public async Task <IActionResult> Edit(int id, [Bind("LoginTrailId,LogInId,LogInTime,LogOutTime")] LoginTrail loginTrail)
{
if (id != loginTrail.LoginTrailId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(loginTrail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LoginTrailExists(loginTrail.LoginTrailId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["LogInId"] = new SelectList(_context.Login, "LoginId", "LoginId", loginTrail.LogInId);
return(View(loginTrail));
}
public async Task <IActionResult> Create([Bind("LoginTrailId,LogInId,LogInTime,LogOutTime")] LoginTrail loginTrail)
{
if (ModelState.IsValid)
{
_context.Add(loginTrail);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["LogInId"] = new SelectList(_context.Login, "LoginId", "LoginId", loginTrail.LogInId);
return(View(loginTrail));
}
public ReturnBool LoginTrail_new(LoginTrail lt)
{
query = @" INSERT INTO login_trail (user_id,client_ip,client_os,client_browser, useragent)
VALUES (@user_id, @client_ip, @client_os, @client_browser, @useragent)";
MySqlParameter[] pr = new MySqlParameter[] {
new MySqlParameter("user_id", lt.User_Id),
new MySqlParameter("client_ip", lt.Client_Ip),
new MySqlParameter("client_os", lt.Client_Os),
new MySqlParameter("client_browser", lt.Client_Browser),
new MySqlParameter("useragent", lt.UserAgent)
};
rb = db.executeInsertQuery(query, pr);
return(rb);
}
public void fn_logintrail(bool flag)
{
LoginTrail lt1 = new LoginTrail();
HttpBrowserCapabilities browser = Request.Browser;
OperatingSystem os = Environment.OSVersion;
lt1.User_Id = txt_login.Text.Trim();
lt1.Client_Ip = util.GetClientIpAddress(this.Page);
lt1.UserAgent = Request.UserAgent;
if (lt1.UserAgent.Contains("Edge"))
{
lt1.Client_Browser = "Microsoft Edge " + browser.Version;
}
else
{
lt1.Client_Browser = browser.Type;
}
lt1.Client_Os = os.VersionString;
rb = dl.LoginTrail_new(lt1);
}
//[ValidateAntiForgeryToken]
public async Task <IActionResult> LoginUser(Dashboard dashboard)
{
//Check if model is valid
if (ModelState.IsValid)
{
//Get & store inputs
String inputUsername = HttpContext.Request.Form["Username"];
String inputPassword = HttpContext.Request.Form["Password"];
//Create String to store List of logins
String loginList = "";
//Create variables to store data
int employeeID = 0;
int loginID = 0;
DateTime loginDate = DateTime.Now;
bool isMatch = false;
String role = "";
//Store List of existing Login details
var loginDetails = from lD in _context.Login
select lD;
//Loop through List of existing login details
foreach (var login in loginDetails)
{
//Compare inputs
if (login.Username.ToString().Equals(inputUsername) &&
login.Password.ToString().Equals(inputPassword))
{
//Store data
employeeID = login.EmployeeId;
loginID = login.LoginId;
//Set boolean
isMatch = true;
/*
* //Print message
* return Content(LOG_TAG + ": Alright !" +
* "\nThe inputs and login details are equal" +
* "\nInputs" +
* "\n- Username: "******"\n- Password: "******"\nLogin Details" +
* "\n- Username: "******"\n- Password: "******"\n- Employee ID: " + login.EmployeeId +
* "\n- Login ID: " + login.LoginId
* );
*/
}
/*
* //Store logins
* loginList += "Employee ID: " + login.EmployeeId + ": " +
* "\n- Login ID: " + login.LoginId +
* "\n- Username: "******"\n- Password: "******"\n\n";
*/
}
//Check boolean value
if (isMatch == true)
{
//Set new values for login trails
var employeLoginTrail = new LoginTrail
{
LogInId = loginID,
LogInTime = loginDate
};
//Use context to add recored in login trails
_context.LoginTrail.Add(employeLoginTrail);
_context.SaveChanges();
//Store query
var employeeDetails = from emp in _context.Employees
join l in _context.Login
on emp.EmployeeId equals l.EmployeeId
where emp.EmployeeId == employeeID
select emp;
//Loop through List
foreach (var detail in employeeDetails)
{
//Check employee role
if (detail.UserRole.Equals("Admin"))
{
//Redirect to dashboard & pass employee ID
return(RedirectToAction("AdminDashboard", "Dashboard", new { id = employeeID }));
}
else if (detail.UserRole.Equals("Manager"))
{
//Redirect to dashboard & pass employee ID
return(RedirectToAction("ManagerDashboard", "Dashboard", new { id = employeeID }));
}
else if (detail.UserRole.Equals("Employee"))
{
//Redirect to dashboard & pass employee ID
return(RedirectToAction("EmployeeDashboard", "Dashboard", new { id = employeeID }));
}
/*
* //Print message
* return Content(LOG_TAG + ": Logged In Employee Details" +
* "\n- Role: " + detail.UserRole
* );
*/
}
}
else
{
//Print error
}
/*
* //Print message
* return Content(LOG_TAG + ": List of existing Login Details content" +
* "\n" + loginList
* );
*/
}
//Redirect to view
return(View("~/Views/Logins/Index.cshtml"));
}