protected void btnUpdate_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null)
{
Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx");
}
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
ButtonRole buttonRole = new ButtonRole();
buttonRole = ButtonRoleManager.GetButtonRoleByID(Int32.Parse(Request.QueryString["buttonRoleID"]));
ButtonRole tempButtonRole = new ButtonRole();
tempButtonRole.ButtonRoleID = buttonRole.ButtonRoleID;
tempButtonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
tempButtonRole.ButtonID = Int32.Parse(ddlButton.SelectedValue);
tempButtonRole.AddedDate = DateTime.Now;
tempButtonRole.AddedBy = loginID;
tempButtonRole.ModifyDate = DateTime.Now;
tempButtonRole.ModifyBy = loginID;
tempButtonRole.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = ButtonRoleManager.UpdateButtonRole(tempButtonRole);
Response.Redirect("AdminButtonRoleDisplay.aspx");
}
public static ButtonRole GetButtonRoleByID(int id)
{
ButtonRole buttonRole = new ButtonRole();
SqlButtonRoleProvider sqlButtonRoleProvider = new SqlButtonRoleProvider();
buttonRole = sqlButtonRoleProvider.GetButtonRoleByID(id);
return buttonRole;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null) { Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx"); }
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
ButtonRole buttonRole = new ButtonRole();
buttonRole = ButtonRoleManager.GetButtonRoleByID(Int32.Parse(Request.QueryString["buttonRoleID"]));
ButtonRole tempButtonRole = new ButtonRole();
tempButtonRole.ButtonRoleID = buttonRole.ButtonRoleID;
tempButtonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
tempButtonRole.ButtonID = Int32.Parse(ddlButton.SelectedValue);
tempButtonRole.AddedDate = DateTime.Now;
tempButtonRole.AddedBy = loginID;
tempButtonRole.ModifyDate = DateTime.Now;
tempButtonRole.ModifyBy = loginID;
tempButtonRole.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = ButtonRoleManager.UpdateButtonRole(tempButtonRole);
Response.Redirect("AdminButtonRoleDisplay.aspx");
}
public static ButtonRole GetButtonRoleByID(int id)
{
ButtonRole buttonRole = new ButtonRole();
SqlButtonRoleProvider sqlButtonRoleProvider = new SqlButtonRoleProvider();
buttonRole = sqlButtonRoleProvider.GetButtonRoleByID(id);
return(buttonRole);
}
public static MvcHtmlString ConstructBar(string name, ButtonRole role, int value)
{
var htmlStr = new StringBuilder();
htmlStr.Append(string.Format("<div class='progress {0}'>", _htmlRole[role]));
htmlStr.Append(String.Format("<div id='{0}' class='bar' style='width: {1}%;'>", name, value));
htmlStr.Append("</div></div>");
return(new MvcHtmlString(htmlStr.ToString()));
}
public ButtonParameters(ButtonIcon icon, ButtonType type, string text, ButtonRole buttonRole, ButtonIconColor buttonIconColor, ButtonHeight buttonHeight, bool enabled, string width, string toolTip = null)
{
ButtonIcon = icon;
Text = text;
ButtonRole = buttonRole;
ButtonIconColor = buttonIconColor;
ButtonHeight = buttonHeight;
Type = type;
Enabled = enabled;
Width = ProcessWidth(width);
ToolTip = toolTip;
}
private void showButtonRoleData()
{
ButtonRole buttonRole = new ButtonRole();
buttonRole = ButtonRoleManager.GetButtonRoleByID(Int32.Parse(Request.QueryString["buttonRoleID"]));
ddlRole.SelectedValue = buttonRole.RoleID.ToString();
ddlButton.SelectedValue = buttonRole.ButtonID.ToString();
txtAddedBy.Text = buttonRole.AddedBy;
txtModifyDate.Text = buttonRole.ModifyDate.ToString("dd MMM yyyy hh:mm tt");
txtModifyBy.Text = buttonRole.ModifyBy;
ddlRowStatus.SelectedValue = buttonRole.RowStatusID.ToString();
}
public bool UpdateButtonRole(ButtonRole buttonRole)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateButtonRole", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ButtonRoleID", SqlDbType.Int).Value = buttonRole.ButtonRoleID;
cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = buttonRole.RoleID;
cmd.Parameters.Add("@ButtonID", SqlDbType.Int).Value = buttonRole.ButtonID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = buttonRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = buttonRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = buttonRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = buttonRole.ModifyBy;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = buttonRole.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public ButtonRole GetButtonRoleFromReader(IDataReader reader)
{
try
{
ButtonRole buttonRole = new ButtonRole
(
(int)reader["ButtonRoleID"],
(int)reader["RoleID"],
(int)reader["ButtonID"],
(DateTime)reader["AddedDate"],
reader["AddedBy"].ToString(),
(DateTime)reader["ModifyDate"],
reader["ModifyBy"].ToString(),
(int)reader["RowStatusID"]
);
return(buttonRole);
}
catch (Exception ex)
{
return(null);
}
}
public ButtonParameters Role(ButtonRole buttonRole)
{
ButtonRole = buttonRole;
return(this);
}
public static MvcHtmlString ProgressBar(this HtmlHelper htmlHelper, string name, ButtonRole buttonRole, int initialValue = 0)
{
return(ProgressBarConstructor.ConstructBar(name, buttonRole, initialValue));
}
public static bool UpdateButtonRole(ButtonRole buttonRole)
{
SqlButtonRoleProvider sqlButtonRoleProvider = new SqlButtonRoleProvider();
return sqlButtonRoleProvider.UpdateButtonRole(buttonRole);
}
public static int InsertButtonRole(ButtonRole buttonRole)
{
SqlButtonRoleProvider sqlButtonRoleProvider = new SqlButtonRoleProvider();
return sqlButtonRoleProvider.InsertButtonRole(buttonRole);
}
public ButtonRole GetButtonRoleFromReader(IDataReader reader)
{
try
{
ButtonRole buttonRole = new ButtonRole
(
(int)reader["ButtonRoleID"],
(int)reader["RoleID"],
(int)reader["ButtonID"],
(DateTime)reader["AddedDate"],
reader["AddedBy"].ToString(),
(DateTime)reader["ModifyDate"],
reader["ModifyBy"].ToString(),
(int)reader["RowStatusID"]
);
return buttonRole;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateButtonRole(ButtonRole buttonRole)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateButtonRole", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ButtonRoleID", SqlDbType.Int).Value = buttonRole.ButtonRoleID;
cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = buttonRole.RoleID;
cmd.Parameters.Add("@ButtonID", SqlDbType.Int).Value = buttonRole.ButtonID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = buttonRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = buttonRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = buttonRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = buttonRole.ModifyBy;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = buttonRole.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public ButtonParameters(ButtonIcon icon, ButtonIconColor iconColor, ButtonRole buttonRole, string buttonText)
: this(icon, ButtonType.ImageText, buttonText, buttonRole, iconColor, ButtonHeight.Normal, true, null)
{
}
private void showButtonRoleData()
{
ButtonRole buttonRole = new ButtonRole();
buttonRole = ButtonRoleManager.GetButtonRoleByID(Int32.Parse(Request.QueryString["buttonRoleID"]));
ddlRole.SelectedValue = buttonRole.RoleID.ToString();
ddlButton.SelectedValue = buttonRole.ButtonID.ToString();
txtAddedBy.Text = buttonRole.AddedBy;
txtModifyDate.Text = buttonRole.ModifyDate.ToString("dd MMM yyyy hh:mm tt");
txtModifyBy.Text = buttonRole.ModifyBy;
ddlRowStatus.SelectedValue = buttonRole.RowStatusID.ToString();
}
public static int InsertButtonRole(ButtonRole buttonRole)
{
SqlButtonRoleProvider sqlButtonRoleProvider = new SqlButtonRoleProvider();
return(sqlButtonRoleProvider.InsertButtonRole(buttonRole));
}
protected void btnRoleWisePageNMenuAccess_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null) { Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx"); }
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
RoleManager.DeleteModuleMenuPageButtonRole(int.Parse(ddlRole.SelectedValue));
int resutl = 0;
foreach (GridViewRow grModule in gvModule.Rows)
{
CheckBox chkSelect = (CheckBox)grModule.FindControl("chkSelect");
if (chkSelect.Checked)
{
ModuleRole moduleRole = new ModuleRole();
moduleRole.ModuleID = Int32.Parse(chkSelect.ToolTip);
moduleRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
moduleRole.AddedDate = DateTime.Now;
moduleRole.AddedBy = loginID;
moduleRole.ModifyDate = DateTime.Now;
moduleRole.ModifyBy = loginID;
moduleRole.RowStatusID = 1;
resutl = ModuleRoleManager.InsertModuleRole(moduleRole);
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (chkSelectPageNMenu.Checked)
{
PageRole pageRole = new PageRole();
pageRole.PageID = Int32.Parse(chkSelectPageNMenu.ToolTip);
pageRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
pageRole.AddedDate = DateTime.Now;
pageRole.AddedBy = loginID;
pageRole.ModifyDate = DateTime.Now;
pageRole.ModifyBy = loginID;
pageRole.RowStatusID = 1;
resutl = PageRoleManager.InsertPageRole(pageRole);
if (chkSelectPageNMenu.ValidationGroup != "0")
{
MenuRole menuRole = new MenuRole();
menuRole.MenuID = Int32.Parse(chkSelectPageNMenu.ValidationGroup);
menuRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
menuRole.AddedDate = DateTime.Now;
menuRole.AddedBy = loginID;
menuRole.ModifyDate = DateTime.Now;
menuRole.ModifyBy = loginID;
menuRole.RowStatusID = 1;
resutl = MenuRoleManager.InsertMenuRole(menuRole);
}
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
{
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (!chkSelectPageNMenu.Checked)
{
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
}
Response.Redirect(HttpContext.Current.Request.Url.AbsoluteUri);
}
public static bool UpdateButtonRole(ButtonRole buttonRole)
{
SqlButtonRoleProvider sqlButtonRoleProvider = new SqlButtonRoleProvider();
return(sqlButtonRoleProvider.UpdateButtonRole(buttonRole));
}
public ButtonParameters(ButtonIcon icon, ButtonIconColor iconColor, ButtonRole buttonRole, ButtonHeight buttonHeight)
: this(icon, ButtonType.Image, null, buttonRole, iconColor, buttonHeight, true, null)
{
}
protected void btnRoleWisePageNMenuAccess_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null)
{
Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx");
}
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
RoleManager.DeleteModuleMenuPageButtonRole(int.Parse(ddlRole.SelectedValue));
int resutl = 0;
foreach (GridViewRow grModule in gvModule.Rows)
{
CheckBox chkSelect = (CheckBox)grModule.FindControl("chkSelect");
if (chkSelect.Checked)
{
ModuleRole moduleRole = new ModuleRole();
moduleRole.ModuleID = Int32.Parse(chkSelect.ToolTip);
moduleRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
moduleRole.AddedDate = DateTime.Now;
moduleRole.AddedBy = loginID;
moduleRole.ModifyDate = DateTime.Now;
moduleRole.ModifyBy = loginID;
moduleRole.RowStatusID = 1;
resutl = ModuleRoleManager.InsertModuleRole(moduleRole);
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (chkSelectPageNMenu.Checked)
{
PageRole pageRole = new PageRole();
pageRole.PageID = Int32.Parse(chkSelectPageNMenu.ToolTip);
pageRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
pageRole.AddedDate = DateTime.Now;
pageRole.AddedBy = loginID;
pageRole.ModifyDate = DateTime.Now;
pageRole.ModifyBy = loginID;
pageRole.RowStatusID = 1;
resutl = PageRoleManager.InsertPageRole(pageRole);
if (chkSelectPageNMenu.ValidationGroup != "0")
{
MenuRole menuRole = new MenuRole();
menuRole.MenuID = Int32.Parse(chkSelectPageNMenu.ValidationGroup);
menuRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
menuRole.AddedDate = DateTime.Now;
menuRole.AddedBy = loginID;
menuRole.ModifyDate = DateTime.Now;
menuRole.ModifyBy = loginID;
menuRole.RowStatusID = 1;
resutl = MenuRoleManager.InsertMenuRole(menuRole);
}
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
{
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (!chkSelectPageNMenu.Checked)
{
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
}
Response.Redirect(HttpContext.Current.Request.Url.AbsoluteUri);
}
