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