/// <summary>
/// Сохранение настроек печати в БД по кредитной организации
/// </summary>
/// <param name="parameters">настройки печати</param>
/// <returns>результат выполнения запроса</returns>
public int SetUserPrintProperties(ReportRequestPrintParameters parameters)
{
using (var sqlConnect = Connections.GetLM())
{
var sql = @"IF EXISTS(SELECT CreditOrgId FROM BankValues.CassetePrintProperties where CreditOrgId = @CreditOrgId and UserId=@userId)
UPDATE BankValues.CassetePrintProperties
set
UserId = @UserId,
BottomField = @BottomField,
TopField = @TopField,
LeftField = @LeftField,
RightField = @RightField,
ColumnMargin = @ColumnMargin,
RowMargin = @RowMargin
where CreditOrgId = @CreditOrgId and UserId=@userId
ELSE
INSERT INTO BankValues.CassetePrintProperties
(
CreditOrgId,
UserId,
BottomField,
TopField,
LeftField,
RightField,
ColumnMargin,
RowMargin
)
values
(
@CreditOrgId,
@UserId,
@BottomField,
@TopField,
@LeftField,
@RightField,
@ColumnMargin,
@RowMargin
)
";
var result = sqlConnect.ExecuteScalar <int>(sql, new
{
parameters.UserId,
parameters.CreditOrgId,
parameters.BottomField,
parameters.LeftField,
parameters.RightField,
parameters.TopField,
parameters.ColumnMargin,
parameters.RowMargin,
});
return(result);
}
}
public int SetUserPrintProperties(
[FromBody][Required(ErrorMessage = "Не задан обязательный параметр `ReportRequestPrintParameters`")] ReportRequestPrintParameters parameters)
{
return(_serviceQR.SetUserPrintProperties(parameters));
}
public int SetUserPrintProperties(ReportRequestPrintParameters parameters)
{
return(_casseteQrCodesRepo.SetUserPrintProperties(parameters));
}
