public ActionResult GetReportLedger(string LedgerTypeCode, DateTime fDate, DateTime toDate, string Ctrl_SubCode, string BranchCode)
{
Session["LedgerType"] = "01";
Session["AccountCode"] = Ctrl_SubCode;
var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.RptCap == 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 = fDate;
ViewBag.tDate = toDate;
ViewBag.AccountCode = Ctrl_SubCode;
ViewBag.BranchCode = BranchCode;
//ViewBag.OB = _ReportLedgerService.All().ToList().FirstOrDefault().OpenBal;
if (BranchCode != null)
{
ViewBag.Branch = BranchCode;//_BranchService.All().FirstOrDefault(x => x.BranchCode == BranchCode.Trim()).BranchName.ToString();
}
else
{
ViewBag.Branch = "All";
}
BranchCode = _BranchService.All().FirstOrDefault(x => x.BranchName == BranchCode).BranchCode.ToString();
Session["Branch"] = BranchCode;
ViewBag.Account = LedgerTypeCode;
string finYear = Session["FinYear"].ToString();
string sql = string.Format("EXEC " + ledger.SP_Name + " '" + finYear + "','','" + BranchCode + "','" + Ctrl_SubCode + "','" + fDate.ToString("MM/dd/yy") + "','" + toDate.ToString("MM/dd/yy") + "'");
List <ReportLedger> rptLedger = _ReportLedgerService.SqlQueary(sql).ToList();
//if (rptLedger.Count == 0)
//{
// //, new { errMsg });//
// //string errMsg = "There is no data in this combination. Please try again !!!";
// return RedirectToAction("GetSummaryReport2", "SummaryReport", new { fDate = @ViewBag.fDate, tDate = @ViewBag.tDate, LedgerTypeCode = "011" });
//}
//else
//{
return(View("~/Views/Report/GetReportLedger.cshtml", rptLedger));
//}
}
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));
}