protected void ddlStatus_OnSelectedIndexChanged(object sender, EventArgs e)
{
if (ddlStatus.SelectedValue.ToString() == "NotApprove")
{
if (ddlViewBy.SelectedValue.ToString() == "Course")
{
pnlCourse.Visible = true; pnlIM.Visible = false;
}
btnApprove.Visible = true; btnHold.Visible = true; btnToBeApprove.Visible = true;
}
else if (ddlStatus.SelectedValue.ToString() == "Active")
{
btnHold.Visible = false; btnApprove.Visible = false; btnToBeApprove.Visible = false; pnlIM.Visible = true;
}
else if (ddlStatus.SelectedValue.ToString() == "Pending")
{
if (ddlViewBy.SelectedValue.ToString() == "Course")
{
pnlCourse.Visible = true; pnlIM.Visible = false;
}
btnApprove.Visible = false; btnHold.Visible = false; btnToBeApprove.Visible = true;
}
GridToBeApprove.DataSource = null;
GridToBeApprove.DataBind();
ddlStatus.Focus();
}
private void bind()
{
string qry = "";
if (ddlSearch.SelectedValue == "Status")
{
qry = "select SN, SID,StudentName,IMID,Course,Part,Session,EntryStatus from Project where Status='" + ddlStatus.SelectedValue.ToString() + "' and Session='" + lblSeasonHidden.Text + "' order by SID";
}
else if (ddlSearch.SelectedValue == "IMID")
{
qry = "select SN, SID,StudentName,IMID,Course,Part,Session,EntryStatus from Project where IMID='" + txtID.Text + "' and Session='" + lblSeasonHidden.Text + "' order by SID";
}
else if (ddlSearch.SelectedValue == "Enrolment")
{
qry = "select SN,SID,StudentName,IMID,Course,Part,Session,EntryStatus from Project where SID='" + txtID.Text + "'";
}
else if (ddlSearch.SelectedValue == "InstitutionID")
{
qry = "select SN,SID,StudentName,IMID,Course,Part,Session,EntryStatus from Project where InstitutionID='" + txtID.Text + "' and Session='" + lblSeasonHidden.Text + "' order by SID";
}
SqlDataAdapter adp = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridToBeApprove.DataSource = dt;
GridToBeApprove.Columns[9].Visible = false;
GridToBeApprove.DataBind();
}
protected void btnView_Onclick(object sender, EventArgs e)
{
string qry = "", qry2 = "";
if (ddlViewBy.SelectedValue.ToString() == "Course")
{
if (ddlCourse.SelectedValue.ToString() == "All")
{
if (ddlStatus.SelectedValue.ToString() == "Active")
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and IMID='" + txtIMID.Text + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
else
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Status='" + ddlStatus.SelectedValue.ToString() + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
qry2 = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Status='ToBeApprove' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
else
{
if (ddlStatus.SelectedValue.ToString() == "Active")
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and IMID='" + txtIMID.Text + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
else
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
qry2 = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='ToBeApprove' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
}
else if (ddlViewBy.SelectedValue.ToString() == "IMID")
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Course,Part,Session,Status from Student where IMID='" + txtIMID.Text.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
qry2 = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Course,Part,Session,Status from Student where IMID='" + txtIMID.Text.ToString() + "' and Status='ToBeApprove' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
SqlDataAdapter ad = new SqlDataAdapter();
ad = new SqlDataAdapter(qry, con);
DataTable at = new DataTable();
ad.Fill(at);
GridToBeApprove.DataSource = at;
GridToBeApprove.DataBind();
ad = new SqlDataAdapter(qry2, con);
at.Clear();
ad.Fill(at);
GridAppTable.DataSource = at;
GridAppTable.DataBind();
if (GridAppTable.Rows.Count > 0)
{
btnApprove.Enabled = true;
}
else
{
btnApprove.Enabled = false;
}
btnViewa.Focus();
}
protected void btnView_Onclick(object sender, EventArgs e)
{
string qry = "";
qry = "select FormType,Amount,Type,Enrolment,AppNo,IMID,SerialNo,Name from RecoverApp where Status='" + ddlStatus.SelectedValue.ToString() + "' and FormType='Admission'";
SqlDataAdapter ad = new SqlDataAdapter();
ad = new SqlDataAdapter(qry, con);
DataTable at = new DataTable();
ad.Fill(at);
GridToBeApprove.DataSource = at;
GridToBeApprove.DataBind();
}
protected void txtID_TextChanged(object sender, EventArgs e)
{
bind(); GridToBeApprove.Focus();
}
protected void ddlStatus_OnSelectedIndexChanged(object sender, EventArgs e)
{
GridToBeApprove.DataSource = null;
GridToBeApprove.DataBind();
btnViewa.Focus();
}
