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