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); }