public List <AbstractMedicine> GetAllMedicines() { List <AbstractMedicine> allMedicines = new List <AbstractMedicine>(); using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "Select * from AbstractMedicine"; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { AbstractMedicine medicine = new AbstractMedicine(); medicine.mid = Convert.ToInt32(reader["mid"]); medicine.name = reader["name"].ToString(); medicine.description = reader["description"].ToString(); medicine.price = Convert.ToDouble(reader["price"]); medicine.type = reader["type"].ToString(); medicine.state = reader["state"].ToString(); allMedicines.Add(medicine); } } return(allMedicines); }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { String selected = listBox1.SelectedItem as string; selectedAbstractMedicine = medicines.Find(m => m.name == selected); textBox1.Text = selectedAbstractMedicine.name; textBox2.Text = selectedAbstractMedicine.description; textBox3.Text = selectedAbstractMedicine.type; textBox4.Text = selectedAbstractMedicine.state; textBox5.Text = selectedAbstractMedicine.price.ToString(); }
public void updateMedicine(AbstractMedicine medicine) { using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand { Connection = con, CommandText = "Update AbstractMedicine SET name = @name, description=@description, type=@type, state=@state, price=@price where mid =@mid" }; cmd.Parameters.Add(new SqlParameter("@name", medicine.name)); cmd.Parameters.Add(new SqlParameter("@description", medicine.description)); cmd.Parameters.Add(new SqlParameter("@price", medicine.price)); cmd.Parameters.Add(new SqlParameter("@type", medicine.type)); cmd.Parameters.Add(new SqlParameter("@state", medicine.state)); cmd.Parameters.Add(new SqlParameter("@mid", medicine.mid)); con.Open(); cmd.ExecuteNonQuery(); } }
public int createMedince(AbstractMedicine medicine) { int mid = 0; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand { Connection = con, CommandText = "INSERT INTO AbstractMedicine (name,description,type,state,price) VALUES(@name,@description,@type,@state,@price);select scope_identity();" }; cmd.Parameters.Add(new SqlParameter("@name", medicine.name)); cmd.Parameters.Add(new SqlParameter("@description", medicine.description)); cmd.Parameters.Add(new SqlParameter("@type", medicine.type)); cmd.Parameters.Add(new SqlParameter("@state", medicine.state)); cmd.Parameters.Add(new SqlParameter("@price", medicine.price)); con.Open(); mid = Convert.ToInt32(cmd.ExecuteScalar()); } return(mid); }
private void button1_Click(object sender, EventArgs e) { AbstractMedicine m = new AbstractMedicine(); m.name = textBox1.Text; m.description = textBox2.Text; m.type = textBox3.Text; m.state = textBox4.Text; m.price = float.Parse(textBox5.Text); List <string> selectedrugs = new List <string>(); foreach (object li in listBox1.SelectedItems) { selectedrugs.Add(li as string); } DrugWeightForm dw = new DrugWeightForm(selectedrugs); DialogResult d = dw.ShowDialog(); List <DrugWeight> ldw = new List <DrugWeight>(); foreach (var pair in DrugWeightForm.drug_values) { int did = mrdb.getDrugIdByName(pair.Key); double weight = pair.Value; ldw.Add(new DrugWeight(did, weight)); } int mid = mrdb.createMedince(m); mrdb.addDrugToMedicine(mid, ldw); //m.drugweight label6.Text = "New Medicine Successfully Added"; }
public bool removeMedicine(AbstractMedicine m) { medicines.Remove(m); return(true); }
public bool addNewMedicine(AbstractMedicine m) { medicines.Add(m); return(true); }