public ActionResult RemoveUni(UniModel m)
{
if (m.UNI_NAME == null)
{
ViewBag.EmptyFields = "Must not leave any University entry fields blank. Try again.";
return(View("DeleteUni", m));
}
grabFromDB DB = new grabFromDB();
if (DB.getUniversities().Count == 1)
{
ViewBag.InvalidUni = "Cannot delete the last university in the database. Try Again.";
return(View("DeleteUni", m));
}
if (DB.getUniversitiesByName(m.UNI_NAME).Count != 1)
{
ViewBag.InvalidUni = "This university does not exist in the database. Try Again.";
return(View("DeleteUni", m));
}
else
{
DB.removeUniversityByName(m.UNI_NAME);
ViewBag.ReturnValue = "University successfully removed.";
return(View("AdminPage"));
}
}
internal UniModel ConvertToUniModel(DataTable dt, DataTable dtB)
{
UniModel CUni = new UniModel();
DataRow dr = dt.Rows[0];
CUni.UniId = Convert.ToInt32(dr["UniId"]);
CUni.Adres = Convert.ToString(dr["adres"]);
CUni.AnabilimDali = Convert.ToInt32(dr["AnabilimDali"]);
CUni.ArsGorevlisi = Convert.ToInt32(dr["ArsGorevlisi"]);
CUni.ArsUygMer = Convert.ToInt32(dr["ArsUygMer"]);
CUni.aWeb = Convert.ToString(dr["aWeb"]);
CUni.BirOgr = Convert.ToInt32(dr["BirOgr"]);
CUni.Bolge = Convert.ToString(dr["Bolge"]);
CUni.Bolum = Convert.ToInt32(dr["Bolum"]);
CUni.Docent = Convert.ToInt32(dr["Docent"]);
CUni.Doktora = Convert.ToInt32(dr["Doktora"]);
CUni.Enstitu = Convert.ToInt32(dr["Enstitu"]);
CUni.EPosta = Convert.ToString(dr["EPosta"]);
CUni.Fakulte = Convert.ToInt32(dr["Fakulte"]);
CUni.Fax = Convert.ToString(dr["Fax"]);
CUni.IkiOgr = Convert.ToInt32(dr["IkiOgr"]);
CUni.isDevlet = Convert.ToInt32(dr["isDevlet"]);
CUni.Kurulus = Convert.ToString(dr["Kurulus"]);
CUni.MYO = Convert.ToInt32(dr["MYO"]);
CUni.OgrGorevlisi = Convert.ToInt32(dr["OgrGorevlisi"]);
CUni.Okutman = Convert.ToInt32(dr["Okutman"]);
CUni.Prof = Convert.ToInt32(dr["Prof"]);
CUni.Program = Convert.ToInt32(dr["Program"]);
CUni.Sehir = Convert.ToString(dr["Sehir"]);
CUni.Tel = Convert.ToString(dr["Tel"]);
CUni.Uni = Convert.ToString(dr["Uni"]);
CUni.Uzman = Convert.ToInt32(dr["Uzman"]);
CUni.web = Convert.ToString(dr["web"]);
CUni.Ydocent = Convert.ToInt32(dr["Ydocent"]);
CUni.YuksekLisans = Convert.ToInt32(dr["YuksekLisans"]);
CUni.Yuksekokul = Convert.ToInt32(dr["Yuksekokul"]);
CUni.Bolumler = (from rw in dtB.AsEnumerable()
select new UniBolum()
{
bId = Convert.ToInt32(rw["BolumId"]),
Ad = Convert.ToString(rw["Bolum"]),
Fak = Convert.ToString(rw["Fakulte"]),
PT = Convert.ToString(rw["PuanTuru"]),
DV = Convert.ToString(rw["Aciklama"]),
SR = Convert.ToInt32(rw["BasariSirasi"]),
EKP = Convert.ToDecimal(rw["EnKck"]),
Kontenjan = Convert.ToInt32(rw["Kontenjan"]),
Kosullar = Convert.ToString(rw["Kosullar"]),
SU = Convert.ToInt32(rw["SU"]),
BK = Convert.ToString(rw["BK"])
}).ToList <UniBolum>();
return(CUni);
}
public ActionResult UniEntry(UniModel m)
{
//check for blank entries
if (m.UNI_NAME == null || m.City == null || m.Prov_State == null || m.Country == null)
{
ViewBag.EmptyFields = "Must not leave any University entry fields blank. Try again.";
return(View("AddUni", m));
}
if (m.UNI_NAME.Length > 100)
{
ViewBag.InvalidUni = "University name too long. Try again.";
return(View("AddUni", m));
}
if (m.City.Length > 100)
{
ViewBag.InvalidCity = "City name too long. Try again.";
return(View("AddUni", m));
}
//check for two letter province
if (m.Prov_State.Length != 2)
{
ViewBag.IncorectProv = "Province must be two letters. AB, BC, ect. Try Again.";
return(View("AddUni", m));
}
if (m.Country.Length > 100)
{
ViewBag.IncorrectCountry = "Country name too long.";
return(View("AddUni", m));
}
grabFromDB DB = new grabFromDB();
if (DB.getUniversitiesByName(m.UNI_NAME).Count != 0)
{
ViewBag.InvalidUni = "This university has already been entered. Try again.";
return(View("AddUni", m));
}
else
{
DB.insertUniversity(m.UNI_NAME, m.City, m.Prov_State, m.Country);
ViewBag.ReturnValue = "University successfully added.";
return(View("AdminPage"));
}
}
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));
}
public ActionResult DeleteUni()
{
UniModel model = new UniModel();
return(View("DeleteUni", model));
}
public ActionResult AddUni()
{
UniModel model = new UniModel();
return(View("AddUni", model));
}
