public void search1()
{
int parsedvalue;
if (!int.TryParse(txtsearch.Text, out parsedvalue))
{
lblmsg.Text = (" inputs are invalid. check again....");
}
else if (txtsearch.Text.Length > 0)
{
DataTable dt = blod.getalldata(Convert.ToInt32(txtsearch.Text));
if (dt.Rows.Count > 0)
{
dataGridView1.DataSource = dt;
}
else
{
lblmsg.Text = "table no not found";
}
}
int sum = 0;
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[5].Value);
}
label2.Text = sum.ToString();
}
private void btnsearch_Click(object sender, EventArgs e)
{
if (txtsearch.Text.Length > 0)
{
DataTable dt = blod.getalldata(Convert.ToInt32(txtsearch.Text));
if (dt.Rows.Count > 0)
{
dataGridView1.DataSource = dt;
}
else
{
MessageBox.Show("no table found");
}
}
int sum = 0;
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[5].Value);
}
label2.Text = sum.ToString();
}
private void dgv_deliver_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dgv_deliver.Columns["cal_recived"].Index && e.RowIndex >= 0)
{
Home_delivery_check check = new Home_delivery_check();
check.txt_name.Text = dgv_deliver.CurrentRow.Cells["calcusname"].Value.ToString();
check.txt_amount.Text = dgv_deliver.CurrentRow.Cells["caltotal"].Value.ToString();
check.txt_deliverby.Text = dgv_deliver.CurrentRow.Cells["caldeliveryman"].Value.ToString();
check.lblkotid.Text = dgv_deliver.CurrentRow.Cells["calkotid"].Value.ToString();
check.homeId.Text = dgv_deliver.CurrentRow.Cells["calid"].Value.ToString();
check.lbl_payment_type.Text = dgv_deliver.CurrentRow.Cells["cal_payment_type"].Value.ToString();
check.ShowDialog();
gridview();
}
else if (e.ColumnIndex == dgv_deliver.Columns["cal_cancel"].Index && e.RowIndex >= 0)
{
DialogResult dialogResult = MessageBox.Show("Are You Sure Want To Delete Delivery", "Cancel", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
DataTable dt = blord.getalldata(Convert.ToDecimal(dgv_deliver.CurrentRow.Cells["calkotid"].Value.ToString()));
if (dt.Rows.Count > 0)
{
for (int x = 0; dt.Rows.Count > x; x++)
{
string customer_name = dt.Rows[x]["user_name"].ToString();
table_no = Convert.ToDecimal(dt.Rows[x]["table_no"].ToString());
string item_name = dt.Rows[x]["item"].ToString();
decimal quantity = Convert.ToDecimal(dt.Rows[x]["quantity"].ToString());
decimal total = Convert.ToDecimal(dt.Rows[x]["total"].ToString());
decimal cost = Convert.ToDecimal(dt.Rows[x]["cost"].ToString());
string category_name = dt.Rows[x]["category_name"].ToString();
string phone_no = dt.Rows[x]["phone"].ToString();
int bocs = bloc.insertordercancellation(customer_name, table_no, item_name, quantity, total, cost, "NO", category_name, "K1", phone_no, DateTime.Now, "NULL", "HD");
}
int vb = blress.voidBillInsert(Convert.ToInt32(dgv_deliver.CurrentRow.Cells["calbill_no"].Value), Convert.ToInt32(0), "Home Delivery Cancel", "True", DateTime.Now, Login.sendtext);//void bill no save
int delete_by_table = blord.deletefromtable(table_no);
if (delete_by_table > 0)
{
int hd_no = (int)table_no;
int delete_home_no = BLLhome.deletehomedeleveryid(hd_no.ToString());
int deletehomedelevery = BLLhome.deletehomedeleveryvalue(table_no);
MessageBox.Show("Home Delivery Order Has Been Deleted");
gridview();
}
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dtchk = BLLhome.getalldatabykotId(Convert.ToDecimal(lblkotid.Text));
if (dtchk.Rows.Count > 0)
{
service_charge = Convert.ToDecimal(dtchk.Rows[0]["service_charge"].ToString());
taxable_amount = Convert.ToDecimal(dtchk.Rows[0]["taxable_amount"].ToString());
tax_amount = Convert.ToDecimal(dtchk.Rows[0]["tax_amount"].ToString());
fiscal_year = dtchk.Rows[0]["fiscal_year"].ToString();
customer_name = dtchk.Rows[0]["customer_name"].ToString();
customer_address = dtchk.Rows[0]["customer_adress"].ToString();
customer_phone = dtchk.Rows[0]["customer_name"].ToString();
grand_total = Convert.ToDecimal(dtchk.Rows[0]["grandtotal"].ToString());
sub_total = Convert.ToDecimal(dtchk.Rows[0]["total"].ToString());
discount = dtchk.Rows[0]["discount"].ToString();
dtItem = blord.getalldata(Convert.ToDecimal(lblkotid.Text));
for (int z = 0; z < dtItem.Rows.Count; z++)
{
order_id = Convert.ToInt32(dtItem.Rows[z]["order_id"].ToString());
string item_name = dtItem.Rows[z]["item"].ToString();
decimal quantity = Convert.ToDecimal(dtItem.Rows[z]["quantity"].ToString());
total = Convert.ToDecimal(dtItem.Rows[z]["total"].ToString());
decimal cost = Convert.ToDecimal(dtItem.Rows[z]["cost"].ToString());
string category_name = dtItem.Rows[z]["category_name"].ToString();
string service_provider = "";
int b = blres.insertintosalesbook(bill_no, date, txtcashier.Text, category_name, homeId.Text, customer_name, "", item_name, quantity, cost, total, lbl_payment_type.Text, "", sub_total, Convert.ToDecimal(0.00), grand_total, Convert.ToDecimal(0.00), grand_total, "HD", "", "X", service_charge, taxable_amount, tax_amount, fiscal_year, service_provider, date, 0, z, DateTime.Now.ToString("HH:mm tt"), "False", 0, "", "", 0, "", order_id);
}
int ibiza = blres.insert_into_bill_invoice(bill_no);
int delete_home_no = BLLhome.deletehomedeleveryid(lblkotid.Text);
int deletehomedelevery = BLLhome.deletehomedeleveryvalue(Convert.ToDecimal(lblkotid.Text));
int delete = BLLhome.deleteHomedeliveryStatus(lblkotid.Text);
// printer_checker();
MessageBox.Show("Checked");
this.Hide();
}
else
{
MessageBox.Show("The Payment was already Received. Check it.");
}
}
public void datagridviewload()
{
dataGridView1.Rows.Clear();
DataTable dt = new DataTable();
dt = blord.getalldata(Convert.ToDecimal(lbltable.Text));
if (dt.Rows.Count > 0)
{
for (int z = 0; z < dt.Rows.Count; z++)
{
dataGridView1.Rows.Add();
dataGridView1.Rows[z].Cells["cal_order_id"].Value = dt.Rows[z]["order_id"].ToString();
dataGridView1.Rows[z].Cells["cal_item_name"].Value = dt.Rows[z]["item"].ToString();
dataGridView1.Rows[z].Cells["cal_qty"].Value = dt.Rows[z]["quantity"].ToString();
dataGridView1.Rows[z].Cells["cal_total"].Value = dt.Rows[z]["total"].ToString();
dataGridView1.Rows[z].Cells["cal_cost"].Value = dt.Rows[z]["cost"].ToString();
dataGridView1.Rows[z].Cells["cal_category_name"].Value = dt.Rows[z]["category_name"].ToString();
}
calculate_total();
this.Refresh();
//clear();
}
}
