. Net jobs

function sortTable() {     var table = document.getElementById('tblGetRate');     var rowLength = table.rows.length;     var rateValue = [];     for (var i = 0; i < rowLength; i += 1) {         var row = table.rows[i];         if ($(row).has("td.rate").length > 0) {             rateValue.push([$(row).find("td").eq(4).html().replace('$', '').trim(), row]);         }     }     rateValue.sort(function (a, b) { return b[0] - a[0] });     for (var i = 0; i < rateValue.length; i++) {         $(rateValue[i][1]).remove();         $('#tblGetRate').prepend(rateValue[i][1]);     } }

@model MvcApplication30.Models.PagedStudentModel @{     ViewBag.Title = "WebGrid CRUD Operations";     WebGrid grid = new WebGrid(rowsPerPage: Model.PageSize);     grid.Bind(Model.It_Student,               autoSortAndPage: false,               rowCount: Model.TotalRows     ); } Add New Student @grid.GetHtml( htmlAttributes: new { id = "grid" },     fillEmptyRows: false,     mode: WebGridPagerModes.All,     firstText: "<< First",     previousText: "< Prev",     nextText: "Next >",     lastText: "Last >>",      columns: new[] {                 grid.Column("StudentID",                     header: "ID", canSort: true),         grid.Column(header: "Stu...

  function CreateContryDropdown(countryList) {         debugger;         var result = " ";         if (countryList.length > 0) {             for (var index = 0; index < countryList.length; index++) {                 result += " " + countryList[index].Name + " ";             }                   }         result += " ";        return result;     } ---------------------- function CreateHazPKGListType(selectedVal) {     debugger;     var result = " ";     if (selectedVal != "") {         result += " --Select-- ";     } else {         result += " --Select-- ";     }     if (hazPKGList.length > 0) {  ...

var markers = []; var map = ''; function ShowTrack(address) {     markers = [];     debugger;     var lst = address.split('~');     GetMarkers(address);     {         if (lst.length > 1) {             var mapOptions = {                 center: new google.maps.LatLng(markers[0].lat, markers[0].lng),                 zoom: 10,                 mapTypeId: google.maps.MapTypeId.ROADMAP             };             map = new google.maps.Map(document.getElementById("dvMap"), mapOptions);             var lat_lng = new Array();             var latlng = [];             var myLatlng = [];       ...

   private KDLModel.RateShop Rate(RateShopLoadML rateShop)         {             KDLModel.RateShop rate = new KDLModel.RateShop();             Uri InitUrl = new Uri("https://webservices.averittexpress.com/LTLRateQuoteService");             System.Xml.XmlNodeList xmlList = null;             RateShop.RateShopBAL rateShopBAL = new RateShop.RateShopBAL();             try             {                 CarrierUserML carrierUser = new RateShop.RateShopBAL().GetIndividualUserByCarrier(rateShop.CarrierId, rateShop.userCarriers); // Carrier Markup                 #region Authentication                 CarrierUserML cUser = new CarrierUserML();     ...

Get data of Restful Service (URL)    public List TrackByPRONumber(string PRONumber)         {             string URL = "http://works.pittohio.com/mypittohio/pbetrace2.asp?pronumber=";             List list = new List ();             try             {                 WebRequest request = WebRequest.Create(URL + PRONumber + "&all=yes");                 HttpWebResponse response = (HttpWebResponse)request.GetResponse();                 Stream dataStream = response.GetResponseStream();                 StreamReader reader = new StreamReader(dataStream);                 var pittOhioTrackResponse = XDocument.Parse(reader.Read...

You should have schema of request like below   private string CreateXMLRequestGetAvailableImages(string ProNumber)         {             string XMLRequest = string.Empty;             XMLRequest = @"                                                 xmlns:xsd=""http://www.w3.org/2001/XMLSchema""                                 xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">                                             Progressp                         Edward42                 ...

http://stackoverflow.com/questions/8517071/send-json-data-via-post-ajax-and-receive-json-response-from-controller-mvc

 public String ReplaceWholeWord(String s, String word, String bywhat)         {             char firstLetter = word[0];             StringBuilder sb = new StringBuilder();             bool previousWasLetterOrDigit = false;             int i = 0;             s = s + " ";             while (i < s.Length - word.Length + 1)             {                 char ch = '~';                 if (!string.IsNullOrEmpty(Convert.ToStr...

--EXEC [SearchProcedure] '835_FinancialInformation' --EXEC sp_depends [835_FinancialInformation] DECLARE @SearchStr NvarChar(100) SELECT @SearchStr = 'Missing/incomplete/invalid upgrade' CREATE TABLE #Results ( ColumnName nvarchar(370),ColumnValue nvarchar(3630) ) SET NOCOUNT ON DECLARE @TableName NvarChar(256), @ColumnName NvarChar(128),@SearchStr2 NvarChar(110) SET @TableName = '' SET @SearchStr2 = QuoteName('%' + @SearchStr + '%','''') WHILE @TableName Is Not Null BEGIN SET @ColumnName = '' SET @TableName = ( SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName AND OBJECTPROPERTY( OBJECT_ID( QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) ), 'IsMSShipped' ...

---------Using Sub Query 3rd Highest Salary All Employees--------- SELECT * FROM Emp WHERE Salary IN( SELECT TOP 1   salary FROM ( SELECT TOP 3 salary FROM Emp e ORDER BY Salary DESC ) a ORDER BY a.Salary ) ------------------- 3rd highest salary----------- -----3rd Hightest salary---------- DECLARE @n INT=3 SELECT DISTINCT(Salary) from emp e1 where @n=( SELECT COUNT(DISTINCT(salary))  from emp e2 where  e2.salary>=e1.salary ) --------------3rd Highest Salary-----------  ;WITH cte AS  (      SELECT Id,Name,e.Salary, DENSE_RANK() OVER (PARTITION BY e.Salary ORDER BY e.Salary) AS sal      FROM Emp e  )  SELECT *  FROM cte WHERE sal=2 ----------------------- DECLARE @N int SET @N = 3  -- Change the value here to pick a different salary rank SELECT Salary FROM (     SELECT row_number() OVER (ORDER BY Salary DESC) as SalaryRank, Salary     FROM Emp e ) as SalaryCTE WHERE...

         var query = (from employees in _dsSecurity.Employees.AsEnumerable()                                  join empSites in _dtEmployeesSite                                      on employees.EmployeeId equals empSites.EmployeeId                                  join empFilter in _dtScheduleProviders.AsEnumerable()                       ...

ALTER FUNCTION [dbo].[ConvertToClientLocalTime] (     -- Add the parameters for the function here      @Time DATETIME     ,@TimeZone NVARCHAR(100) ) RETURNS DATETIME AS BEGIN     -- Declare the return variable here     DECLARE @LocalDate DATETIME     SELECT         @LocalDate =             CASE WHEN @Time IS NULL OR @Time = '' THEN NULL                  ELSE dbo.ConvertToClientTime(@Time, @TimeZone)             END     -- Return the result of the function     RETURN @LocalDate; END ------------------------------Below function called inside above----- ALTER FUNCTION [dbo].[ConvertToClientTime](@time [datetime], @timeZone [nvarchar](100)) RETURNS [datetime] --WITH EXECUTE AS CALLER ...

ALTER FUNCTION [dbo].[ConvertStringToNumeric] (@Value text) RETURNS NUMERIC(12,2) AS     BEGIN                 declare @string varchar(max)             SET @string = CONVERT(VARCHAR(MAX), @Value)             --set @string='abc93.3ad4'             DECLARE @IncorrectCharLoc SMALLINT             SET @IncorrectCharLoc = PATINDEX('%[^0-9.-]%', @string)             WHILE @IncorrectCharLoc > 0             BEGIN             SET @string = STUFF(@string, @IncorrectCharLoc, 1, '')             SET @IncorrectCharLoc = PATINDEX('%[^0-9.-]%', @string)     ...

ALTER FUNCTION [dbo].[ConvertLocalToUTC](@time [datetime],@timeZoneAdj  Int, @IsDayLightSavings Bit) RETURNS [datetime] --WITH EXECUTE AS CALLER AS BEGIN --EXTERNAL NAME [Mmt.Cyramed.Cryptography].[Mmt.Cyramed.Cryptography.Cryptography].[ConvertLocalToUTC] RETURN dbo.[GetPracticeUTCDateTime](@time,@timeZoneAdj,@IsDayLightSavings) END --------------Below function is called inside above----------- ALTER  FUNCTION  [dbo].[GetPracticeUTCDateTime] (     @InLocaleDateTime DATETIME,     @TimeZoneAdj INT,     @IsDayLightSaving BIT ) RETURNS DateTime AS BEGIN     DECLARE @OutLocalDateTime DATETIME            set @outLocalDateTime = dateadd(MINUTE , -1 * @TimeZoneAdj, @inLocaleDateTime)         if (@IsDayLightSaving = 1) -- figure in daylight savings time        BEGIN        declare @yearT...

ALTER FUNCTION [dbo].[Split](@String nvarchar(max), @Delimiter char(1))            returns @temptable TABLE (items nvarchar(max))   as        begin                declare @index int                declare @slice varchar(8000)                           select @index = 1                    if len(@String)                    while @index!= 0                begin                ...

ALTER function [dbo].[SplitWordList] (  @list varchar(MAX) ) returns @t table  (  Word varchar(50) not null,  Position int identity(1,1) not null ) as begin   declare      @pos int,     @lpos int,     @item varchar(100),     @ignore varchar(100),     @dl int,     @a1 int,     @a2 int,     @z1 int,     @z2 int,     @n1 int,     @n2 int, @n3 int,   @c varchar(1),     @a smallint   select      @a1 = ascii('a'),     @a2 = ascii('A'),     @z1 = ascii('z'),     @z2 = ascii('Z'),     @n1 = ascii('0'),     @n2 = ascii('9'), @n3 = ascii('-') set @ignore = '''"'   set @pos ...

ALTER FUNCTION [dbo].[udf_StringToTable] (       @list NVARCHAR(MAX) ,       @delimiter NCHAR(1) = ',' --Defaults to CSV ) RETURNS @tableList TABLE ( value nvarchar(MAX) ) AS BEGIN     DECLARE @value NVARCHAR(MAX)     DECLARE @position INT     SET @list = LTRIM(RTRIM(@list))+ ','     SET @position = CHARINDEX(@delimiter, @list, 1)     IF REPLACE(@list, @delimiter, '') <> ''     BEGIN         WHILE @position > 0         BEGIN             SET @value = LTRIM(RTRIM(LEFT(@list, @position - 1)))             IF @value <> ''             BEGIN                 INSERT INTO @tableList (value)   ...

ALTER FUNCTION [dbo].[splitstring] (@stringToSplit VARCHAR(MAX)) RETURNS @returnList TABLE ([Name] [nvarchar](500)) AS BEGIN     DECLARE @name NVARCHAR(255)     DECLARE @pos INT     WHILE CHARINDEX(',', @stringToSplit) > 0     BEGIN         SELECT @pos = CHARINDEX(',', @stringToSplit)         SELECT @name = SUBSTRING(@stringToSplit, 1, @pos - 1)         INSERT INTO @returnList         SELECT @name         SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos + 1, LEN(@stringToSplit) - @pos)     END     INSERT INTO @returnList     SELECT @stringToSplit     RETURN END

ALTER FUNCTION [dbo].[udf_GetPhoneSSNFormat] (     -- Add the parameters for the function here     @TypeId        INT,     @DataValue    NVARCHAR(MAX) ) RETURNS NVARCHAR(MAX) AS BEGIN     DECLARE @FormattedValue    NVARCHAR(MAX)     SET @FormattedValue = ''     -- Will Remove all white spaces, brackets, hyphens     DECLARE @OriginalValue    NVARCHAR(MAX)     SET @OriginalValue = ISNULL(REPLACE(REPLACE(REPLACE(REPLACE(@DataValue,'(',''),')',''),'-',''),' ',''),'')         -- Type Id : 1 For Phone #     -- Type Id : 2 For SSN #     IF @TypeId = 1         BEGIN             SELECT @FormattedValue =              ...