Osama Bin Gandhi Posted May 21, 2014 Report Posted May 21, 2014 Yes sir not being off the topic ...But question to .net dev's Can we call a webservice(asp.net traditional webservice) from a sql stored proc?
dotnetrockz Posted May 21, 2014 Report Posted May 21, 2014 Yes sir thats cool....actually i meant to ask a question just like a quiz but u came up with a solution...maa daantlo kuda oka proc lo use chesaru....but i couldn't get to look into the caller(webservice call) proc....
Suhaas Posted May 21, 2014 Report Posted May 21, 2014 thats cool....actually i meant to ask a question just like a quiz but u came up with a solution...maa daantlo kuda oka proc lo use chesaru....but i couldn't get to look into the caller(webservice call) proc.... deniki use chestharu mi org lo?....ippudu clr dll okati SQL meedha host chesi dani ninchi webservice call invoke cheyyatam better kada....stored proc ninchi service call cheyyatam kante... it's possible yes but...is that the right way to go?....aa user ki access ivvali...and under that identity aa sql server service acc.... server meedha vere emaina invoke chese authority untundi kada...security risk avthundemo kada...
dotnetrockz Posted May 21, 2014 Report Posted May 21, 2014 This is a code i wrote to access sharepoint lists from a asp.net web page...i used jquery.... to run this u need to have sharepoint installed and knwledge of sharepoint lists9its easy to create them). knowledge of caml queriesused to query sharepoint data...i used CAMLQuerybuilder a free tool vailable on internet to do this...it constructs query based on ur input. purpose:most offices use sharepoint to post updates this may be regarding an app failure during peak times...and then user keeps on turning in tickets until he comes to know the system is catually down....so to actually show the user that particular fetaure is down when he enters teh tciketing system....the tciketening system reads data from this sharepoint lis... advatnages...reduces coding of dotnet webpages...(sharepoint lists are easy to create ) i used the refrence of jquery spservices lbrary(google it) query part: var query = "<Query>" + "<Where>" + "<And>" + "<Eq>" + "<FieldRef Name=\"SupportGroup\" />" + "<Value Type=\"Text\">" + supportgroup + "</Value>" + "</Eq>" + "<And>" + "<Leq>" + "<FieldRef Name=\"Begin_x0020_Date\" />" + "<Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">" + dt + "</Value>" + "</Leq>" + "<Geq>" + "<FieldRef Name=\"End_x0020_Date\" />" + "<Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">" + dt + "</Value>" + "</Geq>" + "</And>" + "</And>" + "</Where>" + "<OrderBy>" + "<FieldRef Name=\"End_x0020_Date\" Ascending=\"False\" />" + "</OrderBy>" + "</Query>" This part is to show the data retreievd on a popup.... var liHtml = ''; $().SPServices({ operation: "GetListItems", async: false, webURL: http://serverename/sites/corporate, listName: "Anouncement", CAMLViewFields: "<ViewFields></ViewFields>", CAMLQuery: query, completefunc: function (xData, Status) { var itemCount = $(xData.responseXML).find("[nodeName=rs:data]").attr("ItemCount"); if (itemCount == '0') { frmconfirm.submit(); return true; } else { liHtml += '<p>The following announcement(s) are active for the support group you selected.Please review and click <strong>Cancel</strong> if you dont want to open a ticket or click <strong>Ok</strong> to place a ticket.</p>'; liHtml += '<br/>'; liHtml += '<br/>'; $(xData.responseXML).find("[nodeName='z:row']").each(function () { liHtml += '<fieldset style="display: inline-block;border-color:blue;border-style: solid;">'; //liHtml += '<legend>' + '<h2>' + $(this).attr("ows_Title") + '</h2>' + '</legend>'; liHtml += '<ul>' + '<h2>' + $(this).attr("ows_Title") + '</h2>'; liHtml += '<li><p><strong>BeginDate:</strong>' + dateReviver($(this).attr("ows_Begin_x0020_Date")).toString("M/d/yyyy h:mm") + '</p></li>'; liHtml += '<li><p><strong>Instructions:</strong>' + $(this).attr("ows_Message") + '</p></li>'; liHtml += '</ul>'; liHtml += '</fieldset>'; liHtml += '<hr noshade>'; }); $("#listdata").append(liHtml); $('#divSimplePopup').showModal(); return false; liHtml = ''; } } });
dotnetrockz Posted May 21, 2014 Report Posted May 21, 2014 deniki use chestharu mi org lo?....ippudu clr dll okati SQL meedha host chesi dani ninchi webservice call invoke cheyyatam better kada....stored proc ninchi service call cheyyatam kante... it's possible yes but...is that the right way to go?....aa user ki access ivvali...and under that identity aa sql server service acc.... server meedha vere emaina invoke chese authority untundi kada...security risk avthundemo kada... a call to the service to get the the current events for a particular shipment...a job runs daily for a certain period of time and updates the event statuses.....
Suhaas Posted May 21, 2014 Report Posted May 21, 2014 a call to the service to get the the current events for a particular shipment...a job runs daily for a certain period of time and updates the event statuses..... Ok.
Suhaas Posted May 21, 2014 Report Posted May 21, 2014 This is a code i wrote to access sharepoint lists from a asp.net web page...i used jquery.... to run this u need to have sharepoint installed and knwledge of sharepoint lists9its easy to create them). knowledge of caml queriesused to query sharepoint data...i used CAMLQuerybuilder a free tool vailable on internet to do this...it constructs query based on ur input. purpose:most offices use sharepoint to post updates this may be regarding an app failure during peak times...and then user keeps on turning in tickets until he comes to know the system is catually down....so to actually show the user that particular fetaure is down when he enters teh tciketing system....the tciketening system reads data from this sharepoint lis... advatnages...reduces coding of dotnet webpages...(sharepoint lists are easy to create ) i used the refrence of jquery spservices lbrary(google it) query part: var query = "<Query>" + "<Where>" + "<And>" + "<Eq>" + "<FieldRef Name=\"SupportGroup\" />" + "<Value Type=\"Text\">" + supportgroup + "</Value>" + "</Eq>" + "<And>" + "<Leq>" + "<FieldRef Name=\"Begin_x0020_Date\" />" + "<Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">" + dt + "</Value>" + "</Leq>" + "<Geq>" + "<FieldRef Name=\"End_x0020_Date\" />" + "<Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">" + dt + "</Value>" + "</Geq>" + "</And>" + "</And>" + "</Where>" + "<OrderBy>" + "<FieldRef Name=\"End_x0020_Date\" Ascending=\"False\" />" + "</OrderBy>" + "</Query>" This part is to show the data retreievd on a popup.... var liHtml = ''; $().SPServices({ operation: "GetListItems", async: false, webURL: http://serverename/sites/corporate, listName: "Anouncement", CAMLViewFields: "<ViewFields></ViewFields>", CAMLQuery: query, completefunc: function (xData, Status) { var itemCount = $(xData.responseXML).find("[nodeName=rs:data]").attr("ItemCount"); if (itemCount == '0') { frmconfirm.submit(); return true; } else { liHtml += '<p>The following announcement(s) are active for the support group you selected.Please review and click <strong>Cancel</strong> if you dont want to open a ticket or click <strong>Ok</strong> to place a ticket.</p>'; liHtml += '<br/>'; liHtml += '<br/>'; $(xData.responseXML).find("[nodeName='z:row']").each(function () { liHtml += '<fieldset style="display: inline-block;border-color:blue;border-style: solid;">'; //liHtml += '<legend>' + '<h2>' + $(this).attr("ows_Title") + '</h2>' + '</legend>'; liHtml += '<ul>' + '<h2>' + $(this).attr("ows_Title") + '</h2>'; liHtml += '<li><p><strong>BeginDate:</strong>' + dateReviver($(this).attr("ows_Begin_x0020_Date")).toString("M/d/yyyy h:mm") + '</p></li>'; liHtml += '<li><p><strong>Instructions:</strong>' + $(this).attr("ows_Message") + '</p></li>'; liHtml += '</ul>'; liHtml += '</fieldset>'; liHtml += '<hr noshade>'; }); $("#listdata").append(liHtml); $('#divSimplePopup').showModal(); return false; liHtml = ''; } } }); GP
dotnetrockz Posted May 23, 2014 Report Posted May 23, 2014 mana karna kuda vasthe......discuss cheddamani..... senior developer role lo when ur assigned a project how would you plan on the code level based on design prospects like mvc lo chesthe best aa? or else routine .net aa? inka how do u create individual projects,classes..when we need to create interfaces ilantivi evariana chesara ani telsukundham ani....
Suhaas Posted May 23, 2014 Report Posted May 23, 2014 edaina kotha project kani pedha feature request kani vachinapudu.....na varaki oka high level design create chesi...ideas initial ga ma team ki cheppe vadni....idi na idea....take some time ivvala repu think about it and come up with ideas ani meeting schedule chese vadni.....we used to sit down and discuss....ayinanka high level design modify chesi....finalize chese vallam...we call the finalized high level design Blueprint...after that....tasks assigning and implementation....as time goes blueprint lo changes vasthu untayi with things that show up or with things we didn't think of.....we keep track of how the blueprint changed as the implementation goes....next code review lo dani discuss chese vallam....enduku antha changed....what we missed initially and how we can make a better blueprint next time...
dotnetrockz Posted May 23, 2014 Report Posted May 23, 2014 edaina kotha project kani pedha feature request kani vachinapudu.....na varaki oka high level design create chesi...ideas initial ga ma team ki cheppe vadni....idi na idea....take some time ivvala repu think about it and come up with ideas ani meeting schedule chese vadni.....we used to sit down and discuss....ayinanka high level design modify chesi....finalize chese vallam...we call the finalized high level design Blueprint...after that....tasks assigning and implementation....as time goes blueprint lo changes vasthu untayi with things that show up or with things we didn't think of.....we keep track of how the blueprint changed as the implementation goes....next code review lo dani discuss chese vallam....enduku antha changed....what we missed initially and how we can make a better blueprint next time... gp
Recommended Posts