public List <Stock> GetAll(int centerId) { string query = "SELECT *FROM tbl_stock where centerId=" + centerId; ASqlConnection.Open(); ASqlCommand = new SqlCommand(query, ASqlConnection); ASqlDataReader = ASqlCommand.ExecuteReader(); List <Stock> stockList = new List <Stock>(); while (ASqlDataReader.Read()) { MedicineDBGateway aGateway = new MedicineDBGateway();; Stock aStock = new Stock(); Medicine aMedicine = aGateway.Find(Convert.ToInt32(ASqlDataReader["id"])); aStock.MedicineName = aMedicine.Name + "_" + aMedicine.MgMl; aStock.Quantity = (int)ASqlDataReader["quantity"]; stockList.Add(aStock); } ASqlDataReader.Close(); ASqlConnection.Close(); return(stockList); }