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());
}
}
protected void btnNew_Click(object sender, EventArgs e)
{
ddlCourse.ClearSelection();
ddlBranch.ClearSelection();
ddlClass.ClearSelection();
DDLAcademicYear.ClearSelection();
GrdFeesPaidDetails.Visible = false;
lblstatus.Text = "";
lblstatus.Visible = false;
}
//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;
}
}
