public Interest selectInterest(Interest obj) { try { IInterestSvc svc = (IInterestSvc)this.getService(typeof(IInterestSvc).Name); return svc.selectInterest(obj); } catch (ServiceLoadException ex) { throw ex; } }
public bool insertInterest(Interest obj) { using (RealReportContext db = new RealReportContext()) { try { db.Interests.Add(obj); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public Boolean insertInterest(Interest obj) { try { IInterestSvc svc = (IInterestSvc)this.getService(typeof(IInterestSvc).Name); if (obj.isDataEntered()) { return svc.insertInterest(obj); } else { throw new BusinessValidationException(CustomErrors.REQUIRED_FIELD); } } catch (ServiceLoadException ex) { throw ex; } }
public bool deleteInterest(Interest obj) { using (RealReportContext db = new RealReportContext()) { try { IQueryable<Interest> InterestList = from interest in db.Interests where interest.Buying_Agent == obj.Buying_Agent && interest.Selling_Agent == obj.Selling_Agent && interest.Property_ID == obj.Property_ID select interest; if ((InterestList.ToArray().Length > 0)) { db.Interests.Remove((InterestList.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 Interest selectInterest(Interest obj) { RealReportContext db = new RealReportContext(); try { IQueryable<Interest> InterestList = from interest in db.Interests where interest.Buying_Agent == obj.Buying_Agent && interest.Selling_Agent == obj.Selling_Agent && interest.Property_ID == obj.Property_ID select interest; return (InterestList.ToList())[0]; } catch (Exception ex) { return null; } }