void ClearBoxes() { id.Clear(); label.Clear(); price.Clear(); qty.Clear(); priceafterQ.Clear(); disCount.Clear(); TotalPrice.Clear(); choosebtn.Focus(); }
private void add_Click(object sender, EventArgs e) { int a = 0; //count rows //int rows = Orderdgv.Rows.Count; //rows = rows - 1; int insertid = 0; //Count number of products from grid view int sum = 0; for (int i = 0; i < Orderdgv.Rows.Count; ++i) { sum += Convert.ToInt32(Orderdgv.Rows[i].Cells[3].Value); } // MessageBox.Show(sum.ToString()) ; //Remaining amount checks if (ReceivedAmount.Text == "") { if (Convert.ToInt32(TotalPrice.Text) < 0) { ReceivedAmount.Text = TotalPrice.Text; ReceivedAmount.Text = "-" + ReceivedAmount.Text; } ReceivedAmount.Text = TotalPrice.Text; } //inseted bill id int remaining = Convert.ToInt32(ReceivedAmount.Text) - Convert.ToInt32(TotalPrice.Text); if (remaining < 0) { MessageBox.Show("INVALID AMOUNT RECEIVED"); } else { try { //Add BIll details into billdb // only add billid,qty,amount , seller name MessageBox.Show(a.ToString()); a++; DateTime dateTime = DateTime.Now; Con.Open(); String query = "insert into billdb (items, amount, seller,date) values('" + sum.ToString() + "','" + TotalPrice.Text + "','" + Form1.SetValueForText1 + "','" + dateTime.ToShortDateString() + "'); select @@identity;"; SqlCommand cmd = new SqlCommand(query, Con); //cmd.ExecuteNonQuery(); insertid = int.Parse(cmd.ExecuteScalar().ToString()); MessageBox.Show(insertid.ToString()); Con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } int check = Convert.ToInt32(TotalPrice.Text); if (check < 0) { MessageBox.Show("Total Products = " + sum.ToString() + "\n" + "Total Bill = " + TotalPrice.Text + "\n" + "Customer Remaining Change = " + remaining); } if (check > 0) { //Show the change MessageBox.Show("Total Products = " + sum.ToString() + "\n" + "Total Bill = " + TotalPrice.Text + "\n" + "Amount Recieved= " + ReceivedAmount.Text + "\n" + "Change = " + remaining); } int i = 0; //MessageBox.Show("Yahan se"); // //Insert items into table // for (i = 0; i < Orderdgv.Rows.Count - 1; i++) { try { Con.Open(); // MessageBox.Show("Yahse"); string StrQuery = "INSERT INTO solditems (pid,billid, pname, pprice,pqty,total) VALUES ('" + Orderdgv.Rows[i].Cells[0].Value + "', '" + insertid + "', '" + Orderdgv.Rows[i].Cells[1].Value + "', '" + Orderdgv.Rows[i].Cells[2].Value + "', '" + Orderdgv.Rows[i].Cells[3].Value + "', '" + Orderdgv.Rows[i].Cells[4].Value + "')"; SqlCommand cmd = new SqlCommand(StrQuery, Con); cmd.ExecuteNonQuery(); Con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); Con.Close(); } } Orderdgv.Rows.Clear(); ProQty.Clear(); ProName.Clear(); ProPrice.Clear(); TotalPrice.Clear(); ReceivedAmount.Clear(); } }