private void btn_update_Click(object sender, EventArgs e) { int parsedvalue; if (this.txtusers.Text == "" || this.txtquantity.Text == "" || this.txtitem.Text == "" || this.txttableno.Text == "") { MessageBox.Show("the inputs are empty.."); } else if (!int.TryParse(txtquantity.Text, out parsedvalue) || !int.TryParse(txttableno.Text, out parsedvalue)) { MessageBox.Show("the inputs are wrong, check again and type... "); } else { int i = blod.updateorderstable(Convert.ToInt32(txttableno.Text), txtitem.Text, Convert.ToInt32(txtquantity.Text), order_id, Convert.ToDecimal(lbltotal.Text)); if (i > 0) { MessageBox.Show("Data Has Been Update"); this.Hide(); //update bhaye pachi gridview ma auto search bhaye ko chaena } } UserControl_order_lists uld = new UserControl_order_lists(); uld.search1(); this.Hide(); }
private void btn_item_transfer_Click(object sender, EventArgs e) { if (cbo_table_no_choose.Text != "Choose One" && cbo_table_no_choose.SelectedIndex > 0 && cbo_table_no_choose.Text != "") { if (dataGridView2.Rows.Count > 0) { for (int i = 0; i < dataGridView1.Rows.Count; i++) { string order_id = dataGridView1.Rows[i].Cells["cal_order_id"].Value.ToString(); string qty = dataGridView1.Rows[i].Cells["cal_qty"].Value.ToString(); string total = dataGridView1.Rows[i].Cells["cal_total"].Value.ToString(); string status = dataGridView1.Rows[i].Cells["cal_status"].Value.ToString(); if (status == "Update") { int update = blo.updateorderstable(Convert.ToDecimal(qty), Convert.ToInt32(order_id), Convert.ToDecimal(total)); //this stattement will update the item of datagridview1 } } for (int i = 0; i < dataGridView2.Rows.Count; i++) { string order_id = dataGridView2.Rows[i].Cells["cal_order_id_2"].Value.ToString(); string qty = dataGridView2.Rows[i].Cells["cal_qty_2"].Value.ToString(); string total = dataGridView2.Rows[i].Cells["cal_total_2"].Value.ToString(); string category_name = dataGridView2.Rows[i].Cells["cal_category_name2"].Value.ToString(); string kot_type = dataGridView2.Rows[i].Cells["cal_kot_type_2"].Value.ToString(); string item_name = dataGridView2.Rows[i].Cells["cal_item_name2"].Value.ToString(); string cost = dataGridView2.Rows[i].Cells["cal_cost_2"].Value.ToString(); string status = dataGridView2.Rows[i].Cells["cal_status_2"].Value.ToString(); string table_no = cbo_table_no_choose.SelectedValue.ToString(); if (status == "I") { //DataTable dt = blo.getallbyitem_nameandTableno(item_name, table_no); //if (dt.Rows.Count == 0) //{ int insert_order = blo.insertorder_using_sp(Login.sendtext, Convert.ToDecimal(table_no), item_name, Convert.ToDecimal(qty), Convert.ToDecimal(total), Convert.ToDecimal(cost), "Y", category_name, kot_type, "TS", "0", 0); //this will insert data of datagridview2 if (dataGridView2.Rows[i].Cells["cal_delete_status"].Value.ToString() == "True") { int delete_item = blo.deletefromorder_id(Convert.ToInt32(order_id)); } //else //{ //int updateOrder = blo.updateorderItemTransfer(Convert.ToInt32(order_id), Convert.ToDecimal(table_no)); // } } else { int updateOrder = blo.updateorderItemTransfer(Convert.ToInt32(order_id), Convert.ToDecimal(table_no));//this will update datagridview2 } } this.Close(); } else { MessageBox.Show("There is no data to transfer.", "Invalid Item Transfer", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Choose Correct Table No.", "Invalid Table No", MessageBoxButtons.OK, MessageBoxIcon.Error); } }