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