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; }