public string InsertDatos(UserEmp tabla)
{
try
{
Query.UserEmp.Add(tabla);
Query.SaveChanges();
return("");
}
catch (Exception ex)
{
return("Error" + ex.Message);
}
}
public static void EliminarDept(int id)
{
using (var query = new DocumentControllerEntities())
{
var depto = query.Depto.Find(id);
query.Depto.Remove(depto);
query.SaveChanges();
}
}
public static void EliminarEmp(int id)
{
using (var query = new DocumentControllerEntities())
{
var emp = query.UserEmp.Find(id);
query.UserEmp.Remove(emp);
query.SaveChanges();
}
}
public void EditarDepartamentos(Depto dep)
{
using (var query = new DocumentControllerEntities())
{
var a = query.Depto.Find(dep.idDepto);
a.siglas = dep.siglas;
a.FullName = dep.FullName;
query.SaveChanges();
}
}
public void EditarEmpleado(UserEmp emp)
{
using (var query = new DocumentControllerEntities())
{
var d = query.UserEmp.Find(emp.idUserEmp);
d.FirstName = emp.FirstName;
d.LastName = emp.LastName;
d.Email = emp.Email;
d.password = emp.password;
d.Position = emp.Position;
d.Depto = emp.Depto;
query.SaveChanges();
}
}
