private void LoadFromRow(DataRow row)
 {
     try
     {
         ID = Convert.ToInt32(row["int"]);
         HelperName = Convert.ToString(row["HelperName"]);
         HelperTimeAllocation = new HelperTimeAllocation(row);
         HelperJob = new HelperJobs(row);
         ShowDetails = new ShowDetails(row);
         Judge = new Judge(row);
         RingPartyName = row["RingPartyName"].ToString();
         Comments = row["Comments"].ToString();
     }
     catch (Exception e)
     {
         AppException.LogEvent("HelperForShow.LoadFromRow:" + e.Message);
     }
 }
        public static HelperDialogDto GetHelperForDialog(int ShowID, int UserID)
        {
            var days = ShowDetails.GetShowDetails(ShowID);
            var JudgeList = Judge.GetJudgesListForShow(ShowID);
            HelperForShow helper = new HelperForShow();
            var jobs = new HelperJobs().GetAllHelperJobs();
            var times = new HelperTimeAllocation().GetAllTimeAllocations();

            HelperDialogDto helperDialog = new HelperDialogDto
            {
                Days = new List<HelperShowDays>(),
                JobList = GetJobs()
            };

            helperDialog.Days = (from day in days
                                 select new HelperShowDays
                                 {
                                     DayName = day.ShowDate.ToString("dddd"),
                                     Id = day.ID,
                                     JobList = GetJobs(),
                                     JudgeList = (from judge in JudgeList
                                                  where judge.ShowDetailsID == day.ShowDetailsID
                                                  select new HelperJudge
                                                  {
                                                      JudgeId = judge.ID,
                                                      JudgeName = judge.Name
                                                  }).ToList()
                                 }).ToList();

            return helperDialog;
        }