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