public List <string> getCompanyName(string prefixText) { Bis.LegalUserMethod bisCompany = new Bis.LegalUserMethod(); ViewModel.Search searchCompany = new ViewModel.Search(); searchCompany.Filter = " and tblLegalUser.Name_Fa like N'%" + prefixText.FixFarsi() + "%'"; //searchCompany.Order = "order by tblLegalUser.Name_Fa desc"; DataSet dsCompany = bisCompany.GetCutomerData(searchCompany); List <string> CompanyNames = new List <string>(); if (!dsCompany.Null_Ds()) { for (int i = 0; i < dsCompany.Tables[0].Rows.Count; i++) { string item = AutoCompleteExtender.CreateAutoCompleteItem(dsCompany.Tables[0].Rows[i]["Name_Fa"].ToString(), dsCompany.Tables[0].Rows[i]["IDUser"].ToString()); CompanyNames.Add(item); } } return(CompanyNames); }
public List <string> getLegalUserForShowingInlogin(string prefix) { Bis.LegalUserMethod bisCompany = new Bis.LegalUserMethod(); ViewModel.Search searchCompany = new ViewModel.Search(); searchCompany.Filter = " and tblLegalUser.Name_Fa like N'%" + prefix.FixFarsi() + "%' "; //searchCompany.Order = "order by tblLegalUser.Name_Fa desc"; DataSet dsCompany = bisCompany.GetCutomerData(searchCompany); List <string> CompanyNames = new List <string>(); if (!dsCompany.Null_Ds()) { for (int i = 0; i < dsCompany.Tables[0].Rows.Count; i++) { CompanyNames.Add(string.Format("{0}~{1}", dsCompany.Tables[0].Rows[i]["Name_Fa"].ToString(), dsCompany.Tables[0].Rows[i]["IDUser"].ToString())); } return(CompanyNames); } else { CompanyNames.Add(string.Format("{0},{1}", "اطلاعاتی یافت نشد", "اطلاعاتی یافت نشد")); return(CompanyNames); } }