public Employee GetEmployee(int id) { using (Model.Entity en = new Model.Entity()) { Model.Employee e = en.Employees.Find(id); if (e.GetType() == typeof(Model.FullTimeEmployee)) { Model.FullTimeEmployee em = (Model.FullTimeEmployee)e; return(new FullTimeEmployee() { Id = em.EmployeeId, Name = em.Name, StartDate = em.StartDate, Salary = em.Salary }); } else { Model.PartTimeEmployee em = (Model.PartTimeEmployee)e; return(new PartTimeEmployee() { Id = em.EmployeeId, Name = em.Name, StartDate = em.StartDate, HourlyRate = em.HourlyRate }); } } }
public void UpdateEmployee(Employee emp) { using (Model.Entity en = new Model.Entity()) { if (emp.GetType() == typeof(Shared.Entities.FullTimeEmployee)) { Model.FullTimeEmployee e = (Model.FullTimeEmployee)en.Employees.Find(emp.Id); FullTimeEmployee em = (FullTimeEmployee)emp; e.EmployeeId = em.Id; e.Name = em.Name; e.StartDate = em.StartDate; e.Salary = em.Salary; en.SaveChanges(); } else { Model.PartTimeEmployee e = (Model.PartTimeEmployee)en.Employees.Find(emp.Id); PartTimeEmployee em = (PartTimeEmployee)emp; e.EmployeeId = em.Id; e.Name = em.Name; e.StartDate = em.StartDate; e.HourlyRate = em.HourlyRate; en.SaveChanges(); } } }
public void AddEmployee(Employee emp) { using (Model.ObligatorioEntities en = new Model.ObligatorioEntities()) { Model.Employee nuevo = null; if (emp.GetType() == typeof(FullTimeEmployee)) { FullTimeEmployee fullTime = (FullTimeEmployee)emp; nuevo = new Model.FullTimeEmployee() { EMP_ID = fullTime.Id, NAME = fullTime.Name, SALARY = fullTime.Salary, START_DATE = fullTime.StartDate, TYPE_EMP = 1 }; } else { PartTimeEmployee fullTime = (PartTimeEmployee)emp; nuevo = new Model.PartTimeEmployee() { EMP_ID = fullTime.Id, NAME = fullTime.Name, RATE = fullTime.HourlyRate, START_DATE = fullTime.StartDate, TYPE_EMP = 1 }; } en.Employee.Add(nuevo); en.SaveChanges(); } }
public void AddEmployee(Employee emp) { using (Model.TESTEntities DB = new Model.TESTEntities()) { if (emp is PartTimeEmployee) { PartTimeEmployee empLP = new PartTimeEmployee(); Model.PartTimeEmployee nuevo = new Model.PartTimeEmployee(); nuevo.EmployeeId = empLP.Id; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.HourlyRate = empLP.HourlyRate; DB.Employees.Add(nuevo); } else { FullTimeEmployee empLP = new FullTimeEmployee(); Model.FullTimeEmployee nuevo = new Model.FullTimeEmployee(); nuevo.EmployeeId = empLP.Id; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.Salary = empLP.Salary; DB.Employees.Add(nuevo); } DB.SaveChanges(); } }
public Employee GetEmployee(int id) { using (Model.ObligatorioEntities en = new Model.ObligatorioEntities()) { Model.Employee emp = en.Employee.Find(id); Employee retorno = null; if (emp != null) { if (emp.GetType() == typeof(Model.FullTimeEmployee)) { Model.FullTimeEmployee fullTime = (Model.FullTimeEmployee)emp; retorno = new FullTimeEmployee() { Id = fullTime.EMP_ID, Name = fullTime.NAME, StartDate = fullTime.START_DATE, Salary = (int)fullTime.SALARY }; } else { Model.PartTimeEmployee partTime = (Model.PartTimeEmployee)emp; retorno = new PartTimeEmployee() { Id = partTime.EMP_ID, Name = partTime.NAME, StartDate = partTime.START_DATE, HourlyRate = (double)partTime.RATE }; } } return(retorno); } }
private Model.Employee Casteo(Employee emp) { if (emp == null) { return(null); } if (emp.GetType().Name == "FullTimeEmployee") { FullTimeEmployee employee = (FullTimeEmployee)emp; Model.FullTimeEmployee employeeBase = new Model.FullTimeEmployee() { Name = employee.Name, StartDate = employee.StartDate, Salary = employee.Salary }; return(employeeBase); } else { PartTimeEmployee employee = (PartTimeEmployee)emp; Model.PartTimeEmployee employeeBase = new Model.PartTimeEmployee() { Name = employee.Name, StartDate = employee.StartDate, HourlyRate = employee.HourlyRate }; return(employeeBase); } }
private Employee casteo(Model.Employee emp) { if (emp != null) { if (emp.GetType().Name == "FullTimeEmployee") { Model.FullTimeEmployee x = (Model.FullTimeEmployee)emp; FullTimeEmployee employeeBase = new FullTimeEmployee() { Id = x.EmployeeId, Name = x.Name, StartDate = x.StartDate, Salary = x.Salary }; return(employeeBase); } else { Model.PartTimeEmployee x = (Model.PartTimeEmployee)emp; PartTimeEmployee employeeBase = new PartTimeEmployee() { Id = x.EmployeeId, Name = x.Name, StartDate = x.StartDate, HourlyRate = x.HourlyRate }; return(employeeBase); } } return(null); }
public Employee GetEmployee(int id) { using (Model.PracticoEntities en = new Model.PracticoEntities()) { Model.Employee e = en.EmployeeTPH.Find(id); if (e.GetType() == typeof(FullTimeEmployee)) { Model.FullTimeEmployee fullTime = new Model.FullTimeEmployee(); fullTime = (Model.FullTimeEmployee)e; return(new FullTimeEmployee() { Id = fullTime.EmployeeId, Name = fullTime.Name, Salary = fullTime.Salary, StartDate = fullTime.StartDate, }); } else { Model.PartTimeEmployee partTime = new Model.PartTimeEmployee(); partTime = (Model.PartTimeEmployee)e; return(new PartTimeEmployee() { Id = partTime.EmployeeId, Name = partTime.Name, HourlyRate = partTime.HourlyRate, StartDate = partTime.StartDate, }); } } }
public List <Employee> GetAllEmployees() { List <Employee> lista = new List <Employee>(); using (Model.TESTEntities DB = new Model.TESTEntities()) { var ListEmp = (from e in DB.Employees select e).ToList(); foreach (Model.Employee emp in ListEmp) { if (emp is Model.PartTimeEmployee) { Model.PartTimeEmployee empDB = (Model.PartTimeEmployee)emp; PartTimeEmployee nuevo = new PartTimeEmployee(); nuevo.Id = empDB.EmployeeId; nuevo.Name = empDB.Name; nuevo.StartDate = empDB.StartDate; nuevo.HourlyRate = (Double)empDB.HourlyRate; lista.Add(nuevo); } else { Model.FullTimeEmployee empDB = (Model.FullTimeEmployee)emp; FullTimeEmployee nuevo = new FullTimeEmployee(); nuevo.Id = empDB.EmployeeId; nuevo.Name = empDB.Name; nuevo.StartDate = empDB.StartDate; nuevo.Salary = (int)empDB.Salary; lista.Add(nuevo); } } } return(lista); }
public void AddEmployee(Employee emp) { using (Model.PracticoEntities en = new Model.PracticoEntities()) { Model.Employee empNuevo; if (emp.GetType() == typeof(FullTimeEmployee)) { FullTimeEmployee empFT = (FullTimeEmployee)emp; empNuevo = new Model.FullTimeEmployee() { EmployeeId = empFT.Id, Name = empFT.Name, Salary = empFT.Salary, StartDate = empFT.StartDate }; en.EmployeeTPH.Add(empNuevo); en.SaveChanges(); } else { PartTimeEmployee empPT = (PartTimeEmployee)emp; empNuevo = new Model.PartTimeEmployee() { EmployeeId = empPT.Id, Name = empPT.Name, StartDate = empPT.StartDate, HourlyRate = empPT.HourlyRate }; en.EmployeeTPH.Add(empNuevo); en.SaveChanges(); } } }
public Employee GetEmployee(int id) { using (Model.TESTEntities DB = new Model.TESTEntities()) { var ListEmp = (from e in DB.Employees where e.EmployeeId == id select e).ToList(); foreach (Model.Employee emp in ListEmp) { if (emp is Model.PartTimeEmployee) { Model.PartTimeEmployee empDB = (Model.PartTimeEmployee)emp; PartTimeEmployee nuevo = new PartTimeEmployee(); nuevo.Id = empDB.EmployeeId; nuevo.Name = empDB.Name; nuevo.StartDate = empDB.StartDate; nuevo.HourlyRate = (Double)empDB.HourlyRate; return(nuevo); } else { Model.FullTimeEmployee empDB = (Model.FullTimeEmployee)emp; FullTimeEmployee nuevo = new FullTimeEmployee(); nuevo.Id = empDB.EmployeeId; nuevo.Name = empDB.Name; nuevo.StartDate = empDB.StartDate; nuevo.Salary = (int)empDB.Salary; return(nuevo); } } return(null); } }
public void AddEmployee(Employee emp) { if (emp != null) { using (Model.Practico_EntregableEntities en = new Model.Practico_EntregableEntities()) { if (emp.GetType().Name == "PartTimeEmployee") { PartTimeEmployee Pte = (PartTimeEmployee)emp; Model.PartTimeEmployee obj = new Model.PartTimeEmployee() { Name = Pte.Name, StartDate = Pte.StartDate, HourlyRate = Pte.HourlyRate }; en.Employee.Add(obj); en.SaveChanges(); } else { FullTimeEmployee Fte = (FullTimeEmployee)emp; Model.FullTimeEmployee obj = new Model.FullTimeEmployee() { Name = Fte.Name, StartDate = Fte.StartDate, Salary = Fte.Salary }; en.Employee.Add(obj); en.SaveChanges(); } } } }
public void UpdateEmployee(Employee emp) { using (Model.PracticoObligatorioEntities1 en = new Model.PracticoObligatorioEntities1()) { if (emp.GetType() == typeof(Shared.Entities.FullTimeEmployee)) { FullTimeEmployee FullTimeEmp = (FullTimeEmployee)emp; Model.Employee e = en.EmployeesTPH.Find(emp.EMP_ID); if (e != null) { Model.FullTimeEmployee empFT = (Model.FullTimeEmployee)e; empFT.NAME = FullTimeEmp.NAME; empFT.SALARY = FullTimeEmp.SALARY; empFT.START_DATE = FullTimeEmp.START_DATE; en.SaveChanges(); } } else { PartTimeEmployee PartTimeEmp = (PartTimeEmployee)emp; Model.Employee e = en.EmployeesTPH.Find(emp.EMP_ID); if (e != null) { Model.PartTimeEmployee empFT = (Model.PartTimeEmployee)e; empFT.NAME = PartTimeEmp.NAME; empFT.SALARY = PartTimeEmp.SALARY; empFT.START_DATE = PartTimeEmp.START_DATE; en.SaveChanges(); } } } }
public void AddEmployee(Employee emp) { using (Model.PracticoObligatorioEntities en = new Model.PracticoObligatorioEntities()) { if (emp.GetType().Name == "FullTimeEmployee") { FullTimeEmployee employee = (FullTimeEmployee)emp; Model.FullTimeEmployee employeeBase = new Model.FullTimeEmployee() { Name = employee.Name, StartDate = employee.StartDate, Salary = employee.Salary }; en.EmployeesTPH.Add(employeeBase); en.SaveChanges(); } else { PartTimeEmployee employee = (PartTimeEmployee)emp; Model.PartTimeEmployee employeeBase = new Model.PartTimeEmployee() { Name = employee.Name, StartDate = employee.StartDate, HourlyRate = employee.HourlyRate }; en.EmployeesTPH.Add(employeeBase); en.SaveChanges(); } } }
public Employee GetEmployee(int id) { using (Model.PracticoObligatorioEntities1 en = new Model.PracticoObligatorioEntities1()) { Model.Employee e = en.EmployeesTPH.Find(id); if (e.GetType() == typeof(Shared.Entities.FullTimeEmployee)) { FullTimeEmployee fullTime = (FullTimeEmployee)e; return(new FullTimeEmployee() { EMP_ID = fullTime.EMP_ID, NAME = fullTime.NAME, SALARY = fullTime.SALARY, START_DATE = fullTime.START_DATE, }); } else { PartTimeEmployee partTime = (PartTimeEmployee)e; return(new PartTimeEmployee() { EMP_ID = partTime.EMP_ID, NAME = partTime.NAME, RATE = partTime.RATE, START_DATE = partTime.START_DATE, }); } } }
public void AddEmployee(Employee emp) { using (Model.PracticoObligatorioEntities1 en = new Model.PracticoObligatorioEntities1()) { Model.Employee empNuevo; if (emp.GetType() == typeof(Shared.Entities.FullTimeEmployee)) { FullTimeEmployee empFT = (FullTimeEmployee)emp; empNuevo = new Model.FullTimeEmployee() { EMP_ID = empFT.EMP_ID, NAME = empFT.NAME, SALARY = empFT.SALARY, START_DATE = empFT.START_DATE }; en.EmployeesTPH.Add(empNuevo); en.SaveChanges(); } else { PartTimeEmployee empPT = (PartTimeEmployee)emp; empNuevo = new Model.PartTimeEmployee() { EMP_ID = empPT.EMP_ID, NAME = empPT.NAME, SALARY = empPT.SALARY, START_DATE = empPT.START_DATE }; en.EmployeesTPH.Add(empNuevo); en.SaveChanges(); } } }
private Employee Casteo(Model.Employee emp) { if (emp == null) { return(null); } if (emp.GetType().Name == "FullTimeEmployee") { Model.FullTimeEmployee Memp = (Model.FullTimeEmployee)emp; FullTimeEmployee employeeBase = new FullTimeEmployee() { Id = Memp.EmployeeId, Name = Memp.Name, StartDate = Memp.StartDate, Salary = Memp.Salary }; return(employeeBase); } else { Model.PartTimeEmployee Memp = (Model.PartTimeEmployee)emp; PartTimeEmployee employeeBase = new PartTimeEmployee() { Id = Memp.EmployeeId, Name = Memp.Name, StartDate = Memp.StartDate, HourlyRate = Memp.HourlyRate }; return(employeeBase); } }
public void UpdateEmployee(Employee emp) { using (Model.PracticoEntities en = new Model.PracticoEntities()) { if (emp.GetType() == typeof(FullTimeEmployee)) { FullTimeEmployee FullTimeEmp = (FullTimeEmployee)emp; Model.Employee e = en.EmployeeTPH.Find(emp.Id); if (e != null) { Model.FullTimeEmployee empFT = (Model.FullTimeEmployee)e; empFT.Name = FullTimeEmp.Name; empFT.Salary = FullTimeEmp.Salary; empFT.StartDate = FullTimeEmp.StartDate; en.SaveChanges(); } } else { PartTimeEmployee PartTimeEmp = (PartTimeEmployee)emp; Model.Employee e = en.EmployeeTPH.Find(emp.Id); if (e != null) { Model.PartTimeEmployee empFT = (Model.PartTimeEmployee)e; empFT.Name = PartTimeEmp.Name; empFT.StartDate = PartTimeEmp.StartDate; empFT.HourlyRate = PartTimeEmp.HourlyRate; en.SaveChanges(); } } } }
public void UpdateEmployee(Employee emp) { using (Model.TESTEntities DB = new Model.TESTEntities()) { if (emp != null) { if (emp != null) { Model.Employee EmpDB = DB.Employees.Find(emp.Id); if (EmpDB is Model.PartTimeEmployee) { PartTimeEmployee empLP = (PartTimeEmployee)emp; Model.PartTimeEmployee nuevo = (Model.PartTimeEmployee)EmpDB; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.HourlyRate = empLP.HourlyRate; DB.Employees.Attach(nuevo); } else { FullTimeEmployee empLP = (FullTimeEmployee)emp; Model.FullTimeEmployee nuevo = (Model.FullTimeEmployee)EmpDB; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.Salary = empLP.Salary; DB.Employees.Attach(nuevo); } DB.SaveChanges(); } } } }
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 Shared.Entities.FullTimeEmployee GetFullTimeEmployee(int id) { var db = new Practico1TSIEntities(); Model.FullTimeEmployee objEmp = db.EmployeesTPH.OfType <Model.FullTimeEmployee>().Where(e => e.EmployeeID == id).FirstOrDefault(); var retorno = new Shared.Entities.FullTimeEmployee(); retorno.Id = objEmp.EmployeeID; retorno.Name = objEmp.Name; retorno.StartDate = objEmp.StartDate; retorno.Salary = objEmp.Salary; return(retorno); }
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() { List <Employee> retorno = new List <Employee>(); using (Model.ObligatorioEntities en = new Model.ObligatorioEntities()) { List <Model.Employee> emps = en.Employee.ToList(); if (emps.Count < 1) { return(retorno); } en.Employee.ToList().ForEach(emp => { Employee nuevo = null; if (emp.GetType() == typeof(Model.FullTimeEmployee)) { Model.FullTimeEmployee fullTime = (Model.FullTimeEmployee)emp; nuevo = new FullTimeEmployee() { Id = fullTime.EMP_ID, Name = fullTime.NAME, StartDate = fullTime.START_DATE, Salary = (int)fullTime.SALARY }; } else { Model.PartTimeEmployee partTime = (Model.PartTimeEmployee)emp; nuevo = new PartTimeEmployee() { Id = partTime.EMP_ID, Name = partTime.NAME, StartDate = partTime.START_DATE, HourlyRate = (double)partTime.RATE }; } retorno.Add(nuevo); }); } return(retorno); }
public List <Employee> GetAllEmployees() { List <Employee> result = new List <Employee>(); using (Model.PracticoEntities en = new Model.PracticoEntities()) { en.EmployeeTPH.ToList().ForEach(emp => { if (emp.GetType() == typeof(FullTimeEmployee)) { Model.FullTimeEmployee empFT = (Model.FullTimeEmployee)emp; empFT = new Model.FullTimeEmployee(); FullTimeEmployee empleadoFT = new FullTimeEmployee() { Id = empFT.EmployeeId, Name = empFT.Name, StartDate = empFT.StartDate, Salary = empFT.Salary, }; result.Add(empleadoFT); } else { Model.PartTimeEmployee empPT = (Model.PartTimeEmployee)emp; empPT = new Model.PartTimeEmployee(); PartTimeEmployee empleadoPT = new PartTimeEmployee() { Id = empPT.EmployeeId, Name = empPT.Name, StartDate = empPT.StartDate, HourlyRate = empPT.HourlyRate, }; result.Add(empleadoPT); } }); } return(result); }
public void DeleteEmployee(int id) { using (var context = new Model.PracticoNetEntities()) { Model.Employee emp = context.Employee.FirstOrDefault(x => x.EmployeeId == id); if (emp != null) { if (emp.GetType().Name == "FullTimeEmployee") { Model.FullTimeEmployee fte = (Model.FullTimeEmployee)emp; context.Employee.Remove(fte); context.SaveChanges(); } else { Model.PartTimeEmployee pte = (Model.PartTimeEmployee)emp; context.Employee.Remove(pte); context.SaveChanges(); } } } }
public void UpdateEmployee(Employee emp) { if (emp != null) { using (Model.Practico_EntregableEntities en = new Model.Practico_EntregableEntities()) { Model.Employee e = en.Employee.FirstOrDefault(x => x.EmployeeId == emp.Id); e.Name = emp.Name; e.StartDate = emp.StartDate; if (emp.GetType().Name == "PartTimeEmployee") { Model.PartTimeEmployee Pte = (Model.PartTimeEmployee)e; Pte.HourlyRate = ((PartTimeEmployee)emp).HourlyRate; } else { Model.FullTimeEmployee Fte = (Model.FullTimeEmployee)e; Fte.Salary = ((FullTimeEmployee)emp).Salary; } en.SaveChanges(); } } }
public List <Employee> GetAllEmployees() { List <Employee> result = new List <Employee>(); using (Model.Entity en = new Model.Entity()) { en.Employees.ToList().ForEach(x => { if (x.GetType() == typeof(Model.FullTimeEmployee)) { Model.FullTimeEmployee e = (Model.FullTimeEmployee)x; result.Add( new FullTimeEmployee() { Id = e.EmployeeId, Name = e.Name, StartDate = e.StartDate, Salary = e.Salary } ); } else { Model.PartTimeEmployee e = (Model.PartTimeEmployee)x; result.Add( new PartTimeEmployee() { Id = e.EmployeeId, Name = e.Name, StartDate = e.StartDate, HourlyRate = e.HourlyRate } ); } }); } return(result); }
public void AddEmployee(Employee emp) { //throw new NotImplementedException(); Model.ER1Entities context = new Model.ER1Entities(); if (emp.GetType() == typeof(FullTimeEmployee)) { Model.FullTimeEmployee result = new Model.FullTimeEmployee() { }; result.Id = GetAllEmployees().Count; result.Name = emp.Name; result.Salary = ((FullTimeEmployee)emp).Salary; result.StartDate = emp.StartDate; context.Employees.Add(result); } else { Model.PartTimeEmployee result = new Model.PartTimeEmployee() { }; result.Id = GetAllEmployees().Count; result.Name = emp.Name; result.HourlyRate = ((PartTimeEmployee)emp).HourlyRate; result.StartDate = emp.StartDate; context.Employees.Add(result); } // Submit the changes to the database. try { context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } }
public List <Employee> GetAllEmployees() { using (Model.PracticoObligatorioEntities en = new Model.PracticoObligatorioEntities()) { List <Employee> listaEmpleados = new List <Employee>(); en.EmployeesTPH.ToList().ForEach(x => { if (x.GetType().Name == "FullTimeEmployee") { Model.FullTimeEmployee emp = new Model.FullTimeEmployee(); emp = (Model.FullTimeEmployee)x; FullTimeEmployee employee = new FullTimeEmployee() { Id = emp.EmployeeId, Name = emp.Name, StartDate = emp.StartDate, Salary = emp.Salary }; listaEmpleados.Add(employee); } else { Model.PartTimeEmployee emp = new Model.PartTimeEmployee(); emp = (Model.PartTimeEmployee)x; PartTimeEmployee employee = new PartTimeEmployee() { Id = emp.EmployeeId, Name = emp.Name, StartDate = emp.StartDate, HourlyRate = emp.HourlyRate }; listaEmpleados.Add(employee); } }); return(listaEmpleados); } }
public void UpdateEmployee(Employee emp) { if (emp == null) { return; } using (Model.PracticoNetEntities en = new Model.PracticoNetEntities()) { Model.Employee em = en.Employee.Find(emp.Id); em.Name = emp.Name; em.StartDate = emp.StartDate; if (emp.GetType().Name == "FullTimeEmployee") { Model.FullTimeEmployee emCast = (Model.FullTimeEmployee)em; emCast.Salary = ((FullTimeEmployee)emp).Salary; } else { Model.PartTimeEmployee emCast = (Model.PartTimeEmployee)em; emCast.HourlyRate = ((PartTimeEmployee)emp).HourlyRate; } en.SaveChanges(); } }