public List <Employee> ReadEmployee(int IDFrom, int IDTo, string fullname = null)
{
try
{
using (CRUDEFEntities dbContext = new CRUDEFEntities())
{
IQueryable <Employee> query = dbContext.Employees.Where(x => x.ID >= IDFrom && x.ID <= IDTo);
if (!String.IsNullOrWhiteSpace(fullname))
{
query = query.Where(x => x.FullName == fullname);
}
return(query.OrderBy(x => x.ID).ToList());
}
}
catch (Exception)
{ throw; }
}
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);
}
