public object AddRecord(string tableName, Dictionary <string, object> col_val, bool needIdentity, string connKey)
{
try
{
using (CmdOnPoolGenerator gen = new CmdOnPoolGenerator(connKey))
{
DbCommand cmd = gen.CreateCommand(new CustomizedCommand()
{
ColumnsData = col_val, FilteredColumnsData = null, CommandType = CustomizedCommandType.New, ConnectionString = connKey, DataProvider = DataProvider.SqlServer, TableName = tableName
}, needIdentity);
if (needIdentity)
{
return(gen.DatabaseInstance.ExecuteScalar(cmd));
}
else
{
gen.DatabaseInstance.ExecuteNonQuery(cmd);
return(null);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public long AddNewSingleOrder(Guid callbackID, string username, Dictionary <string, object> data, Dictionary <string, object> details)
{
try
{
using (CmdOnPoolGenerator gen = new CmdOnPoolGenerator(ConStrongKeys.FixDbCon))
{
DbCommand cmdOrder = gen.CreateCommand(new CustomizedCommand()
{
ColumnsData = data, FilteredColumnsData = null, CommandType = CustomizedCommandType.New, ConnectionString = SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon), DataProvider = DataProvider.SqlServer, TableName = "Orders"
}, true);
using (System.Transactions.TransactionScope tran = new System.Transactions.TransactionScope())
{
long orderID = Convert.ToInt64(gen.DatabaseInstance.ExecuteScalar(cmdOrder));
details.Add(SingleOrdDetailsProps.OrderID, orderID);
DbCommand cmdOrdersDetail = gen.CreateCommand(new CustomizedCommand()
{
ColumnsData = details, FilteredColumnsData = null, CommandType = CustomizedCommandType.New, ConnectionString = SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon), DataProvider = DataProvider.SqlServer, TableName = "Orders_Details"
}, false);
gen.DatabaseInstance.ExecuteNonQuery(cmdOrdersDetail);
DbCommand cmdSub = gen.DatabaseInstance.GetSqlStringCommand(string.Format("INSERT INTO [SessionOrders] (SessionID,Username, ReqOrdID, OrdID, SubscriptionDateTime) Values (@SubscriberID, @username,@RequesterOrderID, @OrderID, @SubscriptionDateTime)"));
DbParameter para1 = cmdSub.CreateParameter();
para1.ParameterName = "@SubscriberID";
para1.Value = callbackID;
cmdSub.Parameters.Add(para1);
DbParameter para2 = cmdSub.CreateParameter();
para2.ParameterName = "@RequesterOrderID";
para2.Value = (Guid)data[SingleOrderProperties.RequesterOrderID];
cmdSub.Parameters.Add(para2);
DbParameter para3 = cmdSub.CreateParameter();
para3.ParameterName = "@OrderID";
para3.Value = orderID;
cmdSub.Parameters.Add(para3);
DbParameter para4 = cmdSub.CreateParameter();
para4.ParameterName = "@SubscriptionDateTime";
para4.Value = data[SingleOrderProperties.PlacementDateTime];
cmdSub.Parameters.Add(para4);
DbParameter para5 = cmdSub.CreateParameter();
para5.ParameterName = "@Username";
para5.Value = username;
cmdSub.Parameters.Add(para5);
gen.DatabaseInstance.ExecuteNonQuery(cmdSub);
tran.Complete();
return(orderID);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdateRecord(string tableName, Dictionary <string, object> col_val, Dictionary <string, object> keys, string conString)
{
try
{
using (CmdOnPoolGenerator gen = new CmdOnPoolGenerator(conString))
{
DbCommand cmd = gen.CreateCommand(new CustomizedCommand()
{
ColumnsData = col_val, FilteredColumnsData = keys, CommandType = CustomizedCommandType.Update, ConnectionString = SystemConfigurations.GetConnectionString(conString), DataProvider = DataProvider.SqlServer, TableName = tableName
}, false);
return(gen.DatabaseInstance.ExecuteNonQuery(cmd));
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateOrderDetails(Dictionary <string, object> updates, Dictionary <string, object> keys, Dictionary <string, object> ordersDetails_columns_values)
{
using (CmdOnPoolGenerator gen = new CmdOnPoolGenerator(ConStrongKeys.FixDbCon))
{
DbCommand cmdOrders = gen.CreateCommand(new CustomizedCommand()
{
ColumnsData = updates, FilteredColumnsData = keys, CommandType = CustomizedCommandType.Update, ConnectionString = SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon), DataProvider = DataProvider.SqlServer, TableName = "Orders"
}, true);
DbCommand cmdOrdersDetails = gen.CreateCommand(new CustomizedCommand()
{
ColumnsData = ordersDetails_columns_values, FilteredColumnsData = null, CommandType = CustomizedCommandType.New, ConnectionString = SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon), DataProvider = DataProvider.SqlServer, TableName = "Orders_Details"
}, false);
using (System.Transactions.TransactionScope tran = new System.Transactions.TransactionScope())
{
gen.DatabaseInstance.ExecuteNonQuery(cmdOrders);
gen.DatabaseInstance.ExecuteNonQuery(cmdOrdersDetails);
tran.Complete();
}
}
}