public DataSet InstituteSearchForWebsite(InstituteSearchPara _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("InstituteSearchForWebsite", _cn);
_cmd.Parameters.AddWithValue("@Created_IP", _obj.Created_Ip);
_cmd.Parameters.AddWithValue("@Type", _obj.Type);
_cmd.Parameters.AddWithValue("@Discipline_ID", _obj.Discipline_ID);
_cmd.Parameters.AddWithValue("@ProgramLevel_Id", _obj.ProgramLevel_Id);
_cmd.Parameters.AddWithValue("@Qualification_ID", _obj.Qualification_ID);
_cmd.Parameters.AddWithValue("@CourseOfStudy_ID", _obj.CourseOfStudy_ID);
_cmd.Parameters.AddWithValue("@InstituteType", _obj.InstituteType);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_cmd.Parameters.AddWithValue("@ParticipatedYear", _obj.ParticipatedYear);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandTimeout = 180;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return(_ds);
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
}
}
public JsonResult SearchInstitutes(InstituteSearchPara _obj)
{
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
_obj.Created_Ip = localIP;
_obj.ParticipatedYear = ConfigurationManager.AppSettings["ParticipatedYear"].ToString();
InstituteSearchRepository _objRepository = new InstituteSearchRepository();
DataSet _ds = _objRepository.InstituteSearchForWebsite(_obj);
List <InstituteSearchVM> _list = new List <InstituteSearchVM>();
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
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();
_list.Add(_objResult);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public DataSet InstituteSearchForWebsite_New(InstituteSearchPara _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("InstituteSearchForWebsite_New", _cn);
_cmd.Parameters.AddWithValue("@Created_IP", _obj.Created_Ip);
_cmd.Parameters.AddWithValue("@Type", _obj.Type);
_cmd.Parameters.AddWithValue("@Discipline_ID", _obj.Discipline_ID);
_cmd.Parameters.AddWithValue("@ProgramLevel_Id", _obj.ProgramLevel_Id);
_cmd.Parameters.AddWithValue("@Qualification_ID", _obj.Qualification_ID);
_cmd.Parameters.AddWithValue("@CourseOfStudy_ID", _obj.CourseOfStudy_ID);
_cmd.Parameters.AddWithValue("@InstituteType", _obj.InstituteType);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_cmd.Parameters.AddWithValue("@ParticipatedYear", _obj.ParticipatedYear);
_cmd.Parameters.AddWithValue("@ID", _obj.ID);
_cmd.Parameters.AddWithValue("@City", _obj.City);
_cmd.Parameters.AddWithValue("@State", _obj.State);
_cmd.Parameters.AddWithValue("@Duration", _obj.Duration);
_cmd.Parameters.AddWithValue("@TopSearch", _obj.TopSearch);
if (_obj.StartDate != null)
{
if (_obj.StartDate.Equals(""))
{
_cmd.Parameters.AddWithValue("@StartDate", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@StartDate", DateTime.ParseExact(_obj.StartDate.ToString(), "dd/MM/yyyy", null));
}
}
else
{
_cmd.Parameters.AddWithValue("@StartDate", DBNull.Value);
}
if (_obj.EndDate != null)
{
if (_obj.EndDate.Equals(""))
{
_cmd.Parameters.AddWithValue("@EndDate", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@EndDate", DateTime.ParseExact(_obj.EndDate.ToString(), "dd/MM/yyyy", null));
}
}
else
{
_cmd.Parameters.AddWithValue("@EndDate", DBNull.Value);
}
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandTimeout = 180;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return(_ds);
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
}
}
public JsonResult SearchCourseList(InstituteSearchPara _obj)
{
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
_obj.Created_Ip = localIP;
_obj.ParticipatedYear = ConfigurationManager.AppSettings["ParticipatedYear"].ToString();
InstituteSearchRepository _objRepository = new InstituteSearchRepository();
DataSet _ds = _objRepository.InstituteSearchForWebsite_New(_obj);
List <InstituteSearchVM> _list = new List <InstituteSearchVM>();
List <InstituteSearchDropdowns> _listCity = new List <InstituteSearchDropdowns>();
List <InstituteSearchDropdowns> _listDiscipline = new List <InstituteSearchDropdowns>();
List <InstituteSearchDropdowns> _listCourseOfStudy = new List <InstituteSearchDropdowns>();
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
InstituteSearchVM _objResult = new InstituteSearchVM();
_objResult.ID = _dr["ID"].ToString();
_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.StartDate = Convert.ToDateTime(_dr["StartDate"].ToString()).ToString("dd-MM-yyyy");
_objResult.EndDate = Convert.ToDateTime(_dr["EndDate"].ToString()).ToString("dd-MM-yyyy");
_objResult.TotalFees = _dr["TotalFees"].ToString();
_objResult.TotalFeesCurrency = _dr["TotalFeesCurrency"].ToString();
_objResult.Photo = _dr["Photo"].ToString();
_list.Add(_objResult);
}
}
if (_ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[1].Rows)
{
_listCity.Add(new InstituteSearchDropdowns
{
Id = _dr["City"].ToString(),
Value = _dr["City"].ToString()
});
}
}
if (_ds.Tables[2].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[2].Rows)
{
_listDiscipline.Add(new InstituteSearchDropdowns
{
Id = _dr["Discipline_ID"].ToString(),
Value = _dr["Discipline"].ToString()
});
}
}
if (_ds.Tables[3].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[3].Rows)
{
_listCourseOfStudy.Add(new InstituteSearchDropdowns
{
Id = _dr["CourseOfStudy_ID"].ToString(),
Value = _dr["CourseOfStudy"].ToString()
});
}
}
}
return(Json(new
{
List = _list,
ListCity = _listCity,
ListDiscipline = _listDiscipline,
ListCourseOfStudy = _listCourseOfStudy
},
JsonRequestBehavior.AllowGet
));
}
