public DataSet GetGridViewData(LDMFunSchema objLDMFuncSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Districtid", SqlDbType.Int);
param[0].Value = objLDMFuncSchema.Districtid;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "GetGridViewData", param))
{
return(ds);
}
}
catch (Exception)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
//Ldm Application Form
public DataSet GetApplicationForm(LDMFunSchema objLDMFuncSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Status", SqlDbType.VarChar);
param[0].Value = objLDMFuncSchema.Status;
param[1] = new SqlParameter("@ApplicationID", SqlDbType.VarChar);
param[1].Value = objLDMFuncSchema.ApplicationID;
param[2] = new SqlParameter("@ActionType", SqlDbType.VarChar);
param[2].Value = objLDMFuncSchema.ActionType;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "getFormApplicationDetails"))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet GetSocialCategoryViewReport(LDMFunSchema objLDMFuncSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Districtid", SqlDbType.Int);
param[0].Value = objLDMFuncSchema.Districtid;
param[1] = new SqlParameter("@ShiLoanCategory", SqlDbType.VarChar);
param[1].Value = objLDMFuncSchema.ShiLoanCategory;
param[2] = new SqlParameter("@KisLoanCategory", SqlDbType.VarChar);
param[2].Value = objLDMFuncSchema.KisLoanCategory;
param[3] = new SqlParameter("@TarLoanCategory", SqlDbType.VarChar);
param[3].Value = objLDMFuncSchema.TarLoanCategory;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "rep_CategoryLevelReport", param))
{
return(ds);
}
}
catch (Exception)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet SearchSocialCategoryGridData(string searchTxt, LDMFunSchema objLDMFuncSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[2];
//{
// new SqlParameter("@BankName", searchTxt == null ? (object)DBNull.Value :searchTxt),
//};
param[0] = new SqlParameter("@Districtid", SqlDbType.Int);
param[0].Value = objLDMFuncSchema.Districtid;
param[1] = new SqlParameter("@CategoryName", SqlDbType.VarChar);
param[1].Value = searchTxt == null ? (object)DBNull.Value : searchTxt;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "GetSearchCategoryGridData", param))
{
return(ds);
}
}
catch (Exception)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public static List <Data> GetBestFiveBanks()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
LDMFunSchema objLDMFunSchema = new LDMFunSchema();
LDMFunBAL objLDMFunBAL = new LDMFunBAL();
objLDMFunSchema.Districtid = Convert.ToInt32(ddnm_static);
ds = objLDMFunBAL.GetTopBestBank(objLDMFunSchema);
dt = ds.Tables[0];
List <Data> dataList = new List <Data>();
string cat = "";
int val = 0;
foreach (DataRow dr in dt.Rows)
{
cat = dr[0].ToString();
val = Convert.ToInt32(dr[1]);
dataList.Add(new Data(cat, val));
}
//string str = Newtonsoft.Json.JsonConvert.SerializeObject(ds.Tables[0]);
//JavaScriptSerializer json_serializer = new JavaScriptSerializer();
//string bankdata = JsonConvert.DeserializeObject(str.ToString()).ToString();
return(dataList);
}
//Search District
public DataSet SearchDistrictGridData(string searchTxt, LDMFunSchema objLDMFuncSchema)
{
try
{
ds = objLDMFunDL.SearchDistrictGridData(searchTxt, objLDMFuncSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
//Ldm Application Form
public DataSet GetApplicationForm(LDMFunSchema objLDMFuncSchema)
{
try
{
ds = objLDMFunDL.GetApplicationForm(objLDMFuncSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
public DataSet GetLDMContentTarun(LDMFunSchema objLDMFuncSchema)
{
try
{
ds = objLDMFunDL.GetLDMContentTarun(objLDMFuncSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
public DataSet GetGridViewData(LDMFunSchema objLDMFuncSchema)
{
try
{
ds = objLDMFunDL.GetGridViewData(objLDMFuncSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
//Best Five District Performance
public DataSet GetTopBestDistrict(LDMFunSchema objLDMFuncSchema)
{
try
{
ds = objLDMFunDL.GetTopBestDistrict(objLDMFuncSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
//Report SocialCategory
public DataSet GetSocialCategoryViewReport(LDMFunSchema objLDMFuncSchema)
{
try
{
ds = objLDMFunDL.GetSocialCategoryViewReport(objLDMFuncSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
public DataSet LDMInsert(LDMFunSchema objLDMFuncSchema)
{
try
{
ds = objLDMFunDL.LDM_Insert(objLDMFuncSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
public DataSet GetBankName(LDMFunSchema objLDMFunSchema)
{
try
{
ds = objLDMFunDL.GetBankName(objLDMFunSchema);
return(ds);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
}
}
public static List <Data> GetBestFiveDistrict()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
LDMFunSchema objLDMFunSchema = new LDMFunSchema();
LDMFunBAL objLDMFunBAL = new LDMFunBAL();
objLDMFunSchema.Districtid = Convert.ToInt32(ddnm_static_District);
ds = objLDMFunBAL.GetTopBestDistrict(objLDMFunSchema);
dt = ds.Tables[0];
List <Data> dataListDist = new List <Data>();
string cat = "";
int val = 0;
foreach (DataRow dr in dt.Rows)
{
cat = dr[0].ToString();
val = Convert.ToInt32(dr[1]);
dataListDist.Add(new Data(cat, val));
}
return(dataListDist);
}
public static List <Data> GetBestFiveBank()
{
//SqlConnection conn = new SqlConnection(@"Data Source=123.108.51.115,21443;Initial Catalog=PMMY;User ID=mahaadmin;Password=Admin@123");
//DataSet ds = new DataSet();
//DataTable dt = new DataTable();
//conn.Open();
////var ddnm = Session["LDM_DistrictId"];
//string cmdstr = "select distinct top 5 ph.BankName, sum(LoanAmntOutStanding) 'Amount' from Ph_Sec_Excel ph join tblBankMaster b on b.BankName = ph.BankName where ph.DistrictId = "+ ddnm +" group by ph.BankName order by Amount desc";
//SqlCommand cmd = new SqlCommand(cmdstr, conn);
//SqlDataAdapter adp = new SqlDataAdapter(cmd);
//adp.Fill(ds);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
LDMFunSchema objLDMFunSchema = new LDMFunSchema();
LDMFunBAL objLDMFunBAL = new LDMFunBAL();
//var ddnm = Session["LDM_DistrictId"];
//objLDMFunSchema.Districtid = Convert.ToInt32(hdn_ddnm.Value);
objLDMFunSchema.Districtid = Convert.ToInt32(ddnm_static);
ds = objLDMFunBAL.GetTopBestBank(objLDMFunSchema);
dt = ds.Tables[0];
List <Data> dataList = new List <Data>();
string cat = "";
int val = 0;
foreach (DataRow dr in dt.Rows)
{
cat = dr[0].ToString();
val = Convert.ToInt32(dr[1]);
//dataList.Add(new Data(cat, val));
dataList.Add(new Data(cat, val));
}
//string str = Newtonsoft.Json.JsonConvert.SerializeObject(ds.Tables[0]);
//JavaScriptSerializer json_serializer = new JavaScriptSerializer();
//string bankdata = JsonConvert.DeserializeObject(str.ToString()).ToString();
return(dataList);
}
public DataSet LDM_Insert(LDMFunSchema objLDMFuncSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[]
{
//new SqlParameter("@Sr_No", objLDMFuncSchema.Sr_No == 0 ? 0 : objLDMFuncSchema.Sr_No),
new SqlParameter("@BankName", objLDMFuncSchema.BankName == null ? (object)DBNull.Value :objLDMFuncSchema.BankName),
new SqlParameter("@BankBranch", objLDMFuncSchema.BankBranch == null ? (object)DBNull.Value :objLDMFuncSchema.BankBranch),
new SqlParameter("@IFSCCode", objLDMFuncSchema.IFSCCode == null ? (object)DBNull.Value :objLDMFuncSchema.IFSCCode),
new SqlParameter("@App_Reg", objLDMFuncSchema.App_Reg == null ? (object)DBNull.Value :objLDMFuncSchema.App_Reg),
new SqlParameter("@Loan_Category", objLDMFuncSchema.Loan_Category == null ? (object)DBNull.Value :objLDMFuncSchema.Loan_Category),
new SqlParameter("@FirstName", objLDMFuncSchema.FirstName == null ? (object)DBNull.Value :objLDMFuncSchema.FirstName),
new SqlParameter("@MiddleName", objLDMFuncSchema.MiddleName == null ? (object)DBNull.Value :objLDMFuncSchema.MiddleName),
new SqlParameter("@LastName", objLDMFuncSchema.LastName == null ? (object)DBNull.Value :objLDMFuncSchema.LastName),
new SqlParameter("@Gender", objLDMFuncSchema.Gender == null ? (object)DBNull.Value :objLDMFuncSchema.Gender),
new SqlParameter("@MaritalStatus", objLDMFuncSchema.MaritalStatus == null ? (object)DBNull.Value :objLDMFuncSchema.MaritalStatus),
new SqlParameter("@Dob", objLDMFuncSchema.Dob == null ? (object)DBNull.Value :objLDMFuncSchema.Dob),
new SqlParameter("@Village", objLDMFuncSchema.Village == null ? (object)DBNull.Value :objLDMFuncSchema.Village),
new SqlParameter("@Gram", objLDMFuncSchema.Gram == null ? (object)DBNull.Value :objLDMFuncSchema.Gram),
new SqlParameter("@Tehsil", objLDMFuncSchema.Tehsil == null ? (object)DBNull.Value :objLDMFuncSchema.Tehsil),
new SqlParameter("@Block", objLDMFuncSchema.Block == null ? (object)DBNull.Value :objLDMFuncSchema.Block),
new SqlParameter("@District", objLDMFuncSchema.District == null ? (object)DBNull.Value :objLDMFuncSchema.District),
new SqlParameter("@Religion", objLDMFuncSchema.Religion == null ? (object)DBNull.Value :objLDMFuncSchema.Religion),
new SqlParameter("@Minority_Comm", objLDMFuncSchema.Minority_Comm == null ? (object)DBNull.Value :objLDMFuncSchema.Minority_Comm),
new SqlParameter("@Social_Category", objLDMFuncSchema.Social_Category == null ? (object)DBNull.Value :objLDMFuncSchema.Social_Category),
new SqlParameter("@Aadhar", objLDMFuncSchema.Aadhar == null ? (object)DBNull.Value :objLDMFuncSchema.Aadhar),
new SqlParameter("@PAN", objLDMFuncSchema.PAN == null ? (object)DBNull.Value :objLDMFuncSchema.PAN),
new SqlParameter("@Mobile", objLDMFuncSchema.Mobile == null ? (object)DBNull.Value :objLDMFuncSchema.Mobile),
new SqlParameter("@Email", objLDMFuncSchema.Email == null ? (object)DBNull.Value :objLDMFuncSchema.Email),
new SqlParameter("@ReqLoanAmnt", objLDMFuncSchema.ReqLoanAmnt == 0 ? 0 : objLDMFuncSchema.ReqLoanAmnt),
new SqlParameter("@SanctionAmnt", objLDMFuncSchema.SanctionAmnt == 0 ? 0 :objLDMFuncSchema.SanctionAmnt),
new SqlParameter("@SanctionDate", objLDMFuncSchema.SanctionDate == null ? (object)DBNull.Value :objLDMFuncSchema.SanctionDate),
new SqlParameter("@Business_Activity", objLDMFuncSchema.Business_Activity == null ? (object)DBNull.Value :objLDMFuncSchema.Business_Activity),
new SqlParameter("@Type_Loan", objLDMFuncSchema.Type_Loan == null ? (object)DBNull.Value :objLDMFuncSchema.Type_Loan),
new SqlParameter("@DisbursedAmnt", objLDMFuncSchema.DisbursedAmnt == 0 ? 0 :objLDMFuncSchema.DisbursedAmnt),
new SqlParameter("@DisburseDate", objLDMFuncSchema.DisburseDate == null ? (object)DBNull.Value :objLDMFuncSchema.DisburseDate),
new SqlParameter("@LoanAmntOutStanding", objLDMFuncSchema.LoanAmntOutStanding == 0 ? 0 :objLDMFuncSchema.LoanAmntOutStanding),
new SqlParameter("@AnualTarget", objLDMFuncSchema.AnualTarget == 0 ? 0 : objLDMFuncSchema.AnualTarget),
new SqlParameter("@Districtid", objLDMFuncSchema.Districtid == 0 ? 0 :objLDMFuncSchema.Districtid),
new SqlParameter("@BankId", objLDMFuncSchema.BankId == 0 ? 0 :objLDMFuncSchema.BankId),
new SqlParameter("@CategoryId", objLDMFuncSchema.CategoryId == 0 ? 0 :objLDMFuncSchema.CategoryId),
new SqlParameter("@InsertDate", objLDMFuncSchema.InsertDate == null ? (object)DBNull.Value :objLDMFuncSchema.InsertDate),
new SqlParameter("@InsertedBy", objLDMFuncSchema.InsertedBy == null ? (object)DBNull.Value : objLDMFuncSchema.InsertedBy),
};
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "usp_ReadDataInsert", param))
{
return(ds);
}
}
catch (Exception)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
