private void btn_show_Click(object sender, EventArgs e) { if (cbo_searchTYpe.Text == "" || cbo_searchTYpe.Text == "Choose Type" || txt_searchText.Text == "") { MessageBox.Show("The Fields are Empty or invalid."); } else { DateTime dateOne = Convert.ToDateTime(dtp_from.Text); DateTime datetwo = Convert.ToDateTime(dtp_to.Text); if (cbo_searchTYpe.Text == "Product") { DataTable dt = blod.searchitembyname_delete_record(txt_searchText.Text, dateOne, datetwo); if (dt.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dt.Rows.Count; inc++) { int ww = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dt.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dt.Rows[inc]["quantity"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = dt.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dt.Rows[inc]["date_of_sale"].ToString(); dataGridView1.Rows[inc].Cells["calcardamount"].Value = dt.Rows[inc]["card_amount"].ToString(); dataGridView1.Rows[inc].Cells["calcashamt"].Value = dt.Rows[inc]["cash_amount"].ToString(); dataGridView1.Rows[inc].Cells["calpaymode"].Value = dt.Rows[inc]["payment_mode"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = dt.Rows[inc]["cashier_name"].ToString(); dataGridView1.Rows[inc].Cells["calbill_no"].Value = dt.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = dt.Rows[inc]["grand_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dt.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_id"].Value = dt.Rows[inc]["rest_sale_id"].ToString(); dataGridView1.Rows[inc].Cells["cal_table_no"].Value = dt.Rows[inc]["table_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_category_name"].Value = dt.Rows[inc]["category_name"].ToString(); dataGridView1.Rows[inc].Cells["cal_discount"].Value = dt.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = dt.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_date2"].Value = dt.Rows[inc]["date2"].ToString(); grandtotal(); } backPanel.Show(); searchPanel.Hide(); }//dt rows if end else { MessageBox.Show("No Record Found"); } } else if (cbo_searchTYpe.Text == "Category") { DataTable dt = blod.searchbycategory2_delete_record(txt_searchText.Text, dateOne, datetwo); if (dt.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dt.Rows.Count; inc++) { int y = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dt.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dt.Rows[inc]["quantity"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = dt.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dt.Rows[inc]["date_of_sale"].ToString(); dataGridView1.Rows[inc].Cells["calcardamount"].Value = dt.Rows[inc]["card_amount"].ToString(); dataGridView1.Rows[inc].Cells["calcashamt"].Value = dt.Rows[inc]["cash_amount"].ToString(); dataGridView1.Rows[inc].Cells["calpaymode"].Value = dt.Rows[inc]["payment_mode"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = dt.Rows[inc]["cashier_name"].ToString(); dataGridView1.Rows[inc].Cells["calbill_no"].Value = dt.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = dt.Rows[inc]["grand_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dt.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_id"].Value = dt.Rows[inc]["rest_sale_id"].ToString(); dataGridView1.Rows[inc].Cells["cal_table_no"].Value = dt.Rows[inc]["table_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_category_name"].Value = dt.Rows[inc]["category_name"].ToString(); dataGridView1.Rows[inc].Cells["cal_discount"].Value = dt.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = dt.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_date2"].Value = dt.Rows[inc]["date2"].ToString(); grandtotal(); } backPanel.Show(); searchPanel.Hide(); }//dt rows if end else { MessageBox.Show("No Record Found"); } } else if (cbo_searchTYpe.Text == "Bill No") { DataTable dt = blod.searchbybill2_delete_record(txt_searchText.Text); if (dt.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dt.Rows.Count; inc++) { int ac = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dt.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dt.Rows[inc]["quantity"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = dt.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dt.Rows[inc]["date_of_sale"].ToString(); dataGridView1.Rows[inc].Cells["calcardamount"].Value = dt.Rows[inc]["card_amount"].ToString(); dataGridView1.Rows[inc].Cells["calcashamt"].Value = dt.Rows[inc]["cash_amount"].ToString(); dataGridView1.Rows[inc].Cells["calpaymode"].Value = dt.Rows[inc]["payment_mode"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = dt.Rows[inc]["cashier_name"].ToString(); dataGridView1.Rows[inc].Cells["calbill_no"].Value = dt.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = dt.Rows[inc]["grand_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dt.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_id"].Value = dt.Rows[inc]["rest_sale_id"].ToString(); dataGridView1.Rows[inc].Cells["cal_table_no"].Value = dt.Rows[inc]["table_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_category_name"].Value = dt.Rows[inc]["category_name"].ToString(); dataGridView1.Rows[inc].Cells["cal_discount"].Value = dt.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = dt.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_date2"].Value = dt.Rows[inc]["date2"].ToString(); grandtotal(); } backPanel.Show(); searchPanel.Hide(); } else { MessageBox.Show("No Record Found"); } } else if (cbo_searchTYpe.Text == "ALL") { DataTable dtm = blod.searchALL_delete_record(dateOne, datetwo); if (dtm.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dtm.Rows.Count; inc++) { int ac = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dtm.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dtm.Rows[inc]["quantity"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = dtm.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dtm.Rows[inc]["date_of_sale"].ToString(); dataGridView1.Rows[inc].Cells["calcardamount"].Value = dtm.Rows[inc]["card_amount"].ToString(); dataGridView1.Rows[inc].Cells["calcashamt"].Value = dtm.Rows[inc]["cash_amount"].ToString(); dataGridView1.Rows[inc].Cells["calpaymode"].Value = dtm.Rows[inc]["payment_mode"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = dtm.Rows[inc]["cashier_name"].ToString(); dataGridView1.Rows[inc].Cells["calbill_no"].Value = dtm.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = dtm.Rows[inc]["grand_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dtm.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_id"].Value = dtm.Rows[inc]["rest_sale_id"].ToString(); dataGridView1.Rows[inc].Cells["cal_table_no"].Value = dtm.Rows[inc]["table_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_category_name"].Value = dtm.Rows[inc]["category_name"].ToString(); dataGridView1.Rows[inc].Cells["cal_discount"].Value = dtm.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = dtm.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_date2"].Value = dtm.Rows[inc]["date2"].ToString(); grandtotal(); } backPanel.Show(); searchPanel.Hide(); } //dtm rows if end else { MessageBox.Show("No Record Found"); } } else if (cbo_searchTYpe.Text == "Payment Mode") { DataTable dt = blod.searchpayment_mode_delete_record(txt_searchText.Text, dateOne, datetwo); if (dt.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dt.Rows.Count; inc++) { int ac = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dt.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dt.Rows[inc]["quantity"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = dt.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dt.Rows[inc]["date_of_sale"].ToString(); dataGridView1.Rows[inc].Cells["calcardamount"].Value = dt.Rows[inc]["card_amount"].ToString(); dataGridView1.Rows[inc].Cells["calcashamt"].Value = dt.Rows[inc]["cash_amount"].ToString(); dataGridView1.Rows[inc].Cells["calpaymode"].Value = dt.Rows[inc]["payment_mode"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = dt.Rows[inc]["cashier_name"].ToString(); dataGridView1.Rows[inc].Cells["calbill_no"].Value = dt.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = dt.Rows[inc]["grand_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dt.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_id"].Value = dt.Rows[inc]["rest_sale_id"].ToString(); dataGridView1.Rows[inc].Cells["cal_table_no"].Value = dt.Rows[inc]["table_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_category_name"].Value = dt.Rows[inc]["category_name"].ToString(); dataGridView1.Rows[inc].Cells["cal_discount"].Value = dt.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = dt.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_date2"].Value = dt.Rows[inc]["date2"].ToString(); grandtotal(); } backPanel.Show(); searchPanel.Hide(); } else { MessageBox.Show("No Record Found"); } } else if (cbo_searchTYpe.Text == "Sales Type") { DataTable dt = blod.searchsale_type_delete(txt_searchText.Text, dateOne, datetwo); if (dt.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dt.Rows.Count; inc++) { int ac = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dt.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dt.Rows[inc]["quantity"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = dt.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dt.Rows[inc]["date_of_sale"].ToString(); dataGridView1.Rows[inc].Cells["calcardamount"].Value = dt.Rows[inc]["card_amount"].ToString(); dataGridView1.Rows[inc].Cells["calcashamt"].Value = dt.Rows[inc]["cash_amount"].ToString(); dataGridView1.Rows[inc].Cells["calpaymode"].Value = dt.Rows[inc]["payment_mode"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = dt.Rows[inc]["cashier_name"].ToString(); dataGridView1.Rows[inc].Cells["calbill_no"].Value = dt.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = dt.Rows[inc]["grand_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dt.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_id"].Value = dt.Rows[inc]["rest_sale_id"].ToString(); dataGridView1.Rows[inc].Cells["cal_table_no"].Value = dt.Rows[inc]["table_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_category_name"].Value = dt.Rows[inc]["category_name"].ToString(); dataGridView1.Rows[inc].Cells["cal_discount"].Value = dt.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = dt.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_date2"].Value = dt.Rows[inc]["date2"].ToString(); grandtotal(); } backPanel.Show(); searchPanel.Hide(); } else { MessageBox.Show("No Record Found"); } } else if (cbo_searchTYpe.Text == "User") { DataTable dt = blod.searchsale_by_user_delete(txt_searchText.Text, dateOne, datetwo); if (dt.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int inc = 0; inc < dt.Rows.Count; inc++) { int ac = dataGridView1.Rows.Add(); dataGridView1.Rows[inc].Cells["calitem"].Value = dt.Rows[inc]["item_name"].ToString(); dataGridView1.Rows[inc].Cells["calquantity"].Value = dt.Rows[inc]["quantity"].ToString(); dataGridView1.Rows[inc].Cells["caltotal"].Value = dt.Rows[inc]["total"].ToString(); dataGridView1.Rows[inc].Cells["caldate"].Value = dt.Rows[inc]["date_of_sale"].ToString(); dataGridView1.Rows[inc].Cells["calcardamount"].Value = dt.Rows[inc]["card_amount"].ToString(); dataGridView1.Rows[inc].Cells["calcashamt"].Value = dt.Rows[inc]["cash_amount"].ToString(); dataGridView1.Rows[inc].Cells["calpaymode"].Value = dt.Rows[inc]["payment_mode"].ToString(); dataGridView1.Rows[inc].Cells["calcashier_name"].Value = dt.Rows[inc]["cashier_name"].ToString(); dataGridView1.Rows[inc].Cells["calbill_no"].Value = dt.Rows[inc]["bill_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_grand_total"].Value = dt.Rows[inc]["grand_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_type"].Value = dt.Rows[inc]["sales_type"].ToString(); dataGridView1.Rows[inc].Cells["cal_sales_id"].Value = dt.Rows[inc]["rest_sale_id"].ToString(); dataGridView1.Rows[inc].Cells["cal_table_no"].Value = dt.Rows[inc]["table_no"].ToString(); dataGridView1.Rows[inc].Cells["cal_category_name"].Value = dt.Rows[inc]["category_name"].ToString(); dataGridView1.Rows[inc].Cells["cal_discount"].Value = dt.Rows[inc]["discount"].ToString(); dataGridView1.Rows[inc].Cells["cal_sub_total"].Value = dt.Rows[inc]["sub_total"].ToString(); dataGridView1.Rows[inc].Cells["cal_date2"].Value = dt.Rows[inc]["date2"].ToString(); grandtotal(); } backPanel.Show(); searchPanel.Hide(); } else { MessageBox.Show("No Record Found"); } } } }