public ActionResult Prints(DataTable Dt)
{
try
{
// DataTable Dt = new DataTable();
List <byte[]> PdfStream = new List <byte[]>();
DirectReportPrint drp = new DirectReportPrint();
byte[] Pdf;
Pdf = drp.DirectPrint(Dt, User.Identity.Name);
PdfStream.Add(Pdf);
PdfMerger pm = new PdfMerger();
byte[] Merge = pm.MergeFiles(PdfStream);
if (Merge != null)
{
return(File(Merge, "application/pdf"));
}
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
return(Json(new { success = "Error", data = message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = "Success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult GeneratePrints(string ActionName, int Id = 0)
{
string PrintProcedure = "";
if (!string.IsNullOrEmpty(ActionName))
{
var Settings = new StockInHandSettingService(_unitOfWork).GetTrailBalanceSetting(User.Identity.Name);
string SqlParameterGroupOn;
string SqlParameterShowBalance;
string SqlParameterProdType;
string SqlParameterSiteId = Settings.SiteIds;
string DivisionId = Settings.DivisionIds;
string SqlParameterFromDate = Settings.FromDate.HasValue ? Settings.FromDate.Value.ToString("dd/MMM/yyyy") : "";
string SqlParameterToDate = Settings.ToDate.HasValue ? Settings.ToDate.Value.ToString("dd/MMM/yyyy") : "";
SqlParameterProdType = Id.ToString();
if (string.IsNullOrEmpty(Settings.GroupOn))
{
SqlParameterGroupOn = "NULL";
}
else
{
SqlParameterGroupOn = Settings.GroupOn.ToString();
}
if (string.IsNullOrEmpty(Settings.ShowBalance) || Settings.ShowBalance == StockInHandShowBalanceConstants.All)
{
SqlParameterShowBalance = "NULL";
}
else
{
SqlParameterShowBalance = Settings.ShowBalance.ToString();
}
if (ActionName == "StockInHand")
{
PrintProcedure = "Web.spStockInHand @ProductType ='" + SqlParameterProdType.ToString() + "', @Site='" + SqlParameterSiteId.ToString() + "', @FromDate='" + SqlParameterFromDate.ToString() + "', @ToDate='" + SqlParameterToDate.ToString() + "', @GroupOn='" + SqlParameterGroupOn.ToString() + "'";
}
try
{
DataTable Dt = new DataTable();
List <byte[]> PdfStream = new List <byte[]>();
DirectReportPrint drp = new DirectReportPrint();
byte[] Pdf;
Pdf = drp.DirectPrint(Dt, User.Identity.Name);
PdfStream.Add(Pdf);
PdfMerger pm = new PdfMerger();
byte[] Merge = pm.MergeFiles(PdfStream);
if (Merge != null)
{
return(File(Merge, "application/pdf"));
}
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
return(Json(new { success = "Error", data = message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = "Success" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = "Error", data = "No Records Selected." }, JsonRequestBehavior.AllowGet));
}
