// On Login Click
private void metroButton1_Click(object sender, EventArgs e)
{
if (ValidateChildren())
{
string user = username.Text.ToString().Trim().ToLower();
string pass = password.Text.ToString().Trim().ToLower();
// Check if Admin
if (user == "admin" && pass == "admin")
{
Hide();
new Ntecc().ShowDialog();
Show();
}
else
{
// Check if user exist and is teacher
AspireDB db = new AspireDB();
User u = db.Users.SingleOrDefault(x => x.Email == user && x.Password == pass);
if (u != null)
{
Teacher t = db.Teachers.SingleOrDefault(x => x.Email == u.Email);
Hide();
new TeacherHome(t).ShowDialog();
Show();
}
else
{
new MsgBox("User Does not Exsist");
}
}
}
}
public TeacherHome(Teacher tea)
{
// Initialize Teacher view from Teacher object
InitializeComponent();
db = new AspireDB();
teacher_name.Text = tea.Name.ToString();
teacher_contact.Text = tea.Contact.ToString();
teacher_email.Text = tea.Email.ToString();
user = db.Users.SingleOrDefault(x => x.Email == tea.Email);
mon_f.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[0].ToString()));
mon_s.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[1].ToString()));
tues_f.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[2].ToString()));
tues_s.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[3].ToString()));
wed_f.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[4].ToString()));
wed_s.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[5].ToString()));
thur_f.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[6].ToString()));
thur_s.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[7].ToString()));
fri_f.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[8].ToString()));
fri_s.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[9].ToString()));
sat_f.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[10].ToString()));
sat_s.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[11].ToString()));
sun_f.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[12].ToString()));
sun_s.Checked = Convert.ToBoolean(int.Parse(tea.Availability_Time[13].ToString()));
teacher = db.Teachers.SingleOrDefault(Teacher => Teacher.TeacherID == tea.TeacherID);
}
// 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");
}
}
public void CreateList()
{
string lvl = LevelChoser.GetItemText(LevelChoser.SelectedItem);
if (lvl.Equals("All"))
{
if (courses_layout.Controls.Count > 0)
{
courses_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List <Course> clist = db.Courses.ToList();
foreach (Course c in clist)
{
CoursesView cv = new CoursesView(c);
courses_layout.Controls.Add(cv);
}
db.Database.Connection.Close();
}
else
{
if (courses_layout.Controls.Count > 0)
{
courses_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List <Course> clist = db.Courses.Where(x => x.Level == lvl).ToList();
foreach (Course c in clist)
{
CoursesView cv = new CoursesView(c);
courses_layout.Controls.Add(cv);
}
db.Database.Connection.Close();
}
}
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 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");
}
}
public EditSubject(Subject s)
{
InitializeComponent();
db = new AspireDB();
subject_credits.Text = s.Credit.ToString();
subject_hours.Text = s.Hour;
subject_name.Text = s.Name;
sub = db.Subjects.SingleOrDefault(Subject => Subject.SubjectID == s.SubjectID && Subject.Name == s.Name);
//1 Populating Combo box
//2 then selecting the already chosen course
List <Course> css = db.Courses.ToList();
int count = 0, si = 0;
foreach (Course c in css)
{
course_combo.Items.Add(c.Name + "-" + c.Level);
if (s.CourseID == c.CourseID)
{
si = count;
}
count++;
}
course_combo.SelectedIndex = si;
}
public EditRoom(Room rm)
{
InitializeComponent();
db = new AspireDB();
name.Text = rm.Name.ToString();
capacity.Text = rm.Capacity.ToString();
room = db.Rooms.SingleOrDefault(Room => Room.RoomID == rm.RoomID);
}
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 EditCourse(Course cs)
{
InitializeComponent();
db = new AspireDB();
c = db.Courses.SingleOrDefault(Course => Course.CourseID == cs.CourseID && Course.Name == cs.Name && Course.Level == cs.Level);
course_level.Text = c.Level;
course_name.Text = c.Name;
course_strength.Text = c.Nos.ToString();
}
public AddCourse()
{
InitializeComponent();
AspireDB db = new AspireDB();
foreach (Level l in db.Levels.ToList())
{
course_level.Items.Add(l.LevelName);
}
}
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();
}
public AddSubject()
{
InitializeComponent();
db = new AspireDB();
List <Course> css = db.Courses.ToList();
foreach (Course c in css)
{
course_combo.Items.Add(c.Name + "-" + 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, ""));
}
}
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 EditCourse(Course cs)
{
InitializeComponent();
db = new AspireDB();
foreach (Level l in db.Levels.ToList())
{
course_level.Items.Add(l.LevelName);
}
c = db.Courses.SingleOrDefault(Course => Course.CourseID == cs.CourseID && Course.Name == cs.Name && Course.Level == cs.Level);
course_level.Text = c.Level;
course_name.Text = c.Name;
course_strength.Text = c.Nos.ToString();
}
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");
}
public void CreateList()
{
if(courses_layout.Controls.Count>0)
{
courses_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List<Course> clist = db.Courses.ToList();
foreach (Course c in clist)
{
CoursesView cv = new CoursesView(c);
courses_layout.Controls.Add(cv);
}
db.Database.Connection.Close();
}
public CourseControl()
{
InitializeComponent();
LevelChoser.Items.Add("All");
AspireDB db = new AspireDB();
foreach (Level l in db.Levels.ToList())
{
LevelChoser.Items.Add(l.LevelName);
}
LevelChoser.SelectedIndex = 0;
CreateList();
}
public void CreateList(Course c)
{
if (subject_layout.Controls.Count > 0)
{
subject_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List <Subject> slist = db.Subjects.Where(Subject => Subject.CourseID == c.CourseID).ToList <Subject>();
foreach (Subject s in slist)
{
SubjectsView cv = new SubjectsView(s);
subject_layout.Controls.Add(cv);
}
db.Database.Connection.Close();
}
public void CreateList()
{
if (subject_layout.Controls.Count > 0)
{
subject_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List <Subject> slist = db.Subjects.ToList();
foreach (Subject c in slist)
{
SubjectsView cv = new SubjectsView(c);
subject_layout.Controls.Add(cv);
}
db.Database.Connection.Close();
}
public void CreateList()
{
if (teacher_layout.Controls.Count > 0)
{
teacher_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List <Teacher> tlist = db.Teachers.ToList();
foreach (Teacher t in tlist)
{
TeacherView tv = new TeacherView(t);
teacher_layout.Controls.Add(tv);
}
db.Database.Connection.Close();
}
public void CreateList()
{
if (rooms_layout.Controls.Count > 0)
{
rooms_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List <Room> tlist = db.Rooms.ToList();
foreach (Room r in tlist)
{
RoomView tv = new RoomView(r);
rooms_layout.Controls.Add(tv);
}
db.Database.Connection.Close();
}
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();
}
public void CreateList()
{
if (student_layout.Controls.Count > 0)
{
student_layout.Controls.Clear();
}
AspireDB db = new AspireDB();
List <Student> stulist = db.Students.ToList();
foreach (Student s in stulist)
{
StudentsView sv = new StudentsView(s);
student_layout.Controls.Add(sv);
}
db.Database.Connection.Close();
}
public BatchAddStudent()
{
InitializeComponent();
db = new AspireDB();
course_name.Items.Clear();
List <Course> css = db.Courses.ToList();
foreach (Course s in css)
{
course_name.Items.Add(s.Name);
}
course_level.Items.Clear();
foreach (string s in HelpMe.levels)
{
course_level.Items.Add(s);
}
LoadClipboard();
}
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);
}
public EditStudent(Student s)
{
InitializeComponent();
db = new AspireDB();
stud = db.Students.SingleOrDefault(Student => Student.ID == s.ID);
student_name.Text = s.Name;
student_studentID.Text = s.StudentID;
student_email.Text = s.Email;
List <Course> courses_list = db.Courses.ToList <Course>();
int count = 0, si = 0;
foreach (Course c in courses_list)
{
course_combo.Items.Add(c.Name);
if (c.Name.Equals(s.Course.Name))
{
si = count;
}
count++;
}
course_combo.SelectedIndex = si;
}
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 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";
}
}