private void buttonUpdateCopies_Click(object sender, EventArgs e)
{
//----------------------Update Copies of Drugs
string givenID = textBoxDrugIdUpdateCopies.Text;
string givenCopies = textBoxUpdateCopies.Text;
if (givenID != "" && givenCopies != "")
{
//---------------------------------------Query For found Id Exist in database
string query = "Select COUNT (*) FROM PharmasyTable WHERE Id= '" + givenID + "'";
DataTable dt = new DataTable();
ClassCommon.SqlC_DAOpenFillCose(query, dt);
string truevalue = dt.Rows[0][0].ToString();
if (truevalue == "1")
{
//Database
int Copies = Convert.ToInt16(givenCopies);
string colmnName = "Copies";
ClassUpdate.UpdateAnyForPharmasy(colmnName, givenID, Copies);
MessageBox.Show("Success");
buttonShowPharmasyList_Click(sender, e);
}
else
{
MessageBox.Show("ID " + givenID + " Not Found");
}
}
else
{
MessageBox.Show("Please Fill All Field");
}
}
private void buttonSellDrug_Click(object sender, EventArgs e)
{
string drugSellId = textBoxDrugId.Text;
string col = textBoxCollected.Text;
string ret = textBoxReturned.Text;
string query2 = "Select COUNT (*) FROM PharmasyTable WHERE Id= '" + drugSellId + "'";
DataTable dt2 = new DataTable();
ClassCommon.SqlC_DAOpenFillCose(query2, dt2);
string truevalue = dt2.Rows[0][0].ToString();
if (truevalue == "1")
{
if (drugSellId != "" && col != "" && ret != "") //------------- For Exception Handel (Sell Button Click Without Input)
{
string query = "SELECT Price , Name ,Copies, SoldCopies FROM PharmasyTable WHERE Id= '" + drugSellId + "' ";
DataTable dt = new DataTable();
ClassCommon.SqlC_DAOpenFillCose(query, dt);
int orginalPrice = Convert.ToInt16(dt.Rows[0][0].ToString());
string drugName = dt.Rows[0][1].ToString();
int RemainCopies = Convert.ToInt16(dt.Rows[0][2].ToString());
int SoldCopies = Convert.ToInt16(dt.Rows[0][3].ToString());
int collected = Convert.ToInt16(col);
int returned = Convert.ToInt16(ret);
if (((collected - returned) == orginalPrice) && RemainCopies > 0)
{
string colmnName = "Copies";
ClassUpdate.UpdateAnyForPharmasy(colmnName, drugSellId, RemainCopies - 1);
string colmnName2 = "SoldCopies";
ClassUpdate.UpdateAnyForPharmasy(colmnName2, drugSellId, SoldCopies + 1);
ClassUpdate.UpdatePharmasySoldStatus(drugSellId);
MessageBox.Show("This Producted is sold, Now Print Recipt", "Success");
printReceipt(drugSellId, drugName, collected, returned, orginalPrice);
}
else
{
MessageBox.Show("Sell Not Possible ", "Price Not Matched", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Fill All Box ", "Enter All Textbox", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("This Id Is not Exist In Database");
}
}