// Add Course Module private void Addcoursebtn_Click(object sender, EventArgs e) { if (ValidateChildren()) { AspireDB db = new AspireDB(); Course cs = new Course(); byte[] hash = HelpMe.Md5toBinary(course_name.Text.ToString()); Course got = db.Courses.SingleOrDefault(Course => Course.CourseID == hash); if (got != null) { new MsgBox("Duplicate entry"); return; } cs.Name = course_name.Text.ToString(); cs.CourseID = hash; cs.Level = course_level.Text; cs.Nos = Convert.ToInt32(course_strength.Text); db.Courses.Add(cs); db.SaveChanges(); message.Text = "Done"; course_strength.Text = ""; course_name.Text = ""; course_level.Text = ""; CourseControl.Instance.CreateList(); CourseControl.Instance.FooterMessage("Course Added"); } }
private void filter_combo_SelectedIndexChanged(object sender, EventArgs e) { string item = filter_combo.Text; if (!item.Trim().Equals("")) { if (item.Trim().ToLower().Equals("all")) { CreateList(); } else { string[] parsed = item.Split('-'); string name = parsed[0]; string level = HelpMe.GetFullForm(parsed[1]); AspireDB db = new AspireDB(); Course c = db.Courses.SingleOrDefault(Course => Course.Name == name && Course.Level == level); CreateList(c); } } else { CreateList(); } }
// Add Students private void addstudentbtn_Click(object sender, EventArgs e) { if (ValidateChildren()) { byte[] hash = HelpMe.Md5toBinary(course_name.Text.ToString()); Course cou = db.Courses.SingleOrDefault(Course => Course.CourseID == hash); List <Student> sd = db.Students.ToList(); int count = 0; foreach (Student ed in studs) { ed.Course = cou; bool skip = false; foreach (Student d in sd) { if (ed.StudentID == d.StudentID) { skip = true; break; } } if (!skip) { db.Students.Add(ed); count++; } } db.SaveChanges(); message.Text = "Done"; StudentControl.Instance.CreateList(); StudentControl.Instance.FooterMessage(count + " Records Added"); } }
private void saveimgbtn_Click(object sender, EventArgs e) { AspireDB db = new AspireDB(); db.Configuration.ProxyCreationEnabled = false; List<Course> cour = db.Courses.ToList<Course>(); String str = HelpMe.GetJson(cour); Console.Write(str); HelpMe.SaveFileNow(str, "courses"); }
public AddStudent() { InitializeComponent(); db = new AspireDB(); List <Course> cs = db.Courses.ToList <Course>(); foreach (Course c in cs) { course_combo.Items.Add(c.Name + "-" + HelpMe.GetInitials(c.Level, "")); } }
public void FilterBoxUpdate() { AspireDB db = new AspireDB(); List <Course> cs = db.Courses.ToList <Course>(); filter_combo.Items.Add("All"); foreach (Course c in cs) { filter_combo.Items.Add(c.Name + "-" + HelpMe.GetInitials(c.Level, "")); } }
private void saveimgbtn_Click(object sender, EventArgs e) { AspireDB db = new AspireDB(); db.Configuration.ProxyCreationEnabled = false; List <Subject> sub = db.Subjects.ToList <Subject>(); // Create JSON String String str = HelpMe.GetJson(sub); // Save in file with extension HelpMe.SaveFileNow(str, "subject"); }
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); }
// Add student method private void addbtn_Click(object sender, EventArgs e) { if (ValidateChildren()) { Student stud = new Student(); stud.Name = student_name.Text; stud.StudentID = student_studentID.Text; stud.Email = student_email.Text; string toparse = course_combo.Text; string[] strs = toparse.Split('-'); string cname = strs[0], clevel = HelpMe.GetFullForm(strs[1]); Course fc = db.Courses.SingleOrDefault(Course => Course.Name == cname && Course.Level == clevel); stud.Course = fc; db.Students.Add(stud); db.SaveChanges(); student_email.Text = ""; student_name.Text = ""; student_studentID.Text = ""; StudentControl.Instance.CreateList(); StudentControl.Instance.FooterMessage("Student Added"); } }