public List <WSMahitiKhanaja> SelfEmployment()
{
WSMahitiKhanaja AR = new WSMahitiKhanaja();
List <WSMahitiKhanaja> ARApplication = new List <WSMahitiKhanaja>();
try
{
using (SqlConnection kvdConn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("spMahitiKanajaData", kvdConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MethodName", "SE");
kvdConn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
AR.ApplicationNumber = rdr["ApplicationNumber"].ToString();
AR.ApplicantName = rdr["ApplicantName"].ToString();
AR.LoanNumber = rdr["ApprovedApplicationNum"].ToString();
AR.District = rdr["ParDistrict"].ToString();
AR.Taluk = rdr["ParTaluk"].ToString();
AR.Constituency = rdr["ParConstituency"].ToString();
AR.FinancialYear = rdr["FinancialYear"].ToString();
ARApplication.Add(AR);
}
}
return(ARApplication);
}
}
catch
{
return(ARApplication);
}
}
public IHttpActionResult Arivu(string Scheme, string District = "", string DistrictCode = "", string Taluk = "", string FinancialYear = "", string ApplicationNumber = "")
{
List <WSMahitiKhanaja> ARApplication = new List <WSMahitiKhanaja>();
try
{
using (SqlConnection kvdConn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("spMahitiKanajaData", kvdConn))
{
cmd.CommandType = CommandType.StoredProcedure;
if (Scheme.ToUpper() == "AR")
{
cmd.Parameters.AddWithValue("@scheme", "AR");
}
else if (Scheme.ToUpper() == "SE")
{
cmd.Parameters.AddWithValue("@scheme", "SE");
}
if (District != "")
{
cmd.Parameters.AddWithValue("@District", District);
}
if (Taluk != "")
{
cmd.Parameters.AddWithValue("@Taluk", Taluk);
}
if (FinancialYear != "")
{
cmd.Parameters.AddWithValue("@FinancialYear", FinancialYear);
}
if (ApplicationNumber != "")
{
cmd.Parameters.AddWithValue("@ApplicationNumber", ApplicationNumber);
}
if (DistrictCode != "")
{
cmd.Parameters.AddWithValue("@DistrictCode", DistrictCode);
}
kvdConn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
WSMahitiKhanaja AR = new WSMahitiKhanaja();
AR.ApplicationNumber = rdr["ApplicationNumber"].ToString();
AR.ApplicantName = rdr["ApplicantName"].ToString();
AR.LoanNumber = rdr["ApprovedApplicationNum"].ToString();
AR.District = rdr["District"].ToString();
AR.Taluk = rdr["ParTaluk"].ToString();
AR.Constituency = rdr["ParConstituency"].ToString();
AR.FinancialYear = rdr["FinancialYear"].ToString();
ARApplication.Add(AR);
}
}
return(Ok(ARApplication));
}
}
catch
{
return(Ok(ARApplication));
}
}
