internal async Task <JsonResult> CreateReturn(ReturnManifest returnManifest) { SqlConnection cn = null; try { cn = Connection.GetConnection(); SqlCommand smd = new SqlCommand("return_manifest_create", cn) { CommandType = CommandType.StoredProcedure }; smd.Parameters.AddWithValue("@location_id", returnManifest.LocationId); smd.Parameters.AddWithValue("@dsp_code", returnManifest.DSP); smd.Parameters.AddWithValue("@created_by", returnManifest.CreatedBy); smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; 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); } }
internal async Task <JsonResult> AWBScan(ReturnManifest returnManifest) { SqlConnection cn = null; try { cn = Connection.GetConnection(); SqlCommand smd = new SqlCommand("return_manifest_scan", cn) { CommandType = CommandType.StoredProcedure }; smd.Parameters.AddWithValue("@return_manifest", returnManifest.ReturnManifestNo); smd.Parameters.AddWithValue("@awb_no", returnManifest.AWBNo); smd.Parameters.AddWithValue("@return_reason", returnManifest.Returnreson); smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; 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> Complete([FromBody] ReturnManifest returnManifest) { try { return(await _returnManifestLogic.Complete(returnManifest).ConfigureAwait(false)); } catch (Exception ee) { return(await _returnManifestLogic.SendRespose("False", ee.Message).ConfigureAwait(false)); } }