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
});
}
}
