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