private void btnprint_Click(object sender, EventArgs e) { print(); if (txtsearch.Text.Length > 0) { if (dataGridView1.Rows.Count > 0) { for (int a = 0; a < dataGridView1.Rows.Count; a++) { string item = (dataGridView1.Rows[a].Cells[3].Value.ToString()); int quantity = Convert.ToInt32(dataGridView1.Rows[a].Cells[4].Value.ToString()); decimal total = Convert.ToDecimal(dataGridView1.Rows[a].Cells[5].Value.ToString()); string date = DateTime.Today.ToShortDateString(); int b = blod.addorder(item, quantity, total, Convert.ToDateTime(date)); } } else { lblmsg.Text = "No record found in database"; } int i = blod.deletefromtable(Convert.ToInt32(txtsearch.Text)); if (i > 0) { MessageBox.Show("Data has been save to database"); } } }
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(); } } } } }