/// <summary> /// get skill agregation for list box control /// </summary> protected void GetSkillAgregationListForDDL(string selectedAgregationIDs, bool hasExtraHeader = false) { if (string.IsNullOrEmpty(selectedAgregationIDs)) { selectedAgregationIDs = "None"; } List <SelectListItem> lstItem = new List <SelectListItem>(); List <uspWFMGetAggregationResult> lstSkillAgregation = new List <uspWFMGetAggregationResult>(); if (hasExtraHeader) { lstItem.Insert(0, new SelectListItem { Text = "指定なし", Value = "0" }); } using (WFMDBDataContext db = new WFMDBDataContext()) { lstSkillAgregation = db.uspWFMGetAggregation(this.TenantID, this.TenantSpecialFlag).ToList(); } foreach (var item in lstSkillAgregation) { lstItem.Add(new SelectListItem { Text = item.vAggregationName, Value = item.iAggregationID.ToString(), Selected = selectedAgregationIDs.Contains(item.iAggregationID.ToString()) }); } ViewData["lstSkillAgregation"] = lstItem; }
// GET: SkillAgregation public ActionResult Index() { List <uspWFMGetAggregationResult> lstSkillAgregation = new List <uspWFMGetAggregationResult>(); using (WFMDBDataContext db = new WFMDBDataContext()) { lstSkillAgregation = db.uspWFMGetAggregation(this.TenantID, this.TenantSpecialFlag).ToList(); } return(View(lstSkillAgregation)); }
/// <summary> /// get skill agregation for list box control /// </summary> protected void GetSkillAgregationListForDDL(string selectedAgregationIDs, bool hasExtraHeader = false) { if (string.IsNullOrEmpty(selectedAgregationIDs)) selectedAgregationIDs = "None"; List<SelectListItem> lstItem = new List<SelectListItem>(); List<uspWFMGetAggregationResult> lstSkillAgregation = new List<uspWFMGetAggregationResult>(); if (hasExtraHeader) { lstItem.Insert(0, new SelectListItem { Text = "指定なし", Value = "0" }); } using (WFMDBDataContext db = new WFMDBDataContext()) { lstSkillAgregation = db.uspWFMGetAggregation(this.TenantID, this.TenantSpecialFlag).ToList(); } foreach (var item in lstSkillAgregation) { lstItem.Add(new SelectListItem { Text = item.vAggregationName, Value = item.iAggregationID.ToString(), Selected = selectedAgregationIDs.Contains(item.iAggregationID.ToString()) }); } ViewData["lstSkillAgregation"] = lstItem; }
// GET: SkillAgregation public ActionResult Index() { List<uspWFMGetAggregationResult> lstSkillAgregation = new List<uspWFMGetAggregationResult>(); using (WFMDBDataContext db = new WFMDBDataContext()) { lstSkillAgregation = db.uspWFMGetAggregation(this.TenantID, this.TenantSpecialFlag).ToList(); } return View(lstSkillAgregation); }