public void Rebind()
{
DbLayer db = new DbLayer();
DataList1.DataSource = db.GetDataSet("select * from newsportal").Tables[0];
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DbLayer db = new DbLayer();
DataList1.DataSource = db.GetDataSet("select name,UserType,Date,BlogContent from Blog where Active='true'").Tables[0];
DataList1.DataBind();
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DbLayer db = new DbLayer();
//DataSet ds = db.GetDataSet("SELECT t.FirstName,t.LastName,ta.ExpertiseArea, ta.WorkExperience,ta.ComfortableLevel,ta.Qalification,ta.ProjectAchievement,ta.Remark, ta.LastUpdate from TrainerAdvancePro ta inner join TrainerRegistration t ON t.UserId=ta.Userid ");
DataSet ds = db.GetDataSet("SELECT t.UserId, t.FirstName,t.LastName,ta.ExpertiseArea, ta.WorkExperience,ta.ComfortableLevel,ta.Qalification,ta.ProjectAchievement,ta.Remark, ta.LastUpdate from TrainerAdvancePro ta inner join TrainerRegistration t ON t.UserId=ta.Userid where ta.ExpertiseArea='" + drpExperties.SelectedValue + "' and ta.Qalification='" + drpQali.SelectedValue + "' and ta.ComfortableLevel='" + drpComfor.SelectedValue + "'");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
lblError.Text = "";
DbLayer db = new DbLayer();
DataSet ds = db.GetDataSet("SELECT UserType,Active from Login where userId='" + teachername.Value.Trim() + "' and Password='******' ");
if (ds.Tables[0].Rows.Count > 0)
{
if (Convert.ToBoolean(ds.Tables[0].Rows[0][1]))
{
string userType = ds.Tables[0].Rows[0][0].ToString();
if (userType == "Learner")
{
DataSet ds2 = db.GetDataSet("select FirstName,LastName from LearnerRegistration where userId='" + teachername.Value.Trim() + "'");
Session["name"] = ds2.Tables[0].Rows[0][0] + " " + ds2.Tables[0].Rows[0][1];
Session["userId"] = teachername.Value;
Session["userType"] = ds.Tables[0].Rows[0][0].ToString();
Response.Redirect("Learner/AdvanceProfile.aspx");
}
else
{
DataSet ds2 = db.GetDataSet("select FirstName,LastName from TrainerRegistration where userId='" + teachername.Value.Trim() + "'");
Session["name"] = ds2.Tables[0].Rows[0][0] + " " + ds2.Tables[0].Rows[0][1];
Session["userId"] = teachername.Value;
Session["userType"] = ds.Tables[0].Rows[0][0].ToString();
Response.Redirect("Trainner/AdvanceProfileTrainer.aspx");
}
}
else
{
lblError.Text = "Your Id is Blocked !!!";
return;
}
}
else
{
lblError.Text = "Invalid User Id or Password !";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
lblError.Text = "";
DbLayer db = new DbLayer();
DataSet ds = db.GetDataSet("SELECT Role from AdminLogin where userId='" + pupilname.Value.Trim() + "' and Password='******' ");
if (ds.Tables[0].Rows.Count > 0)
{
Session["userId"] = pupilname.Value;
Session["userType"] = ds.Tables[0].Rows[0][0].ToString();
Response.Redirect("Admin/ViewSuggestion.aspx");
}
else
{
lblError.Text = "Invalid Admin Login ";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DbLayer db = new DbLayer();
DataSet ds = db.GetDataSet("select * from Login where UserId='" + Session["userId"].ToString() + "' and Password='******' ");
if (ds.Tables[0].Rows.Count > 0)
{
int i = db.ExecuteNonQuery("Update Login set Password='******'where UserId='" + Session["userId"].ToString() + "' ");
if (i > 0)
{
Label1.ForeColor = Color.Green;
Label1.Text = "Your Password is Successfully Updated ..";
}
}
else
{
Label1.ForeColor = Color.Red;
Label1.Text = "Invalid Old Password plz Try again !!!";
}
}
