private void ComboSetNo_TextChanged(object sender, EventArgs e)
{
FormatBtnUpdate(ComboSetNo, TxtSettlementNo, ComboLocation, TxtTotalAmount, TxtReason);
FormatBtnDelete(ComboSetNo);
//
// Loading data into form
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
if (ComboSetNo.Text != "")
{
string StrSetNo = null;
int? IntLocID = null;
string StrLocation = null;
DateTime?VarSetDate = null;
decimal? DecimalAmount = null;
string StrDetails = null;
string StrNotes = null;
var c = dc.ProSelectSettlement(ComboSetNo.Text, ref StrSetNo, ref IntLocID, ref VarSetDate, ref DecimalAmount, ref StrDetails, ref StrNotes);
TxtSettlementNo.Text = StrSetNo;
var d = dc.ProGetLocationByID(IntLocID, ref StrLocation);
ComboLocation.Text = StrLocation;
if (VarSetDate != null)
{
DateSettlement.Value = VarSetDate.Value;
}
else
{
DateSettlement.Value = DateTime.Now;
}
TxtTotalAmount.Text = DecimalAmount.ToString();
TxtReason.Text = StrDetails;
TxtNotes.Text = StrNotes;
}
else
{
TxtSettlementNo.Text = null;
ComboLocation.Text = null;
DateSettlement.Value = DateTime.Now;
TxtTotalAmount.Text = null;
TxtReason.Text = null;
TxtNotes.Text = null;
}
}
}
catch (NullReferenceException)
{
}
catch (InvalidOperationException)
{
DateSettlement.Value = DateTime.Now;
BtnDelete.Enabled = false;
}
catch (Exception EX)
{
MessageBox.Show(EX.Message.ToString());
}
}
