public SchoolViewModel(IDictionary <string, object> properties)
{
// Avoid problems with a null or empty collection.
StudentBody = new StudentBody();
StudentBody.Students.Add(new Student());
string uri = "http://xamarin.github.io/xamarin-forms-book-samples" +
"/SchoolOfFineArt/students.xml";
HttpWebRequest request = WebRequest.CreateHttp(uri);
request.BeginGetResponse((arg) =>
{
// Deserialize XML file.
Stream stream = request.EndGetResponse(arg).GetResponseStream();
StreamReader reader = new StreamReader(stream);
XmlSerializer xml = new XmlSerializer(typeof(StudentBody));
StudentBody = xml.Deserialize(reader) as StudentBody;
// Enumerate through all the students
foreach (Student student in StudentBody.Students)
{
// Set StudentBody property in each Student object.
student.StudentBody = StudentBody;
// Load possible Notes from properties dictionary
// (for program in Chapter 25).
if (properties != null && properties.ContainsKey(student.FullName))
{
student.Notes = (string)properties[student.FullName];
}
}
}, null);
// Adjust GradePointAverage randomly.
Device.StartTimer(TimeSpan.FromSeconds(0.1),
() =>
{
if (studentBody != null)
{
int index = rand.Next(studentBody.Students.Count);
Student student = studentBody.Students[index];
double factor = 1 + (rand.NextDouble() - 0.5) / 5;
student.GradePointAverage = Math.Round(
Math.Max(0, Math.Min(5, factor * student.GradePointAverage)), 2);
}
return(true);
});
}
public async Task <IActionResult> AddStudentToClass(string classId, [FromBody] StudentBody body)
{
return(await AddStudentToClass(classId, body.FirstName, body.LastName, await GenerateUniqueBarCode()));
}
public CollegeScorecardViewModel GetStudentBodyandCostData(int?id)
{
StudentBodyData studentbodydata = new StudentBodyData();
StudentBody studentbodyfromDB = new StudentBody();
CostAidEarningsData costaidearningsdata = new CostAidEarningsData();
CostAidEarnings costaidearningsfromDB = new CostAidEarnings();
CollegeScorecardViewModel collegescorecarddata = new CollegeScorecardViewModel();
string studentbodyandcostdata = "";
//Retrieving the list of colleges from Database
List <School> schoolslist = dbContext.Schools.ToList();
//Retrieving the studentbody data from Database for the selected college
studentbodyfromDB = dbContext.StudentBody.Where(s => s.id == id).FirstOrDefault();
//Retrieving the studentbody data from Database for the selected college
costaidearningsfromDB = dbContext.CostAidEarnings.Where(s => s.id == id).FirstOrDefault();
//check if the count is 0 (no data available in database), then call the API
if (schoolslist.Count == 0)
{
Schools schoolsdata = GetSchoolsDatafromAPI();
foreach (School school in schoolsdata.results)
{
schoolslist.Add(school);
}
}
//check if the studentbodyfromDB or costaidearningsfromDB is null (no data available in database), then call the API
if (studentbodyfromDB == null || costaidearningsfromDB == null)
{
APIHandler webHandler = new APIHandler();
studentbodyandcostdata = webHandler.GetStudentBodyandCostDataAPI(id);
var settings = new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Include,
MissingMemberHandling = MissingMemberHandling.Ignore
};
if (!studentbodyandcostdata.Equals(""))
{
// JsonConvert is part of the NewtonSoft.Json Nuget package
studentbodydata = JsonConvert.DeserializeObject <StudentBodyData>(studentbodyandcostdata, settings);
costaidearningsdata = JsonConvert.DeserializeObject <CostAidEarningsData>(studentbodyandcostdata, settings);
}
foreach (StudentBody studentbody in studentbodydata.results)
{
//Database will give PK constraint violation error when trying to insert record with existing PK.
//So add company only if it doesnt exist, check existence using symbol (PK)
if (dbContext.StudentBody.Where(c => c.id.Equals(studentbody.id)).Count() == 0)
{
dbContext.StudentBody.Add(studentbody);
}
collegescorecarddata.StudentBody = studentbody;
}
foreach (CostAidEarnings costaidearnings in costaidearningsdata.results)
{
//Database will give PK constraint violation error when trying to insert record with existing PK.
//So add company only if it doesnt exist, check existence using symbol (PK)
if (dbContext.CostAidEarnings.Where(c => c.id.Equals(costaidearnings.id)).Count() == 0)
{
dbContext.CostAidEarnings.Add(costaidearnings);
}
collegescorecarddata.CostAidEarnings = costaidearnings;
}
dbContext.SaveChanges();
collegescorecarddata.SchoolsList = schoolslist;
}
//check if the data in the DB is older than 30 days?, then call the API
else if (studentbodyfromDB != null && costaidearningsfromDB != null)
{
// Checking the last saved data time for studentbody and costaidrearnings records
int studentbodylastSaveddataTime = (DateTime.Now.Date - studentbodyfromDB.CreatedOn.Date).Days;
int costaidearningslastSaveddataTime = (DateTime.Now.Date - costaidearningsfromDB.CreatedOn.Date).Days;
if (studentbodylastSaveddataTime > 30 || costaidearningslastSaveddataTime > 30)
{
APIHandler webHandler = new APIHandler();
studentbodyandcostdata = webHandler.GetStudentBodyandCostDataAPI(id);
var settings = new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Include,
MissingMemberHandling = MissingMemberHandling.Ignore
};
if (!studentbodyandcostdata.Equals(""))
{
// JsonConvert is part of the NewtonSoft.Json Nuget package
studentbodydata = JsonConvert.DeserializeObject <StudentBodyData>(studentbodyandcostdata, settings);
costaidearningsdata = JsonConvert.DeserializeObject <CostAidEarningsData>(studentbodyandcostdata, settings);
}
foreach (StudentBody studentbody in studentbodydata.results)
{
//Database will give PK constraint violation error when trying to insert record with existing PK.
//So add company only if it doesnt exist, check existence using symbol (PK)
if (dbContext.StudentBody.Where(c => c.id.Equals(studentbody.id)).Count() == 0)
{
dbContext.StudentBody.Add(studentbody);
}
// Update the existing DB record with the latest data from API
else
{
studentbodyfromDB.CreatedOn = DateTime.Now;
studentbodyfromDB.latestadmissionsadmission_rateoverall = studentbody.latestadmissionsadmission_rateoverall;
studentbodyfromDB.latestcompletioncompletion_rate_4yr_150nt = studentbody.latestcompletioncompletion_rate_4yr_150nt;
studentbodyfromDB.lateststudentdemographicsfemale_share = studentbody.lateststudentdemographicsfemale_share;
studentbodyfromDB.lateststudentgrad_students = studentbody.lateststudentgrad_students;
studentbodyfromDB.lateststudentpart_time_share = studentbody.lateststudentpart_time_share;
studentbodyfromDB.lateststudentretention_ratefour_yearfull_time = studentbody.lateststudentretention_ratefour_yearfull_time;
studentbodyfromDB.lateststudentsize = studentbody.lateststudentsize;
dbContext.Entry(studentbodyfromDB).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
collegescorecarddata.StudentBody = studentbody;
}
foreach (CostAidEarnings costaidearnings in costaidearningsdata.results)
{
//Database will give PK constraint violation error when trying to insert record with existing PK.
//So add company only if it doesnt exist, check existence using symbol (PK)
if (dbContext.CostAidEarnings.Where(c => c.id.Equals(costaidearnings.id)).Count() == 0)
{
dbContext.CostAidEarnings.Add(costaidearnings);
}
// Update the existing DB record with the latest data from API
else
{
costaidearningsfromDB.CreatedOn = DateTime.Now;
costaidearningsfromDB.latestaidfederal_loan_rate = costaidearnings.latestaidfederal_loan_rate;
costaidearningsfromDB.latestaidmedian_debtcompletersoverall = costaidearnings.latestaidmedian_debtcompletersoverall;
costaidearningsfromDB.latestaidpell_grant_rate = costaidearnings.latestaidpell_grant_rate;
costaidearningsfromDB.latestcostavg_net_pricepublic = costaidearnings.latestcostavg_net_pricepublic;
costaidearningsfromDB.latestcosttuitionin_state = costaidearnings.latestcosttuitionin_state;
costaidearningsfromDB.latestcosttuitionout_of_state = costaidearnings.latestcosttuitionout_of_state;
costaidearningsfromDB.latestearnings10_yrs_after_entrymedian = costaidearnings.latestearnings10_yrs_after_entrymedian;
}
collegescorecarddata.CostAidEarnings = costaidearnings;
}
dbContext.SaveChanges();
collegescorecarddata.SchoolsList = schoolslist;
}
else
{
collegescorecarddata.SchoolsList = schoolslist;
collegescorecarddata.StudentBody = studentbodyfromDB;
collegescorecarddata.CostAidEarnings = costaidearningsfromDB;
}
}
return(collegescorecarddata);
}
