private static void TestAuditFailure(int numberOfMessagesToCreate) { while (numberOfMessagesToCreate > 0) { QueueMessage msg = new QueueMessage(); DataAudit da = new DataAudit(); da.Contract = "inhealth001"; da.EntityID = "531f2dcc072ef727c4d29e22"; da.EntityType = "testentitytype"; da.UserId = "531f2dcc072ef727c4d29yyy"; da.TimeStamp = DateTime.Now; string xmlBody = AuditDispatcher.ToXML(da); string messageQueue = @".\private$\failure"; QueueMessage newMessage = new QueueMessage(ASEMessageType.Process, messageQueue); newMessage.Body = xmlBody; MessageQueueHelper.SendMessage(@messageQueue, newMessage, "TestFailureType"); --numberOfMessagesToCreate; } }
public IActionResult DeleteDetail(int id, int parentId) { var currentRoleId = _PartnerManager.GetCurrentUserRole(this.HttpContext); var permission = _partActRepo.GetPartAct("PartnerActivity.Detail.Delete", currentRoleId); if (permission == null) { toastNotification.AddErrorToastMessage("ليس لديك الصلاحية الكافية", new ToastrOptions { Title = "" }); return(Redirect(Request.Headers["Referer"].ToString())); } var old = _partActRepo.GetDetail(id, parentId); if (old != null) { var audit = new DataAudit(); audit.Activity.Id = "PartnerActivity.Detail"; audit.PartnerId = _PartnerManager.GetCurrentUserId(this.HttpContext); audit.PartnerAccount = _PartnerManager.GetCurrentUserAccount(this.HttpContext); audit.Action.Id = "Delete"; audit.Success = true; audit.OldValue = old.ToString(); _auditing.Create(audit); _partActRepo.DeleteDetail(id, parentId); } return(RedirectToAction("Detail", new { id = parentId })); }
public IActionResult Edit(CreatePartnerActivity2Dto model) { if (ModelState.IsValid) { var currentRoleId = _PartnerManager.GetCurrentUserRole(this.HttpContext); var permission = _partActRepo.GetPartAct("PartnerActivity.Edit", currentRoleId); if (permission == null) { toastNotification.AddErrorToastMessage("ليس لديك الصلاحية الكافية", new ToastrOptions { Title = "" }); return(Redirect(Request.Headers["Referer"].ToString())); } var old = _partActRepo.GetPartAct(model.Id); if (old == null) { return(View(model)); } var pAct = new PartnerActivity(); pAct.Id = model.Id; pAct.Activity.Id = model.ActivityId; pAct.FromRole.Id = model.FromRoleId ?? 0; pAct.MaxQueryRows = model.MaxQueryRowsNo; pAct.MaxQueryDuration.Id = model.MaxQueryDurationId; pAct.Scope.Id = model.ScopeId; pAct.OnlyPartnerChildren = model.OnlyPartnerChildren; pAct.LastEditOn = DateTime.Now; var result = _partActRepo.Edit(pAct); if (result.Success) { var audit = new DataAudit(); audit.Activity.Id = "PartnerActivity.Edit"; audit.PartnerId = _PartnerManager.GetCurrentUserId(this.HttpContext); audit.PartnerAccount = _PartnerManager.GetCurrentUserAccount(this.HttpContext); audit.Action.Id = "Update"; audit.Success = true; audit.OldValue = old.ToString(); audit.NewValue = pAct.ToString(); _auditing.Create(audit); return(RedirectToAction("Index")); } else { model.Error = result.Error; } } var fromRoles = new RoleRepo(db, _partActRepo).GetRoles(); var activities = new ActivityRepo(db, _PartnerManager).GetActivities(); var maxQueryDuration = new CommonCodeRepo(db).GetCodesByType("queryduration"); var scopes = new CommonCodeRepo(db).GetCodesByType("activity.scope"); model.FromRoles = fromRoles; model.Activities = activities; model.MaxQueryDuration = maxQueryDuration; model.Scopes = scopes; return(View(model)); }
public IActionResult Delete(int id) { var currentRoleId = partnerManager.GetCurrentUserRole(this.HttpContext); var permission = partnerActivity.GetPartAct("MessageTemplate.Delete", currentRoleId); if (permission == null) { toastNotification.AddErrorToastMessage("ليس لديك الصلاحية الكافية", new ToastrOptions { Title = "" }); return(Redirect(Request.Headers["Referer"].ToString())); } var old = new MessageTemplateRepo(db, partnerManager).GetSingle(id); if (old != null) { var audit = new DataAudit(); audit.Activity.Id = "MessageTemplate.Delete"; audit.PartnerId = partnerManager.GetCurrentUserId(this.HttpContext); audit.PartnerAccount = partnerManager.GetCurrentUserAccount(this.HttpContext); audit.Action.Id = "Delete"; audit.Success = true; audit.OldValue = old.ToString(); auditing.Create(audit); new MessageTemplateRepo(db, partnerManager).RemoveMessage(id); } return(RedirectToAction("Index")); }
public OpertionResult Create(DataAudit data) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "v_partner_id", OracleDbType = OracleDbType.Varchar2, Value = data.PartnerId }, new OracleParameter { ParameterName = "v_partner_acc", OracleDbType = OracleDbType.Int32, Value = data.PartnerAccount }, new OracleParameter { ParameterName = "v_act_id", OracleDbType = OracleDbType.Varchar2, Value = data.Activity.Id }, new OracleParameter { ParameterName = "v_action_id", OracleDbType = OracleDbType.Varchar2, Value = data.Action.Id }, new OracleParameter { ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = data.Note }, new OracleParameter { ParameterName = "v_old_value", OracleDbType = OracleDbType.NVarchar2, Value = data.OldValue }, new OracleParameter { ParameterName = "v_new_value", OracleDbType = OracleDbType.NVarchar2, Value = data.NewValue }, new OracleParameter { ParameterName = "v_system_note", OracleDbType = OracleDbType.NVarchar2, Value = data.SystemNote }, new OracleParameter { ParameterName = "v_error", OracleDbType = OracleDbType.Varchar2, Value = data.Error }, new OracleParameter { ParameterName = "v_success", OracleDbType = OracleDbType.Int32, Value = data.Success ? 1 : 0 } }; #endregion var result = db.ExecuteStoredProc("pk_utility.sp_create_audit", parameters); return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); //if (result > 0) //{ // return new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }; //} //else //{ // return new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }; //} } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public AuditExport(DataAudit obj) { UserName = obj.User?.FullName; Date = obj.Date; Action = Enum.GetName(typeof(AuditActionType), obj.ActionTypeId).ToString(); TableName = obj.TableName; OldData = obj.OldData; NewData = obj.NewData; }
public static int SaveDataAudit(DataAudit dataAudit) { using (LinkManagementEntities entities = new LinkManagementEntities()) { entities.DataAudits.Add(dataAudit); entities.SaveChanges(); } return(1); }
public IActionResult EditDetail(CreatePartnerActivityDetailDto model) { if (ModelState.IsValid) { var currentRoleId = _PartnerManager.GetCurrentUserRole(this.HttpContext); var permission = _partActRepo.GetPartAct("PartnerActivity.Detail.Edit", currentRoleId); if (permission == null) { toastNotification.AddErrorToastMessage("ليس لديك الصلاحية الكافية", new ToastrOptions { Title = "" }); return(Redirect(Request.Headers["Referer"].ToString())); } var old = _partActRepo.GetDetail(model.Id, model.ParentId); if (old == null) { return(View(model)); } var originObject = new PartnerActivityDetail(); originObject.Id = model.Id; originObject.ParentId = model.ParentId; originObject.ToRole.Id = model.ToRoleId; originObject.CheckBalanceRequired = model.CheckBalanceRequired; originObject.MinValue = model.MinValue; originObject.MaxValue = model.MaxValue; originObject.TaxPercent = model.TaxPercent; originObject.BonusPercent = model.BonusPercent; originObject.BonusTaxPercent = model.BonusTaxPercent; originObject.FixedFactor = model.FixedFactor; originObject.CreatedBy.Id = _PartnerManager.GetCurrentUserId(this.HttpContext); var result = _partActRepo.UpdateDetail(originObject); if (result.Success) { var audit = new DataAudit(); audit.Activity.Id = "PartnerActivity.Detail.Edit"; audit.PartnerId = _PartnerManager.GetCurrentUserId(this.HttpContext); audit.PartnerAccount = _PartnerManager.GetCurrentUserAccount(this.HttpContext); audit.Action.Id = "Update"; audit.Success = true; audit.OldValue = old.ToString(); audit.NewValue = originObject.ToString(); var auditResult = _auditing.Create(audit); if (!auditResult.Success) { _logger.LogError($"Edit Partner Activity Detail no[{originObject.Id}] , Error was {auditResult.Error}"); } } return(RedirectToAction("Detail", new { id = model.ParentId })); } model.ToRoles = new RoleRepo(db, _partActRepo).GetRoles(); return(View(model)); }
private void SaveAudit(IEnumerable <PropertyValueTracker> entity, CrudAction changeType) { var audit = new DataAudit() { ChangedBy = currentUserService.GetCurrentUserInfo()?.NetworkID, ChangedDate = DateTime.Now, ChangeType = (int)changeType, EntityName = entity.GetType().FullName, NewInfo = entity.ToXMLString() }; repository.Save(audit); }
public DataAudit ToAudit() { var audit = new DataAudit { TableName = TableName, ObjectKey = JsonConvert.SerializeObject(KeyValues), OldData = OldValues.Count == 0 ? null : JsonConvert.SerializeObject(OldValues), NewData = NewValues.Count == 0 ? null : JsonConvert.SerializeObject(NewValues), UserId = UserId, Date = Time, SessionId = SessionId, ActionTypeId = (int)ActionType, }; return(audit); }
public IActionResult RemovePV(double pvalue) { var currentRoleId = _partnerManager.GetCurrentUserRole(this.HttpContext); var permission = _partActRepo.GetPartAct("PayemntValues.Remove", currentRoleId); if (permission == null) { _toastNotification.AddErrorToastMessage("ليس لديك الصلاحيات الكافية", new ToastrOptions { Title = "" }); return(Redirect(Request.Headers["Referer"].ToString())); } var removedObj = new PaymentValuesRepo(_db, _partnerManager).GetSingleOrDefault(pvalue); if (removedObj == null) { _toastNotification.AddErrorToastMessage($"المبلغ {pvalue.ToString("N2")} غير موجود", new ToastrOptions { Title = "" }); return(View("PValues")); } else { var result = new PaymentValuesRepo(_db, _partnerManager).Remove(pvalue); if (result.Success) { _toastNotification.AddSuccessToastMessage($"المبلغ {pvalue.ToString("N2")} تم حذفه", new ToastrOptions { Title = "" }); var audit = new DataAudit(); audit.Activity.Id = "PayemntValues.Remove"; audit.PartnerId = _partnerManager.GetCurrentUserId(this.HttpContext); audit.PartnerAccount = _partnerManager.GetCurrentUserAccount(this.HttpContext); audit.Action.Id = "Delete"; audit.Success = true; audit.OldValue = removedObj.ToString(); audit.NewValue = string.Empty; _auditing.Create(audit); } PValues(); return(View("PValues")); } }
public IActionResult ApiBlackListRemove(string ipAddress) { var currentRoleId = _partnerManager.GetCurrentUserRole(this.HttpContext); var permission = _partActRepo.GetPartAct("API.IpBlacklist.Remove", currentRoleId); if (permission == null) { _toastNotification.AddErrorToastMessage("ليس لديك الصلاحيات الكافية", new ToastrOptions { Title = "" }); return(Redirect(Request.Headers["Referer"].ToString())); } var removedObj = new ApiIPBlacklistRepo(_db).GetSingleOrDefault(ipAddress); if (removedObj == null) { _toastNotification.AddErrorToastMessage($"العوان {ipAddress} غير موجود"); return(View("ApiIPsBlacklist")); } else { var result = new ApiIPBlacklistRepo(_db).Remove(ipAddress); if (result.Success) { _toastNotification.AddSuccessToastMessage($"العنوان {ipAddress} تم حذفه", new ToastrOptions { Title = "" }); var audit = new DataAudit(); audit.Activity.Id = "API.IpBlacklist.Remove"; audit.PartnerId = _partnerManager.GetCurrentUserId(this.HttpContext); audit.PartnerAccount = _partnerManager.GetCurrentUserAccount(this.HttpContext); audit.Action.Id = "Delete"; audit.Success = true; audit.OldValue = removedObj.ToString(); audit.NewValue = string.Empty; _auditing.Create(audit); } var model = new ApiIPBlacklistRepo(_db).GetList(string.Empty); return(View("ApiIPsBlacklist", model)); } }
public IActionResult DeleteMessage(string actId, int msgId) { var old = new ActivityMessageRepo(db, partnerManager).GetSingle(actId, msgId); if (old != null) { var audit = new DataAudit(); audit.Activity.Id = "ActivityMessage.Delete"; audit.PartnerId = partnerManager.GetCurrentUserId(this.HttpContext); audit.PartnerAccount = partnerManager.GetCurrentUserAccount(this.HttpContext); audit.Action.Id = "Delete"; audit.Success = true; audit.OldValue = old.ToString(); new DataAuditRepo(db).Create(audit); new ActivityMessageRepo(db, partnerManager).RemoveMessage(actId, msgId); return(LocalRedirect("~/Activity/AssignMessage/" + actId)); } return(RedirectToAction("Index")); }
public List <DataAudit> GetAuditig(GetListParam param) { string sql = "Select * from v_data_audit "; string whereClause = string.Empty; #region Build Parameters var parameters = new List <OracleParameter>(); if (!string.IsNullOrEmpty(param.CreatorId)) { var param1 = new OracleParameter() { ParameterName = "CreatorId", OracleDbType = OracleDbType.Varchar2, Value = param.CreatorId }; parameters.Add(param1); whereClause = " WHERE partner_id=:CreatorId "; } if (param.CreatorAccount > 0) { var param1 = new OracleParameter() { ParameterName = "CreatorAccount", OracleDbType = OracleDbType.Int32, Value = param.CreatorAccount }; parameters.Add(param1); whereClause += string.IsNullOrEmpty(whereClause) ? " WHERE partner_acc=:CreatorAccount " : " AND partner_acc=:CreatorAccount "; } if (!string.IsNullOrEmpty(param.ActivityId)) { var param1 = new OracleParameter() { ParameterName = "ActivityId", OracleDbType = OracleDbType.Varchar2, Value = param.ActivityId }; parameters.Add(param1); whereClause += string.IsNullOrEmpty(whereClause) ? " WHERE act_id=:ActivityId " : " AND act_id=:ActivityId "; } //if (!string.IsNullOrEmpty(actionId)) //{ // var param1 = new OracleParameter() { ParameterName = "actionId", OracleDbType = OracleDbType.Varchar2, Value = actionId }; // parameters.Add(param1); // whereClause += string.IsNullOrEmpty(whereClause) ? " WHERE action_id=:actionId " : " AND action_id=:actionId "; //} if (param.IncludeDates) { if (param.StartDate != null && param.StartDate != DateTime.MinValue) { var param1 = new OracleParameter() { ParameterName = "StartDate", OracleDbType = OracleDbType.Date, Value = param.StartDate }; parameters.Add(param1); whereClause += string.IsNullOrEmpty(whereClause) ? " WHERE trunc(createdon)>=:StartDate " : " AND trunc(createdon)>=:StartDate "; } if (param.EndDate != null && param.EndDate != DateTime.MinValue) { var param1 = new OracleParameter() { ParameterName = "EndDate", OracleDbType = OracleDbType.Date, Value = param.EndDate }; parameters.Add(param1); whereClause += string.IsNullOrEmpty(whereClause) ? " WHERE trunc(createdon)<=:EndDate " : " AND trunc(createdon)<=:EndDate "; } } whereClause += " ORDER BY createdon DESC "; #endregion DataTable dt = null; if (parameters != null && parameters.Count > 0) { dt = this.db.GetData(sql + whereClause, parameters); } else { dt = this.db.GetData(sql + whereClause, null); } var dataList = new List <DataAudit>(); if (dt != null) { foreach (DataRow row in dt.Rows) { var currObj = new DataAudit(); currObj.Id = row["row_id"] == DBNull.Value ? 0 : int.Parse(row["row_id"].ToString()); currObj.PartnerId = row["partner_id"] == DBNull.Value ? string.Empty : row["partner_id"].ToString(); currObj.PartnerAccount = row["partner_acc"] == DBNull.Value ? -1 : int.Parse(row["partner_acc"].ToString()); currObj.PartnerName = row["partner_name"] == DBNull.Value ? string.Empty : row["partner_name"].ToString(); currObj.CreatedOn = row["createdon"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(row["createdon"].ToString()); currObj.Activity.Id = row["act_id"] == DBNull.Value ? string.Empty : row["act_id"].ToString(); currObj.Activity.Name = row["act_name"] == DBNull.Value ? string.Empty : row["act_name"].ToString(); currObj.Activity.Type = row["act_type"] == DBNull.Value ? string.Empty : row["act_type"].ToString(); currObj.Activity.Order = row["act_order"] == DBNull.Value ? int.MinValue :int.Parse(row["act_order"].ToString()); currObj.Activity.Internal = row["internal_use"] == DBNull.Value ? false : row["internal_use"].ToString() == "1" ? true : false; currObj.Action.Id = row["action_id"] == DBNull.Value ? string.Empty : row["action_id"].ToString(); currObj.Action.Name = row["action_name"] == DBNull.Value ? string.Empty : row["action_name"].ToString(); currObj.Action.Type = row["code_type"] == DBNull.Value ? string.Empty : row["code_type"].ToString(); currObj.Action.Order = row["code_order"] == DBNull.Value ? int.MinValue : int.Parse(row["code_order"].ToString()); currObj.Note = row["note"] == DBNull.Value ? string.Empty : row["note"].ToString(); currObj.OldValue = row["old_value"] == DBNull.Value ? string.Empty : row["old_value"].ToString(); currObj.NewValue = row["new_value"] == DBNull.Value ? string.Empty : row["new_value"].ToString(); currObj.SystemNote = row["system_note"] == DBNull.Value ? string.Empty : row["system_note"].ToString(); currObj.Error = row["error"] == DBNull.Value ? string.Empty : row["error"].ToString(); currObj.Success = row["success"] == DBNull.Value ? false : row["success"].ToString() == "1" ? true : false; if (!string.IsNullOrEmpty(currObj.OldValue)) { var old = currObj.OldValue.Split('\n'); currObj.OldValueList = old.OfType <string>().ToList(); } if (!string.IsNullOrEmpty(currObj.NewValue)) { var n = currObj.NewValue.Split('\n'); currObj.NewValueList = n.OfType <string>().ToList(); } dataList.Add(currObj); } } return(dataList); }
public OpertionResult Update(MessageTemplate template) { try { var old = GetSingle(template.Id); if (old == null) { return new OpertionResult { AffectedCount = 0, Success = false, Error = "No Old Data" } } ; if (old.Title == template.Title && old.Message == template.Message && old.ToWho == template.ToWho) { return new OpertionResult { AffectedCount = 0, Success = false, Error = "Nothing to update" } } ; #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_msg_id", OracleDbType = OracleDbType.Varchar2, Value = template.Id }, new OracleParameter { ParameterName = "v_msg_name", OracleDbType = OracleDbType.NVarchar2, Value = template.Title }, new OracleParameter { ParameterName = "v_msg_text", OracleDbType = OracleDbType.NVarchar2, Value = template.Message }, new OracleParameter { ParameterName = "v_towho", OracleDbType = OracleDbType.Int32, Value = template.ToWho } }; #endregion db.ExecuteStoredProc("pk_settings.fn_update_message_template", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { var audit = new DataAudit(); audit.Activity.Id = "MessageTemplate.Update"; audit.PartnerId = template.CreatedBy.Id; audit.PartnerAccount = template.CreatedBy.Account; audit.Action.Id = "Update"; audit.Success = true; audit.OldValue = old.ToString(); audit.NewValue = template.ToString(); var auditResult = new DataAuditRepo(db).Create(audit); return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }