public List <Employee> ExtendSearchDate(DateTime initDate, DateTime endDate)
{
List <Employee> emp = new List <Employee>();
using (ContextDataContext context = new ContextDataContext())
{
emp = context.Employee.Where(x => x.ContractDate >= initDate && x.ContractDate <= endDate).ToList();
}
return(emp);
}
public List <Employee> GetEmployees()
{
List <Employee> emp = new List <Employee>();
using (ContextDataContext context = new ContextDataContext())
{
emp = context.Employee.ToList();
}
return(emp);
}
public List <Employee> ExtendSearchText(string text)
{
List <Employee> emp = new List <Employee>();
using (ContextDataContext context = new ContextDataContext())
{
emp = context.Employee.Where(x => x.IdentificationNumber.Contains(text) || x.FirstName.Contains(text) || x.LastName.Contains(text) || x.Email.Contains(text) || x.Direccion.Contains(text)).ToList();
}
return(emp);
}
public bool CreateEmployee(Employee emp)
{
bool resultado = false;
using (ContextDataContext context = new ContextDataContext())
{
context.Employee.InsertOnSubmit(emp);
context.SubmitChanges();
resultado = true;
}
return(resultado);
}
public bool CreateAdministrator(Administrator adm)
{
bool resultado = false;
using (ContextDataContext context = new ContextDataContext())
{
context.Administrator.InsertOnSubmit(adm);
context.SubmitChanges();
resultado = true;
}
return(resultado);
}
public bool DeleteEmployee(string id)
{
bool result = false;
Employee emp = new Employee();
using (ContextDataContext context = new ContextDataContext())
{
emp = context.Employee.Where(x => x.IdentificationNumber == id).FirstOrDefault();
context.Employee.DeleteOnSubmit(emp);
context.SubmitChanges();
result = true;
}
return(result);
}
public void InsertLogConnection(int id)
{
LogConnection cnx = new LogConnection()
{
IdAdministrator = id,
ConnetionDate = DateTime.UtcNow
};
using (ContextDataContext context = new ContextDataContext())
{
context.LogConnection.InsertOnSubmit(cnx);
context.SubmitChanges();
}
}
public bool EditEmployee(string id, string name, string lastName, string email)
{
bool result = false;
Employee emp = new Employee();
using (ContextDataContext context = new ContextDataContext())
{
emp = context.Employee.Where(x => x.IdentificationNumber == id).FirstOrDefault();
emp.FirstName = name;
emp.LastName = lastName;
emp.Email = email;
context.SubmitChanges();
result = true;
}
return(result);
}
public bool LoginUser(string user, string password)
{
bool result = false;
Administrator adm = new Administrator();
using (ContextDataContext context = new ContextDataContext())
{
adm = context.Administrator.Where(s => s.Username == user && s.Password == password).FirstOrDefault();
if (adm != null)
{
InsertLogConnection(adm.Id);
result = true;
}
}
return(result);
}
