public void BindSubject()
{
try
{
EWA_Common objEWA = new EWA_Common();
DL_Common objDL = new DL_Common();
objEWA.OrgId = Session["OrgId"].ToString();
objEWA.CourseId = ddlCourse.SelectedValue.ToString();
objEWA.BranchId = ddlBranch.SelectedValue.ToString();
objEWA.ClassId = ddlClass.SelectedValue.ToString();
//objEWA.DivisionId = ddlDivision.SelectedValue.ToString();
objEWA.UserCode = Session["Username"].ToString();
DataSet ds = objDL.FetchSubject_DL(objEWA);
DDSubject.Items.Clear();
DDSubject.DataSource = ds;
DDSubject.DataTextField = "SubjectName";
DDSubject.DataValueField = "SubjectId";
DDSubject.DataBind();
DDSubject.Items.Insert(0, new ListItem("Select", "0"));
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindBranch()
{
try
{
EWA_Common objEWA = new EWA_Common();
DL_Common objDL = new DL_Common();
objEWA.CourseId = ddlCourse.SelectedValue.ToString();
DataSet ds = objDL.BindBranch_DL(objEWA);
if (ds.Tables[0].Rows.Count != 0)
{
ddlBranch.DataSource = ds;
ddlBranch.DataTextField = "BranchName";
ddlBranch.DataValueField = "BranchId";
ddlBranch.DataBind();
}
else
{
ddlBranch.Items.Clear();
}
ddlBranch.Items.Insert(0, new ListItem("Select", "0"));
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Bind Branch
#region [Bind Branch]
protected void BindBranch()
{
try
{
EWA_Common objEWA = new EWA_Common();
DL_Common objDL = new DL_Common();
objEWA.CourseId = ddlCourse.SelectedValue.ToString();
if (!objEWA.CourseId.Equals("Select"))
{
DataSet ds = objDL.BindBranch_DL(objEWA);
ddlBranch.DataSource = ds;
ddlBranch.DataTextField = "BranchName";
ddlBranch.DataValueField = "BranchId";
ddlBranch.DataBind();
ddlBranch.Items.Insert(0, "Select");
}
else
{
ddlBranch.Items.Clear();
ddlBranch.Items.Insert(0, "Select");
}
BindClass();
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
private void BindBranch()
{
try
{
EWA_Common objEWA = new EWA_Common();
DL_Common objDL = new DL_Common();
objEWA.CourseId = ddlCourse.SelectedValue.ToString();
DataSet ds = objDL.BindBranch_DL(objEWA);
ddlBranch.DataSource = ds;
ddlBranch.DataTextField = "BranchName";
ddlBranch.DataValueField = "BranchId";
ddlBranch.DataBind();
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"));
}
catch (Exception exp)
{
throw exp;
}
}
// Bind Designation BindDesignation_BL
#region [Bind Designation]
public DataSet BindDesignation_BL(EWA_Common ObjEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindDesignation_DL(ObjEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
// Bind Designation BindDesignationType_BL
#region [Bind Designation Type]
public DataSet BindDesignationType_BL()
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindDesignationType_DL();
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet BindAssigned_Subject_BL(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindAssigned_Subject_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Bind Subject
#region [Bind Subject]
public DataSet FatchSubject_BL(EWA_Common ObjEWA)
{
try
{
DL_Common ObjDL = new DL_Common();
DataSet ds = ObjDL.FetchSubject_DL(ObjEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet Deleteinstallment(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.Deleteinstallment(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet BindAcademicYear(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindAcademicYear(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet GetInstallmentData(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.GetInstallmentData(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet BindClassForinstallments(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindClasses(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet Bind_AdmissionCompleted_BL(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.Bind_AdmissionCompleted_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet BindStudentAttendance_BL(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindStudentAttendance_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet BindResultFormat_BL(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindResultFormat_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Bind University
#region [Bind University]
public DataSet BL_BindUniversity()
{
try
{
DL_Common ObjDL = new DL_Common();
DataSet ds = ObjDL.DL_BindUniversity();
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
// Bind Courses BindFeesCategory_BL
#region [Bind FeesCategory]
public DataSet BindFeesCategory_BL(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindFeesCategory_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//
//Added by Ashwini 9-OCT-2020
public DataSet InsertPromoteStudentData(EWA_Admission objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.InsertPromoteStudentData(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Added by Ashwini 23-Oct-2020
public DataSet GetStudentListFilterWise(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.GetStudentListFilterWise(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//
//Added by Ashwini 28-sep-2020
public DataSet Bind_Route(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.BindBusRoute_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//
//Added by Ashwini 30-sep-2020
public DataSet CheckAllotBus(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.CheckAllotBus(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//
//Added by Ashwini 26-sep-2020
public DataSet GetBusFeesDetails(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.GetBusFeesDetails(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
// Bind Staff Names
#region [BIND Staff Names]
public DataSet BindFacultyName(EWA_Common objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.DL_BindFacultyName(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet BindFeeStructure(EWA_Common objEWA)
{
DataSet ds = null;
DL_Common ObjDL = new DL_Common();
try
{
ds = ObjDL.BindFeeStructure(objEWA);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
// Bind Staff List
#region [BIND Staff List]
public DataSet BindStaffList_BL(EWA_Common objEWA)
{
DataSet ds = null;
DL_Common ObjDL = new DL_Common();
try
{
ds = ObjDL.BindStaffList_DL(objEWA);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
private DataTable BindBranch_Grid(string courseid)
{
DataSet ds = new DataSet();
try
{
EWA_Common objEWA = new EWA_Common();
DL_Common objDL = new DL_Common();
objEWA.CourseId = courseid;
ds = objDL.BindBranch_DL(objEWA);
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
return(ds.Tables[0]);
}
//To Bind StudentGridBind for route
#region [Student Grid Bind For route]
public DataSet BindStudentForRoute_BL(EWA_Common objEWA)
{
DL_Common objDL = new DL_Common();
try
{
DataSet ds = objDL.BindStudentForRoute_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
objDL = null;
}
}
public DataSet SaveInstallment(EWA_Common objEWA)
{
DL_Common objDL = new DL_Common();
DataSet ds = new DataSet();
try
{
ds = objDL.SaveInstallments(objEWA);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDL = null;
}
}
//Bind Branch
#region [Bind Branch]
private void BindBranch(DropDownList ddlCourse)
{
try
{
EWA_Common objEWA = new EWA_Common();
DL_Common objDL = new DL_Common();
objEWA.CourseId = ddlCourse.SelectedValue.ToString();
DataSet ds = objDL.BindBranch_DL(objEWA);
ddlBranch.DataSource = ds;
ddlBranch.DataTextField = "BranchName";
ddlBranch.DataValueField = "BranchId";
ddlBranch.DataBind();
ddlBranch.Items.Insert(0, new ListItem("Select", "-1"));
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
