public STD_MENU_ITEMS ParseReaderComplete(DataRow row) { STD_MENU_ITEMS objReturn = ParseReaderCustom(row); if (objReturn != null) { if (objReturn.STD_REGISTRY_ID > 0) { STD_REGISTRYDB sTD_REGISTRYDB = new STD_REGISTRYDB(); objReturn.STD_REGISTRY = sTD_REGISTRYDB.ParseReaderCustom(row); } STD_WEB_PAGESDB sTD_WEB_PAGESDB = new STD_WEB_PAGESDB(); if (objReturn.PAGE_ID > 0) { objReturn.STD_WEB_PAGES = sTD_WEB_PAGESDB.ParseReaderCustom(row); } if (objReturn.MENU_PAGE_ID > 0) { objReturn.MENU_PAGE = sTD_WEB_PAGESDB.ParseReaderAlt(row); } if (objReturn.STD_ROLE_ID > 0) { STD_ROLEDB sTD_ROLEDB = new STD_ROLEDB(); objReturn.STD_ROLE = sTD_ROLEDB.ParseReaderCustom(row); } } return(objReturn); }
public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_MENU_ITEMS objSave) { Int32 objReturn = 0; STD_MENU_ITEMSDB objDB = new STD_MENU_ITEMSDB(); objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave); return(objReturn); }
public static STD_MENU_ITEMS GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 MENU_ID) { STD_MENU_ITEMS objReturn = null; STD_MENU_ITEMSDB objDB = new STD_MENU_ITEMSDB(); objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, MENU_ID); return(objReturn); }
private void LoadMenuForm(int id) { ResetMenuForm(); STD_MENU_ITEMS menu = ServiceInterfaceManager.STD_MENU_ITEMS_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id); if (menu != null) { hideMenuId.Value = menu.MENU_ID.ToString(); listPageName.SelectedValue = menu.PAGE_ID.ToString(); listMenuPageName.SelectedValue = menu.MENU_PAGE_ID.ToString(); listRoleName.SelectedValue = menu.STD_ROLE_ID.ToString(); txtSortOrder.Text = menu.SORT_ORDER.ToString(); } }
public STD_MENU_ITEMS ParseReaderMenu(DataRow row) { STD_MENU_ITEMS objReturn = new STD_MENU_ITEMS() { SORT_ORDER = (Int32)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_SORT_ORDER")), STD_REGISTRY = new STD_REGISTRY() { NAME = (string)GetNullableObject(row.Field <object>("STD_REGISTRY_NAME")), }, MENU_PAGE = new STD_WEB_PAGES() { DISPLAY_TEXT = (string)GetNullableObject(row.Field <object>("MENU_PAGE_DISPLAY_TEXT")), URL = (string)GetNullableObject(row.Field <object>("MENU_PAGE_URL")) } }; return(objReturn); }
public STD_MENU_ITEMS ParseReaderCustom(DataRow row) { STD_MENU_ITEMS objReturn = new STD_MENU_ITEMS { CREATED = (DateTime)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_CREATED")), CREATEDBY = (string)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_CREATEDBY")), INACTIVE_DATE = (DateTime?)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_INACTIVE_DATE")), INACTIVE_FLAG = (bool)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_INACTIVE_FLAG")), MENU_ID = (Int32)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_MENU_ID")), MENU_PAGE_ID = (Int32)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_MENU_PAGE_ID")), PAGE_ID = (Int32)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_PAGE_ID")), SORT_ORDER = (Int32)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_SORT_ORDER")), STD_REGISTRY_ID = (Int32)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_STD_REGISTRY_ID")), STD_ROLE_ID = (Int32)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_STD_ROLE_ID")), UPDATED = (DateTime)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_UPDATED")), UPDATEDBY = (string)GetNullableObject(row.Field <object>("STD_MENU_ITEMS_UPDATEDBY")) }; return(objReturn); }
public STD_MENU_ITEMS GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 MENU_ID) { STD_MENU_ITEMS objReturn = null; SqlConnection sConn = null; SqlCommand sCmd = null; SqlDataAdapter sAdapter = null; DataSet objTemp = null; try { sConn = new SqlConnection(SqlConnectionString); sConn.Open(); sCmd = new SqlCommand("CRS.usp_STD_MENU_ITEMS_getitem", sConn); sCmd.CommandTimeout = SqlCommandTimeout; sCmd.CommandType = CommandType.StoredProcedure; sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER); sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID); sCmd.Parameters.AddWithValue("@MENU_ID", MENU_ID); objTemp = new DataSet(); sAdapter = new SqlDataAdapter(sCmd); LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); sAdapter.Fill(objTemp); LogManager.LogTiming(logDetails); CheckDataSet(objTemp); if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0) { objReturn = ParseReader(objTemp.Tables[0].Rows[0]); } sConn.Close(); } catch (Exception ex) { LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); throw ex; } finally { if (sAdapter != null) { sAdapter.Dispose(); sAdapter = null; } if (sCmd != null) { sCmd.Dispose(); sCmd = null; } if (sConn != null) { if (sConn.State != ConnectionState.Closed) { sConn.Close(); } sConn.Dispose(); sConn = null; } } return(objReturn); }
public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_MENU_ITEMS objSave) { Int32 objReturn = 0; SqlConnection sConn = null; SqlCommand sCmd = null; SqlParameter p = null; SqlDataAdapter sAdapter = null; DataSet objTemp = null; try { sConn = new SqlConnection(SqlConnectionString); sConn.Open(); sCmd = new SqlCommand("CRS.usp_STD_MENU_ITEMS_save", sConn); sCmd.CommandTimeout = SqlCommandTimeout; sCmd.CommandType = CommandType.StoredProcedure; sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER); sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID); p = new SqlParameter("@CREATED", SqlDbType.DateTime, 8); p.Precision = 23; p.Scale = 3; AddParameter(ref sCmd, ref p, objSave.CREATED); p = new SqlParameter("@CREATEDBY", SqlDbType.VarChar, 30); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.CREATEDBY); p = new SqlParameter("@INACTIVE_DATE", SqlDbType.DateTime, 8); p.Precision = 23; p.Scale = 3; AddParameter(ref sCmd, ref p, objSave.INACTIVE_DATE); p = new SqlParameter("@INACTIVE_FLAG", SqlDbType.Bit, 1); p.Precision = 1; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.INACTIVE_FLAG); p = new SqlParameter("@MENU_ID", SqlDbType.Int, 4); p.Direction = ParameterDirection.InputOutput; p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.MENU_ID); p = new SqlParameter("@MENU_PAGE_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.MENU_PAGE_ID); p = new SqlParameter("@PAGE_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.PAGE_ID); p = new SqlParameter("@SORT_ORDER", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.SORT_ORDER); p = new SqlParameter("@STD_REGISTRY_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STD_REGISTRY_ID); p = new SqlParameter("@STD_ROLE_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STD_ROLE_ID); p = new SqlParameter("@UPDATED", SqlDbType.DateTime, 8); p.Precision = 23; p.Scale = 3; AddParameter(ref sCmd, ref p, objSave.UPDATED); p = new SqlParameter("@UPDATEDBY", SqlDbType.VarChar, 30); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.UPDATEDBY); objTemp = new DataSet(); sAdapter = new SqlDataAdapter(sCmd); LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); //int cnt = sCmd.ExecuteNonQuery(); sAdapter.Fill(objTemp); LogManager.LogTiming(logDetails); CheckDataSet(objTemp); objReturn = (Int32)sCmd.Parameters["@MENU_ID"].Value; sConn.Close(); } catch (Exception ex) { LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); throw ex; } finally { if (sAdapter != null) { sAdapter.Dispose(); sAdapter = null; } if (sCmd != null) { sCmd.Dispose(); sCmd = null; } if (sConn != null) { if (sConn.State != ConnectionState.Closed) { sConn.Close(); } sConn.Dispose(); sConn = null; } } return(objReturn); }
public static List <STD_MENU_ITEMS> GetMenu(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, string PATH) { List <STD_MENU_ITEMS> objReturn = new List <STD_MENU_ITEMS>(); STD_MENU_ITEMSDB objDB = new STD_MENU_ITEMSDB(); STD_MENU_ITEMS menuItem = null; if (string.IsNullOrEmpty(PATH) || PATH.Equals("~/Default.aspx", StringComparison.InvariantCultureIgnoreCase) || PATH.Equals("~/DataDictionary.aspx", StringComparison.InvariantCultureIgnoreCase) || PATH.Equals("~/RegistryInfo.aspx", StringComparison.InvariantCultureIgnoreCase)) { string[] roles = USER_ROLESManager.GetRoles(CURRENT_USER); List <STD_REGISTRY> allRegs = STD_REGISTRYManager.GetNonSystemRegistries(); List <STD_REGISTRY> uRegs = null; if (IsSystemUser(roles)) { uRegs = STD_REGISTRYManager.GetNonSystemRegistries(); } else { uRegs = STD_REGISTRYManager.GetNonSystemRegistriesByUser(CURRENT_USER, CURRENT_REGISTRY_ID); } if (uRegs != null && uRegs.Count > 0) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Your Registries"; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); foreach (STD_REGISTRY reg in uRegs) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = reg.NAME; menuItem.MENU_PAGE.URL = "~/Common/Default.aspx?id=" + reg.ID.ToString(); objReturn.Add(menuItem); if (allRegs != null && allRegs.Count > 0) { int?index = null; for (int i = 0; i < allRegs.Count; i++) { if (reg.ID == allRegs[i].ID) { index = i; break; } } if (index != null) { allRegs.RemoveAt(index.Value); } } } } if (allRegs != null && allRegs.Count > 0) { if (objReturn.Count > 1) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = string.Empty; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); } menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Available Registries"; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); foreach (STD_REGISTRY reg in allRegs) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = reg.NAME; menuItem.MENU_PAGE.URL = "~/RegistryInfo.aspx?id=" + reg.ID.ToString(); objReturn.Add(menuItem); } } } else if (PATH.ToLower().Contains("~/reports/")) { string reportStore = string.Empty; List <ReportItem> reports = ReportManager.GetAllByUserAndRegistry(CURRENT_USER, CURRENT_REGISTRY_ID); if (reports != null && reports.Count > 0) { foreach (ReportItem report in reports) { if (report.ReportStore != reportStore) { reportStore = report.ReportStore; if (objReturn.Count > 1) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = string.Empty; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); } menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = reportStore + " Reports"; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); } menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = report.Name; menuItem.MENU_PAGE.URL = "~/Reports/RunReport.aspx?path=" + report.Path; objReturn.Add(menuItem); } } string[] roles = USER_ROLESManager.GetRoles(CURRENT_USER); if (!IsReadOnlyUser(roles)) { if (objReturn.Count > 1) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = string.Empty; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); } DBUtils utils = new DBUtils(); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Report Builder"; menuItem.MENU_PAGE.URL = utils.ReportBuilderUrl; objReturn.Add(menuItem); } } else if (PATH.ToLower().Contains("~/cohorts/")) { string titleName = "Registry and Cohort Administration"; STD_REGISTRY reg = STD_REGISTRYManager.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, CURRENT_REGISTRY_ID); if (reg != null) { titleName = reg.NAME; } menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = titleName; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Cohort Criteria"; menuItem.MENU_PAGE.URL = "~/Cohorts/Cohort.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Framework Data"; menuItem.MENU_PAGE.URL = "~/Cohorts/FrameworkData.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "User-Defined Fields"; menuItem.MENU_PAGE.URL = "~/Cohorts/UDF.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Work Streams"; menuItem.MENU_PAGE.URL = "~/Cohorts/Workstream.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Activities"; menuItem.MENU_PAGE.URL = "~/Cohorts/Activity.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = string.Empty; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Registries and Cohorts"; menuItem.MENU_PAGE.URL = "~/Cohorts/Default.aspx"; objReturn.Add(menuItem); } else if (PATH.ToLower().Contains("~/admin/")) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Administration"; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Survey Administration"; menuItem.MENU_PAGE.URL = "~/Admin/Survey.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "User Administration"; menuItem.MENU_PAGE.URL = "~/Admin/User.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Menu Administration"; menuItem.MENU_PAGE.URL = "~/Admin/Menu.aspx"; objReturn.Add(menuItem); menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = "Settings"; menuItem.MENU_PAGE.URL = "~/Admin/Settings.aspx"; objReturn.Add(menuItem); } else { objReturn = objDB.GetItemsByUserRegistryPath(CURRENT_USER, CURRENT_REGISTRY_ID, PATH); if (objReturn != null && objReturn.Count > 0) { menuItem = new STD_MENU_ITEMS(); menuItem.MENU_PAGE = new STD_WEB_PAGES(); menuItem.MENU_PAGE.DISPLAY_TEXT = objReturn[0].STD_REGISTRY.NAME; menuItem.MENU_PAGE.URL = string.Empty; objReturn.Insert(0, menuItem); } } if (objReturn != null && objReturn.Count > 0) { return(objReturn); } else { return(null); } }
private bool SaveMenuForm(ref string strResult) { STD_MENU_ITEMS menu = null; int registryId = 0; int.TryParse(listRegistries.SelectedValue, out registryId); int pageId = 0; int.TryParse(listPageName.SelectedValue, out pageId); int menuPageId = 0; int.TryParse(listMenuPageName.SelectedValue, out menuPageId); int roleId = 0; int.TryParse(listRoleName.SelectedValue, out roleId); if (registryId > 0 && menuPageId > 0 && roleId > 0) { if (string.IsNullOrEmpty(txtSortOrder.Text)) { strResult = "<ul><li>Sort Order is Required</li></ul>"; } else { int id = 0; if (!string.IsNullOrEmpty(hideMenuId.Value)) { int.TryParse(hideMenuId.Value, out id); } if (id > 0) { menu = ServiceInterfaceManager.STD_MENU_ITEMS_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id); } if (menu == null) { menu = new STD_MENU_ITEMS(); } menu.STD_REGISTRY_ID = registryId; menu.CREATEDBY = menu.UPDATEDBY = HttpContext.Current.User.Identity.Name; menu.INACTIVE_FLAG = false; menu.PAGE_ID = pageId; menu.MENU_PAGE_ID = menuPageId; menu.STD_ROLE_ID = roleId; int sortOrder = 0; int.TryParse(txtSortOrder.Text, out sortOrder); menu.SORT_ORDER = sortOrder; menu.MENU_ID = ServiceInterfaceManager.STD_MENU_ITEMS_SAVE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, menu); if (menu.MENU_ID > 0) { hideMenuId.Value = menu.MENU_ID.ToString(); strResult = "Save successful<br /><br />"; return(true); } else { strResult = "Error saving Menu Item, please try again<br /><br />"; } } } else { strResult = "<ul><li>Please select a Registry, Page, Menu Item, and Role</li></ul>"; } return(false); }
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_MENU_ITEMS objDelete) { return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.MENU_ID)); }