/// <summary> /// /// </summary> /// <param name="loginInfo"></param> /// <returns></returns> public OperationResult Login(LoginInfo loginInfo) { PublicHelper.CheckArgument(loginInfo, "logininfo"); var user = SysUserRepository.Entities.SingleOrDefault( u => u.Account == loginInfo.Account || u.Email == loginInfo.Email); if (user == null) { return(new OperationResult(OperationResultType.QueryNull, "指定的账号不存在")); } if (user.Password != loginInfo.Password) { return(new OperationResult(OperationResultType.Warning, "登录密码不正确")); } var loginLog = new LoginLog { IpAddress = loginInfo.IpAddress, User = user }; LoginLogRepository.Insert(loginLog); return(new OperationResult(OperationResultType.Success, "登录成功", user)); }
/// <summary> /// 用户登录 /// </summary> /// <param name="loginInfo">登录信息</param> /// <returns>业务操作结果</returns> public OperationResult Login(LoginInfo loginInfo) { PublicHelper.CheckArgument(loginInfo, "loginInfo"); var user = UserRepository.Entities.SingleOrDefault(o => o.UserName == loginInfo.LoginName); if (user == null) { return(new OperationResult(OperationResultType.QueryNull, "指定账号的用户不存在。")); } if (!(user.Password.Compare(loginInfo.Password))) { return(new OperationResult(OperationResultType.Warning, "登录密码不正确。")); } LoginLog loginLog = new LoginLog { IpAddress = loginInfo.IpAddress, UserId = user.Id }; LoginLogRepository.Insert(loginLog); var info = new UserInfo() { UserName = user.UserName, Password = user.Password, NickName = user.NickName, Email = user.Email }; return(new OperationResult(OperationResultType.Success, "登录成功。", info)); }
public void Remove(int id) { LoginLog loginlog = db.LoginLogs.Find(id); db.LoginLogs.Remove(loginlog); db.SaveChanges(); }
public async Task <IActionResult> CheckIn([FromBody] CheckInOrOutModel model) { var result = new Result <string>(); try { var Org = _ablemusicContext.Org.FirstOrDefault(s => Math.Sqrt(Convert.ToDouble((s.LocaltionX - model.LocaltionX) * (s.LocaltionX - model.LocaltionX) + (s.LocaltionY - model.LocaltionY) * (s.LocaltionY - model.LocaltionY))) <= 0.003 ); if (Org == null) { throw new Exception("Check in failed. 你必须在校区列表里随便一个校区的300米内"); } var newLogLog = new LoginLog { UserId = model.UserId, LogType = 1, CreatedAt = DateTime.UtcNow.AddHours(12), OrgId = Org.OrgId }; _ablemusicContext.Add(newLogLog); await _ablemusicContext.SaveChangesAsync(); result.Data = "Check in successfully."; return(Ok(result)); } catch (Exception ex) { result.IsSuccess = false; result.ErrorMessage = ex.Message; return(BadRequest(result)); } }
/// <summary> /// 添加与编辑LoginLog记录 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="model">LoginLog表实体</param> /// <param name="content">更新说明</param> /// <param name="isCache">是否更新缓存</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Save(Page page, LoginLog model, string content = null, bool isCache = true, bool isAddUseLog = true) { try { //保存 model.Save(); //判断是否启用缓存 if (CommonBll.IsUseCache() && isCache) { SetModelForCache(model); } if (isAddUseLog) { if (string.IsNullOrEmpty(content)) { content = "{0}" + (model.Id == 0 ? "添加" : "编辑") + "LoginLog记录成功,ID为【" + model.Id + "】"; } //添加用户访问记录 UseLogBll.GetInstence().Save(page, content); } } catch (Exception e) { var result = "执行LoginLogBll.Save()函数出错!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } }
/// <summary> /// 通过sql语句和参数查询登陆日志的信息 /// </summary> /// <param name="sql"></param> /// <returns></returns> private static IList <LoginLog> GetAllLoginLogs(string sql, params SqlParameter [] para) { IList <LoginLog> ltLoginLog = new List <LoginLog>(); try { DataTable dt = DBHelper.GetDataSet(sql, para); foreach (DataRow row in dt.Rows) { LoginLog loginLog = new LoginLog(); loginLog.LoginId = Convert.ToInt32(row["LoginId"]); loginLog.User = UserService.GetUserById(row["UserId"].ToString()); loginLog.ExitTime = (DateTime)row["ExitTime"]; loginLog.LoginTime = (DateTime)row["LoginTime"]; loginLog.IfSuccess = Convert.ToInt32(row["ifSuccess"]); loginLog.LoginUserIp = Convert.ToString(row["LoginUserIp"]); loginLog.LoginDesc = Convert.ToString(row["LoginDesc"]); ltLoginLog.Add(loginLog); } return(ltLoginLog); } catch (Exception ex) { Console.WriteLine(ex.Message); throw ex; } }
/// <summary> /// 获取当前登入的日志数据 /// </summary> /// <param name="uername"></param> /// <param name="logintype"></param> public LoginLog GetLoginLogDetails(string uername, int logintype) { LoginLog detail = new LoginLog(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from Ecshop_LoginLog where MemberName = @username and LogType = @logtype"); this.database.AddInParameter(sqlStringCommand, "username", DbType.String, uername); this.database.AddInParameter(sqlStringCommand, "logtype", DbType.Int32, logintype); DataSet dtLoginlog = this.database.ExecuteDataSet(sqlStringCommand); if (dtLoginlog != null && dtLoginlog.Tables[0].Rows.Count > 0) { var table = dtLoginlog.Tables[0]; detail.MemberName = table.Rows[0]["MemberName"].ToString(); detail.LogType = !string.IsNullOrWhiteSpace(table.Rows[0]["LogType"].ToString()) ? Int32.Parse(table.Rows[0]["LogType"].ToString()) : -1; detail.LoginIP = table.Rows[0]["LoginIP"].ToString(); detail.ErrorCount = !string.IsNullOrWhiteSpace(table.Rows[0]["ErrorCount"].ToString()) ? Int32.Parse(table.Rows[0]["ErrorCount"].ToString()) : -1; detail.ID = !string.IsNullOrWhiteSpace(table.Rows[0]["ID"].ToString()) ? Int32.Parse(table.Rows[0]["ID"].ToString()) : -1; if (!string.IsNullOrWhiteSpace(table.Rows[0]["AddTime"].ToString())) { detail.AddTime = DateTime.Parse(table.Rows[0]["AddTime"].ToString()); } } else { detail.ID = -1; } return(detail); }
/// <summary> /// 获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <param name="isCache">是否从缓存中读取</param> /// <returns>DataAccess.Model.LoginLog</returns> public DataAccess.Model.LoginLog GetModel(long id, bool isCache = true) { //判断是否使用缓存 if (CommonBll.IsUseCache() && isCache) { //从缓存中获取List var list = GetList(); if (list == null || list.Count == 0) { return(null); } else { //在List查询指定主键Id的记录 return(list.SingleOrDefault(x => x.Id == id)); } } else { //从数据库中直接读取 var model = LoginLog.SingleOrDefault(x => x.Id == id); if (model == null) { return(null); } else { //对查询出来的实体进行转换 return(Transform(model)); } } }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <returns>DataAccess.Model.LoginLog</returns> public DataAccess.Model.LoginLog GetModelForCache(long id) { try { //从缓存中读取指定Id记录 var model = GetModelForCache(x => x.Id == id); if (model == null) { //从数据库中读取 var tem = LoginLog.SingleOrDefault(x => x.Id == id); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取LoginLog表记录时出现异常", e); return(null); } }
public async Task <IActionResult> PutLoginLog([FromRoute] int id, [FromBody] LoginLog loginLog) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != loginLog.LoginLogId) { return(BadRequest()); } _context.Entry(loginLog).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LoginLogExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult GetLogList(LoginLog logmodel) { var result = db.Queryable <LoginLog>().Where(it => it.Login_ID == logmodel.Login_ID).ToList(); var temp = new Tuple <int, List <LoginLog> >(result.Count, result); return(JsonResult <LoginLog>(temp)); }
/// <summary> /// 用户登录 /// </summary> /// <param name="loginInfo">登录信息</param> /// <returns>业务操作结果</returns> public virtual OperationResult Login(LoginInfo loginInfo, string CheckCode, ref SystemUser user) { try { PublicHelper.CheckArgument(loginInfo, "loginInfo"); if (loginInfo.CheckCode.ToUpper() != CheckCode.ToUpper()) { return(new OperationResult(OperationResultType.QueryNull, "验证码输入有误。")); } user = SysUserRepository.Entities.SingleOrDefault(m => m.UserName == loginInfo.Account || m.Email == loginInfo.Account); if (user == null) { return(new OperationResult(OperationResultType.QueryNull, "指定账号的用户不存在。")); } if (user.Password != loginInfo.Password) { return(new OperationResult(OperationResultType.Warning, "登录密码不正确。")); } LoginLog loginLog = new LoginLog { IpAddress = loginInfo.IpAddress, SystemUserID = user.Id }; LoginLogRepository.Insert(loginLog); return(new OperationResult(OperationResultType.Success, "登录成功。", user)); } catch (Exception ex) { return(new OperationResult(OperationResultType.QueryNull, ex.Message.ToString()));; } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(LoginLog model) { using (DBHelper db = DBHelper.Create()) { db.Insert <LoginLog>(model); } }
public async Task <ActionResult> VerifyCode(VerifyCodeViewModel model) { if (!ModelState.IsValid) { return(View(model)); } // The following code protects for brute force attacks against the two factor codes. // If a user enters incorrect codes for a specified amount of time then the user account // will be locked out for a specified amount of time. // You can configure the account lockout settings in IdentityConfig var result = await SignInManager.TwoFactorSignInAsync(model.Provider, model.Code, isPersistent : model.RememberMe, rememberBrowser : model.RememberBrowser); switch (result) { case SignInStatus.Success: LoginLog.CreateLoginLog(model.Email, true, UserManager); return(RedirectToLocal(model.ReturnUrl)); case SignInStatus.LockedOut: return(View("Lockout")); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid code."); LoginLog.CreateLoginLog(model.Email, false, UserManager); return(View(model)); } }
public async Task <ActionResult> ExternalLoginCallback(string returnUrl) { var loginInfo = await AuthenticationManager.GetExternalLoginInfoAsync(); if (loginInfo == null) { return(RedirectToAction("Login")); } // Sign in the user with this external login provider if the user already has a login var result = await SignInManager.ExternalSignInAsync(loginInfo, isPersistent : false); switch (result) { case SignInStatus.Success: LoginLog.CreateLoginLog(loginInfo.Email, true, UserManager); return(RedirectToLocal(returnUrl)); case SignInStatus.LockedOut: return(View("Lockout")); case SignInStatus.RequiresVerification: return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = false })); case SignInStatus.Failure: default: // If the user does not have an account, then prompt the user to create an account ViewBag.ReturnUrl = returnUrl; ViewBag.LoginProvider = loginInfo.Login.LoginProvider; LoginLog.CreateLoginLog(loginInfo.Email, false, UserManager); return(View("ExternalLoginConfirmation", new ExternalLoginConfirmationViewModel { Email = loginInfo.Email })); } }
public Tuple <int, List <LoginLog> > GetLoginlog(LoginLog model) { using (UnitOfWork dal = new UnitOfWork(new CoreDbContext())) { var loginRepository = dal.GetRepository <LoginLog>(); var conditions = ExpandHelper.True <LoginLog>(); if (!string.IsNullOrEmpty(model.LoginName)) { conditions = conditions.And(a => a.LoginName.Contains(model.LoginName)); } if (!string.IsNullOrEmpty(model.LoginNicker)) { conditions = conditions.And(a => a.LoginNicker.Contains(model.LoginNicker)); } var logmodel = loginRepository.Get(filter: conditions); var count = logmodel.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); logmodel = logmodel.OrderSort(column.data, item.dir); } } var result = logmodel.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <LoginLog> >(count, result)); } }
public ResultData LoginAPI(string Username, string Password, string Token) { ResultData result = new ResultData(); var ACT_Tocken = "DFG5DF65GFGD5TERTB6FZZSFREGCV546"; var key = "shdfg2323g3g4j3879sdfh2j3237w8eh"; try { if (Username != null && Password != null && !Username.Equals("") && !Password.Equals("") && Token == ACT_Tocken) { User newuser = iuser.getUserbyUsername(Username); if (newuser != null) { var newPassword = AesOperaions.DecryptString(key, newuser.u_password); if (Password.ToString().Equals(newPassword.ToString())) { newuser.u_password = null; string JsonStr = JsonConvert.SerializeObject(newuser); //HttpContext.Session.SetString("User", JsonStr); LoginLog loginLog = new LoginLog(); loginLog.ll_cre_by = newuser.u_id; loginLog.ll_login_time = DateTime.Now; loginLog.ll_cre_date = DateTime.Now; loginLog.ll_cre_by_name = newuser.u_name; iLoginLog.Add(loginLog); result.successData = newuser; result.Message = "Success"; result.hasError = false; } else { result.Message = "User Name and Password are incorrect!!!"; result.successData = null; result.hasError = true; } } else { result.Message = "User Name and Password are incorrect!!!"; result.successData = null; result.hasError = true; } } else { result.Message = "User Name and Password are incorrect!!!"; result.successData = null; result.hasError = true; } } catch (Exception ex) { result.Message = ex.Message; // result.Message = "User Name and Password are incrrect!!!"; result.successData = null; result.hasError = true; } return(result); }
public static int Insert(LoginLog loginLog) { int id = 0; try { db = EnterpriseLibraryContainer.Current.GetInstance <Database>("LogDB"); DbCommand cmd = db.GetStoredProcCommand("LoginLogInsert"); db = AddParam(db, cmd, loginLog); db.ExecuteNonQuery(cmd); Object obj = db.GetParameterValue(cmd, "Id"); if (obj != null) { int.TryParse(obj.ToString(), out id); } } catch (Exception ex) { throw ex; } return(id); }
public ActionResult Login(LoginModel model) { var user = UserService.Login(model.User, model.Password); var log = new LoginLog { CreateTime = DateTime.Now, IDUser = user == null ? -1 : user.ID, LoginName = model.User, IsPass = (user != null), IP = GetIP() }; UserService.Log(log); if (user != null) { this.SetCurrentUser(user); return(RedirectToAction("Index", "tree")); } else { ModelState.AddModelError("msg", "用户名或密码不正确."); return(View(model)); } }
public void Login() { Validate(); if (IsValid) { var passwordHash = this.getMd5Hash(this.Password); var hasUser = db.User.Any(u => u.UserName.ToLower() == this.UserName.ToLower() && u.Password == passwordHash); if (!hasUser) { this.Message = "Sikertelen bejelentkezés, hibás adatok!"; this.MsgVisible = true; } else { //TODO:Egy komplex user objektum tárolása célszerűbb lenne var userId = db.User.First(u => u.UserName == this.UserName).UserId; Application.Current.Properties["userId"] = userId; this.Message = "Sikeres bejelentkezés!"; this.MsgVisible = true; var log = new LoginLog() { UserId = userId, DateTime = DateTime.Now }; db.LoginLog.Add(log); db.SaveChanges(); new LoginWPF.View.LogList().Show(); Application.Current.MainWindow.Close(); } } }
/// <summary> /// 根据条件查询登录日志信息 /// </summary> /// <param name="demandType">查询类型(实体类中的所有属性选其一)</param> /// <param name="demandContent">查询参数(要查询的条件参数)</param> /// <returns></returns> public static LoginLog GetLoginLogByConn(string demandType, string demandContent) { LoginLog obj = LoginLog_Service.GetLoginLogByConn(demandType, demandContent); obj.GetPersonageInfo = PersonageInfo_Manager.GetPersonageInfoByConn("P_LoginName", obj.P_LoginName); return(obj); }
public ResponseLoginDTO Login(RequestLoginDTO dto) { using (var db = new DBEntities()) { var password = StringEncrypt.EncryptWithMD5(dto.Password); var model = db.Users.Where(t => t.Password == password && t.UserID == dto.UserID && !t.IsDeleted).FirstOrDefault(); if (model != null) { model.UserToken = Guid.NewGuid().ToString("N"); model.LastTime = DateTime.Now; LoginLog log = new LoginLog() { LogID = Guid.NewGuid().ToString("N"), LoginAccount = model.UserID, LoginName = model.UserName, LoginTime = model.LastTime.Value.ToString("yyyy-MM-dd HH:mm:ss") }; db.LoginLogs.Add(log); db.SaveChanges(); return(new ResponseLoginDTO() { UserToken = model.UserToken }); } return(null); } }
public static LoginLog getUserLastLoginLog(int user_id) { LoginLog login_log = null; MySqlConnection conn = new MySqlConnection(Config.sqlUrl); conn.Open(); String sql = "select * from login_log where user_id=@user_id order by id desc;"; MySqlCommand comm = new MySqlCommand(sql, conn); comm.Parameters.Add("user_id", user_id); MySqlDataReader sdr = comm.ExecuteReader(); bool flag = false; sdr.Read(); if (sdr.Read()) { login_log = new LoginLog(); login_log.id = sdr.GetInt32("id"); login_log.user_id = sdr.GetInt32("user_id"); login_log.ip = sdr.GetString("ip"); login_log.time = sdr.GetDateTime("time"); } sdr.Close(); comm.Clone(); conn.Close(); return(login_log); }
/// <summary> /// 记录登录日志 /// </summary> /// <param name="account"></param> /// <param name="timestamp"></param> /// <returns></returns> public bool SaveSysLoginLog(string account, string timestamp) { long timestampLong = 0; if (!long.TryParse(timestamp, out timestampLong)) { return(false); } try { LoginLog log = new LoginLog() { AccountNo = account, OccureTime = DateTime.Now, UserHostAddress = WebHelper.UserHostAddress, SessionId = WebHelper.SessionId, IntTimeStamp = timestampLong }; return(new LoginLogR().Insert(log) > 0); } catch (Exception ex) { return(false); } }
protected void btnLogin_Click(object sender, System.EventArgs e) { // 判断是登入日志信息 logdetail = EventLogs.GetLoginLogDetails(txtUserName.Text.Trim(), 3); // 没有日志数据 if (logdetail.ID == -1) { CurrLogin(); } else { // 在一个小时内登入错误次数大于5 int time = 0; TimeSpan a = DateTime.Now - logdetail.AddTime.Value; time = a.Hours; if (logdetail.ErrorCount >= 5 && time < 1) { this.ShowMessage("登入错误超过5次,一个小时后才能登入或通过忘记密码重新登入", false); currFlag.Value = "No"; } else { CurrLogin(); } } }
public static bool insert(LoginLog login_log) { if (login_log == null) { return(false); } try { MySqlConnection conn = new MySqlConnection(Config.sqlUrl); conn.Open(); String sql = "insert into login_log (user_id, ip, time) values (@user_id,@ip,@time)"; MySqlCommand comm = new MySqlCommand(sql, conn); comm.Parameters.Add("user_id", login_log.user_id); comm.Parameters.Add("ip", login_log.ip); comm.Parameters.Add("time", login_log.time); comm.ExecuteNonQuery(); comm.Clone(); conn.Close(); } catch { return(false); } return(true); }
public static void Log(LoginLog log) { using (var conn = Database.GetConn()) { conn.Insert(log); } }
public ResponseMessageWrap <int> Update([FromBody] LoginLog loginLog) { return(new ResponseMessageWrap <int> { Body = LoginLogService.Update(loginLog) }); }
public ActionResult GetErrorList(LoginLog logmodel) { var basePath = System.Web.HttpContext.Current.Server.MapPath("~/log"); var strArray = Directory.GetFiles(basePath); var result = new List <dynamic>(); foreach (var item in strArray) { dynamic dyfileinfo = new ExpandoObject(); var file = new DirectoryInfo(item); dyfileinfo.filePath = file.FullName; dyfileinfo.fileName = file.Name; result.Add(dyfileinfo); } result = result.OrderByDescending(a => a.fileName).ToList(); result = result.Skip(logmodel.pageIndex).Take(logmodel.pageSize).ToList(); var strjson = SerializeObject(new ResultEntity { recordsFiltered = strArray.Count(), recordsTotal = strArray.Count(), dataList = result }); return(Content(strjson)); }
public ResponseMessageWrap <int> Insert([FromBody] LoginLog loginLog) { return(new ResponseMessageWrap <int> { Body = LoginLogService.Insert(loginLog) }); }
/// <summary> /// 用户登录 /// </summary> /// <param name="loginInfo">登录信息</param> /// <returns>业务操作结果</returns> public virtual OperationResult Login(LoginInfo loginInfo) { PublicHelper.CheckArgument(loginInfo, "loginInfo"); Users member = MemberRepository.Entities.SingleOrDefault(m => m.UserName == loginInfo.Account || m.Memberships .Email == loginInfo.Account); if (member == null) { return new OperationResult(OperationResultType.QueryNull, "指定账号的用户不存在。"); } if (member.Memberships.Password != loginInfo.Password) { return new OperationResult(OperationResultType.Warning, "登录密码不正确。"); } LoginLog loginLog = new LoginLog { IpAddress = loginInfo.IpAddress, Member = member }; LoginLogRepository.Insert(loginLog); return new OperationResult(OperationResultType.Success, "登录成功。", member); }
public void CreateLoginLog(LoginLog loginlog) { db.LoginLogs.Add(loginlog); db.SaveChanges(); }
/// <summary> /// There are no comments for LoginLog in the schema. /// </summary> public void AddToLoginLog(LoginLog loginLog) { base.AddObject("LoginLog", loginLog); }
/// <summary> /// Create a new LoginLog object. /// </summary> /// <param name="loginLogID">Initial value of LoginLogID.</param> public static LoginLog CreateLoginLog(int loginLogID) { LoginLog loginLog = new LoginLog(); loginLog.LoginLogID = loginLogID; return loginLog; }
/// <summary> /// 用户登录 /// </summary> /// <param name="loginInfo"></param> /// <returns></returns> public virtual OperationResult Login(LoginInfo loginInfo) { User user = Users.SingleOrDefault(u=>u.UserName==loginInfo.Access||u.Email==loginInfo.Access);//用户名或邮箱登录 if (user == null) return new OperationResult(OperationResultType.QueryNull,"指定账号的用户不存在。"); if (user.Password != loginInfo.Password) return new OperationResult(OperationResultType.Error, "登录密码不正确。"); LoginLog loginLog = new LoginLog { IpAddress = loginInfo.IpAddress, User = user }; //To Do:写入数据库 return new OperationResult(OperationResultType.Success,"登录成功。",user); }