// GET: StockLedgerRpt
public ActionResult StockLedgerRpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); //GardenSelection();
ViewBag.AccountCode = new SelectList(_ItemService.All().ToList(), "ItemCode", "ItemName");
ViewBag.ItemType = new SelectList(_itemTypeService.All().ToList(), "ItemTypeCode", "ItemTypeName");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.Group = LoadDropDown.LoadGroupInfoByItemType("", _CommonVmService);
ViewBag.SubGroup = LoadDropDown.LoadSGroupByGroupId("", "", _CommonVmService);
ViewBag.SubSubGroup = LoadDropDown.LoadSSGroupInfo("", "", "", _CommonVmService);
#region For item Filtering option
ViewBag.NoGrp = sysSet.NoGrp;
ViewBag.OnlyGrp = sysSet.OnlyGrp;
ViewBag.GrpAndSubGrp = sysSet.GrpAndSubGrp;
ViewBag.SubSubGrp = sysSet.SubSubGrp;
#endregion
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
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 static SelectList LoadAllFinYears(IFYDDAppService _fYDDService)
{
var items = _fYDDService.All().ToList()
.Select(x => new { x.Id, x.FinYear }).OrderByDescending(x => x.Id).ToList();
//items.Insert(0, new { ID = 0, FinYear = "---- Select ----" });
return(new SelectList(items, "FinYear", "FinYear"));
}
public ActionResult PendingSearch()
{
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
return(View());
}
public ActionResult Sample_GiftRptSearch()
{
ViewBag.LocCode = new SelectList(_ILocationAppService.All().ToList(), "LocCode", "LocName");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
return(View());
}
// GET: IncomeExpenditure
public ActionResult IncomeExpenditure()
{
if (Session["UserID"] != null)
{
ViewBag.ProjName = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
ViewBag.BrName = new SelectList(_BranchService.All().ToList(), "BrCode", "BrName");
ViewBag.FYDD = new SelectList(_FYDDService.All().ToList(), "FinYear", "FinYear");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
//ViewBag.RptCaption = "Income and Expenditure A/C Report";
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Search(string errMsg)
{
var Fydd = _IFYDDAppService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.SubCode = new SelectList(_ISubsidiaryInfoAppService.All().Where(x => x.SubType == "1").ToList(), "SubCode", "SubName");
ViewBag.Message = errMsg;
return(View());
}
public ActionResult Montly_Amount_Quantity_Rpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.Location = new SelectList(_ILocationAppService.All().ToList(), "LocCode", "LocName").ToList(); //GardenSelection();
ViewBag.CustomerName = new SelectList(_ISubsidiaryInfoService.All().ToList().Where(x => x.SubType == "1"), "SubCode", "SubName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); //GardenSelection();
ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult BalSheetRpt(string errMsg, string RptCaption)
{
if (Session["UserID"] != null)
{
ViewBag.ProjName = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
ViewBag.BrName = new SelectList(_BranchService.All().ToList(), "BrCode", "BrName");
ViewBag.FYDD = new SelectList(_FYDDService.All().ToList(), "FinYear", "FinYear");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
if (RptCaption == "rptBalanceSheet")
{
ViewBag.RptCaption = "Balance Sheet Report";
}
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult CollectionStatementRpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");//GardenSelection();
ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
//
// GET: /ListOfTransection/
public ActionResult Search(string errMsg)
{
if (Session["UserID"] != null)
{
//ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == Session["BranchCode"].ToString()).BranchName;
ViewBag.JTrGrpId = new SelectList(_jTrGrpService.All().ToList(), "VType", "TypeDesc");
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;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: ProductionRpt
public ActionResult ProductionRpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.ItemType = new SelectList(_itemTypeService.All().ToList(), "ItemTypeCode", "ItemTypeName");
ViewBag.ItemCode = LoadDropDown.LoadItemByItemType("", _CommonVmService);
ViewBag.BranchCode = new SelectList(_branchService.All().ToList(), "BranchCode", "BranchName");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Search(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.LedgerTypeCode = new SelectList(_SumRptTypeService.All().ToList(), "ReportTypeCode", "ReportTypeName");
ViewBag.BranchCode = PermittedBranch();//new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.BookType = LoadDropDown.LoadBookType();
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult ItemWiseSalesStatementRpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.LocCode = new SelectList(_locationService.All().ToList(), "LocCode", "LocName");
ViewBag.ItemCode = LoadDropDown.LoadItems(_ItemService);
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult RateChart(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.CustGroup = LoadDropDown.LoadSubGrpDDL();
ViewBag.CustCode = LoadDropDown.LoadSubsidiary(_ISubsidiaryInfoService);
ViewBag.ItemCode = LoadDropDown.LoadItem(_IItemInfoAppService);
ViewBag.CustType = new SelectList(ISubsidiaryTypeService.All().ToList(), "TypeCode", "SubType");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: JobWiseRecPay
public ActionResult JobWiseRecPay(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
//ViewBag.FYDD = new SelectList(_FYDDService.All().ToList(), "FinYear", "FinYear");
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Search(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.LedgerTypeCode = new SelectList(_LedgerTypeService.All().ToList(), "LedgerTypeCode", "LedgerTypeName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); //GardenSelection();
ViewBag.AccountCode = LoadDropDown.LoadAccount("", _ItemService, _SubsidiaryService, _NewChartService);
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
//var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: Store
public ActionResult StoreRpt(string errMsg)
{
if (Session["UserID"] != null)
{
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.ItemCode = new SelectList(_ItemInfoService.All().ToList(), "ItemCode", "ItemName");
ViewBag.Source = new SelectList(_issRecvSrcDestService.All().ToList().Where(x => x.Type == "S"), "SrcDestId", "SrcDestName");
ViewBag.DesLocCode = new SelectList(_issRecvSrcDestService.All().ToList().Where(x => x.Type == "D"), "SrcDestId", "SrcDestName");
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Sales_CollectionSearch(string errMsg)
{
if (Session["UserID"] != null)
{
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
string branchCode = Session["BranchCode"].ToString();
ViewBag.LocCode = new SelectList(_ILocationAppService.All().ToList(), "LocCode", "LocName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");//GardenSelection();
ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
ViewBag.SubCode = new SelectList(_SubsidiaryService.All().ToList(), "SubCode", "SubName");
ViewBag.errMsg = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult LogIn(string returnUrl)
{
ViewBag.returnUrl = returnUrl;
ViewBag.FinYear = new SelectList(_FYDDAppService.All().OrderByDescending(x => x.FinYear), "FinYear", "FinYear");
return(View());
}
public ActionResult VatRpt(string errMsg)
{
if (Session["UserID"] != null)
{
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}