public async Task<IHttpActionResult> CreatePickupReceipt(PickupReceiptBindingModel model) { if (!ModelState.IsValid) { return Ok(StatusResult<PickupReceiptResultBindingModel>.Error("Model is Invalid")); } var response = await PickupManager.CreatePickupReceiptAsync(model); return Ok(response); }
private static async Task<StatusResult<PickupReceiptResultBindingModel>> CreatePickupReceiptStoredProcedureHelper(PickupReceiptBindingModel model) { PickupReceiptResultBindingModel result = null; try { // using a stored procedure to handle var db = BottleRocketDbContext.Create(); string sql = "exec SpCreatePickupReceipts {0}, {1}, {2}, {3}"; var query = await db.Database.SqlQuery<PickupReceiptResultBindingModel>(sql, model.UserId, model.PickupCycleId, model.TotalAmount, model.BagCount).FirstOrDefaultAsync(); if (query == null) { return StatusResult<PickupReceiptResultBindingModel>.Error("Query result is null"); } result = query; } catch (Exception ex) { return StatusResult<PickupReceiptResultBindingModel>.Error(ex.Message, result); } return StatusResult<PickupReceiptResultBindingModel>.Success(result); }
public static async Task<StatusResult<PickupReceiptResultBindingModel>> CreatePickupReceiptAsync(PickupReceiptBindingModel model) { return await CreatePickupReceiptStoredProcedureHelper(model); }