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