public ActionResult CashBookPdf(RptSearchVModel vmodel) { vmodel.fDate = Convert.ToDateTime(Session["fDate"]); vmodel.toDate = Convert.ToDateTime(Session["tDate"]); string finyear = Session["FinYear"].ToString(); vmodel.BranchCode = Session["Branch"].ToString(); string sql = string.Format("EXEC rptCashBook '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.toDate.ToString("MM/dd/yyyy") + "'"); List <CashBook> cashBook = _CashBookService.SqlQueary(sql).ToList(); ViewBag.Datef = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.Datet = InWord.GetAbbrMonthNameDate(vmodel.toDate); ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch; if (vmodel.BranchCode != "" && vmodel.BranchCode != "0") { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(new Rotativa.ViewAsPdf("CashBookPdf", cashBook) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult ItemWiseSalesStatementRptPdf(DateTime fDate, DateTime tDate, string BranchCode, string LocCode, string FinYear, string ItemCode) { string sql = string.Format("Exec rpt_ItemWiseSalesStat '" + BranchCode + "','" + LocCode + "','" + ItemCode + "', '" + fDate.ToString("yyyy/MM/dd") + "', '" + tDate.ToString("yyyy/MM/dd") + "'"); IEnumerable <ItemWiseSaleVM> VchrLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <ItemWiseSaleVM>(sql).ToList(); } ViewBag.LocName = _locationService.All().Where(s => s.LocCode == LocCode).Select(x => x.LocName).FirstOrDefault(); ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(new Rotativa.ViewAsPdf("rpt_ItemWiseSalesStatementPdf", "", VchrLst) { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult MontlyQuantityRptPdf(DateTime fDate, DateTime tDate, string ProjCode, string BranchCode, string FinYear) { string customerGroup = ""; //rpt_SP_ProdSales_Qty @fdate smalldatetime, @tdate smalldatetime, @ProjCode varchar(3), @BranchCode string sql = string.Format("EXEC rpt_SP_ProdSales_Qty '" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + ProjCode + "', '" + BranchCode + "'"); IEnumerable <MontlyQuantity> VchrLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <MontlyQuantity>(sql).ToList(); } var FY = FinYear; ViewBag.BranchCode = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault(); //ViewBag.fDate = fDate.ToString("dd-MMM-yyyy"); //ViewBag.tDate = tDate.ToString("dd-MMM-yyyy"); ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //Response.AppendHeader("Content-Disposition", "inline; filename=" + RptName + "_" + DateTime.Now.ToShortDateString() + ".pdf"); return(new Rotativa.ViewAsPdf("rptSalesCollectionStatePdf", "", VchrLst) { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult JobWiseRecPayPdf(string ProjCode, string BranchCode, string JobNo, string fDate, string tDate) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("RptJobWiseRecPay_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("JobWiseRecPay", "JobWiseRecPay", new { errMsg })); } if (BranchCode == null) { BranchCode = Session["BranchCode"].ToString(); } ViewBag.fDate = InWord.GetAbbrMonthNameDate(Convert.ToDateTime(fDate)); ViewBag.tDate = InWord.GetAbbrMonthNameDate(Convert.ToDateTime(tDate)); string sql = string.Format("Exec rpt_JobRecPay '" + Session["FinYear"].ToString() + "','" + ProjCode + "','" + BranchCode + "','" + JobNo + "','" + Convert.ToDateTime(fDate).ToString("yyyy/MM/dd") + "','" + Convert.ToDateTime(tDate).ToString("yyyy/MM/dd") + "',''"); List <rptJobWiseVM> JobWiseRecPay = _JobWiseReportService.SqlQueary(sql).ToList(); Response.AppendHeader("Content-Disposition", "inline; filename= JobWiseIncExp" + DateTime.Now.ToShortDateString() + ".pdf"); return(new Rotativa.ViewAsPdf("JobWiseRecPayPdf", "", JobWiseRecPay) { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, //FileName = RptName + "-" + DateTime.Now.ToShortDateString() + ".pdf" , contStatementReportPdf CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult StoreRptPdf(DateTime fDate, DateTime tDate, string BranchCode, string ItemCode, string FinYear) { //string sql = string.Format("EXEC rpt_SP_CollectionStat_1'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "', '" + BranchCode + "', '" + FinYear + "',''"); //IEnumerable<MovementItemVM> VchrLst; //using (AcclineERPContext dbContext = new AcclineERPContext()) //{ // VchrLst = dbContext.Database.SqlQuery<MovementItemVM>(sql).ToList(); //} ViewBag.BranchCode = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault(); ViewBag.ItemCode = _ItemInfoService.All().Where(s => s.ItemCode == ItemCode).Select(x => x.ItemCode).FirstOrDefault(); ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; //Response.AppendHeader("Content-Disposition", "inline; filename=" + RptName + "_" + DateTime.Now.ToShortDateString() + ".pdf"); return(new Rotativa.ViewAsPdf("StoreRptPdf", "", "") { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult TransWiseVatRptPdf(DateTime fDate, DateTime tDate, string TransNo, string command) { string FinYear = Session["FinYear"].ToString(); string sql = string.Format("EXEC VM_rpt6P1 '" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + TransNo + "', '" + FinYear + "','" + Session["ProjCode"].ToString() + "','" + Session["BranchCode"].ToString() + "'"); IEnumerable <VatStatementVM> VchrLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <VatStatementVM>(sql).ToList(); } ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; if (command == "Preview") { return(View("rptVatPdf", VchrLst)); } else { return(View("~/Views/VATRpt/rptVatPdf - Copy.cshtml", VchrLst)); } }
public ActionResult SalesCollectionStatementRptPdf(DateTime fDate, DateTime tDate, string ProjCode, string BranchCode, string FinYear) { ViewBag.BranchName = "All"; if (BranchCode != "") { String BranchName = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault(); ViewBag.BranchName = BranchName; } var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(fDate), Convert.ToString(tDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("SalesCollectionStatRpt_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg })); } string customerGroup = ""; //rpt_SP_SalesCollectionStat_1 @fdate smalldatetime, @tdate smalldatetime, @ProjCode varchar(3), @BranchCode varchar(3),@FinYear varchar(7), @customerGroup varchar(7) string sql = string.Format("EXEC rpt_SP_SalesCollectionStat_1 '" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + ProjCode + "', '" + BranchCode + "', '" + FinYear + "','" + customerGroup + "' "); //,'" + Session["UserName"] + "' //string sql = string.Format("EXEC rpt_SP_SalesCollectionStat_1 '" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + ProjCode + "', '" + BranchCode + "', '" + FinYear + "','"+ customerGroup +"'"); IEnumerable <SalesCollectionStat> VchrLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <SalesCollectionStat>(sql).ToList(); } ViewBag.BranchCode = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault(); //ViewBag.fDate = fDate.ToString("dd-MMM-yyyy"); //ViewBag.tDate = tDate.ToString("dd-MMM-yyyy"); ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; //Response.AppendHeader("Content-Disposition", "inline; filename=" + RptName + "_" + DateTime.Now.ToShortDateString() + ".pdf"); return(new Rotativa.ViewAsPdf("rptSalesCollectionStatePdf", "", VchrLst) { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult StockLedgerPdf(RptSearchVModel vmodel, string finyear) { vmodel.BranchCode = Session["Branch"].ToString(); vmodel.AccountCode = Session["AccountCode"].ToString(); var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == "rptStoreLedger"); ViewBag.LedgerCap = ledger.LedgerCap; ViewBag.RptCap = ledger.RptCap; ViewBag.OpeningCap = ledger.OpeningCap; ViewBag.ClosingCap = ledger.ClosingCap; ViewBag.Col1Cap = ledger.Col1Cap; ViewBag.Col2Cap = ledger.Col2Cap; ViewBag.Col3Cap = ledger.Col3Cap; ViewBag.Col4Cap = ledger.Col4Cap; ViewBag.Col5Cap = ledger.Col5Cap; ViewBag.Col6Cap = ledger.Col6Cap; ViewBag.Col7Cap = ledger.Col7Cap; ViewBag.Col8Cap = ledger.Col8Cap; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate); ViewBag.AccountCode = vmodel.AccountCode; ViewBag.BranchCode = vmodel.BranchCode; if (vmodel.BranchCode != "") { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } if (vmodel.AccountCode != "") { ViewBag.Account = _ItemService.All().FirstOrDefault(x => x.ItemCode == vmodel.AccountCode.Trim()).ItemName.ToString(); } else { ViewBag.Account = "All"; } ViewBag.PrintDate = DateTime.Now.ToShortDateString(); finyear = Session["FinYear"].ToString(); string sql = string.Format(" EXEC " + ledger.SP_Name + " '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.AccountCode + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.toDate.ToString("MM/dd/yyyy") + "'"); List <ReportLedger> rptLedger = _ReportLedgerService.SqlQueary(sql).ToList(); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(new Rotativa.ViewAsPdf("StockLedgerPdf", rptLedger) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult GetCashBook(RptSearchVModel vmodel) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("Search", "CashBook", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("RptCashBook_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("Search", "CashBook", new { errMsg })); } Session["fDate"] = vmodel.fDate; Session["tDate"] = vmodel.toDate; string finyear = Session["FinYear"].ToString(); vmodel.BranchCode = (vmodel.BranchCode == "0") ? "" : vmodel.BranchCode; Session["Branch"] = vmodel.BranchCode; ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch; if (vmodel.BranchCode != "" && vmodel.BranchCode != "0") { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } string sql = string.Format("EXEC rptCashBook '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.fDate.ToString("yyyy/MM/dd") + "','" + vmodel.toDate.ToString("yyyy/MM/dd") + "'"); List <CashBook> cashBook = _CashBookService.SqlQueary(sql).ToList(); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; if (cashBook.Count == 0) { string errMsg = "There is no data on this date. Please try another !!!"; return(RedirectToAction("Search", "CashBook", new { errMsg })); } else { ViewBag.Datef = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.Datet = InWord.GetAbbrMonthNameDate(vmodel.toDate); return(View(cashBook)); } }
public ActionResult GetCustomerLedger(RptSearchVModel vmodel, string finyear) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.tDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("CustomerLedgerGDS_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg })); } //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; finyear = Session["FinYear"].ToString(); ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.tDate); ViewBag.CustCode = vmodel.SubCode; ViewBag.Customer = _ISubsidiaryInfoAppService.All().FirstOrDefault(x => x.SubCode == vmodel.SubCode.Trim()).SubName.ToString(); ViewBag.SubCode = vmodel.SubCode; string sql = string.Format("exec rpt_CustLedger_GDS '" + vmodel.fDate.ToString("yyyy/MM/dd") + "','" + vmodel.tDate.ToString("yyyy/MM/dd") + "','" + vmodel.SubCode + "','" + Session["FinYear"].ToString() + "','" + Session["UserName"] + "' "); IEnumerable <CustomerLedgerVM> VchrLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <CustomerLedgerVM>(sql).ToList(); } return(new Rotativa.ViewAsPdf("CustomerLedgerPdf", "", VchrLst) { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult GetVoucherPreview(string VchrNo, string FinYear) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("RptVoucherPreview_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg })); } if (VchrNo != null) { var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == "rptVoucher"); ViewBag.RptCap = ledger.RptCap; ViewBag.Col1Cap = ledger.Col1Cap; ViewBag.Col2Cap = ledger.Col2Cap; ViewBag.Col3Cap = ledger.Col3Cap; ViewBag.Col4Cap = ledger.Col4Cap; ViewBag.Col5Cap = ledger.Col5Cap; ViewBag.Col6Cap = ledger.Col6Cap; ViewBag.Col7Cap = ledger.Col7Cap; string BranchCode = Session["BranchCode"].ToString(); ViewBag.Branch = _BranchService.All().Where(x => x.BranchCode == BranchCode.Trim()).Select(s => s.BranchName).ToString(); FinYear = Session["FinYear"].ToString(); string sql = string.Format("EXEC rptVoucher '" + FinYear + "','" + VchrNo + "'"); List <VchrPreviewVM> rptVchr = _VchrPreviewVMService.SqlQueary(sql).ToList(); //if (rptVchr.Count == 0) //{ // string errMsg = "There is no data in this combination. Please try again !!!"; // return RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg }); //} //else //{ double amt = 0; foreach (var item in rptVchr) { if (item.cramount != 0) { amt += item.cramount; } } string InWordsamt = InWord.ConvertToWords(amt.ToString()); ViewBag.InWordsAmt = InWordsamt; return(View(rptVchr)); //} } else { string errMsg = "Voucher no is required!"; return(RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg })); } }
public ActionResult TransWiseVat6P10RptPdf(DateTime fDate, DateTime tDate, string TransNo, string command) { List <Vat6P10> VchrLst_Ka = new List <Vat6P10>(); List <Vat6P10> VchrLst_Kha = new List <Vat6P10>(); string sql = string.Format("EXEC VM_rpt6P10 '" + TransNo + "','','','','" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','Ka' "); using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst_Ka = dbContext.Database.SqlQuery <Vat6P10>(sql).ToList(); } sql = string.Format("EXEC VM_rpt6P10 '" + TransNo + "','','','','" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','Kha' "); using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst_Kha = dbContext.Database.SqlQuery <Vat6P10>(sql).ToList(); } Ka_KhaModel finalItem = new Ka_KhaModel(); finalItem.VchrLst_Ka1 = VchrLst_Ka; finalItem.VchrLst_Kha1 = VchrLst_Kha; ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; if (command == "Preview") { return(View(finalItem)); } else { return(View("TransWiseVat6P10RptPdf - Copy", finalItem)); } //return new Rotativa.ViewAsPdf("TransWiseVat6P10RptPdf", "", finalItem) //{ // //PageMargins= new Rotativa.Options.Margins(2,2,0,1), // PageSize = Rotativa.Options.Size.A4, // (14f, 8.5f), // // PageOrientation = Rotativa.AspNetCore.Options.Orientation.Landscape, // PageOrientation = Rotativa.Options.Orientation.Portrait, // CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" //}; }
public ActionResult GetMoneyReceiptPdf(string ReceiptNo) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("MoneyReceiptCash_Print")) { string errMsg = "P"; return(RedirectToAction("CashMoneyReceipt", "CashMoneyReceipt", new { errMsg })); } MoneyReceiptVM MRVM = new MoneyReceiptVM(); var cashRPfd = _moneyReceiptService.All().FirstOrDefault(x => x.MRNo == ReceiptNo && x.PayMode == "Ca"); if (cashRPfd != null) { MRVM.MRNo = cashRPfd.MRNo; MRVM.CustCode = cashRPfd.CustCode.Trim(); MRVM.CustName = (from s in _subsidiaryInfoService.All().ToList() where s.SubCode == cashRPfd.CustCode.Trim() select s.SubName).FirstOrDefault(); MRVM.Address = (from se in _SubsidiaryExtService.All().ToList() where se.SubCode.Trim() == cashRPfd.CustCode.Trim() select se.SubAddress).FirstOrDefault(); MRVM.InWord = InWord.ConvertToWords(Convert.ToString(cashRPfd.MRAmount)); MRVM.AcType = _newChartService.All().FirstOrDefault(s => s.Accode == cashRPfd.Accode).AcName; MRVM.MRDate = cashRPfd.MRDate; #region //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; #endregion MRVM.Amount = Convert.ToDecimal(cashRPfd.MRAmount); MRVM.PayMode = "Ca"; return(new Rotativa.ViewAsPdf("~/Views/CashReceipt/MoneyReceiptPdf.cshtml", MRVM) { PageSize = Rotativa.Options.Size.A4 }); } else { //string errMsg = "E"; //return RedirectToAction("CashOperation", "CashOperation", new { errMsg }); MRVM.PayMode = "Ca"; return(new Rotativa.ViewAsPdf("~/Views/CashReceipt/MoneyReceiptPdf.cshtml", MRVM) { PageSize = Rotativa.Options.Size.A4 }); } }
public ActionResult GetVoucherPreview(string VchrNo, string FinYear) { var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == "rptVoucher"); ViewBag.RptCap = ledger.RptCap; ViewBag.Col1Cap = ledger.Col1Cap; ViewBag.Col2Cap = ledger.Col2Cap; ViewBag.Col3Cap = ledger.Col3Cap; ViewBag.Col4Cap = ledger.Col4Cap; ViewBag.Col5Cap = ledger.Col5Cap; ViewBag.Col6Cap = ledger.Col6Cap; ViewBag.Col7Cap = ledger.Col7Cap; string BranchCode = Session["BranchCode"].ToString(); ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == BranchCode.Trim()).BranchName.ToString(); FinYear = Session["FinYear"].ToString(); string sql = string.Format("EXEC rptVoucher '" + FinYear + "','" + VchrNo + "'"); List <VchrPreviewVM> rptVchr = _VchrPreviewVMService.SqlQueary(sql).ToList(); //if (rptVchr.Count == 0) //{ // string errMsg = "There is no data in this combination. Please try again !!!"; // return RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg }); //} //else //{ double amt = 0; foreach (var item in rptVchr) { if (item.cramount != 0) { amt += item.cramount; } } string InWordsamt = InWord.ConvertToWords(amt.ToString()); ViewBag.InWordsAmt = InWordsamt; return(View("~/Views/VchrPreview/GetVoucherPreview.cshtml", rptVchr)); //} }
public ActionResult TransWiseVat6P2P1RptPdf(DateTime fDate, DateTime tDate, string TransNo, string FinYear, string command) { string sql = string.Format("EXEC VM_rpt6P2P1 '" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + TransNo + "', '" + FinYear + "'"); IEnumerable <VatStatementVM> VchrLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <VatStatementVM>(sql).ToList(); } ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; if (command == "Preview") { return(View("rptVat6P2P1Pdf", VchrLst)); } else { return(View("rptVat6P2P1Pdf", VchrLst)); } //return new Rotativa.ViewAsPdf("rptVat6P2P1Pdf", "", VchrLst) //{ // //PageMargins= new Rotativa.Options.Margins(2,2,0,1), // PageSize = Rotativa.Options.Size.A4, // (14f, 8.5f), // // PageOrientation = Rotativa.AspNetCore.Options.Orientation.Landscape, // PageOrientation = Rotativa.Options.Orientation.Landscape, // CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" //}; }
public ActionResult GetMoneyReceiptPdf(string ReceiptNo) { MoneyReceiptVM MRVM = new MoneyReceiptVM(); var crPfd = _chequeReceiptService.All().FirstOrDefault(x => x.ChqReceiptNo == ReceiptNo); if (crPfd != null) { var todayDate = DateTime.Now; var TingCount = _chequeReceiptService.All().FirstOrDefault(x => x.ChqReceiptNo == ReceiptNo); TingCount.MRTing = TingCount.MRTing + 1; TingCount.MRTingTime = todayDate.AddHours(todayDate.Hour).AddMinutes(todayDate.Minute).AddSeconds(todayDate.Second).AddMilliseconds(todayDate.Millisecond); MRVM.MRNo = crPfd.ChqReceiptNo; MRVM.CustCode = crPfd.SubCode.Trim(); MRVM.ChequeDate = (DateTime)crPfd.ChqDate; MRVM.CustName = (from s in _subsidiaryService.All().ToList() where s.SubCode == crPfd.SubCode.Trim() select s.SubName).FirstOrDefault(); MRVM.Address = (from se in _SubsidiaryExtService.All().ToList() where se.SubCode.Trim() == crPfd.SubCode.Trim() select se.SubAddress).FirstOrDefault(); MRVM.InWord = InWord.ConvertToWords(crPfd.Amount.ToString()); MRVM.AcType = LoadDropDown.GetMrAgainst(crPfd.MRAgainst); MRVM.MRDate = crPfd.ChqReceiptDate; MRVM.Amount = crPfd.Amount; MRVM.PayMode = "ChequeReceipt"; MRVM.ChequeNo = crPfd.ChqNo; MRVM.BankName = _bankInfoService.All().FirstOrDefault(s => s.BankCode == crPfd.BankCode).BankName;; MRVM.Branch = crPfd.BranchName; _chequeReceiptService.Update(TingCount); _chequeReceiptService.Save(); return(new Rotativa.ViewAsPdf("~/Views/CashReceipt/MoneyReceiptPdf.cshtml", MRVM) { PageSize = Rotativa.Options.Size.A4 }); } else { string errMsg = "NF"; return(RedirectToAction("ChequeReceipts", "ChequeReceipts", new { errMsg })); } }
public ActionResult IncomeExpenditurePdf(string ProjName, string fDate, string tDate) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("RptBalanceSheet_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("IncExpAcRpt", "IncExpAcRpt", new { errMsg })); } ViewBag.fDate = InWord.GetAbbrMonthNameDate(Convert.ToDateTime(fDate)); ViewBag.tDate = InWord.GetAbbrMonthNameDate(Convert.ToDateTime(tDate)); string sql = string.Format("Exec rptIncExpAC1 '" + ProjName + "','" + Session["BranchCode"].ToString() + "','" + Convert.ToDateTime(fDate).ToString("MM/dd/yyyy") + "','" + Convert.ToDateTime(tDate).ToString("MM/dd/yyyy") + "','" + Session["FinYear"].ToString() + "'"); List <BalSheetRptVM> balSheet = _BalSheetRptService.SqlQueary(sql).ToList(); Response.AppendHeader("Content-Disposition", "inline; filename= IncomeExpenditure_" + DateTime.Now.ToShortDateString() + ".pdf"); return(new Rotativa.ViewAsPdf("IncomeExpenditurePdf", "", balSheet) { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, //FileName = RptName + "-" + DateTime.Now.ToShortDateString() + ".pdf" , contStatementReportPdf CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult SummaryReportPdf(RptSearchVModel vmodel, string finyear) { vmodel.BranchCode = Session["Branch"].ToString(); vmodel.LedgerTypeCode = Session["LedgerType"].ToString(); if (Session["LevelNo"] == null) { vmodel.LevelNo = "0"; } else { vmodel.LevelNo = Session["LevelNo"].ToString(); } // vmodel.LevelNo =Session["LevelNo"].ToString(); var rptCap = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == vmodel.LedgerTypeCode); ViewBag.LedgerCap = rptCap.LedgerCap; ViewBag.RptCap = rptCap.RptCap; ViewBag.Col1Cap = rptCap.Col1Cap; ViewBag.Col2Cap = rptCap.Col2Cap; ViewBag.Col3Cap = rptCap.Col3Cap; ViewBag.Col4Cap = rptCap.Col4Cap; ViewBag.Col5Cap = rptCap.Col5Cap; ViewBag.Col6Cap = rptCap.Col6Cap; ViewBag.Col7Cap = rptCap.Col7Cap; ViewBag.Col8Cap = rptCap.Col8Cap; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.tDate); ViewBag.BranchCode = vmodel.BranchCode; if (vmodel.BranchCode != "" && vmodel.BranchCode != "0") { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch; ViewBag.PrintDate = DateTime.Now.ToShortDateString(); finyear = Session["FinYear"].ToString(); if (Session["LevelNo"] == null) { vmodel.LevelNo = "0"; } else { vmodel.LevelNo = Session["LevelNo"].ToString(); } string sql = string.Format(" EXEC " + rptCap.SP_Name + " '" + finyear + "','','" + vmodel.BranchCode + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.tDate.ToString("MM/dd/yyyy") + "','" + Session["Discardcntl"] + "','" + vmodel.LevelNo + "'"); List <SummaryReport> summaryReport = _SumRptService.SqlQueary(sql).ToList(); Session["Discardcntl"] = ""; Session["LevelNo"] = ""; //if (summaryReport.Count == 0) //{ // string errMsg = "There is no data in this combination. Please try again !!!"; // return RedirectToAction("GetSummaryReport2", "SummaryReport", new { errMsg }); //} //else //{ //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; if (rptCap.RptCap == "Stock Summary") { return(new Rotativa.ViewAsPdf("SummaryStockReportPdf", summaryReport) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); } return(new Rotativa.ViewAsPdf("SummaryReportPdf", summaryReport) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); //} }
//public SelectList GardenSelection() //{ // var UserName = User.Identity.Name; // var brans = _employeeService.All().Where(x => x.Email == UserName).ToList().FirstOrDefault(); // var UserId = brans.Id; // var items = _userbranchService.All().ToList().Where(x => x.Userid == UserId.ToString()).ToList(); // List<Branch> branchList = new List<Branch>(); // foreach (var item in items) // { // var branch = _BranchService.All().ToList().FirstOrDefault(x => x.BranchCode == item.BranchCode); // branchList.Add(branch); // } // branchList.Insert(0, new Branch() { BranchCode = "0", BranchName = "---- Select ----" }); // //List<Branch> BranchCode = new SelectList(branchList, "BranchCode", "BranchName"); // return new SelectList(branchList.OrderBy(x => x.BranchCode), "BranchCode", "BranchName"); //} public ActionResult GetSummaryReport(RptSearchVModel vmodel, string finyear) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("Search", "SummaryReport", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("RptTrialBalance_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("Search", "SummaryReport", new { errMsg })); } Session["Branch"] = (vmodel.BranchCode == null) ? "" : vmodel.BranchCode; Session["LedgerType"] = vmodel.LedgerTypeCode; Session["fDate"] = vmodel.fDate; Session["tDate"] = vmodel.toDate; if (vmodel.LevelNo == null) { vmodel.LevelNo = "0"; } Session["LevelNo"] = vmodel.LevelNo; // Session["LevelNo"] = vmodel.LevelNo; var rptCap = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == vmodel.LedgerTypeCode); ViewBag.LedgerCap = rptCap.LedgerCap; ViewBag.RptCap = rptCap.RptCap; ViewBag.Col1Cap = rptCap.Col1Cap; ViewBag.Col2Cap = rptCap.Col2Cap; ViewBag.Col3Cap = rptCap.Col3Cap; ViewBag.Col4Cap = rptCap.Col4Cap; ViewBag.Col5Cap = rptCap.Col5Cap; ViewBag.Col6Cap = rptCap.Col6Cap; ViewBag.Col7Cap = rptCap.Col7Cap; ViewBag.Col8Cap = rptCap.Col8Cap; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate); ViewBag.foDate = vmodel.fDate.ToString("MM/dd/yyyy"); ViewBag.toDate = vmodel.toDate.ToString("MM/dd/yyyy"); ViewBag.LocCode = vmodel.LocCode;//----location---// ViewBag.BranchCode = vmodel.BranchCode; if (vmodel.BranchCode != null && vmodel.BranchCode != "0") { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } //---------------Location---------------------------// if (vmodel.LocCode != null && vmodel.LocCode != "0") { ViewBag.Location = _locationService.All().FirstOrDefault(x => x.LocCode == vmodel.LocCode.Trim()).LocName.ToString(); } else { ViewBag.Location = "All"; } finyear = Session["FinYear"].ToString(); if (vmodel.LevelNo == null) { vmodel.LevelNo = "0"; } string sql = string.Format(" EXEC " + rptCap.SP_Name + " '" + finyear + "','01','" + vmodel.LocCode + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.toDate.ToString("MM/dd/yyyy") + "','" + vmodel.DisControl + "','" + vmodel.LevelNo + "'"); List <SummaryReport> summaryReport = _SumRptService.SqlQueary(sql).ToList(); Session["Discardcntl"] = vmodel.DisControl; //if (summaryReport.Count == 0) //{ // string errMsg = "There is no data in this combination. Please try again !!!"; // return RedirectToAction("Search", "SummaryReport", new { errMsg }); //} //else //{ if (rptCap.RptCap == "Stock Summary") { return(View("~/Views/SummaryReport/GetSummaryStockReport.cshtml", summaryReport)); } //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(View(summaryReport)); //} }
public ActionResult GetGLEntries(RptSearchVModel vmodel) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("Search", "ListOfTransaction", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("RptJournalVoucher_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("Search", "ListOfTransaction", new { errMsg })); } string finyear = Session["FinYear"].ToString(); Session["Branch"] = vmodel.BranchCode; Session["LedgerType"] = vmodel.LedgerTypeCode; Session["fDate"] = vmodel.fDate; Session["tDate"] = vmodel.toDate; Session["Data"] = vmodel.JTrGrpId; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate); if (vmodel.JTrGrpId == null) { vmodel.JTrGrpId = ""; } // Session["NullData"] = vmodel.JTrGrpId = ""; string sql = string.Format("EXEC rptListTran '" + finyear + "','01','" + vmodel.BranchCode + "','" + vmodel.JTrGrpId.Trim() + "','" + vmodel.fDate.ToString("MM-dd-yyyy") + "','" + vmodel.toDate.ToString("MM-dd-yyyy") + "'"); List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList(); // Session["Data"] = glReport; //if (glReport.Count == 0) //{ // string errMsg = "Data not found !!!"; // return RedirectToAction("Search", "ListOfTransaction", new { errMsg }); //} //else //{ double amt = 0; List <JarnalVoucher> sList = new List <JarnalVoucher>(); //InWord.ConvertToWords(amt.ToString()).ToList(); foreach (var item in glReport) { //if (item.CrAmount != 0) // { if (item.DrAmount > 0) { amt = item.DrAmount; } else if (item.CrAmount > 0) { amt = item.CrAmount; } JarnalVoucher sAmt = new JarnalVoucher(); sAmt.ACCode = item.ACCode; sAmt.VDate = item.VDate; sAmt.AcName = item.AcName; sAmt.InWords = InWord.ConvertToWords(amt.ToString()); sAmt.AcName = item.AcName; sAmt.Narration = item.Narration; sAmt.SubSidiary = item.SubSidiary; sAmt.CrAmount = item.CrAmount; sAmt.DrAmount = item.DrAmount; sAmt.VchrNo = item.VchrNo; sAmt.Posted = item.Posted; sAmt.Sub_Ac = item.Sub_Ac; sList.Add(sAmt); // } } return(View("~/Views/ListOfTransaction/TransactionList.cshtml", sList)); //} }
public ActionResult rptSalesCollectionComparisonPdf(RptSearchVModel vmodel, string finyear) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.tDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("SalesCollectionComparison_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg })); } finyear = Session["FinYear"].ToString(); ViewBag.SubCode = vmodel.SubCode; ViewBag.ProjCode = vmodel.projCode; ViewBag.BranchCode = vmodel.BranchCode; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.tDate); String BranchCode = vmodel.BranchCode; ViewBag.BranchName = "All"; if (BranchCode != "") { ViewBag.BranchName = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault(); } //For us Culture Ex: 0.00 const string culture = "en-US"; System.Globalization.CultureInfo ci = System.Globalization.CultureInfo.GetCultureInfo(culture); System.Threading.Thread.CurrentThread.CurrentCulture = ci; System.Threading.Thread.CurrentThread.CurrentUICulture = ci; string sql_1 = string.Format("exec rpt_salescolcomparison_det '" + vmodel.fDate.ToString("yyyy-MM-dd") + "','" + vmodel.tDate.ToString("yyyy-MM-dd") + "','" + vmodel.projCode + "','" + vmodel.BranchCode + "' ,'" + Session["UserName"] + "' "); string sql_2 = string.Format("exec rpt_salescolcomparison_foot '" + vmodel.fDate.ToString("yyyy-MM-dd") + "','" + vmodel.tDate.ToString("yyyy-MM-dd") + "','" + vmodel.projCode + "','" + vmodel.BranchCode + "','" + Session["UserName"] + "' "); // string sql_1 = string.Format("exec rpt_salescolcomparison_det '" + vmodel.fDate.ToString("yyyy-MM-dd") + "','" + vmodel.tDate.ToString("yyyy-MM-dd") + "','" + vmodel.projCode + "','" + vmodel.BranchCode + "' "); //string sql_2 = string.Format("exec rpt_salescolcomparison_foot '" + vmodel.fDate.ToString("yyyy-MM-dd") + "','" + vmodel.tDate.ToString("yyyy-MM-dd") + "','" + vmodel.projCode + "','" + vmodel.BranchCode + "' "); IEnumerable <SalesCollectionComparisionVM> VchrLst; SalesCollectionComparisionVM yearlyData = new SalesCollectionComparisionVM(); //IEnumerable<SalesCollectionComparisionVM > yearlyData; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <SalesCollectionComparisionVM>(sql_1).ToList(); //yearlyData = dbContext.Database.SqlQuery<SalesCollectionComparisionVM>(sql_2).FirstOrDefault(); yearlyData = dbContext.Database.SqlQuery <SalesCollectionComparisionVM>(sql_2).FirstOrDefault(); } ViewBag.yearlyDataV = yearlyData; return(new Rotativa.ViewAsPdf("rptSalesCollectionComparisonPdf", "", VchrLst) { PageOrientation = Rotativa.Options.Orientation.Portrait, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public JsonResult UpdateData(string finYear, DateTime fDate, DateTime tDate, string command) { List <Vat6P9P1_1> Part1 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part2 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part3 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part4 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part5 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part6 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part7 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part8 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part9 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part10 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part11 = new List <Vat6P9P1_1>(); string today = DateTime.Today.ToString("yyyy/MM/dd"); int month = fDate.Day; int year = fDate.Year; //@ProjCode, @BranchCode, @FinYear,@Year, @Month, @fdate,@tdate //VM_rpt9P1_P1 '','','2019-20',2019,7,'2019-7-1','2019-7-31' string sql = string.Format("EXEC VM_rpt9P1_P1 '','',''," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part1 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P2 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + today + "','64',1"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part2 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P3 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part3 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P4 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part4 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P5 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part5 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P6 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part6 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P7 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part7 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P8 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part8 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P9 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part9 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P10 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part10 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P11 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part11 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } Part1Part2Model finalItem = new Part1Part2Model(); finalItem.P1_1PArt1 = Part1; finalItem.P1_1PArt2 = Part2; finalItem.P1_1PArt3 = Part3; finalItem.P1_1PArt4 = Part4; finalItem.P1_1PArt5 = Part5; finalItem.P1_1PArt6 = Part6; finalItem.P1_1PArt7 = Part7; finalItem.P1_1PArt8 = Part8; finalItem.P1_1PArt9 = Part9; finalItem.P1_1PArt10 = Part10; finalItem.P1_1PArt11 = Part11; ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); return(Json(new { redirectUrl = Url.Action("TransWiseVat6P9P1_1RptPdf", "VATRpt"), finalItem, isRedirect = true })); }
public ActionResult PendingRptPdf(DateTime fDate, DateTime tDate) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(fDate), Convert.ToString(tDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("PendingSearch_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg })); } ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); List <PendingNotEncashRptVM> finalList = new List <PendingNotEncashRptVM>(); List <MoneyReceipt> MRList = new List <MoneyReceipt>(); List <ChequeReceipt> CRList = new List <ChequeReceipt>(); //ChequeReceipt itemob2 = new ChequeReceipt(); //MoneyReceipt MoneyReceipt = new MoneyReceipt(); //List<String> MRIdList = new List<String>(); MRList = _IMoneyReceiptAppService.All().Where(x => x.EncashDate == null).ToList(); CRList = _IChequeReceiptAppService.All().Where(x => x.ChqStatus == null).ToList(); foreach (var item in MRList) { PendingNotEncashRptVM itemob = new PendingNotEncashRptVM(); itemob.MRSL = item.MRSL; itemob.MRNo = item.MRNo; itemob.MRDate = item.MRDate; itemob.CustCode = item.CustCode; //itemob.ChkAmount = ""; itemob.MRAmount = item.MRAmount; itemob.Remarks = item.Remarks; finalList.Add(itemob); } foreach (var item in CRList) { PendingNotEncashRptVM itemob = new PendingNotEncashRptVM(); itemob.MRSL = item.MRSL; itemob.MRNo = item.ChqReceiptNo; itemob.MRDate = item.ChqReceiptDate; itemob.CustCode = item.SubCode; itemob.ChkAmount = item.Amount; // itemob.MRAmount = item.MRAmount; itemob.Remarks = item.Remarks; finalList.Add(itemob); } //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(new Rotativa.ViewAsPdf("~/Views/Pending/PendingRptPdf.cshtml", finalList) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); //return View(finalList); }
public ActionResult GetVoucherPreviewPdf(string FinYear, string vchrNo, string pType) { var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == "rptVoucher"); ViewBag.RptCap = ledger.RptCap; ViewBag.Col1Cap = ledger.Col1Cap; ViewBag.Col2Cap = ledger.Col2Cap; ViewBag.Col3Cap = ledger.Col3Cap; ViewBag.Col4Cap = ledger.Col4Cap; ViewBag.Col5Cap = ledger.Col5Cap; ViewBag.Col6Cap = ledger.Col6Cap; ViewBag.Col7Cap = ledger.Col7Cap; ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch; if (ViewBag.HasBranch == true) { var BranchCode = Session["BranchCode"].ToString(); if (BranchCode != null) { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == BranchCode).BranchName.ToString(); } else { ViewBag.Branch = "All"; } } string sql = string.Format("EXEC rptVoucher '" + FinYear + "','" + vchrNo + "'"); List <VchrPreviewVM> rptVchr = _VchrPreviewVMService.SqlQueary(sql).ToList(); //if (rptVchr.Count == 0) //{ // string errMsg = "There is no data in this combination. Please try again !!!"; // return RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg }); //} //else //{ double amt = 0; foreach (var item in rptVchr) { if (item.cramount != 0) { amt += item.cramount; } } string InWordsamt = InWord.ConvertToWords(amt.ToString()); ViewBag.InWordsAmt = InWordsamt; if (pType == "A4") { return(new Rotativa.ViewAsPdf("~/Views/VchrPreview/VchrPreviewPdf.cshtml", rptVchr) { PageSize = Rotativa.Options.Size.A4 }); } else if (pType == "A3") { return(new Rotativa.ViewAsPdf("~/Views/VchrPreview/VchrPreviewPdf.cshtml", rptVchr) { PageSize = Rotativa.Options.Size.A3 }); } else { return(new Rotativa.ViewAsPdf("~/Views/VchrPreview/VchrPreviewPdf.cshtml", rptVchr) { PageSize = Rotativa.Options.Size.A5 }); } //} }
public ActionResult TransWiseVat6P9P1_1RptPdf(string finYear, DateTime fDate, DateTime tDate, string command) { List <Vat6P9P1_1> Part1 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part2 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part3 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part4 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part5 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part6 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part7 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part8 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part9 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part10 = new List <Vat6P9P1_1>(); List <Vat6P9P1_1> Part11 = new List <Vat6P9P1_1>(); string today = DateTime.Today.ToString("yyyy/MM/dd"); int month = fDate.Day; int year = fDate.Year; //@ProjCode, @BranchCode, @FinYear,@Year, @Month, @fdate,@tdate //VM_rpt9P1_P1 '','','2019-20',2019,7,'2019-7-1','2019-7-31' string sql = string.Format("EXEC VM_rpt9P1_P1 '','',''," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part1 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P2 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + today + "','64',1"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part2 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P3 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part3 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P4 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part4 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P5 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part5 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P6 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part6 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P7 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part7 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P8 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part8 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P9 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part9 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P10 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part10 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } sql = string.Format("EXEC VM_rpt9P1_P11 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'"); using (AcclineERPContext dbContext = new AcclineERPContext()) { Part11 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList(); } Part1Part2Model finalItem = new Part1Part2Model(); finalItem.P1_1PArt1 = Part1; finalItem.P1_1PArt2 = Part2; finalItem.P1_1PArt3 = Part3; finalItem.P1_1PArt4 = Part4; finalItem.P1_1PArt5 = Part5; finalItem.P1_1PArt6 = Part6; finalItem.P1_1PArt7 = Part7; finalItem.P1_1PArt8 = Part8; finalItem.P1_1PArt9 = Part9; finalItem.P1_1PArt10 = Part10; finalItem.P1_1PArt11 = Part11; ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //bool process = false; //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; if (command == "Preview") { return(View(finalItem)); } //return Json(process, JsonRequestBehavior.AllowGet); else { sql = string.Format("exec Count_MRPrint " + year + "," + month + ""); } IEnumerable <MonthlyReturn> MontlyReturnLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { MontlyReturnLst = dbContext.Database.SqlQuery <MonthlyReturn>(sql).ToList(); } return(View("TransWiseVat6P9P1_1RptPdf - Copy", finalItem)); //return new Rotativa.ViewAsPdf("TransWiseVat6P9P1_1RptPdf", "", finalItem) //{ // //PageMargins= new Rotativa.Options.Margins(2,2,0,1), // PageSize = Rotativa.Options.Size.A4, // (14f, 8.5f), // // PageOrientation = Rotativa.AspNetCore.Options.Orientation.Landscape, // PageOrientation = Rotativa.Options.Orientation.Portrait, // CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" //}; }
public ActionResult MontlyQuantityRptPdf2(string Location, string CustomerName, DateTime fDate, DateTime tDate, string ProjCode, string BranchCode, string FinYear, string QtyAmt) { //#### AMOUNT string ItemGroup = ""; string sp = ""; string customerGroup = ""; //string Location = ""; if (QtyAmt != "Amount") { sp = "rpt_SP_ProdSales_Qty"; } else { sp = "rpt_SP_ProdSales_Amt"; } customerGroup = CustomerName; //rpt_SP_ProdSales_Qty @fdate smalldatetime, @tdate smalldatetime, @ProjCode varchar(3), @BranchCode varchar(3),@FinYear varchar(7), @customerGroup varchar(7),@ItemGroup varchar(6) string sql = string.Format("EXEC " + sp + "'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + ProjCode + "', '" + BranchCode + "','" + FinYear + "','" + customerGroup + "','" + ItemGroup + "','" + Session["UserName"] + "' "); IEnumerable <MontlyQuantity> VchrLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { VchrLst = dbContext.Database.SqlQuery <MontlyQuantity>(sql).ToList(); } ViewBag.BranchCode = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault(); //ViewBag.fDate = fDate.ToString("dd-MMM-yyyy"); //ViewBag.tDate = tDate.ToString("dd-MMM-yyyy"); ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); //Response.AppendHeader("Content-Disposition", "inline; filename=" + RptName + "_" + DateTime.Now.ToShortDateString() + ".pdf"); //#### AMOUNT ####### ViewBag.CustomerName = "All"; ViewBag.Location = "All"; if (CustomerName != "") { CustomerName = _ISubsidiaryInfoService.All().Where(s => s.SubCode == CustomerName).Select(x => x.SubName).FirstOrDefault(); ViewBag.CustomerName = CustomerName; } if (Location != "") { Location = _ILocationAppService.All().ToList().Where(s => s.LocCode == Location).Select(x => x.LocName).FirstOrDefault(); ViewBag.Location = Location; } //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; if (QtyAmt != "Amount") { return(new Rotativa.ViewAsPdf("~/Views/MontlyQuantity/QuantityPdf.cshtml", VchrLst) { PageOrientation = Rotativa.Options.Orientation.Landscape, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); } else { return(new Rotativa.ViewAsPdf("~/Views/MontlyQuantity/AmountPdf.cshtml", VchrLst) { PageOrientation = Rotativa.Options.Orientation.Landscape, PageSize = Rotativa.Options.Size.A4, CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); } }
//public ActionResult ListOfTransectionPreview(RptSearchVModel vmodel, string pType) //{ // string finyear = Session["FinYear"].ToString(); // Session["Branch"] = vmodel.BranchCode; // Session["LedgerType"] = vmodel.LedgerTypeCode; // Session["fDate"] = vmodel.fDate; // Session["tDate"] = vmodel.tDate; // var BranchCode = Session["BranchCode"].ToString(); // if (BranchCode != null) // { // ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == BranchCode).BranchName.ToString(); // } // else // { // ViewBag.Branch = "All"; // } // string sql = string.Format("EXEC rptListTran '" + finyear + "','01','" + vmodel.BranchCode + "','" + vmodel.JTrGrpId + "','" + Convert.ToDateTime(vmodel.fDate) + "','" + Convert.ToDateTime(vmodel.tDate) + "'"); // List<JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList(); // if (glReport.Count == 0) // { // string errMsg = "Data not found !!!"; // //ViewBag.msg = errMsg; // return RedirectToAction("CashOperation", "CashOperation", new { errMsg }); // } // else // { // if (pType == "A4") { return new Rotativa.ViewAsPdf("~/Views/CashOperation/ListOfTransectionPreview.cshtml", glReport) { PageSize = Rotativa.Options.Size.A4 }; } // else if (pType == "A3") { return new Rotativa.ViewAsPdf("~/Views/CashOperation/ListOfTransectionPreview.cshtml", glReport) { PageSize = Rotativa.Options.Size.A3 }; } // else { return new Rotativa.ViewAsPdf("~/Views/CashOperation/ListOfTransectionPreview.cshtml", glReport) { PageSize = Rotativa.Options.Size.A5 }; } // } //} public ActionResult ListOfTransactionPreview(RptSearchVModel vmodel) { vmodel.fDate = Convert.ToDateTime(Session["fDate"]); vmodel.toDate = Convert.ToDateTime(Session["tDate"]); vmodel.BranchCode = Session["Branch"].ToString(); string finyear = Session["FinYear"].ToString(); if (Session["Data"] == null) { vmodel.JTrGrpId = ""; } else { vmodel.JTrGrpId = Session["Data"].ToString(); } //vmodel.JTrGrpId = Session["Data"].ToString(); //if (vmodel.JTrGrpId == null) //{ // vmodel.JTrGrpId = ""; //} // string x = "" = Session["NullData"].ToString(); string sql = string.Format("EXEC rptListTran '" + finyear + "','01','" + vmodel.BranchCode + "','" + vmodel.JTrGrpId + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.toDate.ToString("MM/dd/yyyy") + "'"); List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList(); ViewBag.BranchCode = vmodel.BranchCode; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate); ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch; if (ViewBag.HasBranch == true) { if (vmodel.BranchCode != null && vmodel.BranchCode != "0") { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } } // var glReport = Session["Data"].ToString(); //if (glReport == null) //{ // string errMsg = "Data not found !!!"; // return RedirectToAction("ListOfTransaction", "Search", new { errMsg }); //} //else //{ double amt = 0; //foreach (var item in glReport) //{ // double amt = 0; List <JarnalVoucher> sList = new List <JarnalVoucher>(); //InWord.ConvertToWords(amt.ToString()).ToList(); foreach (var item in glReport) { if (item.DrAmount > 0) { amt = item.DrAmount; } else if (item.CrAmount > 0) { amt = item.CrAmount; } JarnalVoucher sAmt = new JarnalVoucher(); sAmt.ACCode = item.ACCode; sAmt.VDate = item.VDate; sAmt.AcName = item.AcName; sAmt.InWords = InWord.ConvertToWords(amt.ToString()); sAmt.AcName = item.AcName; sAmt.Narration = item.Narration; sAmt.SubSidiary = item.SubSidiary; sAmt.CrAmount = item.CrAmount; sAmt.DrAmount = item.DrAmount; sAmt.VchrNo = item.VchrNo; sAmt.Posted = item.Posted; sAmt.Sub_Ac = item.Sub_Ac; sList.Add(sAmt); // } } //string InWordsamt = InWord.ConvertToWords(amt.ToString()); //ViewBag.InWordsAmt = InWordsamt; // ViewBag.glDate = date; // return View("~/Views/ListOfTransection/TransectionList.cshtml", glReport); return(new Rotativa.ViewAsPdf("ListOfTransactionPreview", sList) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); //} }
public ActionResult ReportLedgerPdf(RptSearchVModel vmodel, string finyear) { vmodel.BranchCode = Session["Branch"].ToString(); vmodel.LedgerTypeCode = Session["LedgerType"].ToString(); vmodel.AccountCode = Session["AccountCode"].ToString(); //vmodel.fDate = Session["fDate"].; //vmodel.tDate = Session["tDate"].ToString(); var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.LedgerTypeCode == vmodel.LedgerTypeCode); ViewBag.LedgerCap = ledger.LedgerCap; ViewBag.RptCap = ledger.RptCap; ViewBag.OpeningCap = ledger.OpeningCap; ViewBag.ClosingCap = ledger.ClosingCap; ViewBag.Col1Cap = ledger.Col1Cap; ViewBag.Col2Cap = ledger.Col2Cap; ViewBag.Col3Cap = ledger.Col3Cap; ViewBag.Col4Cap = ledger.Col4Cap; ViewBag.Col5Cap = ledger.Col5Cap; ViewBag.Col6Cap = ledger.Col6Cap; ViewBag.Col7Cap = ledger.Col7Cap; ViewBag.Col8Cap = ledger.Col8Cap; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate); ViewBag.AccountCode = vmodel.AccountCode; ViewBag.BranchCode = vmodel.BranchCode; if (vmodel.BranchCode != null) { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } if (vmodel.LedgerTypeCode == "01") { ViewBag.Account = _NewChartService.All().FirstOrDefault(x => x.Accode == vmodel.AccountCode.Trim()).AcName.ToString(); } else if (vmodel.LedgerTypeCode == "02") { ViewBag.Account = _SubsidiaryService.All().FirstOrDefault(x => x.SubCode == vmodel.AccountCode.Trim()).SubName.ToString(); } else { ViewBag.Account = _ItemService.All().FirstOrDefault(x => x.ItemCode == vmodel.AccountCode.Trim()).ItemName.ToString(); } ViewBag.PrintDate = DateTime.Now.ToShortDateString(); finyear = Session["FinYear"].ToString(); string sql = string.Format(" EXEC " + ledger.SP_Name + " '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.AccountCode + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.toDate.ToString("MM/dd/yyyy") + "'"); List <ReportLedger> rptLedger = _ReportLedgerService.SqlQueary(sql).ToList(); //if (rptLedger.Count == 0) //{ // string errMsg = "There is no data in this combination. Please try again !!!"; // return RedirectToAction("Search", "Report", new { errMsg }); //} //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(new Rotativa.ViewAsPdf("ReportLedgerPdf", rptLedger) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); }
public ActionResult Sample_GiftRptPdf(string LocCode, DateTime fDate, DateTime tDate) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(fDate), Convert.ToString(tDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("Sample_Gift_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg })); } ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate); ViewBag.Location = "All"; if (LocCode != "") { LocCode = _ILocationAppService.All().ToList().Where(s => s.LocCode == LocCode).Select(x => x.LocName).FirstOrDefault(); ViewBag.Location = LocCode; } List <Sample_giftRptVM> finalList = new List <Sample_giftRptVM>(); List <String> IssueIdList = new List <String>(); if (LocCode == "") { IssueIdList = _IIssueMainService.All().Where(x => x.IssueDate > fDate && x.IssueDate < tDate).Select(s => s.IssueNo).ToList(); } else { IssueIdList = _IIssueMainService.All().Where(x => x.IssueDate > fDate && x.IssueDate < tDate && x.FromLocCode == LocCode).Select(s => s.IssueNo).ToList(); } foreach (var IssueId in IssueIdList) { Sample_giftRptVM item = new Sample_giftRptVM(); var DetailList = _IssueDetailsAppService.All().FirstOrDefault(x => x.IssueNo == IssueId); var Mainlist = _IIssueMainService.All().FirstOrDefault(x => x.IssueNo == IssueId); item.No = IssueId; item.date = Mainlist.IssueDate.ToShortDateString(); item.Type = _INewChartAppService.All().Where(x => x.Accode == Mainlist.DesLocCode).Select(x => x.AcName).FirstOrDefault(); item.Lot = DetailList.LotNo; item.Quantity = DetailList.Qty; item.U_Price = DetailList.Price; item.Amount = Mainlist.Amount; item.Given_To = _ISubsidiaryInfoService.All().Where(x => x.SubCode == Mainlist.ToLocCode).Select(x => x.SubName).FirstOrDefault(); finalList.Add(item); } //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(new Rotativa.ViewAsPdf("~/Views/Sample_Gift/Sample_GiftRptPdf.cshtml", finalList) { CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\"" }); //return View(finalList); }
public ActionResult GetReportLedger(RptSearchVModel vmodel, string finyear) { var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString()); if (ChkFYR != "") { return(RedirectToAction("StockLedgerRpt", "StockLedgerRpt", new { errMsg = ChkFYR })); } RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("RptGeneralLedger_Preview")) { string errMsg = "No Preview Permission for this User !!"; return(RedirectToAction("StockLedgerRpt", "StockLedgerRpt", new { errMsg })); } vmodel.BranchCode = (vmodel.BranchCode == null) ? "" : vmodel.BranchCode; Session["Branch"] = vmodel.BranchCode; vmodel.AccountCode = (vmodel.AccountCode == null) ? "" : vmodel.AccountCode; Session["AccountCode"] = vmodel.AccountCode; Session["fDate"] = vmodel.fDate; Session["tDate"] = vmodel.toDate; var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == "rptStoreLedger"); ViewBag.LedgerCap = ledger.LedgerCap; ViewBag.RptCap = ledger.RptCap; ViewBag.OpeningCap = ledger.OpeningCap; ViewBag.ClosingCap = ledger.ClosingCap; ViewBag.Col1Cap = ledger.Col1Cap; ViewBag.Col2Cap = ledger.Col2Cap; ViewBag.Col3Cap = ledger.Col3Cap; ViewBag.Col4Cap = ledger.Col4Cap; ViewBag.Col5Cap = ledger.Col5Cap; ViewBag.Col6Cap = ledger.Col6Cap; ViewBag.Col7Cap = ledger.Col7Cap; ViewBag.Col8Cap = ledger.Col8Cap; ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate); ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate); ViewBag.AccountCode = vmodel.AccountCode; ViewBag.BranchCode = vmodel.BranchCode; ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch; if (vmodel.BranchCode != "" && vmodel.BranchCode != "0") { ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString(); } else { ViewBag.Branch = "All"; } if (vmodel.AccountCode != "") { ViewBag.Account = _ItemService.All().FirstOrDefault(x => x.ItemCode == vmodel.AccountCode.Trim()).ItemName.ToString(); } else { ViewBag.Account = "All"; } finyear = Session["FinYear"].ToString(); string sql = string.Format(" EXEC " + ledger.SP_Name + " '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.AccountCode + "','" + vmodel.fDate.ToString("MM-dd-yyyy") + "','" + vmodel.toDate.ToString("MM-dd-yyyy") + "'"); List <ReportLedger> rptLedger = _ReportLedgerService.SqlQueary(sql).ToList(); //For us Culture Ex: 0.00 const string culture = "en-US"; CultureInfo ci = CultureInfo.GetCultureInfo(culture); Thread.CurrentThread.CurrentCulture = ci; Thread.CurrentThread.CurrentUICulture = ci; return(View(rptLedger)); }