/*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus DoBulkUpdate(BulkUpdateViewModel bulkUpdateViewModel, out int numRows) { // Initialize questStatus status = null; numRows = -1; // TODO: PREP REQUEST BulkUpdateRequest bulkUpdateRequest = new BulkUpdateRequest(); bulkUpdateRequest.FilterId = bulkUpdateViewModel.FilterId; foreach (NameValueViewModel nameValueViewModel in bulkUpdateViewModel.ColumnData) { BulkUpdateColumnValue bulkUpdateColumnValue = new BulkUpdateColumnValue(); bulkUpdateColumnValue.Name = nameValueViewModel.ColumnName; bulkUpdateColumnValue.Value = nameValueViewModel.ColumnValue; BufferMgr.TransferBuffer(nameValueViewModel, bulkUpdateColumnValue); bulkUpdateRequest.Columns.Add(bulkUpdateColumnValue); } // Perform bulk update. BulkUpdateMgr bulkUpdateMgr = new BulkUpdateMgr(this.UserSession); status = bulkUpdateMgr.PerformBulkUpdate(bulkUpdateRequest, out numRows); if (!questStatusDef.IsSuccess(status)) { return(status); } return(status); }
public questStatus PerformBulkUpdateFilterProcedure(BulkUpdateRequest bulkUpdateRequest, FilterProcedure filterProcedure) { // Initialize questStatus status = null; // Execute filter RunFilterRequest runFilterRequest = new RunFilterRequest(); runFilterRequest.FilterId.Id = bulkUpdateRequest.FilterId; ResultsSet resultsSet = null; FilterMgr filterMgr = new FilterMgr(this.UserSession); status = filterMgr.ExecuteFilter(runFilterRequest, out resultsSet); if (!questStatusDef.IsSuccess(status)) { return(new questStatus(status.Severity, String.Format("Error executing filter Id={0}: {1}", runFilterRequest.FilterId.Id, status.Message))); } // Perform operation. status = _dbBulkUpdateMgr.PerformBulkUpdateFilterProcedure(bulkUpdateRequest, filterProcedure, resultsSet); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
private void TriggerBulkUpdate(bool selectedOnly) { var recordsToUpdate = GetRecordsToProcess(selectedOnly); var request = new BulkUpdateRequest(new RecordType(QueryViewModel.RecordType, RecordService.GetDisplayName(QueryViewModel.RecordType)), recordsToUpdate); var bulkUpdateDialog = new BulkUpdateDialog(RecordService, (IDialogController)ApplicationController.ResolveType(typeof(IDialogController)), request, () => { ClearChildForms(); QueryViewModel.DynamicGridViewModel.ReloadGrid(); }); LoadChildForm(bulkUpdateDialog); }
/*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus PerformBulkUpdate(BulkUpdateRequest bulkUpdateRequest, out int numRows) { // Initialize questStatus status = null; numRows = -1; // Get the filter Filter filter = null; FilterId filterId = new FilterId(bulkUpdateRequest.FilterId); FilterMgr filterMgr = new FilterMgr(this.UserSession); status = filterMgr.GetFilter(filterId, out filter); if (!questStatusDef.IsSuccess(status)) { return(status); } bulkUpdateRequest.Filter = filter; // Determine if bulk update filter procedure exists. FilterProcedure filterProcedure = null; status = _dbBulkUpdateMgr.GetFilterProcedure(bulkUpdateRequest, "Update", out filterProcedure); if (!questStatusDef.IsSuccessOrWarning(status)) { return(status); } // Perform bulk update filter procedure if exists. if (questStatusDef.IsSuccess(status)) { return(PerformBulkUpdateFilterProcedure(bulkUpdateRequest, filterProcedure)); } // Generate the SQL status = _dbBulkUpdateMgr.GenerateBulkUpdateSQL(bulkUpdateRequest); if (!questStatusDef.IsSuccess(status)) { return(status); } // Perform bulk update. status = _dbBulkUpdateMgr.PerformBulkUpdate(bulkUpdateRequest, out numRows); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
private void TriggerBulkUpdate(bool selectedOnly) { ApplicationController.DoOnAsyncThread(() => { var recordsToUpdate = GetRecordsToProcess(selectedOnly); var request = new BulkUpdateRequest(new RecordType(QueryViewModel.RecordType, RecordService.GetDisplayName(QueryViewModel.RecordType)), recordsToUpdate); request.AllowExecuteMultiples = RecordService.SupportsExecuteMultiple; var bulkUpdateDialog = new BulkUpdateDialog(RecordService, (IDialogController)ApplicationController.ResolveType(typeof(IDialogController)), request, CompleteChildDialogAndReload); base.LoadChildForm(bulkUpdateDialog); }); }
// // Filter Procedure Utility Routines // public questStatus GetFilterProcedure(BulkUpdateRequest bulkUpdateRequest, string Action, out FilterProcedure filterProcedure) { // Initialize questStatus status = null; filterProcedure = null; // Get the filter procedures. FilterId filterId = new FilterId(bulkUpdateRequest.FilterId); List <FilterProcedure> filterProcedureList = null; DbFilterProceduresMgr dbFilterProceduresMgr = new DbFilterProceduresMgr(this.UserSession); status = dbFilterProceduresMgr.Read(filterId, out filterProcedureList); if (!questStatusDef.IsSuccess(status)) { return(status); } // Determine if given action exists. FilterProcedure UPDATEsproc = filterProcedureList.Find(delegate(FilterProcedure fp) { return(fp.Action == Action); }); if (UPDATEsproc == null) { return(new questStatus(Severity.Warning, String.Format("No {0} filter procedure", Action))); } // Get parameters FilterProcedureId filterProcedureId = new FilterProcedureId(UPDATEsproc.Id); List <FilterProcedureParameter> filterProcedureParameterList = null; DbFilterProcedureParametersMgr dbFilterProcedureParametersMgr = new DbFilterProcedureParametersMgr(this.UserSession); status = dbFilterProcedureParametersMgr.Read(filterProcedureId, out filterProcedureParameterList); if (!questStatusDef.IsSuccess(status)) { return(status); } // Return filter procedure with parameters. UPDATEsproc.ParameterList = filterProcedureParameterList; filterProcedure = UPDATEsproc; return(new questStatus(Severity.Success)); }
public async Task <List <BulkResult> > BatchRequestAsync(BulkUpdateRequest bulkRequest, string method) { var context = JsonConvert.SerializeObject(bulkRequest); httpClient = _baseAuthorization.GetHttpCliente(); var url = $"{ApiUrl}services/data/v{ApiCofiguration.Version}/composite/sobjects"; var request = new HttpRequestMessage(new HttpMethod(method.ToUpper()), url) { Content = new StringContent(context, Encoding.UTF8, "application/json") }; var result = await _baseAuthorization.GetHttpCliente().SendAsync(request); var resultContent = await result.Content.ReadAsStringAsync(); if (!result.IsSuccessStatusCode) { throw new Exception($"Error=>> {resultContent} Token Expired In: {ComvertToDateTimeUnixTimestamp(_baseAuthorization.Timeout)}"); } result.EnsureSuccessStatusCode(); return(JsonConvert.DeserializeObject <List <BulkResult> >(resultContent)); }
/*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus GenerateBulkUpdateSQL(BulkUpdateRequest bulkUpdateRequest) { // Initialize questStatus status = null; StringBuilder sbBulkUPDATE = new StringBuilder(); // Validate if (bulkUpdateRequest.Filter.FilterTableList.Count != 1) { return(new questStatus(Severity.Error, String.Format("ERROR: currently, only single-table filters supported with BUlk Update"))); } // Get info on FROM clause on filter SQL string FROMClause = null; List <FilterEntity> FROMEntityList = null; List <JoinEntity> joinEntityList = null; DbFilterSQLMgr dbFilterSQLMgr = new DbFilterSQLMgr(); status = dbFilterSQLMgr.GetFROMEntities(bulkUpdateRequest.Filter, out FROMClause, out FROMEntityList, out joinEntityList); if (!questStatusDef.IsSuccess(status)) { return(status); } sbBulkUPDATE.AppendLine(String.Format("UPDATE [{0}].[{1}] SET ", bulkUpdateRequest.Filter.FilterTableList[0].TablesetTable.Table.Schema, bulkUpdateRequest.Filter.FilterTableList[0].TablesetTable.Table.Name)); List <string> setClauseList = new List <string>(); for (int idx = 0; idx < bulkUpdateRequest.Columns.Count; idx += 1) { BulkUpdateColumnValue bulkUpdateColumnValue = bulkUpdateRequest.Columns[idx]; string setClause = null; status = getFilterColumn(bulkUpdateColumnValue, bulkUpdateRequest.Filter, FROMEntityList.Count); if (!questStatusDef.IsSuccess(status)) { return(status); } if (bulkUpdateColumnValue.bNull) { setClause += String.Format(" [{0}] = NULL ", bulkUpdateColumnValue.Name); setClauseList.Add(setClause); } else if (!string.IsNullOrEmpty(bulkUpdateColumnValue.Value)) { int _value = 0; if (int.TryParse(bulkUpdateColumnValue.Value, out _value)) { if (_value == -1 && bulkUpdateColumnValue.LookupId >= BaseId.VALID_ID) { continue; } } setClause += String.Format(" [{0}] = {1} ", bulkUpdateColumnValue.Name, getValueIdentifier(bulkUpdateColumnValue)); setClauseList.Add(setClause); } } if (setClauseList.Count == 0) { return(new questStatus(Severity.Error, "There are no columns with data specified to bulk update. At least one column value is required.")); } for (int idx = 0; idx < setClauseList.Count; idx += 1) { string setClause = setClauseList[idx]; if (idx > 0) { sbBulkUPDATE.Append(" ,"); } sbBulkUPDATE.AppendLine(setClause); } // KLUGIE: Get WHERE clause from Filter string whereClause = null; if (bulkUpdateRequest.Filter.SQL.IndexOf("WHERE") > -1) { // NOTE: NEED SUBCLAUSES PARSED OUT; THIS IS A QUICK KLUGIE FOR SINGLE TABLE ONLY. BUT, MANY THINGS CAN COME AFTER A WHERE CLAUSE. // WE'LL FIND OUT WHAT WHEN THE SQL HERE BOMBS OUT. whereClause = bulkUpdateRequest.Filter.SQL.Substring(bulkUpdateRequest.Filter.SQL.IndexOf("WHERE")); // Shamelessly strip off table identifer. SINGLE TABLE ---HAS--- TO BE [T1]. TABLE ALIAS. // I SHOULD BE ASHAMED OF THIS, BUT I'M NOT. GET 'ER DONE. whereClause = whereClause.Replace("[T1].", ""); } if (whereClause != null) { sbBulkUPDATE.AppendLine(whereClause); } // String it and return it. Pray for the best. bulkUpdateRequest.SQL = sbBulkUPDATE.ToString(); return(new questStatus(Severity.Success)); }
public questStatus PerformBulkUpdateFilterProcedure(BulkUpdateRequest bulkUpdateRequest, FilterProcedure filterProcedure, ResultsSet resultsSet) { // Initialize questStatus status = null; BulkUpdateLog bulkUpdateLog = bLogging ? new BulkUpdateLog() : null; BulkUpdateLogId bulkUpdateLogId = null; int numRows = 0; string logMessage = null; List <string> logParameterList = null; try { // Initialize log if (bLogging) { bulkUpdateLog.Event = "Initialize"; bulkUpdateLog.UserSessionId = this.UserSession.Id; bulkUpdateLog.Username = this.UserSession.User.Username; bulkUpdateLog.Batch = Guid.NewGuid().ToString(); string Filter = null; status = _dbBulkUpdateLogsMgr.SetFilter(bulkUpdateRequest.Filter, out Filter); if (!questStatusDef.IsSuccess(status)) { return(status); } bulkUpdateLog.Filter = Filter; } // Get database connection string TablesetId tablesetId = new TablesetId(bulkUpdateRequest.Filter.TablesetId); Tableset tableset = null; DbTablesetsMgr dbTablesetsMgr = new DbTablesetsMgr(this.UserSession); status = dbTablesetsMgr.Read(tablesetId, out tableset); if (!questStatusDef.IsSuccess(status)) { return(status); } if (bLogging) { string Tableset = null; status = _dbBulkUpdateLogsMgr.SetTableset(tableset, out Tableset); if (!questStatusDef.IsSuccess(status)) { return(status); } bulkUpdateLog.Tableset = Tableset; } DatabaseId databaseId = new DatabaseId(tableset.DatabaseId); Quest.Functional.MasterPricing.Database database = null; DbDatabasesMgr dbDatabasesMgr = new DbDatabasesMgr(this.UserSession); status = dbDatabasesMgr.Read(databaseId, out database); if (!questStatusDef.IsSuccess(status)) { return(status); } if (bLogging) { string Database = null; status = _dbBulkUpdateLogsMgr.SetDatabase(database, out Database); if (!questStatusDef.IsSuccess(status)) { return(status); } bulkUpdateLog.Database = Database; } // Connect and execute bool bTransaction = true; // Update all rows are none of them. using (SqlConnection conn = new SqlConnection(database.ConnectionString)) { bulkUpdateLog.Event = "Connect"; conn.Open(); SqlTransaction trans = null; if (bTransaction) { trans = conn.BeginTransaction(); if (bLogging) { bulkUpdateLog.Event = "BeginTransaction"; } } numRows = 0; foreach (dynamic _dynRow in resultsSet.Data) { using (SqlCommand cmd = new SqlCommand(null, conn, trans)) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = filterProcedure.Name; // Initialize logging info if (bLogging) { logParameterList = new List <string>(); bulkUpdateLog.Event = null; bulkUpdateLog.NumRows = numRows; bulkUpdateLog.Parameters = null; bulkUpdateLog.Message = null; bulkUpdateLog.Data = null; } List <string> dataValueList = new List <string>(); foreach (FilterProcedureParameter filterParam in filterProcedure.ParameterList) { if (bLogging) { bulkUpdateLog.Event = "Next Parameter: " + filterParam.ParameterName; } if (filterParam.Direction != "Input") { SqlParameter sqlParam = new SqlParameter(); if (filterParam.Direction == "ReturnValue") { sqlParam.Direction = ParameterDirection.ReturnValue; } else if (filterParam.Direction == "Output") { sqlParam.Direction = ParameterDirection.Output; } else { continue; // Input/ouput TODO } sqlParam.ParameterName = filterParam.ParameterName; // TEMPORARY continue; } if (bLogging) { logParameterList.Add(String.Format(" Id: {0}, ParameterName: {1}, SqlDbType: {2} ", filterParam.Id, filterParam.ParameterName, filterParam.SqlDbType.ToString())); string parameterArray = null; _dbBulkUpdateLogsMgr.SetArray(logParameterList, out parameterArray); bulkUpdateLog.Parameters = parameterArray; } // If a meta-parameter, fill in its value and continue. bool bIsMetaParameter = false; SqlParameter sqlMetaParameter = null; if (filterParam.ParameterName.Equals("@_Username", StringComparison.InvariantCultureIgnoreCase)) { bIsMetaParameter = true; sqlMetaParameter = new SqlParameter(filterParam.ParameterName, SqlDbType.NVarChar); sqlMetaParameter.Value = this.UserSession.User.Username; } else if (filterParam.ParameterName.Equals("@_UserSessionId", StringComparison.InvariantCultureIgnoreCase)) { bIsMetaParameter = true; sqlMetaParameter = new SqlParameter(filterParam.ParameterName, SqlDbType.Int); sqlMetaParameter.Value = this.UserSession.Id; } else if (filterParam.ParameterName.StartsWith("@_", StringComparison.InvariantCultureIgnoreCase)) { logMessage = String.Format("ERROR: unknown meta-parameter: {0}", filterParam.ParameterName); if (bLogging) { bulkUpdateLog.Message = logMessage; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } return(new questStatus(Severity.Error, logMessage)); } if (bIsMetaParameter) { cmd.Parameters.Add(sqlMetaParameter); continue; } // Get the column name from the parameter name FilterItem bulkUpdateFilterItem = bulkUpdateRequest.Filter.FilterItemList.Find(delegate(FilterItem fi) { return(String.Equals(fi.ParameterName, filterParam.ParameterName, StringComparison.CurrentCultureIgnoreCase)); }); if (bulkUpdateFilterItem == null) { if (bTransaction) { trans.Rollback(); } logMessage = String.Format("ERROR: filter item not found for sproc parameter {0}", filterParam.ParameterName); if (bLogging) { bulkUpdateLog.Message = logMessage; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } return(new questStatus(Severity.Error, logMessage)); } // Get the bulk update value. // NOTE: THIS COULD BE A TROUBLE SPOT. ORIGINAL REQUIREMENT WAS SINGLE-ENTITY FILTERS ONLY HAD PROCEDURES. THUS, THOSE FILTER ITEMS // WOULD NEVER HAVE NAMES QUALIFIED BY THE ENTITY THEY'RE IN. BUT, FILTERS WITH ENTITIES THAT HAVE NO COLUMNS IN THE FILTER ITEMS // TECHNICALLY QUALIFY AS 'SINGLE-ENTITY FILTER'. THUS, IF THE NAME ALONE DOESN'T MATCH. GO FOR THE ENTITY_NAME AS A MATCH. BulkUpdateColumnValue bulkUpdateColumnValue = bulkUpdateRequest.Columns.Find(delegate(BulkUpdateColumnValue cv) { return(cv.Name == bulkUpdateFilterItem.FilterColumn.Name); }); if (bulkUpdateColumnValue == null) { bulkUpdateColumnValue = bulkUpdateRequest.Columns.Find(delegate(BulkUpdateColumnValue cv) { string[] parts = cv.Name.Split('_'); if (parts.Length == 2) { return(parts[0] == bulkUpdateFilterItem.FilterColumn.ParentEntityType.Name && parts[1] == bulkUpdateFilterItem.FilterColumn.Name); } return(false); }); } if (bulkUpdateColumnValue == null) { return(new questStatus(Severity.Error, String.Format("ERROR: bulk update column value {0} not found in bulk update columns", bulkUpdateFilterItem.FilterColumn.Name))); } if (bLogging) { bulkUpdateLog.BulkUpdateColumn = String.Format(" Name: {0}, Value: {1} ", bulkUpdateColumnValue.Name, bulkUpdateColumnValue.Value); } // Determine bulk update value to use. string updateValue = null; if (bulkUpdateColumnValue.bNull) { updateValue = null; } else if (!string.IsNullOrEmpty(bulkUpdateColumnValue.Value)) { updateValue = bulkUpdateColumnValue.Value; } else if (filterParam.bRequired) { // Indexing not working, but should be ... ////updateValue = _dynRow[bulkUpdateColumnValue.Name]; bool bFound = false; foreach (KeyValuePair <string, object> kvp in _dynRow) { if (kvp.Key == bulkUpdateColumnValue.Name) { updateValue = kvp.Value != null?kvp.Value.ToString() : null; // Not sure if we go w/ Null here. But, oh well ... bFound = true; break; } } if (!bFound) { return(new questStatus(Severity.Error, String.Format("ERROR: filter results column {0} not found to use in bulk update operation", bulkUpdateColumnValue.Name))); } } else // Value is required, use results value since a value not specified in bulk updates. { updateValue = null; } // Bind the parameter // TODO:REFACTOR SqlDbType sqlDbType = (SqlDbType)Enum.Parse(typeof(SqlDbType), filterParam.SqlDbType, true); SqlParameter sqlParameter = new SqlParameter(filterParam.ParameterName, sqlDbType); if (bLogging) { bulkUpdateLog.Event = "Set Parameter Value"; } if (sqlDbType == SqlDbType.Bit) { bool bValue = updateValue != "0"; sqlParameter.Value = bValue; } else if (sqlDbType == SqlDbType.Int) { int intValue = Convert.ToInt32(updateValue); sqlParameter.Value = intValue; } else if (sqlDbType == SqlDbType.NVarChar) { if (updateValue == null) { sqlParameter.Value = DBNull.Value; } else { sqlParameter.Value = updateValue.ToString(); } } else if (sqlDbType == SqlDbType.VarChar) { if (updateValue == null) { sqlParameter.Value = DBNull.Value; } else { sqlParameter.Value = updateValue.ToString(); } } else if (sqlDbType == SqlDbType.DateTime) { if (updateValue == null) { sqlParameter.Value = DBNull.Value; } else { sqlParameter.Value = Convert.ToDateTime(updateValue); } } else if (sqlDbType == SqlDbType.DateTime2) { if (updateValue == null) { sqlParameter.Value = DBNull.Value; } else { sqlParameter.Value = Convert.ToDateTime(updateValue); } } else if (sqlDbType == SqlDbType.Date) { if (updateValue == null) { sqlParameter.Value = DBNull.Value; } else { sqlParameter.Value = Convert.ToDateTime(updateValue); } } else if (sqlDbType == SqlDbType.Decimal) { if (updateValue == null) { sqlParameter.Value = DBNull.Value; } else { sqlParameter.Value = Convert.ToDecimal(updateValue); } } else { if (updateValue == null) { sqlParameter.Value = DBNull.Value; } else { sqlParameter.Value = updateValue; } } cmd.Parameters.Add(sqlParameter); if (bLogging) { dataValueList.Add(String.Format(" Name: {0}, Value: {1} ", sqlParameter.ParameterName, sqlParameter.Value == DBNull.Value ? "null" : sqlParameter.Value.ToString())); } } // Execute the command try { if (bLogging) { bulkUpdateLog.Event = "ExecuteNonQuery"; } int _numRows = cmd.ExecuteNonQuery(); if (_numRows != 1) { if (bTransaction) { trans.Rollback(); } logMessage = String.Format("ERROR: Bulk update stored procedure failed: Rows: {0}", _numRows); if (bLogging) { bulkUpdateLog.Message = logMessage; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } return(new questStatus(Severity.Error, logMessage)); } else if (bLoggingPerRow) { bulkUpdateLog.Message = "Successful bulk update"; bulkUpdateLog.NumRows = _numRows; bulkUpdateLog.BulkUpdateColumn = null; string valueArray = null; _dbBulkUpdateLogsMgr.SetArray(dataValueList, out valueArray); bulkUpdateLog.Data = valueArray; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } } catch (SqlException ex) { if (bTransaction) { trans.Rollback(); } logMessage = String.Format("SQL EXCEPTION: Bulk update stored procedure {0}: {1}", filterProcedure.Name, ex.Message); if (bLogging) { bulkUpdateLog.Message = logMessage; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } return(new questStatus(Severity.Error, logMessage)); } catch (System.Exception ex) { if (bTransaction) { trans.Rollback(); } logMessage = String.Format("EXCEPTION: Bulk update stored procedure {0}: {1}", filterProcedure.Name, ex.Message); if (bLogging) { bulkUpdateLog.Message = logMessage; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } return(new questStatus(Severity.Error, logMessage)); } } numRows += 1; } if (bTransaction) { trans.Commit(); } if (bLogging) { bulkUpdateLog.Event = "COMMIT"; bulkUpdateLog.NumRows = numRows; bulkUpdateLog.BulkUpdateColumn = null; bulkUpdateLog.Message = "Bulk update operation successful"; bulkUpdateLog.Data = null; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } } } catch (System.Exception ex) { logMessage = String.Format("EXCEPTION: Bulk Update Operation: {0}.{1}: {2}", this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.InnerException != null ? ex.InnerException.Message : ex.Message); if (bLogging) { bulkUpdateLog.Event = bulkUpdateLog.Event == null ? "EXCEPTION" : bulkUpdateLog.Event; bulkUpdateLog.Message = logMessage; bulkUpdateLog.NumRows = numRows; string parameterArray = null; _dbBulkUpdateLogsMgr.SetArray(logParameterList, out parameterArray); bulkUpdateLog.Parameters = parameterArray; string Exception = null; _dbBulkUpdateLogsMgr.SetException(ex, out Exception); bulkUpdateLog.Data = Exception; _dbBulkUpdateLogsMgr.Create(bulkUpdateLog, out bulkUpdateLogId); } return(new questStatus(Severity.Fatal, logMessage)); } return(new questStatus(Severity.Success)); }
public questStatus PerformBulkUpdate(BulkUpdateRequest bulkUpdateRequest, out int numRows) { // Initialize questStatus status = null; numRows = -1; try { // Get database connection string TablesetId tablesetId = new TablesetId(bulkUpdateRequest.Filter.TablesetId); Tableset tableset = null; DbTablesetsMgr dbTablesetsMgr = new DbTablesetsMgr(this.UserSession); status = dbTablesetsMgr.Read(tablesetId, out tableset); if (!questStatusDef.IsSuccess(status)) { return(status); } DatabaseId databaseId = new DatabaseId(tableset.DatabaseId); Quest.Functional.MasterPricing.Database database = null; DbDatabasesMgr dbDatabasesMgr = new DbDatabasesMgr(this.UserSession); status = dbDatabasesMgr.Read(databaseId, out database); if (!questStatusDef.IsSuccess(status)) { return(status); } using (SqlConnection conn = new SqlConnection(database.ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(null, conn)) { cmd.CommandType = CommandType.Text; cmd.CommandText = bulkUpdateRequest.SQL; try { int retval = cmd.ExecuteNonQuery(); if (retval < 0) { return(new questStatus(Severity.Error, String.Format("ERROR: Bulk update failed: {0}", numRows))); } if (retval == 0) { return(new questStatus(Severity.Warning, String.Format("WARNING: {0} rows bulk updated", numRows))); } numRows += retval; } catch (System.Exception ex) { return(new questStatus(Severity.Error, String.Format("EXCEPTION: Bulk update failed: {0}", ex.Message))); } } } } catch (System.Exception ex) { return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}", this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.InnerException != null ? ex.InnerException.Message : ex.Message))); } return(new questStatus(Severity.Success)); }
public async Task <List <BulkResult> > MutipleCreateAsync(BulkUpdateRequest bulkRequest) { return(await BatchRequestAsync(bulkRequest, "POST")); }