public ActionResult Errents() { using (var db = new projectdbEntities()) // Öppnar anslutning till databasen. { return(View(db.Errents.ToList())); } }
public ActionResult DeleteConfirmed(int?id) { var db = new projectdbEntities(); // Öppnar anslutning till databasen. Errents errent = db.Errents.Find(id); db.Errents.Remove(errent); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Index() { // Snabbt exempel Users user = new Users(); using (var db = new projectdbEntities()) // Öppnar anslutning till databasen. { return(View(db.Users.ToList())); } }
public ActionResult Edit([Bind(Include = "Assigned")] Errents errent) { if (ModelState.IsValid) { var db = new projectdbEntities(); // Öppnar anslutning till databasen. db.Entry(errent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Errents")); } return(View(errent)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var db = new projectdbEntities(); // Öppnar anslutning till databasen. Errents errent = db.Errents.Find(id); if (errent == null) { return(HttpNotFound()); } return(View(errent)); }
public ActionResult saveErrent(Errents model) { try { //Sparar ärende i databas. projectdbEntities db = new projectdbEntities(); Errents errent = new Errents(); errent.Name = model.Name; errent.Email = model.Email; errent.ErrentCathegory = model.ErrentCathegory; errent.Errent = model.Errent; db.Errents.Add(errent); db.SaveChanges(); int latestErrentId = model.id; //Mailar bekräftelse till den sm skickar in ärende. var fromAddress = new MailAddress(Secret.GetValues("username"), "CMS"); var toAddress = new MailAddress(errent.Email, errent.Name); string fromPassword = Secret.GetValues("password"); const string subject = "Vi har mottagit ditt ärende"; const string body = "Vi handlägger ditt ärende skyndsamt och återkommer till dig."; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, Credentials = new NetworkCredential(fromAddress.Address, fromPassword), Timeout = 20000 }; using (var message = new MailMessage(fromAddress, toAddress) { Subject = subject, Body = body }) { smtp.Send(message); } //S**t på mailfunktion } catch (Exception ex) { throw ex; } return(RedirectToAction("Index", "create")); }
public ActionResult Autherize(ProjectCMS.Models.Users users) { using (projectdbEntities db = new projectdbEntities()) { var userDeatails = db.Users.Where(x => x.Username == users.Username && x.Password == users.Password).FirstOrDefault(); if (userDeatails == null) { users.LoginErrorMessage = "Felaktiktigt användarnamn eller lösenord."; return(View("Index", users)); } else { Session["userId"] = userDeatails.UserId; Session["Username"] = userDeatails.Username; return(RedirectToAction("Errents", "Home")); } } }
public ActionResult createUser(Users model) { try { //Sparar ärende i databas. projectdbEntities db = new projectdbEntities(); Users user = new Users(); user.Username = model.Username; user.Password = model.Password; user.Email = model.Email; user.AccessId = model.AccessId; db.Users.Add(user); db.SaveChanges(); int latestUserId = model.UserId; } catch (Exception ex) { throw ex; } return(RedirectToAction("Index", "CreateUser")); }