public void SaveRecord(ChargeViewModel chargeViewModel)
{
tbl_GLChargeMaster_BasicInfo tblCharge = new tbl_GLChargeMaster_BasicInfo();
tbl_GLChargeMaster_Details tblChargeDetails = new tbl_GLChargeMaster_Details();
tblCharge.ChargeName = chargeViewModel.ChargeName;
tblCharge.ReferenceDate = chargeViewModel.ReferenceDate;
tblCharge.Status = chargeViewModel.Status;
tblCharge.BranchID = Convert.ToInt32(HttpContext.Current.Session["BranchId"]);
tblCharge.CMPId = Convert.ToInt32(HttpContext.Current.Session["CompanyId"]);
tblCharge.FYID = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]);
tblCharge.CreatedDate = DateTime.Now;
tblCharge.CreatedBy = chargeViewModel.CreatedBy;
tblCharge.UpdatedDate = DateTime.Now;
tblCharge.UpdatedBy = chargeViewModel.UpdatedBy;
_context.tbl_GLChargeMaster_BasicInfo.Add(tblCharge);
_context.SaveChanges();
int CID = _context.tbl_GLChargeMaster_BasicInfo.Max(x => x.CID);
//save the data in Charge Details table
foreach (var p in chargeViewModel.chargeDetailsCollection)
{
var chargetrn = new tbl_GLChargeMaster_Details
{
CID = CID,
LoanAmtFrom = p.LoanAmountGreaterthan,
LoanAmtTo = p.LoanAmountLessthan,
Charges = p.ChargeAmount,
ChargeType = p.ChargeType,
};
_context.tbl_GLChargeMaster_Details.Add(chargetrn);
_context.SaveChanges();
}
}
public static ChargeViewModel ToViewModelCharge(tbl_GLChargeMaster_BasicInfo charge, ICollection <tbl_GLChargeMaster_Details> ChargeTrnList)
{
var purchaseviewmodel = new ChargeViewModel
{
ChargeName = charge.ChargeName,
ReferenceDate = charge.ReferenceDate,
Status = charge.Status,
ID = charge.CID,
};
IList <ChargeDetailsViewModel> ChargeTrnViewModelList = new List <ChargeDetailsViewModel>();
foreach (var c in ChargeTrnList)
{
var ChargeTrnViewModel = new ChargeDetailsViewModel
{
ID = c.ID,
LoanAmountGreaterthan = c.LoanAmtFrom,
LoanAmountLessthan = c.LoanAmtTo,
ChargeAmount = c.Charges,
ChargeType = c.ChargeType,
};
ChargeTrnViewModelList.Add(ChargeTrnViewModel);
}
purchaseviewmodel.chargeDetailsCollection = ChargeTrnViewModelList;
return(purchaseviewmodel);
}
