public static object TranExecuteScalar(TranItem tran_item,
string cmdText, params SqlParameter[] parameters)
{
tran_item.cmd.CommandText = cmdText;
tran_item.cmd.Parameters.Clear();
tran_item.cmd.Parameters.AddRange(parameters);
return(tran_item.cmd.ExecuteScalar());
}
public static void TranExecuteNonQuery(TranItem tran_item,
string cmdText, params SqlParameter[] parameters)
{
tran_item.cmd.CommandText = cmdText;
tran_item.cmd.Parameters.Clear();
tran_item.cmd.Parameters.AddRange(parameters);
tran_item.cmd.ExecuteNonQuery();
}
public static TranItem TranConnection()
{
TranItem tran_item = new TranItem();
tran_item.conn = new SqlConnection(connstr);
tran_item.conn.Open();
tran_item.tran = tran_item.conn.BeginTransaction();
tran_item.cmd = tran_item.conn.CreateCommand();
tran_item.cmd.Transaction = tran_item.tran;
return(tran_item);
}
private static void CompareAndAddToList(List <TranItem> finalList, TranItem newRecord)
{
TranItem inListItem = finalList.FirstOrDefault(x => x.Receiver == newRecord.Sender && x.Sender == newRecord.Receiver);
if (inListItem != null)
{
if (newRecord.Amount >= inListItem.Amount)
{
newRecord.Amount -= inListItem.Amount;
finalList.Remove(inListItem);
}
else
{
inListItem.Amount -= newRecord.Amount;
return;
}
}
if (newRecord.Amount != 0)
{
finalList.Add(newRecord);
}
}
public static void TranEnd(TranItem tran_item)
{
tran_item.tran.Commit();
tran_item.conn.Close();
tran_item.tran.Dispose();
}
