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();
}
