public Home() { InitializeComponent(); Db = new DTDB(); }
private void btnAdd_Click(object sender, EventArgs e) { int c = 0, c1 = 0; if (string.IsNullOrWhiteSpace(txtCode.Text) || string.IsNullOrWhiteSpace(txtName.Text) || (txtML.Visible == true && string.IsNullOrWhiteSpace(txtML.Text)) || string.IsNullOrWhiteSpace(txtAc.Text) || string.IsNullOrWhiteSpace(txtFc.Text) || string.IsNullOrWhiteSpace(txtGarden.Text) || string.IsNullOrWhiteSpace(txtOc.Text) || string.IsNullOrWhiteSpace(txtParcel.Text) || string.IsNullOrWhiteSpace(txtRoom.Text)) { MessageBox.Show("Please fill all the feilds"); return; } if (comboGroup.SelectedIndex < 0 || (comboSubGroup.Visible == true && comboSubGroup.SelectedIndex < 0)) { MessageBox.Show("Please Select Product category or subcategory"); return; } try { db = new DTDB(); String sql = "insert into " + DTDB.TABLE_ITEMS + " (code,name,ml,category,tax,fc,ac,oc,room,parcel,garden) values(@code,@name,@ml,@category,@tax,@fc,@ac,@oc,@room,@parcel,@garden)"; SQLiteCommand cmd = new SQLiteCommand(sql, db.conn); cmd.Parameters.Add("@code", DbType.Int32).Value = txtCode.Text; cmd.Parameters.Add("@name", DbType.String).Value = txtName.Text; if (comboSubGroup.Visible == true) { if (comboSubGroup.Text.ToUpper().Contains("LIQUOR")) { cmd.Parameters.Add("@ml", DbType.Int32).Value = txtML.Text; } else { cmd.Parameters.Add("@ml", DbType.Int32).Value = 0; } cmd.Parameters.Add("@category", DbType.String).Value = comboSubGroup.Text; } else { cmd.Parameters.Add("@ml", DbType.Int32).Value = 0; cmd.Parameters.Add("@category", DbType.String).Value = comboGroup.Text; } if (chkTax.Checked == true) { cmd.Parameters.Add("@tax", DbType.Int32).Value = 1; } else { cmd.Parameters.Add("@tax", DbType.Int32).Value = 0; } cmd.Parameters.Add("@fc", DbType.Double).Value = txtFc.Text; cmd.Parameters.Add("@ac", DbType.Double).Value = txtAc.Text; cmd.Parameters.Add("@oc", DbType.Double).Value = txtOc.Text; cmd.Parameters.Add("@room", DbType.Double).Value = txtFc.Text; cmd.Parameters.Add("@parcel", DbType.Double).Value = txtParcel.Text; cmd.Parameters.Add("@garden", DbType.Double).Value = txtGarden.Text; sql = "insert into " + DTDB.TABLE_STOCK + " (code,qty,ml) values(@code,@qty,@ml)"; SQLiteCommand cmd1 = new SQLiteCommand(sql, db.conn); cmd1.Parameters.Add("@code", DbType.Int32).Value = txtCode.Text; cmd1.Parameters.Add("@qty", DbType.Int32).Value = txtQty.Text; if (comboSubGroup.Visible == true && comboSubGroup.Text.ToUpper().Contains("LIQUOR")) { cmd1.Parameters.Add("@ml", DbType.Int32).Value = txtML.Text; } else { cmd1.Parameters.Add("@ml", DbType.Int32).Value = 0; } if ((c = cmd.ExecuteNonQuery()) > 0 && (c1 = cmd1.ExecuteNonQuery()) > 0) { MessageBox.Show("Item Added SuccessFully"); } else if (c > 0 && c1 <= 0) { SQLiteCommand cmd2 = new SQLiteCommand("delete from " + DTDB.TABLE_ITEMS + " where code=@code", db.conn); cmd2.Parameters.Add("@code", DbType.Int32).Value = txtCode.Text; cmd2.ExecuteNonQuery(); MessageBox.Show("Unable to Add the Product Please try again later..."); } else if (c <= 0 && c1 > 0) { SQLiteCommand cmd2 = new SQLiteCommand("delete from " + DTDB.TABLE_STOCK + " where code=@code", db.conn); cmd2.Parameters.Add("@code", DbType.Int32).Value = txtCode.Text; cmd2.ExecuteNonQuery(); MessageBox.Show("Unable to Add the Product Please try again later..."); } } catch (SQLiteException e1) { if (e1.ErrorCode == 19) { MessageBox.Show("Item With such code already exists!!! "); } else { MessageBox.Show(e1.Message); } } catch (Exception e1) { MessageBox.Show(e1.Message); } finally { db.conn.Close(); } }