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