public CashReceiptModel GetCashReceiptDetails(int id)
{
ShomaRMEntities db = new ShomaRMEntities();
CashReceiptModel model = new CashReceiptModel();
var getCashRdata = db.tbl_CashReceipts.Where(p => p.CRID == id).FirstOrDefault();
if (getCashRdata != null)
{
model.PropertyID = getCashRdata.PropertyID;
model.UnitID = getCashRdata.UnitID;
model.TenantID = getCashRdata.TenantID;
model.Revision_Num = getCashRdata.Revision_Num;
model.Status = getCashRdata.Status;
model.Batch = getCashRdata.Batch;
model.Description = getCashRdata.Description;
model.Balance = getCashRdata.Balance;
model.PrePayment = getCashRdata.PrePayment;
model.PaymentAmount = getCashRdata.PaymentAmount;
model.CheckNumber = getCashRdata.CheckNumber;
model.PaymentDate = getCashRdata.PaymentDate;
model.PaymentType = getCashRdata.PaymentType;
model.BankAccount = getCashRdata.BankAccount;
model.DateStamp = getCashRdata.DateStamp;
model.IsApplicant = getCashRdata.IsApplicant;
model.DepositAcctDate = getCashRdata.DepositAcctDate;
}
model.CRID = id;
return(model);
}
public List <CashReceiptModel> GetCashReceiptList(DateTime FromDate, DateTime ToDate)
{
ShomaRMEntities db = new ShomaRMEntities();
List <CashReceiptModel> lstpr = new List <CashReceiptModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetCashReceiptList";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramF = cmd.CreateParameter();
paramF.ParameterName = "FromDate";
paramF.Value = FromDate;
cmd.Parameters.Add(paramF);
DbParameter paramC = cmd.CreateParameter();
paramC.ParameterName = "ToDate";
paramC.Value = ToDate;
cmd.Parameters.Add(paramC);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
CashReceiptModel pr = new CashReceiptModel();
DateTime?paymentDate = null;
try
{
paymentDate = Convert.ToDateTime(dr["PaymentDate"].ToString());
}
catch
{
}
DateTime?dateStampString = null;
try
{
dateStampString = Convert.ToDateTime(dr["DateStamp"].ToString());
}
catch
{
}
DateTime?depositAcctDateString = null;
try
{
depositAcctDateString = Convert.ToDateTime(dr["DepositAcctDate"].ToString());
}
catch
{
}
pr.CRID = Convert.ToInt32(dr["CRID"].ToString());
pr.PropertyIDString = dr["PropertyID"].ToString();
pr.UnitIDString = dr["UnitID"].ToString();
pr.TenantIDString = dr["TenantID"].ToString();
pr.Revision_Num = Convert.ToInt32(dr["Revision_Num"].ToString());
pr.Status = Convert.ToInt32(dr["Status"].ToString());
pr.Batch = dr["Batch"].ToString();
pr.Description = dr["Description"].ToString();
pr.Balance = Convert.ToDecimal(dr["Balance"].ToString());
pr.PrePayment = Convert.ToDecimal(dr["PrePayment"].ToString());
pr.PaymentAmount = Convert.ToDecimal(dr["PaymentAmount"].ToString());
pr.CheckNumber = dr["CheckNumber"].ToString();
pr.PaymentDateString = paymentDate == null ? "" : paymentDate.ToString();
pr.PaymentType = dr["PaymentType"].ToString();
pr.BankAccount = dr["BankAccount"].ToString();
pr.DateStampString = dateStampString == null ? "" : dateStampString.ToString();
pr.IsApplicant = Convert.ToInt32(dr["IsApplicant"].ToString());
pr.DepositAcctDateString = depositAcctDateString == null ? "" : depositAcctDateString.ToString();
lstpr.Add(pr);
}
db.Dispose();
return(lstpr.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public string SaveUpdateCashReceipt(CashReceiptModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
string msg = "";
int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0;
if (model.CRID == 0)
{
var saveCashReceipt = new tbl_CashReceipts()
{
PropertyID = model.PropertyID,
UnitID = model.UnitID,
TenantID = model.TenantID,
Revision_Num = model.Revision_Num,
Status = model.Status,
Batch = model.Batch,
Description = model.Description,
Balance = model.Balance,
PrePayment = model.PrePayment,
PaymentAmount = model.PaymentAmount,
CheckNumber = model.CheckNumber,
PaymentDate = model.PaymentDate,
PaymentType = model.PaymentType,
BankAccount = model.BankAccount,
DateStamp = model.DateStamp,
IsApplicant = model.IsApplicant,
DepositAcctDate = model.DepositAcctDate,
UserID = userid,
};
db.tbl_CashReceipts.Add(saveCashReceipt);
db.SaveChanges();
msg = "Cash Receipt Saved Successfully";
}
else
{
var getNOdata = db.tbl_CashReceipts.Where(p => p.CRID == model.CRID).FirstOrDefault();
if (getNOdata != null)
{
getNOdata.PropertyID = model.PropertyID;
getNOdata.PropertyID = model.PropertyID;
getNOdata.UnitID = model.UnitID;
getNOdata.TenantID = model.TenantID;
getNOdata.Revision_Num = model.Revision_Num;
getNOdata.Status = model.Status;
getNOdata.Batch = model.Batch;
getNOdata.Description = model.Description;
getNOdata.Balance = model.Balance;
getNOdata.PrePayment = model.PrePayment;
getNOdata.PaymentAmount = model.PaymentAmount;
getNOdata.CheckNumber = model.CheckNumber;
getNOdata.PaymentDate = model.PaymentDate;
getNOdata.PaymentType = model.PaymentType;
getNOdata.BankAccount = model.BankAccount;
getNOdata.DateStamp = model.DateStamp;
getNOdata.IsApplicant = model.IsApplicant;
getNOdata.DepositAcctDate = model.DepositAcctDate;
}
db.SaveChanges();
msg = "Cash Receipt Updated Successfully";
}
db.Dispose();
return(msg);
}
