public static List <KeyValuePair <string, int> > ReloadCity(string parm)
{
List <string> City = new List <string>();
List <KeyValuePair <string, int> > dataList = new List <KeyValuePair <string, int> >();
sql_class sqlQuery = new sql_class();
sqlQuery.WhereLIKE("CityName", parm);
sqlQuery.Limit(5);
DataTable data = sqlQuery.Get("City", "CityName", "CityID");
if (data.Rows.Count == 0)
{
dataList.Add(new KeyValuePair <string, int>("לא נמצאו התאמות", -1));
}
var sizedata = data.Rows.Count;
var i = 0;
while (sizedata > 0)
{
dataList.Add(new KeyValuePair <string, int>(data.Rows[i]["CityName"].ToString(), Convert.ToInt32(data.Rows[i]["CityID"])));
sizedata--;
i++;
}
return(dataList);
}
public static List <string> AutoCompilteId_card(string parm)
{
List <string> autoid = new List <string>();
sql_class sqlQuery = new sql_class();
sqlQuery.WhereLIKE("UsarName", parm);
sqlQuery.Limit(5);
DataTable data = sqlQuery.Get("Customer", "UsarName");
if (data.Rows.Count == 0)
{
autoid.Add("לא נמצאו התאמות");
}
var sizedata = data.Rows.Count;
var i = 0;
while (sizedata > 0)
{
autoid.Add(data.Rows[i]["UsarName"].ToString());
sizedata--;
i++;
}
return(autoid);
}