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