public async Task <UserPriviledge> GetPriviledgeAsync(int id)
{
var userPriviledge = new UserPriviledge();
SqlConnection conn = new SqlConnection(ConnectionSettings.ConnectionString);
var commandText = string.Format($"SELECT [Id] ,[Name] ,[Description] FROM [dbo].[UserPriviledgeMaster] where Id = '{id}' ");
using (SqlCommand cmd = new SqlCommand(commandText, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
var dataReader = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection);
while (dataReader.Read())
{
userPriviledge.Id = Convert.ToInt32(dataReader["Id"]);
userPriviledge.Name = Convert.ToString(dataReader["Name"]);
userPriviledge.Description = Convert.ToString(dataReader["Description"]);
}
dataReader.Close();
conn.Close();
}
List <UserPriviledgeDetail> userPriviledgeDetails = new List <UserPriviledgeDetail>();
commandText = string.Format($"SELECT UPD.[Id] ,UPD.[UserPriviledgeId] ,UPD.[UserMenuActionId] ,UPD.[IsPermitted],UMAA.MenuId,UM.Menu,UMAA.ActionId,UA.Action FROM [dbo].[UserPriviledgeDetails] UPD INNER JOIN UserMenuActionAssignment UMAA ON UMAA.Id = UPD.UserMenuActionId INNER JOIN UserMenu UM ON UM.Id = UMAA.MenuId INNER JOIN UserAction UA ON UA.ID = UMAA.ActionId where UPD.UserPriviledgeId = '{id}'");
using (SqlCommand cmd1 = new SqlCommand(commandText, conn))
{
cmd1.CommandType = CommandType.Text;
conn.Open();
var dataReader1 = cmd1.ExecuteReader(CommandBehavior.CloseConnection);
while (dataReader1.Read())
{
var userPriviledgeDetail = new UserPriviledgeDetail();
userPriviledgeDetail.Id = Convert.ToInt32(dataReader1["Id"]);
userPriviledgeDetail.UserPriviledgeId = Convert.ToInt32(dataReader1["UserPriviledgeId"]);
userPriviledgeDetail.UserMenuActionId = Convert.ToInt32(dataReader1["UserMenuActionId"]);
userPriviledgeDetail.IsPermitted = Convert.ToBoolean(dataReader1["IsPermitted"]);
userPriviledgeDetail.MenuId = Convert.ToInt32(dataReader1["MenuId"]);
userPriviledgeDetail.Menu = Convert.ToString(dataReader1["Menu"]);
userPriviledgeDetail.ActionId = Convert.ToInt32(dataReader1["ActionId"]);
userPriviledgeDetail.Action = Convert.ToString(dataReader1["Action"]);
userPriviledgeDetails.Add(userPriviledgeDetail);
}
dataReader1.Close();
conn.Close();
}
userPriviledge.UserPriviledgeDetails = userPriviledgeDetails;
return(userPriviledge);
}
public async Task <IEnumerable <UserPriviledgeDetail> > GetRawPriviledgeAsync()
{
var userPriviledgeDetails = new List <UserPriviledgeDetail>();
SqlConnection conn = new SqlConnection(ConnectionSettings.ConnectionString);
var commandText = string.Format($"SELECT UMAS.[Id] ,UMAS.[MenuId],UM.MENU ,UMAS.[ActionId], UA.Action ,UMAS.[IsApplicable],0 as [IsPermitted] FROM [UserMenuActionAssignment] UMAS INNER JOIN USERMENU UM ON UMAS.MenuId = UM.ID INNER JOIN USERACTION UA ON UMAS.ActionId = UA.ID order by UM.MENU,UMAS.[ActionId]");
using (SqlCommand cmd = new SqlCommand(commandText, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
var dataReader = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection);
while (dataReader.Read())
{
var userPriviledgeDetail = new UserPriviledgeDetail();
userPriviledgeDetail.Id = Convert.ToInt32(dataReader["Id"]);
userPriviledgeDetail.UserMenuActionId = Convert.ToInt32(dataReader["Id"]);
userPriviledgeDetail.MenuId = Convert.ToInt32(dataReader["MenuId"]);
userPriviledgeDetail.Menu = Convert.ToString(dataReader["MENU"]);
userPriviledgeDetail.ActionId = Convert.ToInt32(dataReader["ActionId"]);
userPriviledgeDetail.Action = Convert.ToString(dataReader["Action"]);
userPriviledgeDetail.IsApplicable = Convert.ToBoolean(dataReader["IsApplicable"]);
userPriviledgeDetail.IsPermitted = Convert.ToBoolean(dataReader["IsPermitted"]);
userPriviledgeDetails.Add(userPriviledgeDetail);
}
dataReader.Close();
conn.Close();
}
userPriviledgeDetails.OrderBy(x => x.MenuId);
return(userPriviledgeDetails);
}
