public int BuildPaganationCashReceiptList(CashReceiptSearchModel 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_GetCashReceiptPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param0 = cmd.CreateParameter();
param0.ParameterName = "FromDate";
param0.Value = model.FromDate;
cmd.Parameters.Add(param0);
DbParameter param1 = cmd.CreateParameter();
param1.ParameterName = "ToDate";
param1.Value = model.ToDate;
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;
}
}
public List <CashReceiptSearchModel> FillCashReceiptSearchGrid(CashReceiptSearchModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
List <CashReceiptSearchModel> lstCashReceipt = new List <CashReceiptSearchModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetCashReceiptPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param0 = cmd.CreateParameter();
param0.ParameterName = "FromDate";
param0.Value = model.FromDate;
cmd.Parameters.Add(param0);
DbParameter param1 = cmd.CreateParameter();
param1.ParameterName = "ToDate";
param1.Value = model.ToDate;
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)
{
CashReceiptSearchModel searchmodel = new CashReceiptSearchModel();
searchmodel.CRID = Convert.ToInt32(dr["CRID"].ToString());
searchmodel.PropertyTitle = dr["PropertyID"].ToString();
searchmodel.UnitName = dr["UnitID"].ToString();
searchmodel.TenantName = dr["TenantID"].ToString();
searchmodel.Revision_Num = dr["Revision_Num"].ToString();
searchmodel.Status = dr["Status"].ToString();
searchmodel.Batch = dr["Batch"].ToString();
searchmodel.Description = dr["Description"].ToString();
searchmodel.Balance = Convert.ToDecimal(dr["Balance"].ToString());
searchmodel.PrePayment = Convert.ToDecimal(dr["PrePayment"].ToString());
searchmodel.PaymentAmount = Convert.ToDecimal(dr["PaymentAmount"].ToString());
searchmodel.CheckNumber = dr["CheckNumber"].ToString();
searchmodel.PaymentDate = dr["PaymentDate"].ToString();
searchmodel.PaymentType = dr["PaymentType"].ToString();
searchmodel.BankAccount = dr["BankAccount"].ToString();
searchmodel.DateStamp = dr["DateStamp"].ToString();
searchmodel.DepositAcctDate = dr["DepositAcctDate"].ToString();
lstCashReceipt.Add(searchmodel);
}
db.Dispose();
return(lstCashReceipt.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
