public ICUModel ViewICU(int id)
{
string stm = @"SELECT * FROM ICU WHERE Id=" + id;
using var cmd = new SQLiteCommand(stm, con);
using SQLiteDataReader rdr = cmd.ExecuteReader();
if (!rdr.Read())
{
return(null);
}
ICUModel iCUModel = new ICUModel();
iCUModel.id = (int)Convert.ToInt64(rdr["Id"]);
iCUModel.NumberOfBeds = (int)Convert.ToInt64(rdr["NumberOfBeds"]);
iCUModel.Layout = Convert.ToChar(rdr["Layout"]);
return(iCUModel);
}
public List <ICUModel> GetAllICU()
{
string stm = "SELECT * FROM ICU";
using var cmd = new SQLiteCommand(stm, con);
using SQLiteDataReader rdr = cmd.ExecuteReader();
Console.WriteLine("inside get");
List <ICUModel> listOfIcu = new List <ICUModel>();
while (rdr.Read())
{
ICUModel iCUObject = new ICUModel();
iCUObject.id = (int)Convert.ToInt64(rdr["Id"]);
iCUObject.NumberOfBeds = (int)Convert.ToInt64(rdr["NumberOfBeds"]);
iCUObject.Layout = Convert.ToChar(rdr["Layout"]);
listOfIcu.Add(iCUObject);
}
return(listOfIcu);
}
