public int CenterStockSave(CenterMedicineStock medicine)
{
string query = "insert into Quantity_tbl(Quantity,CenterID,MedicineID) values('" + medicine.Quantity + "','" + medicine.CenterID + "','" + medicine.MedicineID + "')";
aGateway.sqlConnection.Open();
aGateway.command.CommandText = query;
int rowAffected = aGateway.command.ExecuteNonQuery();
aGateway.sqlConnection.Close();
return rowAffected;
}
public List<CenterMedicineStock> GetStock(DAL.DAO.Center newCenter)
{
List<CenterMedicineStock> listofStock = aCenterGateway.ListofStocks(newCenter);
List<CenterMedicineStock> medicineStockWithDetails=new List<CenterMedicineStock>();
foreach (CenterMedicineStock medicineStock in listofStock)
{
CenterMedicineStock newMedicineStock=new CenterMedicineStock();
newMedicineStock.Quantity = medicineStock.Quantity;
newMedicineStock.MedicineName = aCenterGateway.MedicineName(medicineStock.MedicineID);
medicineStockWithDetails.Add(newMedicineStock);
}
return medicineStockWithDetails;
}
public bool IsMedicineExist(CenterMedicineStock medicine,out int quantity)
{
bool result = false;
quantity = 0;
aGateway.command.CommandText = "SELECT * FROM Quantity_tbl WHERE CenterID='" + medicine.CenterID + "' AND MedicineID='"+medicine.MedicineID+"'";
aGateway.sqlConnection.Open();
SqlDataReader reader = aGateway.command.ExecuteReader();
while (reader.Read())
{
result = true;
quantity = int.Parse(reader["Quantity"].ToString());
break;
}
reader.Close();
aGateway.sqlConnection.Close();
return result;
}
public List<CenterMedicineStock> ListofStocks(DAO.Center aCenter)
{
List<CenterMedicineStock> stock= new List<CenterMedicineStock>();
aGateway.command.CommandText = "SELECT * FROM Quantity_tbl WHERE CenterID='"+ aCenter.ID +"'";
aGateway.sqlConnection.Open();
SqlDataReader reader = aGateway.command.ExecuteReader();
while (reader.Read())
{
CenterMedicineStock newMedicine=new CenterMedicineStock();
newMedicine.Quantity = int.Parse(reader[1].ToString());
newMedicine.MedicineID = int.Parse(reader[3].ToString());
stock.Add(newMedicine);
}
reader.Close();
aGateway.sqlConnection.Close();
return stock;
}
private void StockSave()
{
List<CenterMedicineStock> currentStocks = (List<CenterMedicineStock>)ViewState["MedicineStock"];
CenterMedicineStock newMedicineStock = new CenterMedicineStock();
newMedicineStock.MedicineID = int.Parse(medicineDropDownList.SelectedItem.Value);
newMedicineStock.Quantity = int.Parse(quantityMedicineTextBox.Text);
newMedicineStock.CenterID = int.Parse(centerDropDownList.SelectedItem.Value);
currentStocks.Add(newMedicineStock);
ViewState["MedicineStock"] = currentStocks;
}