public static bool DeleteEmployee(string sEmpId) { bool bReturn = false; try { EmployeeDBEntities myEntityDb = new EmployeeDBEntities(); var empToDelete = (from emp in myEntityDb.Employees where emp.Id == (new Guid(sEmpId)) select emp).SingleOrDefault(); myEntityDb.Employees.Remove(empToDelete); myEntityDb.SaveChanges(); } catch (Exception ex) { System.Diagnostics.Trace.WriteLine(ex); } return bReturn; }
public static bool InsertEmployee() { bool bReturn = false; try { EmployeeDBEntities myEntityDb = new EmployeeDBEntities(); Employee emp = new Employee(); emp.Id = Guid.NewGuid(); emp.Name = "ABC + " + new Random().Next().ToString(); emp.DOB = DateTime.Now; emp.EmailId = emp.Name + "@abc.com"; myEntityDb.Employees.Add(emp); myEntityDb.SaveChanges(); } catch (Exception ex) { System.Diagnostics.Trace.WriteLine(ex); } return bReturn; }
public static bool UpdateEmployee(string sEmpId) { bool bReturn = false; try { EmployeeDBEntities myEntityDb = new EmployeeDBEntities(); var empToUpdate = (from emp in myEntityDb.Employees where emp.Id == (new Guid(sEmpId)) select emp).SingleOrDefault(); if (empToUpdate != null) { empToUpdate.Name = "Update demo " + new Random().Next().ToString() + empToUpdate.Name; myEntityDb.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Trace.WriteLine(ex); } return bReturn; }