public void UpdateEmployee(Employee emp) { Model.ER1Entities context = new Model.ER1Entities(); //Query the database var query = from employee in context.Employees where employee.Id == emp.Id select employee; //Change the values foreach (Model.Employee e in query) { e.Name = emp.Name; e.StartDate = emp.StartDate; if (e.GetType() == typeof(Model.FullTimeEmployee)) { ((Model.FullTimeEmployee)e).Salary = ((Shared.Entities.FullTimeEmployee)emp).Salary; } else { ((Model.PartTimeEmployee)e).HourlyRate = ((Shared.Entities.PartTimeEmployee)emp).HourlyRate; } } // Submit the changes to the database. try { context.SaveChanges(); }catch (Exception e) { Console.WriteLine(e); } }
public Employee GetEmployee(int id) { Model.ER1Entities context = new Model.ER1Entities(); // DataContext takes a connection string. IQueryable <Model.Employee> query = from employee in context.Employees where employee.Id == id select employee; Model.Employee empR = query.First(); if (empR.GetType() == typeof(Model.FullTimeEmployee)) { FullTimeEmployee result = new FullTimeEmployee(); result.Id = id; result.Name = empR.Name; result.Salary = ((Model.FullTimeEmployee)empR).Salary; result.StartDate = empR.StartDate; return(result); } else { PartTimeEmployee result = new PartTimeEmployee(); result.Id = id; result.Name = empR.Name; result.HourlyRate = ((Model.PartTimeEmployee)empR).HourlyRate; result.StartDate = empR.StartDate; return(result); } }
public List <Employee> GetAllEmployees() { // Model.ER1Entities context = new Model.ER1Entities(); using (var context = new Model.ER1Entities()) { IQueryable <Model.Employee> listEmp = from row in context.Employees select row; List <Employee> ret = new List <Employee>(); try { foreach (var empR in listEmp) { if (empR.GetType() == typeof(Model.FullTimeEmployee)) { FullTimeEmployee result = new FullTimeEmployee() { }; result.Id = empR.Id; result.Name = empR.Name; result.Salary = ((Model.FullTimeEmployee)empR).Salary; result.StartDate = empR.StartDate; ret.Add(result); } else { PartTimeEmployee result = new PartTimeEmployee() { }; result.Id = empR.Id; result.Name = empR.Name; result.HourlyRate = ((Model.PartTimeEmployee)empR).HourlyRate; result.StartDate = empR.StartDate; ret.Add(result); } } }catch (Exception e) { var a = e; } return(ret); }; }
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 void DeleteEmployee(int id) { //throw new NotImplementedException(); Model.ER1Entities context = new Model.ER1Entities(); //Query the database var query = from employee in context.Employees where employee.Id == id select employee; //Delete on submit foreach (Model.Employee e in query) { context.Employees.Remove(e); } // Submit the changes to the database. try { context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } }