private void button1_Click(object sender, EventArgs e) { if (!ValidateForEmptiness(textBox2.Text)) { MessageBox.Show("Unit Code is Required"); } else if (!ValidateForEmptiness(textBox3.Text)) { MessageBox.Show("Unit Title is Required"); } else if (!ValidateCombobox(comboBox1)) { MessageBox.Show("Essential is Required"); } else { int uId = Convert.ToInt32(textBox1.Text); model.unitId = uId; model.unitCode = textBox2.Text; model.unitTitle = textBox3.Text; model.essential = comboBox1.Text.Trim(); using (tafesystemEntities tf = new tafesystemEntities()) { tf.units.Add(model); tf.SaveChanges(); } ClearFields(); MessageBox.Show("Data submitted successsfully"); PopulateGridView(); } }
//this will update the enrollemnt enrties private void button7_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int eId = Convert.ToInt32(textBox8.Text); var update2 = tf.enrollments.First(a => a.enrollmentId == eId); update2.coursename = comboBox10.Text; update2.semestername = comboBox9.Text; update2.locationname = comboBox2.Text; update2.mode = comboBox3.Text; update2.status = comboBox6.Text; update2.fee = comboBox4.Text; update2.result = comboBox5.Text; int studId = Convert.ToInt32(textBox9.Text); update2.studentId = studId; int courId = Convert.ToInt32(textBox10.Text); update2.courseId = courId; int locId = Convert.ToInt32(textBox11.Text); update2.locationId = locId; tf.SaveChanges(); } MessageBox.Show("Record Updated sucessfully"); PopulateGridView2(); ClearFields2(); }
//user can add a semester private void button1_Click(object sender, EventArgs e) { if (!ValidateCombobox(comboBox1)) { MessageBox.Show("Semester Name is Required"); } else { int csId = Convert.ToInt32(textBox1.Text); model.semesterId = csId; model.semestername = comboBox1.Text; using (tafesystemEntities tf = new tafesystemEntities()) { tf.coursesemesters.Add(model); tf.SaveChanges(); } ClearFields(); MessageBox.Show("Data submitted successsfully"); PopulateGridView(); } }
//this will save the enetered data into the system private void button6_Click(object sender, EventArgs e) { int eId = Convert.ToInt32(textBox8.Text); model1.enrollmentId = eId; model1.coursename = comboBox10.Text.Trim(); model1.semestername = comboBox9.Text.Trim(); model1.locationname = comboBox2.Text.Trim(); model1.mode = comboBox3.Text.Trim(); model1.status = comboBox6.Text.Trim(); model1.fee = comboBox4.Text.Trim(); model1.result = comboBox5.Text.Trim(); int studId = Convert.ToInt32(textBox9.Text); model1.studentId = studId; int courId = Convert.ToInt32(textBox10.Text); model1.courseId = courId; int locId = Convert.ToInt32(textBox11.Text); model1.locationId = locId; using (tafesystemEntities tf = new tafesystemEntities()) { tf.enrollments.Add(model1); tf.SaveChanges(); } ClearFields2(); MessageBox.Show("Data submitted successsfully"); PopulateGridView2(); }
private void button1_Click(object sender, EventArgs e) { if (!ValidateCombobox(comboBox1)) { MessageBox.Show("Enter Amount of Paid fee"); } else if (!ValidateForEmptiness(textBox2.Text)) { MessageBox.Show("Student ID is Required"); } else { int fId = Convert.ToInt32(textBox1.Text); model3.feeId = fId; model3.paidfee = comboBox1.Text; int stuId = Convert.ToInt32(textBox2.Text); model3.studentId = stuId; using (tafesystemEntities tf = new tafesystemEntities()) { tf.fees.Add(model3); tf.SaveChanges(); } MessageBox.Show("Payment made successsfully"); PopulateGridView(); } }
//add a recrod private void button10_Click(object sender, EventArgs e) { int tcId = Convert.ToInt32(textBox8.Text); model5.teachercourseId = tcId; model5.coursename = comboBox11.Text; model5.clustername = comboBox2.Text; model5.semestername = comboBox12.Text; model5.locationname = comboBox8.Text; model5.mode = comboBox3.Text; model5.status = comboBox4.Text; int tId = Convert.ToInt32(textBox9.Text); model5.teacherId = tId; int cId = Convert.ToInt32(textBox10.Text); model5.courseId = cId; using (tafesystemEntities tf = new tafesystemEntities()) { tf.teachercourses.Add(model5); tf.SaveChanges(); } MessageBox.Show("Data submitted successsfully"); PopulateGridView2(); ClearFields2(); }
//admin can add the cluster infromation in the system private void button1_Click(object sender, EventArgs e) { if (!ValidateForEmptiness(textBox2.Text)) { MessageBox.Show("Enter Cluster Name"); } if (!ValidateForEmptiness(textBox3.Text)) { MessageBox.Show("Enter Teacher ID"); } else { int clId = Convert.ToInt32(textBox1.Text); model.clusterId = clId; model.clustername = textBox2.Text; int tId = Convert.ToInt32(textBox3.Text); model.teacherId = tId; using (tafesystemEntities tf = new tafesystemEntities()) { tf.clusters.Add(model); tf.SaveChanges(); } ClearFields(); MessageBox.Show("Data submitted successsfully"); PopulateGridView(); } }
//user can update the location info private void button2_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int clId = Convert.ToInt32(textBox1.Text); var update = tf.courselocations.First(a => a.locationId == clId); update.locationname = textBox2.Text; tf.SaveChanges(); } MessageBox.Show("Record Updated sucessfully"); PopulateGridView(); ClearFields(); }
private void button3_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int fId = Convert.ToInt32(textBox1.Text); var update2 = tf.fees.First(a => a.feeId == fId); update2.paidfee = comboBox1.Text; int studId = Convert.ToInt32(textBox2.Text); tf.SaveChanges(); } MessageBox.Show("Record Updated sucessfully"); PopulateGridView(); ClearField(); }
private void button2_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int uId = Convert.ToInt32(textBox1.Text); var update = tf.units.First(a => a.unitId == uId); update.unitCode = textBox2.Text; update.unitTitle = textBox3.Text; update.essential = comboBox1.Text; tf.SaveChanges(); } MessageBox.Show("Record Updated sucessfully"); PopulateGridView(); ClearFields(); }
//user can add a location private void button1_Click(object sender, EventArgs e) { int clId = Convert.ToInt32(textBox1.Text); model.locationId = clId; model.locationname = textBox2.Text; using (tafesystemEntities tf = new tafesystemEntities()) { tf.courselocations.Add(model); tf.SaveChanges(); } ClearFields(); MessageBox.Show("Data submitted successsfully"); PopulateGridView(); }
//dele a signin info private void button11_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure to delete this record", "Message box", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (tafesystemEntities tf = new tafesystemEntities()) { var entry = tf.Entry(model2); if (entry.State == System.Data.Entity.EntityState.Detached) { tf.tusers.Attach(model2); } tf.tusers.Remove(model2); tf.SaveChanges(); PopulateGridView3(); ClearFields3(); MessageBox.Show("Deleted Sucessfully"); } } }
//login updation private void button13_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int uId = Convert.ToInt32(textBox14.Text); var update1 = tf.tusers.First(a => a.userId == uId); update1.username = textBox13.Text; update1.password = textBox12.Text; update1.userType = comboBox5.Text; int teacId = Convert.ToInt32(textBox11.Text); tf.SaveChanges(); } MessageBox.Show("Signin Updated sucessfully"); PopulateGridView3(); ClearFields3(); }
private void button5_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int uId = Convert.ToInt32(textBox3.Text); var update = tf.susers.First(a => a.userId == uId); update.username = textBox4.Text; update.password = textBox5.Text; update.userType = comboBox2.Text; int studId = Convert.ToInt32(textBox6.Text); update.studentId = studId; tf.SaveChanges(); } MessageBox.Show("SignUp Updated sucessfully"); PopulateGridView2(); ClearField2(); }
//update the record private void button3_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int tId = Convert.ToInt32(textBox2.Text); var update = tf.teachers.First(a => a.teacherId == tId); update.firstname = textBox4.Text; update.middlename = textBox1.Text; update.lastname = textBox3.Text; update.dob = dateTimePicker1.Value.Date; update.gender = comboBox1.Text; update.email = textBox6.Text; update.address = textBox7.Text; update.phone = textBox5.Text; tf.SaveChanges(); } MessageBox.Show("Record Updated sucessfully"); PopulateGridView(); ClearFields(); }
//update a record private void button8_Click(object sender, EventArgs e) { using (tafesystemEntities tf = new tafesystemEntities()) { int tcourId = Convert.ToInt32(textBox8.Text); var update2 = tf.teachercourses.First(a => a.teachercourseId == tcourId); update2.coursename = comboBox11.Text; update2.clustername = comboBox2.Text; update2.semestername = comboBox12.Text; update2.locationname = comboBox8.Text; update2.mode = comboBox3.Text; update2.status = comboBox4.Text; int teachId = Convert.ToInt32(textBox9.Text); update2.teacherId = teachId; int corId = Convert.ToInt32(textBox10.Text); update2.courseId = corId; tf.SaveChanges(); } MessageBox.Show("Record Updated sucessfully"); PopulateGridView2(); ClearFields2(); }
private void button4_Click(object sender, EventArgs e) { if (!ValidateForEmptiness(textBox4.Text)) { MessageBox.Show("Username is Required"); } else if (!ValidateForEmptiness(textBox5.Text)) { MessageBox.Show("Password is Required"); } else if (!ValidateCombobox(comboBox2)) { MessageBox.Show("User Type is Required"); } else if (!ValidateForEmptiness(textBox6.Text)) { MessageBox.Show("Student ID is Required"); } int uId = Convert.ToInt32(textBox3.Text); model4.userId = uId; model4.username = textBox4.Text; model4.password = textBox5.Text; model4.userType = comboBox2.Text; int stuId = Convert.ToInt32(textBox6.Text); model4.studentId = stuId; using (tafesystemEntities tf = new tafesystemEntities()) { tf.susers.Add(model4); tf.SaveChanges(); } MessageBox.Show("SignUp successsful"); PopulateGridView2(); ClearField2(); }
//Teachers can edit their perosnal details from here private void button2_Click(object sender, EventArgs e) { using (var Context = new tafesystemEntities()) { var Record = (from t in Context.teachers where t.teacherId == teacherId select t).FirstOrDefault(); if (Record != null) { Record.address = textBox6.Text; Record.phone = textBox7.Text; Record.email = textBox5.Text; Context.SaveChanges(); MessageBox.Show("Updated Successfully"); TeacherPersonalDetails(); } else { MessageBox.Show("Error in Updating Details Try again later!"); } } }
//login for teacher private void button14_Click(object sender, EventArgs e) { int uId = Convert.ToInt32(textBox14.Text); model2.userId = uId; model2.username = textBox13.Text; model2.password = textBox12.Text; model2.userType = comboBox5.Text; int teacId = Convert.ToInt32(textBox11.Text); model2.teacherId = teacId; using (tafesystemEntities tf = new tafesystemEntities()) { tf.tusers.Add(model2); tf.SaveChanges(); } MessageBox.Show("SignUp successsful"); PopulateGridView3(); ClearFields3(); }
//from here user can add a course in the system private void button1_Click(object sender, EventArgs e) { //perform validation on the entered data if (!ValidateCombobox(comboBox1)) { MessageBox.Show("Course Name is Required"); } else if (!ValidateCombobox(comboBox2)) { MessageBox.Show("Course Mode is Required"); } else if (!ValidateCombobox(comboBox3)) { MessageBox.Show("Course Fee is Required"); } else { int cId = Convert.ToInt32(textBox1.Text); model.courseId = cId; model.coursename = comboBox1.Text; model.mode = comboBox2.Text; model.fee = comboBox3.Text.Trim(); using (tafesystemEntities tf = new tafesystemEntities()) { tf.courses.Add(model); tf.SaveChanges(); } ClearFields(); MessageBox.Show("Data submitted successsfully"); PopulateGridView(); } }
//add the teacher info private void button1_Click(object sender, EventArgs e) { if (!ValidateForEmptiness(textBox4.Text)) { MessageBox.Show("First Name is required"); } else if (!ValidateForEmptiness(textBox1.Text)) { MessageBox.Show("Middle Name is required"); } else if (!ValidateForEmptiness(textBox3.Text)) { MessageBox.Show("Last Name is required"); } else if (!ValidateCombobox(comboBox1)) { MessageBox.Show("Gender is Required"); } else if (!ValidateForEmptiness(textBox6.Text)) { MessageBox.Show(" Email is required"); } else if (!ValidEmail(textBox6.Text)) { MessageBox.Show("Enter email correctly"); } else if (!ValidateForEmptiness(textBox5.Text)) { MessageBox.Show(" Address is required"); } else if (!ValidateForEmptiness(textBox7.Text)) { MessageBox.Show(" Phone Number is required"); } else if (!ValidateForNumeric(textBox7.Text)) { MessageBox.Show("Phone should be in numbers"); } else if (ValidateForLength(textBox7.Text, 11) == false) { MessageBox.Show("Enter a valid phone number"); } else { int tId = Convert.ToInt32(textBox2.Text); model.teacherId = tId; model.firstname = textBox4.Text.Trim(); model.middlename = textBox1.Text.Trim(); model.lastname = textBox3.Text.Trim(); model.dob = dateTimePicker1.Value.Date; model.gender = comboBox1.Text.Trim(); model.email = textBox6.Text.Trim(); model.address = textBox7.Text.Trim(); model.phone = textBox5.Text.Trim(); using (tafesystemEntities tf = new tafesystemEntities()) { tf.teachers.Add(model); tf.SaveChanges(); } ClearFields(); MessageBox.Show("Data submitted successsfully"); PopulateGridView(); } }