public GlAccount GetLastGlIn(MainGlCategory mainCategory) { using (ISession session = NHibernateHelper.OpenSession()) { return(session.Query <GlAccount>().Where(g => g.GlCategory.MainCategory == mainCategory).OrderByDescending(a => a.ID).First()); } }
public List <GlAccount> GetByMainCategory(MainGlCategory mainCategory) { using (ISession session = NHibernateHelper.OpenSession()) { return(session.Query <GlAccount>().Where(a => a.GlCategory.MainCategory == mainCategory).ToList()); } }
public bool AnyGlIn(MainGlCategory mainCategory) { using (ISession session = NHibernateHelper.OpenSession()) { return(session.Query <GlAccount>().Any(gl => gl.GlCategory.MainCategory == mainCategory)); } }
public long GenerateGLAccountNumber(MainGlCategory glMainCategory) { long code = 0; //get the last account number in this category if (glRepo.AnyGlIn(glMainCategory)) { var lastAct = glRepo.GetLastGlIn(glMainCategory); code = lastAct.CodeNumber + 1; } else //this is going to be the first act in this category { switch (glMainCategory) //these codes are assumed at author's descretion { case MainGlCategory.Asset: code = 1000102016; break; case MainGlCategory.Capital: code = 3000102016; break; case MainGlCategory.Expenses: code = 5000102016; break; case MainGlCategory.Income: code = 4000102016; break; case MainGlCategory.Liability: code = 2000102016; break; default: break; } }//end if return(code); }
public long GenerateGLAccountNumber(MainGlCategory glMainCategory) { long code = 0; //get the last account number in this category if (glRepo.AnyGlIn(glMainCategory)) { var lastAct = glRepo.GetLastGlIn(glMainCategory); code = lastAct.CodeNumber + 1; } else { switch (glMainCategory) //the codes below are just used at my discretion. { case MainGlCategory.Asset: code = 1000102016; break; case MainGlCategory.Capital: code = 3000102016; break; case MainGlCategory.Expenses: code = 5000102016; break; case MainGlCategory.Income: code = 4000102016; break; case MainGlCategory.Liability: code = 2000102016; break; default: break; } }//end if return(code); }
public ActionResult Create(AddGlActViewModel model) { ViewBag.GlCategoryId = new SelectList(glCatRepo.GetAll(), "ID", "Name", model.GlCategoryId); ViewBag.BranchId = new SelectList(branchRepo.GetAll(), "ID", "Name", model.BranchId); if (ModelState.IsValid) { try { var category = glCatRepo.GetById(model.GlCategoryId); var branch = branchRepo.GetById(model.BranchId); MainGlCategory mainCategory = (MainGlCategory)((int)category.MainCategory); //if is unique account name if (!gllogic.IsUniqueName(model.AccountName)) { ViewBag.Msg = "Account name must be unique"; return(View(model)); } GlAccount glAccount = new GlAccount() { AccountName = model.AccountName, GlCategory = category, Branch = branch, CodeNumber = gllogic.GenerateGLAccountNumber(mainCategory) }; glactRepo.Insert(glAccount); //ViewBag.Msg = "successfully added account"; return(RedirectToAction("Create", new { message = "successfully added account" })); } catch (Exception ex) { //ErrorLogger.Log("Message= " + ex.Message + "\nInner Exception= " + ex.InnerException + "\n"); return(PartialView("Error")); } } ViewBag.Msg = "Please enter correct data"; return(View(model)); }
public List <GlAccount> GetByMainCategory(MainGlCategory mainCategory) { return(db.GlAccounts.Where(a => a.GlCategory.MainCategory == mainCategory).ToList()); }
public GlAccount GetLastGlIn(MainGlCategory mainCategory) { return(db.GlAccounts.Where(g => g.GlCategory.MainCategory == mainCategory).OrderByDescending(a => a.ID).First()); }
public bool AnyGlIn(MainGlCategory mainCategory) { return(db.GlAccounts.Any(gl => gl.GlCategory.MainCategory == mainCategory)); }