public string ReadSQLFile(string tempUnzippedPath, string sqlProvidername) { string exceptions = string.Empty; try { StreamReader objReader = new StreamReader(tempUnzippedPath + '\\' + sqlProvidername); string sLine = ""; string scriptDetails = ""; ArrayList arrText = new ArrayList(); while (sLine != null) { sLine = objReader.ReadLine(); if (sLine != null) { arrText.Add(sLine); } } objReader.Close(); foreach (string sOutput in arrText) { scriptDetails += sOutput + "\r\n"; } SQLHandler sqlHandler = new SQLHandler(); exceptions = sqlHandler.ExecuteScript(scriptDetails, true); } catch (Exception ex) { exceptions += ex.Message.ToString(); } return(exceptions); }
protected void btnRunScript_Click(object sender, EventArgs e) { string Frequency = ddlFrequency.SelectedItem.Text; string Job = string.Empty; string FilePath = Server.MapPath("~/Install/Job/ManageTracker.sql"); string[] DBInfo = GetDataBaseInfo(); DateTime StartDate = GetDate(); string SDate = string.Format("{0:yyyy-MM-dd}", StartDate); StreamReader sr = new StreamReader(FilePath); if (File.Exists(FilePath)) { Job = sr.ReadToEnd(); Job = Job.Replace("'Frequency'", "'" + Frequency + "'") .Replace("'DatabaseName'", "'" + DBInfo[0] + "'") .Replace("'ManageTracker'", "'" + DBInfo[0] + "'") .Replace("StartingDate", SDate); SQLHandler sageSQLHandler = new SQLHandler(); sageSQLHandler.ExecuteScript(Job, true); } sr.Close(); }
//public static byte[] ConvertImageToByteArray(Stream afuInputStream, int contentLength) //{ // byte[] sqlBinaryData = new byte[contentLength]; // afuInputStream.Read(sqlBinaryData, 0, contentLength); // return sqlBinaryData; //} private void ExecuteSql() { try { SQLHandler objSqlh = new SQLHandler(); if (chkRunAsScript.Checked == true) { string strError = objSqlh.ExecuteScript(txtSqlQuery.Text); if (string.IsNullOrEmpty(strError)) { ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("SQL", "TheQueryCompletedSuccessfully"), "", SageMessageType.Success); } else { ShowMessage(SageMessageTitle.Notification.ToString(), strError, "", SageMessageType.Alert); } } else { System.Data.DataTable dt = objSqlh.ExecuteSQL(txtSqlQuery.Text); if (dt != null) { gdvResults.DataSource = dt; gdvResults.DataBind(); } else { ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("SQL", "ThereIsAnErrorInYourQuery"), "", SageMessageType.Alert); } } string txt = txtSqlQuery.Text; } catch (Exception ex) { ProcessException(ex); } }
public string RemoveSqlScript(string tempUnzippedPath, string sqlProvidername) { string exceptions = string.Empty; try { var objReader = new StreamReader(tempUnzippedPath + '\\' + sqlProvidername); string sLine = ""; string scriptDetails = ""; var arrText = new ArrayList(); while (sLine != null) { sLine = objReader.ReadLine(); if (sLine != null) arrText.Add(sLine); } objReader.Close(); foreach (string sOutput in arrText) { scriptDetails += sOutput + "\r\n"; } var sqlHandler = new SQLHandler(); exceptions = sqlHandler.ExecuteScript(scriptDetails, true); } catch (Exception ex) { exceptions += ex.Message.ToString(); } return exceptions; }
public void RegisterModule(string moduleName, string moduleFolderPath, string procedure) { ModuleInfo objModule = new ModuleInfo(); int _newModuleID = 0; int _newModuleDefID = 0; int _newPortalmoduleID = 0; string Exceptions = string.Empty; string ExtensionMessage = string.Empty; try { //add module and package tables objModule.ModuleName = moduleName; objModule.Name = moduleName; objModule.FriendlyName = moduleName; objModule.Description = txtModuleDescription.Text; objModule.FolderName = moduleName; objModule.Version = "01.00.00";//ddlFirst.SelectedValue + "." + ddlSecond.SelectedValue + "." + ddlLast.SelectedValue;//"01.00.00"; //new Version(1, 0, 0); objModule.Owner = ""; objModule.Organization = ""; objModule.URL = ""; objModule.Email = ""; objModule.ReleaseNotes = ""; objModule.License = ""; objModule.PackageType = "Module"; objModule.isPremium = true; objModule.supportedFeatures = 0; objModule.BusinessControllerClass = ""; objModule.CompatibleVersions = ""; objModule.dependencies = ""; objModule.permissions = ""; ModuleController objController = new ModuleController(); int[] outputValue; outputValue = objController.AddModules(objModule, false, 0, true, DateTimeHelper.GetUtcTime(DateTime.Now), GetPortalID, GetUsername); objModule.ModuleID = outputValue[0]; objModule.ModuleDefID = outputValue[1]; _newModuleID = objModule.ModuleID; _newModuleDefID = objModule.ModuleDefID; //insert into ProtalModule table _newPortalmoduleID = objController.AddPortalModules(GetPortalID, _newModuleID, true, DateTimeHelper.GetUtcTime(DateTime.Now), GetUsername); //install permission for the installed module in ModuleDefPermission table with ModuleDefID and PermissionID // get the default module VIEW permissions int _permissionIDView = objController.GetPermissionByCodeAndKey("SYSTEM_VIEW", "VIEW"); objController.AddModulePermission(_newModuleDefID, _permissionIDView, GetPortalID, _newPortalmoduleID, true, GetUsername, true, DateTimeHelper.GetUtcTime(DateTime.Now), GetUsername); int _permissionIDEdit = objController.GetPermissionByCodeAndKey("SYSTEM_EDIT", "EDIT"); objController.AddModulePermission(_newModuleDefID, _permissionIDEdit, GetPortalID, _newPortalmoduleID, true, GetUsername, true, DateTimeHelper.GetUtcTime(DateTime.Now), GetUsername); RegisterControl(moduleName, moduleFolderPath + moduleName + "/" + moduleName + ".ascx", 1, _newModuleDefID); if (chkEdit.Checked) { RegisterControl(moduleName, moduleFolderPath + moduleName + "/" + moduleName + "Edit" + ".ascx", 2, _newModuleDefID); } if (chkSetting.Checked) { RegisterControl(moduleName, moduleFolderPath + moduleName + "/" + moduleName + "Setting" + ".ascx", 3, _newModuleDefID); } if (Exceptions != string.Empty) { if (objModule.ModuleID > 0 && _newModuleDefID > 0) { Installers install = new Installers(); //Delete Module info from data base install.ModulesRollBack(objModule.ModuleID, GetPortalID); } } else { SQLHandler sageSQLHandler = new SQLHandler(); sageSQLHandler.ExecuteScript(procedure, true); } } catch (Exception ex) { ShowMessage("", ex.ToString(), "", SageMessageType.Error); ProcessException(ex); } Response.Redirect(Request.Url.AbsoluteUri); }
public void RegisterModule(string moduleName, string moduleFolderPath, string procedure) { ModuleInfo objModule = new ModuleInfo(); int _newModuleID = 0; int _newModuleDefID = 0; int _newPortalmoduleID = 0; string Exceptions = string.Empty; string ExtensionMessage = string.Empty; try { //add module and package tables objModule.ModuleName = moduleName; objModule.Name = moduleName; objModule.FriendlyName = moduleName; objModule.Description = txtModuleDescription.Text; objModule.FolderName = moduleName; objModule.Version = "01.00.00";//ddlFirst.SelectedValue + "." + ddlSecond.SelectedValue + "." + ddlLast.SelectedValue;//"01.00.00"; //new Version(1, 0, 0); objModule.Owner = ""; objModule.Organization = ""; objModule.URL = ""; objModule.Email = ""; objModule.ReleaseNotes = ""; objModule.License = ""; objModule.PackageType = "Module"; objModule.isPremium = true; objModule.supportedFeatures = 0; objModule.BusinessControllerClass = ""; objModule.CompatibleVersions = ""; objModule.dependencies = ""; objModule.permissions = ""; ModuleController objController = new ModuleController(); int[] outputValue; outputValue = objController.AddModules(objModule, false, 0, true, DateTime.Now, GetPortalID, GetUsername); objModule.ModuleID = outputValue[0]; objModule.ModuleDefID = outputValue[1]; _newModuleID = objModule.ModuleID; _newModuleDefID = objModule.ModuleDefID; //insert into ProtalModule table _newPortalmoduleID = objController.AddPortalModules(GetPortalID, _newModuleID, true, DateTime.Now, GetUsername); //install permission for the installed module in ModuleDefPermission table with ModuleDefID and PermissionID // get the default module VIEW permissions int _permissionIDView = objController.GetPermissionByCodeAndKey("SYSTEM_VIEW", "VIEW"); objController.AddModulePermission(_newModuleDefID, _permissionIDView, GetPortalID, _newPortalmoduleID, true, GetUsername, true, DateTime.Now, GetUsername); int _permissionIDEdit = objController.GetPermissionByCodeAndKey("SYSTEM_EDIT", "EDIT"); objController.AddModulePermission(_newModuleDefID, _permissionIDEdit, GetPortalID, _newPortalmoduleID, true, GetUsername, true, DateTime.Now, GetUsername); RegisterControl(moduleName, moduleFolderPath + moduleName + "/" + moduleName + ".ascx", 1, _newModuleDefID); if (chkEdit.Checked) { RegisterControl(moduleName, moduleFolderPath + moduleName + "/" + moduleName + "Edit" + ".ascx", 2, _newModuleDefID); } if (chkSetting.Checked) { RegisterControl(moduleName, moduleFolderPath + moduleName + "/" + moduleName + "Setting" + ".ascx", 3, _newModuleDefID); } if (Exceptions != string.Empty) { if (objModule.ModuleID > 0 && _newModuleDefID > 0) { Installers install = new Installers(); //Delete Module info from data base install.ModulesRollBack(objModule.ModuleID, GetPortalID); } } else { SQLHandler sageSQLHandler = new SQLHandler(); sageSQLHandler.ExecuteScript(procedure, true); } } catch (Exception ex) { ShowMessage("", ex.ToString(), "", SageMessageType.Error); ProcessException(ex); } Response.Redirect(Request.Url.AbsoluteUri); }