internal async Task <JsonResult> BarcodePrintInfoNAV(BarcodeGenrate barcodeGenrate)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
using (SqlCommand smd = new SqlCommand("barcode_vendor_info", cn))
{
smd.CommandType = System.Data.CommandType.StoredProcedure;
smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.AddWithValue("@mrp", barcodeGenrate.MRP);
smd.Parameters.AddWithValue("@vendor_no", barcodeGenrate.VendorNo);
smd.Parameters.AddWithValue("@vendor_name", barcodeGenrate.VendorName);
smd.Parameters.AddWithValue("@vendor_address", barcodeGenrate.VendorAddress);
smd.Parameters.AddWithValue("@vendor_city", barcodeGenrate.VendorCity);
smd.Parameters.AddWithValue("@vendor_country", barcodeGenrate.VendorCountry);
smd.Parameters.AddWithValue("@barcode", barcodeGenrate.Barcode);
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string json = smd.Parameters["@jsonOutput"].Value.ToString();
JArray arr = JArray.Parse(json);
return(new JsonResult(arr));
}
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
public async Task <JsonResult> BarcodePrintInfoNAV([FromBody] BarcodeGenrate barcodeGenrate)
{
try
{
return(await _barcodeGenrateLogic.BarcodePrintInfoNAV(barcodeGenrate).ConfigureAwait(false));
}
catch (Exception ee)
{
return(await _barcodeGenrateLogic.SendRespose("False", ee.Message).ConfigureAwait(false));
}
}
public async Task <IActionResult> PrintBarcodeReport([FromBody] BarcodeGenrate barcodeGenrate)
{
//string fileUrl = "";
//try
//{
// DataSet ds = await _barcodeGenrateLogic.PrintBarcodeReport(barcodeGenrate).ConfigureAwait(false);
// if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0 && ds.Tables[1].Rows[0]["condition"].ToString().Equals("True", StringComparison.OrdinalIgnoreCase))
// {
// XtraReport report = XtraReport.FromFile("Reports/BarcodeReport.repx");
// report.ExportOptions.Pdf.Compressed = true;
// report.DataSource = ds.Tables[1];
// report.DataMember = ds.Tables[1].TableName;
// if (!Directory.Exists(Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "Reports")))
// {
// Directory.CreateDirectory(Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "Reports"));
// }
// fileUrl = Directory.GetCurrentDirectory() + "/wwwroot/Reports/" + barcodeGenrate.Barcode.Replace("/", "_") + ".pdf";
// if (System.IO.File.Exists(fileUrl))
// {
// System.IO.File.Delete(fileUrl);
// }
// new PdfStreamingExporter(report, true).Export(fileUrl);
// Response.Headers.Add("filename", barcodeGenrate.Barcode.Replace("/", "_") + ".pdf");
// return File(System.IO.File.ReadAllBytes(fileUrl), "application/pdf", barcodeGenrate.Barcode.Replace("/", "_") + ".pdf");
// }
// else if (ds.Tables.Count > 1)
// {
// return new JsonResult(ds.Tables[1]);
// }
// return await _barcodeGenrateLogic.SendRespose("True", "Fail get Get Data.").ConfigureAwait(false);
//}
//catch (Exception ee)
//{
// return await _barcodeGenrateLogic.SendRespose("False", ee.Message).ConfigureAwait(false);
//}
//finally
//{
// if (System.IO.File.Exists(fileUrl))
// {
// System.IO.File.Delete(fileUrl);
// }
//}\
return(await _barcodeGenrateLogic.SendRespose("False", "").ConfigureAwait(false));
}
internal async Task <DataSet> PrintBarcodeReport(BarcodeGenrate barcodeGenrate)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlDataAdapter da = new SqlDataAdapter("barcode_all_info_to_print", cn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@barcode", barcodeGenrate.Barcode);
da.SelectCommand.Parameters.AddWithValue("@times", barcodeGenrate.No);
DataSet dt = new DataSet();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
