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