public void updateEmployee(int Id, string Name) { //will update all the employee using (EmployeeDbContainer db = new EmployeeDbContainer()) { var emp = db.Employees.Where(x => x.Id == Id).FirstOrDefault(); emp.Name = Name; db.SaveChanges(); } }
public void deleteEmployee(int Id) { //will delete all employee using (EmployeeDbContainer db = new EmployeeDbContainer()) { var emp = db.Employees.Where(x => x.Id == Id).FirstOrDefault(); db.Employees.Remove(emp); db.SaveChanges(); } }
public void saveEmployee(EmployeeEntity obj) { //will save all the employee using (EmployeeDbContainer db = new EmployeeDbContainer()) { Employee emp = new Employee { Id = obj.Id, Name = obj.Name }; db.Employees.Add(emp); db.SaveChanges(); } }
public void getAllEmployee() { //this will get all the employee from the databasea List <EmployeeEntity> listEmp = new List <EmployeeEntity>(); using (EmployeeDbContainer db = new EmployeeDbContainer()) { listEmp = db.Employees.Select(x => new EmployeeEntity { Id = x.Id, Name = x.Name }).ToList(); } //populating the datagridview dgvEmployee.DataSource = listEmp; }
public int getTempID() { //getting a temporary ID int Id = 0; using (EmployeeDbContainer db = new EmployeeDbContainer()) { var empID = db.Employees.OrderByDescending(x => x.Id).FirstOrDefault(); if (empID == null) { Id = 0; } else { Id = empID.Id; } } return(Id + 1); }