private async Task GetGroupsEntities(SqlConnection connection1, String userId, Dictionary <string, LoadRightsModel> rightModel)
{
SqlCommand cmd = new SqlCommand();
string cmdString = "SELECT m.entitie, gm.isquery, gm.isedit, gm.isnew, gm.isdelete, m.id FROM UsersGroups ug " +
"left join groups g on ug.idgroup = g.id " +
"left join groupsmenu gm on ug.idgroup = gm.idgroup " +
"left join menu m on gm.idmenu = m.id " +
"where ug.iduser = @iduser and ug.isChecked = 1 and g.status = 1 and m.status = 1";
cmd.CommandText = cmdString;
cmd.Connection = connection1;
SqlParameter parameter = new SqlParameter("@iduser", SqlDbType.VarChar);
parameter.Value = userId;
cmd.Parameters.Add(parameter);
SqlDataReader reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
LoadRightsModel model = new LoadRightsModel();
model.identitie = reader.GetString(0);
model.isquery = reader.GetInt32(1);
model.isedit = reader.GetInt32(2);
model.isnew = reader.GetInt32(3);
model.isdelete = reader.GetInt32(4);
model.idmenu = reader.GetString(5);
if (rightModel.ContainsKey(model.identitie))
{
if (rightModel[model.identitie].isquery < model.isquery)
{
rightModel[model.identitie].isquery = model.isquery;
}
if (rightModel[model.identitie].isedit < model.isedit)
{
rightModel[model.identitie].isedit = model.isedit;
}
if (rightModel[model.identitie].isnew < model.isnew)
{
rightModel[model.identitie].isnew = model.isnew;
}
if (rightModel[model.identitie].isdelete < model.isdelete)
{
rightModel[model.identitie].isdelete = model.isdelete;
}
}
else
{
rightModel.Add(model.identitie, model);
}
}
reader.Close();
}
private async Task <int> AddUsersEntities(SqlConnection connection1, String userId, LoadRightsModel model)
{
SqlCommand cmd = new SqlCommand();
string cmdString = "insert into UserRights (iduser, idmenu, entitie, isquery, isedit, isnew, isdelete) " +
"Values(@iduser, @idmenu, @entitie, @isquery, @isedit, @isnew, @isdelete)";
cmd.CommandText = cmdString;
cmd.Connection = connection1;
SqlParameter parameter = new SqlParameter("@iduser", SqlDbType.VarChar);
parameter.Value = userId;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@idmenu", SqlDbType.VarChar);
parameter.Value = model.idmenu;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@entitie", SqlDbType.VarChar);
parameter.Value = model.identitie;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isquery", SqlDbType.Int);
parameter.Value = model.isquery;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isedit", SqlDbType.Int);
parameter.Value = model.isedit;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isnew", SqlDbType.Int);
parameter.Value = model.isnew;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isdelete", SqlDbType.Int);
parameter.Value = model.isdelete;
cmd.Parameters.Add(parameter);
return(await cmd.ExecuteNonQueryAsync());
}
private async Task <int> UpdateUsersEntities(SqlConnection connection1, String userId, LoadRightsModel model)
{
SqlCommand cmd = new SqlCommand();
string cmdString = "update UserRights set isquery = @isquery, isedit = @isedit, isnew = @isnew, isdelete = @isdelete " +
"where iduser = @iduser and entitie = @entitie";
cmd.CommandText = cmdString;
cmd.Connection = connection1;
SqlParameter parameter = new SqlParameter("@iduser", SqlDbType.VarChar);
parameter.Value = userId;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@entitie", SqlDbType.VarChar);
parameter.Value = model.identitie;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isquery", SqlDbType.Int);
parameter.Value = model.isquery;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isedit", SqlDbType.Int);
parameter.Value = model.isedit;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isnew", SqlDbType.Int);
parameter.Value = model.isnew;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@isdelete", SqlDbType.Int);
parameter.Value = model.isdelete;
cmd.Parameters.Add(parameter);
return(await cmd.ExecuteNonQueryAsync());
}
