public PlaceItem getPlaceItemByName(string name)
{
sqlConnection = null;
sqlConnection = TimeTableDatabase.getConnection();
try
{
using (sqlConnection)
{
PlaceItem SQLItem = new PlaceItem();
string SQL = "SELECT [foodplaceid],[name] FROM [foodplace] " +
" WHERE [name]='" + name + "';";
sqlConnection.Open();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand(SQL, sqlConnection);
myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
SQLItem.PlaceID = Convert.ToInt32(myReader["foodplaceid"]);
SQLItem.PlaceName = myReader["name"].ToString();
sqlConnection.Close();
sqlConnection = null;
return SQLItem;
}
else
{
sqlConnection.Close();
sqlConnection = null;
return null;
}
}
}
catch (System.Exception)
{
return null;
}
}