private void button4_Click(object sender, RoutedEventArgs e)
{
// back
int DocNum;
if (int.TryParse(textBox1.Text, out DocNum))
{
DocNum = DocNum - 1;
if (DocNum > 0)
{
idx = DocNum;
TransactionDataHandler handler = new TransactionDataHandler();
handler.conn = conn;
if (handler.LoadTransaction(DocNum))
{
DOC_NUM = handler._DOC_NUM;
textBox1.Text = Convert.ToString(handler._DOC_NUM);
string driver = dct_drv_licen.SingleOrDefault(r => r.Value == handler._DRV_COD).Key;
textBox3.Text = driver;
comboBox1.Text = dct_drivers[driver];
string company = dct_companies.SingleOrDefault(r => r.Value == handler._CMP_COD).Key;
comboBox2.Text = company;
textBox4.Text = handler._Destination;
comboBox3.Text = handler._Serv_Name;
comboBox4.Text = handler._Doc_Type_Name;
datePicker1.SelectedDate = handler._Doc_Date;
textBox5.Text = string.Format("{0:0.00}", handler._Trans_Value);
textBox6.Text = string.Format("{0:0.00}", handler._Trans_Reduct);
textBox7.Text = string.Format("{0:0.00}", handler._Trans_Final);
textBox8.Text = handler._Voucher_Num;
textBox9.Text = Convert.ToString(handler._No_Pax);
textBox10.Text = handler._Comments;
DeleteTransaction.Opacity = 1;
DeleteTransaction.IsEnabled = true;
button2.IsEnabled = true;
CopyTransaction.Opacity = 1;
CopyTransaction.IsEnabled = true;
PrintLastTransaction.Opacity = 1;
PrintLastTransaction.IsEnabled = true;
this.Title = "Edit Transaction";
label16.Visibility = Visibility.Hidden;
if (!handler.isValid)
{
label16.Visibility = Visibility.Visible;
DeleteTransaction.Opacity = 0.4;
DeleteTransaction.IsEnabled = false;
button2.IsEnabled = false;
CopyTransaction.Opacity = 1;
CopyTransaction.IsEnabled = true;
button1.IsEnabled = false;
PrintLastTransaction.IsEnabled = false;
PrintLastTransaction.Opacity = 0.4;
SaveTransaction.IsEnabled = false;
SaveTransaction.Opacity = 0.4;
CancelTransaction.IsEnabled = false;
CancelTransaction.Opacity = 0.4;
}
if (mode.Equals(Mode.MODE_VIEWRO))
{
MakeFormRO(true);
this.Title = "View Transaction";
if (!handler.isValid)
{
button2.IsEnabled = false;
DeleteTransaction.IsEnabled = false;
DeleteTransaction.Opacity = 0.4;
}
}
}
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
try
{
label16.Visibility = Visibility.Hidden;
DOC_NUM = null;
SqlCeDataReader myReader = null;
SqlCeCommand command = new SqlCeCommand("select UniqueValue from UniqueNumbers Where UniqueName='Receipt'", conn);
myReader = command.ExecuteReader();
if (myReader.Read())
{
textBox1.Text = myReader["UniqueValue"].ToString();
textBox2.Text = DateTime.Today.ToShortDateString();
}
myReader.Close();
myReader.Dispose();
command = new SqlCeCommand("select DRV_COD, DRV_LICENSE, DRV_NAME from Driver", conn);
myReader = command.ExecuteReader();
while (myReader.Read())
{
int Code = Convert.ToInt32(myReader["DRV_COD"].ToString());
string license = myReader["DRV_LICENSE"].ToString();
string name = myReader["DRV_NAME"].ToString();
if (!dct_drivers.ContainsKey(license))
{
dct_drivers.Add(license, name);
}
if (!drivers.Contains(name))
{
drivers.Add(name);
}
if (!dct_drv_licen.ContainsKey(license))
{
dct_drv_licen.Add(license, Code);
}
}
myReader.Close();
myReader.Dispose();
command = new SqlCeCommand("select CMP_COD, CMP_NAME from Company", conn);
myReader = command.ExecuteReader();
while (myReader.Read())
{
int Code = Convert.ToInt32(myReader["CMP_COD"].ToString());
string name = myReader["CMP_NAME"].ToString();
if (!companies.Contains(name))
{
companies.Add(name);
}
if (!dct_companies.ContainsKey(name))
{
dct_companies.Add(name, Code);
}
}
myReader.Close();
myReader.Dispose();
command = new SqlCeCommand("select SERV_NAME from Service_Type", conn);
myReader = command.ExecuteReader();
while (myReader.Read())
{
string name = myReader["SERV_NAME"].ToString();
if (!servicetype.Contains(name))
{
servicetype.Add(name);
}
}
myReader.Close();
myReader.Dispose();
command = new SqlCeCommand("select DOC_TYPE_NAME from Document_Type", conn);
myReader = command.ExecuteReader();
while (myReader.Read())
{
string name = myReader["DOC_TYPE_NAME"].ToString();
if (!documenttype.Contains(name))
{
documenttype.Add(name);
}
}
myReader.Close();
myReader.Dispose();
comboBox1.ItemsSource = drivers;
comboBox2.ItemsSource = companies;
comboBox3.ItemsSource = servicetype;
comboBox4.ItemsSource = documenttype;
if (Mode.MODE_CREATE.Equals(mode))
{
datePicker1.DisplayDate = DateTime.Today;
datePicker1.SelectedDate = DateTime.Today;
textBox5.Text = "0.00";
textBox6.Text = "0.00";
textBox7.Text = "0.00";
textBox9.Text = "0";
DeleteTransaction.IsEnabled = false;
DeleteTransaction.Opacity = 0.4;
CopyTransaction.IsEnabled = false;
CopyTransaction.Opacity = 0.4;
PrintLastTransaction.IsEnabled = false;
PrintLastTransaction.Opacity = 0.4;
this.Title = "Add Transaction";
label16.Visibility = Visibility.Hidden;
}
else if (Mode.MODE_VIEWRO.Equals(mode))
{
if (idx != null)
{
MakeFormRO(true);
TransactionDataHandler handler = new TransactionDataHandler();
handler.conn = conn;
if (!handler.LoadTransaction(idx.Value))
{
Config.ShowErrorMessage(string.Format("Failed to load the data associated to document number: {0}", idx.Value));
this.Close();
}
else
{
DOC_NUM = handler._DOC_NUM;
textBox1.Text = Convert.ToString(handler._DOC_NUM);
string driver = dct_drv_licen.SingleOrDefault(r => r.Value == handler._DRV_COD).Key;
textBox3.Text = driver;
comboBox1.Text = dct_drivers[driver];
string company = dct_companies.SingleOrDefault(r => r.Value == handler._CMP_COD).Key;
comboBox2.Text = company;
textBox4.Text = handler._Destination;
comboBox3.Text = handler._Serv_Name;
comboBox4.Text = handler._Doc_Type_Name;
datePicker1.SelectedDate = handler._Doc_Date;
textBox5.Text = string.Format("{0:0.00}", handler._Trans_Value);
textBox6.Text = string.Format("{0:0.00}", handler._Trans_Reduct);
textBox7.Text = string.Format("{0:0.00}", handler._Trans_Final);
textBox8.Text = handler._Voucher_Num;
textBox9.Text = Convert.ToString(handler._No_Pax);
textBox10.Text = handler._Comments;
if (!handler.isValid)
{
label16.Visibility = Visibility.Visible;
DeleteTransaction.Opacity = 0.4;
DeleteTransaction.IsEnabled = false;
button2.IsEnabled = false;
}
this.Title = "View Transaction";
}
}
else
{
datePicker1.DisplayDate = DateTime.Today;
datePicker1.SelectedDate = DateTime.Today;
textBox5.Text = "0.00";
textBox6.Text = "0.00";
textBox7.Text = "0.00";
textBox9.Text = "0";
DeleteTransaction.IsEnabled = false;
DeleteTransaction.Opacity = 0.4;
CopyTransaction.IsEnabled = false;
CopyTransaction.Opacity = 0.4;
PrintLastTransaction.IsEnabled = false;
PrintLastTransaction.Opacity = 0.4;
this.Title = "Add Transaction";
mode = Mode.MODE_CREATE;
label16.Visibility = Visibility.Hidden;
}
}
else if (Mode.MODE_UPDATE.Equals(mode))
{
if (idx != null)
{
//MakeFormRO(true);
TransactionDataHandler handler = new TransactionDataHandler();
handler.conn = conn;
if (!handler.LoadTransaction(idx.Value))
{
Config.ShowErrorMessage(string.Format("Failed to load the data associated to document number: {0}", idx.Value));
this.Close();
}
else
{
DOC_NUM = handler._DOC_NUM;
textBox1.Text = Convert.ToString(handler._DOC_NUM);
string driver = dct_drv_licen.SingleOrDefault(r => r.Value == handler._DRV_COD).Key;
textBox3.Text = driver;
comboBox1.Text = dct_drivers[driver];
string company = dct_companies.SingleOrDefault(r => r.Value == handler._CMP_COD).Key;
comboBox2.Text = company;
textBox4.Text = handler._Destination;
comboBox3.Text = handler._Serv_Name;
comboBox4.Text = handler._Doc_Type_Name;
datePicker1.SelectedDate = handler._Doc_Date;
textBox5.Text = string.Format("{0:0.00}", handler._Trans_Value);
textBox6.Text = string.Format("{0:0.00}", handler._Trans_Reduct);
textBox7.Text = string.Format("{0:0.00}", handler._Trans_Final);
textBox8.Text = handler._Voucher_Num;
textBox9.Text = Convert.ToString(handler._No_Pax);
textBox10.Text = handler._Comments;
if (!handler.isValid)
{
label16.Visibility = Visibility.Visible;
DeleteTransaction.Opacity = 0.4;
DeleteTransaction.IsEnabled = false;
button2.IsEnabled = false;
button1.IsEnabled = false;
PrintLastTransaction.IsEnabled = false;
PrintLastTransaction.Opacity = 0.4;
CopyTransaction.IsEnabled = true;
CopyTransaction.Opacity = 0.4;
SaveTransaction.IsEnabled = false;
SaveTransaction.Opacity = 0.4;
CancelTransaction.IsEnabled = false;
CancelTransaction.Opacity = 0.4;
}
this.Title = "Edit Transaction";
}
}
}
else if (Mode.MODE_VOID.Equals(mode))
{
if (idx != null)
{
MakeFormRO(true);
TransactionDataHandler handler = new TransactionDataHandler();
handler.conn = conn;
if (!handler.LoadTransaction(idx.Value))
{
Config.ShowErrorMessage(string.Format("Failed to load the data associated to document number: {0}", idx.Value));
this.Close();
}
else
{
DOC_NUM = handler._DOC_NUM;
textBox1.Text = Convert.ToString(handler._DOC_NUM);
string driver = dct_drv_licen.SingleOrDefault(r => r.Value == handler._DRV_COD).Key;
textBox3.Text = driver;
comboBox1.Text = dct_drivers[driver];
string company = dct_companies.SingleOrDefault(r => r.Value == handler._CMP_COD).Key;
comboBox2.Text = company;
textBox4.Text = handler._Destination;
comboBox3.Text = handler._Serv_Name;
comboBox4.Text = handler._Doc_Type_Name;
datePicker1.SelectedDate = handler._Doc_Date;
textBox5.Text = string.Format("{0:0.00}", handler._Trans_Value);
textBox6.Text = string.Format("{0:0.00}", handler._Trans_Reduct);
textBox7.Text = string.Format("{0:0.00}", handler._Trans_Final);
textBox8.Text = handler._Voucher_Num;
textBox9.Text = Convert.ToString(handler._No_Pax);
textBox10.Text = handler._Comments;
if (!handler.isValid)
{
label16.Visibility = Visibility.Visible;
DeleteTransaction.Opacity = 0.4;
DeleteTransaction.IsEnabled = false;
button2.IsEnabled = false;
}
this.Title = "Void Transaction";
}
VoidTrans();
this.Close();
}
else
{
this.Close();
}
}
else if (Mode.MODE_COPYC.Equals(mode))
{
if (idx != null)
{
TransactionDataHandler handler = new TransactionDataHandler();
handler.conn = conn;
if (!handler.LoadTransaction(idx.Value))
{
Config.ShowErrorMessage(string.Format("Failed to load the data associated to document number: {0}", idx.Value));
this.Close();
}
else
{
int?dn = handler.GetNewDocNum();
if (dn != null)
{
DOC_NUM = handler._DOC_NUM;
textBox1.Text = Convert.ToString(dn.Value);
string driver = dct_drv_licen.SingleOrDefault(r => r.Value == handler._DRV_COD).Key;
textBox3.Text = driver;
comboBox1.Text = dct_drivers[driver];
string company = dct_companies.SingleOrDefault(r => r.Value == handler._CMP_COD).Key;
comboBox2.Text = company;
textBox4.Text = handler._Destination;
comboBox3.Text = handler._Serv_Name;
comboBox4.Text = handler._Doc_Type_Name;
datePicker1.SelectedDate = DateTime.Today;
datePicker1.DisplayDate = DateTime.Today;
textBox5.Text = string.Format("{0:0.00}", handler._Trans_Value);
textBox6.Text = string.Format("{0:0.00}", handler._Trans_Reduct);
textBox7.Text = string.Format("{0:0.00}", handler._Trans_Final);
//textBox8.Text = handler._Voucher_Num;
textBox9.Text = Convert.ToString(handler._No_Pax);
textBox10.Text = handler._Comments;
this.Title = "Copy Transaction";
CopyTransaction.IsEnabled = false;
CopyTransaction.Opacity = 0.4;
DeleteTransaction.IsEnabled = false;
DeleteTransaction.Opacity = 0.4;
}
else
{
Config.ShowErrorMessage(string.Format("Failed to load the data associated to document number: {0}", idx.Value));
this.Close();
}
}
}
else
{
datePicker1.DisplayDate = DateTime.Today;
datePicker1.SelectedDate = DateTime.Today;
textBox5.Text = "0.00";
textBox6.Text = "0.00";
textBox7.Text = "0.00";
textBox9.Text = "0";
DeleteTransaction.IsEnabled = false;
DeleteTransaction.Opacity = 0.4;
CopyTransaction.IsEnabled = false;
CopyTransaction.Opacity = 0.4;
PrintLastTransaction.IsEnabled = false;
PrintLastTransaction.Opacity = 0.4;
this.Title = "Add Transaction";
mode = Mode.MODE_CREATE;
}
}
}
catch (System.Exception ex)
{
log.Error(ex);
Config.FatalError();
}
}