public IActionResult Keys()
{
IEnumerable <KeyViewModel> keys = null;
UserLogViewModel userModel = null;
userid = HttpContext.Session.GetString(key: sessionUserid);
var responseTask = client.GetAsync($"GetKeys/{userid}");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <IList <KeyViewModel> >();
readTask.Wait();
keys = readTask.Result;
}
else
{
keys = Enumerable.Empty <KeyViewModel>();
ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
}
var responseTask2 = client.GetAsync($"GetUserLog/{userid}");
responseTask2.Wait();
var result2 = responseTask2.Result;
var read2 = result2.Content.ReadAsAsync <UserLogViewModel>();
read2.Wait();
userModel = read2.Result;
var tupleData = new Tuple <IEnumerable <KeyViewModel>, UserLogViewModel>(keys, userModel);
return(View(tupleData));
}
public ActionResult LogIn(UserLogViewModel userAndPassword, string returnUrl)
{
if (myUserDAL.CheckUser(userAndPassword.User, userAndPassword.Password))
{
FormsAuthentication.SetAuthCookie(userAndPassword.User, false);
return(RedirectToAction("Index", "Home"));
}
return(View(userAndPassword));
}
public async Task SetUserLog(UserLogViewModel model)
{
try
{
//await db.UserLog.InsertOneAsync(model);
return;
}
catch
{
throw;
}
}
public async Task <UserLogViewModel> GetUserLog(string userid)
{
try
{
UserLogViewModel model = null;
return(model);
}
catch
{
throw;
}
}
public async Task SetUserLog(UserLogViewModel model)
{
try
{
db.UserLog.Add(model);
await db.SaveChangesAsync();
}
catch (Exception e)
{
throw e;
}
}
public ActionResult Registration(UserLogViewModel userAndPassword)
{
if (myUserDAL.RegistrationUser(userAndPassword.User, userAndPassword.Password))
{
FormsAuthentication.SetAuthCookie(userAndPassword.User, false);
return(RedirectToAction("Index", "Home"));
}
else
{
return(View(userAndPassword));
}
}
public async Task SetUserLog(UserLogViewModel model)
{
try
{
if (repository != null)
{
await repository.SetUserLog(model);
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult MyIndex([Bind(Include = "UserName, EndPoint, Date")] UserLogViewModel log)
{
ViewBag.UserName = HttpContext.User.Identity.Name;
if (ModelState.IsValid)
{
//from viewmodel to object
UserLog userLog = new UserLog { Date = DateTime.Parse(log.Date), EndPoint = log.EndPoint,
UserName = log.UserName };
_db.UserLogs.Add(userLog);
_db.Entry(log).State = EntityState.Added;
_db.SaveChanges();
}
return View();
}
public IActionResult Index()
{
var userLogList = _userLogService.GetUserLog(HttpContext.Connection.RemoteIpAddress.ToString());
List <UserLogViewModel> userLogViewList = new List <UserLogViewModel>();
foreach (var userLog in userLogList)
{
var userLogView = new UserLogViewModel {
IPAdress = userLog.IPAdress, AnagramList = userLog.AnagramWord, SearchedWord = userLog.SearchedWord, SearchTime = userLog.SearchTime
};
userLogViewList.Add(userLogView);
}
return(View(userLogViewList));
}
private void Form2_Load(object sender, EventArgs e)
{
try
{
LoadRows();
CheckExpirationDate();
CreateComboboxList();
UserLogViewModel uLogin = new UserLogViewModel();
uLogin = callWebApi.GetLastLogin();
loginInfo.Text = "Last Login ----> " + uLogin.LoginTime.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 设置操作数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="tName"></param>
/// <param name="fName"></param>
/// <param name="dType"></param>
/// <param name="sdata"></param>
/// <param name="chdata"></param>
/// <returns></returns>
public bool SetOprData <T>(string tName, string fName, string dType, T sdata, T chdata)
{
try {
var data = new UserLogViewModel <T>();
data.tableName = tName;
data.FieldName = fName;
data.dataType = dType;
data.sourceValue = sdata;
data.changeValue = chdata;
oprData = data.ToJson();
return(true);
}
catch
{
return(false);
}
}
public async Task <UserLogViewModel> GetUserLog(string userid)
{
try
{
UserLogViewModel model = new UserLogViewModel();
model = db.UserLog.OrderByDescending(x => x.LoginTime).Skip(1).FirstOrDefault(x => x.UserId == userid);
if (model == null)
{
return(null);
}
return(model);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Shows the user log view
/// </summary>
/// <returns></returns>
public ActionResult UserLog()
{
//connect to the db
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;
AttachDbFilename=C:\M183\M183\Database\SQLLoggingIntrusionDetection.mdf;
Integrated Security=True;Connect Timeout=30";
//get all userlogs
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "SELECT * " +
"FROM [dbo].[UserLog] ul " +
"JOIN [dbo].[User] u " +
"ON ul.UserId = u.Id " +
"ORDER BY ul.CreatedOn DESC";
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
List <UserLogViewModel> userLogViewModels = new List <UserLogViewModel>();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
//10 = id
//0 = log id
//7 = createdon
UserLogViewModel userLogViewModel = new UserLogViewModel();
userLogViewModel.UserId = sqlDataReader.GetValue(10).ToString();
userLogViewModel.LogId = sqlDataReader.GetValue(0).ToString();
userLogViewModel.LogCreatedOn = sqlDataReader.GetValue(7).ToString();
userLogViewModels.Add(userLogViewModel);
}
}
else
{
ViewBag.Message = "No results found!";
}
return(View(userLogViewModels));
}
public IActionResult LoginForm(UserLogViewModel model)
{
if (ModelState.IsValid)
{
User ReturnUser = _context.Users.SingleOrDefault(u => u.Email == model.Email);
if (ReturnUser != null)
{
if (model.Email != null && model.Password != null)
{
var Hasher = new PasswordHasher <UserLogViewModel>();
if (0 != Hasher.VerifyHashedPassword(model, ReturnUser.Password, model.Password))
{
HttpContext.Session.SetInt32("UserId", ReturnUser.UserId);
return(RedirectToAction("Dashboard", "Fruit"));
}
}
}
ViewBag.Login = "******";
return(View("Index"));
}
return(View("Index"));
}
public ActionResult Login(LoginViewModel model)
{
//HTTP POST
var postTask = client.PostAsJsonAsync <LoginViewModel>("Login", model);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
UserLogViewModel uLogin = new UserLogViewModel();
var responseTask2 = client.GetAsync($"GetUserID/{model.Email}");
responseTask2.Wait();
var result2 = responseTask2.Result;
var read2 = result2.Content.ReadAsAsync <string>();
read2.Wait();
userid = read2.Result;
HttpContext.Session.SetString(sessionUsername, userid);
uLogin.Username = model.Email;
uLogin.UserId = userid;
uLogin.Id = Guid.NewGuid().ToString();
uLogin.LoginTime = DateTime.Now;
var postTask3 = client.PostAsJsonAsync <UserLogViewModel>("SetUserLog", uLogin);
postTask3.Wait();
var result3 = postTask3.Result;
if (!result3.IsSuccessStatusCode)
{
_logger.LogInformation("Could not register the user log");
}
_logger.LogInformation("User Logged in");
return(RedirectToAction("Keys", "Key"));
}
return(View(model));
}
public async Task SetUserLog([FromBody] UserLogViewModel model)
{
//wait mangodb.GetUserID(username);
await sql.SetUserLog(model);
}
