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());
}
}
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();
}
}
}
}
