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");
}
}
}
}
