public JsonResult SelectQualification()
{
StudentRepository _objNationality = new StudentRepository();
DataSet ds = _objNationality.select_form_load_student();
List <ProgramLevels> _ProgramLevel = new List <ProgramLevels>();
if (ds != null)
{
if (ds.Tables[3].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[3].Rows)
{
ProgramLevels _obj = new ProgramLevels();
_obj.ProgramLevel_Id = (row["ProgramLevel_Id"].ToString());
_obj.ProgramLevel = row["ProgramLevel"].ToString();
_ProgramLevel.Add(_obj);
}
}
}
return(Json(new
{
List = _ProgramLevel
},
JsonRequestBehavior.AllowGet
));
}
public void selectDropdown()
{
StudentRepository _objNationality = new StudentRepository();
DataSet ds = _objNationality.select_form_load_student();
List <ProgramLevels> _ProgramLevels = new List <ProgramLevels>();
List <Country> _Country = new List <Country>();
List <mCourseOfStudy> _Course = new List <mCourseOfStudy>();
if (ds != null)
{
if (ds.Tables[4].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[4].Rows)
{
Country _objcountry = new Country();
_objcountry.Country_id = (row["Country_id"].ToString());
_objcountry.Country_Name = row["Country_Name"].ToString();
_objcountry.country_code = row["country_code"].ToString();
_Country.Add(_objcountry);
}
}
if (ds.Tables[5].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[5].Rows)
{
ProgramLevels _objpro = new ProgramLevels();
_objpro.ProgramLevel_Id = (row["ProgramLevel_Id"].ToString());
_objpro.ProgramLevel = row["ProgramLevel"].ToString();
_ProgramLevels.Add(_objpro);
}
}
if (ds.Tables[6].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[6].Rows)
{
mCourseOfStudy _objpro = new mCourseOfStudy();
_objpro.CourseOfStudy_ID = (row["CourseOfStudy_ID"].ToString());
_objpro.CourseOfStudy = row["CourseOfStudy"].ToString();
_Course.Add(_objpro);
}
_Course.Add(new mCourseOfStudy {
CourseOfStudy_ID = "0", CourseOfStudy = "Other"
});
}
}
ViewBag.ProgramLevels = _ProgramLevels;
ViewBag.Country = _Country;
ViewBag.Course = _Course;
}
public void SelectDropdown()
{
Descipline obj = new Descipline();
DisciplineRepository _objNationality = new DisciplineRepository();
DataSet ds = _objNationality.Select_decipline("1");
List <Descipline> _Descipline = new List <Descipline>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Descipline _objDescipline = new Descipline();
_objDescipline.Discipline_ID = (row["Discipline_ID"].ToString());
_objDescipline.Discipline = row["Discipline"].ToString();
_Descipline.Add(_objDescipline);
}
}
}
ProgramLevels objpro = new ProgramLevels();
ProgramLevelsRepository _objpro = new ProgramLevelsRepository();
DataSet ds1 = _objpro.Select_ProgramLevel("1");
List <ProgramLevels> _ProgramLevels = new List <ProgramLevels>();
if (ds1 != null)
{
if (ds1.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds1.Tables[0].Rows)
{
ProgramLevels _objProgramLevels = new ProgramLevels();
_objProgramLevels.ProgramLevel_Id = (row["ProgramLevel_Id"].ToString());
_objProgramLevels.ProgramLevel = row["ProgramLevel"].ToString();
_ProgramLevels.Add(_objProgramLevels);
}
}
}
CurrencyRepository _objRepo = new CurrencyRepository();
DataSet dsContry = _objRepo.select_Currency();
List <Currency> _ListCurrency = new List <Currency>();
if (dsContry != null)
{
if (dsContry.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dsContry.Tables[0].Rows)
{
Currency _objcont = new Currency();
_objcont.Currency_Id = row["Currency_Id"].ToString();
_objcont.CurrencyCode = row["CurrencyCode"].ToString();
_objcont.CurrencyName = row["CurrencyName"].ToString();
_ListCurrency.Add(_objcont);
}
}
}
ViewBag.Currency = _ListCurrency;
ViewBag.Descipline = _Descipline;
ViewBag.ProgramLevels = _ProgramLevels;
}
