internal async Task <JsonResult> IQCDeleteLine(IQC delete)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("iqc_line_delete", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.AddWithValue("@grn_line_no", delete.GRNLineNo);
smd.Parameters.AddWithValue("@grn_no", delete.GRNHeaderNo);
smd.Parameters.AddWithValue("@rejection_reason", delete.RejectionReason);
smd.Parameters.AddWithValue("@barcode", delete.Barcode);
smd.Parameters.AddWithValue("@bincode", delete.Bincode);
smd.Parameters.AddWithValue("@quantity", delete.Quantity);
smd.Parameters.AddWithValue("@vendor_lot_no", delete.VendorLotNo);
smd.Parameters.AddWithValue("@expire_date", delete.ExpireDate);
smd.Parameters.Add("@iqcheaderOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.Add("@iqc_lines", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string iqcheader = smd.Parameters["@iqcheaderOutput"].Value.ToString();
string iqc_lines = smd.Parameters["@iqc_lines"].Value.ToString();
smd.Dispose();
List <IQCResponse> response = new List <IQCResponse>();
IQCResponse data = new IQCResponse()
{
Header = JArray.Parse(iqcheader),
Lines = JArray.Parse(iqc_lines)
};
response.Add(data);
return(new JsonResult(response));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
internal async Task <JsonResult> IQCData(IQC grn_no)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("iqc_start_info_by_grn_no", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.AddWithValue("@grn_no", grn_no.GRNHeaderNo);
smd.Parameters.Add("@iqcheaderOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.Add("@iqc_lines", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string iqcheader = smd.Parameters["@iqcheaderOutput"].Value.ToString();
string iqc_lines = smd.Parameters["@iqc_lines"].Value.ToString();
smd.Dispose();
List <IQCResponse> response = new List <IQCResponse>();
IQCResponse data = new IQCResponse()
{
Header = JArray.Parse(iqcheader),
Lines = JArray.Parse(iqc_lines)
};
response.Add(data);
return(new JsonResult(response));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
