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