protected void saveButton_Click(object sender, EventArgs e)
{
Medicine aMedicine = new Medicine();
aMedicine.Name = medicineTextBox.Text;
msgLabel.Text = aMedicineManager.Save(aMedicine);
medicineGridView.DataSource = aMedicineManager.ShowMedicine();
medicineGridView.DataBind();
}
public string Save(Medicine aMedicine)
{
if (aMedicineGateway.Save(aMedicine) > 0)
{
return "Saved Successfully";
}
else
{
return "Failed";
}
}
public List<Medicine> GetCenterAllMedicineList(int centerId)
{
List<Medicine> medicineList = new List<Medicine>();
string query = "SELECT * FROM CenterMedicineRelationTBL WHERE CenterId='" + centerId + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int medicineId = int.Parse(reader["MedicineId"].ToString());
Medicine aMedicine = new Medicine();
aMedicine = medicineManager.GetCenterAllMedicines(medicineId);
aMedicine.Quantity = int.Parse(reader["Quantity"].ToString());
medicineList.Add(aMedicine);
}
reader.Close();
connection.Close();
return medicineList;
}