public void CreateEmployee(int ID, string fullname)
{
try
{
using (CRUDEFEntities dbContext = new CRUDEFEntities())
{
var emp = new Employee();
emp.ID = ID;
emp.FullName = fullname;
dbContext.Employees.Add(emp);
dbContext.SaveChanges();
}
}
catch (Exception)
{ throw; }
}
public bool UpdateEmployee(int ID, string newFullName)
{
using (var dbContext = new CRUDEFEntities())
{
var query = dbContext.Employees.SingleOrDefault(x => x.ID == ID);
if (query == null)
{
return(false);
}
if (!String.IsNullOrWhiteSpace(newFullName))
{
query.FullName = newFullName;
}
dbContext.SaveChanges();
return(true);
}
}
public bool DeleteEmployee(int ID)
{
try
{
using (CRUDEFEntities dbContext = new CRUDEFEntities())
{
var query = dbContext.Employees.SingleOrDefault(x => x.ID == ID);
if (query == null)
{
return(false);
}
dbContext.Employees.Remove(query);
dbContext.SaveChanges();
}
}
catch (Exception)
{ throw; }
return(true);
}
