public static SelectList GetSelectList_BranchDepartment(object sValue, int BranchId, string NullOrNameEmpty) { var selectListItems = new List <SelectListItem>(); BranchDepartmentRepository branchDepartmentRepository = new BranchDepartmentRepository(new Domain.Sale.ErpSaleDbContext()); if (NullOrNameEmpty != null) { SelectListItem itemEmpty = new SelectListItem(); itemEmpty.Text = NullOrNameEmpty; itemEmpty.Value = null; selectListItems.Add(itemEmpty); } try { var q = branchDepartmentRepository.GetAllvwBranchDepartment().Where(x => x.Sale_BranchId == BranchId).OrderBy(item => item.Sale_DepartmentId); foreach (var i in q) { SelectListItem item = new SelectListItem(); item.Text = i.Sale_DepartmentId; item.Value = i.Id.ToString(); selectListItems.Add(item); } } catch { } var selectList = new SelectList(selectListItems, "Value", "Text", sValue); return(selectList); }
public IEnumerable <vwBranchDepartment> FetchBranchDepartment(int?BranchId) { BranchDepartmentRepository departmentRepository = new BranchDepartmentRepository(new ErpStaffDbContext()); List <vwBranchDepartment> departmentList = departmentRepository.GetAllvwBranchDepartment().Where(x => x.Sale_BranchId == BranchId).ToList(); departmentList.Insert(0, new vwBranchDepartment() { Id = -1, Staff_DepartmentId = "- Rỗng -" }); return(departmentList); }