public void GetSelfEmployment() { try { using (SqlConnection kvdConn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString)) { List <WSSEWebService> SEApplication = new List <WSSEWebService>(); using (SqlCommand cmd = new SqlCommand("spGetSEApplications", kvdConn)) { cmd.CommandType = CommandType.StoredProcedure; kvdConn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { WSSEWebService SE = new WSSEWebService(); SE.ImgPath = rdr["ImgPath"].ToString(); SE.ApplicationNumber = rdr["ApplicationNumber"].ToString(); SE.ApplicantName = rdr["ApplicantName"].ToString(); SE.ApplicantNameNC = rdr["ApplicantNameNC"].ToString(); SE.FatherName = rdr["FatherName"].ToString(); SE.Gender = rdr["Gender"].ToString(); SE.District = rdr["ParDistrict"].ToString(); SE.RDNumber = rdr["RDNumber"].ToString(); SE.MobileNumber = rdr["MobileNumber"].ToString(); SE.AlternateNumber = rdr["AlternateNumber"].ToString(); SE.EmailID = rdr["EmailID"].ToString(); SE.Quota = rdr["Quota"].ToString(); SE.ApprovedAmount = rdr["ApprovedAmount"].ToString(); SE.CaseWorker = rdr["CaseWorker"].ToString(); SE.CWStatus = rdr["CWStatus"].ToString(); SE.DistrictManager = rdr["DistrictManager"].ToString(); SE.DMStatus = rdr["DMStatus"].ToString(); SE.CEO = rdr["CEO"].ToString(); SE.CEOStatus = rdr["CEOStatus"].ToString(); SE.Documentation = rdr["Documentation"].ToString(); SE.DOCStatus = rdr["DOCStatus"].ToString(); SE.ZonalManager = rdr["ZonalManager"].ToString(); SE.ZMStatus = rdr["ZMStatus"].ToString(); SE.ApprovedApplicationNum = rdr["ApprovedApplicationNum"].ToString(); SE.DOB = rdr["DOB"].ToString(); SE.Age = rdr["Age"].ToString(); SE.PWD = rdr["PhysicallyChallenged"].ToString(); SE.Widowed = rdr["Widowed"].ToString(); SE.Divorced = rdr["Divorced"].ToString(); SE.AnualIncome = rdr["AnualIncome"].ToString(); SE.Address = rdr["ParmanentAddress"].ToString(); SE.Constituency = rdr["ParConstituency"].ToString(); SE.Pincode = rdr["ParPincode"].ToString(); SE.AccountNumber = rdr["AccountNumber"].ToString(); SE.BankName = rdr["BankName"].ToString(); SE.Branch = rdr["Branch"].ToString(); SE.IFSCCode = rdr["IFSCCode"].ToString(); SE.BankAddress = rdr["BankAddress"].ToString(); SE.BankDetails = ""; SE.LoanPurpose = rdr["LoanPurpose"].ToString(); SE.ApplicationAppliedDate = rdr["ApplicationAppliedDate"].ToString(); SE.BankUpdate = rdr["BankUpdate"].ToString(); SE.AadhaarNumber = ""; SE.Zone = rdr["ZoneName"].ToString(); SEApplication.Add(SE); } } JavaScriptSerializer js = new JavaScriptSerializer(); js.MaxJsonLength = (Int32.MaxValue);//2147483647 Context.Response.Write(js.Serialize(SEApplication)); //Context.Response.Write(new System.Web.Configuration.ScriptingJsonSerializationSection().MaxJsonLength); } } catch (Exception ex) { WSError ER = new WSError(); ER.ErrorMessage = ex.ToString(); JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(ER)); } }
public WebServer(Namiono namiono, string ident, string hostname, int port) { docRoot = Path.Combine(Environment.CurrentDirectory, ident); provider = namiono; provider.WebRequestHandled += (sender, e) => { var data = Encoding.UTF8.GetBytes(e.Content); Send(ref data, ref e.Context); }; socket = new HTTPSocket(hostname, port); socket.HTTPDataReceived += (sender, e) => { var evtargs = new WSDataReceivedEventArgs(); evtargs.Context = e.context; var path = FileSystem.ResolvePath(e.context.Request.Url.LocalPath, docRoot); if (path.EndsWith(".js", StringComparison.InvariantCultureIgnoreCase) || path.EndsWith(".png", StringComparison.InvariantCultureIgnoreCase) || path.EndsWith(".css", StringComparison.InvariantCultureIgnoreCase) || path.EndsWith(".ico", StringComparison.InvariantCultureIgnoreCase)) { var data = new byte[FileSystem.Size(path)]; var bytesRead = 0; FileSystem.Read(path, ref data, out bytesRead); e.context.Response.StatusCode = 200; e.context.Response.StatusDescription = "OK"; Send(ref data, ref e.context); } else { if (!string.IsNullOrEmpty(e.context.Request.Headers["Needs"])) { var needsHeader = e.context.Request.Headers["Needs"]; if (needsHeader == "shoutcast") { evtargs.Needs = Needs.ShoutCast; } if (needsHeader == "user") { evtargs.Needs = Needs.User; } if (needsHeader == "site") { evtargs.Needs = Needs.Site; } } else { evtargs.Needs = Needs.Nothing; } if (WSDataReceived != null) { WSDataReceived.Invoke(this, evtargs); } } }; socket.HTTPError += (sender, e) => { if (WSError == null) { return; } var evrgs = new WSErrorEventArgs(); evrgs.Exception = e.Exception; WSError.Invoke(this, evrgs); }; }
public void GetArivu() { try { using (SqlConnection kvdConn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString)) { List <WSARWebService> ARApplication = new List <WSARWebService>(); using (SqlCommand cmd = new SqlCommand("spGetARApplications", kvdConn)) { cmd.CommandType = CommandType.StoredProcedure; kvdConn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { WSARWebService AR = new WSARWebService(); AR.ImgPath = rdr["ImgPath"].ToString(); AR.ApplicationNumber = rdr["ApplicationNumber"].ToString(); AR.ApplicantName = rdr["ApplicantName"].ToString(); AR.ApplicantNameNC = rdr["ApplicantNameNC"].ToString(); AR.FatherName = rdr["FatherName"].ToString(); AR.Gender = rdr["Gender"].ToString(); AR.District = rdr["ParDistrict"].ToString(); AR.RDNumber = rdr["RDNumber"].ToString(); AR.MobileNumber = rdr["MobileNumber"].ToString(); AR.AlternateNumber = rdr["AlternateNumber"].ToString(); AR.EmailID = rdr["EmailID"].ToString(); AR.Quota = rdr["Quota"].ToString(); AR.CaseWorker = rdr["CaseWorker"].ToString(); AR.CWStatus = rdr["CWStatus"].ToString(); AR.DistrictManager = rdr["DistrictManager"].ToString(); AR.DMStatus = rdr["DMStatus"].ToString(); AR.CEO = rdr["CEO"].ToString(); AR.CEOStatus = rdr["CEOStatus"].ToString(); AR.Documentation = rdr["Documentation"].ToString(); AR.DOCStatus = rdr["DOCStatus"].ToString(); AR.ZonalManager = rdr["ZonalManager"].ToString(); AR.ZMStatus = rdr["ZMStatus"].ToString(); AR.ApprovedApplicationNum = rdr["ApprovedApplicationNum"].ToString(); AR.DOB = rdr["DOB"].ToString(); AR.Age = rdr["Age"].ToString(); AR.PWD = rdr["PhysicallyChallenged"].ToString(); AR.AnualIncome = rdr["AnualIncome"].ToString(); AR.Address = rdr["ParmanentAddress"].ToString(); AR.Constituency = rdr["ParConstituency"].ToString(); AR.Pincode = rdr["ParPincode"].ToString(); AR.AccountNumber = rdr["AccountNumber"].ToString(); AR.BankName = rdr["BankName"].ToString(); AR.Branch = rdr["Branch"].ToString(); AR.IFSCCode = rdr["IFSCCode"].ToString(); AR.BankAddress = rdr["BankAddress"].ToString(); AR.BankDetails = ""; AR.ApplicationAppliedDate = rdr["ApplicationAppliedDate"].ToString(); AR.BankUpdate = rdr["BankUpdate"].ToString(); AR.AadhaarNumber = ""; AR.Zone = rdr["ZoneName"].ToString(); AR.CETApplicationNum = rdr["CETApplicationNum"].ToString(); AR.CETAdmissionTicateNum = rdr["CETAdmissionTicateNum"].ToString(); AR.CollegeName = rdr["CollegeName"].ToString(); AR.Course = rdr["Course"].ToString(); AR.PrevYearMarks = rdr["PrevYearMarks"].ToString(); AR.ClgHostel = rdr["ClgHostel"].ToString(); AR.CurrentYear = rdr["CurrentYear"].ToString(); AR.Year1Loan = rdr["Year1Loan"].ToString(); AR.Year2Loan = rdr["Year2Loan"].ToString(); AR.Year3Loan = rdr["Year3Loan"].ToString(); AR.Year4Loan = rdr["Year4Loan"].ToString(); AR.Year5Loan = rdr["Year5Loan"].ToString(); AR.Year6Loan = rdr["Year6Loan"].ToString(); ARApplication.Add(AR); } } JavaScriptSerializer js = new JavaScriptSerializer(); js.MaxJsonLength = (Int32.MaxValue);//2147483647 Context.Response.Write(js.Serialize(ARApplication)); } } catch (Exception ex) { WSError ER = new WSError(); ER.ErrorMessage = ex.ToString(); JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(ER)); } }