public ActionResult Authorize(Personel personelModel) { IsTakipEntities db = new IsTakipEntities(); var userdetails = db.Personels.Where(x => x.username == personelModel.username && x.password == personelModel.password).FirstOrDefault(); if (userdetails == null) { personelModel.LogErrorMessage = "Hatalı kullanıcı adı veya şifre"; return(View("Index", personelModel)); } else { Session["personelID"] = userdetails.PersonelID; Session["personelAdi"] = userdetails.PersonelAd; return(RedirectToAction("Index", "Home")); } }
public static bool isata(Isler isler) { IsTakipEntities db = new IsTakipEntities(); bool atandi = false; if (sayac == 6) { sayac = 1; } isler.Atanan = sayac; var atananperson = db.Personels.Where(x => x.PersonelID == sayac).FirstOrDefault(); isler.AtananIsim = atananperson.PersonelAd; atananperson.IsSayisi = atananperson.IsSayisi + 1; db.Islers.Add(isler); db.Database.ExecuteSqlCommand("update Personel set Durum = 1 where PersonelID=@p1", new SqlParameter("@p1", sayac)); db.SaveChanges(); sayac++; atandi = true; return(atandi); }