public static RoleWiseModule GetRoleWiseModuleByID(int id)
{
RoleWiseModule roleWiseModule = new RoleWiseModule();
SqlRoleWiseModuleProvider sqlRoleWiseModuleProvider = new SqlRoleWiseModuleProvider();
roleWiseModule = sqlRoleWiseModuleProvider.GetRoleWiseModuleByID(id);
return roleWiseModule;
}
protected void btnRemoveModule_Click(object sender, EventArgs e)
{
int _selectedIndex = lbxRoleWiseModules.SelectedIndex;
while (lbxRoleWiseModules.SelectedIndex >= 0)
{
RoleWiseModule roleWiseModule = new RoleWiseModule();
//roleWiseModule = RoleWiseModuleManager.GetRoleWiseModuleByID(Int32.Parse(lbxRoleWiseModules.SelectedValue));
roleWiseModule.RoleID = ddlRole.SelectedValue;
roleWiseModule.ModuleID = Convert.ToInt32(lbxRoleWiseModules.SelectedValue);
roleWiseModule.AddedBy = "";
roleWiseModule.AddedDate = DateTime.Now;
roleWiseModule.UpdatedBy = "Admin";
roleWiseModule.UpdatedDate = DateTime.Now;
roleWiseModule.RowStatusID = (int)Enums.RowStatus.Deleted;
bool result = RoleWiseModuleManager.UpdateRoleWiseModule(roleWiseModule);
if (result)
{
lbxModules.Items.Add(lbxRoleWiseModules.SelectedItem);
lbxRoleWiseModules.Items.RemoveAt(_selectedIndex);
}
else
continue;
}
_sortList(lbxModules);
}
protected void btnAddModule_Click(object sender, EventArgs e)
{
if (ddlRole.SelectedIndex > 0)
{
try
{
int _selectedIndex = lbxModules.SelectedIndex;
while (lbxModules.SelectedIndex >= 0)
{
RoleWiseModule roleWiseModule = new RoleWiseModule();
roleWiseModule.ModuleID = Int32.Parse(lbxModules.SelectedValue);
roleWiseModule.RoleID = ddlRole.SelectedValue;
roleWiseModule.AddedBy = "Admin";
roleWiseModule.AddedDate = DateTime.Now;
roleWiseModule.UpdatedBy = "Admin";
roleWiseModule.UpdatedDate = DateTime.Now;
roleWiseModule.RowStatusID = (int)Enums.RowStatus.Active;
int resutl = RoleWiseModuleManager.InsertRoleWiseModule(roleWiseModule);
if (resutl > 0)
{
lbxRoleWiseModules.Items.Add(lbxModules.SelectedItem);
lbxModules.Items.RemoveAt(_selectedIndex);
}
else
continue;
}
_sortList(lbxModules);
_sortList(lbxRoleWiseModules);
if (lbxModules.Items.Count == _selectedIndex)
lbxModules.SelectedIndex = _selectedIndex - 1;
else
lbxModules.SelectedIndex = _selectedIndex;
lbxRoleWiseModules.SelectedIndex = -1;
}
catch (Exception ex)
{
}
}
}
private void _loadSideMenu(RoleWiseModule r_module, string roleID)
{
try
{
List<DisplayMenu> displayMenus = DisplayMenuManager.GetDisplayMenuByModuleNRole(r_module.ModuleID, roleID);
List<DisplayMenu> rootMenus = new List<DisplayMenu>();
rootMenus = displayMenus.FindAll(X => X.ParentMenuID == 0);
displayMenus.RemoveAll(X => X.ParentMenuID == 0);
string sideMenu = string.Empty;
sideMenu = "<h3 class=\"sidebarHead\">" + r_module.ModuleName + "</h3>";
sideMenu += "<div class=\"sideBarInner\">";
sideMenu += "<ul><li><ul class=\"innernav\">";
foreach (DisplayMenu rm in rootMenus)
{
sideMenu += "<li style=\"background: #e5e5e5;\"><a href=\"" + rm.PageURL + "\">" + rm.MenuTitle + "</a>";
sideMenu += "<ul>";
List<DisplayMenu> childMenus = displayMenus.FindAll(X => X.ParentMenuID == rm.MenuID);
displayMenus.RemoveAll(X => X.ParentMenuID == rm.MenuID);
foreach (DisplayMenu cm in childMenus)
{
sideMenu += "<li style=\"background: #e5e5e5;\"><a href=\"../" + cm.PageURL + "\">" + cm.MenuTitle + "</a></li>";
}
sideMenu += "</ul></li>";
}
foreach (DisplayMenu dm in displayMenus)
{
sideMenu += "<li style=\"background: #e5e5e5;\"><a href=\"../" + dm.PageURL + "\">" + dm.MenuTitle + "</a></li>";
}
sideMenu += "</ul><li></ul></div>";
litSideMenu.Text = sideMenu;
}
catch (Exception ex)
{
}
}
public static bool UpdateRoleWiseModule(RoleWiseModule roleWiseModule)
{
SqlRoleWiseModuleProvider sqlRoleWiseModuleProvider = new SqlRoleWiseModuleProvider();
return sqlRoleWiseModuleProvider.UpdateRoleWiseModule(roleWiseModule);
}
public static int InsertRoleWiseModule(RoleWiseModule roleWiseModule)
{
SqlRoleWiseModuleProvider sqlRoleWiseModuleProvider = new SqlRoleWiseModuleProvider();
return sqlRoleWiseModuleProvider.InsertRoleWiseModule(roleWiseModule);
}
public RoleWiseModule GetRoleWiseModuleFromReader(IDataReader reader)
{
try
{
RoleWiseModule roleWiseModule = new RoleWiseModule
(
(int)reader["RoleWiseModuleID"],
(int)reader["ModuleID"],
reader["RoleID"].ToString(),
reader["AddedBy"].ToString(),
(DateTime)reader["AddedDate"],
reader["UpdatedBy"].ToString(),
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
return roleWiseModule;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateRoleWiseModule(RoleWiseModule roleWiseModule)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("USER_RoleWiseModule_Update", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RoleWiseModuleID", SqlDbType.Int).Value = roleWiseModule.RoleWiseModuleID;
cmd.Parameters.Add("@ModuleID", SqlDbType.Int).Value = roleWiseModule.ModuleID;
cmd.Parameters.Add("@RoleID", SqlDbType.NVarChar).Value = roleWiseModule.RoleID;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = roleWiseModule.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = roleWiseModule.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = roleWiseModule.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = roleWiseModule.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = roleWiseModule.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
