public bool UpdateCommisionStructureHeader(CommisionStructureHeaderVM commisionStructureHeaderVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblCommisionStructureHeader commisionStructureHeader = unitOfWork.TblCommisionStructureHeaderRepository.GetByID(commisionStructureHeaderVM.CommisionStructureID); commisionStructureHeader.ComStructName = commisionStructureHeaderVM.CommisionStructureName; commisionStructureHeader.BUID = commisionStructureHeaderVM.BusinessUnitID; commisionStructureHeader.PartnerID = commisionStructureHeaderVM.PartnerID; commisionStructureHeader.InsCompanyID = commisionStructureHeaderVM.InsuranceCompanyID; commisionStructureHeader.InsClassID = commisionStructureHeaderVM.InsuranceClassID; commisionStructureHeader.InsSubClassID = commisionStructureHeaderVM.InsuranceSubClassID; commisionStructureHeader.ModifiedDate = DateTime.Now; commisionStructureHeader.ModifiedBy = commisionStructureHeaderVM.ModifiedBy; unitOfWork.TblCommisionStructureHeaderRepository.Update(commisionStructureHeader); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public CommisionStructureHeaderVM GetCommisionStructureHeaderByID(int commisionStructureID) { try { tblCommisionStructureHeader commisionStructureHeaderData = unitOfWork.TblCommisionStructureHeaderRepository.GetByID(commisionStructureID); CommisionStructureHeaderVM commisionStructureHeaderVM = new CommisionStructureHeaderVM(); commisionStructureHeaderVM.CommisionStructureID = commisionStructureHeaderData.ComStructID; commisionStructureHeaderVM.CommisionStructureName = commisionStructureHeaderData.ComStructName; commisionStructureHeaderVM.BusinessUnitID = commisionStructureHeaderData.BUID != null?Convert.ToInt32(commisionStructureHeaderData.BUID) : 0; if (commisionStructureHeaderVM.BusinessUnitID > 0) { commisionStructureHeaderVM.BusinessUnitName = commisionStructureHeaderData.tblBussinessUnit.BussinessUnit; } commisionStructureHeaderVM.PartnerID = commisionStructureHeaderData.PartnerID != null?Convert.ToInt32(commisionStructureHeaderData.PartnerID) : 0; if (commisionStructureHeaderVM.PartnerID > 0) { commisionStructureHeaderVM.PartnerName = commisionStructureHeaderData.tblPartner.PartnerName; } commisionStructureHeaderVM.InsuranceCompanyID = commisionStructureHeaderData.InsCompanyID != null?Convert.ToInt32(commisionStructureHeaderData.InsCompanyID) : 0; if (commisionStructureHeaderVM.InsuranceCompanyID > 0) { commisionStructureHeaderVM.InsuranceCompanyName = commisionStructureHeaderData.tblInsCompany.InsCompany; } commisionStructureHeaderVM.InsuranceClassID = commisionStructureHeaderData.InsClassID != null?Convert.ToInt32(commisionStructureHeaderData.InsClassID) : 0; if (commisionStructureHeaderVM.InsuranceClassID > 0) { commisionStructureHeaderVM.InsuranceClassName = commisionStructureHeaderData.tblInsClass.Code; } commisionStructureHeaderVM.InsuranceSubClassID = commisionStructureHeaderData.InsSubClassID != null?Convert.ToInt32(commisionStructureHeaderData.InsSubClassID) : 0; if (commisionStructureHeaderVM.InsuranceSubClassID > 0) { commisionStructureHeaderVM.InsuranceSubClassName = commisionStructureHeaderData.tblInsSubClass.Description; } commisionStructureHeaderVM.CreatedDate = commisionStructureHeaderData.CreatedDate != null?commisionStructureHeaderData.CreatedDate.ToString() : string.Empty; commisionStructureHeaderVM.ModifiedDate = commisionStructureHeaderData.ModifiedDate != null?commisionStructureHeaderData.ModifiedDate.ToString() : string.Empty; commisionStructureHeaderVM.CreatedBy = commisionStructureHeaderData.CreatedBy != null?Convert.ToInt32(commisionStructureHeaderData.CreatedBy) : 0; commisionStructureHeaderVM.ModifiedBy = commisionStructureHeaderData.ModifiedBy != null?Convert.ToInt32(commisionStructureHeaderData.ModifiedBy) : 0; return(commisionStructureHeaderVM); } catch (Exception ex) { throw; } }
public bool DeleteCommisionStructureHeader(int commisionStructureID) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblCommisionStructureHeader commisionStructureHeader = unitOfWork.TblCommisionStructureHeaderRepository.GetByID(commisionStructureID); unitOfWork.TblCommisionStructureHeaderRepository.Delete(commisionStructureHeader); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }