public JsonResult SelectDropdown_CourseType(string ID = "", string Discipline_ID = "", string ProgramLevel_Id = "", string Qualification_ID = "", string Type = "", string CourseOfStudy_ID = "", string InstituteType = "", string InstituteID = "", string GenderRestrictions = "")
{
NICHE objRep = new NICHE();
DataSet ds = objRep.sp_Select_tbl_InstituteCourse_Niche_Search(ID, Discipline_ID, "0", "0", "DropDown_List_Type", "0", "0", "", "0");
List <CourseType> _CourseType = new List <CourseType>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
CourseType _obj = new CourseType();
_obj.Id = (row["Id"].ToString());
_obj.Value = row["Value"].ToString();
_CourseType.Add(_obj);
}
}
}
string Code = string.Empty, Message = string.Empty;
return(Json(new
{
List = _CourseType,
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
//ViewBag.DesciplineNiche = _CourseType;
}
public JsonResult SelectQNiche(string ID = "", string Discipline_ID = "", string ProgramLevel_Id = "", string Qualification_ID = "", string Type = "", string CourseOfStudy_ID = "", string InstituteType = "", string InstituteID = "", string GenderRestrictions = "")
{
string Code = string.Empty, Message = string.Empty;
List <mQualification> _list = new List <mQualification>();
try
{
NICHE objRep = new NICHE();
DataSet _ds = objRep.sp_Select_tbl_InstituteCourse_Niche_Search(ID, Discipline_ID, ProgramLevel_Id, "0", "DropDown_List_Qualification", "0", InstituteType, "", "0");
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mQualification
{
Qualification_ID = _dr["Qualification_ID"].ToString(),
Qualification = _dr["Qualification"].ToString()
});
}
}
}
}
catch (NullReferenceException)
{
Code = "error";
Message = "Your session has been expired. Kindly refresh and try again.";
}
catch (Exception)
{
Code = "error";
Message = "Error from server side. Kindly refresh and try again.";
}
return(Json(new
{
List = _list,
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SelectCSNiche(string ID = "", string Discipline_ID = "", string ProgramLevel_Id = "", string Qualification_ID = "", string Type = "", string CourseOfStudy_ID = "", string InstituteType = "", string InstituteID = "", string GenderRestrictions = "")
{
string Code = string.Empty, Message = string.Empty;
List <mCourseOfStudy> _list = new List <mCourseOfStudy>();
try
{
NICHE objRep = new NICHE();
DataSet _ds = objRep.sp_Select_tbl_InstituteCourse_Niche_Search(ID, Discipline_ID, ProgramLevel_Id, Qualification_ID, "DropDown_List_CourseOfStudy", "0", InstituteType, "", "0");
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mCourseOfStudy
{
CourseOfStudy_ID = _dr["CourseOfStudy_ID"].ToString(),
CourseOfStudy = _dr["CourseOfStudy"].ToString()
});
}
}
}
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
return(Json(new
{
List = _list,
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
}
public void SelectDropdownNiche()
{
NICHE _objDiscipline = new NICHE();
DataSet ds = _objDiscipline.Select_Niche("Discipline");
List <Descipline> _Discipline = new List <Descipline>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Descipline _obj = new Descipline();
_obj.Discipline_ID = (row["Discipline_ID"].ToString());
_obj.Discipline = row["Discipline"].ToString();
_Discipline.Add(_obj);
}
}
}
ViewBag.DesciplineNiche = _Discipline;
}
public JsonResult SelectNicheCourse(string ID = "", string Discipline_ID = "", string ProgramLevel_Id = "", string Qualification_ID = "", string Type = "", string CourseOfStudy_ID = "", string InstituteType = "", string InstituteID = "", string Month_id = "", string Year_id = "", string GenderRestrictions = "")
{
NICHE objRep = new NICHE();
DataSet ds = objRep.sp_Select_tbl_InstituteCourse_Niche_Search(ID, Discipline_ID, ProgramLevel_Id, Qualification_ID, "AllNicheCourse", CourseOfStudy_ID, InstituteType, InstituteID, GenderRestrictions, Month_id, Year_id);
//List<NicheCourse> _list = new List<NicheCourse>();
List <InstituteSearchVM> _list = new List <InstituteSearchVM>();
List <Date> _listDT = new List <Date>();
List <Date> _listYr = new List <Date>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in ds.Tables[0].Rows)
{
NicheCourse objNicheCourse = new NicheCourse();
InstituteSearchVM _objResult = new InstituteSearchVM();
_objResult.InstituteID = _dr["InstituteID"].ToString();
_objResult.InstituteName = _dr["InstituteName"].ToString();
_objResult.Website = _dr["Website"].ToString();
_objResult.StateName = _dr["StateName"].ToString();
_objResult.City = _dr["City"].ToString();
_objResult.TotalCourse = _dr["TotalCourse"].ToString();
_objResult.TotalSeats = _dr["TotalSeats"].ToString();
_objResult.Photo = _dr["Photo"].ToString();
_objResult.Discipline = _dr["Discipline"].ToString();
_objResult.ProgramLevel = _dr["ProgramLevel"].ToString();
_objResult.Qualification = _dr["Qualification"].ToString();
_objResult.CourseOfStudy = _dr["CourseOfStudy"].ToString();
_objResult.ID = _dr["ID"].ToString();
_objResult.StartDate = _dr["StartDate"].ToString();
_objResult.EndDate = _dr["EndDate"].ToString();
_list.Add(_objResult);
}
}
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[1].Rows)
{
Date _obj = new Date();
_obj.Month_id = (row["Month_id"].ToString());
_obj.Month = row["Month"].ToString();
_listDT.Add(_obj);
}
}
if (ds.Tables[2].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[2].Rows)
{
Date _obj = new Date();
_obj.Year_id = (row["Year_id"].ToString());
_obj.Year = row["year"].ToString();
_listYr.Add(_obj);
}
}
}
return(Json(new
{
List = _list,
ListMonth = _listDT,
ListYear = _listYr,
},
JsonRequestBehavior.AllowGet
));
}
