public List<SendMedicine> MedicineList(int district, int thana, int center)
{
SqlConnection connection = new SqlConnection(connectionString);
string query ="select MedicineName, Quantity from tbl_SendMedicine where DistrictID = '"+district+"' and ThanaID = '"+thana+"' and Center = '"+center+"'";
SqlCommand command = new SqlCommand(query,connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List<SendMedicine> medicines = new List<SendMedicine>();
while (reader.Read())
{
SendMedicine aMedicine = new SendMedicine();
aMedicine.Medicine = reader["MedicineName"].ToString();
aMedicine.Quantity = int.Parse(reader["Quantity"].ToString());
medicines.Add(aMedicine);
}
reader.Close();
connection.Close();
return medicines;
}
public int saveSendMedicine(SendMedicine aSendMedicine)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "insert into tbl_SendMedicine values('"+aSendMedicine.DistrictID+"','"+aSendMedicine.ThanaID+"','"+aSendMedicine.CenterID+"','"+aSendMedicine.Medicine+"','"+aSendMedicine.Quantity+"')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}
public List<SendMedicine> LoadMedicines(string center, string thana, string district)
{
int centerID = aMedicineGateway.GetIDByCenterName(center);
int thanaID = aMedicineGateway.GetIDByThanaName(thana);
int districtID = aMedicineGateway.GetIDByDistrictName(district);
SqlConnection connection = new SqlConnection(connectionString);
string query = "select * from tbl_SendMedicine where Center = '" + centerID + "' and ThanaID = '" + thanaID + "' and DistrictID = '" + districtID + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
List<SendMedicine> medicineList = new List<SendMedicine>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
SendMedicine aMedicine = new SendMedicine();
aMedicine.ID = int.Parse(reader["ID"].ToString());
aMedicine.Medicine = reader["MedicineName"].ToString();
medicineList.Add(aMedicine);
}
reader.Close();
connection.Close();
return medicineList;
}
protected void saveButton_Click(object sender, EventArgs e)
{
int result = 0;
foreach (MedicineQuantity medicineQuantity in medicineList)
{
SendMedicine aSendMedicine = new SendMedicine();
string district = districtDropDownList.SelectedItem.ToString();
aSendMedicine.DistrictID = aMedicineManager.GetIDByDistrictName(district);
string thana = thanaDropDownList.SelectedItem.ToString();
aSendMedicine.ThanaID = aMedicineManager.GetIDByThanaName(thana);
string center = centerDropDownList.SelectedItem.ToString();
aSendMedicine.CenterID = aMedicineManager.GetIDByCenterName(center);
aSendMedicine.Medicine = medicineQuantity.Name;
aSendMedicine.Quantity = int.Parse(medicineQuantity.Quantity.ToString());
result = aMedicineManager.saveSendMedicine(aSendMedicine);
}
if (result != 0)
{
showLabel.Text = "Medicines added to center.";
}
else
{
showLabel.Text = "Medicines not added.";
}
}
public int saveSendMedicine(SendMedicine aSendMedicine)
{
return aGateway.saveSendMedicine(aSendMedicine);
}
