public SiteRolesInfo GetModel(Guid id)
{
SiteRolesInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 ApplicationId,Id,Named,LowerName,LastUpdatedDate
from SiteRoles
where Id = @Id " );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier)
};
parms[0].Value = id;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new SiteRolesInfo();
model.ApplicationId = reader.GetGuid(0);
model.Id = reader.GetGuid(1);
model.Named = reader.GetString(2);
model.LowerName = reader.GetString(3);
model.LastUpdatedDate = reader.GetDateTime(4);
}
}
}
return(model);
}
public SiteRolesInfo GetAspnetModel(string appName, string name)
{
SiteRolesInfo model = null;
var sb = new StringBuilder(300);
sb.Append(@"select top 1 ApplicationId,RoleId,RoleName,LoweredRoleName
from aspnet_Roles where ApplicationId = @ApplicationId and LoweredRoleName = @Named " );
SqlParameter[] parms =
{
new SqlParameter("@ApplicationId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Named", SqlDbType.NVarChar, 50)
};
parms[0].Value = Guid.Parse(new Applications().GetAspnetAppId(appName).ToString());
parms[1].Value = name;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new SiteRolesInfo();
model.ApplicationId = reader.GetGuid(0);
model.Id = reader.GetGuid(1);
model.Named = reader.GetString(2);
model.LowerName = reader.GetString(3);
}
}
}
return(model);
}
public List <SiteRolesInfo> GetAspnetList(string sqlWhere, params SqlParameter[] cmdParms)
{
var sb = new StringBuilder(500);
sb.Append("select RoleId,RoleName from aspnet_Roles ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
var list = new List <SiteRolesInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
var model = new SiteRolesInfo();
model.Id = reader.GetGuid(0);
model.Named = reader.GetString(1);
list.Add(model);
}
}
}
return(list);
}
public SiteRolesInfo GetModel(string name)
{
SiteRolesInfo model = null;
var sb = new StringBuilder(300);
sb.Append(@"select top 1 ApplicationId,Id,Named,LowerName,LastUpdatedDate
from SiteRoles
where Named = @Named " );
SqlParameter[] parms =
{
new SqlParameter("@Named", SqlDbType.NVarChar, 50)
};
parms[0].Value = name;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new SiteRolesInfo();
model.ApplicationId = reader.GetGuid(0);
model.Id = reader.GetGuid(1);
model.Named = reader.GetString(2);
model.LowerName = reader.GetString(3);
model.LastUpdatedDate = reader.GetDateTime(4);
}
}
}
return(model);
}
public SiteRolesInfo GetAspnetModel(string appName, string name)
{
SiteRolesInfo model = null;
var sb = new StringBuilder(300);
sb.Append(@"select top 1 r.ApplicationId,r.RoleId,r.RoleName,r.LoweredRoleName
from aspnet_Roles r
join aspnet_Applications a on a.ApplicationId = r.ApplicationId
where a.ApplicationName = @AppName and LoweredRoleName = @Named ");
SqlParameter[] parms =
{
new SqlParameter("@AppName", SqlDbType.NVarChar, 256),
new SqlParameter("@Named", SqlDbType.NVarChar, 50)
};
parms[0].Value = appName;
parms[1].Value = name;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AspnetDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new SiteRolesInfo();
model.ApplicationId = reader.GetGuid(0);
model.Id = reader.GetGuid(1);
model.Named = reader.GetString(2);
model.LowerName = reader.GetString(3);
}
}
}
return(model);
}
public override void CreateRole(string roleName)
{
var bll = new SiteRoles();
var appId = Guid.Parse(new Applications().GetApplicationId(ApplicationName).ToString());
var model = new SiteRolesInfo(appId, Guid.Empty, roleName, roleName.ToLower(), DateTime.Now);
bll.Insert(model);
}
public int UpdateAspnetRoles(SiteRolesInfo model)
{
var oldInfo = _db.SiteRoles.FindById(model.Id);
if (oldInfo != null)
{
oldInfo.Named = model.Named;
return(_db.SiteRoles.Update(oldInfo) ? 1 : 0);
}
return(0);
}
public IList <SiteRolesInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(500);
sb.Append(@"select count(*) from SiteRoles ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), cmdParms);
if (totalRecords == 0)
{
return(new List <SiteRolesInfo>());
}
sb.Clear();
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
ApplicationId,Id,Named,LowerName,LastUpdatedDate
from SiteRoles " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <SiteRolesInfo> list = new List <SiteRolesInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
SiteRolesInfo model = new SiteRolesInfo();
model.ApplicationId = reader.GetGuid(1);
model.Id = reader.GetGuid(2);
model.Named = reader.GetString(3);
model.LowerName = reader.GetString(4);
model.LastUpdatedDate = reader.GetDateTime(5);
list.Add(model);
}
}
}
return(list);
}
public ResResultModel SaveRole(RoleModel model)
{
try
{
if (!HttpContext.Current.User.IsInRole("Administrators"))
{
throw new ArgumentException(MC.Role_InvalidError);
}
model.RoleName = model.RoleName.Trim();
if (string.IsNullOrEmpty(model.RoleName))
{
return(ResResult.Response(false, MC.Request_Params_InvalidError, ""));
}
if (Roles.RoleExists(model.RoleName))
{
return(ResResult.Response(false, MC.Data_ExistError, ""));
}
Guid gId = Guid.Empty;
if (model.RoleId != null)
{
Guid.TryParse(model.RoleId.ToString(), out gId);
}
var bll = new SiteRoles();
var modelInfo = new SiteRolesInfo(Guid.Empty, gId, model.RoleName, model.UserName, DateTime.Now);
if (!gId.Equals(Guid.Empty))
{
if (modelInfo.Named == "Administrators" || modelInfo.Named == "System" || modelInfo.Named == "Users" || modelInfo.Named == "Guest")
{
return(ResResult.Response(false, MC.M_SysDataChangedError, ""));
}
bll.UpdateAspnetRoles(modelInfo);
}
else
{
Roles.CreateRole(model.RoleName);
}
return(ResResult.Response(true, "", ""));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public int UpdateAspnetRoles(SiteRolesInfo model)
{
string cmdText = @"update aspnet_Roles set RoleName = @RoleName,LoweredRoleName = Lower(@RoleName) where RoleId = @RoleId";
SqlParameter[] parms =
{
new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier),
new SqlParameter("@RoleName", SqlDbType.NVarChar, 256),
};
parms[0].Value = Guid.Parse(model.Id.ToString());
parms[1].Value = model.Named;
return(SqlHelper.ExecuteNonQuery(SqlHelper.AspnetDbConnString, CommandType.Text, cmdText, parms));
}
public int UpdateAspnetRoles(SiteRolesInfo model)
{
return(dal.UpdateAspnetRoles(model));
}
public int Update(SiteRolesInfo model)
{
return(dal.Update(model));
}
public int InsertByOutput(SiteRolesInfo model)
{
return(dal.InsertByOutput(model));
}
public int Insert(SiteRolesInfo model)
{
throw new NotImplementedException();
}
public int Update(SiteRolesInfo model)
{
throw new NotImplementedException();
}
