internal static int UpdateTransaction()
{
try
{
daTransactions = new tblTransactionsTableAdapter();
dtTransactions = new DAL.DataObjects.dbDSCMainDataSet.tblTransactionsDataTable();
daTransactions.FillById(dtTransactions, TransactionsBL.ID);
drwTransactions = dtTransactions[0];
//drwTransactions.TransactionDate = TransactionsBL.TransactionDate;
drwTransactions.FormTypeCode = TransactionsBL.FormTypeCode;
drwTransactions.FormTypeDescription = TransactionsBL.FormTypeDescription;
drwTransactions.FormsBfwd = TransactionsBL.FormsBfwd;
drwTransactions.FormsReceived = TransactionsBL.FormsReceived;
drwTransactions.FormsSorted = TransactionsBL.FormsSorted;
drwTransactions.FormsScanned = TransactionsBL.FormsScanned;
drwTransactions.FormsVerified = TransactionsBL.FormsVerified;
drwTransactions.BackLog = TransactionsBL.BackLog;
drwTransactions.DataClerk = TransactionsBL.DataClerk;
drwTransactions.DateCreated = TransactionsBL.DateCreated;
drwTransactions.CreatedBy = TransactionsBL.CreatedBy;
drwTransactions.DateModified = TransactionsBL.DateModified;
drwTransactions.ModifiedBy = TransactionsBL.ModifiedBy;
n = daTransactions.Update(dtTransactions);
return(n);
}
catch (SqlException ex)
{
MessageBox.Show("Error: " + ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(n);
}
}
internal static int DeleteTransaction()
{
n = 0;
try
{
daTransactions = new tblTransactionsTableAdapter();
dtTransactions = new DAL.DataObjects.dbDSCMainDataSet.tblTransactionsDataTable();
daTransactions.FillById(dtTransactions, TransactionsBL.ID);
drwTransactions = dtTransactions[0];
drwTransactions.BeginEdit();
drwTransactions.Deleted = TransactionsBL.Deleted;
drwTransactions.DeletedBy = TransactionsBL.DeletedBy;
drwTransactions.DateDeleted = TransactionsBL.DateDeleted;
drwTransactions.EndEdit();
n = daTransactions.Update(dtTransactions);
return(n);
}
catch
{
return(n);
}
}