public List <BankAccountSearchModel> GetBankAccountList(BankAccountSearchModel model) { ShomaRMEntities db = new ShomaRMEntities(); List <BankAccountSearchModel> lstBAL = new List <BankAccountSearchModel>(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetBankAccountPaginationAndSearchData"; cmd.CommandType = CommandType.StoredProcedure; DbParameter param0 = cmd.CreateParameter(); param0.ParameterName = "Filter"; param0.Value = model.Filter; cmd.Parameters.Add(param0); DbParameter param1 = cmd.CreateParameter(); param1.ParameterName = "Criteria"; param1.Value = string.IsNullOrEmpty(model.Criteria) ? "" : model.Criteria; cmd.Parameters.Add(param1); DbParameter param3 = cmd.CreateParameter(); param3.ParameterName = "PageNumber"; param3.Value = model.PageNumber; cmd.Parameters.Add(param3); DbParameter param4 = cmd.CreateParameter(); param4.ParameterName = "NumberOfRows"; param4.Value = model.NumberOfRows; cmd.Parameters.Add(param4); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } foreach (DataRow dr in dtTable.Rows) { BankAccountSearchModel searchmodel = new BankAccountSearchModel(); searchmodel.BAID = Convert.ToInt32(dr["BAID"].ToString()); searchmodel.Bank_Name = dr["Bank_Name"].ToString(); searchmodel.Account_Number = dr["Account_Number"].ToString(); searchmodel.Account_TypeText = dr["Account_Type"].ToString(); lstBAL.Add(searchmodel); } db.Dispose(); return(lstBAL.ToList()); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }
public int BuildPaganationBankAccountList(BankAccountSearchModel model) { int NOP = 0; ShomaRMEntities db = new ShomaRMEntities(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetBankAccountPaginationAndSearchData"; cmd.CommandType = CommandType.StoredProcedure; DbParameter param0 = cmd.CreateParameter(); param0.ParameterName = "Filter"; param0.Value = model.Filter; cmd.Parameters.Add(param0); DbParameter param1 = cmd.CreateParameter(); param1.ParameterName = "Criteria"; param1.Value = string.IsNullOrEmpty(model.Criteria) ? "" : model.Criteria; cmd.Parameters.Add(param1); DbParameter param3 = cmd.CreateParameter(); param3.ParameterName = "PageNumber"; param3.Value = model.PageNumber; cmd.Parameters.Add(param3); DbParameter param4 = cmd.CreateParameter(); param4.ParameterName = "NumberOfRows"; param4.Value = model.NumberOfRows; cmd.Parameters.Add(param4); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } if (dtTable.Rows.Count > 0) { NOP = int.Parse(dtTable.Rows[0]["NumberOfPages"].ToString()); } db.Dispose(); return(NOP); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }