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