private void BindCourse()
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ddlCourse.DataSource = ds;
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
ddlBranch.Items.Clear();
ddlClass.Items.Clear();
ddlBranch.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
ddlClass.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindCourse()
{
try
{
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ViewState["dvBranch"] = ds.Tables[2];
ViewState["dvClass"] = ds.Tables[3];
ddlCourse.Items.Clear();
ddlCourse.DataSource = ds.Tables[0];
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new ListItem("---Select---", "0"));
DDLAcademicYear.Items.Clear();
DDLAcademicYear.DataSource = ds.Tables[7];
DDLAcademicYear.DataTextField = "AcademicYear";
DDLAcademicYear.DataValueField = "AcademicYearId";
DDLAcademicYear.DataBind();
DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0"));
ddlBranch.Items.Clear();
ddlBranch.Items.Insert(0, new ListItem("---Select---", "0"));
ddlClass.Items.Clear();
ddlClass.Items.Insert(0, new ListItem("---Select---", "0"));
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindCourse()
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ViewState["dvBranch"] = ds.Tables[2];
ViewState["dvClass"] = ds.Tables[3];
ViewState["dvDivision"] = ds.Tables[4];
ViewState["dvStudentData"] = ds.Tables[5];
ddlCourse.DataSource = ds.Tables[0];
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new ListItem("---Select---", "0"));
ddlCasteCategory.DataSource = ds.Tables[1];
ddlCasteCategory.DataTextField = "CasteCategoryName";
ddlCasteCategory.DataValueField = "CasteCategoryId";
ddlCasteCategory.DataBind();
ddlCasteCategory.Items.Insert(0, new ListItem("---Select---", "0"));
DDLAcademicYear.DataSource = ds.Tables[7];
DDLAcademicYear.DataTextField = "AcademicYear";
DDLAcademicYear.DataValueField = "AcademicYearId";
DDLAcademicYear.DataBind();
DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0"));
ddlBranch.Items.Clear();
ddlBranch.Items.Insert(0, new ListItem("---Select---", "0"));
ddlClass.Items.Clear();
ddlClass.Items.Insert(0, new ListItem("---Select---", "0"));
if (IsPostBack)
{
GrdStudent.DataSource = ds.Tables[5];
GrdStudent.DataBind();
gvPrint.DataSource = ds.Tables[5];
gvPrint.DataBind();
ViewState["PrintData"] = ds.Tables[5];
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindCourse()
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ViewState["dvcast"] = ds.Tables[1];
ViewState["dvBranch"] = ds.Tables[2];
ViewState["dvClass"] = ds.Tables[3];
//ViewState["dvDivision"] = ds.Tables[4];
ViewState["dvStudentData"] = ds.Tables[5];
ddlCourse.DataSource = ds.Tables[0];
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new ListItem("---Select---", "0"));
ddlCasteCategory.DataSource = ds.Tables[1];
ddlCasteCategory.DataTextField = "CasteCategoryName";
ddlCasteCategory.DataValueField = "CasteCategoryId";
ddlCasteCategory.DataBind();
ddlCasteCategory.Items.Insert(0, new ListItem("---Select---", "0"));
DDLAcademicYear.DataSource = ds.Tables[7];
DDLAcademicYear.DataTextField = "AcademicYear";
DDLAcademicYear.DataValueField = "AcademicYearId";
DDLAcademicYear.DataBind();
DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0"));
ddlBranch.Items.Clear();
ddlBranch.Items.Insert(0, new ListItem("---Select---", "0"));
ddlClass.Items.Clear();
ddlClass.Items.Insert(0, new ListItem("---Select---", "0"));
ddlDivision.Items.Clear();
ddlDivision.Items.Insert(0, new ListItem("---Select---", "0"));
GrdStudent.DataSource = ds.Tables[5];
GrdStudent.DataBind();
//GrdStudent.DataSource = db.Displaygrid("SELECT tblStudent.UserCode, tblAdmissionDetails.FirstName, tblAdmissionDetails.MiddleName, tblAdmissionDetails.LastName, tblCourse.CourseName, tblBranch.BranchName, tblClass.ClassName, tblAdmissionDetails.AdmissionYear FROM tblAdmissionDetails INNER JOIN tblStudent ON tblAdmissionDetails.AdmissionID = tblStudent.AdmissionId INNER JOIN tblCourse ON tblAdmissionDetails.CourseId = tblCourse.CourseId INNER JOIN tblBranch ON tblAdmissionDetails.BranchId = tblBranch.BranchId INNER JOIN tblClass ON tblAdmissionDetails.ClassId = tblClass.ClassId where tblAdmissionDetails.OrgID='" + Convert.ToInt32(Session["OrgId"]) + "'");
//GrdStudent.DataBind();
gvPrint.DataSource = ds.Tables[5];
gvPrint.DataBind();
ViewState["PrintData"] = ds.Tables[5];
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
public void BindStudentList(string rblStatus)
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ViewState["dvStudentData"] = ds.Tables[6];
dvStudentData = new DataView(ViewState["dvStudentData"] as DataTable);
dvStudentData.RowFilter = "[Status] = '" + rblStatus + "'";
GrdStudent.DataSource = dvStudentData;
GrdStudent.DataBind();
gvPrint.DataSource = dvStudentData;
gvPrint.DataBind();
}
// Biding Methods
#region Biding Comman Methods
private void BindCourse(int OrgID)
{
try
{
objEWA.OrgId = Convert.ToString(OrgID);
DataSet ds = objBL.BindCourses_BL(objEWA);
ddlCourses.DataSource = ds;
ddlCourses.DataTextField = "CourseName";
ddlCourses.DataValueField = "CourseId";
ddlCourses.DataBind();
ddlCourses.Items.Insert(0, "Select");
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindCourse()
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = DDL_SelectCollege.SelectedValue;
DataSet ds = objBL.BindCourses_BL(objEWA);
ddlCourse.DataSource = ds;
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new ListItem("Select", "0"));
}
catch (Exception exp)
{
}
}
//Bind Course
#region
private void BindCourse()
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ddlCourse.DataSource = ds;
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, "Select");
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Bind Course
#region [Bind Courses]
private void BindCourse(int OrgID)
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
//Pass from Session
objEWA.OrgId = Convert.ToString(OrgID);
DataSet ds = objBL.BindCourses_BL(objEWA);
ddlCourses.DataSource = ds;
ddlCourses.DataTextField = "CourseName";
ddlCourses.DataValueField = "CourseId";
ddlCourses.DataBind();
ddlCourses.Items.Insert(0, new ListItem("Select", "0"));
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Bind Drop Down
#region [Bind Drop Down]
protected void BindDropDownData(int orgID)
{
try
{
BL_Common objBL = new BL_Common();
EWA_Common objEWA = new EWA_Common();
objEWA.OrgId = Convert.ToString(orgID);
ds = objBL.BindCourses_BL(objEWA);
ddl_Course.DataSource = ds;
ddl_Course.DataTextField = "CourseName";
ddl_Course.DataValueField = "CourseId";
ddl_Course.DataBind();
ddl_Course.Items.Insert(0, "Select");
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindCourse()
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ViewState["dvBranch"] = ds.Tables[2];
ViewState["dvClass"] = ds.Tables[3];
//ViewState["dvStudentData"] = ds.Tables[6];
ddlCourse.DataSource = ds.Tables[0];
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new ListItem("---Select---", "0"));
ddlBranch.Items.Clear();
ddlBranch.Items.Insert(0, new ListItem("---Select---", "0"));
ddlClass.Items.Clear();
ddlClass.Items.Insert(0, new ListItem("---Select---", "0"));
//GrdStudent.DataSource = ds.Tables[6];
//GrdStudent.DataBind();
//gvPrint.DataSource = ds.Tables[6];
//gvPrint.DataBind();
//ViewState["PrintData"] = ds.Tables[6];
//ViewState["dvStudentData_Completed"] = ds.Tables[8];
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindStudent()
{
try
{
EWA_Common objEWA = new EWA_Common();
BL_Common objBL = new BL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = objBL.BindCourses_BL(objEWA);
ViewState["dvStudentData"] = ds.Tables[5];
GrdStudent.DataSource = ds.Tables[5];
GrdStudent.DataBind();
gvPrint.DataSource = ds.Tables[5];
gvPrint.DataBind();
ViewState["PrintData"] = ds.Tables[5];
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Added by Ashwini 8-Oct-2020
private void BindCourse()
{
try
{
ec.OrgId = Session["OrgId"].ToString();
DataSet ds = bl.BindCourses_BL(ec);
ViewState["dvBranch"] = ds.Tables[2];
ViewState["dvClass"] = ds.Tables[3];
ViewState["dvDivision"] = ds.Tables[4];
ViewState["dvStudentData"] = ds.Tables[5];
ddlCourse.Items.Clear();
ddlCourse.DataSource = ds.Tables[0];
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new ListItem("---Select---", "0"));
DDLAcademicYear.Items.Clear();
DDLAcademicYear.DataSource = ds.Tables[7];
DDLAcademicYear.DataTextField = "AcademicYear";
DDLAcademicYear.DataValueField = "AcademicYearId";
DDLAcademicYear.DataBind();
DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0"));
ddlBranch.Items.Clear();
ddlBranch.Items.Insert(0, new ListItem("---Select---", "0"));
ddlClass.Items.Clear();
ddlClass.Items.Insert(0, new ListItem("---Select---", "0"));
}
catch (Exception exp)
{
throw exp;
}
}
//Page Load
#region [Page Load]
protected void Page_Load(object sender, EventArgs e)
{
try
{
int orgId = Convert.ToInt32(Session["OrgID"]);
if (orgId == 0)
{
Response.Redirect("~/CMSHome.aspx");
}
if (!IsPostBack)
{
EWA_Common ObjEWA = new EWA_Common();
BL_Common ObjBL = new BL_Common();
//Session OrgId;
ObjEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = ObjBL.BindCourses_BL(ObjEWA);
// ObjEWA.CourseId = ObjEWA.CourseId;
ddlCourse.DataSource = ds;
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, new ListItem("Select", "Select"));
//Session OrgId;
ObjEWA.OrgId = Session["OrgId"].ToString();
//DataSet ds1 = ObjBL.BindCasteCategory_BL(ObjEWA);
Bind_ddlFeesCategory();
//cn.Open();
//SqlCommand cmd1 = new SqlCommand("SELECT CourseId,CourseName FROM tblCourse WHERE OrgId='" + ddlCourse.SelectedValue + "'", cn);
//SqlDataReader dr1 = cmd1.ExecuteReader();
//ddlCourse.DataSource = dr1;
//ddlCourse.Items.Clear();
//ddlCourse.DataTextField = "CourseName";
//ddlCourse.DataValueField = "CourseId";
//ddlCourse.DataBind();
//cn.Close();
//ddlCourse.Items.Insert(0, new ListItem("--Please Select Course--", "0"));
// cn.Open();
// SqlCommand cmd = new SqlCommand("SELECT CasteCategoryId,CasteCategoryName FROM tblCasteCategory where OrgId='" + orgId.ToString() + "'", cn);
// SqlDataReader dr = cmd.ExecuteReader();
// ddlCastCategory.DataSource = dr;
//// ddlCastCategory.DataSource = ds1;
// ddlCastCategory.DataTextField = "CasteCategoryName";
// ddlCastCategory.DataValueField = "CasteCategoryId";
// ddlCastCategory.DataBind();
// ddlCastCategory.Items.Insert(0, "Select");
// dr.Close();
BindGridView("Empty");
lblresult.Text = "";
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
