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); } }
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 Company SelectCompany(string companyName) { try { using (CronusContext cc = new CronusContext()) { Company company = cc.Company.Find(companyName); return(company); } } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }
public List <CRONUS_Sverige_AB_Employee_Statistics_Group> GetAllEmployeeStatisticsGroup() { try { using (CronusContext cc = new CronusContext()) { List <CRONUS_Sverige_AB_Employee_Statistics_Group> list = cc.CRONUS_Sverige_AB_Employee_Statistics_Group.ToList(); return(list); } } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }
public List <CRONUS_Sverige_AB_Employee_Relative> GetAllEmployeeRelative() { try { using (CronusContext cc = new CronusContext()) { List <CRONUS_Sverige_AB_Employee_Relative> list = cc.CRONUS_Sverige_AB_Employee_Relative.ToList(); return(list); } } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }
public List <CRONUS_Sverige_AB_Employee_Absence> GetEmployeeAbsence() { try { using (CronusContext cc = new CronusContext()) { List <CRONUS_Sverige_AB_Employee_Absence> list = cc.CRONUS_Sverige_AB_Employee_Absence.Where(e => e.From_Date.Year == 2004).ToList(); return(list); } } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }
public List <CRONUS_Sverige_AB_Employee_Relative> GetEmployeeRelatives(string employeeNr) { try { using (CronusContext cc = new CronusContext()) { List <CRONUS_Sverige_AB_Employee_Relative> list = cc.CRONUS_Sverige_AB_Employee_Relative.Where(e => e.Employee_No_ == employeeNr).ToList(); return(list); } } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }
public List <Company> SelectAllCompany() { try { using (CronusContext cc = new CronusContext()) { List <Company> list = cc.Company.ToList(); return(list); } } catch (Exception e) { throw ExceptionHandler.HandleEFException(e); } }