public RadComboBoxData LoadStoreDDL(RadComboBoxContext context) { //The RadComboBoxData object contains all required information for load on demand: // - the items // - are there more items in case of paging // - status message to be displayed (which is optional) RadComboBoxData result = new RadComboBoxData(); LookupDAO lkp = new LookupDAO(); List <KeyValuePair <string, string> > stores = lkp.GetStore(); //Get all items from the Customers table. This query will not be executed untill the ToArray method is called. var allStores = from store in stores orderby store.Key, store.Value select new RadComboBoxItemData { Text = store.Key + " - " + store.Value, Value = store.Key }; //In case the user typed something - filter the result set string text = context.Text; if (!String.IsNullOrEmpty(text)) { allStores = allStores.Where(item => item.Text.StartsWith(text)); } //Perform the paging // - first skip the amount of items already populated // - take the next 10 items int numberOfItems = context.NumberOfItems; var storelist = allStores.Skip(numberOfItems).Take(10); //This will execute the database query and return the data as an array of RadComboBoxItemData objects result.Items = storelist.ToArray(); int endOffset = numberOfItems + storelist.Count(); int totalCount = allStores.Count(); //Check if all items are populated (this is the last page) if (endOffset == totalCount) { result.EndOfItems = true; } //Initialize the status message result.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset, totalCount); return(result); }
public IActionResult FetchLookup([FromRoute] string ApiKey, [FromBody] LookupObj Param) { IActionResult response; LookupResponse resp = new LookupResponse(); try { #region Call Get_Data_Set LookupDAO ObjResponseDAO = new LookupDAO(_ConStr); DataSet ds = ObjResponseDAO.FetchLookup(ApiKey, Param); #endregion var lookups = (from r in ds.Tables[0].AsEnumerable() select new Lookup() { lookup_id = r.Field <int>("lookup_id"), lookup_code = r.Field <string>("lookup_code"), lookup_description = r.Field <string>("lookup_description"), lookup_name = r.Field <string>("lookup_name") }).ToList(); resp.statuscode = (int)Common.ResponseStatusCode.Success; resp.message = "success"; resp.rows = lookups; response = Ok(resp); } catch (Exception ex) { Common c = new Common(); ExceptionObj exobj = c.GetExceptionObjBase(ex); exobj.form_name = "BodyController"; exobj.page_url = "api/Body/List"; int ReturnVal; string ReturnMsg; ExceptionDAO exd = new ExceptionDAO(_ConStr); exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg); resp.statuscode = (int)Common.ResponseStatusCode.Exception; resp.message = ex.Message.ToString(); response = BadRequest(resp); } return(response); }
private void populateStoreDDL() { LookupDAO lkp = new LookupDAO(); List <KeyValuePair <string, string> > stores = lkp.GetStore(); List <KeyValuePair <Int16, string> > storesconcat = new List <KeyValuePair <Int16, string> >(); foreach (KeyValuePair <string, string> store in stores) { Int16 storeid = Int16.Parse(store.Key); KeyValuePair <Int16, string> listItem = new KeyValuePair <short, string>(storeid, (store.Key + " - " + store.Value)); storesconcat.Add(listItem); } rcbStore.DataSource = storesconcat; rcbStore.DataTextField = "value"; rcbStore.DataValueField = "key"; }