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 Search(string errMsg, string RptCaption)
{
if (Session["UserID"] != null)
{
//ViewBag.LedgerTypeCode = new SelectList(_SumRptTypeService.All().ToList(), "ReportTypeCode", "ReportTypeName");
ViewBag.LedgerTypeCode = new SelectList(_LedgerCapService.All().ToList(), "SP_Name", "RptName");
//var result = EFContext.TestAddresses.Select(m => m.Name).Distinct();
//callList.Select(c => c.ApplicationID).Distinct()
// var query = prodDtcx.PersonAddress.Select(adr => adr.City).OrderBy(adr.City) .Distinct();
//same data avoid (shahin)
ViewBag.LevelNo = new SelectList(_newchartAppService.All().Select(x => new { LevelNo = x.LevelNo })
.Distinct(), "LevelNo", "LevelNo");
ViewBag.LocCode = new SelectList(_locationService.All().ToList(), "LocCode", "LocName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");//GardenSelection();
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT.ToString("dd/MM/yyyy");
ViewBag.Message = errMsg;
if (RptCaption == "rptTBProcess")
{
ViewBag.RptCaption = "Trial Balance";
}
else if (RptCaption == "rptStockSumm")
{
ViewBag.RptCaption = "Stock Summary";
}
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
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));
}
