Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 4
0
        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();
            }
        }
Ejemplo n.º 5
0
        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);
            }
        }
Ejemplo n.º 10
0
        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));
 }