public List <MedicineStruct> GetAllMedicineNameIntoStorage()
{
string query = "SELECT distinct Gyogyszerek.Nev from Gyogyszerek, Raktaron where Raktaron.GyogyszerID = Gyogyszerek.GyogyszerID and Mennyiseg <> '0'", error = string.Empty;
SqlDataReader rdr = myExecuteReader(query, ref error);
List <MedicineStruct> gyogyszerList = new List <MedicineStruct>();
if (error == "OK")
{
while (rdr.Read())
{
MedicineStruct item = new MedicineStruct();
item.gyogyszerName = rdr[0].ToString();
gyogyszerList.Add(item);
}
}
CloseConnection();
return(gyogyszerList);
}
public List <MedicineStruct> GetAllMedicineName()
{
string query = "SELECT distinct Gyogyszerek.Nev from Gyogyszerek order by Gyogyszerek.Nev", error = string.Empty;
SqlDataReader rdr = myExecuteReader(query, ref error);
List <MedicineStruct> gyogyszerList = new List <MedicineStruct>();
if (error == "OK")
{
while (rdr.Read())
{
MedicineStruct item = new MedicineStruct();
item.gyogyszerName = rdr[0].ToString();
gyogyszerList.Add(item);
}
}
CloseConnection();
return(gyogyszerList);
}
