/// <summary>
/// Get Login User Common Info
/// </summary>
/// <param name="userLoginDal"></param>
/// <returns></returns>
public UserAccountModels GetLoginUserList(UserAccountModels userLoginDal)
{
var s = (from l in _context.SodUsersInfo
where l.UserName == userLoginDal.UserName && l.Password == userLoginDal.Password
orderby l.UserName
select new
{
l.DepartmentId,
l.DesignationId,
l.UserName,
l.EmpCode
}).ToList();
var lst = new UserAccountModels();
if (s.Count > 0)
{
lst = new UserAccountModels
{
DepartmentId = s[0].DepartmentId,
DesignationId = s[0].DesignationId,
UserName = s[0].UserName,
EmpCode = s[0].EmpCode
};
}
return(lst);
}
/// <summary>
/// Reset Password
/// </summary>
/// <param name="userLoginDal"></param>
/// <returns></returns>
public int ResetPassword(UserAccountModels userLoginDal)
{
var s = 0;
using (_context)
{
var result = from u in _context.SodUsersInfo
where (u.UserName == userLoginDal.UserName) && (u.Password == userLoginDal.OldPassword)
select u;
if (result.Count() == 1)
{
var dbuser = result.First();
dbuser.Password = userLoginDal.Password;
s = _context.SaveChanges();
}
}
return(s);
}
public ActionResult UpdatePassword(FormCollection frm)
{
var userAccountModel = new UserAccountModels
{
UserName = Session["user"].ToString().Trim(),
Password = frm["txtcfpwd"],
OldPassword = frm["txtoldpwd"]
};
int?s = _userAccountRepository.ResetPassword(userAccountModel);
if (s > 0)
{
return(RedirectToAction("UserAccount"));
}
else
{
ViewBag.LoginFailMessage = "Error : Invalid Reset Password.";
return(View("ChangePassword"));
}
}
public ActionResult ValidateLogin(FormCollection form)
{
var userAccountModel = new UserAccountModels
{
UserName = form["username"],
Password = form["password"]
};
var userList = _userAccountRepository.GetLoginUserList(userAccountModel);
if (userList.UserName != null)
{
//Store Login Data in Session
Session["user"] = userAccountModel.UserName.Trim().ToUpper();
Session["DesignationId"] = userList.DesignationId;
Session["DepartmentId"] = userList.DepartmentId;
Session["EmpId"] = userList.EmpCode;
if (form["username"].Equals("admin"))
{
Session["formtype"] = "Admin";
return(RedirectToAction("Index", "Admin"));
}
else if (userList.DepartmentId.Equals(108))
{
Session["formtype"] = "Revenue";
return(RedirectToAction("BookingList", "Revenue"));
}
else if (userList.DepartmentId.Equals(109))
{
Session["formtype"] = "Helpdesk";
return(RedirectToAction("bklist", "hd"));
}
else if (userList.DepartmentId.Equals(110))
{
Session["formtype"] = "Traveldesk";
return(RedirectToAction("hotelList", "trns"));
}
else if (userList.DepartmentId.Equals(111))
{
Session["formtype"] = "Billingdesk";
return(RedirectToAction("blist", "billing"));
}
else if (userList.DepartmentId.Equals(112))
{
Session["formtype"] = "Financedesk";
return(RedirectToAction("finlist", "finance"));
}
else if (userList.DepartmentId.Equals(113))
{
Session["formtype"] = "TraveldeskAdmin";
return(RedirectToAction("hotelList", "trns"));
}
else if (userList.DepartmentId.Equals(114))
{
Session["formtype"] = "OATTraveldesk";
return(RedirectToAction("flist", "Oat"));
}
else if (userList.DepartmentId.Equals(115))
{
Session["formtype"] = "OATBillingdesk";
return(RedirectToAction("oatblist", "billing"));
}
else
{
Session["formtype"] = "User";
return(RedirectToAction("SearchFlight", "User"));
}
}
else
{
ViewBag.LoginFailMessage = "Invalid Login-id or Password.";
return(View("UserAccount"));
}
}
/// <summary>
/// Count User List in Login Db
/// </summary>
/// <param name="userLoginDal"></param>
/// <returns></returns>
public int GetUserLoginInfo(UserAccountModels userLoginDal)
{
var count = _context.SodUsersInfo.Count(u => u.UserName == userLoginDal.UserName && u.Password == userLoginDal.Password);
return(count);
}
