private void btn_run_all_Click(object sender, EventArgs e) { DataTable dt = bbtc.getAllData(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { decimal subtotal = Convert.ToDecimal(dt.Rows[i]["sub_total"]); decimal discount = Convert.ToDecimal(dt.Rows[i]["discount"]); string sales_type = dt.Rows[i]["sales_type"].ToString(); string bill_no = dt.Rows[i]["bill_no"].ToString(); DateTime date2 = Convert.ToDateTime(dt.Rows[i]["date2"].ToString()); if (subtotal > 0) { decimal service_charge = 0; decimal tax_amount = 0; decimal subtotal_with_services; decimal subtotalwithDiscount = subtotal - discount; TaxCalculation tax = new TaxCalculation(); if (sales_type != "TA" && service_chargeStatus == "True") { service_charge = tax.service_calculation(subtotalwithDiscount); } subtotal_with_services = (subtotalwithDiscount + service_charge); tax_amount = tax.tax_calculation(Convert.ToDecimal(subtotal_with_services)); int upadateTax = bbtc.updatetaxandservice(bill_no, date2, tax_amount, service_charge, subtotal_with_services); int upadateTaxmat = bbtc.updatetaxandserviceMet(bill_no, date2, tax_amount, subtotal_with_services); } } } }
public void DataGridViewLoad() { if (dtLoad.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dtLoad.Rows.Count; inc++) { int ww = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dtLoad.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dtLoad.Rows[inc]["quantity"].ToString(); string cost = dtLoad.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = cost; string sub_total = dtLoad.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = sub_total; string discount = dtLoad.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = discount; float discount_amount = dcr.calculateDiscount(Convert.ToDecimal(cost), Convert.ToDecimal(discount)); string amountWithDiscount = (Convert.ToSingle(cost) - discount_amount).ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total_with_dis"].Value = amountWithDiscount; decimal service_change = tc.service_calculation(Convert.ToDecimal(amountWithDiscount)); dataGridView1.Rows[inc].Cells["cal_service_charge"].Value = service_change.ToString(); decimal taxable_amount = (Convert.ToDecimal(amountWithDiscount) + Convert.ToDecimal(service_change)); dataGridView1.Rows[inc].Cells["cal_taxable_amount"].Value = taxable_amount.ToString(); decimal tax_amount = tc.tax_calculation(taxable_amount); dataGridView1.Rows[inc].Cells["cal_tax"].Value = tax_amount.ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = taxable_amount + tax_amount; dataGridView1.Rows[inc].Cells["calbill_no"].Value = dtLoad.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = Convert.ToDateTime(dtLoad.Rows[inc]["date_of_sale"].ToString()); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dtLoad.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dtLoad.Rows[inc]["date_of_sale"].ToString(); } grandtotalCalculation(); backPanel.Show(); searchPanel.Hide(); bill_no = null; } }