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 Ids, int DocTypeId)
{
if (!string.IsNullOrEmpty(Ids))
{
int SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var Settings = new SaleOrderSettingsService(_unitOfWork).GetSaleOrderSettingsForDocument(DocTypeId, DivisionId, SiteId);
if (new RolePermissionService(_unitOfWork).IsActionAllowed(UserRoles, DocTypeId, Settings.ProcessId, this.ControllerContext.RouteData.Values["controller"].ToString(), "GeneratePrints") == false)
{
return(View("~/Views/Shared/PermissionDenied.cshtml").Warning("You don't have permission to do this task."));
}
try
{
List <byte[]> PdfStream = new List <byte[]>();
foreach (var item in Ids.Split(',').Select(Int32.Parse))
{
DirectReportPrint drp = new DirectReportPrint();
var pd = context.SaleOrderHeader.Find(item);
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pd.DocTypeId,
DocId = pd.SaleOrderHeaderId,
ActivityType = (int)ActivityTypeContants.Print,
DocNo = pd.DocNo,
DocDate = pd.DocDate,
DocStatus = pd.Status,
}));
byte[] Pdf;
if (pd.Status == (int)StatusConstants.Drafted || pd.Status == (int)StatusConstants.Import || pd.Status == (int)StatusConstants.Modified)
{
//LogAct(item.ToString());
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
else if (pd.Status == (int)StatusConstants.Submitted || pd.Status == (int)StatusConstants.ModificationSubmitted)
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint_AfterSubmit, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
else
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint_AfterApprove, User.Identity.Name, item);
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));
}
public ActionResult GeneratePrints(string ActionName, int LedgerAccountGroupId = 0)
{
string PrintProcedure = "";
if (!string.IsNullOrEmpty(ActionName))
{
var settings = new TrialBalanceSettingService(_unitOfWork).GetTrailBalanceSetting(User.Identity.Name);
string SiteId = settings.SiteIds;
string DivisionId = settings.DivisionIds;
string FromDate = settings.FromDate.HasValue ? settings.FromDate.Value.ToString("dd/MMM/yyyy") : "";
string ToDate = settings.ToDate.HasValue ? settings.ToDate.Value.ToString("dd/MMM/yyyy") : "";
if (ActionName == "BalanceSheet")
{
PrintProcedure = "Web.spBalanceSheet '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + FromDate.ToString() + "','" + ToDate.ToString() + "'";
}
else if (ActionName == "ProfitAndLoss")
{
PrintProcedure = "Web.spProfitAndLoss '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + FromDate.ToString() + "','" + ToDate.ToString() + "'";
}
else if (ActionName == "TrialBalanceSummary")
{
PrintProcedure = "Web.spTrialBalanceSummary '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + FromDate.ToString() + "','" + ToDate.ToString() + "'";
}
else if (ActionName == "TrialBalance")
{
PrintProcedure = "Web.spTrialBalance '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + ToDate.ToString() + "'";
}
else if (ActionName == "SubTrialBalanceSummary")
{
if (LedgerAccountGroupId == 0)
{
PrintProcedure = "Web.spSubTrialBalanceSummary '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + FromDate.ToString() + "','" + ToDate.ToString() + "'";
}
else
{
PrintProcedure = "Web.spSubTrialBalanceSummary '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + FromDate.ToString() + "','" + ToDate.ToString() + "','" + LedgerAccountGroupId.ToString() + "'";
}
}
else if (ActionName == "SubTrialBalance")
{
if (LedgerAccountGroupId == 0)
{
PrintProcedure = "Web.spSubTrialBalance '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + ToDate.ToString() + "'";
}
else
{
PrintProcedure = "Web.spSubTrialBalance '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + ToDate.ToString() + "','" + LedgerAccountGroupId.ToString() + "'";
}
}
else if (ActionName == "LedgerBalance")
{
if (LedgerAccountGroupId == 0)
{
PrintProcedure = "Web.spLedger '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + FromDate.ToString() + "','" + ToDate.ToString() + "'";
}
else
{
PrintProcedure = "Web.spLedger '" + SiteId.ToString() + "','" + DivisionId.ToString() + "','" + FromDate.ToString() + "','" + ToDate.ToString() + "','" + LedgerAccountGroupId.ToString() + "'";
}
}
try
{
List <byte[]> PdfStream = new List <byte[]>();
DirectReportPrint drp = new DirectReportPrint();
byte[] Pdf;
Pdf = drp.DirectDocumentPrint(PrintProcedure, 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));
}
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));
}
public ActionResult GeneratePrints(string Ids, int DocTypeId)
{
if (!string.IsNullOrEmpty(Ids))
{
int SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var Settings = new PurchaseOrderSettingService(_unitOfWork).GetPurchaseOrderSettingForDocument(DocTypeId, DivisionId, SiteId);
try
{
List <byte[]> PdfStream = new List <byte[]>();
foreach (var item in Ids.Split(',').Select(Int32.Parse))
{
DirectReportPrint drp = new DirectReportPrint();
var pd = db.PurchaseOrderAmendmentHeader.Find(item);
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pd.DocTypeId,
DocId = pd.PurchaseOrderAmendmentHeaderId,
ActivityType = (int)ActivityTypeContants.Print,
DocNo = pd.DocNo,
DocDate = pd.DocDate,
DocStatus = pd.Status,
}));
byte[] Pdf;
if (pd.Status == (int)StatusConstants.Drafted || pd.Status == (int)StatusConstants.Import || pd.Status == (int)StatusConstants.Modified)
{
//LogAct(item.ToString());
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
else if (pd.Status == (int)StatusConstants.Submitted || pd.Status == (int)StatusConstants.ModificationSubmitted)
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint_AfterSubmit, User.Identity.Name, item);
PdfStream.Add(Pdf);
}
else
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint_AfterApprove, User.Identity.Name, item);
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));
}
public byte[] GetReport(string Ids, int DocTypeId, string UserName)
{
int SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var Settings = new JobReceiveSettingsService(_unitOfWork).GetJobReceiveSettingsForDocument(DocTypeId, DivisionId, SiteId);
string ReportSql = "";
if (!string.IsNullOrEmpty(Settings.DocumentPrint))
{
ReportSql = GetReportHeader(Settings.DocumentPrint).ReportSQL;
}
List <byte[]> PdfStream = new List <byte[]>();
foreach (var item in Ids.Split(',').Select(Int32.Parse))
{
DirectReportPrint drp = new DirectReportPrint();
var pd = Find(item);
byte[] Pdf;
if (!string.IsNullOrEmpty(ReportSql))
{
Pdf = drp.rsDirectDocumentPrint(ReportSql, UserName, item);
PdfStream.Add(Pdf);
}
else
{
if (pd.Status == (int)StatusConstants.Drafted || pd.Status == (int)StatusConstants.Import || pd.Status == (int)StatusConstants.Modified)
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint, UserName, item);
PdfStream.Add(Pdf);
}
else if (pd.Status == (int)StatusConstants.Submitted || pd.Status == (int)StatusConstants.ModificationSubmitted)
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint_AfterSubmit, UserName, item);
PdfStream.Add(Pdf);
}
else
{
Pdf = drp.DirectDocumentPrint(Settings.SqlProcDocumentPrint_AfterApprove, UserName, item);
PdfStream.Add(Pdf);
}
}
_logger.LogActivityDetail(logVm.Map(new ActiivtyLogViewModel
{
DocTypeId = pd.DocTypeId,
DocId = pd.JobReceiveHeaderId,
ActivityType = (int)ActivityTypeContants.Print,
DocNo = pd.DocNo,
DocDate = pd.DocDate,
DocStatus = pd.Status,
}));
}
PdfMerger pm = new PdfMerger();
byte[] Merge = pm.MergeFiles(PdfStream);
return(Merge);
}
