public static async void SaveOrphan(Orphan inOrphan)
{
try
{
// Replace this with the API code.
using (var context = new SMSContext())
{
var updatedOrphan = context.Orphans.Single(c => c.OrphanID == inOrphan.OrphanID);
updatedOrphan.OrphanID = inOrphan.OrphanID;
updatedOrphan.FirstName = inOrphan.FirstName;
updatedOrphan.LastName = inOrphan.LastName;
updatedOrphan.MiddleName = inOrphan.MiddleName;
updatedOrphan.FullName = inOrphan.FullName;
if (inOrphan.GuardianID != 0)
{
updatedOrphan.GuardianID = inOrphan.GuardianID;
}
updatedOrphan.LCMStatus = inOrphan.LCMStatus;
updatedOrphan.ProfileNumber = inOrphan.ProfileNumber;
updatedOrphan.Gender = inOrphan.Gender;
updatedOrphan.EntryDate = inOrphan.EntryDate;
updatedOrphan.DateOfBirth = inOrphan.DateOfBirth;
context.Orphans.Update(updatedOrphan);
await context.SaveChangesAsync();
}
}
catch (Exception eSql)
{
// Your code may benefit from more robust error handling or logging.
// This logging is just a reminder that you should handle exceptions when connecting to remote data.
System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}");
}
}
public static async void SaveAcademic(int orphanID, Academic inAcademic)
{
try
{
// Replace this with the API code.
using (var context = new SMSContext())
{
var updatedAcademic = context.Academics.Single(c => c.AcademicID == inAcademic.AcademicID);
updatedAcademic.AcademicID = inAcademic.AcademicID;
updatedAcademic.OrphanID = orphanID;
updatedAcademic.EntryDate = inAcademic.EntryDate;
updatedAcademic.Grade = inAcademic.Grade;
updatedAcademic.School = inAcademic.School;
updatedAcademic.KCPE = inAcademic.KCPE;
updatedAcademic.KCSE = inAcademic.KCSE;
context.Academics.Update(updatedAcademic);
await context.SaveChangesAsync();
}
}
catch (Exception eSql)
{
// Your code may benefit from more robust error handling or logging.
// This logging is just a reminder that you should handle exceptions when connecting to remote data.
System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}");
}
}
public static async void SaveNarration(int orphanID, Narration inNarration)
{
try
{
// Replace this with the API code.
using (var context = new SMSContext())
{
var updatedNarration = context.Narrations.Single(c => c.NarrationID == inNarration.NarrationID);
updatedNarration.NarrationID = inNarration.NarrationID;
updatedNarration.OrphanID = orphanID;
updatedNarration.EntryDate = inNarration.EntryDate;
updatedNarration.Subject = inNarration.Subject;
updatedNarration.Note = inNarration.Note;
context.Narrations.Update(updatedNarration);
await context.SaveChangesAsync();
}
}
catch (Exception eSql)
{
// Your code may benefit from more robust error handling or logging.
// This logging is just a reminder that you should handle exceptions when connecting to remote data.
System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}");
}
}
public static async void AddOrphan(Orphan inOrphan)
{
try
{
// Replace this with the API code.
using (var context = new SMSContext())
{
context.Orphans.Add(inOrphan);
await context.SaveChangesAsync();
}
}
catch (Exception eSql)
{
// Your code may benefit from more robust error handling or logging.
// This logging is just a reminder that you should handle exceptions when connecting to remote data.
System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}");
}
}
public static async void DeleteAcademic(Academic inAcademic)
{
try
{
// Replace with API code
using (var context = new SMSContext())
{
context.Academics.Remove(inAcademic);
await context.SaveChangesAsync();
}
}
catch (Exception eSql)
{
// Your code may benefit from more robust error handling or logging.
// This logging is just a reminder that you should handle exceptions when connecting to remote data.
System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}");
}
}
public static async void DeleteGuardian(Guardian inGuardian)
{
//TODO: If you delete a Guardian that has an Orphan, you will need to make sure the Orphan's
// Guardian entry is nulled out.
try
{
// Replace with API code
using (var context = new SMSContext())
{
context.Guardians.Remove(inGuardian);
await context.SaveChangesAsync();
}
}
catch (Exception eSql)
{
// Your code may benefit from more robust error handling or logging.
// This logging is just a reminder that you should handle exceptions when connecting to remote data.
System.Diagnostics.Debug.WriteLine($"Exception: {eSql.Message} {eSql.InnerException?.Message}");
}
}
