public static dynamic getModel(Guid userId)
{
var result = new IMAC_sysContext().Database.SqlQuerySmart <dashboardDieta>("usp_IMAC_Dashboard_GetModel").ToList();
var tiposDieta = result.Select(x => x.DietaTipo).Distinct().ToList();
var obrasSociales = new IMAC_sysContext().Database.SqlQuerySmart <dashboardOSocial>("usp_IMAC_Dashboard_ObraSocialDieta").ToList();
var admisionesaltas = new IMAC_sysContext().Database.SqlQuerySmart <dashboardAdmisionesAltas>("usp_IMAC_Dashboard_Admisiones_Get").ToList();
var returnValue = new
{
dietas = tiposDieta.Select(x => new
{
label = x,
value = result.Count(y => y.DietaTipo == x)
}).ToList(),
obrasSociales = new
{
labels = new List <string>()
{
"Días de Internación", "Dietas entregadas", "Días de Internación (Alta)"
}, //obrasSociales.Select(x => x.ObraSocial).ToList(),
datasets = obrasSociales.Select(x => new
{
label = x.ObraSocial,
data = new List <int>()
{
x.DiasInternacion, x.Dietas, x.DiasAlta
}
}).ToList()
},
admalt = new
{
labels = admisionesaltas.Select(x => x.fecha).ToList(),
datasets = admaltDatasets(admisionesaltas)
},
admaltdetalle = new
{
labels = admisionesaltas.Select(x => x.fecha).ToList(),
datasets = admaltDetalleDatasets(admisionesaltas)
}
};
return(returnValue);
}
public static dynamic getSexos()
{
try
{
using (var db = new IMAC_sysContext())
{
var result = db.Database.SqlQuerySmart <Option>("usp_IMAC_TipoSexo_Get").ToList();
return(result.Select(x => new
{
id = x.Id,
text = x.Texto
}));
}
}
catch
{
throw;
}
}
public static dynamic getTiposDocumento()
{
try
{
using (var db = new IMAC_sysContext())
{
var result = db.Database.SqlQuerySmart <Option>("usp_IMAC_TiposDocumento_Get").ToList();
return(result.Select(x => new
{
id = x.Id,
text = x.Texto,
description = x.Descripcion
}));
}
}
catch
{
throw;
}
}
public static appUser UserLogin(string username, string password)
{
username = username.ToLower();
using (var db = new IMAC_usuariosContext())
{
var result = db.Database.SqlQuerySmart <password_with_format>("usp_IMAC_Usuario_GetPaswordHashAndSalt", new
{
ApplicationName = "IMAC",
UserName = username,
UpdateLastLoginActivityDate = true
}).FirstOrDefault();
if (result == null)
{
throw new Exception("User not found");
}
if (result.IsLockedOut)
{
throw new Exception("User locked out");
}
var validated = ValidatePassword(password, result.Password, result.PasswordSalt);
if (!validated)
{
int countToBlock = 3;
if (ConfigurationManager.AppSettings.Get("CountToBlock") != null)
{
Int32.TryParse(ConfigurationManager.AppSettings.Get("CountToBlock"), out countToBlock);
}
var invalidPasswordCount = db.Database.SqlQuerySmart <invalid_password_count_result>("usp_IMAC_Usuario_InvalidPassword", new
{
UserId = result.UserId,
CountToBlock = countToBlock
}).FirstOrDefault();
if (invalidPasswordCount.LockedOut)
{
throw new Exception("User locked out");
}
throw new Exception("Invalid Password");
}
var person = new LoginPerfilGet();
var roles = new List <string>();
if (result.IsApproved)
{
person = new IMAC_sysContext().Database.SqlQuerySmart <LoginPerfilGet>("usp_IMAC_Usuario_LoginPerfilGet", new
{
UserId = result.UserId
}).FirstOrDefault();
roles = db.Database.SqlQuerySmart <string>("aspnet_UsersInRoles_GetRolesForUser", new
{
ApplicationName = "IMAC",
UserName = username
}).ToList();
}
return(new appUser()
{
UserId = result.UserId,
roles = roles,
username = username,
nombre = person != null ? person.Nombre : null,
isApproved = result.IsApproved,
lastlogin = result.LastLoginDate.HasValue ? (result.LastLoginDate.Value.ToShortDateString() + " - " + result.LastLoginDate.Value.ToShortTimeString()) : "",
picture = person != null ? person.Picture : null
});
}
}
