public static void updateReviewedStatus(bool isReviewed, int CWID)
 {
     try
     {
         using (var db = new HearMyNameEntities())
         {
             StudentRecording originalRecord = db.StudentRecordings.Find(CWID);
             originalRecord.isReviewed = isReviewed;
             db.SaveChanges();
         }
     }
     catch (Exception ex)
     {
     }
 }
        protected void LoadData()
        {
            if (isNSO)
            {
                btnUpdate.Value = "Save and Log Out";
            }

            int numericCWID = Int32.Parse(CWID);

            hdrMainHeader.InnerText = Name;
            using (var db = new HearMyNameEntities())
            {
                if (db.StudentRecordings.FirstOrDefault(A => A.StudentCWID == numericCWID) != null) //this is an update
                {
                    StudentRecording previousRecord = db.StudentRecordings.First(A => A.StudentCWID == numericCWID);
                    if (!IsPostBack)
                    {
                        txtPreferredName.Value = previousRecord.StudentPreferredName.Replace("(student)", "");
                        txtPhoneticName.Value  = previousRecord.Pronounciation;
                        if (audioPlayer.Src == null || audioPlayer.Src.Contains("Default"))
                        {
                            audioPlayer.Attributes["src"] = $"~/userfiles/converted/{CWID}.mp3?noCache={new Random().Next(0, 1000).ToString()}"; //the NoCache parameter just makes it so that the name looks different to the browser so it doesn't cache it.
                        }
                        else
                        {
                            playButton.Disabled = true;
                        }
                    }

                    recordingID          = previousRecord.ID;
                    hdnRecordingID.Value = recordingID.ToString();
                }
                else //This is a recording for a student has never done this before
                {
                    txtPreferredName.Value = Name;
                    playButton.Disabled    = true;
                    hdnRecordingID.Value   = "0";
                }
            }
        }
        //copy the recording from the project directory to the file server (Waxmyrtle) and delete the current project directory copy.
        //save/update db record for the student.
        protected static string updateDatabase(int recordingID, string email, string pronounciation, string studentSystemName, string NTID, string preferredName, string currentUserID)
        {
            int numericCWID = Int32.Parse(currentUserID);

            try
            {
                using (var db = new HearMyNameEntities())
                {
                    string newRecodingID = string.Empty;
                    if (recordingID > 0) //a record exists, this is an UPdate
                    {
                        StudentRecording originalRecord = db.StudentRecordings.Find(recordingID);
                        originalRecord.StudentPreferredName = preferredName;
                        originalRecord.Pronounciation       = pronounciation;

                        AppEvent newAppEvent = new AppEvent
                        {
                            RecordingID     = recordingID,
                            ActionPerformed = "Updated recording",
                            NewStatus       = "NotApproved",
                            PerformedBy     = 1,
                            PerformedOn     = DateTime.Now
                        };
                        db.AppEvents.Add(newAppEvent);
                    }
                    else //this is a new record, inserrrrt!
                    {
                        StudentRecording newRecord = new StudentRecording
                        {
                            StudentCWID          = int.Parse(currentUserID),
                            StudentNTID          = NTID,
                            StudentName          = studentSystemName,
                            StudentPreferredName = string.IsNullOrEmpty(preferredName) ? " " : preferredName,
                            Pronounciation       = string.IsNullOrEmpty(pronounciation) ? " " : pronounciation,
                            StudentEmail         = email,
                            CreatedBy            = currentUserID,
                            CreatedOn            = DateTime.Now
                        };
                        AppEvent newAppEvent = new AppEvent
                        {
                            ActionPerformed = "Created a new recording",
                            NewStatus       = "NotApproved",
                            PerformedBy     = 1,
                            PerformedOn     = DateTime.Now
                        };

                        newRecord.AppEvents = new List <AppEvent>();
                        newRecord.AppEvents.Add(newAppEvent);
                        db.StudentRecordings.Add(newRecord);
                    }

                    db.SaveChanges();

                    StudentRecording previousRecord = db.StudentRecordings.First(A => A.StudentCWID == numericCWID);


                    return(previousRecord.ID.ToString());
                }
            }
            catch (Exception exe)
            {
                LogHelper.LogError(exe.ToString());
                return(string.Empty);
            }
        }