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