// Bind Courses BindClass_BL
#region [Bind Courses]
public DataSet BindCourses_BL(EWA_SendSMS objEWA)
{
try
{
DL_SendSMS objDL = new DL_SendSMS();
DataSet ds = objDL.BindCourses_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
private void BindCourse()
{
try
{
EWA_SendSMS objEWA = new EWA_SendSMS();
BL_SendSMS objBL = new BL_SendSMS();
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"));
ddlDivision.Items.Clear();
ddlDivision.Items.Insert(0, new ListItem("---Select---", "0"));
GrdStudent.DataSource = ds.Tables[5];
GrdStudent.DataBind();
ViewState["PrintData"] = ds.Tables[5];
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
// Bind Courses BindCourses_DL
#region [Bind Course Region]
public DataSet BindCourses_DL(EWA_SendSMS ObjEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "FetchCourses";
prmList[2] = "@OrgId";
prmList[3] = ObjEWA.OrgId;
ds = ObjHelper.FillControl(prmList, "SP_SendSMS");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
