protected void Application_Start(object sender, EventArgs e) { using (var context = new ExampleDBEntities()) { using (var contextTransaction = context.Database.BeginTransaction()) { try { if (!context.Logins.Any(m => m.Username.Equals("admin"))) { context.Logins.Add(new Login { Username = "******", Password = "******", UpdatedDate = DateTime.Now }); context.SaveChanges(); contextTransaction.Commit(); } } catch (Exception) { contextTransaction.Rollback(); } } } }
public ActionResult Login(string txtUser, string txtPassword) { try { using (ExampleDBEntities bd = new ExampleDBEntities()) { var oUser = (from d in bd.Users where d.email == txtUser.Trim() && d.password == txtPassword.Trim() select d).FirstOrDefault(); //retornar el elemento o null if (oUser == null) { ViewBag.Error = "Username or password is not valid."; return(View()); } Session["txtUser"] = oUser; } return(RedirectToAction("Index", "Home")); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View()); } }