public void AddEmployee_sp(EmpDTO Emp) { using (var empEntities = new EmployeeDBEntities()) { var employee = Emp.ToEntity(); empEntities.spAddEmployee(employee.Name,employee.JoinDate,employee.Salary,employee.DepartmentID); } }
public int AddEmployee(EmpDTO Emp) { using (var empEntities = new EmployeeDBEntities()) { var employee = Emp.ToEntity(); empEntities.Employees.Add(employee); empEntities.SaveChanges(); return employee.ID; } }
public static EmpDTO ToDomain(this Employee emp) { var employee = new EmpDTO { Name = emp.Name, Salary = emp.Salary, JoinDate = emp.JoinDate, DepartmentID = emp.DepartmentID }; return employee; }
public void UpdateEmployee_sp(EmpDTO Emp) { using (var empEntities = new EmployeeDBEntities()) { var employee = empEntities.Employees.FirstOrDefault(x => x.ID == Emp.ID); employee.JoinDate = Emp.JoinDate; employee.Name = Emp.Name; employee.Salary = Emp.Salary; employee.DepartmentID = Emp.DepartmentID; empEntities.SaveChanges(); } }
private static void AddEmployee() { try { var emp = new EmpDTO { Name = "as", Salary = 20000, JoinDate = Convert.ToDateTime("04-05-1989"), DepartmentID = 2 }; obj.AddEmployee_sp(emp); Console.WriteLine("Added succesfully...."); //Console.WriteLine(Id); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); } }
private static void UpdateEmployee() { try { var emp = new EmpDTO { ID = 1004, Name = "as", Salary = 20000, JoinDate = Convert.ToDateTime("04-05-1989"), DepartmentID = 2 }; obj.UpdateEmployee(emp); Console.WriteLine("Updated succesfully...."); Console.WriteLine(emp.ID); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); } }