protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridView1.DataBind();
        // Sending Cancellation Confirmation Email To the Students for information
        try
        {
            String studentID;
            if (Session["StudentID"] == null)
            {
                studentID = "300717754";
            }
            else
            {
                studentID = Session["StudentID"].ToString();
            }
            EmailConfirmation obj = new EmailConfirmation();
            DatabaseRegistration objdb = new DatabaseRegistration();

            String emailID = objdb.getEmailID(studentID);
            String Subject = "Appointment Cancellation";
            String body = "You have Successfully Cancelled Appointment.\n Message Send from Advisor Booking Service System";

            obj.sendEmail("*****@*****.**", "Passwordisimportant", emailID, Subject, body);
            Server.Transfer("StudentCancelAppointment.aspx");
        }
        catch {
            Server.Transfer("StudentCancelAppointment.aspx");
        }
    }
 protected void btnUpdate_Click(object sender, EventArgs e)
 {
     try
     {
         DatabaseRegistration objdb = new DatabaseRegistration();
         if (objdb.update_Password(studentID, txtOldPassword.Text, txtPassword.Text))
         {
             lblMessage.Text = "Password updated Successfully";
         }
         else
         {
             lblMessage.Text = "Enter Correct Old Password";
         }
     }
     catch (Exception obj)
     {
         lblMessage.Text = " Password is not updated Successfully. Database Error";
     }
 }
    protected void btnRegister_Click(object sender, EventArgs e)
    {
        try
        {String path;
            studentID = txtStudentID.Text;
            EmailConfirmation obj = new EmailConfirmation();
            DatabaseRegistration objdb = new DatabaseRegistration();

            if (objdb.isStudentIDAvailable(studentID) && objdb.isEmailIDAvailable(txtEmailID.Text))
            {
                if (PhotoUpload.HasFile)
                {
                    PhotoUpload.SaveAs(MapPath("~/Files/Images/Students/" + PhotoUpload.FileName));
                    path = PhotoUpload.FileName; ;
                }
                else
                {
                    path = " ";
                }
                objdb.insert_Student_Info(txtStudentID.Text, txtFName.Text, txtLName.Text, ddlProgram.SelectedValue, txtCurrentSemester.Text, path);
                objdb.insert_Student_Login_Info(txtEmailID.Text, txtPassword.Text, txtStudentID.Text);
                String Subject = "Registration Confirmation Email";
                String body = "You are Successfully registered with Advisor Booking Service.";
                body = body + "\n Now You can make an appointment with the advisor";
                body = body + "\n Your User Name is =" + txtEmailID.Text;
                body = body + "\n Your Password is =" + txtPassword.Text;
                obj.sendEmail("*****@*****.**", "Passwordisimportant", txtEmailID.Text, Subject, body);
                lblMessage.Text = "Successfully Registered";
                /// clear_Fields();
                Response.Redirect("UserLogin.aspx");
            }
            else
            {
                lblMessage.Text = "StudentID or Email ID is already registered";
                clear_Fields();
            }
        }
        catch (Exception obj)
        {
            lblMessage.Text = "Error in Registeration. Please try again";
        }
    }
 protected void btnUpdate_Click(object sender, EventArgs e)
 {
     try
     {
         DatabaseRegistration objdb = new DatabaseRegistration();
         if (imgUpload.HasFile)
         {
             imgUpload.SaveAs(MapPath("~\\Files\\Images\\Students\\" + imgUpload.FileName));
             path = imgUpload.FileName;
         }
         else
         {
             path = Session["Path"].ToString();
         }
         objdb.update_Student_Info(lblStudentIDValue.Text, txtFName.Text, txtLName.Text, ddlProgramName.SelectedValue, txtCurrentSemester.Text, path);
         lblMessage.Text = "Profile updated Successfully";
     }
     catch
     {
         lblMessage.Text = "Profile is not updated Successfully. Database Error";
     }
 }