public Client selectClient(Client obj) { try { IClientSvc svc = (IClientSvc)this.getService(typeof(IClientSvc).Name); return svc.selectClient(obj); } catch (ServiceLoadException ex) { throw ex; } }
public bool insertClient(Client obj) { using (RealReportContext db = new RealReportContext()) { try { db.Clients.Add(obj); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public Boolean updateClient(Client obj) { try { IClientSvc svc = (IClientSvc)this.getService(typeof(IClientSvc).Name); if (obj.isDataEntered()) { return svc.updateClient(obj); } else { throw new BusinessValidationException(CustomErrors.REQUIRED_FIELD); } } catch (ServiceLoadException ex) { throw ex; } }
public bool deleteClient(Client obj) { using (RealReportContext db = new RealReportContext()) { try { IQueryable<Client> ClientList = from client in db.Clients where client.ClientID == obj.ClientID select client; if ((ClientList.ToArray().Length > 0)) { // #region Database Submission try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }
public Client selectClient(Client obj) { RealReportContext db = new RealReportContext(); try { IQueryable<Client> ClientList = from Client in db.Clients where Client.ClientID == obj.ClientID select Client; return (ClientList.ToList())[0]; } catch (Exception ex) { return null; } }
public bool updateClient(Client obj) { using (RealReportContext db = new RealReportContext()) { try { IQueryable<Client> ClientList = from Client in db.Clients where Client.ClientID == obj.ClientID select Client; if ((ClientList.ToArray()).Length > 0) { foreach (Client Client in ClientList) { //Modify Attributes } #region Database Submission with Rollback try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }