/// <summary> /// GEt Account informaion /// </summary> /// <param name="check"></param> /// <returns></returns> public AccountInformationModel GetAccountInformation(OnHoldChecksModel check) { using (SqlConnection connection = new SqlConnection(_connectionString)) { var accountInformation = new AccountInformationModel(); string sql = "dbo.PCN_GET_ACCOUNTINFORMATION_HOLDCHECKS"; var p = new DynamicParameters(); p.Add("@Account", check.Account, dbType: DbType.String, direction: ParameterDirection.Input); p.Add("@Location", check.LocationId, dbType: DbType.Int32, direction: ParameterDirection.Input); p.Add("@Deposit", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@Returned", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@Porcent", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@DepositLastDay", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@ReturnedLastDay", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@TimeAgency", 0, dbType: DbType.DateTime, direction: ParameterDirection.Output); p.Add("@TimeMaker", 0, dbType: DbType.DateTime, direction: ParameterDirection.Output); var result = connection.Query <AccountInformationModel>(sql, p, commandType: CommandType.StoredProcedure).ToList(); if (result != null) { accountInformation = result.FirstOrDefault(); } return(accountInformation); } }
/// <summary> /// Update check Information /// </summary> /// <param name="check"></param> /// <param name="user"></param> /// <returns></returns> public string UpdateCheckInformation(OnHoldChecksModel check, string user) { if (!string.IsNullOrEmpty(check.Notes)) { _onHoldRepositoryWrite.UpdateCheckNotes(check, user); } return(_onHoldRepositoryWrite.UpdateCheckInformation(check, user)); }
/// <summary> /// Add hold list. /// </summary> /// <param name="hold"></param> /// <returns></returns> private OnHoldDescriptionModel AddHoldToList(OnHoldChecksModel hold) { return(new OnHoldDescriptionModel() { IdHold = hold.IdHold.ToString(), NameHold = hold.NameHold, IdGroupHold = hold.IdGroupHold }); }
/// <summary> /// Update notes in crm for each check /// </summary> /// <param name="check"></param> /// <param name="user"></param> /// <returns></returns> public string UpdateCheckNotes(OnHoldChecksModel check, string user) { using (SqlConnection connection = new SqlConnection(_connectionString)) { string response = string.Empty; string sql = "dbo.spAddMessageByCheckToCRM"; var p = new DynamicParameters(); p.Add("@checkId", check.CheckID, dbType: DbType.Int32, direction: ParameterDirection.Input); p.Add("@message", check.Notes, dbType: DbType.String, direction: ParameterDirection.Input); p.Add("@username", user, dbType: DbType.String, direction: ParameterDirection.Input); p.Add("@error", string.Empty, dbType: DbType.String, direction: ParameterDirection.Output); connection.Execute(sql, p, commandType: CommandType.StoredProcedure); response = p.Get <string>("@error"); return(response); } }
/// <summary> /// Update check Information /// </summary> /// <param name="check"></param> /// <param name="user"></param> /// <returns></returns> public string UpdateCheckInformation(OnHoldChecksModel check, string user) { using (SqlConnection connection = new SqlConnection(_connectionString)) { string response = string.Empty; string sql = "Viacheck.PCN_UpdateCheckOnHoldInfo"; var p = new DynamicParameters(); p.Add("@AMOUNT", check.Amount, dbType: DbType.Int64, direction: ParameterDirection.Input); p.Add("@ACCOUNT", check.Account, dbType: DbType.String, direction: ParameterDirection.Input); p.Add("@CHECKID", check.CheckID, dbType: DbType.Int32, direction: ParameterDirection.Input); p.Add("@CHECK_NUMBER", check.CheckNumber, dbType: DbType.String, direction: ParameterDirection.Input); p.Add("@ABA", check.Transit, dbType: DbType.String, direction: ParameterDirection.Input); p.Add("@USERNAME", user, dbType: DbType.String, direction: ParameterDirection.Input); p.Add("@ISVCP", false, dbType: DbType.Boolean, direction: ParameterDirection.Input); p.Add("@error", string.Empty, dbType: DbType.String, direction: ParameterDirection.Output); connection.Execute(sql, p, commandType: CommandType.StoredProcedure); response = p.Get <string>("@error"); return(response); } }
public async Task <OnHoldResponseModel> GetAccountInformation([FromBody] OnHoldChecksModel checkParameters) { try { return(new OnHoldResponseModel() { Status = new MessageResponseModel { Code = MessageResponse.SUCCESS_CODE }, AccountInformation = _onHoldBussines.GetAccountInformation(checkParameters) }); } catch (Exception ex) { _viamLogger.Error(ex); return(new OnHoldResponseModel() { Status = new MessageResponseModel { Code = MessageResponse.ERROR_CODE, Message = ex.Message } }); } }
/// <summary> /// Get Account informaion /// </summary> /// <param name="check"></param> /// <returns></returns> public AccountInformationModel GetAccountInformation(OnHoldChecksModel check) { return(_onHoldRepositoryRead.GetAccountInformation(check)); }