public static async Task <long> AddAsync(string tenant, GiftCardFund model)
{
const string sql =
@"SELECT * FROM sales.add_gift_card_fund(@0::integer, @1::integer, @2::bigint, sales.get_gift_card_id_by_gift_card_number(@3), @4::date, @5::date, @6::integer, @7::public.money_strict, @8::integer, @9, @10);";
return
(await
Factory.ScalarAsync <long>(tenant, sql, model.UserId, model.OfficeId, model.LoginId, model.GiftCardNumber, model.ValueDate, model.BookDate, model.AccountId, model.Amount,
model.CostCenterId, model.ReferenceNumber, model.StatementReference).ConfigureAwait(false));
}
public static async Task <long> AddAsync(string tenant, GiftCardFund model)
{
string sql = @"SELECT * FROM sales.add_gift_card_fund(@0::integer, @1::integer, @2::bigint, sales.get_gift_card_id_by_gift_card_number(@3), @4::date, @5::date, @6::integer, @7::public.money_strict, @8::integer, @9, @10);";
if (DbProvider.GetDbType(DbProvider.GetProviderName(tenant)) == DatabaseType.SqlServer)
{
sql = FrapidDbServer.GetProcedureCommand(tenant, "sales.add_gift_card_fund", new[] { "@0", "@1", "@2", "@3", "@4", "@5", "@6", "@7", "@8", "@9", "@10" });
}
return(await Factory.ScalarAsync <long>(tenant, sql, model.UserId, model.OfficeId, model.LoginId, model.GiftCardNumber, model.ValueDate, model.BookDate, model.AccountId, model.Amount,
model.CostCenterId, model.ReferenceNumber, model.StatementReference).ConfigureAwait(false));
}
public async Task <ActionResult> AddFundEntryAsync(GiftCardFund model)
{
if (!this.ModelState.IsValid)
{
return(this.InvalidModelState(this.ModelState));
}
try
{
var meta = await AppUsers.GetCurrentAsync().ConfigureAwait(true);
model.OfficeId = meta.OfficeId;
model.UserId = meta.UserId;
model.LoginId = meta.LoginId;
long id = await GiftCardFunds.AddAsync(this.Tenant, model).ConfigureAwait(true);
return(this.Ok(id));
}
catch (Exception ex)
{
return(this.Failed(ex.Message, HttpStatusCode.InternalServerError));
}
}
