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