private IList<string> GetAllWords(string keywordStartsWith, int limit) { StringBuilder sb = new StringBuilder(); using (App_Data.DataClassesERPDataContext db = new App_Data.DataClassesERPDataContext()) { var query = from ord in db.partnos //where ord.part_no.StartsWith(keywordStartsWith) where SqlMethods.Like(ord.part_no, "%" + keywordStartsWith + "%") select ord; // Execute the query, and change the column values // you want to change. //foreach (App_Data.partno ord in query) foreach (var ord in query) { sb.Append(Convert.ToString(ord.part_no.Trim() + "|")); } //return Convert.ToString(sb); } ////TODO: implement real search here! //// dummy implementation IList<string> output = new List<string>(); output = sb.ToString().Split('|'); //output.Add(keywordStartsWith + "1"); //output.Add(keywordStartsWith + "2"); //output.Add(keywordStartsWith + "3"); //output.Add(keywordStartsWith + "4"); return output; }
public AjaxControlToolkit.CascadingDropDownNameValue[] Getregion(string knownCategoryValues, string category) { List<AjaxControlToolkit.CascadingDropDownNameValue> regions = new List<AjaxControlToolkit.CascadingDropDownNameValue>(); var sd = AjaxControlToolkit.CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); string dcountry = sd["country"]; using (App_Data.DataClassesERPDataContext db = new App_Data.DataClassesERPDataContext()) { var ddregion = from bc in db.location_regions where bc.id_num == Convert.ToInt32(dcountry) select bc; dcountry = ddregion.Single().country.ToString(); } using (App_Data.DataClassesERPDataContext db = new App_Data.DataClassesERPDataContext()) { var ddregion = from bc in db.location_regions where bc.country == dcountry && bc.flag == 1 orderby bc.region select new { region = bc.region, id_num = bc.id_num }; foreach (var obj in ddregion) { regions.Add(new AjaxControlToolkit.CascadingDropDownNameValue(obj.region.ToString(), obj.id_num.ToString())); } } return regions.ToArray(); }
public string[] GetCompletionList(string prefixText, int count) { List<string> output = new List<string>(); using (App_Data.DataClassesERPDataContext db = new App_Data.DataClassesERPDataContext()) { var query = from ord in db.partnos //where ord.part_no.StartsWith(prefixText) where SqlMethods.Like(ord.part_no, "%" + prefixText + "%") select ord; foreach (var ord in query) { output.Add(ord.part_no.Trim()); } //return Convert.ToString(sb); } ////TODO: implement real search here! return output.ToArray(); //if (count == 0) //{ // count = 10; //} //if (prefixText.Equals("xyz")) //{ // return new string[0]; //} //if (prefixText.Equals("xyz")) //{ // return new string[0]; //} //Random random = new Random(); //List<string> items = new List<string>(count); //for (int i = 0; i < count; i++) //{ // char c1 = (char)random.Next(65, 90); // char c2 = (char)random.Next(97, 122); // char c3 = (char)random.Next(97, 122); // items.Add(prefixText + c1 + c2 + c3); //} //return items.ToArray(); }
public AjaxControlToolkit.CascadingDropDownNameValue[] Getcountry(string knownCategoryValues, string category) { List<AjaxControlToolkit.CascadingDropDownNameValue> countries = new List<AjaxControlToolkit.CascadingDropDownNameValue>(); using (App_Data.DataClassesERPDataContext db = new App_Data.DataClassesERPDataContext()) { var ddcountry = from c in db.location_regions where c.flag == 0 orderby c.country select new { c.country, c.id_num }; foreach (var obj in ddcountry) { countries.Add(new AjaxControlToolkit.CascadingDropDownNameValue(obj.country.ToString().Trim(), obj.id_num.ToString().Trim())); } } return countries.ToArray(); }