protected override void Dispose(bool disposing) { if (disposing) { reader?.Dispose(); reader = null; cmd?.Dispose(); cmd = null; } base.Dispose(disposing); }
public WrappedReader(IDbCommand cmd, IDataReader reader) { this.cmd = cmd; this.reader = reader; }
public override System.Threading.Tasks.Task PostprocessAsync(System.Data.Common.DbDataReader reader, System.Collections.Generic.IList <System.Exception> exceptions, System.Threading.CancellationToken token) { storeVersion(); // Nothing return(System.Threading.Tasks.Task.CompletedTask); }
public async System.Threading.Tasks.Task <EventSourcingTests.Aggregation.Invoice> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { var id = await reader.GetFieldValueAsync <System.Guid>(0, token); EventSourcingTests.Aggregation.Invoice document; document = await _serializer.FromJsonAsync <EventSourcingTests.Aggregation.Invoice>(reader, 1, token).ConfigureAwait(false); _session.MarkAsDocumentLoaded(id, document); return(document); }
public EventSourcingTests.Aggregation.Invoice Resolve(System.Data.Common.DbDataReader reader) { EventSourcingTests.Aggregation.Invoice document; document = _serializer.FromJson <EventSourcingTests.Aggregation.Invoice>(reader, 0); return(document); }
protected internal override IndexDocumentData GetIndexDocumentDataFromReader(System.Data.Common.DbDataReader reader) { WriteLog(MethodInfo.GetCurrentMethod(), reader); return(base.GetIndexDocumentDataFromReader(reader)); }
public DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested Resolve(System.Data.Common.DbDataReader reader) { var id = reader.GetFieldValue <System.Guid>(0); if (_identityMap.TryGetValue(id, out var existing)) { return(existing); } DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested document; document = _serializer.FromJson <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested>(reader, 1); _session.MarkAsDocumentLoaded(id, document); _identityMap[id] = document; StoreTracker(_session, document); return(document); }
public DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested Resolve(System.Data.Common.DbDataReader reader) { var id = reader.GetFieldValue <System.Guid>(0); DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested document; document = _serializer.FromJson <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested>(reader, 1); _session.MarkAsDocumentLoaded(id, document); return(document); }
public ActionStatus SaveHardwareKit(Entity.KitVerifyRequest requestData, bool isEdit) { var response = new ActionStatus(); try { logger.Information(Constants.ACTION_ENTRY, "HardwareKitRepository.SaveHardwareKit"); var createdHardwareKits = new List <BulkUploadResponse>(); var xmlData = string.Empty; using (var stringwriter = new System.IO.StringWriter()) { var serializer = new XmlSerializer(requestData.GetType()); serializer.Serialize(stringwriter, requestData); xmlData = stringwriter.ToString(); } using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, component.helper.SolutionConfiguration.Version); parameters.Add(sqlDataAccess.CreateParameter("data", xmlData.ToString(), DbType.Xml, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("isEdit", (isEdit == false ? 0 : 1), DbType.Boolean, ParameterDirection.Input)); System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[HardwareKit_AddUpdate]", CommandType.StoredProcedure, null), parameters.ToArray()); while (dbDataReader.Read()) { var item = new Entity.BulkUploadResponse(); if (dbDataReader["kitGuid"] != null) { item.kitGuid = new Guid(dbDataReader["kitGuid"].ToString().ToUpper()); item.kitTypeGuid = new Guid(dbDataReader["kitTypeGuid"].ToString().ToUpper()); item.kitCode = (dbDataReader["kitCode"].ToString()); createdHardwareKits.Add(item); } else { response.Message = dbDataReader["fieldname"].ToString().ToUpper(); response.Data = "Unable to save Hardware Kit!"; response.Success = false; } } if ((createdHardwareKits.Count != 0 && createdHardwareKits.Count > 0) || isEdit) { response.Success = true; response.Message = "Hardware Kit saved successfully!"; response.Data = createdHardwareKits; } else { response.Success = false; response.Data = createdHardwareKits; response.Message = "Unable to save Hardware Kit!"; } } logger.Information(Constants.ACTION_EXIT, "HardwareKitRepository.SaveHardwareKit"); } catch (Exception ex) { response.Success = false; response.Message = ex.Message.ToString(); logger.Error(Constants.ACTION_EXCEPTION, ex); } return(response); }
} // End Sub WriteAssociativeArray private static void WriteAssociativeArray(Newtonsoft.Json.JsonTextWriter jsonWriter, System.Data.Common.DbDataReader dr, bool dataType) { // JSON: //{ // "column_1":{ "index":0,"fieldType":"int"} // ,"column_2":{ "index":1,"fieldType":"int"} //} jsonWriter.WriteStartObject(); for (int i = 0; i < dr.FieldCount; ++i) { jsonWriter.WritePropertyName(dr.GetName(i)); jsonWriter.WriteStartObject(); jsonWriter.WritePropertyName("index"); jsonWriter.WriteValue(i); #if false jsonWriter.WritePropertyName("columnName"); jsonWriter.WriteValue(dr.GetName(i)); #endif if (dataType) { jsonWriter.WritePropertyName("fieldType"); jsonWriter.WriteValue(GetAssemblyQualifiedNoVersionName(dr.GetFieldType(i))); } // End if (dataType) jsonWriter.WriteEndObject(); } // Next i jsonWriter.WriteEndObject(); } // End Sub WriteAssociativeArray
} // End Sub WriteArray public virtual void SerializeDataTableAsAssociativeJsonArray(System.Data.Common.DbCommand cmd, System.IO.Stream output, bool pretty, System.Text.Encoding enc) { Newtonsoft.Json.JsonSerializer ser = new Newtonsoft.Json.JsonSerializer(); using (System.IO.TextWriter sw = new System.IO.StreamWriter(output, enc)) { using (Newtonsoft.Json.JsonTextWriter jsonWriter = new Newtonsoft.Json.JsonTextWriter(sw)) { if (pretty) { jsonWriter.Formatting = Newtonsoft.Json.Formatting.Indented; } // jsonWriter.WriteStartObject(); // jsonWriter.WritePropertyName("tables"); // jsonWriter.WriteStartArray(); using (System.Data.Common.DbConnection con = this.Connection) { cmd.Connection = con; if (con.State != System.Data.ConnectionState.Open) { con.Open(); } try { using (System.Data.Common.DbDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess | System.Data.CommandBehavior.CloseConnection )) { do { // jsonWriter.WriteStartObject(); // tbl = new Table(); //jsonWriter.WritePropertyName("columns"); //// WriteArray(jsonWriter, dr); //WriteAssociativeArray(jsonWriter, dr); //jsonWriter.WritePropertyName("rows"); jsonWriter.WriteStartArray(); if (dr.HasRows) { string[] columns = new string[dr.FieldCount]; for (int i = 0; i < dr.FieldCount; i++) { columns[i] = dr.GetName(i); } // Next i while (dr.Read()) { object[] thisRow = new object[dr.FieldCount]; // jsonWriter.WriteStartArray(); // object[] thisRow = new object[dr.FieldCount]; jsonWriter.WriteStartObject(); // tbl = new Table(); for (int i = 0; i < dr.FieldCount; ++i) { jsonWriter.WritePropertyName(columns[i]); object obj = dr.GetValue(i); if (obj == System.DBNull.Value) { obj = null; } jsonWriter.WriteValue(obj); } // Next i // jsonWriter.WriteEndArray(); // tbl.Rows.Add(thisRow); jsonWriter.WriteEndObject(); } // Whend } // End if (dr.HasRows) jsonWriter.WriteEndArray(); // jsonWriter.WriteEndObject(); // ser.Tables.Add(tbl); } while (dr.NextResult()); } // End using dr } catch (System.Exception ex) { System.Console.WriteLine(ex.Message); throw; } if (con.State != System.Data.ConnectionState.Closed) { con.Close(); } } // End using con // jsonWriter.WriteEndArray(); // jsonWriter.WriteEndObject(); jsonWriter.Flush(); } // End Using jsonWriter } // End Using sw } // End Sub SerializeDataTableAsAssociativeJsonArray
private static void WriteAssociativeArray(Newtonsoft.Json.JsonTextWriter jsonWriter, System.Data.Common.DbDataReader dr) { WriteAssociativeArray(jsonWriter, dr, false); } // End Sub WriteAssociativeArray
private static string GetInsertSQL(string pTable, System.Data.Common.DbDataReader pDataReader) { StringBuilder InsertSQL = new StringBuilder(); StringBuilder ValueSQL = new StringBuilder(); InsertSQL.Append("Insert Into "); InsertSQL.Append(pTable); InsertSQL.Append(" ("); ValueSQL.Append(" values ("); foreach (System.Data.OleDb.OleDbParameter param in pDataReader) { //string FieldName = param.ParameterName.TrimStart(new char[] { '@' }); string FieldName = param.SourceColumn; if (FieldName.ToUpperInvariant() == "UNIQUEKEY") { continue; //ValueSQL.Append("null"); //param.Value = DBNull.Value; } else { InsertSQL.Append("["); InsertSQL.Append(FieldName); InsertSQL.Append("],"); if (pDataReader[FieldName] == DBNull.Value) { ValueSQL.Append("null"); } else { switch (pDataReader[FieldName].GetType().ToString()) { case "System.Int32": case "System.Decimal": case "System.Boolean": case "System.Double": case "System.Single": case "System.Byte": ValueSQL.Append(pDataReader[FieldName].ToString().Replace("'", "''")); break; default: ValueSQL.Append("'"); ValueSQL.Append(pDataReader[FieldName].ToString().Replace("'", "''")); ValueSQL.Append("'"); break; } } } ValueSQL.Append(","); } InsertSQL.Length = InsertSQL.Length - 1; ValueSQL.Length = ValueSQL.Length - 1; InsertSQL.Append(")"); ValueSQL.Append(")"); InsertSQL.Append(ValueSQL); return(InsertSQL.ToString()); }
/// <summary> /// Update one row /// </summary> /// <param name="pFileString">File String</param> /// <param name="pUpdateSQL">Update SQL Statement</param> /// <param name="pCommand">Command</param> /// <returns>bool</returns> public static bool Update_1_Row(string pFileString, string pSelectSQL, string pKeyString, System.Data.Common.DbDataReader pDataReader) { /* * NOTE FROM EPI1: The original contents of this method have been moved to SqlDatabase.Update_1_Row * and OleDbDatabase.Update_1_Row. * */ bool result = false; DataSet dataSet = new DataSet(); DataTable Temp = new DataTable(); string connString = ParseConnectionString(pFileString); if (DataSource != null) { IDbDriver driver = DataSource.CreateDatabaseObject(new System.Data.Common.DbConnectionStringBuilder()); driver.ConnectionString = connString; result = driver.Update_1_Row(pSelectSQL, pKeyString, pDataReader); } return(result); }
public EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity Resolve(System.Data.Common.DbDataReader reader) { var id = reader.GetFieldValue <System.Guid>(0); if (_identityMap.TryGetValue(id, out var existing)) { return(existing); } EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity document; document = _serializer.FromJson <EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity>(reader, 1); _session.MarkAsDocumentLoaded(id, document); _identityMap[id] = document; StoreTracker(_session, document); return(document); }
public async System.Threading.Tasks.Task <EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { var id = await reader.GetFieldValueAsync <System.Guid>(0, token); if (_identityMap.TryGetValue(id, out var existing)) { return(existing); } EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity document; document = await _serializer.FromJsonAsync <EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity>(reader, 1, token).ConfigureAwait(false); _session.MarkAsDocumentLoaded(id, document); _identityMap[id] = document; return(document); }
public async System.Threading.Tasks.Task <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested document; document = await _serializer.FromJsonAsync <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested>(reader, 0, token).ConfigureAwait(false); return(document); }
public ActionStatus UploadHardwareKit(List <Entity.HardwareKitDTO> requestData) { var response = new ActionStatus(); try { logger.Information(Constants.ACTION_ENTRY, "HardwareKitRepository.SaveHardwareKit"); List <Guid> createdHardwareKits = new List <Guid>(); var stringResult = string.Empty; using (var stringwriter = new System.IO.StringWriter()) { var serializer = new XmlSerializer(requestData.GetType()); serializer.Serialize(stringwriter, requestData); stringResult = stringwriter.ToString(); } stringResult = stringResult.Replace("HardwareKitDTO", "HardwareKit").Replace("KitDeviceDTO", "KitDevice"); XDocument requestXML = XDocument.Parse(stringResult); requestXML = new XDocument(new XElement("HardwareKits", requestXML.Root)); using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, component.helper.SolutionConfiguration.Version); parameters.Add(sqlDataAccess.CreateParameter("data", requestXML.ToString(), DbType.Xml, ParameterDirection.Input)); System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[KitDevice_AddUpdate]", CommandType.StoredProcedure, null), parameters.ToArray()); while (dbDataReader.Read()) { if (dbDataReader["guid"] != null) { createdHardwareKits.Add(new Guid(dbDataReader["guid"].ToString().ToUpper())); } else { response.Message = dbDataReader["fieldname"].ToString().ToUpper(); response.Data = null; response.Success = false; } } if (createdHardwareKits.Count != 0 && createdHardwareKits.Count == 1) { // requestData.Guid = createdHardwareKits.FirstOrDefault(); response.Success = true; response.Data = requestData; } else { response.Success = false; response.Data = requestData; response.Message = "Unable to save Hardware-Kit"; } //var result = DataUtils.DataReaderToList<Entity.HardwareKitResponse>(dbDataReader, null); //result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString()); } logger.Information(Constants.ACTION_EXIT, "HardwareKitRepository.SaveHardwareKit"); } catch (Exception ex) { response.Success = false; response.Message = ex.Message.ToString(); logger.Error(Constants.ACTION_EXCEPTION, ex); } return(response); }
public async System.Threading.Tasks.Task <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { var id = await reader.GetFieldValueAsync <System.Guid>(0, token); DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested document; document = await _serializer.FromJsonAsync <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested>(reader, 1, token).ConfigureAwait(false); _session.MarkAsDocumentLoaded(id, document); return(document); }
public DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass Resolve(System.Data.Common.DbDataReader reader) { DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass document; document = _serializer.FromJson <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass>(reader, 0); return(document); }
public async System.Threading.Tasks.Task <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { var id = await reader.GetFieldValueAsync <System.Guid>(0, token); if (_identityMap.TryGetValue(id, out var existing)) { return(existing); } DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested document; document = await _serializer.FromJsonAsync <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested>(reader, 1, token).ConfigureAwait(false); _session.MarkAsDocumentLoaded(id, document); _identityMap[id] = document; StoreTracker(_session, document); return(document); }
public async System.Threading.Tasks.Task <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass document; document = await _serializer.FromJsonAsync <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass>(reader, 0, token).ConfigureAwait(false); return(document); }
public override async System.Threading.Tasks.Task PostprocessAsync(System.Data.Common.DbDataReader reader, System.Collections.Generic.IList <System.Exception> exceptions, System.Threading.CancellationToken token) { storeVersion(); await postprocessUpdateAsync(reader, exceptions, token); }
public DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass Resolve(System.Data.Common.DbDataReader reader) { var id = reader.GetFieldValue <System.Guid>(0); DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass document; document = _serializer.FromJson <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass>(reader, 1); _session.MarkAsDocumentLoaded(id, document); return(document); }
public async System.Threading.Tasks.Task <EventSourcingTests.Aggregation.Invoice> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { EventSourcingTests.Aggregation.Invoice document; document = await _serializer.FromJsonAsync <EventSourcingTests.Aggregation.Invoice>(reader, 0, token).ConfigureAwait(false); return(document); }
public async System.Threading.Tasks.Task <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { var id = await reader.GetFieldValueAsync <System.Guid>(0, token); DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass document; document = await _serializer.FromJsonAsync <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass>(reader, 1, token).ConfigureAwait(false); _session.MarkAsDocumentLoaded(id, document); return(document); }
public async System.Threading.Tasks.Task <EventSourcingTests.Aggregation.Invoice> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { var id = await reader.GetFieldValueAsync <System.Guid>(0, token); if (_identityMap.TryGetValue(id, out var existing)) { return(existing); } EventSourcingTests.Aggregation.Invoice document; document = await _serializer.FromJsonAsync <EventSourcingTests.Aggregation.Invoice>(reader, 1, token).ConfigureAwait(false); _session.MarkAsDocumentLoaded(id, document); _identityMap[id] = document; StoreTracker(_session, document); return(document); }
public DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass Resolve(System.Data.Common.DbDataReader reader) { var id = reader.GetFieldValue <System.Guid>(0); if (_identityMap.TryGetValue(id, out var existing)) { return(existing); } DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass document; document = _serializer.FromJson <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass>(reader, 1); _session.MarkAsDocumentLoaded(id, document); _identityMap[id] = document; StoreTracker(_session, document); return(document); }
public override void Postprocess(System.Data.Common.DbDataReader reader, System.Collections.Generic.IList <System.Exception> exceptions) { storeVersion(); }
public async System.Threading.Tasks.Task <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass> ResolveAsync(System.Data.Common.DbDataReader reader, System.Threading.CancellationToken token) { var id = await reader.GetFieldValueAsync <System.Guid>(0, token); if (_identityMap.TryGetValue(id, out var existing)) { return(existing); } DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass document; document = await _serializer.FromJsonAsync <DocumentDbTests.Bugs.Bug_849_not_node_not_correctly_evaluated.TestClass>(reader, 1, token).ConfigureAwait(false); _session.MarkAsDocumentLoaded(id, document); _identityMap[id] = document; StoreTracker(_session, document); return(document); }
public DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested Resolve(System.Data.Common.DbDataReader reader) { DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested document; document = _serializer.FromJson <DocumentDbTests.Reading.Linq.IsNullNotNullArbitraryDepthTests.UserNested>(reader, 0); return(document); }
public EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity Resolve(System.Data.Common.DbDataReader reader) { var id = reader.GetFieldValue <System.Guid>(0); EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity document; document = _serializer.FromJson <EventSourcingTests.Bugs.Bug_2025_event_inheritance_in_projection.Identity>(reader, 1); _session.MarkAsDocumentLoaded(id, document); return(document); }