/// <summary> /// Getmultiples holds by rol /// </summary> /// <param name="agencyCode">Agency Code</param> /// <param name="categoryHold">Category Id</param> /// <param name="dateFrom">Date from</param> /// <param name="dateTo">Date To</param> /// <param name="amount">Amount</param> /// <param name="user">User login</param> /// <returns>Hold results</returns> public List <OnHoldChecksModel> GetMultiplesHoldsData(OnHoldFiltersModels filters) { using (SqlConnection connection = new SqlConnection(_connectionString)) { var holdList = new List <OnHoldChecksModel>(); string sql = "Viacheck.PCN_GetChecksMultipleHolds"; var p = new DynamicParameters(); p.Add("@agencyCode", filters.AgencyCode, dbType: DbType.Int32, direction: ParameterDirection.Input); p.Add("@groupHold", filters.CategoryHold, dbType: DbType.Int32, direction: ParameterDirection.Input); p.Add("@dateFrom", filters.DateFrom, dbType: DbType.DateTime, direction: ParameterDirection.Input); p.Add("@dateTo", filters.DateTo, dbType: DbType.DateTime, direction: ParameterDirection.Input); p.Add("@amount", filters.Amount, dbType: DbType.Decimal, direction: ParameterDirection.Input); p.Add("@user", filters.User, dbType: DbType.String, direction: ParameterDirection.Input); holdList = connection.Query <OnHoldChecksModel>(sql, p, commandType: CommandType.StoredProcedure).ToList(); return(holdList); } }
public async Task <OnHoldResponseModel> GetChecksOnHoldV1([FromBody] OnHoldFiltersModels holdParameters) { try { return(new OnHoldResponseModel() { Status = new MessageResponseModel { Code = MessageResponse.SUCCESS_CODE }, HoldResults = _onHoldBussines.GetChecksOnHoldV1(holdParameters) }); } catch (Exception ex) { _viamLogger.Error(ex); return(new OnHoldResponseModel() { Status = new MessageResponseModel { Code = MessageResponse.ERROR_CODE, Message = ex.Message } }); } }
public List <OnHoldChecksModel> GetChecksOnHoldV1(OnHoldFiltersModels filters) { var checkHoldList = _onHoldRepositoryRead.GetMultiplesHoldsDataV1(filters); return(checkHoldList); }
public List <OnHoldChecksModel> GetChecksOnHold(OnHoldFiltersModels filters) { var checkHoldList = new List <OnHoldChecksModel>(); var checkIdsList = _onHoldRepositoryRead.GetMultiplesHoldsData(filters); var checkList = (from chk in checkIdsList select chk.CheckID).Distinct(); foreach (var checkId in checkList.ToList()) { var checkHoldsList = (from chk in checkIdsList where chk.CheckID == checkId select chk ).ToList(); var check = checkHoldsList.FirstOrDefault(); var arrayStatusDescription = this.GetDescriptionCheck(check.Description.ToString()); var isDefinitive = arrayStatusDescription.Length == 3 ? arrayStatusDescription[1] : string.Empty; List <OnHoldDescriptionModel> holds = this.GetHoldsByCheck(checkHoldsList, isDefinitive); string holdColor = "#000000"; if (isDefinitive == "1") { holdColor = "red"; } else { var holdPriority = (from obj in checkHoldsList select obj).Min(c => c.HoldPriority); holdColor = (from obj in checkHoldsList where obj.HoldPriority == holdPriority select obj).FirstOrDefault().HoldColor; } checkHoldList.Add(new OnHoldChecksModel() { CheckID = check.CheckID, BatchID = check.BatchID, CheckStatus = check.CheckStatus, Amount = check.Amount, Transit = check.Transit, CheckNumber = check.CheckNumber, Account = check.Account, Created = check.Created, LocationName = check.LocationName, RefImageKey = check.RefImageKey, Notes = check.Notes, OwnLicense = check.OwnLicense, FinCen = check.FinCen, Holds = holds, HighlightedField = check.HighlightedField, LocationId = check.LocationId, GiactValidation = check.GiactValidation.ToString(), Description = DescriptionHelper(arrayStatusDescription, check.Description), IsDefinitive = isDefinitive, HoldColor = holdColor, VerifyHoldNoShowed = (holds.Count != checkHoldsList.Count), OriginalAccount = check.Account, OriginalAmount = check.Amount, OriginalCheckNumber = check.CheckNumber, OriginalTransit = check.Transit }); } return(checkHoldList); }