public static USER_RoleWiseMenu GetUSER_RoleWiseMenuByID(int ID)
{
USER_RoleWiseMenu uSER_RoleWiseMenu = new USER_RoleWiseMenu();
SqlUSER_RoleWiseMenuProvider sqlUSER_RoleWiseMenuProvider = new SqlUSER_RoleWiseMenuProvider();
uSER_RoleWiseMenu = sqlUSER_RoleWiseMenuProvider.GetUSER_RoleWiseMenuByID(ID);
return uSER_RoleWiseMenu;
}
public static USER_RoleWiseMenu GetUserRowStatusByRowStatusID(int RowStatusID)
{
USER_RoleWiseMenu uSER_RoleWiseMenu = new USER_RoleWiseMenu();
SqlUSER_RoleWiseMenuProvider sqlUSER_RoleWiseMenuProvider = new SqlUSER_RoleWiseMenuProvider();
uSER_RoleWiseMenu = sqlUSER_RoleWiseMenuProvider.GetUSER_RoleWiseMenuByRowStatusID(RowStatusID);
return uSER_RoleWiseMenu;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (ddlRoleID.SelectedIndex > 0 && lbxModules.SelectedIndex != -1)
{
string roleID = ddlRoleID.SelectedValue;
bool isUpdated = false;
foreach (GridViewRow row in gvMenuAccess.Rows)
{
CheckBox cbIsAssigned = (CheckBox)row.FindControl("cbIsAssigned");
int menuID = Convert.ToInt32(((HiddenField)row.FindControl("hfMenuID")).Value);
USER_RoleWiseMenu uSER_RoleWiseMenu = new USER_RoleWiseMenu();
uSER_RoleWiseMenu.ID = 0;
uSER_RoleWiseMenu.MenuID = menuID;
uSER_RoleWiseMenu.RoleID = roleID;
uSER_RoleWiseMenu.AddedBy = "Admin";
uSER_RoleWiseMenu.AddedDate = DateTime.Now;
uSER_RoleWiseMenu.UpdatedBy = "Admin";
uSER_RoleWiseMenu.UpdatedDate = DateTime.Now;
if (cbIsAssigned.Checked)
{
uSER_RoleWiseMenu.RowStatusID = (int)Enums.RowStatus.Active;
}
else
{
uSER_RoleWiseMenu.RowStatusID = (int)Enums.RowStatus.Deleted;
}
int result = USER_RoleWiseMenuManager.InsertUSER_RoleWiseMenu(uSER_RoleWiseMenu);
if (result > 0)
isUpdated = true;
}
if (isUpdated)
{
_loadMenus();
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "Message", "alert('Updated Successfully!!');", true);
}
}
}
catch (Exception ex)
{
}
}
public static bool UpdateUSER_RoleWiseMenu(USER_RoleWiseMenu uSER_RoleWiseMenu)
{
SqlUSER_RoleWiseMenuProvider sqlUSER_RoleWiseMenuProvider = new SqlUSER_RoleWiseMenuProvider();
return sqlUSER_RoleWiseMenuProvider.UpdateUSER_RoleWiseMenu(uSER_RoleWiseMenu);
}
public static int InsertUSER_RoleWiseMenu(USER_RoleWiseMenu uSER_RoleWiseMenu)
{
SqlUSER_RoleWiseMenuProvider sqlUSER_RoleWiseMenuProvider = new SqlUSER_RoleWiseMenuProvider();
return sqlUSER_RoleWiseMenuProvider.InsertUSER_RoleWiseMenu(uSER_RoleWiseMenu);
}
public bool UpdateUSER_RoleWiseMenu(USER_RoleWiseMenu uSER_RoleWiseMenu)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateUSER_RoleWiseMenu", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = uSER_RoleWiseMenu.ID;
cmd.Parameters.Add("@MenuID", SqlDbType.Int).Value = uSER_RoleWiseMenu.MenuID;
cmd.Parameters.Add("@RoleID", SqlDbType.NVarChar).Value = uSER_RoleWiseMenu.RoleID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = uSER_RoleWiseMenu.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = uSER_RoleWiseMenu.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = uSER_RoleWiseMenu.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public USER_RoleWiseMenu GetUSER_RoleWiseMenuFromReader(IDataReader reader)
{
try
{
USER_RoleWiseMenu uSER_RoleWiseMenu = new USER_RoleWiseMenu
(
DataAccessObject.IsNULL<int>(reader["ID"]),
DataAccessObject.IsNULL<int>(reader["MenuID"]),
DataAccessObject.IsNULL<string>(reader["RoleID"].ToString()),
DataAccessObject.IsNULL<string>(reader["AddedBy"]),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"]),
DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return uSER_RoleWiseMenu;
}
catch(Exception ex)
{
return null;
}
}
