public bool SaveInsCommisionStructureLine(InsCommissionStructureLineVM commisionStructureLineVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblComCommisionStructureLine commisionStructureLine = new tblComCommisionStructureLine(); commisionStructureLine.ComStructID = commisionStructureLineVM.CommisionStructureID; commisionStructureLine.ChargeTypeID = commisionStructureLineVM.RateCategoryID; commisionStructureLine.Percentage = commisionStructureLineVM.RateValue; commisionStructureLine.CreatedDate = DateTime.Now; //commisionStructureLine.CreatedBy = commisionStructureLineVM.CreatedBy; //unitOfWork.TblCommisionStructureLineRepository.Insert(commisionStructureLine); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public bool SaveInsCommisionStructureHeader(InsCommissionStructureHeaderVM commisionStructureHeaderVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblInsComCommisionStructureHeader commisionStructureHeader = new tblInsComCommisionStructureHeader(); commisionStructureHeader.ComStructName = commisionStructureHeaderVM.CommisionStructureName; commisionStructureHeader.ExtraFloat1 = commisionStructureHeaderVM.BusinessUnitID; commisionStructureHeader.InsCompanyID = commisionStructureHeaderVM.InsuranceCompanyID; commisionStructureHeader.InsClassID = commisionStructureHeaderVM.InsuranceClassID; commisionStructureHeader.InsSubClassID = commisionStructureHeaderVM.InsuranceSubClassID; commisionStructureHeader.CreatedDate = DateTime.Now; commisionStructureHeader.CreatedBy = commisionStructureHeaderVM.CreatedBy; unitOfWork.TblInsCommisionStructureHeaderRepository.Insert(commisionStructureHeader); unitOfWork.Save(); int savedIndex = commisionStructureHeader.ComHeaderID; foreach (var chargeType in commisionStructureHeaderVM.ChargeTypeList) { tblComCommisionStructureLine inscommissionLine = new tblComCommisionStructureLine(); inscommissionLine.ComStructID = savedIndex; inscommissionLine.ChargeTypeID = chargeType.ChargeTypeID; inscommissionLine.Percentage = chargeType.Amount; inscommissionLine.CreatedDate = DateTime.Now; inscommissionLine.CreatedBy = commisionStructureHeaderVM.CreatedBy; unitOfWork.TblInsCommisionStructureLineRepository.Insert(inscommissionLine); unitOfWork.Save(); } //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }