public static MenuMasterAuthentication GetMenuMasterAuthentication(MenuMaster MenuMaster)
{
MenuMasterAuthentication result = new MenuMasterAuthentication();
result._MenuMaster = MenuMaster;
MenuMasterPermissionCollection MenuMasterPermissionList = MenuMasterPermissionCollection.GetMenuMasterPermissionCollection();
foreach (MenuMasterPermission item in MenuMasterPermissionList)
{
result._listAuthentication.Add(item, new List <Role>());
}
RoleCollection roleList = RoleCollection.GetRoleCollection();
Database database = new Database("PSCPortalConnectionString");
using (DbConnection connection = database.GetConnection())
{
DbCommand command = database.GetCommand(connection);
#region MenuMasterId
DbParameter prMenuMasterId = database.GetParameter(System.Data.DbType.Guid, "@MenuMasterId", MenuMaster.Id);
command.Parameters.Add(prMenuMasterId);
#endregion
command.CommandText = "MenuMasterAuthentication_GetAllByMenuMasterId";
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
DbDataReader reader = command.ExecuteReader();
int idtptemp;
Guid idrtemp;
MenuMasterPermission tptemp;
Role rtemp;
while (reader.Read())
{
idtptemp = (int)reader["MenuMasterPermissionId"];
idrtemp = (Guid)reader["RoleId"];
tptemp = MenuMasterPermissionList.Where(tp => tp.Id == idtptemp).Single();
rtemp = roleList.Where(r => r.Id == idrtemp).Single();
result._listAuthentication[tptemp].Add(rtemp);
}
}
return(result);
}
public static MenuMasterPermissionCollection GetMenuMasterPermissionCollection()
{
MenuMasterPermissionCollection result = new MenuMasterPermissionCollection();
Database database = new Database("PSCPortalConnectionString");
using (DbConnection connection = database.GetConnection())
{
DbCommand command = database.GetCommand(connection);
command.CommandText = "MenuMasterPermission_GetAll";
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
result.Add(new MenuMasterPermission(reader));
}
}
}
return(result);
}
