private void buttonDrugInsert_Click(object sender, EventArgs e)
{
//-----------------------Insert New Drugs
string id = textBoxDrugIdInsert.Text;
string name = textBoxDrugName.Text;
string givenprice = textBoxDrugPriceInsert.Text;
string givencopies = textBoxDrugCopiesInsert.Text;
if (id != "" && name != "" && givenprice != "" && givencopies != "")
{
//---------------------------------------Query For found Id Exist in database
string query = "Select COUNT (*) FROM PharmasyTable WHERE Id= '" + id + "'";
DataTable dt = new DataTable();
ClassCommon.SqlC_DAOpenFillCose(query, dt);
string truevalue = dt.Rows[0][0].ToString();
if (truevalue == "0")
{
//Database
int Price = Convert.ToInt16(givenprice);
int Copies = Convert.ToInt16(givencopies);
ClassInsert.InsertInPharmasyTable(id, name, Price, Copies);
MessageBox.Show("Success");
buttonShowPharmasyList_Click(sender, e);
}
else
{
MessageBox.Show("Given Id already In Database");
}
}
else
{
MessageBox.Show("Please Fill All Field");
}
}
