private void AddShopIdForEmpLevel3() { string sql = "SELECT * FROM employee WHERE work_place = 'shop'"; try { myDataHelper.OpenConnection(); MySqlDataReader reader = MyDataHelper.DataReader(sql); while (reader.Read()) { ((Employee)myEvent.GetPersonById(Convert.ToInt32(reader["empNr"]))).ChangeShop(myEvent.GetShopById(Convert.ToInt32(reader["SERVICE_POINT_id"]))); } } catch { return; } finally { myDataHelper.CloseConnection(); } }