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));
}
}
