public ActionResult Dersler(tblDersModel model) { WhereAUEntities db = new WhereAUEntities(); //model.BolumId= Bolum Id hep sıfır geliyor neden ? model.BolumList = db.tblBolumler.OrderBy(x => x.Name).Select(x => new SelectListItem() { Text = x.Name, Value = x.Id.ToString(), Selected = model.BolumId == x.Id ? true : false, }).ToList(); model.DersList = db.poolBolumDers.Where(x => x.FpoolfakultebolumID == model.BolumId).OrderBy(x => x.tblDersler.Name) .Select(x => new SelectListItem() { Text = x.tblDersler.Name, Value = x.tblDersler.Id.ToString(), }).ToList(); return(View(model)); }
public ActionResult Olustur(tblHocalar model) { WhereAUEntities db = new WhereAUEntities(); db.tblHocalar.Add(model); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Home /* public ActionResult Index() * { * var db = new WhereAUEntities(); * UniversityViewModel model = new UniversityViewModel(); * * * List<tblOkullar> okulList = db.tblOkullar.OrderBy(x => x.OkulName).ToList(); * List<poolOkulFakulte> okulunFakulteList = db.poolOkulFakulte.OrderBy(f => f.FFakulteID).ToList(); * // List<poolFakulteBolum> fakulteninBolumList = db.poolFakulteBolum.OrderBy(k => k.FBolumID).ToList(); * List<tblFakulteler> fakulteList = db.tblFakulteler.OrderBy(k => k.Id).ToList(); * * model.UniversiteList = (from s in okulList * select new SelectListItem * { * Text = s.OkulName, * Value = s.Id.ToString() * }).ToList(); * model.UniversiteList.Insert(0, new SelectListItem { Value = " ", Text = "Seçiniz", Selected = true }); * * * return View(model); * * } */ public ActionResult Anasayfa() { WhereAUEntities db = new WhereAUEntities(); var model = new HomePageViewModel(); model.Universiteler = db.tblOkullar.Select(x => new SelectListItem() { Text = x.OkulName, Value = x.Id.ToString() }).ToList(); return(View(model)); }
public ActionResult Anasayfa(HomePageViewModel model) { WhereAUEntities db = new WhereAUEntities(); var i = db.poolOkulFakulte.FirstOrDefault(); //Gereklimim kontro et ? model.Fakulteleri = db.poolOkulFakulte.OrderBy(x => x.tblFakulteler.Name).Where(x => x.FOkulID == model.SelectedUniId).Select(x => new SelectListItem() { Text = x.tblFakulteler.Name, Value = x.FFakulteID.ToString() }).ToList(); return(PartialView("OkulFakulteleriPartial", model)); }
public ActionResult Dersler() { WhereAUEntities db = new WhereAUEntities(); tblDersModel model = new tblDersModel(); List <tblBolumler> BolumList = db.tblBolumler.OrderBy(x => x.Name).ToList(); model.BolumList = (from s in BolumList select new SelectListItem { Text = s.Name, Value = s.Id.ToString(), }).ToList(); List <tblDersler> fakulteDersleri = new List <tblDersler>(); return(View(model)); }
public ActionResult Login(LoginModel model) { if (!ModelState.IsValid) { return(View("index", model)); } var db = new WhereAUEntities(); var user = db.tblAdminLogin.FirstOrDefault(x => x.kullaniciAdi == model.UserName && x.password == model.Password); if (user != null) { return(RedirectToAction("Index", "Home")); } return(View("index")); }