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