public ChartOfAccount ChartOfAccountData(string accountCode) { var coaItem = new POSAccount.Contract.ChartOfAccount(); if (accountCode != null && accountCode.Length > 0) { coaItem = new POSAccount.BusinessFactory.ChartOfAccountBO().GetChartOfAccount(new Contract.ChartOfAccount { AccountCode = accountCode, BranchID = Utility.SsnBranch }); } coaItem.CurrencyCodeList = Utility.GetCurrencyItemList(); coaItem.AccountGroupList = Utility.GetAccountGroupItemList(Convert.ToInt16((Session["BranchId"]))).Where(x => x.Value != accountCode).ToList(); coaItem.DebitCreditList = Utility.GetLookupItemList("DebitCredit"); return(coaItem); }
public ActionResult UpdateChartOfAccount(POSAccount.Contract.ChartOfAccount item) { if (ModelState.IsValid) { if (item.BranchID == 0) { item.BranchID = Utility.SsnBranch; } if (item == null) { return(new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest)); } item.CreatedBy = Utility.DEFAULTUSER; item.ModifiedBy = Utility.DEFAULTUSER; var result = new POSAccount.BusinessFactory.ChartOfAccountBO().SaveChartOfAccount(item); } return(RedirectToAction("ChartOfAccountMaster", "MasterData")); }
public ActionResult ChartOfAccountMaster(string branchID, string _accountCode = "") { var accountCode = Request.Form["hdnAccountCode"]; if (string.IsNullOrWhiteSpace(accountCode)) { if (!string.IsNullOrWhiteSpace(_accountCode)) { accountCode = _accountCode; } } ViewData["hdnAccountCode"] = accountCode; short branchId = -1; if (branchID != null) { branchId = Convert.ToInt16(branchID); } else { branchId = Convert.ToInt16(Session["BranchId"]); } //var ChartOfAccounts = new POSAccount.BusinessFactory.ChartOfAccountBO().GetList(); var accountGroupList = new POSAccount.BusinessFactory.AccountGroupBO().GetList(); var chartOfAccountsList = new POSAccount.BusinessFactory.ChartOfAccountBO().GetList(branchId); List <AccountGroupVm> accountGroupVm = new List <AccountGroupVm>(); for (var i = 0; i < accountGroupList.Count; i++) { var code = accountGroupList[i].Code; AccountGroupVm accountGroup = new AccountGroupVm(); accountGroup.Code = accountGroupList[i].Code; accountGroup.AccountType = accountGroupList[i].AccountType; accountGroup.Description = accountGroupList[i].Description; accountGroup.Description1 = accountGroupList[i].Description1; accountGroup.Description2 = accountGroupList[i].Description2; accountGroup.SequenceNo = accountGroupList[i].SequenceNo; accountGroup.COAList = chartOfAccountsList.Where(x => x.AccountGroup == accountGroupList[i].Code) .Select(x => new ChartOfAccountsVm() { AccountCode = x.AccountCode, Description = x.Description, Description2 = x.Description2, AccountGroup = x.AccountGroup, DebitCredit = x.DebitCredit, CurrencyCode = x.CurrencyCode, Status = x.Status, Sequence = x.Sequence, BranchID = x.BranchID, CreatedBy = x.CreatedBy, CreatedOn = x.CreatedOn, ModifiedBy = x.ModifiedBy, ModifiedOn = x.ModifiedOn, AccountGroupDescription = x.AccountGroupDescription, COAList = PopulateChilds(x.AccountCode, chartOfAccountsList) }).ToList <ChartOfAccountsVm>(); accountGroupVm.Add(accountGroup); } /* * var list = ChartOfAccounts.GroupBy(x => x.AccountGroup) * .Select(x => new MyItem() { * Description = x.FirstOrDefault().Description, * Description2 = x.FirstOrDefault().Description2, * AccountGroupDescription = x.FirstOrDefault().AccountGroupDescription, * Sequence = x.FirstOrDefault().Sequence, * AccountCode = x.FirstOrDefault().AccountCode, * ChildItems = (ChartOfAccounts.Where(y => y.AccountGroup == x.FirstOrDefault().AccountGroup) * .Select(y => new MyItem() { * Description = y.Description, * Description2 = y.Description2, * AccountGroupDescription = y.AccountGroupDescription, * Sequence = y.Sequence, * AccountCode = y.AccountCode * })).ToList() * }).ToList<MyItem>();*/ if (Request.IsAjaxRequest()) { return(Json(accountGroupVm, JsonRequestBehavior.AllowGet)); } else { return(View("ChartOfAccounts", accountGroupVm)); } }