private void loadimgbtn_Click(object sender, EventArgs e)
{
// Opens File and match extension -> If Extension do not match it shows msg
string json = HelpMe.OpenFileNow("courses");
// Load Data from Json File Opened
List <Course> css = HelpMe.GetDataFromJson <Course>(json);
AspireDB db = new AspireDB();
db.Courses.SqlQuery(" DBCC CHECKIDENT('Course', RESEED, 0)");
int count = 0;
foreach (Course s in css)
{
// Check for Exsisting Subjects
if (db.Courses.Count(Course => Course.Name == s.Name && Course.Level == s.Level) <= 0)
{
db.Courses.Add(s);
count++;
}
}
string msg;
try
{
db.SaveChanges();
msg = "File Loaded ( " + count + " Rows Added )";
}
catch (Exception ee)
{
count = 0;
msg = "File Not Loaded";
new MsgBox("Invalid File");
MessageBox.Show(ee.Message);
}
//Update list and Show Footer Message
CourseControl.Instance.CreateList();
CourseControl.Instance.FooterMessage(msg);
}
private void loadimgbtn_Click(object sender, EventArgs e)
{
// Opens File and match extension -> If Extension do not match it shows msg
string json = HelpMe.OpenFileNow("subject");
// Load Data from Json File Opened
List <Subject> sub = HelpMe.GetDataFromJson <Subject>(json);
AspireDB db = new AspireDB();
int count = 0;
foreach (Subject s in sub)
{
// Check for Exsisting Subjects
if (db.Subjects.Count(Subject => Subject.Name == s.Name && Subject.CourseID == s.CourseID) <= 0)
{
db.Subjects.Add(s);
count++;
}
}
string msg;
try {
db.SaveChanges();
msg = "File Loaded ( " + count + " Rows Added )";
}
catch
{
count = 0;
msg = "File Not Loaded, Please Make Sure Courses Exsists";
new MsgBox("Invalid File or Courses Missing!");
}
//Update list and Show Footer Message
SubjectControl.Instance.CreateList();
SubjectControl.Instance.FooterMessage(msg);
}
