internal async Task <JsonResult> SlotInfo(SlotReport slotReport) { SqlConnection cn = null; try { cn = Connection.GetConnection(); SqlCommand smd = new SqlCommand("slot_report", cn) { CommandType = CommandType.StoredProcedure }; smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; smd.Parameters.AddWithValue("@flag", slotReport.flag); smd.Parameters.AddWithValue("@zone", slotReport.zone); smd.Parameters.AddWithValue("@order_no", slotReport.order_no); smd.Parameters.AddWithValue("@location_id", slotReport.LocationId); await smd.ExecuteNonQueryAsync().ConfigureAwait(false); string json = smd.Parameters["@jsonOutput"].Value.ToString(); smd.Dispose(); JArray arr = JArray.Parse(json); return(new JsonResult(arr)); } catch (Exception) { throw; } finally { Connection.CloseConnection(ref cn); } }
public async Task <JsonResult> SlotInfo([FromBody] SlotReport slotReport) { try { return(await _reportLogic.SlotInfo(slotReport).ConfigureAwait(false)); } catch (Exception e) { return(await _reportLogic.SendRespose("False", e.Message).ConfigureAwait(false)); } }