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