public bool UpdateQty(PurchaseesModelsd AMM)
{
try
{
var query = "UPDATE tbl_Madecine SET Quantity='" + AMM.Quntity + "' where Name='" + AMM.Medicine + "' ";
var rowAffected = _pharmaDb.ExecuteNonQuery(query, _connectionString);
return(rowAffected > 0);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
lblAllQty.Text = Convert.ToString(Convert.ToInt32(lblQuantity.Text) - Convert.ToInt32(txtQuantity.Text));
try
{
if (Convert.ToInt32(lblQuantity.Text) > 0)
{
var PurchaseesModel = new PurchaseesModelsd();
PurchaseesModel.Medicine = dropMedicine.SelectedItem.ToString();
PurchaseesModel.Quntity = Convert.ToInt32(lblAllQty.Text);
var isSave = _sealsManager.UpdateQty(PurchaseesModel);
if (isSave)
{
string successMessage = "Added Successfully";
lblMessage.Text = successMessage;
lblMessage.ForeColor = Color.Green;
AddPurchaseItems();
remove();
GridviewRowSum();
return;
}
string failMessage = "Fild Not Saved ";
lblMessage.Text = failMessage;
}
else
{
lblMessage.Text = "Please Stock In Medicine";
}
}
catch (Exception exception)
{
lblMessage.Text = exception.Message;
}
}
public bool UpdateQty(PurchaseesModelsd AMM)
{
var update2 = _purchaseRepository.UpdateQty(AMM);
return(update2);
}
