public ActionResult VMBIN()
{
var itemProj = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
List <SelectListItem> _list = itemProj.ToList();
_list.Insert(0, new SelectListItem()
{
Value = "-1", Text = "---select---"
});
itemProj = new SelectList((IEnumerable <SelectListItem>)_list, "Value", "Text");
ViewBag.ProjCode = itemProj;
var itemBranch = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
List <SelectListItem> _listBranch = itemBranch.ToList();
_listBranch.Insert(0, new SelectListItem()
{
Value = "-1", Text = "---select---"
});
itemBranch = new SelectList((IEnumerable <SelectListItem>)_listBranch, "Value", "Text");
ViewBag.BranchCode = itemBranch;
return(View());
}
private string SaveProjectInfo(VMMasterForm MstrInf)
{
var ProjCode = _projInfoService.All().ToList().FirstOrDefault(x => x.ProjCode == MstrInf.Code);
if (ProjCode == null)
{
ProjInfo _proj = new ProjInfo();
_proj.ProjCode = MstrInf.Code;
_proj.ProjName = MstrInf.Name;
_proj.ProjLocalName = MstrInf.LocalName;
_proj.ProjDescrip = MstrInf.Descr;
_projInfoService.Add(_proj);
_projInfoService.Save();
var ProjID = _proj.ProjID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveProjectInfo",
ProjID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("2");
}
}
public ActionResult Vat6P9P1_1Rpt(string errMsg)
{
if (Session["UserID"] != null)
{
AcclineERPContext dbContext = new AcclineERPContext();
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
ViewBag.DesignationCode = new SelectList(dbContext.Designation, "DesigCode", "DesigDesc");
//ViewBag.DesignationCode = LoadDropDown.LoadAllDesignation(_designationService);
//ViewBag.des = new SelectList(_designationService.All().ToList(), "DesigCode", "DesigDesc");
ViewBag.ApprBy = LoadAppBy(_employeeInfoService);
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.FinYear = LoadDropDown.LoadAllFinYears(_FYDDService);
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: CashMoneyReceipt
public ActionResult CashMoneyReceipt(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.MRAgainst = LoadDropDown.LoadMRAgainstDDL();
ViewBag.CustCode = new SelectList(_subsidiaryInfoService.All().ToList().Where(x => x.SubType == "1"), "SubCode", "SubName");
var VchrConv = _vchrSetService.All().ToList().FirstOrDefault().VchrConv;
Session["VchrConv"] = VchrConv;
ViewBag.MRSL = LoadDropDown.GenerateRecvSlNo(_moneyReceiptService, "", Session["BranchCode"].ToString(), "", Session["VchrConv"].ToString());
DateTime datetime = DateTime.Now;
ViewBag.GLProvition = Counter("CR");
ViewBag.GLEntries = CountEntries("CR", datetime);
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintJob = sysSet.MaintJob;
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
ViewBag.errMsg = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult GL_OpenBal()
{
ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
var defAc = LoadDropDown.GetDefAc();
List <NewChart> charts = _NewChartAppService.All().ToList().Where(x => x.Accode.Substring(0, 1) == defAc.AssAc || x.Accode.Substring(0, 1) == defAc.LiaAc).ToList();
List <NewChart> finalList = new List <NewChart>();
foreach (var chart in charts)
{
bool key = true;
foreach (var temp in charts)
{
if (chart == temp)
{
}
else
{
if (chart.Accode == temp.ParentAcCode)
{
key = false;
}
}
}
if (key)
{
finalList.Add(chart);
}
}
ViewBag.Accode = new SelectList(finalList, "Accode", "AcName");
return(View());
}
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: 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 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"));
}
}
// 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 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 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 LoadChartofAccounts(string errMsg)
{
if (Session["UserID"] != null)
{
var sepa = _minLevService.All().FirstOrDefault();
ViewBag.Separator = sepa.Sepa;
ViewBag.errMsg = errMsg;
ViewBag.ProjName = new SelectList(_projInfoService.All().ToList(), "ProjId", "ProjName");
var plist = _newChartService.All().Where(x => x.ParentCode == 0).Select(a => new
{
a.AcSyscode,
a.AcName
}).ToList();
GetHierarchy();
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}