//Page Indext Created
#region [Grd Index Changed]
protected void grdIcard_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
BL_StudentView objBAL = new BL_StudentView();
EWA_StudentView objEWA = new EWA_StudentView();
objEWA.CourseId = ddlcourse.SelectedValue.Trim();
objEWA.ClassId = ddlclass.SelectedValue.Trim();
objEWA.BranchId = ddlbranch.SelectedValue.Trim();
objEWA.OrgId = Convert.ToInt32(Session["OrgId"]);
DataSet ds = new DataSet();
ds = objBAL.BL_StudentIcard(objEWA);
grdIcard.DataSource = ds;
grdIcard.DataBind();
grdIcard.PageIndex = e.NewPageIndex;
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Bind Grid
#region [Bind grid]
private void BindGrid()
{
try
{
BL_StudentView objBAL = new BL_StudentView();
EWA_StudentView objEWA = new EWA_StudentView();
objEWA.CourseId = ddlcourse.SelectedValue.Trim();
objEWA.BranchId = ddlbranch.SelectedValue.Trim();
objEWA.ClassId = ddlclass.SelectedValue.Trim();
objEWA.OrgId = Convert.ToInt32(Session["OrgId"]);
DataSet ds = new DataSet();
ds = objBAL.BL_StudentIcard(objEWA);
//if (ds.Tables[0].Rows.Count > 0)
//{
database db = new database();
grdIcard.DataSource = db.Displaygrid("SELECT tblStudent.UserCode, tblStudent.FirstName + ' ' + tblStudent.MiddleName + ' ' + tblStudent.LastName AS FullName FROM tblStudent INNER JOIN tblClass ON tblStudent.BranchId = tblClass.BranchId WHERE (tblStudent.OrgId = '" + Convert.ToInt32(Session["OrgId"]) + "') AND (tblStudent.CourseId = '" + ddlcourse.SelectedValue.Trim() + "') AND (tblStudent.BranchId = '" + ddlbranch.SelectedValue.Trim() + "') AND (tblClass.ClassId = '" + ddlclass.SelectedValue.Trim() + "')");
// grdIcard.DataSource = ds.Tables[0];
grdIcard.DataBind();
// }
//else
//{
// DataTable dt = new DataTable();
// dt.Columns.Add("UserCode");
// dt.Columns.Add("FullName");
// //dt.Rows.Add();
// //dt.Rows.Add();
// //dt.Rows.Add();
// grdIcard.DataSource = dt;
// grdIcard.DataBind();
//}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
