/// <summary> /// Elimina una instancia de riesgos_estatus /// </summary> /// <param name="entidad"></param> /// <returns></returns> public string Eliminar(int id_comment_type_payment) { try { SICOEMEntities sicoem = new SICOEMEntities(); comments_types_payments bono = sicoem.comments_types_payments .First(i => i.id_comment_type_payment == id_comment_type_payment); bono.enabled = false; sicoem.SaveChanges(); return(""); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); var fullErrorMessage = string.Join("; ", errorMessages); return(fullErrorMessage.ToString()); } }
/// <summary> /// Elimina una instancia de riesgos_estatus /// </summary> /// <param name="entidad"></param> /// <returns></returns> public string Eliminar(string login) { try { SICOEMEntities sicoem = new SICOEMEntities(); permissions_users_bonds_types permiso = sicoem.permissions_users_bonds_types .First(i => i.login.ToString() == login.ToString()); permiso.Enabled = false; sicoem.SaveChanges(); return(""); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); var fullErrorMessage = string.Join("; ", errorMessages); return(fullErrorMessage.ToString()); } }
public int AgregarArchivo(files_requests_bonds file) { try { string mess = ""; SICOEMEntities context = new SICOEMEntities(); file.date_attach = DateTime.Now; context.files_requests_bonds.Add(file); context.SaveChanges(); return(file.id_file_request_bond); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); var fullErrorMessage = string.Join("; ", errorMessages); return(0); } }
/// <summary> /// Devuelve una tabla con los estatus de los proyectos activos /// </summary> /// <returns></returns> public DataTable SelectAll() { DataTable dt = new DataTable(); try { SICOEMEntities sicoem = new SICOEMEntities(); var query = sicoem.permissions_users_bonds_types .Where(s => s.Enabled == true) .Select(u => new { u.login, u.permission_request_bond, u.permision_authorization_bond, u.FiltroCC, }).ToArray(); NAVISION dbnavision = new NAVISION(); var results = from p in query join up in dbnavision.Employee on p.login.ToUpper().Trim() equals up.Usuario_Red.ToUpper().Trim() select new { p.login, empleado = up.First_Name.Trim() + " " + up.Last_Name.Trim(), p.permission_request_bond, p.permision_authorization_bond, p.FiltroCC, }; dt = To.DataTable(results.ToList()); return(dt); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); var fullErrorMessage = string.Join("; ", errorMessages); return(new DataTable()); } }