protected void btnSubmit_Click(object sender, EventArgs e)
{
string Email = txtEmail.Text.ToString();
if (ValidateEmail(Email))
{
Binus.Common.Data.Student Data = new Binus.Common.Data.Student
{
studentEmail = Email
};
Binus.Common.Data.Student ForgetPassword = new StudentSystem().Student_ReadSecurityQuestion(Data);
if (Data.studentEmail == ForgetPassword.studentEmail)
{
Session["SecurityEmail"] = ForgetPassword.studentEmail;
Session["SecurityName"] = ForgetPassword.studentName;
Session["SecurityPassword"] = ForgetPassword.studentPassword;
Session["SecurityQuestion"] = ForgetPassword.studentSecurityQuestion;
Response.Redirect("student_securityQuestion_popUp_fill.aspx" + "?" + ForgetPassword.studentEmail);
}
else
{
lblErrorMsg.Text = "Invalid email!";
}
}
else
{
lblErrorMsg.Text = "Please input correct email!";
}
}
protected void btnChangePassword_Click(object sender, EventArgs e)
{
string Answer = txtAnswer.Text.ToString().ToLower();
if (Answer == "")
{
lblErrorMsg.Text = "Please input the answer!";
}
else
{
Binus.Common.Data.Student Data = new Binus.Common.Data.Student
{
studentEmail = Session["SecurityEmail"].ToString(),
studentSecurityAnswer = Answer
};
Binus.Common.Data.Student CheckPassword = new StudentSystem().Student_CheckSecurityAnswer(Data);
if (Data.studentSecurityAnswer == CheckPassword.studentSecurityAnswer)
{
Response.Redirect("student_resetPassword.aspx");
}
else
{
lblErrorMsg.Text = "Wrong answer!";
}
}
}
private void LoadData()
{
Binus.Common.Data.Student Data = new Binus.Common.Data.Student()
{
courseName = Session["CurrentCourse"].ToString()
};
List <Material> RetVal = new StudentSystem().Student_GetMaterial(Data);
gvMaterial.DataSource = RetVal;
gvMaterial.DataBind();
}
protected void btnChangePassword_Click(object sender, EventArgs e)
{
if (ValidateChangePassword())
{
string CurrentPassword = txtCurrentPassword.Text;
string NewPassword = txtNewPassword.Text;
string ReTypePassword = txtReNewPassword.Text;
// Hashing password
string HashPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(NewPassword, "SHA1");
Binus.Common.Data.Student Data = new Binus.Common.Data.Student();
Data.studentEmail = Session["ActiveStudentEmail"].ToString();
Data.studentPassword = CurrentPassword;
try
{
if (Session["ActiveStudentEmail"].ToString() == "*****@*****.**")
{
if (new StudentSystem().Student_ChangePassword(Data, NewPassword))
{
lblErrorMsg.Text = "Success..";
Session["Password"] = NewPassword;
}
else
{
lblErrorMsg.Text = "ERROR!";
}
}
else
{
if (new StudentSystem().Student_ChangePassword(Data, HashPassword))
{
lblErrorMsg.Text = "Success..";
Session["Password"] = HashPassword;
}
else
{
lblErrorMsg.Text = "ERROR!";
}
}
}
catch (Exception ex)
{
throw ex;
}
}
else
{
lblErrorMsg.Text = "Please check all field input!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
Binus.Common.Data.Student Data = new Binus.Common.Data.Student
{
studentEmail = Session["ActiveStudentEmail"].ToString()
};
Binus.Common.Data.Student GetDetail = new StudentSystem().Student_GetDetail(Data);
lblStudentID.Text = GetDetail.studentID;
lblStudentName.Text = GetDetail.studentName;
lblStudentDOB.Text = GetDetail.studentDOB;
lblCourseName.Text = GetDetail.courseName;
string ConStr = @"Data Source=127.0.0.1;Initial Catalog=LapakMikir;Integrated Security=True";
SqlConnection Conn = new SqlConnection(ConStr);
SqlCommand sqlCommand = new SqlCommand("dbo.bn_student_readDetail", Conn);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add("Email", SqlDbType.VarChar).Value = Session["ActiveStudentEmail"].ToString();
Conn.Open();
SqlDataReader Reader = sqlCommand.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
try
{
byte[] ImgData = (byte[])Reader["studentPicture"];
string ImgUrl = Convert.ToBase64String(ImgData, 0, ImgData.Length);
imgProfile.ImageUrl = "data:image/png;base64," + ImgUrl;
}
catch
{
imgProfile.ImageUrl = "~/Assets/ppDefault.png";
}
}
Reader.Close();
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string Email = txtEmail.Text.ToString();
string Password = txtPassword.Text.ToString();
// Hashing password
string HashPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(Password, "SHA1");
Binus.Common.Data.Student Login = new Binus.Common.Data.Student
{
studentEmail = Email,
studentPassword = Password
};
if (Email != "*****@*****.**")
{
Login.studentPassword = HashPassword;
}
Binus.Common.Data.Student DoLogin = new LogInSystem().DoLogIn(Login);
if (DoLogin == null)
{
lblErrorMsg.Text = "Invalid username & password!";
}
else
{
if (Login.studentPassword == DoLogin.studentPassword)
{
Session["ActiveStudentEmail"] = DoLogin.studentEmail;
Session["Password"] = Password;
Session["CurrentCourse"] = DoLogin.courseName;
Response.Redirect("student_dashboard.aspx");
//Response.Redirect("student_accountSetting.aspx");
}
else
{
lblErrorMsg.Text = "Invalid username & password!";
}
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
// Hashing the password
string HashPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "SHA1");
string ErrorMsg = CheckData();
Binus.Common.Data.Student Data = new Binus.Common.Data.Student
{
studentName = txtName.Text,
studentEmail = txtEmail.Text,
studentSecondaryEmail = txtSecEmail.Text,
studentPassword = HashPassword,
studentDOB = txtDOB.Text,
studentSecurityQuestion = ddlSecurityQuestion.SelectedValue,
studentSecurityAnswer = txtSecurityAnswer.Text.ToLower()
};
if (ValidateInput(ErrorMsg))
{
try
{
if (new StudentSystem().Student_CreateNewStudent(Data))
{
Response.Redirect("student_login.aspx");
}
else
{
lblErrorMsg.Text = "Error!";
}
}
catch (Exception ex)
{
throw ex;
}
}
else
{
lblErrorMsg.Text = ErrorMsg;
}
}
