private void Check_Data() { Proceed_Registration = false; using (OleDbConnection con = new OleDbConnection(OledbCon)) { string query = "Select * From Master_Data where Item_Number = @ItemNum"; using (OleDbCommand cmd = new OleDbCommand(query, con)) { cmd.Parameters.AddWithValue("@ItemNum", ItemNumtxt.Text); con.Open(); OleDbDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { Proceed_Registration = false; MessageBox.Show("Item: " + ItemNumtxt.Text + " is already registered in the database."); Clear_Data(); ItemNumtxt.Focus(); } else { Proceed_Registration = true; } } } }
private void Item_Registration() { using (OleDbConnection con = new OleDbConnection(OledbCon)) { string query = "INSERT INTO Master_Data(Item_Number, Item_Name, Item_Category, Item_Quantity, Item_Orig_Price,Item_Price) " + "Values(@iNumber,@iName,@iCategory,@iQty,@iOPrice,@iPrice)"; using (OleDbCommand cmd = new OleDbCommand(query, con)) { cmd.Parameters.AddWithValue("@iNumber", ItemNumtxt.Text); cmd.Parameters.AddWithValue("@iName", ItemNametxt.Text); cmd.Parameters.AddWithValue("@iCategory", ItemCattxt.Text); cmd.Parameters.AddWithValue("@iQty", ItemQtytxt.Text); cmd.Parameters.AddWithValue("@iOPrice", OrigPricetxt.Text); cmd.Parameters.AddWithValue("@iPrice", ItemPricetxt.Text); con.Open(); int result = cmd.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("Registration Complete"); Clear_Data(); ItemNumtxt.Focus(); } con.Close(); } } }