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));
}
}
