public ActionResult LogOut()
{
try
{
if (Session["LoginHistoryID"] != null)
{
#region SEC_LoginHistory Update
using (DB_A157D8_AnjaliMISEntities1 db = new DB_A157D8_AnjaliMISEntities1())
{
Int32 id = Convert.ToInt16(Session["LoginHistoryID"].ToString());
SEC_LoginHistory sEC_LoginHistory = db.SEC_LoginHistory.Find(id);
db.Entry(sEC_LoginHistory).State = EntityState.Modified;
sEC_LoginHistory.Modified = DateTime.Now;
sEC_LoginHistory.LogoutTime = DateTime.Now;
sEC_LoginHistory.Remarls = "Logout..";
db.SaveChanges();
}
#endregion SEC_LoginHistory Update
}
}
catch (Exception ex)
{
}
FormsAuthentication.SignOut();
Session.Clear();
Session.Abandon(); // it will clear the session at the end of request
return(RedirectToAction("index"));
}
public ActionResult DeleteConfirmed(int id)
{
SEC_LoginHistory sEC_LoginHistory = db.SEC_LoginHistory.Find(id);
db.SEC_LoginHistory.Remove(sEC_LoginHistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "LoginHistoryID,UserID,LoginTime,LogoutTime,Created,Remarls,Modified")] SEC_LoginHistory sEC_LoginHistory)
{
if (ModelState.IsValid)
{
db.Entry(sEC_LoginHistory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", sEC_LoginHistory.UserID);
return(View(sEC_LoginHistory));
}
// GET: SEC_LoginHistory/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SEC_LoginHistory sEC_LoginHistory = db.SEC_LoginHistory.Find(id);
if (sEC_LoginHistory == null)
{
return(HttpNotFound());
}
return(View(sEC_LoginHistory));
}
// GET: SEC_LoginHistory/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SEC_LoginHistory sEC_LoginHistory = db.SEC_LoginHistory.Find(id);
if (sEC_LoginHistory == null)
{
return(HttpNotFound());
}
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", sEC_LoginHistory.UserID);
return(View(sEC_LoginHistory));
}
public ActionResult Login(LoginViewModal objUser)
{
if (ModelState.IsValid)
{
using (DB_A157D8_AnjaliMISEntities1 db = new DB_A157D8_AnjaliMISEntities1())
{
var obj = db.SEC_User.Where(a => a.UserName.Equals(objUser.UserName) && a.Password.Equals(objUser.Password) && a.IsActive == true).FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.UserID.ToString();
Session["UserName"] = obj.UserName.ToString();
#region SEC_LoginHistory
SEC_LoginHistory sEC_LoginHistory = new SEC_LoginHistory();
sEC_LoginHistory.Created = DateTime.Now;
sEC_LoginHistory.Modified = DateTime.Now;
sEC_LoginHistory.LoginTime = DateTime.Now;
sEC_LoginHistory.LogoutTime = DateTime.Now;
sEC_LoginHistory.Remarls = "Login..";
if (Session["UserID"] != null)
{
sEC_LoginHistory.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
if (ModelState.IsValid)
{
db.SEC_LoginHistory.Add(sEC_LoginHistory);
db.SaveChanges();
if (sEC_LoginHistory.LoginHistoryID > 0)
{
Session["LoginHistoryID"] = sEC_LoginHistory.LoginHistoryID.ToString();
}
}
#endregion SEC_LoginHistory
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Enter valid Credentials..");
}
}
}
return(View(objUser));
}
