public List <medicine_tb> get_medicinedata()
{
List <medicine_tb> aMedicineTbs = new List <medicine_tb>();
var highScores = db.medicine_tb;
foreach (var VAR1 in highScores)
{
medicine_tb aMedicineTb = new medicine_tb();
aMedicineTb.medicineID = VAR1.medicineID;
aMedicineTb.medicineName = VAR1.medicineName;
aMedicineTb.mg_ml = VAR1.mg_ml;
aMedicineTbs.Add(aMedicineTb);
}
return(aMedicineTbs);
}
public string getMedNamebyMedId(int ias)
{
medicine_tb aTb = new medicine_tb();
string name = "";
var highScores = from oTb in db.medicine_tb
where oTb.medicineID == ias
select oTb;
if (highScores.Count() == 1)
{
foreach (var VAR1 in highScores)
{
name = VAR1.medicineName;
}
}
return(name);
}
public void insert_data(medicine_tb aMedicineTb)
{
db.medicine_tb.Add(aMedicineTb);
db.SaveChanges();
}
