public bool DeleteIntroducer(int introducerID)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
//Delete Business Unit List
List <tblIntroducerBusinessUnit> existingBusinessUnitList = unitOfWork.TblIntroducerBusinessUnitRepository.Get(x => x.IntroducerID == introducerID).ToList();
foreach (tblIntroducerBusinessUnit existingBusinessUnit in existingBusinessUnitList)
{
unitOfWork.TblIntroducerBusinessUnitRepository.Delete(existingBusinessUnit);
unitOfWork.Save();
}
//Delete Introducer
tblIntroducer introducer = unitOfWork.TblIntroducerRepository.GetByID(introducerID);
unitOfWork.TblIntroducerRepository.Delete(introducer);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public static tblIntroducer Create()
{
tblIntroducer it = new tblIntroducer();
it.it_name = "unknown name";
it.it_phone = "unknown phone";
it.it_address = "unknown address";
return it;
}
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 void Add()
{
var tblIntroducer = new tblIntroducer
{
Introducer_Loan_Id = DLoanId,
Introducer_IntroducerType_Id = DIntroducerTypeId,
Introducer_Info_Id = DInfoId,
Introducer_Institution_Id = DInstitutionId,
IntroducerDescription = DDescription
};
_dbLoanEntities.tblIntroducer.Add(tblIntroducer);
_dbLoanEntities.SaveChanges();
}
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);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="dest"></param>
/// <returns></returns>
public tblIntroducer UpdateIntroducer(BxdbDataContext db, tblIntroducer it)
{
// TODO: dest.id != old.id
//
tblIntroducer old = this.It;
it.it_id = old.it_id;
it.it_address = old.it_address;
it.it_name = old.it_name;
it.it_phone = old.it_phone;
it.it_remark = old.it_remark;
return it;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public tblIntroducer GetIntroducer(BxdbDataContext db)
{
tblIntroducer old = this.It;
tblIntroducer it = new tblIntroducer();
it.it_id = old.it_id;
it.it_address = old.it_address;
it.it_name = old.it_name;
it.it_phone = old.it_phone;
it.it_remark = old.it_remark;
if (it.it_id == 0)
{
db.tblIntroducer.InsertOnSubmit(it);
}
return it;
}
