public void AddCompany(string companyName, string description) { try { using (CronusContext cc = new CronusContext()) { if (companyName != "") { Company company = new Company(companyName, description); cc.Company.Add(company); cc.SaveChanges(); } else { companyName = null; Company company = new Company(companyName, description); cc.Company.Add(company); cc.SaveChanges(); } } } catch (Exception e) { throw ExceptionHandler.HandleEFException(e);; } }
public void UpdateCompany(string oldCompanyName, string description) { try { using (CronusContext cc = new CronusContext()) { Company company = cc.Company.Find(oldCompanyName); if (company != null) { company.Description = description; cc.SaveChanges(); } else { throw new SoapException("Company not found", SoapException.ServerFaultCode); } } } catch (SoapException) { throw; } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }
public void RemoveCompany(string companyName) { try { using (CronusContext cc = new CronusContext()) { Company company = SelectCompany(companyName); if (company != null) { cc.Company.Attach(company); cc.Company.Remove(company); cc.SaveChanges(); } else { throw new SoapException("Company not found", SoapException.ServerFaultCode); } } } catch (SoapException) { throw; } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }