public void bill_printing_for_58() { blp.bill_no = bill_no_print; blp.cashier = dataGridView1.CurrentRow.Cells["calcashier_name"].Value.ToString(); blp.cash_amount = dataGridView1.CurrentRow.Cells["calcashamt"].Value.ToString(); blp.discount = dataGridView1.CurrentRow.Cells["cal_discount"].Value.ToString(); blp.grand_total = dataGridView1.CurrentRow.Cells["cal_grand_total"].Value.ToString(); blp.sub_total = dataGridView1.CurrentRow.Cells["cal_sub_total"].Value.ToString(); blp.table_no = dataGridView1.CurrentRow.Cells["cal_table_no"].Value.ToString(); DateTime date_of_billing = Convert.ToDateTime(dataGridView1.CurrentRow.Cells["caldate"].Value); blp.print_again = true; DataTable dt = blod.searchbybill2(bill_no); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { blp.datagridview_item_name.Add(dt.Rows[i]["item_name"].ToString()); blp.datagridview_item_price.Add(dt.Rows[i]["cost"].ToString()); blp.datagridview_total.Add(dt.Rows[i]["total"].ToString()); blp.datagridview_quantity.Add(dt.Rows[i]["quantity"].ToString()); } blp.tax_amount = dt.Rows[0]["tax_amount"].ToString(); blp.service_charge = dt.Rows[0]["service_charge"].ToString(); } blp.printtobill(); save_after_print = blp.save_after_print; }
public void bill_printing_for_hotel() { string bill_no = dataGridView1.CurrentRow.Cells["calbill_no"].Value.ToString(); bph.bill_no = bill_no; bph.cashier = dataGridView1.CurrentRow.Cells["calcashier_name"].Value.ToString(); bph.cash_amount = dataGridView1.CurrentRow.Cells["calcashamt"].Value.ToString(); bph.discount = dataGridView1.CurrentRow.Cells["cal_discount"].Value.ToString(); bph.grand_total = dataGridView1.CurrentRow.Cells["cal_grand_total"].Value.ToString(); bph.sub_total = dataGridView1.CurrentRow.Cells["cal_sub_total"].Value.ToString(); bph.table_no = dataGridView1.CurrentRow.Cells["cal_table_no"].Value.ToString(); bph.print_again = true; bph.duplicate_bill_print = true; bph.mobile_no = dataGridView1.CurrentRow.Cells["cal_customer_pan"].Value.ToString(); bph.customer_name = dataGridView1.CurrentRow.Cells["cal_customer_name"].Value.ToString(); DateTime date_of_billing = Convert.ToDateTime(dataGridView1.CurrentRow.Cells["cal_date2"].Value); DataTable dt_bil = blbt.get_all_tax_by_bill_no(bill_no, date_of_billing); if (dt_bil.Rows.Count > 0) { bph.tax_amount = dt_bil.Rows[0]["tax_amount"].ToString(); bph.service_charge = dt_bil.Rows[0]["service_charge"].ToString(); } DataTable dt = blod.searchbybill2(bill_no); for (int i = 0; i < dt.Rows.Count; i++) { bph.datagridview_item_name.Add(dt.Rows[i]["item_name"].ToString()); bph.datagridview_item_price.Add(dt.Rows[i]["cost"].ToString()); bph.datagridview_total.Add(dt.Rows[i]["total"].ToString()); bph.datagridview_quantity.Add(dt.Rows[i]["quantity"].ToString()); } bph.print(); save_after_print = blp_80.save_after_print; }
// bool save_after_print; public void bill_printing_for_80() { string bill_no = dataGridView1.CurrentRow.Cells["col_bill_no"].Value.ToString(); blp_80.bill_no = bill_no; // blp_80.c = dataGridView1.CurrentRow.Cells["col_credit_amount"].Value.ToString(); blp_80.customer_name = dataGridView1.CurrentRow.Cells["col_customername"].Value.ToString(); //blp_80.credit_by = dataGridView1.CurrentRow.Cells["col_credit_by"].Value.ToString(); //blp_80.credit_date = dataGridView1.CurrentRow.Cells["col_credit_date"].Value.ToString(); // bph.credit_by = dataGridView1.CurrentRow.Cells["col_customername"].Value.ToString(); DateTime date_of_billing = Convert.ToDateTime(dataGridView1.CurrentRow.Cells["col_credit_date"].Value); DataTable dt = blod.searchbybill2(bill_no); blp_80.table_no = dt.Rows[0]["table_no"].ToString(); blp_80.discount = dt.Rows[0]["discount"].ToString(); blp_80.grand_total = dt.Rows[0]["grand_total"].ToString(); blp_80.sub_total = dt.Rows[0]["sub_total"].ToString(); blp_80.tax_amount = dt.Rows[0]["tax_amount"].ToString(); blp_80.service_charge = dt.Rows[0]["service_charge"].ToString(); blp_80.billing_date = Convert.ToDateTime(dt.Rows[0]["date_of_sale"]); for (int i = 0; i < dt.Rows.Count; i++) { blp_80.datagridview_item_name.Add(dt.Rows[i]["item_name"].ToString()); blp_80.datagridview_item_price.Add(dt.Rows[i]["cost"].ToString()); blp_80.datagridview_total.Add(dt.Rows[i]["total"].ToString()); blp_80.datagridview_quantity.Add(dt.Rows[i]["quantity"].ToString()); blp_80.datagridview_complementary.Add(""); } blp_80.printtobill(); //save_after_print = blp_80.save_after_print; }
private void datatableLoad() { if (cbo_searchTYpe.Text == "" || cbo_searchTYpe.Text == "Choose Type" || txt_searchText.Text == "") { MessageBox.Show("The Fields are Empty or invalid."); } else { string theDate = dtp_from.Value.ToString("yyyy-MM-dd") + " " + cbo_from_hours.Text + ":" + cbo_minuts_from.Text + ":00"; string theDate2 = dtp_to.Value.ToString("yyyy-MM-dd") + " " + cbo_to_hours.Text + ":" + cbo_minuts.Text + ":00"; DateTime dateOne = Convert.ToDateTime(theDate); DateTime datetwo = Convert.ToDateTime(theDate2); DataTable dtfis = blrr.GetFiscalYearsales(dateOne, datetwo); if (dtfis.Rows.Count > 0) { fiscal_year = dtfis.Rows[0]["fiscal_year"].ToString(); } else { DataTable dt = blfs.get_all_data_from_fiscal("True"); if (dt.Rows.Count > 0) { fiscal_year = dt.Rows[0]["fiscal_year"].ToString(); } } if (cbo_searchTYpe.Text == "Item") { colunm_name = "item_name"; } else if (cbo_searchTYpe.Text == "Category") { colunm_name = "category_name"; } else if (cbo_searchTYpe.Text == "Bill No") { colunm_name = "bill_no"; } else if (cbo_searchTYpe.Text == "Payment Mode") { colunm_name = "payment_mode"; } else if (cbo_searchTYpe.Text == "KOT Type") { colunm_name = "kot_type"; } else if (cbo_searchTYpe.Text == "Sales Type") { colunm_name = "sales_type"; } else if (cbo_searchTYpe.Text == "User") { colunm_name = "cashier_name"; } else if (cbo_searchTYpe.Text == "Service provider") { colunm_name = "service_provider"; } int intSkip = 0; intSkip = (this.mintCurrentPage * this.mintPageSize); if (cbo_searchTYpe.Text == "ALL") { dt_report = blod.searchALLSalesWithoutpagination(dateOne, datetwo, fiscal_year); dtLoad = blod.searchALLSales(dateOne, datetwo, mintPageSize, intSkip, fiscal_year); dtSum = blrr.totalSalesSum(dateOne, datetwo, fiscal_year); DataGridViewLoad(); } else if (cbo_searchTYpe.Text == "Bill No") { dtLoad = blod.searchbybill2(txt_searchText.Text); dt_report = blod.searchbybill2(txt_searchText.Text); dtSum = blrr.totalSalesSumByBillNo(txt_searchText.Text, fiscal_year); DataGridViewLoad(); } else if (cbo_searchTYpe.Text == "Category Group") { dtLoad = blcg.getallFromView(dateOne, datetwo, txt_searchText.Text); dt_report = blcg.getallFromView(dateOne, datetwo, txt_searchText.Text); DataGridViewLoad(); } else { dtLoad = brr.searchitembyColumnNameDynamic(txt_searchText.Text, dateOne, datetwo, colunm_name, fiscal_year); dt_report = brr.searchitembyColumnNameDynamic(txt_searchText.Text, dateOne, datetwo, colunm_name, fiscal_year); // dtSum = blrr.totalSalesSumBYdifferentColumn(txt_searchText.Text, dateOne, datetwo, colunm_name); DataGridViewLoad(); } this.status = (this.mintCurrentPage + 1).ToString() + " / " + this.mintPageCount.ToString(); } }