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; } }