public ActionResult CustomerLedgerPdf(CLSearchVModel vmodel, string finyear) { finyear = Session["FinYear"].ToString(); string sql = string.Format(" EXEC rptCustomerLedger '" + finyear + "','" + vmodel.SubCode + "','" + Convert.ToDateTime(vmodel.fDate) + "','" + Convert.ToDateTime(vmodel.tDate) + "'"); List <CustomerLedger> custLedger = _CustomerLedgerService.SqlQueary(sql).ToList(); ViewBag.fDate = vmodel.fDate; ViewBag.tDate = vmodel.tDate; ViewBag.Customer = _CustomerService.All().FirstOrDefault(x => x.SubCode == vmodel.SubCode.Trim()).SubName.ToString(); ViewBag.PrintDate = DateTime.Now.ToShortDateString(); return(new Rotativa.ViewAsPdf("CustomerLedgerPdf", custLedger)); }
public ActionResult GetCustomerLedger(CLSearchVModel vmodel, string finyear) { finyear = Session["FinYear"].ToString(); ViewBag.fDate = vmodel.fDate; ViewBag.tDate = vmodel.tDate; ViewBag.CustCode = vmodel.SubCode; ViewBag.Customer = _CustomerService.All().FirstOrDefault(x => x.SubCode == vmodel.SubCode.Trim()).SubName.ToString(); string sql = string.Format(" EXEC rptCustomerLedger '" + finyear + "','" + vmodel.SubCode + "','" + Convert.ToDateTime(vmodel.fDate) + "','" + Convert.ToDateTime(vmodel.tDate) + "'"); List <CustomerLedger> custLedger = _CustomerLedgerService.SqlQueary(sql).ToList(); if (custLedger.Count == 0) { string errMsg = "There is no data in this combination. Please try again !!!"; return(RedirectToAction("Search", "CustomerLedger", new { errMsg })); } else { return(View(custLedger)); } }