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