public UsersInRolesInfo GetModel(Guid userId, Guid roleId)
{
UsersInRolesInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 UserId,RoleId
from UsersInRoles
where UserId = @UserId and RoleId = @RoleId " );
SqlParameter[] parms =
{
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier)
};
parms[0].Value = userId;
parms[1].Value = roleId;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.QdhtyyDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new UsersInRolesInfo();
model.UserId = reader.GetGuid(0);
model.RoleId = reader.GetGuid(1);
}
}
}
return(model);
}
public override void AddUsersToRoles(string[] usernames, string[] roleNames)
{
var uBll = new SiteUsers();
var rBll = new SiteRoles();
var urBll = new UsersInRoles();
foreach (var uItem in usernames)
{
var uInfo = uBll.GetModel(uItem);
foreach (var rItem in roleNames)
{
var rInfo = rBll.GetModel(rItem);
var urInfo = new UsersInRolesInfo(uInfo.Id, rInfo.Id);
urBll.Insert(urInfo);
}
}
}
public int Insert(UsersInRolesInfo model)
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"insert into UsersInRoles (UserId,RoleId)
values
(@UserId,@RoleId)
" );
SqlParameter[] parms =
{
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier)
};
parms[0].Value = model.UserId;
parms[1].Value = model.RoleId;
return(SqlHelper.ExecuteNonQuery(SqlHelper.QdhtyyDbConnString, CommandType.Text, sb.ToString(), parms));
}
public int Insert(UsersInRolesInfo model)
{
return(dal.Insert(model));
}
