//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; } }