public LoginResultViewModel Login(LoginViewModel loginViewModel)
{
var result = new LoginResultViewModel();
var entity = _usersRepository.Login(loginViewModel.Identifier, loginViewModel.Credential.ToMd5());
result.Identifier = loginViewModel.Identifier;
result.User = _mapper.Map <UsersViewModel>(entity);
if (entity == null)
{
result.LoginSuccess = false;
result.Message = "Account or password wrong ";
result.Result = LoginResult.AccountOrPasswordWrong;
}
else
{
result.LoginSuccess = true;
}
var loginLog = new LoginLogs
{
UserId = entity?.Id,
LoginName = entity.Name,
IP = loginViewModel.IP,
LoginTime = DateTime.Now,
Message = result.Message
};
//增加日志
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
string str = string.Empty;
try
{
LoginLogs objLoginLogs = new LoginLogs();
LoginLogsRepository objLoginLogsRepository = new LoginLogsRepository();
List <LoginLogsTracker> lstLoginLogsTracker = objLoginLogsRepository.GetAllLoginLogsDetails();
foreach (LoginLogsTracker item in lstLoginLogsTracker)
{
try
{
str += "<tr class=\"gradeX\"><td><a href=\"UserLoginDetails.aspx?id=" + item._UserId + "\">" + item._UserName + "</a></td><td>" + item._count + "</td></tr>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Response.Write(str);
}
public List <LoginLogs> GetLoginLog()
{
string procName = "GetLoginLogs";
SqlDataReader reader = SQLHelper.GetDataReader(procName, null);
List <LoginLogs> list = new List <LoginLogs>();
while (reader.Read())
{
LoginLogs logs = new LoginLogs();
logs.LogId = Convert.ToInt32(reader["LogId"]);
if (string.IsNullOrEmpty(reader["ExitTime"].ToString()))
{
logs.ExitTime = null;
}
else
{
logs.ExitTime = Convert.ToDateTime(reader["ExitTime"]);
}
logs.LoginId = Convert.ToInt32(reader["LoginId"]);
logs.SPName = reader["SPName"].ToString();
logs.ServerName = reader["ServerName"].ToString();
logs.LoginTime = Convert.ToDateTime(reader["LoginTime"]);
list.Add(logs);
}
reader.Close();
return(list);
}
public int LoginLogsAdd(LoginLogs info)
{
string LogiAdd = $"insert into LoginLogs values('{info.IP}','{DateTime.Now}','{info.UserAgent}')";
return(sqlHelper.ExecuteNonQuery(LogiAdd));
}
public int WriteLoginLog(LoginLogs objLoginLog)
{
string sql = "insert into LoginLogs(LoginId, LoginName, ServerName, LoginTime) values(@LoginId,@LoginName,@LoginName,getdate());select @@identity;";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@LoginId", objLoginLog.LoginId),
new SqlParameter("@LoginName", objLoginLog.LoginName),
new SqlParameter("@ServerName", Dns.GetHostName())
};
return(Convert.ToInt32(Helper.SQLHelper.GetSingleResult(sql, param)));
}
public int WriteLoginLog(LoginLogs objLogin)
{
string sql = "insert into LoginLogs(LoginId,SPName,ServerName)values(@LoginId,@SPName,@ServerName);select @@identity";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@LoginId", objLogin.LoginId),
new SqlParameter("@SPName", objLogin.SPName),
new SqlParameter("@ServerName", objLogin.SPName),
};
return(Convert.ToInt32(SQLHelper.GetSingleResult(sql, param)));
}
/// <summary>
/// 写入登录日志，返回日志ID
/// </summary>
/// <param name="loginLog"></param>
/// <returns></returns>
public int WriteLoginLog(LoginLogs loginLog)
{
string sql = "INSERT INTO LoginLogs (LoginId,SPName,ServerName) VALUES (@LoginId,@SPName,@ServerName);SELECT @@IDENTITY";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@LoginId", loginLog.LoginId),
new SqlParameter("@SPName", loginLog.SPName),
new SqlParameter("@ServerName", loginLog.ServerName)
};
return(Convert.ToInt32(SqlHelper.GetSingleResult(sql, param)));
}
/// <summary>
/// 写入登录日志
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
private int WriteLoginLog(LoginLogs log)
{
string sql = "insert into LoginLogs (LoginId,LoginName,ServerName,LoginTime) values (@LoginId,@LoginName,@ServerName,@LoginTime);select @@identity;";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@LoginId", log.LoginId),
new SqlParameter("@LoginName", log.LoginName),
new SqlParameter("@ServerName", log.ServerName),
new SqlParameter("@LoginTime", log.LoginTime)
};
return(Convert.ToInt32(Helper.SqlHelper.GetSingleResult(sql, param)));
}
private void LoginUser(IUser userInfo)
{
ForumUtils.WriteUserCookie(userInfo.ID, TypeConverter.StrToInt(DNTRequest.GetString("expires"), -1), this.config.Passwordkey, DNTRequest.GetInt("templateid", 0), DNTRequest.GetInt("loginmode", -1));
this.oluserinfo = OnlineUsers.UpdateInfo(this.config.Passwordkey, this.config.Onlinetimeout, userInfo.ID, "");
this.olid = this.oluserinfo.Olid;
this.username = userInfo.Name;
this.userid = userInfo.ID;
this.usergroupinfo = UserGroup.FindByID(userInfo.GroupID);
this.useradminid = this.usergroupinfo.RadminID;
Utils.WriteCookie("bindconnect", "1");
OnlineUsers.UpdateAction(this.olid, UserAction.Login.ActionID, 0);
LoginLogs.DeleteLoginLog(DNTRequest.GetIP());
Users.UpdateUserCreditsAndVisit(userInfo.ID, DNTRequest.GetIP());
}
/// <summary>
/// 登录操作
/// </summary>
/// <param name="userInfo"></param>
private void LoginUser(ShortUserInfo userInfo)
{
#region 无延迟更新在线信息和相关用户信息
ForumUtils.WriteUserCookie(userInfo.Uid, TypeConverter.StrToInt(DNTRequest.GetString("expires"), -1),
config.Passwordkey, DNTRequest.GetInt("templateid", 0), DNTRequest.GetInt("loginmode", -1));
oluserinfo = OnlineUsers.UpdateInfo(config.Passwordkey, config.Onlinetimeout, userInfo.Uid, "");
olid = oluserinfo.Olid;
username = userInfo.Username;
userid = userInfo.Uid;
usergroupinfo = UserGroups.GetUserGroupInfo(userInfo.Groupid);
useradminid = usergroupinfo.Radminid; // 根据用户组得到相关联的管理组id
Utils.WriteCookie("bindconnect", "true"); //将当前登录用户是否绑定QQ互联的状态设置为true
OnlineUsers.UpdateAction(olid, UserAction.Login.ActionID, 0);
LoginLogs.DeleteLoginLog(DNTRequest.GetIP());
Users.UpdateUserCreditsAndVisit(userInfo.Uid, DNTRequest.GetIP());
#endregion
}
/// <summary>
/// 退出日志
/// </summary>
public void ExitLog(LoginLogs objLog)
{
string sql = "update LoginLogs set ExitTime=@ExitTime where LogId=@LogId";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ExitTime", SQLHelper.GetDBTime()),
new SqlParameter("@LogId", objLog.LogId)
};
try
{
SQLHelper.Update(sql, parameters);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="sp"></param>
/// <returns></returns>
public SalesPerson UserLogin(SalesPerson sp)
{
string sql = "select SalesPersonId,SalesPersonName from SalesPerson where SalesPersonId=@SalesPersonId and LoginPassword=@LoginPassword";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@SalesPersonId", sp.SalesPersonId),
new SqlParameter("@LoginPassword", sp.LoginPassword)
};
SqlDataReader reader = null;
try
{
reader = Helper.SqlHelper.GetReader(sql, param);
}
catch (Exception ex)
{
Helper.LogHelper.WriteLog(ex.Message);
throw ex;
}
if (reader.Read())
{
SalesPerson objSP = new SalesPerson()
{
SalesPersonName = reader["SalesPersonName"].ToString(),
SalesPersonId = Convert.ToInt32(reader["SalesPersonId"])
};
// 添加登录日志
LoginLogs log = new LoginLogs()
{
LoginId = objSP.SalesPersonId,
LoginName = objSP.SalesPersonName,
LoginTime = DateTime.Now,
ServerName = Dns.GetHostName()
};
objSP.LogId = WriteLoginLog(log);
return(objSP);
}
else
{
return(null);
}
}
/// <summary>
/// 管理员登录
/// </summary>
/// <param name="admins"></param>
/// <returns></returns>
public SysAdmins AdminLogin(SysAdmins admins)
{
admins = adminService.AdminLogin(admins);
if (admins != null && admins.AdminStatus == 1)
{
//登录成功日志记录
LoginLogs logInfo = new LoginLogs
{
LoginId = admins.LoginId,
SPName = admins.AdminName,
ServerName = Dns.GetHostName()
};
var logId = adminService.WriteToLoginLog(logInfo);
admins.LogId = logId;//为退出做准备
}
return(admins);
}
public async Task <LoginResponse> LoginAsync(LoginViewModel login, bool rememmeberMe, int expireDays = 20, HttpContext context = null)
{
return(await Task.Run(async() =>
{
LoginResponse response = new();
Users user = await _user.GetUserByEmailAsync(login.Email);
if (user != null)
{
if (await CheckPasswordAsync(user, login.Password))
{
Tokens token = await CreateTokenAsync(user, expireDays);
if (await _tokenCrud.InsertAsync(token) && await _tokenCrud.SaveAsync())
{
LoginLogs log = await CreateLogAsync(token, context);
await _logCrud.InsertAsync(log); await _logCrud.SaveAsync();
//Create Success Type
if (rememmeberMe)
{
response.Success = new Success
{
IsSucces = true,
Key = token.TokenKey,
Value = token.TokenValue
};
}
response.Status = LoginStatus.Success;
return response;
}
response.Status = LoginStatus.Exception;
return response;
}
response.Status = LoginStatus.WrongPassword;
return response;
}
response.Status = LoginStatus.UserNotFound;
return response;
}));
}
/// <summary>
/// 添加登录日志，返回日志编号
/// </summary>
/// <param name="logInfo"></param>
/// <returns></returns>
public int WriteLoginlog(LoginLogs logInfo)
{
string sql = "insert LoginLogs(LoginId, SPName, ServerName) values (@LoginId,@SPName,@ServerName);select @@identity";
SqlParameter[] salParameters = new SqlParameter[]
{
new SqlParameter("@LoginId", logInfo.LoginId),
new SqlParameter("@SPName", logInfo.SPName),
new SqlParameter("@ServerName", logInfo.ServerName),
};
try
{
return(Convert.ToInt32(SQLHelper.ExecuteScalar(sql, salParameters)));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 登录日志
/// </summary>
/// <param name="objLog"></param>
public void LoginLog(LoginLogs objLog)
{
//loginTime通过数据库中getdate方法获取数据库默认时间
string sql = "insert into LoginLogs ( LoginId, LoginName, ServerName) values(@LoginId, @LoginName, @ServerName);select @@identity";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@LoginId", objLog.LoginId),
new SqlParameter("@LoginName", objLog.LoginName),
new SqlParameter("@ServerName", objLog.ServerName)
//new SqlParameter("@LoginTime",objLog.LoginTime)
};
try
{
objLog.LogId = Convert.ToInt32(SQLHelper.GetSingleResult(sql, parameters));//获取当前登录时插入的LogId
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public SysAdmins AdminLogin(SysAdmins admin)
{
SysAdmins sys = adminServer.AdminLogin(admin);
if (sys != null && sys.AdminStatus == 1)
{
LoginLogs log = new LoginLogs()
{
Loginid = sys.LoginId,
SPName = sys.AdminName,
ServerName = Dns.GetHostName()
};
//保存当前管理员登录日志的ID
sys.LoginLogId = saleServer.WriteSalesLog(log);
}
else
{
sys = null;
}
return(sys);
}
/// <summary>
/// 日志记录返回本次日志的ID号
/// </summary>
/// <param name="logs"></param>
/// <returns></returns>
public int WriteSalesLog(LoginLogs logs)
{
string procName = "WriteLog";
SqlParameter[] sp =
{
new SqlParameter("@LoginId", SqlDbType.Int),
new SqlParameter("@SPName", SqlDbType.NVarChar,50),
new SqlParameter("@ServerName", SqlDbType.NVarChar, 50)
};
sp[0].Value = logs.LoginId;
sp[1].Value = logs.SPName;
sp[2].Value = logs.ServerName;
object res = SQLHelper.ExecuteScalar(procName, sp);
if (res == null)
{
return(-1);
}
return(int.Parse(res.ToString()));
}
/// <Add>
/// Add logging details of user
/// </Add>
/// <param name="loginLogs">Set Values in a LoginLogs Class Property and Pass the Object of LoginLogs Class (SocioBoard.Domain.LoginLogs).</param>
public void Add(LoginLogs loginLogs)
{
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to save details.
session.Save(loginLogs);
transaction.Commit();
} //End Transaction
} //End Session
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
}
/// <summary>
/// 管理员登录逻辑
/// </summary>
/// <param name="sys"></param>
/// <returns></returns>
public SysAdmins AdminLogin(SysAdmins admin)
{
SysAdmins sys = manager.AdminLogin(admin);
//管理员不是空，状态时启用状态
if (sys != null && sys.AdminStatus == 1)
{
//可以登录,写入日志
LoginLogs login = new LoginLogs()
{
LoginId = sys.LoginId,
SPName = sys.AdminName,
ServerName = Dns.GetHostName()
};
//记录日志
sys.LoginLogId = server.WriteSalesLog(login);
}
else
{
sys = null;
}
return(sys);
}
public SysAdmins AdminLogin(SysAdmins admins)
{
//根据用户账号和密码调用查询用户登录
SysAdmins sys = adminServer.AdminLogin(admins);
//判断管理员账号状态
if (sys != null && sys.AdminStatus == 1)
{
//写入日志
LoginLogs log = new LoginLogs()
{
LoginId = sys.LoginId,
SPName = sys.AdminName,
ServerName = Dns.GetHostName()
};
//保存当前管理员登录ID
sys.LoginLogId = saleServer.WriteSalesLog(log);
}
else
{
sys = null;
}
return(sys);
}
