public bool UpdateIntroducer(IntroducerVM introducerVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
//Update Introducer
tblIntroducer introducer = unitOfWork.TblIntroducerRepository.GetByID(introducerVM.IntroducerID);
introducer.IntroducerName = introducerVM.IntroducerName;
introducer.Description = introducerVM.Description;
introducer.Address1 = introducerVM.Address1;
introducer.Address2 = introducerVM.Address2;
introducer.Address3 = introducerVM.Address3;
introducer.ModifiedDate = DateTime.Now;
introducer.ModifiedBy = introducerVM.ModifiedBy;
unitOfWork.TblIntroducerRepository.Update(introducer);
unitOfWork.Save();
//Delete Existing Business Unit ID List
List <tblIntroducerBusinessUnit> existingBusinessUnitList = unitOfWork.TblIntroducerBusinessUnitRepository.Get(x => x.IntroducerID == introducerVM.IntroducerID).ToList();
foreach (tblIntroducerBusinessUnit existingBusinessUnit in existingBusinessUnitList)
{
unitOfWork.TblIntroducerBusinessUnitRepository.Delete(existingBusinessUnit);
unitOfWork.Save();
}
//Save New Business Unit ID List
foreach (int businessUnitID in introducerVM.BusinessUnitIDList)
{
tblIntroducerBusinessUnit introducerBusinessUnit = new tblIntroducerBusinessUnit();
introducerBusinessUnit.IntroducerID = introducer.IntroducerID;
introducerBusinessUnit.BUID = businessUnitID;
unitOfWork.TblIntroducerBusinessUnitRepository.Insert(introducerBusinessUnit);
unitOfWork.Save();
}
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public bool SaveIntroducer(IntroducerVM introducerVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
//Save Introducer
tblIntroducer introducer = new tblIntroducer();
introducer.IntroducerName = introducerVM.IntroducerName;
introducer.Description = introducerVM.Description;
introducer.Address1 = introducerVM.Address1;
introducer.Address2 = introducerVM.Address2;
introducer.Address3 = introducerVM.Address3;
introducer.CreatedDate = DateTime.Now;
introducer.CreatedBy = introducerVM.CreatedBy;
unitOfWork.TblIntroducerRepository.Insert(introducer);
unitOfWork.Save();
//Save Business Unit ID List
foreach (int businessUnitID in introducerVM.BusinessUnitIDList)
{
tblIntroducerBusinessUnit introducerBusinessUnit = new tblIntroducerBusinessUnit();
introducerBusinessUnit.IntroducerID = introducer.IntroducerID;
introducerBusinessUnit.BUID = businessUnitID;
unitOfWork.TblIntroducerBusinessUnitRepository.Insert(introducerBusinessUnit);
unitOfWork.Save();
}
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
