private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if ((e.KeyChar == 13) && (textBox1.Text != String.Empty)) { string id = ""; bool found = false; cn.Open(); cm = new SqlCommand("select * from tblCart where transno = @transno and pcode = @pcode", cn); cm.Parameters.AddWithValue("@transno", fpos.lblTransaction.Text); cm.Parameters.AddWithValue("@pcode", pcode); dr = cm.ExecuteReader(); dr.Read(); if (dr.HasRows) { found = true; id = dr["id"].ToString(); } else { found = false; } dr.Close(); cn.Close(); if (found == true) { cn.Open(); cm = new SqlCommand("update tblCart set qty = (qty + " + int.Parse(textBox1.Text) + ") where id = '" + id + "'", cn); cm.ExecuteNonQuery(); cn.Close(); fpos.txtSearch.Clear(); fpos.txtSearch.Focus(); fpos.LoadCart(); this.Dispose(); } else { cn.Open(); cm = new SqlCommand("insert into tblCart (transno, pcode, price, qty, sdate, cashier) values (@transno, @pcode, @price, @qty, @sdate, @cashier)", cn); cm.Parameters.AddWithValue("@transno", transno); cm.Parameters.AddWithValue("@pcode", pcode); cm.Parameters.AddWithValue("@price", price); cm.Parameters.AddWithValue("@qty", int.Parse(textBox1.Text)); cm.Parameters.AddWithValue("@sdate", DateTime.Now); cm.Parameters.AddWithValue("@cashier", fpos.lblName.Text.Substring(0, fpos.lblName.Text.IndexOf(" |"))); cm.ExecuteNonQuery(); cn.Close(); fpos.txtSearch.Clear(); fpos.txtSearch.Focus(); fpos.LoadCart(); this.Dispose(); } } }
private void btnEnter_Click(object sender, EventArgs e) { try { if ((double.Parse(txtChange.Text) < 0) || (txtChange.Text.ToString() == String.Empty)) { MessageBox.Show("Insufficient amount. Please enter the correct amount!", "Danger!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { for (int i = 0; i < fpos.dataGridView1.Rows.Count; i++) { //Update Product Table cn.Open(); cm = new SqlCommand("update tblProduct set qty = qty - " + int.Parse(fpos.dataGridView1.Rows[i].Cells[5].Value.ToString()) + " where pcode = '" + fpos.dataGridView1.Rows[i].Cells[8].Value.ToString() + "'", cn); cm.ExecuteNonQuery(); cn.Close(); //Update Cart Table cn.Open(); cm = new SqlCommand("update tblCart set status = 'Sold' where id like '" + fpos.dataGridView1.Rows[i].Cells[1].Value.ToString() + "' and status like 'Pending'", cn); cm.ExecuteNonQuery(); cn.Close(); } formRecieptPOS frm = new formRecieptPOS(fpos); frm.LoadReport(txtCash.Text, txtChange.Text); frm.ShowDialog(); MessageBox.Show("Payment Sucessfuly Saved", "Payment", MessageBoxButtons.OK, MessageBoxIcon.Information); fpos.getTransNo(); fpos.LoadCart(); this.Dispose(); } } catch (Exception) { MessageBox.Show("Insufficient amount. Please enter the correct amount!", "Danger!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnConfirm_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Add discount? Click Yes To Confirm.", stitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { cn.Open(); cm = new SqlCommand("update tblcart set disc = @disc where id = @id", cn); cm.Parameters.AddWithValue("@disc", Double.Parse(txtDiscAmount.Text)); cm.Parameters.AddWithValue("@id", int.Parse(lblID.Text)); cm.ExecuteNonQuery(); cn.Close(); fpos.LoadCart(); this.Dispose(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }