public void DeleteEmployee(int id)
{
var db = new Model.Practico1TSIEntities();
string sql = "DELETE FROM EmployeeTPH WHERE ID = " + id;
db.Database.ExecuteSqlCommand(sql);
}
public void AddFullTimeEmployee(Shared.Entities.FullTimeEmployee emp)
{
var db = new Model.Practico1TSIEntities();
String sql = "INSERT INTO EmployeesTPH VALUES(" +
emp.Id + ",'" + emp.Name + "','" + emp.StartDate + "'," + emp.Salary + "," + null + ",1)";
db.Database.ExecuteSqlCommand(sql);
}
public void UpdateFullTimeEmployee(Shared.Entities.FullTimeEmployee emp)
{
var db = new Model.Practico1TSIEntities();
string sql = "UPDATE EmployeeTPH SET " +
" NAME = '" + emp.Name + "'" +
", START_DATE = '" + emp.StartDate + "'" +
", SALARY = " + emp.Salary +
", RATE = null " +
", TYPE = 2 " +
" WHERE ID = " + emp.Id;
db.Database.ExecuteSqlCommand(sql);
}
public void AddFullTimeEmployee(Shared.Entities.FullTimeEmployee emp)
{
var bd = new Model.Practico1TSIEntities();
var t = new Model.FullTimeEmployee();
t.Name = emp.Name;
t.EmployeeID = emp.Id;
t.StartDate = emp.StartDate;
t.Salary = (Int16)emp.Salary;
bd.EmployeesTPH.Add(t);
bd.SaveChanges();
}
public void UpdateFullTimeEmployee(Shared.Entities.FullTimeEmployee emp)
{
var db = new Model.Practico1TSIEntities();
var objEmp = db.EmployeesTPH.Find(emp.Id);
Model.FullTimeEmployee empF = new Model.FullTimeEmployee();
empF.EmployeeID = emp.Id;
empF.Name = emp.Name;
empF.StartDate = emp.StartDate;
empF.Salary = (short)emp.Salary;
db.EmployeesTPH.Remove(objEmp);
db.EmployeesTPH.Add(empF);
db.SaveChanges();
}
public List <Employee> GetAllEmployees()
{
var db = new Model.Practico1TSIEntities();
List <Employee> retorno = new List <Employee>();
string sqlP = "SELECT * FROM EmployeeTPH WHERE TYPE = 1";
string sqlF = "SELECT * FROM EmployeeTPH WHERE TYPE = 2";
var empP = db.Database.SqlQuery <PartTimeEmployee>(sqlP).ToList();
var empF = db.Database.SqlQuery <Shared.Entities.FullTimeEmployee>(sqlF).ToList();
retorno.Union(empP);
retorno.Union(empF);
return(retorno);
}
public Employee GetEmployee(int id)
{
Console.WriteLine("entre a la funcion EF");
Model.Practico1TSIEntities db = new Model.Practico1TSIEntities();
var empQuery = db.EmployeesTPH.Find(id);
Console.WriteLine(empQuery.Name);
if (empQuery is Model.PartTimeEmployee)
{
Console.WriteLine("entre a PartTimeEmployee");
return(GetPartTimeEmployee(id));
}
else
{
return(GetFullTimeEmployee(id));
}
}
