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