public static USER_Menu GetUserPageByPageID(int PageID) { USER_Menu uSER_Menu = new USER_Menu(); SqlUSER_MenuProvider sqlUSER_MenuProvider = new SqlUSER_MenuProvider(); uSER_Menu = sqlUSER_MenuProvider.GetUSER_MenuByPageID(PageID); return uSER_Menu; }
public static USER_Menu GetUserRowStatusByRowStatusID(int RowStatusID) { USER_Menu uSER_Menu = new USER_Menu(); SqlUSER_MenuProvider sqlUSER_MenuProvider = new SqlUSER_MenuProvider(); uSER_Menu = sqlUSER_MenuProvider.GetUSER_MenuByRowStatusID(RowStatusID); return uSER_Menu; }
protected void btnAdd_Click(object sender, EventArgs e) { USER_Menu uSER_Menu = new USER_Menu(); uSER_Menu.PageID = int.Parse(ddlPageID.SelectedValue); uSER_Menu.ModuleID = Convert.ToInt32(ddlModules.SelectedValue); uSER_Menu.MenuTitle = txtMenuTitle.Text; uSER_Menu.ParentMenuID = Convert.ToInt32(ddlParentMenu.SelectedValue); uSER_Menu.AddedBy = "Admin"; uSER_Menu.AddedDate = DateTime.Now; uSER_Menu.UpdatedBy = "Admin"; uSER_Menu.UpdatedDate = DateTime.Now; uSER_Menu.RowStatusID = int.Parse(ddlRowStatusID.SelectedValue); int resutl = USER_MenuManager.InsertUSER_Menu(uSER_Menu); Response.Redirect("AdminDisplayUSER_Menu.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { try { USER_Menu uSER_Menu = new USER_Menu(); uSER_Menu.MenuID = int.Parse(Request.QueryString["ID"].ToString()); uSER_Menu.PageID = int.Parse(ddlPageID.SelectedValue); uSER_Menu.ModuleID = Convert.ToInt32(ddlModules.SelectedValue); uSER_Menu.MenuTitle = txtMenuTitle.Text; uSER_Menu.ParentMenuID = Convert.ToInt32(ddlParentMenu.SelectedValue); uSER_Menu.AddedBy = "Admin"; uSER_Menu.AddedDate = DateTime.Now; uSER_Menu.UpdatedBy = "Admin"; uSER_Menu.UpdatedDate = DateTime.Now; uSER_Menu.RowStatusID = int.Parse(ddlRowStatusID.SelectedValue); bool resutl = USER_MenuManager.UpdateUSER_Menu(uSER_Menu); Response.Redirect("AdminDisplayUSER_Menu.aspx"); } catch (Exception ex) { } }
public static USER_Menu GetUSER_MenuByMenuID(int MenuID) { USER_Menu uSER_Menu = new USER_Menu(); SqlUSER_MenuProvider sqlUSER_MenuProvider = new SqlUSER_MenuProvider(); uSER_Menu = sqlUSER_MenuProvider.GetUSER_MenuByMenuID(MenuID); return uSER_Menu; }
public static bool UpdateUSER_Menu(USER_Menu uSER_Menu) { SqlUSER_MenuProvider sqlUSER_MenuProvider = new SqlUSER_MenuProvider(); return sqlUSER_MenuProvider.UpdateUSER_Menu(uSER_Menu); }
public static int InsertUSER_Menu(USER_Menu uSER_Menu) { SqlUSER_MenuProvider sqlUSER_MenuProvider = new SqlUSER_MenuProvider(); return sqlUSER_MenuProvider.InsertUSER_Menu(uSER_Menu); }
private void showUSER_MenuData() { try { USER_Menu uSER_Menu = new USER_Menu(); uSER_Menu = USER_MenuManager.GetUSER_MenuByMenuID(Int32.Parse(Request.QueryString["ID"])); ddlModules.SelectedValue = uSER_Menu.ModuleID.ToString(); ddlModules_SelectedIndexChanged(new object(), new EventArgs()); ddlPageID.SelectedValue = uSER_Menu.PageID.ToString(); txtMenuTitle.Text = uSER_Menu.MenuTitle.ToString(); ddlParentMenu.SelectedValue = uSER_Menu.ParentMenuID.ToString(); ddlRowStatusID.SelectedValue = uSER_Menu.RowStatusID.ToString(); } catch (Exception ex) { } }
public bool UpdateUSER_Menu(USER_Menu uSER_Menu) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateUSER_Menu", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MenuID", SqlDbType.Int).Value = uSER_Menu.MenuID; cmd.Parameters.Add("@ModuleID", SqlDbType.Int).Value = uSER_Menu.ModuleID; cmd.Parameters.Add("@PageID", SqlDbType.Int).Value = uSER_Menu.PageID; cmd.Parameters.Add("@MenuTitle", SqlDbType.NVarChar).Value = uSER_Menu.MenuTitle; cmd.Parameters.Add("@ParentMenuID", SqlDbType.Int).Value = uSER_Menu.ParentMenuID; //cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = uSER_Menu.AddedBy; //cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = uSER_Menu.AddedDate; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = uSER_Menu.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = uSER_Menu.UpdatedDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = uSER_Menu.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public USER_Menu GetUSER_MenuFromReader(IDataReader reader) { try { USER_Menu uSER_Menu = new USER_Menu ( DataAccessObject.IsNULL<int>(reader["MenuID"]), DataAccessObject.IsNULL<int>(reader["ModuleID"]), DataAccessObject.IsNULL<int>(reader["PageID"]), DataAccessObject.IsNULL<string>(reader["MenuTitle"]), DataAccessObject.IsNULL<int>(reader["ParentMenuID"]), 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_Menu; } catch(Exception ex) { return null; } }