public void bind_weekly_pared_rally()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_weekly_pared_info");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
public bool checkStudentRollnumber(string rollnumber)
{
string query = "select * from tbl_form where rollno = '" + txtroll.Text + "'";
DataSet ds = db.ExecuteDataSet(query);
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public void bindtable()
{
DataSet ds = db.ExecuteDataSet("select * from tbl_application_form");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
public void blindtable()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_event_details");
GridView2.DataSource = ds.Tables[0];
GridView2.DataBind();
}
public void blindtable()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_camp_update");
GridView3.DataSource = ds.Tables[0];
GridView3.DataBind();
}
public void blindtable()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_demo_paper");
GridView6.DataSource = ds.Tables[0];
GridView6.DataBind();
}
public void bindtable()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_jobs");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
public void blindtable()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_weekly_pared_info");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
public void blindtable()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_army_exam_book");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
public void bind_event()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_exam_details");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
public void bind_camp_update()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_camp_update");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
public void bind_demo_paper()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_army_exam_book");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
public void bind_job_info()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_jobs");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
public void bind_demo_paper()
{
DataSet ds = new DataSet();
ds = db.ExecuteDataSet("select * from tbl_army_rally_info");
DataList4.DataSource = ds.Tables[0];
DataList4.DataBind();
}
private bool AuthenticateMe(string userRollNo, string password)
{
// just hard code the username for this demo
// in real scenario you should call your object and validate username and password againt the database or whichever data source you are using
DataSet ds = new DataSet();
string query = "select * from tbl_application_form where rollno= '" + userRollNo + "' and password='******'";
ds = db.ExecuteDataSet(query);
if (ds.Tables[0].Rows.Count > 0)
{
Random r = new Random();
int num = r.Next(1000);
string id = num.ToString();
if (TextBox1.Text.Equals(ds.Tables[0].Rows[0]["rollno"].ToString()) && TextBox2.Text.Equals(ds.Tables[0].Rows[0]["password"].ToString()))
{
Session["SessionId"] = id;
Session["username"] = TextBox1.Text;
return(true);
}
else
{
Response.Write("<script>alert('Login Failed!!! Try Again.')</script>");
return(false);
}
}
else
{
Response.Write("<script>alert('Roll Number Does Not Found!!! Try Again.')</script>");
return(false);
}
return(false);
}
private bool AuthenticateMe(string userName, string passwords)
{
// just hard code the username for this demo
// in real scenario you should call your object and validate username and password againt the database or whichever data source you are using
DataSet ds = new DataSet();
string query = "select * from tb_login where username= '******' and password='******'";
ds = db.ExecuteDataSet(query);
if (ds.Tables[0].Rows.Count > 0)
{
Random r = new Random();
int num = r.Next(1000);
string id = num.ToString();
if (txtusername.Text.Equals(ds.Tables[0].Rows[0]["username"].ToString()) && txtpassword.Text.Equals(ds.Tables[0].Rows[0]["password"].ToString()))
{
Session["SessionId"] = id;
Session["username"] = txtusername.Text;
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "hiii", "callme('hiiiii')", true);
return(true);
}
else
{
// Label1.Visible = true;
// Label1.Text = "Please enter valid passowrd";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "hiii", "callme('Please Enter Valid Email Or Passowrd')", true);
}
}
else
{
// Label1.Visible = true;
// Label1.Text = "Please enter valid username and passowrd";
}
return(false);
}
protected void Button1_Click(object sender, EventArgs e)
{
string query = "select * from tbl_application_form where rollno = '" + txtroll.Text + "'";
DataSet ds = db.ExecuteDataSet(query);
if (ds.Tables[0].Rows.Count > 0)
{
string status = ds.Tables[0].Rows[0]["status"].ToString();
if (status.Equals("yes"))
{
lblmessage.InnerText = "Your form is approved.";
}
else
{
lblmessage.InnerText = "Your form is not yet approved.";
}
}
else
{
}
}