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();
}
}
}
