public ActionResult GetUniType(int id)
{
UniPuanEntities1 uni = new UniPuanEntities1();
if (id != null)
{
var univer = (from c in uni.UP_ST_UNIVERSITY
where
c.UNITYPEID == id
select new UniData()
{
UNIVERSITYID = c.UNIVERSITYID, UNIVERSITYNAME = c.UNIVERSITYNAME
}).ToList();
return(Json(univer, JsonRequestBehavior.AllowGet));
}
else
{
var univer = (from c in uni.UP_ST_UNIVERSITY
select new UniData()
{
UNIVERSITYID = c.UNIVERSITYID, UNIVERSITYNAME = c.UNIVERSITYNAME
}).ToList();
return(Json(univer, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetCities(string id)
{
UniPuanEntities1 uni = new UniPuanEntities1();
if (id != null)
{
var idList = id.Split(',').Select(t => Convert.ToInt32(t));
var cities = (from c in uni.UP_ST_CITY
where
c.UP_ST_DEPARTMENT.Count(d => idList.Contains(d.DEPARTMENTID)) > 0
select new CityData()
{
CITYID = c.CITYID, CITYNAME = c.CITYNAME
}).ToList();
return(Json(cities, JsonRequestBehavior.AllowGet));
}
else
{
var cities = (from c in uni.UP_ST_CITY
select new CityData()
{
CITYID = c.CITYID, CITYNAME = c.CITYNAME
}).ToList();
return(Json(cities, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetDepartments(string id)
{
UniPuanEntities1 uni = new UniPuanEntities1();
if (id != null)
{
var cities = (from c in uni.UP_ST_PROGRAM
where
c.SCORETYPE == id
select new DepartmentData()
{
DEPARTMENTID = c.DEPARTMENTID, DEPARTMENTNAME = c.DEPARTMENTNAME
}).ToList();
return(Json(cities, JsonRequestBehavior.AllowGet));
}
else
{
var cities = (from d in uni.UP_ST_DEPARTMENT
select new DepartmentData()
{
DEPARTMENTID = d.DEPARTMENTID, DEPARTMENTNAME = d.DEPARTMENTNAME
}).ToList();
return(Json(cities, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetUnies(string id)
{
UniPuanEntities1 uni = new UniPuanEntities1();
if (id != null)
{
var idList = id.Split(',').Select(t => Convert.ToInt32(t));
var universities = (from u in uni.UP_ST_UNIVERSITY
where
uni.UP_ST_UNIVERSITY.Count(d => idList.Contains(u.CITYID)) > 0
select new UniData()
{
UNIVERSITYID = u.UNIVERSITYID, UNIVERSITYNAME = u.UNIVERSITYNAME
}).ToList();
return(Json(universities, JsonRequestBehavior.AllowGet));
}
else
{
var universities = (from c in uni.UP_ST_UNIVERSITY
select new UniData()
{
UNIVERSITYID = c.UNIVERSITYID, UNIVERSITYNAME = c.UNIVERSITYNAME
}).ToList();
return(Json(universities, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetUniversities(string id)
{
var idList = id.Split(',').Select(t => Convert.ToInt32(t));
UniPuanEntities1 uni = new UniPuanEntities1();
//var universities= uni.UP_ST_UNIVERSITY.Where(d=> d.CITYID.ToString()==id).ToList();
var unies = (from u in uni.UP_ST_UNIVERSITY
where
u.UP_ST_DEPARTMENT.Count(d => idList.Contains(d.DEPARTMENTID)) > 0
select new UniData()
{
UNIVERSITYID = u.UNIVERSITYID, UNIVERSITYNAME = u.UNIVERSITYNAME
}).ToList();
return(Json(unies, JsonRequestBehavior.AllowGet));
}
public static List <SelectListItem> DepListGonder()
{
UniPuanEntities1 uni = new UniPuanEntities1();
List <SelectListItem> listdep = new List <SelectListItem>();
foreach (var dep in uni.UP_ST_DEPARTMENT)
{
SelectListItem selectList = new SelectListItem()
{
Text = dep.DEPARTMENTNAME,
Value = dep.DEPARTMENTID.ToString(),
};
listdep.Add(selectList);
}
return(listdep);
}
public ActionResult SetProgram(string id, string name)
{
var idList = id.Split(',').Select(t => Convert.ToInt32(t));
UniPuanEntities1 uni = new UniPuanEntities1();
if (name == "Departments" || name == "secimd")
{
var dep = (from c in uni.UP_ST_DEPARTMENT
where
(idList.Contains(c.DEPARTMENTID))
select new ProgramData()
{
ID = c.DEPARTMENTID, NAME = c.DEPARTMENTNAME
}).ToList();
return(Json(dep, JsonRequestBehavior.AllowGet));
}
else if (name == "Cities" || name == "secimc")
{
var dep = (from c in uni.UP_ST_CITY
where
(idList.Contains(c.CITYID))
select new ProgramData()
{
ID = c.CITYID, NAME = c.CITYNAME
}).ToList();
return(Json(dep, JsonRequestBehavior.AllowGet));
}
else if (name == "Uni" || name == "secimu")
{
var dep = (from c in uni.UP_ST_UNIVERSITY
where
(idList.Contains(c.UNIVERSITYID))
select new ProgramData()
{
ID = c.UNIVERSITYID, NAME = c.UNIVERSITYNAME
}).ToList();
return(Json(dep, JsonRequestBehavior.AllowGet));
}
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult Search(string id, string name)
{
UniPuanEntities1 prgrm = new UniPuanEntities1();
if (name == "srchdep" || name == "srchdp")
{
var list = (from d in prgrm.UP_ST_DEPARTMENT
where
d.DEPARTMENTNAME.IndexOf(id) != -1
select new ProgramData()
{
ID = d.DEPARTMENTID, NAME = d.DEPARTMENTNAME
}).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
else if (name == "srchcity" || name == "srchcty")
{
var list = (from c in prgrm.UP_ST_CITY
where
c.CITYNAME.IndexOf(id) != -1
select new ProgramData()
{
ID = c.CITYID, NAME = c.CITYNAME
}).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
else if (name == "srchuni" || name == "srchun")
{
var list = (from u in prgrm.UP_ST_UNIVERSITY
where
u.UNIVERSITYNAME.IndexOf(id) != -1
select new ProgramData()
{
ID = u.UNIVERSITYID, NAME = u.UNIVERSITYNAME
}).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult Sonuclar(string scoretype, double?scoremin, double?order, string secimd_hd, string secimd_ud)
{
UniPuanEntities1 uni = new UniPuanEntities1();
List <ProgramData> listprgrm = new List <ProgramData>();
var gelenBolumler = secimd_hd.Split(',');
var gelenUniversiteler = secimd_ud.Split(',');
foreach (var prgrm in uni.UP_ST_PROGRAM)
{
ProgramData prm = new ProgramData();
if (scoremin == null || prgrm.SCOREMIN <= scoremin)
{
if (order == null || prgrm.ORDERR >= order)
{
if (scoretype == "" || prgrm.SCORETYPE == scoretype)
{
prm.SCOREMIN = prgrm.SCOREMIN;
prm.ORDERR = prgrm.ORDERR;
prm.SCORETYPE = prgrm.SCORETYPE;
prm.QUOTAS = prgrm.QUOTAS;
if (secimd_hd == "")
{
prm.DEPARTMENTNAME = prgrm.DEPARTMENTNAME;
if (secimd_ud == "")
{
prm.UNIVERSITYNAME = prgrm.UNIVERSITYNAME;
listprgrm.Add(prm);
}
else
{
foreach (var univ in gelenUniversiteler)
{
if (univ != "")
{
if (prgrm.UNIVERSITYID == Convert.ToInt32(univ))
{
prm.UNIVERSITYNAME = prgrm.UNIVERSITYNAME;
listprgrm.Add(prm);
}
}
}
}
}
else
{
foreach (var depart in gelenBolumler)
{
if (depart != "")
{
if (prgrm.DEPARTMENTID == Convert.ToInt32(depart))
{
prm.DEPARTMENTNAME = prgrm.DEPARTMENTNAME;
if (secimd_ud == "")
{
prm.UNIVERSITYNAME = prgrm.UNIVERSITYNAME;
listprgrm.Add(prm);
}
else
{
foreach (var univ in gelenUniversiteler)
{
if (univ != "")
{
if (prgrm.UNIVERSITYID == Convert.ToInt32(univ))
{
prm.UNIVERSITYNAME = prgrm.UNIVERSITYNAME;
listprgrm.Add(prm);
}
}
}
}
}
}
}
}
}
}
}
}
int uzunluk = listprgrm.Count();
UniModel uniViewModel = new UniModel()
{
Programs = listprgrm,
};
return(Json(listprgrm, JsonRequestBehavior.AllowGet));
}
public ActionResult TercihYap(Guid?SelectedPuan, string boxuni, string boxcity, string boxdep, string searchd, List <ProgramData> listprogram)
{
UniPuanEntities1 uni = new UniPuanEntities1();
ViewBag.SelectedPuan = new SelectList(uni.UP_ST_SCORETYPE, "SCORETYPEID", "SCORETYPENAME", SelectedPuan);
List <SelectListItem> listunitype = new List <SelectListItem>();
foreach (var type in uni.UP_ST_UNITYPE)
{
SelectListItem selectList = new SelectListItem()
{
Text = type.UNITYPENAME,
Value = type.UNITYPEID.ToString(),
};
listunitype.Add(selectList);
}
List <SelectListItem> listdep = new List <SelectListItem>();
foreach (var dep in uni.UP_ST_DEPARTMENT)
{
SelectListItem selectList = new SelectListItem()
{
Text = dep.DEPARTMENTNAME,
Value = dep.DEPARTMENTID.ToString(),
};
listdep.Add(selectList);
}
List <SelectListItem> listcity = new List <SelectListItem>();
foreach (var city in uni.UP_ST_CITY)
{
SelectListItem selectList = new SelectListItem()
{
Text = city.CITYNAME,
Value = city.CITYID.ToString(),
};
listcity.Add(selectList);
}
List <SelectListItem> listscoretype = new List <SelectListItem>();
foreach (var type in uni.UP_ST_SCORETYPE)
{
SelectListItem selectList = new SelectListItem()
{
Text = type.SCORETYPENAME,
Value = type.SCORETYPEID.ToString(),
};
listscoretype.Add(selectList);
}
List <SelectListItem> listuni = new List <SelectListItem>();
foreach (var univ in uni.UP_ST_UNIVERSITY)
{
SelectListItem selectList = new SelectListItem()
{
Text = univ.UNIVERSITYNAME,
Value = univ.UNIVERSITYID.ToString(),
};
listuni.Add(selectList);
}
List <string> listsec = new List <string>();
listsec.Add(boxdep);
List <string> listsct = new List <string>();
listsct.Add(boxcity);
List <string> listsun = new List <string>();
listsun.Add(boxuni);
if (listprogram == null)
{
listprogram = new List <ProgramData>();
}
UniModel uniViewModel = new UniModel()
{
Departments = listdep,
Cities = listcity,
Universities = listuni,
Unitypes = listunitype,
ScoreTypes = listscoretype,
SelectedDepartments = listsec,
SelectedCities = listsct,
SelectedUniversities = listsun,
Programs = listprogram
};
return(View(uniViewModel));
}
