public void AddTransaction(int AccountId, int AccountSortCodeId, int ProductId, bool IsActive)
{
try
{
int id;
if (TableBinary.Rows.Count == 0)
{
id = 0;
}
else
{
id = Convert.ToInt32(TableBinary.Compute("MAX([Id])", ""));
}
id = id + 1;
using (BinaryWriter writer = new BinaryWriter(File.Open(fileName, FileMode.Append)))
{
writer.Write(GetTransactionBytes(id, AccountId, AccountSortCodeId, ProductId, IsActive), 0, Size_Block);
TableBinary.Rows.Add(id, AccountId, AccountSortCodeId, ProductId, IsActive);
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
private void AddTransaction(int AccountId, int AccountSortCodeId, int ProductId, bool IsActive)
{
try
{
if (TableBinary.Rows.Count == 0)
{
Id = 0;
}
else
{
Id = Convert.ToInt32(TableBinary.Compute("MAX([Id])", ""));
}
Id = Id + 1;
Chunk = GetTransactionBytes(Id, AccountId, AccountSortCodeId, ProductId, IsActive);
using (BinaryWriter writer = new BinaryWriter(File.Open(fileName, FileMode.Append)))
{
writer.Write(Chunk, 0, Size_Chunk);
TableBinary.Rows.Add(Id, AccountId, AccountSortCodeId, ProductId, IsActive);
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}