public Agreement selectAgreement(Agreement obj) { try { IAgreementSvc svc = (IAgreementSvc)this.getService(typeof(IAgreementSvc).Name); return svc.selectAgreement(obj); } catch (ServiceLoadException ex) { throw ex; } }
public Boolean objectDataEquals(Agreement obj) { if (!(this.Agreement_ID.Equals(obj.Agreement_ID))) { return false; } if (!(this.Agreement_Name.Equals(obj.Agreement_Name))) { return false; } return true; }
public bool deleteAgreement(Agreement obj) { using (RealReportContext db = new RealReportContext()) { try { IQueryable<Agreement> AgreementList = from agreement in db.Agreements where agreement.Agreement_ID == obj.Agreement_ID select agreement; if ((AgreementList.ToArray().Length > 0)) { foreach (Agreement agreement in AgreementList.ToList()) { for (int n = 0; n < (agreement.Properties.ToArray()).Length; n++ ) { db.Properties.Remove((agreement.Properties.ToArray())[0]); } } db.Agreements.Remove((AgreementList.ToArray())[0]); #region Database Submission try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }
public Agreement selectAgreement(Agreement obj) { RealReportContext db = new RealReportContext(); try { IQueryable<Agreement> AgreementList = from agreement in db.Agreements where agreement.Agreement_ID == obj.Agreement_ID select agreement; return (AgreementList.ToList())[0]; } catch (Exception ex) { return null; } }
public bool insertAgreement(Agreement obj) { using (RealReportContext db = new RealReportContext()) { try { db.Agreements.Add(obj); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public Boolean updateAgreement(Agreement obj) { try { IAgreementSvc svc = (IAgreementSvc)this.getService(typeof(IAgreementSvc).Name); if (obj.isDataEntered()) { return svc.updateAgreement(obj); } else { throw new BusinessValidationException(CustomErrors.REQUIRED_FIELD); } } catch (ServiceLoadException ex) { throw ex; } }
public bool updateAgreement(Agreement obj) { using (RealReportContext db = new RealReportContext()) { try { IQueryable<Agreement> AgreementList = from agreement in db.Agreements where agreement.Agreement_ID == obj.Agreement_ID select agreement; if ((AgreementList.ToArray()).Length > 0) { foreach (Agreement agreement in AgreementList) { agreement.Agreement_Name = obj.Agreement_Name; } #region Database Submission with Rollback try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }