public async Task TestCreateLogFail()
{
//Arrange
var userLog = new UsersLog()
{
UsersLogId = 1,
Description = "test",
LogType = LogType.ATTENDANCE_JOIN.ToString(),
RoomId = "1"
};
await _logDAO.CreateLog(userLog);
var userLog2 = new UsersLog()
{
UsersLogId = 1,
Description = "test",
LogType = LogType.ATTENDANCE_JOIN.ToString(),
RoomId = "1"
};
//Act
var result = await _logDAO.CreateLog(userLog2);
var list = await context.UserLog.ToListAsync();
//Assert
Assert.Contains("Error", result);
Assert.Single(list);
}
public static List <UsersLog> UsersLogList(int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string keyWords, int uid = -1)
{
string whereSql = " 1=1 ";
if (uid > -1)
{
whereSql += " and a.uid=" + uid + " ";
}
if (!string.IsNullOrEmpty(keyWords))
{
whereSql += " and (a.UserName like '%" + keyWords + "%' or a.mobile like'%" + keyWords + "%' or a.email like'%" + keyWords + "%') ";
}
string cstr = @" a.*,b.Email,b.UserName,b.mobile,b.nickname";
DataTable dt = CommonBusiness.GetPagerData("Owzx_UsersLog a left join owzx_users b on a.uid=b.uid ", cstr, whereSql, "a.Uid", pageSize, pageIndex, out totalCount, out pageCount);
List <UsersLog> list = new List <UsersLog>();
foreach (DataRow item in dt.Rows)
{
UsersLog model = new UsersLog();
model.FillData(item);
list.Add(model);
}
return(list);
}
public IHttpActionResult PutUsersLog(int id, UsersLog usersLog)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != usersLog.LogID)
{
return(BadRequest());
}
db.Entry(usersLog).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UsersLogExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task TestCreateLogSuccess(LogType logType)
{
//Arrange
var userLog = new UsersLog()
{
UserId = "1",
DateTime = DateTime.Parse("2020-02-02"),
Description = "test",
LogType = logType.ToString(),
RoomId = "1"
};
//Act
var result = await _logDAO.CreateLog(userLog);
var list = await context.UserLog.ToListAsync();
var justAdded = list[0];
//Assert
Assert.Contains("Success", result);
Assert.NotEmpty(list);
Assert.Equal("1", justAdded.UserId);
Assert.Equal(DateTime.Parse("2020-02-02"), justAdded.DateTime);
Assert.Equal("test", justAdded.Description);
Assert.Equal(logType.ToString(), justAdded.LogType);
Assert.Equal("1", justAdded.RoomId);
}
public JsonResult Login(string Username, string Password)
{
try
{
NLogLogger.LogInfo("Login-->Username:"******"Dữ liệu không được bỏ trống" }));
}
var password = Encrypt.Md5(Password.Trim());
int checkLogin = AbstractDAOFactory.Instance().CreateUsersDAO().Authentication(Username.Trim(), password);
if (checkLogin == -49)
{
return(Json(new { success = false, statusCode = -102, msg = "Tài khoản của bạn đã bị block" }));
}
else if (checkLogin == -50)
{
return(Json(new { success = false, statusCode = -102, msg = "Tài khoản của bạn chưa được cấp quyền" }));
}
else if (checkLogin == -53)
{
return(Json(new { success = false, statusCode = -102, msg = "Mật khẩu không chính xác" }));
}
else if (checkLogin > 0)
{
var m_Users = AbstractDAOFactory.Instance().CreateUsersDAO().GetByUsername(Username);
if (m_Users != null && m_Users.UserID > 0)
{
var Log = new UsersLog();
Log.ClientIP = Config.GetIP();
Log.FunctionID = 9999;
Log.UserID = m_Users.UserID;
Log.LogType = 1;
Log.FunctionName = "Đăng Nhập Hệ Thống";
Log.Description = "Tài khoản " + m_Users.Username + " Đăng nhập hệ thống";
var insertLog = AbstractDAOFactory.Instance().CreateUsersLogDAO().InsertUsersLog(Log);
if (m_Users.Status)
{
Session["LoginType"] = 1;
string SessionID = Session.SessionID;
m_UserValidation.SignIn(m_Users.UserID, m_Users.Username, m_Users.IsAdministrator, SessionID);
var UrlRedirect = Config.UrlRoot; // Session["Redirect_Uri"] == null ? Config.UrlRoot : Server.UrlDecode(Session["Redirect_Uri"].ToString());
NLogLogger.LogInfo("UrlRedirect : " + UrlRedirect);
return(Json(new { success = true, statusCode = 1, msg = "Đăng Nhập Thành Công", url = UrlRedirect }));
}
return(Json(new { success = false, statusCode = -102, msg = "Tài khoản của bạn đã bị block" }));
}
}
return(Json(new { success = false, statusCode = -1, msg = "Username hoặc Password không đúng" }));
}
catch (Exception ex)
{
NLogLogger.PublishException(ex);
return(Json(new { success = false, statusCode = -99, msg = "Hệ thống bận vui lòng quay lại sau" }));
}
}
public static void CreateUserLog(string page, int uid, string ipAddress)
{
Business.Interfaces.IUserLog _objIUserLog = new UserLog(new RentEntities());
// log active
Entities.UsersLog usersLog = new UsersLog();
usersLog.IpAddress = ipAddress;
usersLog.Uid = uid == 1 ? 1 : uid;
usersLog.Page = page;
_objIUserLog.Insert(usersLog);
}
protected void Page_Init(object sender, EventArgs e)
{
try
{
var account = new VTCeBank.SSO.Utils.Account(Request);
NLogLogger.LogInfo("account.AccountName: " + account.AccountName);
if (string.IsNullOrEmpty(account.AccountName))
{
// Response.Redirect(SSOMAIL.SsoHelper.URLLoginMail);
}
else
{
var pos = account.AccountName.IndexOf("@");
if (pos > 0)
{
account.AccountName = account.AccountName.Substring(0, pos);
}
var m_Users = AbstractDAOFactory.Instance().CreateUsersDAO().GetByUsername(account.AccountName);
if (m_Users != null && m_Users.UserID > 0)
{
var Log = new UsersLog();
Log.FunctionID = 9999;
Log.ClientIP = Config.GetIP();
Log.UserID = m_Users.UserID;
Log.LogType = 1;
Log.FunctionName = "Đăng Nhập Hệ Thống";
Log.Description = "Tài khoản " + m_Users.Username + " Đăng nhập hệ thống";
var insertLog = AbstractDAOFactory.Instance().CreateUsersLogDAO().InsertUsersLog(Log);
if (m_Users.Status)
{
//Session[SessionsManager.SESSION_USERID] = m_Users.UserID;
//Session[SessionsManager.SESSION_USERNAME] = m_Users.Username;
//Session["LoginType"] = 0;
string SessionID = Session.SessionID;
m_UserValidation.SignIn(m_Users.UserID, m_Users.Username, m_Users.IsAdministrator, SessionID);
Url = Session["Redirect_Uri"] == null ? UrlRoot : Server.UrlDecode(Session["Redirect_Uri"].ToString());
Response.Redirect(Url);
}
Response.Redirect("Common/ErrorPermission");
}
Response.Redirect("Common/ErrorPermission");
}
}
catch (Exception ex)
{
NLogLogger.PublishException(ex);
}
finally
{
Response.End();
}
}
/// <summary>
/// добавить строку в протокол
/// </summary>
/// <param name="botUserId"></param>
/// <param name="trueAns"></param>
/// <param name="askQuantity"></param>
/// <param name="trueAnsQuantity"></param>
/// <param name="askTxt"></param>
/// <param name="ansTxt"></param>
internal void AddToUsersLog(int botUserId, char trueAns, int askQuantity, int trueAnsQuantity, string askTxt, string ansTxt)
{
UsersLog usersLog = new UsersLog()
{
BotUserId = botUserId, TrueAns = trueAns, AskQuantity = askQuantity,
TrueAnsQuantity = trueAnsQuantity, AskTxt = askTxt, AnsTxt = ansTxt
};
data.GetTable <UsersLog>().InsertOnSubmit(usersLog);
data.SubmitChanges();
}
public IHttpActionResult GetUsersLog(int id)
{
UsersLog usersLog = db.UsersLog.Find(id);
if (usersLog == null)
{
return(NotFound());
}
return(Ok(usersLog));
}
public IHttpActionResult PostUsersLog(UsersLog usersLog)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.UsersLog.Add(usersLog);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = usersLog.LogID }, usersLog));
}
public ActionResult Authenticate(UsersLog user)
{
string result = "";
try
{
string pass = EncodePasswordMd5(user.Password);
M_Users check = (from c in db.M_Users
where c.UserName == user.UserName &&
c.Password == pass &&
c.IsDeleted == false
select c).FirstOrDefault();
if (check != null)
{
bool rememberme = false;
if (user.Rememberme)
{
rememberme = true;
}
System.Web.HttpContext.Current.Session["UserName"] = check.FirstName + ' ' + check.LastName;
System.Web.HttpContext.Current.Session["user"] = check;
FormsAuthentication.SetAuthCookie(user.UserName, true);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1,
user.UserName,
DateTime.Now,
DateTime.Now.AddMinutes(FormsAuthentication.Timeout.TotalMinutes),
rememberme,
user.ToString());
}
result = (check == null) ? "Failed" : "Success";
if (result == "Failed")
{
//Error_Logs error = new Error_Logs();
//error.PageModule = "Login";
//error.ErrorLog = "Incorrect Username or Password";
//error.DateLog = db.TT_GETTIME().FirstOrDefault();//DateTime.Now;;
//error.Username = user.UserName;
//db.Error_Logs.Add(error);
//db.SaveChanges();
}
string urlmail = (Session["urlmail"] != null) ? Session["urlmail"].ToString() : "/Home/Index";
return(Json(new { result = result, urlmail = urlmail }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { result = result, urlmail = "" }, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult DeleteUsersLog(int id)
{
UsersLog usersLog = db.UsersLog.Find(id);
if (usersLog == null)
{
return(NotFound());
}
db.UsersLog.Remove(usersLog);
db.SaveChanges();
return(Ok(usersLog));
}
public async Task <string> CreateLog(UsersLog usersLog)
{
try
{
await _context.UserLog.AddAsync(usersLog);
await _context.SaveChangesAsync();
return("Success at creating log " + usersLog.ToString());
}
catch (Exception ex)
{
return("Error at log " + usersLog.ToString());
}
}
/// <summary>
/// Ghi log
/// </summary>
/// <param name="logId"></param>
/// <param name="userId"></param>
/// <param name="functionId"></param>
/// <param name="desription"></param>
/// <param name="paygateName"></param>
/// <returns></returns>
public int InsertUsersLog(UsersLog log)
{
try
{
var pars = new SqlParameter[7];
pars[0] = new SqlParameter("@_UserID", log.UserID);
pars[1] = new SqlParameter("@_FunctionID", log.FunctionID);
pars[2] = new SqlParameter("@_FunctionName", log.FunctionName);
pars[3] = new SqlParameter("@_Description", log.Description);
pars[4] = new SqlParameter("@_LogType", log.LogType);
pars[5] = new SqlParameter("@_ClientIP", log.ClientIP);
pars[6] = new SqlParameter("@_ResponseCode", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
new DBHelper(Config.Site1400ConnectionString).ExecuteNonQuerySP("SP_UserLogs_Insert", pars);
return(Convert.ToInt32(pars[6].Value));
}
catch (Exception ex)
{
NLogLogger.LogInfo(ex.ToString());
return(-99);
}
}
public ActionResult Authenticate(UsersLog user)
{
string result = "";
db.Database.CommandTimeout = 0;
try
{
string pass = EncodePasswordMd5(user.Password);
M_Users check = (from c in db.M_Users
where c.UserName == user.UserName &&
c.Password == pass &&
c.IsDeleted == false
select c).FirstOrDefault();
check.CostCode = (from c in db.M_Employee_CostCenter where c.EmployNo == user.UserName orderby c.ID descending select c.CostCenter_AMS).FirstOrDefault();
string CostCodenow = check.CostCode;
check.Section = (from c in db.M_Cost_Center_List where c.Cost_Center == CostCodenow select c.GroupSection).FirstOrDefault();
if (check != null)
{
bool rememberme = false;
if (user.Rememberme)
{
rememberme = true;
}
string emailtemplatepath = Server.MapPath(@"~/Content/EmailForm/OTEmail.html");
System.Web.HttpContext.Current.Session["emailpath"] = emailtemplatepath;
System.Web.HttpContext.Current.Session["UserName"] = check.FirstName + ' ' + check.LastName;
System.Web.HttpContext.Current.Session["user"] = check;
FormsAuthentication.SetAuthCookie(user.UserName, true);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1,
user.UserName,
DateTime.Now,
DateTime.Now.AddMinutes(FormsAuthentication.Timeout.TotalMinutes),
rememberme,
user.ToString());
RefreshPageAccess(check.UserName, check.Section);
List <CostCenterM> newCostCode = (from c in db.M_Cost_Center_List where c.GroupSection == "" || c.GroupSection == null
select new CostCenterM {
CostCodenew = c.Cost_Center,
CostCodenewname = c.Section
}).ToList();
System.Web.HttpContext.Current.Session["newCostCode"] = newCostCode;
}
result = (check == null) ? "Failed" : "Success";
if (result == "Failed")
{
//Error_Logs error = new Error_Logs();
//error.PageModule = "Login";
//error.ErrorLog = "Incorrect Username or Password";
//error.DateLog = db.TT_GETTIME().FirstOrDefault();//DateTime.Now;;
//error.Username = user.UserName;
//db.Error_Logs.Add(error);
//db.SaveChanges();
}
string urlmail = (Session["urlmail"] != null) ? Session["urlmail"].ToString() : "/";
return(Json(new { result = result, urlmail = urlmail }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
Error_Logs error = new Error_Logs();
error.PageModule = "Login";
error.ErrorLog = err.Message;
error.DateLog = db.TT_GETTIME().FirstOrDefault();//DateTime.Now;;
error.Username = user.UserName;
db.Error_Logs.Add(error);
db.SaveChanges();
return(Json(new { result = result, urlmail = "" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// добавить строку в протокол
/// </summary>
/// <param name="usersLog"></param>
internal void AddToUsersLog(UsersLog usersLog)
{
data.GetTable <UsersLog>().InsertOnSubmit(usersLog);
data.SubmitChanges();
}
public async Task <string> CreateLog(UsersLog usersLog) => await Task.FromResult("true");
