public List <GetSectionComboResult> GetSectionCombo(SectionCriteria criteria) { using (TransactionEntities Context = new TransactionEntities()) { var result = Context.GetSectionCombo( prodDate: criteria.ProdDate , deptCode: criteria.DeptCode , userCode: criteria.UserCode ).ToList(); return(result); } }
public ActionResult GetSectionComboData(DataSourceLoadOptions loadOptions, string strDeptCode) { SectionCriteria cri = new SectionCriteria(); cri.ProdDate = this.CommonService.GetProductionDate(); cri.DeptCode = string.IsNullOrWhiteSpace(strDeptCode) ? null : strDeptCode; cri.UserCode = UserDetail.UserID; //test //cri.UserCode = "3570"; var Sections = this.TransactionService.GetSectionCombo(cri); //Sections.Insert(0, new GetSectionCombo_Result() { SecCode = null, SecCodeDisplay = "--Select--"}); return(Content(JsonConvert.SerializeObject(DataSourceLoader.Load(Sections, loadOptions)), ConstantValues.JSON_CONTENT_TYPE)); }