public void LoadForm(int id) { ResetForm(); STD_REGISTRY registry = ServiceInterfaceManager.STD_REGISTRY_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id); if (registry != null) { hideRegistryId.Value = registry.ID.ToString(); txtRegistryName.Text = registry.NAME; txtRegistryCode.Text = registry.CODE; txtRegistryDescription.Text = registry.DESCRIPTION_TEXT; LoadUserLists(); if (registry.REGISTRY_OWNER > 0) { listRegistryOwner.SelectedValue = registry.REGISTRY_OWNER.ToString(); } if (registry.REGISTRY_ADMINISTRATOR > 0) { listRegistryAdministrator.SelectedValue = registry.REGISTRY_ADMINISTRATOR.ToString(); } if (registry.REGISTRY_SUPPORT_CONTACT > 0) { listSupportContact.SelectedValue = registry.REGISTRY_SUPPORT_CONTACT.ToString(); } } }
protected virtual void Page_Load(object sender, EventArgs e) { int id = 0; if (!Page.IsPostBack) { if (Request.QueryString["id"] != null) { if (int.TryParse(Request.QueryString["id"].ToString(), out id)) { UserSession.CurrentRegistryId = id; } } if (Request.QueryString["path"] != null) { userSession.CurrentReportPath = Request.QueryString["path"]; } if (UserSession.CurrentRegistryId > 0) { STD_REGISTRY r = ServiceInterfaceManager.STD_REGISTRY_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentRegistryId); if (r != null) { UserSession.CurrentRegistry = r.NAME; UserSession.CurrentRegistryId = r.ID; } } } }
public void LoadForm(int id) { STD_REGISTRY registry = ServiceInterfaceManager.STD_REGISTRY_GET_COMPLETE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id); if (registry != null) { lblRegistryNameValue.Text = (registry.NAME == string.Empty ? "N/A" : registry.NAME); lblRegistryCodeValue.Text = (registry.CODE == string.Empty ? "N/A" : registry.CODE); lblRegistryDescriptionValue.Text = (registry.DESCRIPTION_TEXT == string.Empty ? "N/A" : registry.DESCRIPTION_TEXT); if (!registry.INACTIVE_FLAG) { lblRegistryStatusValue.Text = "Enabled"; } else { lblRegistryStatusValue.Text = "Disabled"; } if (registry.REGISTRY_OWNER_USER != null) { lblRegistryOwnerValue.Text = (registry.REGISTRY_OWNER_USER.FULL_NAME == string.Empty ? "N/A" : registry.REGISTRY_OWNER_USER.FULL_NAME); } else { lblRegistryOwnerValue.Text = "N/A"; } if (registry.REGISTRY_ADMINISTRATOR_USER != null) { lblRegistryAdministratorValue.Text = (registry.REGISTRY_ADMINISTRATOR_USER.FULL_NAME == string.Empty ? "N/A" : registry.REGISTRY_ADMINISTRATOR_USER.FULL_NAME); } else { lblRegistryAdministratorValue.Text = "N/A"; } if (registry.SUPPORT_CONTACT_USER != null) { lblSupportContactValue.Text = (registry.SUPPORT_CONTACT_USER.FULL_NAME == string.Empty ? "N/A" : registry.SUPPORT_CONTACT_USER.FULL_NAME); } else { lblSupportContactValue.Text = "N/A"; } } USERS user = ServiceInterfaceManager.USERS_GET_BY_NAME(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, HttpContext.Current.User.Identity.Name); if (user != null) { if (UserSession.CurrentRegistryId == user.DEFAULT_REGISTRY_ID) { chkRegistryDefault.Checked = true; } else { chkRegistryDefault.Checked = false; } } }
private void LoadForm() { ResetForm(); STD_REGISTRY systemRegistry = ApplicationSession.SystemRegistry; AppSettings appSettings = ServiceInterfaceManager.APPSETTINGS_GET(HttpContext.Current.User.Identity.Name, systemRegistry.ID); if (appSettings != null) { txtSqlCommandTimeout.Text = appSettings.SqlCommandTimeout.ToString(); txtLogFileSize.Text = appSettings.LogFileSize.ToString(); txtLogFileArchive.Text = appSettings.LogFileArchive.ToString(); listLogErrors.SelectedValue = appSettings.LogErrors.ToString().ToLower(); listLogInformation.SelectedValue = appSettings.LogInformation.ToString().ToLower(); listLogTiming.SelectedValue = appSettings.LogTiming.ToString().ToLower(); listDatabaseLogEnabled.SelectedValue = appSettings.DatabaseLogEnabled.ToString().ToLower(); //listEventLogEnabled.SelectedValue = appSettings.EventLogEnabled.ToString().ToLower(); listFileLogEnabled.SelectedValue = appSettings.FileLogEnabled.ToString().ToLower(); txtFileLogPath.Text = appSettings.FileLogPath.ToString(); listMviEnabled.SelectedValue = appSettings.MviEnabled.ToString().ToLower(); listMviProcessingCode.SelectedValue = appSettings.MviProcessingCode.ToString().ToUpper(); txtMviCertName.Text = appSettings.MviCertName.ToString(); txtMviServiceUrl.Text = appSettings.MviServiceUrl.ToString(); txtReportBuilderPath.Text = appSettings.ReportBuilderPath.ToString(); txtReportServerUrl.Text = appSettings.ReportServerUrl.ToString(); txtReportServicePath.Text = appSettings.ReportServicePath.ToString(); txtEtlSchedule.Text = appSettings.EtlSchedule; txtEtlRetryAttempts.Text = appSettings.EtlRetryAttempts.ToString(); txtEtlTimeBetweenAttempts.Text = appSettings.EtlTimeBetweenAttempts.ToString(); txtHomePageText.Text = appSettings.HomePageText; } }
public static Int32 SaveWithReporting(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, USERS objSave) { Int32 objReturn = 0; USERSDB objDB = new USERSDB(); objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave); if (objReturn > 0) { //Create System User ReportManager.AddSystemUser(CURRENT_USER, CURRENT_REGISTRY_ID, objSave.USERNAME); //Give Read Only to Root ReportManager.AddItemReadOnly(CURRENT_USER, CURRENT_REGISTRY_ID, objSave.USERNAME, "/"); //Give Read Only to Reports ReportManager.AddItemReadOnly(CURRENT_USER, CURRENT_REGISTRY_ID, objSave.USERNAME, "/Reports"); //Give Read Only to System STD_REGISTRY registry = STD_REGISTRYManager.GetSystemRegistry(); if (registry != null && !string.IsNullOrEmpty(registry.CODE)) { ReportManager.AddItemReadOnly(CURRENT_USER, CURRENT_REGISTRY_ID, objSave.USERNAME, "/Reports/" + registry.CODE); } //Add User Folder and Give Admin string itemPath = ReportManager.CreateUserFolder(CURRENT_USER, CURRENT_REGISTRY_ID, objSave.USERNAME); if (!string.IsNullOrEmpty(itemPath)) { ReportManager.AddItemAdmin(CURRENT_USER, CURRENT_REGISTRY_ID, objSave.USERNAME, itemPath); } } return(objReturn); }
public static STD_REGISTRY GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID) { STD_REGISTRY objReturn = null; STD_REGISTRYDB objDB = new STD_REGISTRYDB(); objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, ID); return(objReturn); }
public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_REGISTRY objSave) { Int32 objReturn = 0; STD_REGISTRYDB objDB = new STD_REGISTRYDB(); objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave); return(objReturn); }
public static STD_REGISTRY GetSystemRegistry() { STD_REGISTRY objReturn = null; STD_REGISTRYDB objDB = new STD_REGISTRYDB(); objReturn = objDB.GetSystemRegistry(); return(objReturn); }
protected override void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ServiceInterfaceManager.LogInformation("PAGE_LOAD", String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId); } try { base.Page_Load(sender, e); STD_REGISTRY systemRegistry = ApplicationSession.SystemRegistry; AppSettings appSetting = ServiceInterfaceManager.APPSETTINGS_GET(HttpContext.Current.User.Identity.Name, systemRegistry.ID); if (appSetting != null) { string query = ""; query = Request.QueryString["query"] as string; switch (query) { case "1": //File Log View if (!string.IsNullOrEmpty(appSetting.FileLogPath.ToString())) { string logText = File.ReadAllText(appSetting.FileLogPath.ToString()); //string whitelist = "^[a-zA-Z0-9-,. ]+$"; //Regex pattern = new Regex(whitelist); //if (!pattern.IsMatch(logText)) // throw new Exception("Invalid Search Criteria"); txtOutput.Text = logText; } else { lblResult.Text = "There is no File Log Path saved in Settings. A file could not be generated to view.<br /><br />"; txtOutput.Visible = false; } break; default: { lblResult.Text = "You have not selected a file to view. Please return to settings and pick a file.<br /><br />"; txtOutput.Visible = false; break; } } } } catch (Exception ex) { ServiceInterfaceManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId); throw ex; } }
public void Refresh(bool refreshAll) { if (refreshAll) { this.domainNames = ServiceInterfaceManager.USERS_LOAD_FROM_AD(); } this.systemRegistry = ServiceInterfaceManager.STD_REGISTRY_GET_SYSTEM(); this.registries = ServiceInterfaceManager.STD_REGISTRY_GET_ALL_NON_SYSTEM(); HttpContext.Current.Application["ApplicationSession"] = this; }
private bool SaveRoles() { //Do one last save of system roles because of strange bug with auto-postback STD_REGISTRY system = ApplicationSession.SystemRegistry; if (system != null) { int roleId = 0; int.TryParse(rblSystemRoles.SelectedValue, out roleId); UpdateRoles(system.ID, roleId); } //Default to true, if there is an error saving to DB, will set value to false bool blnReturn = true; List <USER_ROLES> saveRoles = new List <USER_ROLES>(); List <USER_ROLES> userRoles = UserRoles; if (userRoles != null) { //Work with any system roles first userRoles = userRoles.OrderByDescending(data => data.STD_ROLE.SUPER_USER_FLAG).ToList <USER_ROLES>(); int userId = 0; if (int.TryParse(hideUserId.Value, out userId)) { foreach (USER_ROLES userRole in userRoles) { userRole.USER_ID = userId; //Only save to the DB if there is an existing record (USER_ROLD_ID > 0) //Or, if it has a valid role (STD_ROLE_ID > 0) if (userRole.USER_ROLE_ID > 0 || userRole.STD_ROLE_ID > 0) { saveRoles.Add(userRole); } } if (saveRoles.Count > 0) { ServiceInterfaceManager.USER_ROLES_SAVE_ALL(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, saveRoles); } UserRoles = ServiceInterfaceManager.USER_ROLES_GET_ALL_BY_USER(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, userId); } } return(blnReturn); }
public static string CreateRegistryFolder(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID) { string objReturn = string.Empty; ReportDB objDB = new ReportDB(); STD_REGISTRY registry = STD_REGISTRYManager.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, CURRENT_REGISTRY_ID); if (registry == null || string.IsNullOrEmpty(registry.CODE)) { return(string.Empty); } string folderName = registry.CODE; objReturn = objDB.CreateFolder(CURRENT_USER, CURRENT_REGISTRY_ID, folderName); objDB.Dispose(); return(objReturn); }
public static List <ReportItem> GetRegistryReports(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID) { List <ReportItem> objReturn = null; ReportDB objDB = new ReportDB(); STD_REGISTRY registry = STD_REGISTRYManager.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, CURRENT_REGISTRY_ID); if (registry == null || string.IsNullOrEmpty(registry.CODE)) { return(null); } string folderName = "/Reports/" + registry.CODE; objReturn = objDB.GetReports(CURRENT_USER, CURRENT_REGISTRY_ID, folderName); objDB.Dispose(); return(objReturn); }
public static bool CreateDataSet(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID) { bool objReturn = false; ReportDB objDB = new ReportDB(); STD_REGISTRY registry = STD_REGISTRYManager.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, CURRENT_REGISTRY_ID); if (registry == null || string.IsNullOrEmpty(registry.CODE)) { return(false); } string name = registry.CODE; string parent = "/Reports/" + registry.CODE; objReturn = objDB.CreateDataSet(CURRENT_USER, CURRENT_REGISTRY_ID, name, parent); objDB.Dispose(); return(objReturn); }
protected void RblSystemRoles_SelectedIndexChanged(object sender, EventArgs e) { ServiceInterfaceManager.LogInformation("POSTBACK_EVENT", String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId); try { STD_REGISTRY system = ApplicationSession.SystemRegistry; if (system != null) { int roleId = 0; int.TryParse(rblSystemRoles.SelectedValue, out roleId); UpdateRoles(system.ID, roleId); } } catch (Exception ex) { ServiceInterfaceManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId); throw ex; } }
public STD_REGISTRY ParseReaderCustom(DataRow row) { STD_REGISTRY objReturn = new STD_REGISTRY { CODE = (string)GetNullableObject(row.Field <object>("STD_REGISTRY_CODE")), COMMENTS = (string)GetNullableObject(row.Field <object>("STD_REGISTRY_COMMENTS")), CREATED = (DateTime)GetNullableObject(row.Field <object>("STD_REGISTRY_CREATED")), CREATEDBY = (string)GetNullableObject(row.Field <object>("STD_REGISTRY_CREATEDBY")), DESCRIPTION_TEXT = (string)GetNullableObject(row.Field <object>("STD_REGISTRY_DESCRIPTION_TEXT")), ID = (Int32)GetNullableObject(row.Field <object>("STD_REGISTRY_ID")), INACTIVE_DATE = (DateTime?)GetNullableObject(row.Field <object>("STD_REGISTRY_INACTIVE_DATE")), INACTIVE_FLAG = (bool)GetNullableObject(row.Field <object>("STD_REGISTRY_INACTIVE_FLAG")), NAME = (string)GetNullableObject(row.Field <object>("STD_REGISTRY_NAME")), REGISTRY_ADMINISTRATOR = (Int32?)GetNullableObject(row.Field <object>("STD_REGISTRY_REGISTRY_ADMINISTRATOR")), REGISTRY_OWNER = (Int32?)GetNullableObject(row.Field <object>("STD_REGISTRY_REGISTRY_OWNER")), REGISTRY_SUPPORT_CONTACT = (Int32?)GetNullableObject(row.Field <object>("STD_REGISTRY_REGISTRY_SUPPORT_CONTACT")), SORT_ORDER = (Int32)GetNullableObject(row.Field <object>("STD_REGISTRY_SORT_ORDER")), UPDATED = (DateTime)GetNullableObject(row.Field <object>("STD_REGISTRY_UPDATED")), UPDATEDBY = (string)GetNullableObject(row.Field <object>("STD_REGISTRY_UPDATEDBY")) }; return(objReturn); }
public STD_REGISTRY ParseReaderComplete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, DataRow row) { STD_REGISTRY objReturn = ParseReader(row); USERSDB objDB = new USERSDB(); if (objReturn.REGISTRY_OWNER > 0) { objReturn.REGISTRY_OWNER_USER = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, objReturn.REGISTRY_OWNER.Value); } if (objReturn.REGISTRY_ADMINISTRATOR > 0) { objReturn.REGISTRY_ADMINISTRATOR_USER = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, objReturn.REGISTRY_ADMINISTRATOR.Value); } if (objReturn.REGISTRY_SUPPORT_CONTACT > 0) { objReturn.SUPPORT_CONTACT_USER = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, objReturn.REGISTRY_SUPPORT_CONTACT.Value); } return(objReturn); }
private bool SaveForm() { bool objReturn = false; STD_REGISTRY systemRegistry = ApplicationSession.SystemRegistry; AppSettings oldAppSettings = ServiceInterfaceManager.APPSETTINGS_GET(HttpContext.Current.User.Identity.Name, systemRegistry.ID); AppSettings newAppSettings = new AppSettings(); int iValue = 0; int.TryParse(txtSqlCommandTimeout.Text, out iValue); newAppSettings.SqlCommandTimeout = iValue; iValue = 0; int.TryParse(txtLogFileSize.Text, out iValue); newAppSettings.LogFileSize = iValue; iValue = 0; int.TryParse(txtLogFileArchive.Text, out iValue); newAppSettings.LogFileArchive = iValue; bool bValue = false; bool.TryParse(listLogErrors.SelectedValue, out bValue); newAppSettings.LogErrors = bValue; bValue = false; bool.TryParse(listLogInformation.SelectedValue, out bValue); newAppSettings.LogInformation = bValue; bValue = false; bool.TryParse(listLogTiming.SelectedValue, out bValue); newAppSettings.LogTiming = bValue; bValue = false; bool.TryParse(listDatabaseLogEnabled.SelectedValue, out bValue); newAppSettings.DatabaseLogEnabled = bValue; bValue = false; //bool.TryParse(listEventLogEnabled.SelectedValue, out bValue); newAppSettings.EventLogEnabled = bValue; bValue = false; bool.TryParse(listFileLogEnabled.SelectedValue, out bValue); newAppSettings.FileLogEnabled = bValue; if (ValidFileLogPath()) { newAppSettings.FileLogPath = txtFileLogPath.Text; } else { return(false); } bValue = false; bool.TryParse(listMviEnabled.SelectedValue, out bValue); newAppSettings.MviEnabled = bValue; newAppSettings.MviProcessingCode = listMviProcessingCode.SelectedValue; newAppSettings.MviCertName = this.txtMviCertName.Text; newAppSettings.MviServiceUrl = this.txtMviServiceUrl.Text; newAppSettings.ReportBuilderPath = txtReportBuilderPath.Text; newAppSettings.ReportServerUrl = txtReportServerUrl.Text; newAppSettings.ReportServicePath = txtReportServicePath.Text; newAppSettings.EtlSchedule = txtEtlSchedule.Text; iValue = 0; int.TryParse(txtEtlRetryAttempts.Text, out iValue); newAppSettings.EtlRetryAttempts = iValue; iValue = 0; int.TryParse(txtEtlTimeBetweenAttempts.Text, out iValue); newAppSettings.EtlTimeBetweenAttempts = iValue; newAppSettings.HomePageText = txtHomePageText.Text; objReturn = ServiceInterfaceManager.APPSETTINGS_SAVE(HttpContext.Current.User.Identity.Name, systemRegistry.ID, newAppSettings); if (objReturn) { DB_LOG newLog = new DB_LOG(); newLog.STD_REGISTRY_ID = systemRegistry.ID; newLog.IS_ERROR = false; newLog.PROCESS_NAME = "CRSe_WEB.Settings.SaveForm"; newLog.MESSAGE = "CRSe app settings values have been updated (Old Values: " + WriteToXmlString(oldAppSettings) + ") to (New Values: " + WriteToXmlString(newAppSettings) + ")"; newLog.CREATED = DateTime.Now; newLog.CREATEDBY = HttpContext.Current.User.Identity.Name; ServiceInterfaceManager.DB_LOG_SAVE(HttpContext.Current.User.Identity.Name, systemRegistry.ID, newLog); } return(objReturn); }
public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_REGISTRY 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_REGISTRY_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("@CODE", SqlDbType.VarChar, 50); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.CODE); p = new SqlParameter("@COMMENTS", SqlDbType.VarChar, -1); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.COMMENTS); 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("@DESCRIPTION_TEXT", SqlDbType.VarChar, 500); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.DESCRIPTION_TEXT); p = new SqlParameter("@ID", SqlDbType.Int, 4); p.Direction = ParameterDirection.InputOutput; p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.ID); 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("@NAME", SqlDbType.VarChar, 100); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.NAME); p = new SqlParameter("@REGISTRY_ADMINISTRATOR", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.REGISTRY_ADMINISTRATOR); p = new SqlParameter("@REGISTRY_OWNER", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.REGISTRY_OWNER); p = new SqlParameter("@REGISTRY_SUPPORT_CONTACT", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.REGISTRY_SUPPORT_CONTACT); 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("@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["@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 bool SaveForm(ref string strResult) { STD_REGISTRY registry = null; if (string.IsNullOrEmpty(txtRegistryName.Text)) { strResult = "<ul><li>Registry Name is Required</li></ul>"; } else if (string.IsNullOrEmpty(txtRegistryCode.Text)) { strResult = "<ul><li>Registry Code is Required</li></ul>"; } else if (string.IsNullOrEmpty(txtRegistryDescription.Text)) { strResult = "<ul><li>Description is Required</li></ul>"; } else { int id = 0; if (!string.IsNullOrEmpty(hideRegistryId.Value)) { int.TryParse(hideRegistryId.Value, out id); } registry = ServiceInterfaceManager.STD_REGISTRY_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id); if (registry == null) { registry = new STD_REGISTRY(); } registry.CREATEDBY = registry.UPDATEDBY = HttpContext.Current.User.Identity.Name; registry.NAME = txtRegistryName.Text; registry.CODE = txtRegistryCode.Text.Trim(); registry.DESCRIPTION_TEXT = txtRegistryDescription.Text; int userId = 0; int.TryParse(listRegistryOwner.SelectedValue, out userId); if (userId > 0) { registry.REGISTRY_OWNER = userId; } else { registry.REGISTRY_OWNER = null; } userId = 0; int.TryParse(listRegistryAdministrator.SelectedValue, out userId); if (userId > 0) { registry.REGISTRY_ADMINISTRATOR = userId; } else { registry.REGISTRY_ADMINISTRATOR = null; } userId = 0; int.TryParse(listSupportContact.SelectedValue, out userId); if (userId > 0) { registry.REGISTRY_SUPPORT_CONTACT = userId; } else { registry.REGISTRY_SUPPORT_CONTACT = null; } registry.ID = ServiceInterfaceManager.STD_REGISTRY_SAVE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, registry); if (registry.ID > 0) { ApplicationSession.Refresh(false); hideRegistryId.Value = registry.ID.ToString(); strResult = "Save successful<br /><br />"; return(true); } else { strResult = "Error saving Registry, please try again<br /><br />"; } } return(false); }
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_REGISTRY objDelete) { return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ID)); }
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); } }
public STD_REGISTRY GetItemComplete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID) { STD_REGISTRY 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_REGISTRY_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("@ID", 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 = ParseReaderComplete(CURRENT_USER, CURRENT_REGISTRY_ID, 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 static Int32 SaveWithReporting(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_REGISTRY objSave) { Int32 objReturn = 0; STD_REGISTRYDB objDB = new STD_REGISTRYDB(); objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave); if (objReturn > 0) { string itemPath = ReportManager.CreateRegistryFolder(CURRENT_USER, objReturn); if (!string.IsNullOrEmpty(itemPath)) { ReportManager.CreateDataSet(CURRENT_USER, objReturn); List <USERS> adminUsers = USERSManager.GetSystemUsers(CURRENT_USER, CURRENT_REGISTRY_ID); if (adminUsers != null) { foreach (USERS user in adminUsers) { bool blnFound = false; if (user.USER_ROLES != null) { foreach (USER_ROLES userRole in user.USER_ROLES) { if (userRole.STD_ROLE != null) { switch (userRole.STD_ROLE.CODE) { case "CRSADMIN": ReportManager.AddItemAdmin(CURRENT_USER, CURRENT_REGISTRY_ID, user.USERNAME, itemPath); blnFound = true; break; case "CRSUPD": ReportManager.AddItemUpdate(CURRENT_USER, CURRENT_REGISTRY_ID, user.USERNAME, itemPath); blnFound = true; break; case "CRSREAD": ReportManager.AddItemReadOnly(CURRENT_USER, CURRENT_REGISTRY_ID, user.USERNAME, itemPath); blnFound = true; break; default: break; } } if (blnFound) { break; } } } } } } ReportManager.CreateDataSet(CURRENT_USER, objReturn); } return(objReturn); }