public FrmMain3(LoginHistoryModel _model)
{
loginObj = _model;
equipCode = loginObj.EquipCode;
counterId = loginObj.CounterCode;
InitializeComponent();
}
public ActionResult LoginHistory()
{
LoginHistoryModel model = new LoginHistoryModel();
var mongo = GetMongoDb();
IMongoCollection <Login> collection = mongo.GetCollection <Login>("EventStore.Common.Login");
var results = collection.FindAsync(x => x.Id != null);
results.Wait();
var docs = results.Result.ToListAsync();
docs.Wait();
model.Logins = docs.Result.ToList();
return(View(model));
}
public ActionResult LoginHistory(string userName, int?page)
{
LoginHistoryModel retVal = new LoginHistoryModel();
retVal.UserName = userName;
if (!string.IsNullOrEmpty(userName))
{
int currentPageIndex = 0;
if (page.HasValue)
{
currentPageIndex = page.Value - 1;
}
retVal.LoginHistory = new PagedList <LoginAttempt>(this.ServiceManager.UserService.GetLoginHistory(userName), currentPageIndex, Newhl.MainSite.Web.Models.PagedListModel <int> .PageSize);
}
return(this.View(retVal));
}
public List <LoginHistoryModel> SelectLogin()
{
string sql = "select *from LoginHistory ORDER BY CheckTime desc";
List <LoginHistoryModel> loginHistories = new List <LoginHistoryModel>();
SqlDataReader sdr = SQLHelper.ExecuteReader(sql);
if (sdr.HasRows)
{
while (sdr.Read())
{
LoginHistoryModel login = new LoginHistoryModel();
login.Adderss = sdr["Adderss"].ToString();
login.CheckTime = Convert.ToDateTime(sdr["CheckTime"]);
login.Type = sdr["Type"].ToString();
login.UserName = sdr["UserName"].ToString();;
login.Uid = Convert.ToInt32(sdr["Uid"]);
loginHistories.Add(login);
}
sdr.Close();
}
return(loginHistories);
}
public ActionResult TryLogin(UserModel loginInfo)
{
LoginHistoryModel loginHis = new LoginHistoryModel();
try
{
/*
* N 잘못된 ID
* P 잘못된 PW
* O OPT 발행
* X 잘못된 OPT 입력
* S 정상 로그인
*/
string tryID = loginInfo.login_id.Trim();
string tryPW = AESEncrypt.AESEncrypt256(loginInfo.login_pw, tryID);
loginHis.try_id = tryID;
loginHis.try_pw = tryPW;
loginHis.try_ip = CommonUtil.GetRemoteIP(this.Request);
loginHis.session_id = Session.SessionID;
if (tryID == "")
{
loginHis.login_st = "N";
throw new Exception("아이디가 입력되지 않았습니다.");
}
if (loginInfo.login_pw.Trim() == "")
{
loginHis.login_st = "P";
throw new Exception("비밀번호가 입력되지 않았습니다.");
}
UserModel user = Mapper.Instance().QueryForObject <UserModel>("User.selUser", loginInfo);
if (user == null || user.us_idx == null)
{
loginHis.login_st = "N";
throw new Exception("잘못된 접속 정보입니다.");
}
if (user.login_pw != tryPW)
{
loginHis.login_st = "P";
throw new Exception("잘못된 접속 정보입니다.");
}
loginHis.login_us = user.us_idx;
if (user.use_fl != "Y")
{
loginHis.login_st = "A";
throw new Exception("잘못된 접속 정보입니다.");
}
loginHis.login_st = "S";
Session["USER_IDX"] = user.us_idx;
Session["LOGIN_ID"] = user.login_id;
Session["USER_NM"] = user.us_nm;
Session["USER_POS"] = user.us_pos;
Session["USER_POS_NM"] = user.us_pos_nm;
Session["USER_GROUP_IDX"] = user.us_group;
Session["USER_GROUP_NM"] = user.us_group_nm;
Session["USER_ROLE"] = user.us_role;
Session["USER_ROLE_NM"] = user.us_role_nm;
Session["SESSION_ID"] = Session.SessionID;
Session["LANG_CD"] = loginInfo.langCd;
var userAuth = Mapper.Instance().QueryForList <AuthModel>("Auth.selAuthInfo", new AuthModel {
target_type = "U", target_idx = user.us_idx
});
var deptAuth = Mapper.Instance().QueryForList <AuthModel>("Auth.selAuthInfo", new AuthModel {
target_type = "D", target_idx = user.us_group
});
var roleAuth = Mapper.Instance().QueryForList <AuthModel>("Auth.selAuthInfo", new AuthModel {
target_type = "R", target_idx = (int)user.us_role
});
Hashtable authList = new Hashtable();
authList.Add("USER", userAuth);
authList.Add("DEPT", deptAuth);
authList.Add("ROLE", roleAuth);
Session["AUTH"] = authList;
return(Json(new { result = "Redirect", url = Url.Action("index", "Main") }));
}
catch (Exception ex)
{
logger.Error(string.Format("LOGIN ERROR -", loginHis.login_st), ex);
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
finally
{
loginHis.SetLoginHistory();
}
}
public JsonResult GetLoginHistory(LoginHistoryModel searchParam)
{
var LoginList = Mapper.Instance().QueryForList <LoginHistoryModel>("Log.selLoginHis", searchParam);
return(Json(LoginList));
}
