protected void btnSave_Click(object sender, EventArgs e) { if (checkValidation()) { using (ModelTutor obj = new ModelTutor()) { tblCourse newCourse = new tblCourse { CourseCode = txtCourseCode.Text.Trim(), Name = txtCourseName.Text.Trim() }; try { obj.AddTotblCourses(newCourse); obj.SaveChanges(); DataClear(); //CourseEntity.DataBind(); GridView1.DataBind(); } catch (Exception) { } } } }
protected void btnUpdate_Click(object sender, EventArgs ev) { using (ModelTutor obj = new ModelTutor()) { int studentId = Convert.ToInt32(Session["studentId"]); string email = Session["studentEmail"].ToString(); var result = (from e in obj.tblStudents where e.StudentId == studentId && e.Email == email select e).First(); result.Name = txtName.Text.Trim(); result.Address = txtAddress.Text.Trim(); result.Id = txtStudentId.Text.Trim(); try { obj.SaveChanges(); Session["studentName"] = result.Name; } catch (Exception) { } } }
protected void btnConfirm_Click(object sender, EventArgs e) { if (checkValidation()) { int tutorId = Convert.ToInt32(Request.QueryString["tutor"]); int studentId = Convert.ToInt32(Session["studentId"]); int courseId = Convert.ToInt32(Request.QueryString["c"]); string tm = Request.QueryString["t"].ToString(); using (ModelTutor obj = new ModelTutor()) { obj.AddTotblBookings(new tblBooking { TutorId = tutorId, StudentId = studentId, DateOfBooking = Convert.ToDateTime(Request.QueryString["d"]), Description = txtDescription.Text.Trim(), TimeOfBooking = tm, CourseId = courseId }); try { obj.SaveChanges(); Response.Redirect("~/StudentDashboard.aspx?c=" + Request.QueryString["c"]); } catch (Exception) { } } } }
protected void btnAddCourse_Click(object sender, EventArgs e) { using (ModelTutor obj = new ModelTutor()) { int id = Convert.ToInt32(Session["tutorId"]); #region AddCourses if (cbCourse1.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = id, CourseId = Convert.ToInt32(cbCourse1.SelectedValue), Grade = txtGrade1.Text.Trim(), Active = false }); } if (cbCourse2.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = id, CourseId = Convert.ToInt32(cbCourse2.SelectedValue), Grade = txtGrade2.Text.Trim(), Active = false }); } if (cbCourse3.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = id, CourseId = Convert.ToInt32(cbCourse3.SelectedValue), Grade = txtGrade3.Text.Trim(), Active = false }); } if (cbCourse4.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = id, CourseId = Convert.ToInt32(cbCourse4.SelectedValue), Grade = txtGrade4.Text.Trim(), Active = false }); } #endregion try { obj.SaveChanges(); txtGrade1.Text = ""; txtGrade2.Text = ""; txtGrade3.Text = ""; txtGrade4.Text = ""; cbCourse1.SelectedIndex = 0; cbCourse2.SelectedIndex = 0; cbCourse3.SelectedIndex = 0; cbCourse4.SelectedIndex = 0; gridCourses.DataBind(); } catch (Exception) { } } }
protected void btnRate_Click(object sender, EventArgs e) { using (ModelTutor obj = new ModelTutor()) { int studentId = Convert.ToInt32(Session["studentId"]); obj.AddTotblRatings(new tblRating { StudentId = studentId, TutorId = Convert.ToInt32(cbTutor.SelectedValue), Rate = Convert.ToInt32(cbrate.SelectedValue) }); try { obj.SaveChanges(); fillCombo(); fillGrid(); } catch (Exception) { } } }
protected void btnRegister_Click(object sender, EventArgs ev) { if (checkValidation()) { System.Threading.Thread.Sleep(1500); using (ModelTutor obj = new ModelTutor()) { string email = txtEmail.Text.Trim(); var result = (from e in obj.tblStudents where e.Email == email select e).Count(); if (result < 1) { tblStudent newStudent = new tblStudent { Id = txtStudentId.Text.Trim(), Name = txtName.Text.Trim(), Address = txtAddress.Text.Trim(), Email = txtEmail.Text.Trim(), Password = txtPassword.Text.Trim(), Active = true }; try { obj.AddTotblStudents(newStudent); obj.SaveChanges(); Response.Redirect("~/Sucess.aspx?m=Your account has been sucessfuly registered. Login to book tutor."); } catch (Exception) { } } else { Label1.Text = "Email already exist"; } } } }
protected void btnUpdatePassword_Click(object sender, EventArgs ev) { using (ModelTutor obj = new ModelTutor()) { int id = Convert.ToInt32(Session["tutorId"]); var result = (from e in obj.tblTutors where e.TutorId == id select e).First(); result.Password = txtPassword.Text.Trim(); try { obj.SaveChanges(); } catch (Exception) { } } }
protected void btnUpdateTime_Click(object sender, EventArgs ev) { using (ModelTutor obj = new ModelTutor()) { int id = Convert.ToInt32(Session["tutorId"]); var result = (from e in obj.tblSchedules where e.TutorId == id select e).First(); #region Schedule result.Mo = cbMonStart.SelectedValue + "to" + cbMonEnd.SelectedValue; result.Tu = cbTueStart.SelectedValue + "to" + cbTueEnd.SelectedValue; result.We = cbWedStart.SelectedValue + "to" + cbWedEnd.SelectedValue; result.Th = cbThurStart.SelectedValue + "to" + cbThurEnd.SelectedValue; result.Fr = cbFriStart.SelectedValue + "to" + cbFriEnd.SelectedValue; try { obj.SaveChanges(); } catch (Exception) { } #endregion } }
protected void btnRegister_Click(object sender, EventArgs ev) { if (checkValidation()) { using (ModelTutor obj = new ModelTutor()) { string email = txtEmail.Text.Trim(); var result = (from e in obj.tblTutors where e.Email == email select e).Count(); if (result < 1) { tblTutor newTutor = new tblTutor { Id = txtStudentId.Text.Trim(), Name = txtName.Text.Trim(), Email = txtEmail.Text.Trim(), Password = txtPassword.Text.Trim(), Active = true }; obj.AddTotblTutors(newTutor); #region AddCourses if (cbCourse1.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = newTutor.TutorId, CourseId = Convert.ToInt32(cbCourse1.SelectedValue), Grade = txtGrade1.Text.Trim(), Active = false }); } if (cbCourse2.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = newTutor.TutorId, CourseId = Convert.ToInt32(cbCourse2.SelectedValue), Grade = txtGrade2.Text.Trim(), Active = false }); } if (cbCourse3.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = newTutor.TutorId, CourseId = Convert.ToInt32(cbCourse3.SelectedValue), Grade = txtGrade3.Text.Trim(), Active = false }); } if (cbCourse4.SelectedValue != "0") { obj.AddTotblTutorCourses(new tblTutorCourse { TutorId = newTutor.TutorId, CourseId = Convert.ToInt32(cbCourse4.SelectedValue), Grade = txtGrade4.Text.Trim(), Active = false }); } #endregion #region Schedule string mon = cbMonStart.SelectedValue + "to" + cbMonEnd.SelectedValue; string tue = cbTueStart.SelectedValue + "to" + cbTueEnd.SelectedValue; string wed = cbWedStart.SelectedValue + "to" + cbWedEnd.SelectedValue; string thur = cbThurStart.SelectedValue + "to" + cbThurEnd.SelectedValue; string fri = cbFriStart.SelectedValue + "to" + cbFriEnd.SelectedValue; obj.AddTotblSchedules(new tblSchedule { TutorId = newTutor.TutorId, Mo = mon, Tu = tue, We = wed, Th = thur, Fr = fri }); #endregion try { obj.SaveChanges(); Email m = new Email(); try { string body = "Hello " + txtName.Text.Trim() + ",\n" + "You are registered for Tutoring."; m.sendEmail(email, body); } catch (Exception) { } Response.Redirect("~/Sucess.aspx?m=Your account has been sucessfuly registered. Login to book tutor."); } catch (Exception) { } } else { Label1.Text = "Email already exist"; } } } }