// 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";
}
}