// Save Teacher Details private void Save_Click(object sender, EventArgs e) { teacher.Name = teacher_name.Text; teacher.Contact = teacher_contact.Text; teacher.Email = teacher_email.Text; teacher.Availability_Time = AvailabilityTime(); db.Entry(teacher).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); new MsgBox("Deatils Saved"); }
// 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"); } }
// Add Teacher and user for login later private void Addbtn_Click(object sender, EventArgs e) { if (ValidateChildren()) { db = new AspireDB(); Teacher teacher = new Teacher(); teacher.Name = teacher_name.Text; teacher.Email = teacher_email.Text; teacher.Contact = teacher_contact.Text; User u = new User(); u.Email = teacher.Email; u.Password = "******"; u.Role = "T"; teacher.Availability_Time = AvailabilityTime(); db.Teachers.Add(teacher); db.Users.Add(u); db.SaveChanges(); teacher_contact.Text = ""; teacher_name.Text = ""; teacher_email.Text = ""; TeachersControl.Instance.CreateList(); TeachersControl.Instance.FooterMessage("Teacher Added"); } }
private void savebtn_Click(object sender, EventArgs e) { if (student_name.Text.ToString().Trim().Equals("")) { new MsgBox("Please enter Student Name!"); return; } if (student_studentID.Text.ToString().Trim().Equals("")) { new MsgBox("Please enter Student Id!"); return; } if (course_combo.Text.ToString().Trim().Equals("")) { new MsgBox("Please choose Course Name!"); return; } stud.Name = student_name.Text; stud.StudentID = student_studentID.Text; stud.Email = student_email.Text; stud.Course.Name = course_combo.Text; db.Entry(stud).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); StudentControl.Instance.FooterMessage("Student Saved"); StudentControl.Instance.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 updateRoombtn_Click(object sender, EventArgs e) { room.Name = name.Text; room.Capacity = capacity.Text; db.Entry(room).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); RoomsControl.Instance.CreateList(); RoomsControl.Instance.FooterMessage("Room Updated"); }
private void deletebtn_Click(object sender, EventArgs e) { db = new AspireDB(); Room x = db.Rooms.SingleOrDefault(Room => Room.RoomID == _rm.RoomID); db.Rooms.Remove(x); db.SaveChanges(); RoomsControl.Instance.FooterMessage("Room Deleted"); RoomsControl.Instance.CreateList(); }
private void updateBtn_Click(object sender, EventArgs e) { teacher.Name = teacher_name.Text; teacher.Contact = teacher_contact.Text; teacher.Email = teacher_email.Text; teacher.Availability_Time = AvailabilityTime(); db.Entry(teacher).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TeachersControl.Instance.CreateList(); TeachersControl.Instance.FooterMessage("Teacher Updated"); }
// Add Course Method private void addbtn_Click(object sender, EventArgs e) { if (subject_credits.Text.ToString().Trim().Equals("")) { new MsgBox("Please fill Course Credits!"); return; } if (subject_hours.Text.ToString().Trim().Equals("")) { new MsgBox("Please allocate hours for subject!"); return; } if (subject_name.Text.ToString().Trim().Equals("")) { new MsgBox("Please enter a name subject!"); return; } if (course_combo.Text.ToString().Trim().Equals("")) { new MsgBox("Please choose the course!"); return; } Subject s = new Subject(); s.Hour = subject_hours.Text; s.Credit = Convert.ToInt32(subject_credits.Text); s.Name = subject_name.Text; String[] cou = course_combo.Text.Split('-'); string cname = cou[0], clevel = cou[1]; Course cs = db.Courses.SingleOrDefault(Course => Course.Name == cname && Course.Level == clevel); s.Course = cs; db.Subjects.Add(s); db.SaveChanges(); message.Text = "Done"; subject_credits.Text = ""; subject_hours.Text = ""; subject_name.Text = ""; course_combo.SelectedIndex = 0; SubjectControl.Instance.CreateList(); SubjectControl.Instance.FooterMessage("Subject Added"); }
private void deletebtn_Click(object sender, EventArgs e) { db = new AspireDB(); Teacher x = db.Teachers.SingleOrDefault(Teacher => Teacher.TeacherID == _ts.TeacherID); User u = db.Users.SingleOrDefault(p => p.Email == x.Email); if (u != null) { db.Users.Remove(u); } db.Teachers.Remove(x); db.SaveChanges(); TeachersControl.Instance.FooterMessage("Teacher Deleted"); TeachersControl.Instance.CreateList(); }
private void savebtn_Click(object sender, EventArgs e) { if (subject_credits.Text.ToString().Trim().Equals("")) { new MsgBox("Please fill Course Credits!"); return; } if (subject_hours.Text.ToString().Trim().Equals("")) { new MsgBox("Please allocate hours for subject!"); return; } if (subject_name.Text.ToString().Trim().Equals("")) { new MsgBox("Please enter a name subject!"); return; } if (course_combo.Text.ToString().Trim().Equals("")) { new MsgBox("Please choose the course!"); return; } sub.Hour = subject_hours.Text; sub.Credit = Convert.ToInt32(subject_credits.Text); sub.Name = subject_name.Text; // parsing Concatinated coursename+level from combobox string[] cou = course_combo.Text.Split('-'); string name = cou[0], level = cou[1]; Course selected = db.Courses.SingleOrDefault(Course => Course.Name == name && Course.Level == level); sub.CourseID = selected.CourseID; db.Entry(sub).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); SubjectControl.Instance.FooterMessage("Subject Modified"); SubjectControl.Instance.CreateList(); }
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 Savebtn_Click(object sender, EventArgs e) { if (course_level.Text.ToString().Trim().Equals("")) { new MsgBox("Please choose Course Level!"); return; } if (course_name.Text.ToString().Trim().Equals("")) { new MsgBox("Please choose Course Name!"); return; } c.Level = course_level.Text; c.Name = course_name.Text; c.Nos = Convert.ToInt32(course_strength.Text); db.Entry(c).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); CourseControl.Instance.FooterMessage("Course Modified"); CourseControl.Instance.CreateList(); }
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"); } }
// Add Room method private void Addcoursebtn_Click(object sender, EventArgs e) { if (ValidateChildren()) { db = new AspireDB(); Room x = new Room(); Room rm = db.Rooms.SingleOrDefault(Room => Room.Name == name.Text.ToString() && Room.Capacity == capacity.Text.ToString()); if (rm != null) { new MsgBox("Duplicate Room Entry"); return; } x.Capacity = capacity.Text;; x.Name = name.Text; db.Rooms.Add(x); db.SaveChanges(); RoomsControl.Instance.CreateList(); RoomsControl.Instance.FooterMessage("Room Added"); name.Text = ""; capacity.Text = ""; message.Text = "Done"; } }