private string execute(salsum s) { SqlDbAccess dbAccess = new SqlDbAccess(PKDBHelper.ConnectString); dbAccess.CommandTimeout = 120; string jsonset = string.Empty; if (("{SLT}{SLT2}{SLT3}").IndexOf("{" + s.rmode + "}") >= 0) { string query = @"MBL_SALSUM_Q1"; SqlParamCollection parameters = new SqlParamCollection(); PKDBHelper.SqlAddParam(parameters, "@INFDS", SqlDbType.VarChar, 100, s.infds); PKDBHelper.SqlAddParam(parameters, "@RTNCD", SqlDbType.VarChar, 100, s.rtncd); PKDBHelper.SqlAddParam(parameters, "@RMODE", SqlDbType.VarChar, 20, s.rmode); PKDBHelper.SqlAddParam(parameters, "@TDATE", SqlDbType.VarChar, 8, s.tdate); PKDBHelper.SqlAddParam(parameters, "@SLTTG", SqlDbType.VarChar, 10, s.slttg); DataTable dt = dbAccess.ExecuteSpDataSet(query, parameters).Tables[0]; if (dt.Rows.Count > 0) { return JsonConvert.SerializeObject(dt); //, Formatting.Indented); } else { return string.Empty; } } else { return string.Empty; } }
private string execute(pgmmas p) { SqlDbAccess dbAccess = new SqlDbAccess(PKDBHelper.ConnectString); string jsonset = string.Empty; if (("{SLT}").IndexOf("{" + p.rmode + "}") >= 0) { string query = @"SYS_PGMMAS_Q1"; SqlParamCollection parameters = new SqlParamCollection(); PKDBHelper.SqlAddParam(parameters, "@INFDS", SqlDbType.VarChar, 100, p.infds); PKDBHelper.SqlAddParam(parameters, "@RTNCD", SqlDbType.VarChar, 100, p.rtncd); PKDBHelper.SqlAddParam(parameters, "@RMODE", SqlDbType.VarChar, 20, p.rmode); PKDBHelper.SqlAddParam(parameters, "@USRID", SqlDbType.VarChar, 10, p.usrid); PKDBHelper.SqlAddParam(parameters, "@USRTY", SqlDbType.VarChar, 10, p.usrty); PKDBHelper.SqlAddParam(parameters, "@SYSCD", SqlDbType.VarChar, 20, p.syscd); PKDBHelper.SqlAddParam(parameters, "@ISMBL", SqlDbType.VarChar, 1, p.ismbl); DataTable dt = dbAccess.ExecuteSpDataSet(query, parameters).Tables[0]; if (dt.Rows.Count > 0) { return JsonConvert.SerializeObject(dt, Formatting.Indented); } else { return string.Empty; } } else { return string.Empty; } }
private string execute(usrmas p) { SqlDbAccess dbAccess = new SqlDbAccess(PKDBHelper.ConnectString); string jsonset = string.Empty; if (("{CHKUSR}{CHKAUTH}{SLT}").IndexOf("{" + p.rmode + "}") >= 0) { string query = @"MBL_USRMAS_M1"; SqlParamCollection parameters = new SqlParamCollection(); PKDBHelper.SqlAddParam(parameters, "@INFDS", SqlDbType.VarChar, 100, p.infds); PKDBHelper.SqlAddParam(parameters, "@RTNCD", SqlDbType.VarChar, 100, p.rtncd); PKDBHelper.SqlAddParam(parameters, "@RMODE", SqlDbType.VarChar, 20, p.rmode); PKDBHelper.SqlAddParam(parameters, "@USRID", SqlDbType.VarChar, 10, p.usrid); PKDBHelper.SqlAddParam(parameters, "@PASWD", SqlDbType.VarChar, 10, p.paswd); PKDBHelper.SqlAddParam(parameters, "@IPADR", SqlDbType.VarChar, 20, p.ipadr); PKDBHelper.SqlAddParam(parameters, "@FDATE", SqlDbType.Char, 8, p.fdate); PKDBHelper.SqlAddParam(parameters, "@TDATE", SqlDbType.Char, 8, p.tdate); PKDBHelper.SqlAddParam(parameters, "@SSNID", SqlDbType.VarChar, 50, p.ssnid); PKDBHelper.SqlAddParam(parameters, "@FRMNM", SqlDbType.VarChar, 100, p.frmnm); //PKDBHelper.SqlAddParam(parameters, "@DPTCD", SqlDbType.Char, 20, p.dptcd); //PKDBHelper.SqlAddParam(parameters, "@USEYN", SqlDbType.Char, 1, p.useyn); DataTable dt = dbAccess.ExecuteSpDataSet(query, parameters).Tables[0]; if (dt.Rows.Count > 0) { return JsonConvert.SerializeObject(dt, Formatting.Indented); //if (dt.Rows[0]["RESULT"].ToString() == "OK") //{ // return "OK"; //} //else //{ // if (dt.Rows[0]["MSGID"].ToString() == "ERR0008") // { // return "ERR_USER"; // //PKMessageBox.ShowError("사용자가 등록되어 있지 않습니다!", DialogButtons.Ok, "로그인 에러"); // } // else // { // return "ERR_PWD"; // //PKMessageBox.ShowError("비밀번호를 다시 입력하세요!", DialogButtons.Ok, "로그인 에러"); // } //} } else { return string.Empty; } } else { return string.Empty; } }
private string execute(dptmas d) { SqlDbAccess dbAccess = new SqlDbAccess(PKDBHelper.ConnectString); string jsonset = string.Empty; if (("{SLT}").IndexOf("{" + d.rmode + "}") >= 0) { string query = @"MBL_DPTMAS_M1"; SqlParamCollection parameters = new SqlParamCollection(); PKDBHelper.SqlAddParam(parameters, "@INFDS", SqlDbType.VarChar, 100, d.infds); PKDBHelper.SqlAddParam(parameters, "@RTNCD", SqlDbType.VarChar, 100, d.rtncd); PKDBHelper.SqlAddParam(parameters, "@RMODE", SqlDbType.VarChar, 20, d.rmode); PKDBHelper.SqlAddParam(parameters, "@DPTCD", SqlDbType.VarChar, 10, d.dptcd); DataTable dt = dbAccess.ExecuteSpDataSet(query, parameters).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if(dt.Rows[i]["HPTEL"].ToString().Trim()!=string.Empty) { dt.Rows[i]["HPTEL"] = CryptoHelper.DecryptText(dt.Rows[i]["HPTEL"].ToString().Trim()); } if (dt.Rows[i]["EMAIL"].ToString().Trim() != string.Empty) { dt.Rows[i]["EMAIL"] = CryptoHelper.DecryptText(dt.Rows[i]["EMAIL"].ToString().Trim()); } if (dt.Rows[i]["TELNO"].ToString().Trim() != string.Empty) { dt.Rows[i]["TELNO"] = CryptoHelper.DecryptText(dt.Rows[i]["TELNO"].ToString().Trim()); } //if (dt.Rows[i]["GNAME"].ToString().Trim() != string.Empty) //{ // dt.Rows[i]["GNAME"] = "XXX"; //dt.Rows[i]["GNAME"].ToString().Trim().Replace('(', 'X').Replace(')', 'Y'); //} } return JsonConvert.SerializeObject(dt); //, Formatting.Indented); } else { return string.Empty; } } else { return string.Empty; } }
private IEnumerable<string> DeployRun(string action, ComponentRunContext runContext) { var sb = new StringBuilder(); var dbName = SqlUtils.ToBracketedIdentifier(mDatabaseInfo.Name); var sqlParams = new SqlParamCollection(); sb.AppendFormat( "USE [master]\n" + "IF db_id(@dbName) IS NOT NULL\n" + " ALTER DATABASE {0} SET SINGLE_USER WITH ROLLBACK IMMEDIATE\n" + "RESTORE DATABASE {0} FROM DISK = @backupFile WITH FILE = 1, NOUNLOAD, STATS = 5", dbName); sqlParams.Add("@dbName", SqlDbType.NVarChar).Value = mDatabaseInfo.Name; sqlParams.Add("@backupFile", SqlDbType.NVarChar).Value = mDatabaseInfo.BackupFilePath; if (mDatabaseInfo.Relocate) { var names = SqlUtils.GetLogicalAndPhysicalNamesFromBackupFile(mDatabaseInfo.Connection, mDatabaseInfo.BackupFilePath); var i = 0; foreach (var tuple in names) { var logical = string.Format("@l{0}", i); var physical = string.Format("@p{0}", i); sb.AppendFormat(",\n MOVE {0} TO {1}", logical, physical); var destPath = GetRelocation(tuple.Item2); sqlParams.Add(logical, SqlDbType.NVarChar).Value = tuple.Item1; sqlParams.Add(physical, SqlDbType.NVarChar).Value = destPath; ++i; } } sb.AppendFormat( "\nALTER DATABASE {0} SET MULTI_USER\n", dbName); yield return string.Format("Restoring {0}", mDatabaseInfo.Name); if (!runContext.DryRun) { using (var process = SqlUtils.Exec(mDatabaseInfo.Connection, sb.ToString(), sqlParams)) { foreach (var processOutputLine in process.GetOutput()) { yield return processOutputLine.Line; } } } yield return "Database restore completed."; }
public static IProcessExecutionResult BackupDatabase(DatabaseConnectionConfig databaseConnection, string dbName, string backupFilePath, bool compress) { var sb = new StringBuilder(); sb.AppendFormat("BACKUP DATABASE {0} TO DISK = @backupFile WITH FORMAT, INIT, NAME = @name, SKIP, NOREWIND, NOUNLOAD, STATS = 10", ToBracketedIdentifier(dbName)); var parameters = new SqlParamCollection(); parameters.Add("@backupFile", SqlDbType.NVarChar).Value = backupFilePath; parameters.Add("@name", SqlDbType.NVarChar).Value = dbName; if (compress) sb.Append(", COMPRESSION"); return new SqlCommandExecutionResult(databaseConnection, dbName, sb.ToString(), parameters); }
public Error.Types Update( Context context, SiteSettings ss, SqlParamCollection param = null, List <SqlStatement> additionalStatements = null, bool otherInitValue = false, bool setBySession = true, bool get = true) { if (setBySession) { SetBySession(context: context); } var timestamp = Timestamp.ToDateTime(); var statements = new List <SqlStatement>(); UpdateStatements( context: context, ss: ss, statements: statements, timestamp: timestamp, param: param, otherInitValue: otherInitValue, additionalStatements: additionalStatements); var response = Rds.ExecuteScalar_response( context: context, transactional: true, statements: statements.ToArray()); if (response.Count == 0) { return(Error.Types.UpdateConflicts); } if (get) { Get(context: context); } return(Error.Types.None); }
public Error.Types UpdateOrCreate( RdsUser rdsUser = null, SqlWhereCollection where = null, SqlParamCollection param = null) { SetBySession(); var statements = new List <SqlStatement> { Rds.UpdateOrInsertMailAddresses( where : where ?? Rds.MailAddressesWhereDefault(this), param: param ?? Rds.MailAddressesParamDefault(this, setDefault: true)) }; var response = Rds.ExecuteScalar_response( rdsUser: rdsUser, transactional: true, selectIdentity: true, statements: statements.ToArray()); MailAddressId = (response.Identity ?? MailAddressId).ToLong(); Get(); return(Error.Types.None); }
public ErrorData UpdateOrCreate( Context context, SqlWhereCollection where = null, SqlParamCollection param = null) { SetBySession(context: context); var statements = new List<SqlStatement> { Rds.UpdateOrInsertExportSettings( where: where ?? Rds.ExportSettingsWhereDefault(this), param: param ?? Rds.ExportSettingsParamDefault( context: context, exportSettingModel: this, setDefault: true)) }; var response = Rds.ExecuteScalar_response( context: context, transactional: true, selectIdentity: true, statements: statements.ToArray()); ExportSettingId = (response.Id ?? ExportSettingId).ToLong(); Get(context: context); return new ErrorData(type: Error.Types.None); }
private IEnumerable <DataRow> Get( IContext context, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, bool distinct = false, int top = 0, int offset = 0, int pageSize = 0, bool history = false, bool countRecord = false) { var statements = new List <SqlStatement> { Rds.SelectUsers( dataTableName: "Main", column: column ?? Rds.UsersDefaultColumns(), join: join ?? Rds.UsersJoinDefault(), where : where, orderBy: orderBy, param: param, tableType: tableType, distinct: distinct, top: top, offset: offset, pageSize: pageSize, countRecord: countRecord) }; var dataSet = Rds.ExecuteDataSet( context: context, transactional: false, statements: statements.ToArray()); TotalCount = Rds.Count(dataSet); return(dataSet.Tables["Main"].AsEnumerable()); }
public Error.Types Create( RdsUser rdsUser = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool paramAll = false, bool get = true) { var statements = new List <SqlStatement>(); CreateStatements(statements, tableType, param, paramAll); var newId = Rds.ExecuteScalar_long( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); ExportSettingId = newId != 0 ? newId : ExportSettingId; if (get) { Get(); } return(Error.Types.None); }
public ErrorData Update( Context context, SiteSettings ss, SqlParamCollection param = null, List <SqlStatement> additionalStatements = null, bool otherInitValue = false, bool setBySession = true, bool get = true) { if (setBySession) { SetBySession(context: context); } var statements = new List <SqlStatement>(); statements.AddRange(UpdateStatements( context: context, ss: ss, param: param, otherInitValue: otherInitValue, additionalStatements: additionalStatements)); var response = Rds.ExecuteScalar_response( context: context, transactional: true, statements: statements.ToArray()); if (response.Event == "Conflicted") { return(new ErrorData( type: Error.Types.UpdateConflicts, id: OutgoingMailId)); } if (get) { Get(context: context); } Libraries.Search.Indexes.Create(context, ss, ReferenceId, force: true); return(new ErrorData(type: Error.Types.None)); }
public Error.Types Update( RdsUser rdsUser = null, SqlParamCollection param = null, List<SqlStatement> additionalStatements = null, bool otherInitValue = false, bool get = true) { SetBySession(); var timestamp = Timestamp.ToDateTime(); var statements = new List<SqlStatement>(); UpdateStatements(statements, timestamp, param, otherInitValue, additionalStatements); var response = Rds.ExecuteScalar_response( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); if (response.Count == 0) return Error.Types.UpdateConflicts; if (get) Get(); var siteModel = new ItemModel(ReferenceId).GetSite(); var ss = SiteSettingsUtilities.Get(siteModel, siteModel.SiteId); Libraries.Search.Indexes.Create(ss, ReferenceId, force: true); return Error.Types.None; }
public List <SqlStatement> CreateStatements( SiteSettings ss, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool paramAll = false) { return(new List <SqlStatement> { Rds.InsertGroups( tableType: tableType, selectIdentity: true, param: param ?? Rds.GroupsParamDefault( this, setDefault: true, paramAll: paramAll)), Rds.InsertGroupMembers( tableType: tableType, param: param ?? Rds.GroupMembersParam() .GroupId(raw: Def.Sql.Identity) .UserId(Sessions.UserId()) .Admin(true)), StatusUtilities.UpdateStatus(StatusUtilities.Types.GroupsUpdated) }); }
public List <SqlStatement> CreateStatements( List <SqlStatement> statements, SiteSettings ss, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool otherInitValue = false) { statements.AddRange(new List <SqlStatement> { Rds.InsertItems( selectIdentity: true, param: Rds.ItemsParam() .ReferenceType("Wikis") .SiteId(SiteId) .Title(Title.DisplayValue)), Rds.InsertWikis( tableType: tableType, param: param ?? Rds.WikisParamDefault( this, setDefault: true, otherInitValue: otherInitValue)), }); return(statements); }
private List <SqlStatement> UpdateStatements( List <SqlStatement> statements, DateTime timestamp, SqlParamCollection param, bool paramAll = false, List <SqlStatement> additionalStatements = null) { statements.AddRange(new List <SqlStatement> { Rds.UpdateBinaries( verUp: VerUp, where : Rds.BinariesWhereDefault(this) .UpdatedTime(timestamp, _using: timestamp.InRange()), param: param ?? Rds.BinariesParamDefault(this, paramAll: paramAll), countRecord: true) }); if (additionalStatements?.Any() == true) { statements.AddRange(additionalStatements); } return(statements); }
private List <SqlStatement> UpdateStatements( Context context, string dataTableName = null, SqlWhereCollection where = null, SqlParamCollection param = null, bool otherInitValue = false) { return(new List <SqlStatement> { Rds.UpdateDepts( dataTableName: dataTableName, where : where, param: param ?? Rds.DeptsParamDefault( context: context, deptModel: this, otherInitValue: otherInitValue)), new SqlStatement(Def.Sql.IfConflicted.Params(DeptId)), StatusUtilities.UpdateStatus( tenantId: context.TenantId, type: StatusUtilities.Types.DeptsUpdated), }); }
public Error.Types Create( SiteSettings ss, RdsUser rdsUser = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool notice = false, bool paramAll = false, bool get = true) { var statements = CreateStatements(ss, tableType, param, paramAll); var newId = Rds.ExecuteScalar_long( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); WikiId = newId != 0 ? newId : WikiId; if (Contract.Notice() && notice) { SetTitle(ss); CheckNotificationConditions(ss); Notice(ss, "Created"); } if (get) { Get(ss); } var fullText = FullText(ss, onCreating: true); Rds.ExecuteNonQuery( rdsUser: rdsUser, statements: Rds.UpdateItems( param: Rds.ItemsParam() .Title(Title.DisplayValue) .FullText(fullText, _using: fullText != null) .SearchIndexCreatedTime(DateTime.Now, _using: fullText != null), where : Rds.ItemsWhere().ReferenceId(WikiId))); Libraries.Search.Indexes.Create(ss, this); return(Error.Types.None); }
public List <SqlStatement> UpdateStatements( Context context, SiteSettings ss, string dataTableName = null, IEnumerable <string> permissions = null, bool permissionChanged = false, SqlParamCollection param = null, bool otherInitValue = false, List <SqlStatement> additionalStatements = null) { var timestamp = Timestamp.ToDateTime(); var statements = new List <SqlStatement>(); var where = Rds.TenantsWhereDefault(this) .UpdatedTime(timestamp, _using: timestamp.InRange()); if (Versions.VerUp( context: context, ss: ss, verUp: VerUp)) { statements.Add(Rds.TenantsCopyToStatement( where : where, tableType: Sqls.TableTypes.History, ColumnNames())); Ver++; } statements.AddRange(UpdateStatements( context: context, dataTableName: dataTableName, where : where, param: param, otherInitValue: otherInitValue)); statements.AddRange(UpdateAttachmentsStatements(context: context)); if (additionalStatements?.Any() == true) { statements.AddRange(additionalStatements); } return(statements); }
public Error.Types Create( RdsUser rdsUser = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool otherInitValue = false, bool get = true) { var statements = new List <SqlStatement>(); CreateStatements(statements, tableType, param, otherInitValue); var newId = Rds.ExecuteScalar_int( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); TenantId = newId != 0 ? newId : TenantId; if (get) { Get(); } return(Error.Types.None); }
public WikiModel Get( SiteSettings ss, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, bool distinct = false, int top = 0) { Set(ss, Rds.ExecuteTable(statements: Rds.SelectWikis( tableType: tableType, column: column ?? Rds.WikisEditorColumns(ss), join: join ?? Rds.WikisJoinDefault(), where : where ?? Rds.WikisWhereDefault(this), orderBy: orderBy ?? null, param: param ?? null, distinct: distinct, top: top))); return(this); }
public Error.Types UpdateOrCreate( RdsUser rdsUser = null, SqlWhereCollection where = null, SqlParamCollection param = null) { SetBySession(); var statements = new List <SqlStatement> { Rds.UpdateOrInsertTemplates( selectIdentity: true, where : where ?? Rds.TemplatesWhereDefault(this), param: param ?? Rds.TemplatesParamDefault(this, setDefault: true)) }; var newId = Rds.ExecuteScalar_int( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); TemplateId = newId != 0 ? newId : TemplateId; Get(); return(Error.Types.None); }
public Error.Types Update( SiteSettings ss, IEnumerable <string> permissions = null, bool permissionChanged = false, RdsUser rdsUser = null, SqlParamCollection param = null, bool paramAll = false) { SetBySession(); var statements = UpdateStatements(param, paramAll); try { var count = Rds.ExecuteScalar_int( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); if (count == 0) { return(Error.Types.UpdateConflicts); } } catch (System.Data.SqlClient.SqlException e) { if (e.Number == 2601) { return(Error.Types.LoginIdAlreadyUse); } else { throw; } } Get(ss); UpdateMailAddresses(); SetSiteInfo(); return(Error.Types.None); }
public ErrorData Update( Context context, SiteSettings ss, SqlParamCollection param = null, List <SqlStatement> additionalStatements = null, bool otherInitValue = false, bool setBySession = true, bool get = true) { if (setBySession) { SetBySession(context: context); } var statements = new List <SqlStatement>(); statements.AddRange(UpdateStatements( context: context, ss: ss, param: param, otherInitValue: otherInitValue, additionalStatements: additionalStatements)); var response = Repository.ExecuteScalar_response( context: context, transactional: true, statements: statements.ToArray()); if (response.Event == "Conflicted") { return(new ErrorData( type: Error.Types.UpdateConflicts, id: ExtensionId)); } if (get) { Get(context: context); } return(new ErrorData(type: Error.Types.None)); }
public Error.Types UpdateOrCreate( Context context, SqlWhereCollection where = null, SqlParamCollection param = null) { SetBySession(context: context); var statements = new List <SqlStatement> { Rds.UpdateOrInsertBinaries( where : where ?? Rds.BinariesWhereDefault(this), param: param ?? Rds.BinariesParamDefault( context: context, binaryModel: this, setDefault: true)) }; var response = Rds.ExecuteScalar_response( context: context, transactional: true, selectIdentity: true, statements: statements.ToArray()); BinaryId = (response.Identity ?? BinaryId).ToLong(); Get(context: context); return(Error.Types.None); }
public ErrorData UpdateOrCreate( Context context, SqlWhereCollection where = null, SqlParamCollection param = null) { SetBySession(context: context); var statements = new List <SqlStatement> { Rds.UpdateOrInsertDemos( where : where ?? Rds.DemosWhereDefault(this), param: param ?? Rds.DemosParamDefault( context: context, demoModel: this, setDefault: true)) }; var response = Repository.ExecuteScalar_response( context: context, transactional: true, selectIdentity: true, statements: statements.ToArray()); DemoId = (response.Id ?? DemoId).ToInt(); Get(context: context); return(new ErrorData(type: Error.Types.None)); }
public Error.Types Update( RdsUser rdsUser = null, SqlParamCollection param = null, bool paramAll = false, bool get = true) { SetBySession(); var statements = UpdateStatements(param, paramAll); var count = Rds.ExecuteScalar_int( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); if (count == 0) { return(Error.Types.UpdateConflicts); } if (get) { Get(); } return(Error.Types.None); }
public Error.Types Update( SiteSettings ss, IEnumerable <string> permissions = null, bool permissionChanged = false, RdsUser rdsUser = null, SqlParamCollection param = null, bool paramAll = false) { SetBySession(); var statements = UpdateStatements(param, paramAll); var count = Rds.ExecuteScalar_int( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); if (count == 0) { return(Error.Types.UpdateConflicts); } Get(ss); SiteInfo.Reflesh(); return(Error.Types.None); }
public List<SqlStatement> CreateStatements( Context context, string dataTableName = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool otherInitValue = false) { var statements = new List<SqlStatement>(); statements.AddRange(new List<SqlStatement> { Rds.InsertExportSettings( dataTableName: dataTableName, tableType: tableType, selectIdentity: true, param: param ?? Rds.ExportSettingsParamDefault( context: context, exportSettingModel: this, setDefault: true, otherInitValue: otherInitValue)) }); statements.AddRange(UpdateAttachmentsStatements(context: context)); return statements; }
public ErrorData Create( Context context, SiteSettings ss, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool otherInitValue = false, bool get = true) { var statements = new List<SqlStatement>(); statements.AddRange(CreateStatements( context: context, tableType: tableType, param: param, otherInitValue: otherInitValue)); var response = Rds.ExecuteScalar_response( context: context, transactional: true, selectIdentity: true, statements: statements.ToArray()); ExportSettingId = (response.Id ?? ExportSettingId).ToLong(); if (get) Get(context: context); return new ErrorData(type: Error.Types.None); }
public Error.Types Update( RdsUser rdsUser = null, SqlParamCollection param = null, bool paramAll = false) { SetBySession(); var statements = UpdateStatements(param, paramAll); var count = Rds.ExecuteScalar_int( rdsUser: rdsUser, transactional: true, statements: statements.ToArray()); if (count == 0) { return(Error.Types.UpdateConflicts); } Get(); var siteModel = new ItemModel(ReferenceId).GetSite(); var ss = SiteSettingsUtilities.Get(siteModel, siteModel.SiteId); Libraries.Search.Indexes.Create(ss, ReferenceId); return(Error.Types.None); }
public Error.Types Create( RdsUser rdsUser = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlParamCollection param = null, bool otherInitValue = false, bool get = true) { var statements = new List <SqlStatement>(); CreateStatements(statements, tableType, param, otherInitValue); var response = Rds.ExecuteScalar_response( rdsUser: rdsUser, transactional: true, selectIdentity: true, statements: statements.ToArray()); HealthId = (response.Identity ?? HealthId).ToLong(); if (get) { Get(); } return(Error.Types.None); }
private List <SqlStatement> UpdateStatements( Context context, string dataTableName = null, SqlWhereCollection where = null, SqlParamCollection param = null, bool otherInitValue = false) { return(new List <SqlStatement> { Rds.UpdateMailAddresses( dataTableName: dataTableName, where : where, param: param ?? Rds.MailAddressesParamDefault( context: context, mailAddressModel: this, otherInitValue: otherInitValue)), new SqlStatement(Def.Sql.IfConflicted.Params(MailAddressId)) { IfConflicted = true, Id = MailAddressId } }); }
public IssueCollection( Context context, SiteSettings ss, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, bool distinct = false, int top = 0, int offset = 0, int pageSize = 0, bool get = true, List <FormData> formDataSet = null) { if (get) { Set( context: context, ss: ss, dataRows: Get( context: context, ss: ss, column: column, join: join, where : where, orderBy: orderBy, param: param, tableType: tableType, distinct: distinct, top: top, offset: offset, pageSize: pageSize), formDataSet: formDataSet); } }
public MailAddressModel Get( Context context, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, bool distinct = false, int top = 0) { Set(context, Rds.ExecuteTable( context: context, statements: Rds.SelectMailAddresses( tableType: tableType, column: column ?? Rds.MailAddressesDefaultColumns(), join: join ?? Rds.MailAddressesJoinDefault(), where : where ?? Rds.MailAddressesWhereDefault(this), orderBy: orderBy, param: param, distinct: distinct, top: top))); return(this); }
public ErrorData UpdateOrCreate( Context context, SiteSettings ss, SqlWhereCollection where = null, SqlParamCollection param = null) { SetBySession(context: context); var statements = new List <SqlStatement> { Rds.UpdateOrInsertRegistrations( where : where ?? Rds.RegistrationsWhereDefault(this), param: param ?? Rds.RegistrationsParamDefault( context: context, registrationModel: this, setDefault: true)), }; var response = Rds.ExecuteScalar_response( context: context, transactional: true, selectIdentity: true, statements: statements.ToArray()); RegistrationId = (response.Id ?? RegistrationId).ToInt(); Get(context: context, ss: ss); return(new ErrorData(type: Error.Types.None)); }
public static void SqlAddParam(SqlParamCollection pCols, string parameterName, System.Data.SqlDbType dbType, int size, System.Data.ParameterDirection direction, dynamic defaultVal, dynamic elementValue) { pCols.Add(parameterName, dbType, size, direction, elementValue == null ? defaultVal : elementValue); }
private void RestoreDatabase(DatabaseBackupInfo db, bool dryRun, ILog log) { var sb = new StringBuilder(); var dbName = SqlUtils.ToBracketedIdentifier(db.Name); var sqlParams = new SqlParamCollection(); sb.AppendFormat( "USE [master]\n" + "IF db_id(@dbName) IS NOT NULL\n" + " ALTER DATABASE {0} SET SINGLE_USER WITH ROLLBACK IMMEDIATE\n" + "RESTORE DATABASE {0} FROM DISK = @backupFile WITH FILE = 1, NOUNLOAD, STATS = 5", dbName); sqlParams.Add("@dbName", SqlDbType.NVarChar).Value = db.Name; sqlParams.Add("@backupFile", SqlDbType.NVarChar).Value = db.BackupFilePath; if (mDatabaseConnection.Relocate) { var names = SqlUtils.GetLogicalAndPhysicalNamesFromBackupFile(mDatabaseConnection, db.BackupFilePath); var i = 0; foreach (var tuple in names) { var logical = string.Format("@l{0}", i); var physical = string.Format("@p{0}", i); sb.AppendFormat(",\n MOVE {0} TO {1}", logical, physical); var destPath = GetRelocation(db.Name, mDatabaseConnection.RelocatePath, tuple.Item2); sqlParams.Add(logical, SqlDbType.NVarChar).Value = tuple.Item1; sqlParams.Add(physical, SqlDbType.NVarChar).Value = destPath; ++i; } } sb.AppendFormat( "\nALTER DATABASE {0} SET MULTI_USER\n", dbName); log.LogFormat("Restoring {0} from {1}", db.Name, db.BackupFilePath); if (!dryRun) { using (var process = SqlUtils.Exec(mDatabaseConnection, db.Name, sb.ToString(), sqlParams)) using (log.IndentScope()) { foreach (var processOutputLine in process.GetOutput()) { log.Log(processOutputLine.Line); } } } log.Log("Database restore completed."); }