public Sys_UserInRole Find(Int32 id)
{
String stmtId = "Sys_UserInRole.Find";
Sys_UserInRole result = SqlMapper.QueryForObject <Sys_UserInRole>(stmtId, id);
return(result);
}
public bool RemoveUsersFromRoles(string applicationName, string[] usernames, string[] rolenames)
{
bool b = false;
try {
SqlMapper.BeginTransaction();
foreach (string username in usernames)
{
foreach (string rolename in rolenames)
{
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.UserName = username;
ur.RoleName = rolename;
Delete(ur);
}
}
SqlMapper.CommitTransaction();
b = true;
}
catch (Exception ex) {
SqlMapper.RollBackTransaction();
throw ex;
}
return(b);
}
public string[] FindUsersInRole(string applicationName, string roleName, string usernameToMatch)
{
String stmtId = "Sys_UserInRole.FindUsersInRole";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.RoleName = roleName;
ur.UserName = usernameToMatch;
IList <Sys_UserInRole> list = SqlMapper.QueryForList <Sys_UserInRole>(stmtId, ur);
if (list.Count > 0)
{
string[] result = new string[list.Count];
int i = 0;
foreach (Sys_UserInRole t in list)
{
result[i] = t.UserName;
i++;
}
return(result);
}
else
{
return(new string[0]);
}
}
public bool Delete(Sys_UserInRole ur)
{
String stmtId = "Sys_UserInRole.DeleteByName";
if (SqlMapper.Update(stmtId, ur) > 0) {
return true;
}
else return false;
}
public IList <Sys_UserInRole> GetUsersInRole(string applicationName, string roleName)
{
String stmtId = "Sys_UserInRole.GetUsersInRole";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.RoleName = roleName;
IList <Sys_UserInRole> result = SqlMapper.QueryForList <Sys_UserInRole>(stmtId, ur);
return(result);
}
public IList <Sys_UserInRole> GetRolesForUser(string applicationName, string userName)
{
String stmtId = "Sys_UserInRole.GetRolesForUser";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.UserName = userName;
IList <Sys_UserInRole> result = SqlMapper.QueryForList <Sys_UserInRole>(stmtId, ur);
return(result);
}
public bool Delete(Sys_UserInRole ur)
{
String stmtId = "Sys_UserInRole.DeleteByName";
if (SqlMapper.Update(stmtId, ur) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(Sys_UserInRole obj)
{
if (obj == null)
{
throw new ArgumentNullException("obj");
}
String stmtId = "Sys_UserInRole.Update";
if (SqlMapper.Update(stmtId, obj) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool IsUserInRole(string applicationName, string userName, string roleName)
{
String stmtId = "Sys_UserInRole.IsUserInRole";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.RoleName = roleName;
ur.UserName = userName;
int result = SqlMapper.QueryForObject <int>(stmtId, ur);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddUsersToRoles(string applicationName, string[] usernames, string[] rolenames)
{
bool b = false;
try {
SqlMapper.BeginTransaction();
foreach (string username in usernames) {
foreach (string rolename in rolenames) {
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.UserName = username;
ur.RoleName = rolename;
Insert(ur);
}
}
SqlMapper.CommitTransaction();
b = true;
}
catch (Exception ex) {
SqlMapper.RollBackTransaction();
throw ex;
}
return b;
}
public string[] FindUsersInRole(string applicationName, string roleName, string usernameToMatch)
{
String stmtId = "Sys_UserInRole.FindUsersInRole";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.RoleName = roleName;
ur.UserName = usernameToMatch;
IList<Sys_UserInRole> list = SqlMapper.QueryForList<Sys_UserInRole>(stmtId, ur);
if (list.Count > 0) {
string[] result = new string[list.Count];
int i = 0;
foreach (Sys_UserInRole t in list) {
result[i] = t.UserName;
i++;
}
return result;
}
else { return new string[0]; }
}
public bool Update(Sys_UserInRole obj)
{
if (obj == null) throw new ArgumentNullException("obj");
String stmtId = "Sys_UserInRole.Update";
if (SqlMapper.Update(stmtId, obj) > 0) {
return true;
}
else return false;
}
public bool IsUserInRole(string applicationName, string userName, string roleName)
{
String stmtId = "Sys_UserInRole.IsUserInRole";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.RoleName = roleName;
ur.UserName = userName;
int result = SqlMapper.QueryForObject<int>(stmtId, ur);
if (result > 0) {
return true;
}
else return false;
}
public IList<Sys_UserInRole> GetUsersInRole(string applicationName, string roleName)
{
String stmtId = "Sys_UserInRole.GetUsersInRole";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.RoleName = roleName;
IList<Sys_UserInRole> result = SqlMapper.QueryForList<Sys_UserInRole>(stmtId, ur);
return result;
}
public IList<Sys_UserInRole> GetRolesForUser(string applicationName, string userName)
{
String stmtId = "Sys_UserInRole.GetRolesForUser";
Sys_UserInRole ur = new Sys_UserInRole();
ur.ApplicationName = applicationName;
ur.UserName = userName;
IList<Sys_UserInRole> result = SqlMapper.QueryForList<Sys_UserInRole>(stmtId, ur);
return result;
}