private void radButton7_Click(object sender, EventArgs e)
{
GlobleAccess.PaymentReportType = "I";
com_invoice_no.Text = "";
GlobleAccess.cusID = com_customer_id.Text;
this.Enabled = false;
Payments_Full_Report pr = new Payments_Full_Report();
pr.MdiParent = DHNAULA.ActiveForm;
pr.Show();
}
private void btn_repot_Click(object sender, EventArgs e)
{
GlobleAccess.PaymentReportType = "C";
com_invoice_no.Text = "";
GlobleAccess.cusID = com_customer_id.Text;
//string q = "SELECT I.invoiceno,I.invoicedate,C.customername,IL.itemno,IL.itemname,IL.soldqty,IL.retailprice,IL.soldqty*IL.retailprice,I.invoicetotal,IL.discount,I.invoicenote,I.vehicleno FROM invoice I,invoicelines IL, customer C WHERE C.customerno = I.customer AND I.invoiceno = IL.invoiceno AND C.customerno='" + com_customer_id.Text + "'";
// DataSet ds_invoice = middle_access.db_access.SelectData(q);
// if (ds_invoice != null)
// {
//}
// int i = 0;
/* for (int i = 0; i < ds_invoice.Tables[0].Rows.Count; i++)
{
DataRow dr_invoice = ds_invoice.Tables[0].Rows[i];
string invoice_no = dr_invoice.ItemArray.GetValue(0).ToString();
string invoice_date = dr_invoice.ItemArray.GetValue(1).ToString();
string customer_name = dr_invoice.ItemArray.GetValue(2).ToString();
string item_no = dr_invoice.ItemArray.GetValue(3).ToString();
string item_name = dr_invoice.ItemArray.GetValue(4).ToString();
string qty = dr_invoice.ItemArray.GetValue(5).ToString();
string unit_price = dr_invoice.ItemArray.GetValue(6).ToString();
string price = dr_invoice.ItemArray.GetValue(7).ToString();
string total_price = dr_invoice.ItemArray.GetValue(8).ToString();
string discount = dr_invoice.ItemArray.GetValue(9).ToString();
string refNo = dr_invoice.ItemArray.GetValue(10).ToString();
string vehicleNo = dr_invoice.ItemArray.GetValue(11).ToString();
if (discount == "")
{
discount = " ";
price = ((Convert.ToDouble(qty) * Convert.ToDouble(unit_price)) / 100 * (100 - 0)).ToString();
}
else if (discount != " ")
{
price = ((Convert.ToDouble(qty) * Convert.ToDouble(unit_price)) / 100 * (100 - Convert.ToDouble(discount))).ToString();
discount = discount + " %";
}
string q3 = "INSERT INTO temp_invoice_print(invoice_no,invoice_date,customer_name,item_no,item_name,qty,unit_price,price,total_price,discount,refNo,vehicleno)VALUES('" + invoice_no + "','" + invoice_date + "','" + customer_name + "','" + item_no + "','" + item_name + "'," + qty + ",'" + unit_price + ".00','" + price + ".00','" + total_price + ".00','" + discount + "','" + refNo + "','" + vehicleNo + "')";
bool status = middle_access.db_access.InsertData(q3);
// i++;
if (status == true)
{
}
else
{
MessageBox.Show("Error2!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}*/
this.Enabled = false;
// Invoice_report ir = new Invoice_report();
// ir.MdiParent = DHNAULA.ActiveForm;
//ir.Show();
Payments_Full_Report pr = new Payments_Full_Report();
pr.MdiParent = DHNAULA.ActiveForm;
pr.Show();
/* else
{
MessageBox.Show("Incorrect item No!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}*/
}