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;
}
