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