private void LockDealerRecord()
{
Object loLockedBy = dEALERTableAdapter.LockedBy(DEALERcomboBox.Text),
loLockedTime = dEALERTableAdapter.LockTime(DEALERcomboBox.Text);
if (loLockedBy != null && ((String)loLockedBy).TrimEnd() != "")
{
IACDataSetTableAdapters.ULISTTableAdapter ULISTTableAdapter = new IACDataSetTableAdapters.ULISTTableAdapter();
ULISTTableAdapter.FillById(iacDataSet.ULIST, Program.gsUserID);
MessageBox.Show("*** DEALER: " + DEALERcomboBox.Text + " WAS LOCKED BY USER: "******" " +
iacDataSet.ULIST.Rows[0].Field <String>("LIST_NAME") +
"\nON: " + ((DateTime)loLockedTime).ToLongDateString() + " " +
((DateTime)loLockedTime).ToLongTimeString() + "\n" +
"YOU MUST WAIT UNTIL THEY RELEASE IT! ***", "RECORD LOCKED", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
toolStripButtonSave.Enabled = false;
ULISTTableAdapter.Dispose();
loLockedBy = null;
lbEdit = false;
iacDataSet.Clear();
StartUpConfiguration();
}
else
{
dEALERTableAdapter.LockRecord(Program.gsUserID, DEALERcomboBox.Text);
lbILockedIt = true; // Make sure other instances of form don't unlocke this record!
}
}
private void LockContingRecord()
{
Object loLockedBy = cONTINGTableAdapter.LockedBy(DEALERcomboBox.Text, (DateTime)dateTimePickerPostDate.Value, CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].Field <Int32>("CONTING_ENTRY_SEQ")),
loLockedTime = cONTINGTableAdapter.LockTime(DEALERcomboBox.Text, (DateTime)dateTimePickerPostDate.Value, CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].Field <Int32>("CONTING_ENTRY_SEQ"));
if (loLockedBy != null && ((String)loLockedBy).TrimEnd() != "")
{
IACDataSetTableAdapters.ULISTTableAdapter ULISTTableAdapter = new IACDataSetTableAdapters.ULISTTableAdapter();
ULISTTableAdapter.FillById(CONTINGiacDataSet.ULIST, Program.gsUserID);
MessageBox.Show("*** (CONTINGENT RECORD) DEALER#: " + DEALERcomboBox.Text + " POST DATE:" + dateTimePickerPostDate.Text + " SEQUENCE #: " + CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].Field <Int32>("CONTING_ENTRY_SEQ").ToString().TrimStart() + " WAS LOCKED BY USER: "******" " +
CONTINGiacDataSet.ULIST.Rows[0].Field <String>("LIST_NAME") +
"\nON: " + ((DateTime)loLockedTime).ToLongDateString() + " " +
((DateTime)loLockedTime).ToLongTimeString() + "\n" +
"YOU MUST WAIT UNTIL THEY RELEASE IT! ***", "RECORD LOCKED", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
toolStripButtonSave.Enabled = false;
ULISTTableAdapter.Dispose();
loLockedBy = null;
lbEdit = false;
CONTINGiacDataSet.Clear();
StartUpConfiguration();
}
else
{
cONTINGTableAdapter.LockRecord(Program.gsUserID, DEALERcomboBox.Text, (DateTime)dateTimePickerPostDate.Value, CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].Field <Int32>("CONTING_ENTRY_SEQ"));
lbILockedIt = true; // Make sure other instances of form don't unlock this record!
}
}
