//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());
}
}
//Student View Profile
#region [Student Id View]
public DataSet DL_ShowStudentViewProfile(EWA_StudentView objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
//Stored procedure Action value
prmList[1] = "SelectStudentICardView";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
prmList[4] = "@UserCode";
prmList[5] = Convert.ToString(objEWA.StudentID);
//Stored procedure name
ds = ObjHelper.FillControl(prmList, "SP_Student");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
// Bind GrdId GrdId_BL
#region [Bind GrdId]
public DataSet BL_StudentIcard(EWA_StudentView objEWA)
{
try
{
DataSet ds = objDAL.DL_StudentIcard(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//Student Id
#region [Student Id]
public DataSet BL_StudentViewId(EWA_StudentView objEWA)
{
try
{
DataSet ds = objDAL.DL_ShowStudentViewProfile(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//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());
}
}
// Bind GrdId GrdId_DL
#region [Bind GrdId]
public DataSet DL_StudentIcard(EWA_StudentView objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[10];
prmList[0] = "@Action";
prmList[1] = "FetchStudentData";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
prmList[4] = "@CourseId";
prmList[5] = objEWA.CourseId.ToString();
prmList[6] = "@ClassId";
prmList[7] = objEWA.ClassId.ToString();
prmList[8] = "@BranchId";
prmList[9] = objEWA.BranchId.ToString();
//[2] = "@Course";
//prmList[3] = objEWA.Course;
//prmList[2] = "@Branch";
//prmList[3] = objEWA.Branch;
//prmList[2] = "@Class";
//prmList[3] = objEWA.Class;
//prmList[2] = "@Division";
//prmList[3] = objEWA.Division;
ds = ObjHelper.FillControl(prmList, "SP_Student");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
throw;
}
}
