private bool CheckProgram()
{
bool flag = false;
try
{
string _ProcName = "checkProgram";
SqlParameter[] _parameter =
{
new SqlParameter("@ProgramName", textBoxProgramName.Text)
};
SqlDataReader dr = db.GetDataReaderByProc(_ProcName, _parameter);
dr.Read();
if (dr.HasRows)
{
return(flag = true);
}
dr.Close();
}
catch (Exception ex)
{
LabelErrorMessage.Text = ex.Message;
}
return(flag);
}
protected void ButtonLogin_Click(object sender, EventArgs e)
{
try
{
string _ProcName = "loginCheck";
SqlParameter[] _parameter =
{
new SqlParameter("@LoginID", TextBoxUserId.Text),
new SqlParameter("@Password", TextBoxPassword.Text)
};
SqlDataReader dr = db.GetDataReaderByProc(_ProcName, _parameter);
dr.Read();
if (dr.HasRows)
{
if (dr["role"].ToString().Equals("1"))
{
Session["admin"] = TextBoxUserId.Text;
Response.Redirect("~\\Admin\\AdminHomePage.aspx");
}
else if (dr["role"].ToString().Equals("0"))
{
Session["user"] = TextBoxUserId.Text;
Response.Redirect("~\\User\\UserHomePage.aspx");
}
}
}
catch (Exception ex)
{
LabelMessage.Text = ex.Message;
}
}
private bool CheckProgram()
{
bool flag = false;
try
{
string _ProcName = "checkCourse";
SqlParameter[] _parameter =
{
new SqlParameter("@CourseName", textBoxCourse.Text),
new SqlParameter("@ProgramName", DropDownListProgram.SelectedValue.ToString())
};
SqlDataReader dr = db.GetDataReaderByProc(_ProcName, _parameter);
dr.Read();
if (dr.HasRows)
{
return(flag = true);
}
dr.Close();
}
catch (Exception ex)
{
LabelErrorMessage.Text = ex.Message;
}
return(flag);
}
