/// <summary>
/// Creates a new instance of the UsersInRoles class and populates it with data from the specified SqlDataReader.
/// </summary>
private static UserInRol MakeUsersInRole(IDataReader dataReader)
{
UserInRol usersInRole = new UserInRol();
if (dataReader.IsDBNull(0) == false)
{
usersInRole.UserId = dataReader.GetGuid(0);
}
if (dataReader.IsDBNull(1) == false)
{
usersInRole.RoleId = dataReader.GetGuid(1);
}
return(usersInRole);
}
/// <summary>
/// Selects records from the UsersInRoles table by a foreign key.
/// <summary>
/// <param name="userId"></param>
/// <returns>DataSet</returns>
public List <UserInRol> SelectByUserId(Guid userId)
{
Database db = DatabaseFactory.CreateDatabase(CommonENT.MYCTSDBSECURITY_CONNECTION);
DbCommand dbCommand = db.GetStoredProcCommand("spUsersInRolesSelectByUserId");
db.AddInParameter(dbCommand, "UserId", DbType.Guid, userId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
List <UserInRol> usersInRoleList = new List <UserInRol>();
while (dataReader.Read())
{
UserInRol usersInRole = MakeUsersInRole(dataReader);
usersInRoleList.Add(usersInRole);
}
return(usersInRoleList);
}
}
public bool Modificar(Usuario user)
{
Usuario u = ctx.Usuario.Single(c => c.id_user == user.id_user);
u.Rut = user.Rut;
u.Nombre_usuario = user.Nombre_usuario;
u.Apellido_usuario = user.Apellido_usuario;
u.Email_usuario = user.Email_usuario;
u.Telefono_usuario = user.Telefono_usuario;
u.Sexo = user.Sexo;
u.Contrasena = user.Contrasena;
u.Tipo = user.Tipo;
UserInRol urol = ctx.UserInRol.Single(c => c.id_user == user.id_user);
urol.id_rol = user.Tipo;
ctx.SaveChanges();
return(true);
}
public bool Ingresar(Usuario user)
{
try
{
ctx.Usuario.Add(user);
ctx.SaveChanges();
UserInRol UserInROL = new UserInRol();
UserInROL.id_rol = (user.Tipo);
UserInROL.id_user = user.id_user;
ctx.UserInRol.Add(UserInROL);
ctx.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
