public List <string> getProductName_En(string prefix)
{
Bis.ProductMethod bisProduct = new Bis.ProductMethod();
ViewModel.Search searchProduct = new ViewModel.Search();
searchProduct.Filter = "and tblProduct.Accessory='false' and tblProduct.Name_En like N'%" + prefix.FixFarsi() + "%' ";
DataSet dsProduct = bisProduct.GetProductData(searchProduct);
List <string> ProductNames = new List <string>();
if (!dsProduct.Null_Ds())
{
for (int i = 0; i < dsProduct.Tables[0].Rows.Count; i++)
{
ProductNames.Add(string.Format("{0}~{1}", dsProduct.Tables[0].Rows[i]["Name_En"].ToString(), dsProduct.Tables[0].Rows[i]["IDProduct"].ToString()));
//string item = AutoCompleteExtender.CreateAutoCompleteItem(dsProduct.Tables[0].Rows[i]["ProductCodeName"].ToString(), dsProduct.Tables[0].Rows[i]["IDProduct"].ToString());
//ProductNames.Add(item);
}
return(ProductNames);
}
else
{
ProductNames.Add(string.Format("{0},{1}", "اطلاعاتی یافت نشد", "اطلاعاتی یافت نشد"));
return(ProductNames);
}
}
public object ProductAutoComplete(object searchparam)
{
Bis.ProductMethod bisProduct = new Bis.ProductMethod();
try
{
if (searchparam != "")
{
ViewModel.Search searchProduct = new ViewModel.Search();
searchProduct.Filter = " and (tblProduct.Name_Fa Like N'%" + searchparam.ToString().FixFarsi() +
"%' or tblProduct.Name_En Like N'%" + searchparam.ToString().FixFarsi() +
"%') and tblProduct.Accessory = 'False' and tblProduct.AcceptByAdmin = 'true' and tblProduct.ShowInSite = 'true' and tblProductCategory.ShowInSite = 'true' ";
searchProduct.Order = "order by tblProduct.Name_Fa desc";
DataSet ds = bisProduct.GetDataAutoCompeleForCompare(searchProduct);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
Dictionary <string, object> row;
foreach (DataRow dr in ds.Tables[0].Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in ds.Tables[0].Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
return(serializer.Serialize(rows));
}
else
{
return("");
}
}
catch (Exception)
{
throw;
}
finally
{
}
}
public List <string> getAccessoryCodeAndName(string prefix)
{
Bis.ProductMethod bisAccessory = new Bis.ProductMethod();
ViewModel.Search searchAccessory = new ViewModel.Search();
searchAccessory.Filter = " and tblProduct.Accessory='true' and (tblProduct.ProductCode like N'%" + prefix.FixFarsi() + "%' or tblProduct.Name_Fa like N'%" + prefix.FixFarsi() + "%' )";
//searchCompany.Order = "order by tblLegalUser.Name_Fa desc";
DataSet dsAccessory = bisAccessory.GetProductData(searchAccessory);
List <string> AccessoryNames = new List <string>();
if (!dsAccessory.Null_Ds())
{
for (int i = 0; i < dsAccessory.Tables[0].Rows.Count; i++)
{
AccessoryNames.Add(string.Format("{0}~{1}", dsAccessory.Tables[0].Rows[i]["AccessoryCodeName"].ToString(), dsAccessory.Tables[0].Rows[i]["IDProduct"].ToString()));
}
return(AccessoryNames);
}
else
{
AccessoryNames.Add(string.Format("{0}~{1}", "اطلاعاتی یافت نشد", Guid.Empty));
return(AccessoryNames);
}
}
