private void InvoiceForm_Load(object sender, EventArgs e)
{
this.tbReceiver.Text = "";
this.dtpInvoice.Value = System.DateTime.Now;
this.dtpInvoiceDue.Value = After10Days;
this.Text = "Invoice ";
invoiceDetails();
if (invoiceNumber != null && invoiceNumber.Length > 0)
{
String fields = "service, quantity, unit, a_price, total, vat";
adapter = new OleDbDataAdapter("Select " + fields + ", hasTax, invoice_date, due_date, receiver, summary, company_info, address, bank_details from InvoiceLog where invoice_number = @invoice_number", conn);
adapter.SelectCommand.Parameters.Add("@invoice_number", OleDbType.VarWChar).Value = invoiceNumber;
adapter.Fill(dataSet, "Invoice_View");
DataTable invoiceLog = dataSet.Tables["Invoice_View"];
if (invoiceLog.Rows.Count > 0)
{
Object[] itemArray = invoiceLog.Rows[0].ItemArray;
DataColumnCollection columns1 = invoiceLog.Columns;
cbTax.Checked = Boolean.Parse(itemArray[columns1.IndexOf("hasTax")].ToString());
tbReceiver.Text = itemArray[columns1.IndexOf("receiver")].ToString();
tbSummary.Text = itemArray[columns1.IndexOf("summary")].ToString();
tbCompanyInfo.Text = itemArray[columns1.IndexOf("company_info")].ToString();
tbAddress.Text = itemArray[columns1.IndexOf("address")].ToString();
tbBankDetails.Text = itemArray[columns1.IndexOf("bank_details")].ToString();
try
{
dtpInvoice.Value = DateTime.Parse(itemArray[columns1.IndexOf("invoice_date")].ToString());
}
catch { }
try
{
dtpInvoiceDue.Value = DateTime.Parse(itemArray[columns1.IndexOf("due_date")].ToString());
}
catch { }
MainWindow.DataGridView_Serialize(dataGridView, invoiceLog, fields);
}
else
{
loadDefault();
invoiceNumberChanged = true;
}
}
else if (ccsNumber != null)
{
loadDefault();
}
conn.Close();
MainWindow.DataGridView_LockColumn(dataGridView, "vat");
MainWindow.DataGridView_LockColumn(dataGridView, "total");
cbTax_CheckedChanged(cbTax, new EventArgs());
autoSuggestControl = new AutoSuggestControl(conn, "InvoiceData", new TextBox[] { tbReceiver, tbAddress, tbBankDetails, tbCompanyInfo });
kryptonPanel1.Controls.Add(autoSuggestControl);
autoSuggestControl.BringToFront();
fileAttacher.displayAttached(item[IndexOf("attached")].ToString().Split(','));
}
private void CMRForm_Load(object sender, EventArgs e)
{
if (!isNew)
{
adapter = new OleDbDataAdapter("select * from CMRHistory where reference_number like @referenceNumber", conn);
adapter.SelectCommand.Parameters.Add("@referenceNumber", OleDbType.VarWChar).Value = tbReference.Text;
adapter.Fill(dataSet, "CMRHistory");
conn.Close();
tbConsignor.Text = Row_ValueByColumnName(CMRHistory_string.consignor);
tbConsignee.Text = Row_ValueByColumnName(CMRHistory_string.consignee);
dtpDate.Value = DateTime.Parse(Row_ValueByColumnName(CMRHistory_date.date));
tbTradeAccessRef.Text = Row_ValueByColumnName(CMRHistory_string.trade_access);
tbCarrier.Text = Row_ValueByColumnName(CMRHistory_string.carrier);
tbNotifyDeliveryAddr.Text = Row_ValueByColumnName(CMRHistory_string.notify_address);
tbTrailerNum.Text = Row_ValueByColumnName(CMRHistory_string.trailer_number);
tbPlaceOfLoading.Text = Row_ValueByColumnName(CMRHistory_string.place_loading);
tbPlaceOfDischarge.Text = Row_ValueByColumnName(CMRHistory_string.place_discharge);
tbBorderCrossing.Text = Row_ValueByColumnName(CMRHistory_string.border_crossing);
tbTerms.Text = Row_ValueByColumnName(CMRHistory_string.terms_delivery);
tbFinalDestination.Text = Row_ValueByColumnName(CMRHistory_string.final_destination);
tbSpecialInstruction.Text = Row_ValueByColumnName(CMRHistory_string.special_instruction);
dtpDate2.Value = DateTime.Parse(Row_ValueByColumnName(CMRHistory_date.date_signed));
tbIssuedAt.Text = Row_ValueByColumnName(CMRHistory_string.issued_at);
tbSenderSignature.Text = Row_ValueByColumnName(CMRHistory_string.sender_signature);
tbCarrierInstruction.Text = Row_ValueByColumnName(CMRHistory_string.carrier_instruction);
MainWindow.DataGridView_Serialize(dataGridView, Table, "packages_kind,gross_weight");
}
this.autoSuggestControl = new AutoSuggestControl(conn, "CMRData", new TextBox[] { tbConsignor,
tbConsignee, tbCarrier, tbNotifyDeliveryAddr, tbTrailerNum,
tbPlaceOfLoading, tbPlaceOfDischarge, tbBorderCrossing, tbTerms,
tbFinalDestination, tbIssuedAt, tbSenderSignature });
this.kryptonPanel.Controls.Add(autoSuggestControl);
autoSuggestControl.BringToFront();
}
