public Medicine Find(string name)
{
string query = "SELECT * FROM tbl_medicine WHERE name='" + name + "'";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlConnection.Open();
ASqlDataReader = ASqlCommand.ExecuteReader();
if (ASqlDataReader.HasRows)
{
Medicine aMedicine = new Medicine();
ASqlDataReader.Read();
aMedicine.Id = (int)ASqlDataReader["id"];
aMedicine.Name = ASqlDataReader["name"].ToString();
aMedicine.Power = Convert.ToDecimal(ASqlDataReader["power"]);
aMedicine.Type = ASqlDataReader["type"].ToString();
ASqlDataReader.Close();
ASqlCommand.Dispose();
ASqlConnection.Close();
return aMedicine;
}
else
{
ASqlDataReader.Close();
ASqlCommand.Dispose();
ASqlConnection.Close();
return null;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
MedicineManager aMedicineManager = new MedicineManager();
Medicine aMedicine = new Medicine();
aMedicine.Name = nameTextBox.Text;
aMedicine.Power = Convert.ToInt32(powerTextBox.Text);
aMedicine.Type = mgMlDropDownList.SelectedItem.ToString();
string msg = aMedicineManager.SaveMedicine(aMedicine);
msgLabel.Text = msg;
}
public string SaveMedicine(Medicine aMedicine)
{
Medicine medicineFound = aMedicineDBGateway.Find(aMedicine.Name);
if (medicineFound == null)
{
aMedicineDBGateway.SaveMedicine(aMedicine);
return "Medicine Successfully Saved...!!!";
}
else
{
return "This medicine already exist";
}
}
public List<Medicine> GetAllMedicines()
{
List<Medicine> medicineList = new List<Medicine>();
string query = "SELECT * FROM tbl_medicine";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlConnection.Open();
ASqlDataReader = ASqlCommand.ExecuteReader();
while (ASqlDataReader.Read())
{
Medicine aMedicine = new Medicine();
aMedicine.Id = (int)ASqlDataReader["id"];
aMedicine.Name = ASqlDataReader["name"].ToString();
aMedicine.Power = Convert.ToDecimal(ASqlDataReader["power"]);
aMedicine.Type = ASqlDataReader["type"].ToString();
medicineList.Add(aMedicine);
}
ASqlDataReader.Close();
ASqlCommand.Dispose();
ASqlConnection.Close();
return medicineList;
}
public void SaveMedicine(Medicine aMedicine)
{
ASqlConnection.Open();
string query = "INSERT INTO tbl_medicine VALUES('" + aMedicine.Name + "','" + aMedicine.Power + "','" + aMedicine.Type + "')";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlCommand.ExecuteNonQuery();
ASqlConnection.Close();
}
public List<Medicine> GetSelectedMedicines(int centerId)
{
List<Medicine> medicineList = new List<Medicine>();
string query = "SELECT * FROM tbl_medicine med JOIN tbl_medicine_stock_center med_stock ON med.id = med_stock.medicine_id WHERE med_stock.center_id='" +centerId+ "'";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlConnection.Open();
ASqlDataReader = ASqlCommand.ExecuteReader();
while (ASqlDataReader.Read())
{
Medicine aMedicine = new Medicine();
aMedicine.Id = (int)ASqlDataReader["id"];
aMedicine.Name = ASqlDataReader["name"].ToString();
aMedicine.Power = Convert.ToDecimal(ASqlDataReader["power"]);
aMedicine.Type = ASqlDataReader["type"].ToString();
medicineList.Add(aMedicine);
}
ASqlDataReader.Close();
ASqlCommand.Dispose();
ASqlConnection.Close();
return medicineList;
}
