public static void AddAllSQLTables(YellowstonePathology.Business.Mongo.TransferCollection transferCollection)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT Table_Name, Column_Name " +
"FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE " +
"WHERE OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1 " +
"AND table_name like 'tbl%'";
cmd.CommandType = CommandType.Text;
YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(Business.Mongo.TestServer.SQLTransferDatabasename);
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Mongo.Transfer transfer = new Transfer();
transfer.ObjectId = BsonObjectId.GenerateNewId().ToString();
transfer.TableName = dr.GetString(0);
transfer.PrimaryKeyName = dr.GetString(1);
transferCollection.Add(transfer);
}
}
}
}
public static void BuildClientOrderCollection(SqlDataReader dr, YellowstonePathology.Business.ClientOrder.Model.ClientOrderCollection clientOrderCollection)
{
int clientOrderIdCount = 0;
while (dr.Read())
{
if (dr["ClientOrderIdCount"] != DBNull.Value)
{
clientOrderIdCount = Convert.ToInt32(dr["ClientOrderIdCount"].ToString());
}
}
for (int i = 0; i < clientOrderIdCount; i++)
{
dr.NextResult();
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = BuildClientOrder(dr);
dr.NextResult();
BuildClientOrderDetailCollection(clientOrder.ClientOrderDetailCollection, dr);
if (clientOrder.ClientOrderId != null)
{
clientOrderCollection.Add(clientOrder);
}
}
}
public static void BuildClientOrderDetailCollection(YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailCollection clientOrderDetailCollection, SqlDataReader dr)
{
int clientOrderDetailCount = 0;
while (dr.Read())
{
clientOrderDetailCount = Convert.ToInt32(dr["ClientOrderDetailCount"].ToString());
}
if (clientOrderDetailCount > 0)
{
for (int i = 0; i < clientOrderDetailCount; i++)
{
dr.NextResult();
string orderTypeCode = null;
while (dr.Read())
{
orderTypeCode = dr["OrderTypeCode"].ToString();
}
dr.NextResult();
YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail = YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailFactory.GetClientOrderDetail(orderTypeCode, Persistence.PersistenceModeEnum.UpdateChangedProperties);
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrderDetail, dr);
propertyWriter.WriteProperties();
clientOrderDetailCollection.Add(clientOrderDetail);
}
}
}
else
{
dr.NextResult();
dr.NextResult();
}
}