public void DoDeleteCustomer(List<MESParameterInfo> lstParameters) { try { dbInstance.BeginTransaction(); ContactDal contactDal = new ContactDal(dbInstance); contactDal.DoDelete<tmdlcontact>(lstParameters); baseDal.DoDelete<tmdlcustomer>(lstParameters); dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }
public void DoUpdateCustomer(tmdlcustomer customer, List<tmdlcontact> lstContact) { try { dbInstance.BeginTransaction(); ContactDal contactDal = new ContactDal(dbInstance); List<MESParameterInfo> lstParams = new List<MESParameterInfo>() { new MESParameterInfo(){ParamName="customerid",ParamValue=customer.customerid} }; List<tmdlcontact> lstOld = contactDal.GetSelectedObjects<tmdlcontact>(lstParams); for (int i = 0; i < lstContact.Count; i++) { if (lstContact[i].customerid == null || lstContact[i].customerid == string.Empty) { //new lstContact[i].customerid = customer.customerid; contactDal.DoInsert<tmdlcontact>(lstContact[i]); } else { //do update contactDal.DoUpdate<tmdlcontact>(lstContact[i]); } } #region check Delete bool bDeleted = true; List<int> lstDeleteIdx = new List<int>(); for (int i = 0; i < lstOld.Count; i++) { bDeleted = true; for (int j = 0; j < lstContact.Count; j++) { if (lstOld[i].contactname == lstContact[j].contactname) { bDeleted = false; } } if (bDeleted) lstDeleteIdx.Add(i); } for (int i = 0; i < lstDeleteIdx.Count; i++) { contactDal.DoDelete<tmdlcontact>(lstOld[lstDeleteIdx[i]]); } #endregion baseDal.DoUpdate<tmdlcustomer>(customer); dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }