public bool UpdateInsCommisionStructureHeader(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();
//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);
}
}
}
public bool DeleteInsCommisionStructureHeader(int commisionStructureID)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblInsComCommisionStructureHeader commisionStructureHeader = unitOfWork.TblInsCommisionStructureHeaderRepository.GetByID(commisionStructureID);
unitOfWork.TblInsCommisionStructureHeaderRepository.Delete(commisionStructureHeader);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
