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);
}
}
