public ActionResult GetSection(DataSourceLoadOptions loadOptions, SectionCriteriaCombo criteria) { criteria.userCode = UserDetail.UserID; List <SectionCombo> sectionCombo = this.CommonService.GetSectionCombo(criteria); if ((criteria.IncludeAll ?? false) == true) { sectionCombo.Insert(0, new SectionCombo() { SecCodeKey = ConstantValues.AllValue, SecName = ConstantValues.AllDisplay }); } return(Content(JsonConvert.SerializeObject(DataSourceLoader.Load(sectionCombo, loadOptions)), ConstantValues.JSON_CONTENT_TYPE)); }
public List <SectionCombo> GetSectionCombo(SectionCriteriaCombo criteria) { using (CommonEntities Context = new CommonEntities()) { var result = Context.GetSectionCombo( prodDate: criteria.ProdDate , prodDateFrom: criteria.ProdDateFrom , prodDateTo: criteria.ProdDateTo , deptCodeKey: criteria.DeptCodeKey , secCodeKey: criteria.SecCodeKey , userCode: criteria.userCode , isActiveOnly: criteria.IsActiveOnly ).ToList(); return(result); } }