public StudLogin SearchLoginDAL(int STUDENTID, string PASSWORD)
{
StudLogin studentLogin = null;
try
{
DbCommand command = DataConnection.CreateCommand();
command.CommandText = "LoginProc";
DbParameter param = command.CreateParameter();
param.ParameterName = "@StudentID";
param.DbType = DbType.Int32;
param.Value = STUDENTID;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Password";
param.DbType = DbType.String;
param.Value = PASSWORD;
command.Parameters.Add(param);
DataTable dataTable = DataConnection.ExecuteSelectCommand(command);
if (dataTable.Rows.Count > 0)
{
studentLogin = new StudLogin();
studentLogin.STUDENTID = Convert.ToInt32(dataTable.Rows[0][0]);
studentLogin.PASSWORD = (string)dataTable.Rows[0][1];
}
}
catch (AdmissionException ex)
{
throw new AdmissionException(ex.Message);
}
return(studentLogin);
}
protected void Button1_Click(object sender, EventArgs e)
{
StudLogin studLogin = new StudLogin();
if (TextBox1.Text == studLogin.STUDENTID.ToString() && TextBox2.Text == studLogin.PASSWORD)
{
Response.Redirect("RegisterUser.aspx");
}
else
{
Label7.Text = "Invalid Details";
}
}
public static StudLogin SearchLoginBL(int StudentID, string Password)
{
StudLogin studLogin = null;
try
{
AdmissionDAL admDAL = new AdmissionDAL();
studLogin = admDAL.SearchLoginDAL(StudentID, Password);
}
catch (AdmissionException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(studLogin);
}
