private PartnerActivityDetail ConvertDataRowToDetailDataModel(DataRow row) { var partAct = new PartnerActivityDetail(); partAct.Id = row["detail_row_id"] == DBNull.Value ? 0 : int.Parse(row["detail_row_id"].ToString()); partAct.ParentId = row["master_row"] == DBNull.Value ? 0 : int.Parse(row["master_row"].ToString()); partAct.ToRole.Id = row["toroleid"] == DBNull.Value ? 0 : int.Parse(row["toroleid"].ToString()); partAct.ToRole.Name = row["torolename"] == DBNull.Value ? string.Empty : row["torolename"].ToString(); partAct.ToRole.IsActive = row["toroleisactive"] == DBNull.Value ? false : row["toroleisactive"].ToString() == "1" ? true : false; partAct.ToRole.Weight = row["toroleweight"] == DBNull.Value ? 0 : int.Parse(row["toroleweight"].ToString()); partAct.ToRole.Order = row["toroleorder"] == DBNull.Value ? byte.MinValue : byte.Parse(row["toroleorder"].ToString()); partAct.ToRole.Code = row["torolecode"] == DBNull.Value ? string.Empty : row["torolecode"].ToString(); partAct.CheckBalanceRequired = row["check_bal"] == DBNull.Value ? true : row["check_bal"].ToString() == "1" ? true : false; partAct.MaxValue = row["max_value"] == DBNull.Value ? 0 : int.Parse(row["max_value"].ToString()); partAct.MinValue = row["min_value"] == DBNull.Value ? 0 : int.Parse(row["min_value"].ToString()); partAct.BonusPercent = row["bonus_per"] == DBNull.Value ? 0 : double.Parse(row["bonus_per"].ToString()); partAct.BonusTaxPercent = row["bonus_tax"] == DBNull.Value ? 0 : double.Parse(row["bonus_tax"].ToString()); partAct.TaxPercent = row["taxper"] == DBNull.Value ? 0 : double.Parse(row["taxper"].ToString()); partAct.FixedFactor = row["fixed_factor"] == DBNull.Value ? 0 : double.Parse(row["fixed_factor"].ToString()); partAct.CreatedOn = row["createdon"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(row["createdon"].ToString()); partAct.LastEditOn = row["lastediton"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(row["lastediton"].ToString()); partAct.CreatedBy.Id = row["createdby"] == DBNull.Value ? string.Empty : row["createdby"].ToString(); partAct.CreatedBy.Account = row["createdbyacc"] == DBNull.Value ? -1 : int.Parse(row["createdbyacc"].ToString()); partAct.CreatedBy.Name = row["createdname"] == DBNull.Value ? string.Empty : row["createdname"].ToString(); return(partAct); }
public PartnerActivityDetail GetDetail(string actId, int fromRoleId, int toRoleId, bool withMaster = false) { var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "actId", OracleDbType = OracleDbType.Varchar2, Value = actId }, new OracleParameter { ParameterName = "fromId", OracleDbType = OracleDbType.Int32, Value = fromRoleId }, new OracleParameter { ParameterName = "toId", OracleDbType = OracleDbType.Int32, Value = toRoleId } }; var masterDataTable = this.db.GetData("Select * from V_PARTNER_ACTIVITY_DETAIL where act_id=:actId and fromroleid=:fromId and toroleid=:toId ", parameters); if (masterDataTable != null && masterDataTable.Rows.Count > 0) { var partAct = new PartnerActivityDetail(); DataRow row = masterDataTable.Rows[0]; partAct = ConvertDataRowToDetailDataModel(row); if (withMaster) { partAct.Parent = GetPartActOnly(partAct.ParentId); } return(partAct); } return(null); }
public PartnerActivityDetail GetDetail(int id, int parentId, bool withMaster = false) { var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "Row_Id", OracleDbType = OracleDbType.Int32, Value = id }, new OracleParameter { ParameterName = "parentId", OracleDbType = OracleDbType.Int32, Value = parentId } }; var masterDataTable = this.db.GetData("Select * from V_PARTNER_ACTIVITY_DETAIL where detail_row_id=:Row_Id and row_id=:parentId ", parameters); var partAct = new PartnerActivityDetail(); if (masterDataTable != null) { DataRow row = masterDataTable.Rows[0]; partAct = ConvertDataRowToDetailDataModel(row); if (withMaster) { partAct.Parent = GetPartAct(partAct.ParentId); } } return(partAct); }
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)); }
public IActionResult AddDetail(CreatePartnerActivityDetailDto model) { if (ModelState.IsValid) { var currentRoleId = _PartnerManager.GetCurrentUserRole(this.HttpContext); var permission = _partActRepo.GetPartAct("PartnerActivity.Detail.Create", currentRoleId); if (permission == null) { toastNotification.AddErrorToastMessage("ليس لديك الصلاحية الكافية", new ToastrOptions { Title = "" }); return(Redirect(Request.Headers["Referer"].ToString())); } var masterModel = _partActRepo.GetPartAct(model.ParentId); if (masterModel == null) { return(null); } var originObject = new PartnerActivityDetail(); 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.CreateDetail(originObject); if (result.Success) { return(RedirectToAction("Detail", new { id = model.ParentId })); } } model.ToRoles = new RoleRepo(db, _partActRepo).GetRoles(); return(View(model)); }
public OpertionResult UpdateDetail(PartnerActivityDetail model) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_row_id", OracleDbType = OracleDbType.Int32, Value = model.Id }, new OracleParameter { ParameterName = "v_master_row", OracleDbType = OracleDbType.Int32, Value = model.ParentId }, new OracleParameter { ParameterName = "v_dest_role_id", OracleDbType = OracleDbType.Int32, Value = model.ToRole.Id }, new OracleParameter { ParameterName = "v_check_bal", OracleDbType = OracleDbType.Int32, Value = model.CheckBalanceRequired ? 1 : 0 }, new OracleParameter { ParameterName = "v_max_value", OracleDbType = OracleDbType.Decimal, Value = model.MaxValue }, new OracleParameter { ParameterName = "v_min_value", OracleDbType = OracleDbType.Decimal, Value = model.MinValue }, new OracleParameter { ParameterName = "v_bonus_per", OracleDbType = OracleDbType.Decimal, Value = model.BonusPercent }, new OracleParameter { ParameterName = "v_taxper", OracleDbType = OracleDbType.Decimal, Value = model.TaxPercent }, new OracleParameter { ParameterName = "v_bonus_tax", OracleDbType = OracleDbType.Decimal, Value = model.BonusTaxPercent }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = model.CreatedBy.Id }, new OracleParameter { ParameterName = "v_fixed_factor", OracleDbType = OracleDbType.Decimal, Value = model.FixedFactor } }; #endregion db.ExecuteStoredProc("pk_settings.fn_updatepartneractivitydetail", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); 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 }); } }