public List <MenuMasterEn> GetMenuMasterList()
{
List <MenuMasterEn> loEnList = new List <MenuMasterEn>();
string sqlCmd = "SELECT * FROM UR_MenuMaster";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
MenuMasterEn loItem = LoadObjectMenuMaster(loReader);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
private MenuMasterEn LoadObjectMenuMaster(IDataReader argReader)
{
MenuMasterEn loItem = new MenuMasterEn();
loItem.MenuID = GetValue <int>(argReader, "menuid");
loItem.MenuName = GetValue <string>(argReader, "menuname");
loItem.PageName = GetValue <string>(argReader, "pagename");
loItem.PageDescription = GetValue <string>(argReader, "pagedescription");
loItem.PageUrl = GetValue <string>(argReader, "pageurl");
loItem.ImageUrl = GetValue <string>(argReader, "imageurl");
loItem.Status = GetValue <bool>(argReader, "status");
loItem.PageOrder = GetValue <int>(argReader, "pageorder");
loItem.LastUpdatedBy = GetValue <string>(argReader, "lastupdatedby");
loItem.LastUpdatedDtTm = GetValue <DateTime>(argReader, "lastupdateddttm");
return(loItem);
}
public List <MenuMasterEn> GetMenuMasterAdmin(string MenuName, int UserGroupID)
{
#region Declarations
//Create Instances - Start
MenuMasterEn MenuDetails = new MenuMasterEn();
List <MenuMasterEn> MenuList = new List <MenuMasterEn>();
//Create Instances - Stop
//variable declarations
string SqlStatement = null;
#endregion
try
{
SqlStatement = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_MenuMaster.PageDescription, " +
" UR_MenuMaster.PageUrl, UR_MenuMaster.ImageUrl, UR_MenuMaster.Status, UR_MenuMaster.PageOrder, UR_MenuMaster.LastUpdatedBy, " +
" UR_MenuMaster.LastUpdatedDtTm, UR_UserRights.IsAdd, UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, " +
" UR_UserRights.IsPrint, UR_UserRights.IsPost, UR_UserRights.IsOthers FROM UR_MenuMaster INNER JOIN UR_UserRights " +
" ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE UR_UserRights.UserGroupId = " + UserGroupID +
" AND UR_MenuMaster.MenuName = " + clsGeneric.AddQuotes(MenuName) + " AND UR_MenuMaster.Status = 'true' " +
" ORDER BY UR_MenuMaster.PageOrder";
IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString,
SqlStatement).CreateDataReader();
if (_IDataReader != null)
{
while (_IDataReader.Read())
{
MenuDetails = LoadMenuObject(_IDataReader);
MenuList.Add(MenuDetails);
}
_IDataReader.Close();
_IDataReader.Dispose();
return(MenuList);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public List <MenuMasterEn> GetPreparerWorkflowList(string MenuName, int UserID, int UserGroupId)
{
MenuMasterEn _MenuMasterEn = new MenuMasterEn();
List <MenuMasterEn> list = new List <MenuMasterEn>();
try
{
string SqlStatement = @"SELECT mm.MenuID, mm.MenuName, mm.PageName, mm.PageDescription, mm.PageUrl, mm.ImageUrl, mm.Status, mm.PageOrder, mm.LastUpdatedBy,
mm.LastUpdatedDtTm, ur.IsAdd, ur.IsEdit, ur.IsDelete, ur.IsView, ur.IsPrint, ur.IsPost, ur.IsOthers
FROM ur_usermenu_preparer prep
INNER JOIN ur_menumaster mm ON mm.menuid = prep.menuid
INNER JOIN ur_userrights ur ON ur.usergroupid = (SELECT usergroupid FROM ur_users WHERE userid = prep.userid)
AND prep.menuid = ur.menuid
WHERE prep.userid = " + UserID + @" AND ur.usergroupid = " + UserGroupId + @"
AND mm.menuname = " + clsGeneric.AddQuotes(MenuName) + @" AND mm.status = 'true'
AND mm.menuid <> 114
ORDER BY mm.pageorder ";
IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, SqlStatement).CreateDataReader();
if (_IDataReader != null)
{
while (_IDataReader.Read())
{
_MenuMasterEn = LoadMenuObject(_IDataReader);
list.Add(_MenuMasterEn);
}
_IDataReader.Close();
_IDataReader.Dispose();
return(list);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Load MenuMaster Entity
/// </summary>
/// <param name="argReader">IDataReader Object is an Input.</param>
/// <returns>Returns MenuMaster Entity</returns>
private MenuMasterEn LoadMenuObject(IDataReader argReader)
{
MenuMasterEn loItem = new MenuMasterEn();
loItem.MenuID = GetValue <int>(argReader, "MenuID");
loItem.MenuName = GetValue <string>(argReader, "MenuName");
loItem.PageName = GetValue <string>(argReader, "PageName");
loItem.PageDescription = GetValue <string>(argReader, "PageDescription");
loItem.PageUrl = GetValue <string>(argReader, "PageUrl");
loItem.ImageUrl = GetValue <string>(argReader, "ImageUrl");
loItem.Status = GetValue <bool>(argReader, "Status");
loItem.PageOrder = GetValue <int>(argReader, "PageOrder");
loItem.LastUpdatedBy = GetValue <string>(argReader, "LastUpdatedBy");
loItem.LastUpdatedDtTm = GetValue <DateTime>(argReader, "LastUpdatedDtTm");
loItem.IsAdd = GetValue <bool>(argReader, "IsAdd");
loItem.IsEdit = GetValue <bool>(argReader, "IsEdit");
loItem.IsDelete = GetValue <bool>(argReader, "IsDelete");
loItem.IsView = GetValue <bool>(argReader, "IsView");
loItem.IsPrint = GetValue <bool>(argReader, "IsPrint");
loItem.IsPost = GetValue <bool>(argReader, "IsPost");
loItem.IsOthers = GetValue <bool>(argReader, "IsOthers");
return(loItem);
}
/// <summary>
/// Method to Get List of All UserRights by UserID
/// </summary>
/// <param name="UserGroupID">UserID as an Input.</param>
/// <returns>Returns List of UserRights</returns>
public List <UserRightsEn> GetMenuByUser(int UserID)
{
List <UserRightsEn> loEnList = new List <UserRightsEn>();
string sqlCmd = null;
//Create Instances - Start
MenuMasterEn MenuDetails = new MenuMasterEn();
List <MenuMasterEn> MenuList = new List <MenuMasterEn>();
//Create Instances - Stop
if (UserID > 0)
{
//sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_UserRights.IsAdd, " +
//"UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, UR_UserRights.IsPost, UR_UserRights.IsPrint," +
//"UR_UserRights.DefaultMode FROM UR_MenuMaster INNER JOIN " +
//"UR_UserRights ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE " +
//"UR_MenuMaster.Status = true AND UR_MenuMaster.MenuID <> 114 AND " +
//"UR_UserRights.UserId =" + UserID + " order by UR_MenuMaster.MenuName desc";
//sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " +
sqlCmd = "SELECT UR_MenuMaster.MenuID " +
"FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " +
"AND UR_MenuMaster.MenuID IN (SELECT MenuID from ur_usermenu WHERE UserId = " + UserID + ") " +
"ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder";
}
else
{
sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " +
"FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " +
"ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder";
}
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
if (UserID > 0)
{
UserRightsEn loItem = new UserRightsEn();
loItem.MenuID = GetValue <int>(loReader, "MenuID");
//loItem.MenuName = GetValue<string>(loReader, "MenuName");
//loItem.PageName = GetValue<string>(loReader, "PageName");
loEnList.Add(loItem);
}
else
{
UserRightsEn loMenuItem = LoadURMenu(loReader);
loMenuItem.MenuID = GetValue <int>(loReader, "MenuID");
loMenuItem.MenuName = GetValue <string>(loReader, "MenuName");
loMenuItem.PageName = GetValue <string>(loReader, "PageName");
//loMenuItem.IsAdd = false;
//loMenuItem.IsEdit = false;
//loMenuItem.IsDelete = false;
//loMenuItem.IsView = false;
//loMenuItem.IsPrint = false;
//loMenuItem.IsPost = false;
//loMenuItem.IsAddModeDefault = false;
loEnList.Add(loMenuItem);
}
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Get List of Menus By UserGroups
/// </summary>
/// <param name="MenuName">MenuName is an Input.</param>
/// <param name="UserGroupID">UserGroupID is an Input.</param>
/// <returns>Returns List of Menus</returns>
public List <MenuMasterEn> GetMenuByWorkflowGroup(string MenuName, int UserGroupID, int UserID)
{
#region Declarations
//Create Instances - Start
MenuMasterEn MenuDetails = new MenuMasterEn();
List <MenuMasterEn> MenuList = new List <MenuMasterEn>();
//Create Instances - Stop
//variable declarations
string SqlStatement = null;
#endregion
try
{
//Build Sql Statement - Start
SqlStatement = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_MenuMaster.PageDescription, " +
" UR_MenuMaster.PageUrl, UR_MenuMaster.ImageUrl, UR_MenuMaster.Status, UR_MenuMaster.PageOrder, UR_MenuMaster.LastUpdatedBy, " +
" UR_MenuMaster.LastUpdatedDtTm, UR_UserRights.IsAdd, UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, " +
" UR_UserRights.IsPrint, UR_UserRights.IsPost, UR_UserRights.IsOthers FROM UR_MenuMaster INNER JOIN UR_UserRights " +
" ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE UR_UserRights.UserGroupId = " + UserGroupID +
" AND UR_MenuMaster.MenuName = " + clsGeneric.AddQuotes(MenuName) + " AND UR_MenuMaster.Status = 'true' ";
if (MenuName == "Setup")
{
SqlStatement += " AND UR_MenuMaster.MenuID = 13";
}
if (MenuName == "Process")
{
SqlStatement += " AND UR_MenuMaster.MenuID = 114";
//SqlStatement += " AND UR_MenuMaster.MenuID IN (SELECT MenuID from ur_usermenu WHERE userid = " + UserID + ") ";
}
if (MenuName == "Reports")
{
SqlStatement += " AND UR_MenuMaster.MenuID = 18";
}
SqlStatement += " ORDER BY UR_MenuMaster.PageOrder";
//Build Sql Statement - Stop
//Get User Login Details - Start
IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString,
SqlStatement).CreateDataReader();
//Get User Login Details - Stop
//if user login details available - Start
if (_IDataReader != null)
{
while (_IDataReader.Read())
{
//load data to entities
MenuDetails = LoadMenuObject(_IDataReader);
MenuList.Add(MenuDetails);
}
_IDataReader.Close();
_IDataReader.Dispose();
return(MenuList);
}
//if user login details available - Stop
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
