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