public HttpResponseMessage AddUserActivityLog(HttpRequestMessage reqObject) { int result = 0; _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedDataObject != null && _requestedDataObject.BusinessData != null) { _UserActivityLog = new UserActivityLog(); _UserActivityLog = JsonConvert.DeserializeObject <UserActivityLog>(_requestedDataObject.BusinessData); bool IsValid = ModelValidation.TryValidateModel(_UserActivityLog, out _modelErrorMsg); if (IsValid) { result = _IUserActivityLogService.AddUserActivityLog(_UserActivityLog); } } if (!string.IsNullOrWhiteSpace(_modelErrorMsg)) { _serviceResponse = _IDataManipulation.SetResponseObject(result, _modelErrorMsg); } else if (result == 1) { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been added successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been added"); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
public void Insert(UserActivityLog userActivityLog) { if (userActivityLog == null) { throw new BaseResultException { Code = MessageCode.DATA_VALIDATION_FAILED, ResultMessage = "数据不能为空" } } ; if (userActivityLog.UserID < 1) { throw new BaseResultException { Code = MessageCode.DATA_VALIDATION_FAILED, ResultMessage = "用户ID为空" } } ; if (userActivityLog.ActivityType.IsNone()) { throw new BaseResultException { Code = MessageCode.DATA_VALIDATION_FAILED, ResultMessage = "类型为空" } } ; userActivityLog.IpAddress = NetworkHelper.GetClientIP(); userActivityLog.ReferrerUrl = NetworkHelper.ReferrerUrl(); userActivityLog.PageUrl = NetworkHelper.PageUrl(); _userlogRepository.Insert(userActivityLog); } } }
public HttpResponseMessage UserActivityLogByDate(HttpRequestMessage reqObject) { _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedDataObject != null && _requestedDataObject.BusinessData != null) { _UserActivityLog = JsonConvert.DeserializeObject <UserActivityLog>(_requestedDataObject.BusinessData); } else { _serviceResponse = _IDataManipulation.ResopnseWhenDataNotFound("Information Not Found"); _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); } var result = _IUserActivityLogService.UserActivityLogByDate(_UserActivityLog); if (result != null) { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been fetched successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(result, "Information Not Found"); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
public async Task recordUserLogon(string userName) { try { var u = await userManager.FindByNameAsync(userName); var roles = await userManager.GetRolesAsync(u); var entry = new UserActivityLog() { username = userName, activity = "logon", activityDate = DateTime.Now, firstname = u.firstName, lastname = u.lastName, isMobileInterface = false, offices = ":" + (String.Join(":", roles)) + ":", userAgent = httpContextAccessor.HttpContext.Request.Headers["User-Agent"].ToString() }; unitOfWork.userActivityLogs.add(entry); await unitOfWork.commitAsync(); } catch (Exception ex) { httpContextAccessor.HttpContext.RiseError(ex); } }
public JsonResult insertuseractivity([FromBody] UserActivityLog Ilog) { try { if (!string.IsNullOrEmpty(HttpContext.Session.GetString("SessionId")) && Ilog != null) { User luser = lIUserRepository.getUserbySessionId(HttpContext.Session.GetString("SessionId")); if (luser != null) { Ilog.SessionId = HttpContext.Session.GetString("SessionId"); Ilog.ActivityType = "Review"; Ilog.StartTimeStamp = !string.IsNullOrEmpty(HttpContext.Session.GetString("SessionTime")) ? Convert.ToDateTime(HttpContext.Session.GetString("SessionTime")) : DateTime.Now; Ilog.UserId = HttpContext.Session.GetString("UserId"); Ilog.UserName = HttpContext.Session.GetString("UserName"); Ilog.UserType = HttpContext.Session.GetString("UserType"); if (!string.IsNullOrEmpty(HttpContext.Session.GetString("ReviewID"))) { Ilog.ReviewId = HttpContext.Session.GetString("ReviewID"); } int _result = lIUserActivityLogRepository.InsertUserActivityLog(Ilog); if (_result > 0) { return(Json(new { result = "success" })); } } } } catch (Exception ex) { logger.LogDebug("Error: " + ex); } return(Json(new { result = "failure" })); }
public bool LogUserActivity(UserActivity UserActivity) { DALInfo.ConnectionString = new Connection(DALInfo).ConnectionString(DALInfo.ApplicationMode); UserActivityLog oUserActivityLog = new UserActivityLog(DALInfo); return(oUserActivityLog.LogActivity(UserActivity, objUser, AppType, AppVersion).Result == 0 ? false : true); }
public IActionResult Delete(string id) { DeviceCalibration ldevice = (from p in context.DeviceCalibration where p.SetupId == id select p).FirstOrDefault(); if (ldevice != null) { int res = lIDeviceCalibrationRepository.deleteDeviceCalibrationCascade(id); if (res > 0) { //Insert to User Activity Log UserActivityLog llog = new UserActivityLog(); llog.SessionId = HttpContext.Session.GetString("SessionId"); llog.ActivityType = "Update"; llog.StartTimeStamp = !string.IsNullOrEmpty(HttpContext.Session.GetString("SessionTime")) ? Convert.ToDateTime(HttpContext.Session.GetString("SessionTime")) : DateTime.Now; llog.Duration = Convert.ToInt32((DateTime.Now - Convert.ToDateTime(HttpContext.Session.GetString("SessionTime"))).TotalSeconds); llog.RecordChangeType = "Delete"; llog.RecordType = "Equipment"; llog.Comment = "Record deleted"; llog.RecordJson = JsonConvert.SerializeObject(ldevice); llog.UserId = HttpContext.Session.GetString("UserId"); llog.UserName = HttpContext.Session.GetString("UserName"); llog.UserType = HttpContext.Session.GetString("UserType"); if (!string.IsNullOrEmpty(HttpContext.Session.GetString("ReviewID"))) { llog.ReviewId = HttpContext.Session.GetString("ReviewID"); } lIUserActivityLogRepository.InsertUserActivityLog(llog); } } return(RedirectToAction("Index", "Equipment")); }
public int AddUserActivityLog(UserActivityLog _UserActivityLog) { try { var _max = _IUoW.Repository <UserActivityLog>().GetMaxValue(x => x.SlId) + 1; _UserActivityLog.SlId = _max.ToString().PadLeft(9, '0'); _UserActivityLog.DateTime = System.DateTime.Now; //_UserActivityLog.TransectionDate = Convert.ToDateTime(System.DateTime.Now.ToString("dd/MM/yyyy")); _UserActivityLog.TransectionDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); //DateTime TransectionDate = Convert.ToDateTime(_UserActivityLog.TransectionDate.ToString("MM/dd/yyyy")); // _UserActivityLog.TransectionDate = Convert.ToDateTime(_UserActivityLog.DateTime.ToString("MM/dd/yyyy")); var result = _IUoW.Repository <UserActivityLog>().Add(_UserActivityLog); if (result == 1) { _IUoW.Commit(); } return(result); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddUserActivityLog(obj)", string.Empty); return(0); } }
public HttpResponseMessage UserActivityLogByAccNo(HttpRequestMessage reqObject) { string WalletAccountNo = string.Empty; _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedData != null && _requestedDataObject.BusinessData != null) { _UserActivityLog = JsonConvert.DeserializeObject <UserActivityLog>(_requestedDataObject.BusinessData); WalletAccountNo = _UserActivityLog.WalletAccountNo; } if (string.IsNullOrWhiteSpace(WalletAccountNo)) { _serviceResponse = _IDataManipulation.ResopnseWhenDataNotFound("Information Not Found"); _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); } var result = _IUserActivityLogService.UserActivityLogByAccNo(WalletAccountNo); if (result != null) { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been fetched successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(result, "Information Not Found"); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
public async Task <IActionResult> AddActivityLog([FromBody] UserActivityLog userActivityLog) { await SqlRepository.AddUserActivityLogAsync(userActivityLog); return(Ok(new Response { Status = "Success", Message = "Added UserActivityLog Successfuly" })); }
//delete the patient record public IActionResult Delete(int patid) { try { Patient lpatient = context.Patient.FirstOrDefault(p => p.PatientId == patid); if (lpatient != null) { string result = lIPatientRxRepository.DeletePatientRecordsWithCasecade(patid); if (!string.IsNullOrEmpty(result) && result == "success") { //Insert to User Activity Log UserActivityLog llog = new UserActivityLog(); llog.SessionId = HttpContext.Session.GetString("SessionId"); llog.ActivityType = "Update"; llog.StartTimeStamp = !string.IsNullOrEmpty(HttpContext.Session.GetString("SessionTime")) ? Convert.ToDateTime(HttpContext.Session.GetString("SessionTime")) : DateTime.Now; llog.Duration = Convert.ToInt32((DateTime.Now - Convert.ToDateTime(HttpContext.Session.GetString("SessionTime"))).TotalSeconds); llog.RecordChangeType = "Delete"; llog.RecordType = "Patient"; llog.Comment = "Record deleted"; llog.RecordJson = JsonConvert.SerializeObject(lpatient); llog.UserId = HttpContext.Session.GetString("UserId"); llog.UserName = HttpContext.Session.GetString("UserName"); llog.UserType = HttpContext.Session.GetString("UserType"); if (!string.IsNullOrEmpty(HttpContext.Session.GetString("ReviewID"))) { llog.ReviewId = HttpContext.Session.GetString("ReviewID"); } lIUserActivityLogRepository.InsertUserActivityLog(llog); } } } catch (Exception ex) { logger.LogDebug("Error: " + ex); } if (!string.IsNullOrEmpty(HttpContext.Session.GetString("UserType")) && HttpContext.Session.GetString("UserType") == "0") { return(RedirectToAction("Index", "Patient")); } if (!string.IsNullOrEmpty(HttpContext.Session.GetString("UserType")) && HttpContext.Session.GetString("UserType") == "1") { return(RedirectToAction("Dashboard", "Support")); } if (!string.IsNullOrEmpty(HttpContext.Session.GetString("UserType")) && HttpContext.Session.GetString("UserType") == "2") { return(RedirectToAction("Dashboard", "Therapist")); } if (!string.IsNullOrEmpty(HttpContext.Session.GetString("UserType")) && HttpContext.Session.GetString("UserType") == "3") { return(RedirectToAction("Dashboard", "Provider")); } else { return(RedirectToAction("Dashboard", "Provider")); } }
/// <summary> /// Write the AuditLog to the log file with EnterpriseLibrary /// </summary> /// <param name="auditLog">auditLog to be writen</param> /// <returns>void</returns> public static void WriteActivityLog(UserActivityLog userActivityLog) { // Log the event - default to error category LogEntry log = new LogEntry(); log.EventId = 1; log.Message = userActivityLog.ToString(); log.Categories.Add(TraceEventType.INFORMATION); Loggers(log); }
public int UpdateUserActivityLog(UserActivityLog pUserActivityLog) { var _activity = (from p in context.UserActivityLog where p.ActivityId == pUserActivityLog.ActivityId select p).FirstOrDefault(); if (_activity != null) { context.Entry(pUserActivityLog).State = Microsoft.EntityFrameworkCore.EntityState.Modified; return(context.SaveChanges()); } return(0); }
public override void Save() { try { using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { UserActivityLog model = new UserActivityLog(); model.CustomerId = Persistence.GetCustomerId(Metadata.CustomerIdString); model.Timestamp = Data.FormattedTimestamp; model.UserId = Data.UserId; model.UserIp = Data.UserIp; model.Offset = Metadata.Offset; model.OperationName = Data.OperationName; model.ServiceName = Data.ServiceName; model.Success = Data.Success; if (Data.AuditKeyValues != null) { model.State = Data.AuditKeyValues.Where(x => x.Key.Equals("new_state")).Select(x => x.ValueString).FirstOrDefault(); model.DetectId = Data.AuditKeyValues.Where(x => x.Key.Equals("detects")).Select(x => x.ValueString).FirstOrDefault(); } else { model.State = null; model.DetectId = null; } db.UserActivityLogs.Add(model); db.SaveChanges(); AppConfiguration.FALCON_STREAM_LAST_OFFSET = Metadata.Offset; log.Debug("[" + Metadata.Offset + "] User activity audit event saved to database"); } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); var fullErrorMessage = string.Join("; ", errorMessages); var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } catch (Exception e) { log.Fatal("[" + Metadata.Offset + "] Error occured while trying to save user activity audit event to database", e); System.Environment.Exit(1); } }
//delete the provider record not having any patients assigned public IActionResult DeleteProvider(string provider) { try { var _user = (from p in context.User where p.UserId == provider select p).FirstOrDefault(); context.User.Remove(_user); int res = context.SaveChanges(); if (res > 0) { VSeeHelper lhelper = new VSeeHelper(); DeleteUser luser = new DeleteUser(); luser.secretkey = ConfigVars.NewInstance.secretkey; luser.username = _user.UserId; var resUser = lhelper.DeleteUser(luser); if (resUser != null && resUser["status"] == "success") { //Insert to User Activity Log UserActivityLog llog = new UserActivityLog(); llog.SessionId = HttpContext.Session.GetString("SessionId"); llog.ActivityType = "Update"; llog.StartTimeStamp = !string.IsNullOrEmpty(HttpContext.Session.GetString("SessionTime")) ? Convert.ToDateTime(HttpContext.Session.GetString("SessionTime")) : DateTime.Now; llog.Duration = Convert.ToInt32((DateTime.Now - Convert.ToDateTime(HttpContext.Session.GetString("SessionTime"))).TotalSeconds); llog.RecordChangeType = "Delete"; llog.RecordType = "Provider"; llog.Comment = "Record deleted"; llog.RecordJson = JsonConvert.SerializeObject(_user); llog.UserId = HttpContext.Session.GetString("UserId"); llog.UserName = HttpContext.Session.GetString("UserName"); llog.UserType = HttpContext.Session.GetString("UserType"); if (!string.IsNullOrEmpty(HttpContext.Session.GetString("ReviewID"))) { llog.ReviewId = HttpContext.Session.GetString("ReviewID"); } lIUserActivityLogRepository.InsertUserActivityLog(llog); } } } catch (Exception ex) { return(RedirectToAction("Index", "Provider")); } return(RedirectToAction("Index", "Provider")); }
public LogActivityViewModel CreateLogActivity(LogActivityViewModel Model) { UserActivityLog log = new UserActivityLog { ActioName = Model.ActioName, Activity = Model.Activity, ActivityMessage = Model.ActivityMessage, ControllerName = Model.ControllerName, EnteredBy = Model.EnteredBy, EnteredDate = Model.EnteredDate, ModuleName = Model.ModuleName, RegistrationNo = Model.RegistrationNo }; _context.UserActivityLogs.Add(log); _context.SaveChanges(); return(Model); }
public IEnumerable <UserActivityLog> UserActivityLogByDate(UserActivityLog _UserActivityLog) { try { //int result1 = DateTime.Compare(toTxnDate.Date, txnDate1.Date); //DateTime FormDate = Convert.ToDateTime(_UserActivityLog.FormDate.ToString("dd/MM/yyyy")); //DateTime ToDate = Convert.ToDateTime(_UserActivityLog.ToDate.ToString("dd/MM/yyyy")); _UserActivityLog.FormDate = Convert.ToDateTime(_UserActivityLog.FormDate.ToShortDateString()); _UserActivityLog.ToDate = Convert.ToDateTime(_UserActivityLog.ToDate.ToShortDateString()); var AllctivityLog = _IUoW.Repository <UserActivityLog>().Get(x => x.TransectionDate >= _UserActivityLog.FormDate && x.TransectionDate <= _UserActivityLog.ToDate).OrderByDescending(x => x.SlId).ToList(); return(AllctivityLog); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "UserActivityLogByDate()", string.Empty); return(null); } }
//===================== Apartments CSV Import======================= public async Task <ActionResult> ProcessCsv(EventItem[] model) { int BuildingID = (int)Session["BuildingID"]; if (ModelState.IsValid) //if(User.Identity.IsAuthenticated) { { foreach (var item in model) { var apartment = new Apartment { ApartmentNumber = item.AparmentNumber, BuildingID = BuildingID, FloorNumber = item.Floor }; db.Apartment.Add(apartment); await db.SaveChangesAsync(); //======================insert Add Building Activity================ var UserID = User.Identity.GetUserId(); // gets logged user ID AspNetUsers myUser = await db.AspNetUsers.FirstOrDefaultAsync(c => c.Id == UserID); // select from db where logged use match var newActivity = new UserActivityLog { BuildingID = BuildingID, UserID = "84a4092e-0bcc-4e4f-b007-c87a99eccae3", DateOfEvent = DateTime.Now, FunctionPerformed = "Added apartment", Message = "Apartment # " + item.AparmentNumber + " was added by " + myUser.UserName }; db.UserActivityLog.Add(newActivity); await db.SaveChangesAsync(); } } } return(RedirectToAction("BuildingProfile", "Building")); }
protected void Page_Load(object sender, EventArgs e) { UserActivityLog.SaveUserActivity(ActivityCode.Read); string chartType = Request.QueryString["chartType"]; string returnValue = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/json"; Response.BufferOutput = true; string userRoles = ((table1.Nestedtable1)Page.Master).GetUserRoles(); if (chartType == "1") { CountPerStudyTableAdapter CountPerStudyTableAdapter = new CountPerStudyTableAdapter(); Datasets.DemographicsChartsDataset.CountPerStudyDataTable table = CountPerStudyTableAdapter.GetData(userRoles); foreach (Datasets.DemographicsChartsDataset.CountPerStudyRow row in table.Rows) { string item = "{\"TCH\":\"" + row.TCHCount.ToString() + "\",\"Total Enrollment\":\"" + row.TotalEnrollment.ToString() + "\",\"EnrollmentYearMonth\":\"" + (row.IsEnrollmentYearMonthNull() ? "null" : row.EnrollmentYearMonth) + "\"}"; returnValue = returnValue + "," + item; } } if (chartType == "6") { CountArmTableAdapter CountArmTableAdapter = new CountArmTableAdapter(); Datasets.DemographicsChartsDataset.CountArmDataTable table = CountArmTableAdapter.GetData(userRoles); foreach (Datasets.DemographicsChartsDataset.CountArmRow row in table.Rows) { string item = "{\"Arm\":\"" + row.ArmText + "\",\"Count\":\"" + row.ArmCount.ToString() + "\"}"; returnValue = returnValue + "," + item; } } if (chartType == "2") { CountGenderTableAdapter CountGenderTableAdapter = new CountGenderTableAdapter(); Datasets.DemographicsChartsDataset.CountGenderDataTable table = CountGenderTableAdapter.GetData(userRoles); foreach (Datasets.DemographicsChartsDataset.CountGenderRow row in table.Rows) { string item = "{\"Gender\":\"" + row.GenderText + "\",\"Count\":\"" + row.GenderCount.ToString() + "\"}"; returnValue = returnValue + "," + item; } } if (chartType == "3") { CountStudyTableAdapter CountStudyTableAdapter = new CountStudyTableAdapter(); Datasets.DemographicsChartsDataset.CountStudyDataTable table = CountStudyTableAdapter.GetData(userRoles); foreach (Datasets.DemographicsChartsDataset.CountStudyRow row in table.Rows) { string item = "{\"Study Site\":\"" + row.StudyText + "\",\"Count\":\"" + row.COECount.ToString() + "\"}"; returnValue = returnValue + "," + item; } } if (chartType == "4") { CountRaceTableAdapter CountRaceTableAdapter = new CountRaceTableAdapter(); Datasets.DemographicsChartsDataset.CountRaceDataTable table = CountRaceTableAdapter.GetData(userRoles); foreach (Datasets.DemographicsChartsDataset.CountRaceRow row in table.Rows) { string item = "{\"Race\":\"" + row.RaceText + "\",\"Count\":\"" + row.RaceCount.ToString() + "\"}"; returnValue = returnValue + "," + item; } } if (chartType == "5") { CountEthnicityTableAdapter CountEthnicityTableAdapter = new CountEthnicityTableAdapter(); Datasets.DemographicsChartsDataset.CountEthnicityDataTable table = CountEthnicityTableAdapter.GetData(userRoles); foreach (Datasets.DemographicsChartsDataset.CountEthnicityRow row in table.Rows) { string item = "{\"Ethnicity\":\"" + row.EthnicityText + "\",\"Count\":\"" + row.EthnicityCount.ToString() + "\"}"; returnValue = returnValue + "," + item; } } returnValue = returnValue.Length > 0 ? returnValue.Substring(1) : returnValue; returnValue = "[" + returnValue + "]"; Response.Write(returnValue); Response.Flush(); Response.End(); }
public int InsertUserActivityLog(UserActivityLog pUserActivityLog) { context.UserActivityLog.Add(pUserActivityLog); return(context.SaveChanges()); }
/// <summary> /// 用户登录 /// </summary> /// <param name="userName"></param> /// <param name="password"></param> public BaseResult <User> Login(string userName, string password, string code) { try { if (userName.IsNone()) { throw new BaseResultException { Code = MessageCode.DATA_VALIDATION_FAILED, ResultMessage = "用户名不能为空" } } ; if (password.IsNone()) { throw new BaseResultException { Code = MessageCode.DATA_VALIDATION_FAILED, ResultMessage = "密码不能为空" } } ; var user = _userRepository.GetByCondition(x => x.UserName == userName); if (user == null) { throw new BaseResultException { Code = MessageCode.DATA_NOT_FOUND, ResultMessage = "用户不存在" } } ; if (user.Status == "DISABLE") { throw new BaseResultException { Code = MessageCode.DATA_NOT_FOUND, ResultMessage = "该账户已停用,请联系管理员进行解锁" } } ; var loginFailedCount = _userlogRepository.GetLoginFailedTimes(userName, DateTime.Now); if (loginFailedCount >= 5) { throw new BaseResultException { Code = MessageCode.DATA_VALIDATION_FAILED, ResultMessage = "今日密码连续错误5次,已限制登录" } } ; if (user.Password != GeneratePassword(password)) { throw new BaseResultException { Code = MessageCode.DATA_NOT_FOUND, ResultMessage = "用户密码错误,当天还剩 " + loginFailedCount + "次" } } ; // 记录成功日志 var userLoginLog = new UserActivityLog { UserID = user.ID, UserName = user.UserName, NickName = user.NickName, ActivityType = "LOGIN_SUCCEED", Comment = "登录成功" }; _userlogRepository.Insert(userLoginLog); user.IsOnline = "Y"; user.DateLastLogin = DateTime.Now; user = _userRepository.Update(user); return(new BaseResult <User> { Data = user }); } catch (BaseResultException ex) { // 记录失败日志 var userLoginLog = new UserActivityLog { UserName = userName, ActivityType = "LOGIN_FAILED", Comment = ex.ResultMessage + " " + password }; _userlogRepository.Insert(userLoginLog); return(new BaseResult <User> { IsSucceed = false }); } }