public List <CRONUSMetadata_Key> GetAllKeys()
{
using (db = new CRONUSContext())
{
return(db.CRONUSMetadata_Key.ToList());
}
}
public List <CRONUSMetadata_Index> GetAllIndexes()
{
using (db = new CRONUSContext())
{
return(db.CRONUSMetadata_Index.Where(i => i.Name.Contains("CRONUS")).ToList());
}
}
public List <CRONUS_Employees_Sick_2004> GetEmployeesSick2004()
{
using (db = new CRONUSContext())
{
return(db.CRONUS_Employees_Sick_2004.ToList());
}
}
public List <CRONUSMetadata_EmployeeRelated> GetEmployeesMetadataAndRelated()
{
using (db = new CRONUSContext())
{
return(db.CRONUSMetadata_EmployeeRelated.ToList());
}
}
public List <CRONUS_Sverige_AB_Partner> GetAllPartners()
{
using (db = new CRONUSContext())
{
return(db.CRONUS_Sverige_AB_Partner.ToList());
}
}
public List <CRONUS_Employees_And_Relatives> GetEmployeesAndRelatives()
{
using (db = new CRONUSContext())
{
return(db.CRONUS_Employees_And_Relatives.ToList());
}
}
public List <CRONUS_Employee_Top5_Absence> GetTop5EmployeesAbsent()
{
using (db = new CRONUSContext())
{
return(db.CRONUS_Employee_Top5_Absence.ToList());
}
}
public List <CRONUSMetadata_Column> GetAllColumnsInEmployees()
{
using (db = new CRONUSContext())
{
return(db.CRONUSMetadata_Column.Where(t => t.Table_Name.Equals("CRONUS Sverige AB$Employee")).ToList());
}
}
public List <CRONUSMetadata_Table> GetAllTablesInDB()
{
using (db = new CRONUSContext())
{
return(db.CRONUSMetadata_Table.ToList());
}
}
public List <CRONUSMetadata_Constraint> GetAllConstraints()
{
using (db = new CRONUSContext())
{
return(db.CRONUSMetadata_Constraint.ToList());
}
}
public List <CRONUS_Sverige_AB_Partner> GetAllEmployeesAndRelatives()
{
using (db = new CRONUSContext())
{
var queryResult = db.CRONUS_Sverige_AB_Employee.Join(db.CRONUS_Sverige_AB_Employee_Relative,
e => e.No_,
er => er.Employee_No_,
(e, er) => new { CRONUS_Sverige_AB_Employee = e, CRONUS_Sverige_AB_Employee_Relative = er }).ToList();
return(null);
}
}
public CRONUS_Sverige_AB_Partner RemovePartner(CRONUS_Sverige_AB_Partner partnerToRemove)
{
try
{
using (db = new CRONUSContext())
{
var partner = db.CRONUS_Sverige_AB_Partner.Where(p => p.Company == partnerToRemove.Company).SingleOrDefault();
db.CRONUS_Sverige_AB_Partner.Remove(partner);
db.SaveChanges();
return(partnerToRemove);
}
} catch (Exception e)
{
throw e;
}
}
public CRONUS_Sverige_AB_Partner AddPartner(CRONUS_Sverige_AB_Partner newPartner)
{
try
{
using (db = new CRONUSContext())
{
db.CRONUS_Sverige_AB_Partner.Add(newPartner);
db.SaveChanges();
}
return(newPartner);
}catch (DbEntityValidationException e)
{
throw e;
}
catch (SqlException e)
{
throw e;
}
catch (Exception e)
{
throw e;
}
}
