public UnidadDeTrabajo(HeladeriaContext _context)
{
context = _context;
genericDAL = new DALGenericoImpl <T>(context);
// quejaDAL = new DALGenericoImpl<Queja>(context);
// tablaDAL = new DALGenericoImpl<TablaGeneral>(context);
}
public string[] gerRolesForUser(string userName)
{
string[] result;
using (context = new HeladeriaContext())
{
result = context.sp_getRolesForUser(userName).ToArray();
}
return(result);
}
public bool update(int userId, int roleId)
{
int result;
using (context = new HeladeriaContext())
{
result = context.sp_updateRoleByUser(roleId, userId);
}
return(true);
}
public bool isUserInRole(string userName, string roleName)
{
bool result = false;
using (context = new HeladeriaContext())
{
result = context.sp_isUserInRole(userName, roleName) != 0;
}
return(result);
}
public bool insertar(int userId, int roleId)
{
int result;
using (context = new HeladeriaContext())
{
result = context.sp_AddUsersInRoles(userId, roleId);
}
if (result == 1)
{
return(true);
}
return(false);
}
public List <User> getUsuariosRole(string roleName)
{
List <User> result = new List <User>();
List <string> lista;
using (context = new HeladeriaContext())
{
lista = context.sp_getUsuariosRole(roleName).ToList();
User user;
foreach (var item in lista)
{
user = this.getUser(item);
result.Add(user);
}
}
return(result);
}
public DALGenericoImpl(HeladeriaContext context)
{
Context = context;
}
