public static List <Items> GetItems(string prefixText)
{
List <string> ar = new List <string>();
IItemMaster _iMGR = (IItemMaster)ObjectFactory.CreateInstance("BusinessProcess.Administration.BItemMaster, BusinessProcess.Administration");
//filling data from database
int?consumableItemTypeID = null;
if (System.Web.HttpContext.Current.Session["ConsumableTypeID"] != null)
{
consumableItemTypeID = Convert.ToInt32(System.Web.HttpContext.Current.Session["ConsumableTypeID"].ToString());
}
// int.TryParse(System.Web.HttpContext.Current.Session["ConsumableTypeID"].ToString(), out consumableItemTypeID);
DataTable dataTable = _iMGR.FindItems(prefixText, null, null, DateTime.Now, false);
List <Items> custItem = new List <Items>();
//string[] custItem = new string[dataTable.Rows.Count+1];
int i = 0;
foreach (DataRow theRow in dataTable.Rows)//.Select("ItemTypeName <> 'Consumables'"))
{
Items item = new Items();
item.ItemId = (int)theRow["ItemID"];
item.ItemName = (string)theRow["ItemName"];
custItem.Add(item);
}
return(custItem);
}
public static List <string> SearchConsumableItems(string prefixText, int count)
{
List <string> ar = new List <string>();
int consumableItemTypeID = -1;
int.TryParse(System.Web.HttpContext.Current.Session["ConsumableTypeID"].ToString(), out consumableItemTypeID);
DateTime issueDate = DateTime.Now;
DateTime.TryParse(System.Web.HttpContext.Current.Session["SelectedDate"].ToString(), out issueDate);
int?SCMFlag = null;
if (System.Web.HttpContext.Current.Session["SCMModule"] != null)
{
SCMFlag = 1;
}
IItemMaster _iMGR = (IItemMaster)ObjectFactory.CreateInstance("BusinessProcess.Administration.BItemMaster, BusinessProcess.Administration");
//DataTable dataTable = _iMGR.FindItems(prefixText, consumableItemTypeID, null, DateTime.Parse(issueDate.ToString("yyyy-MM-dd")), false);
DataTable dataTable = _iMGR.FindItems(prefixText, consumableItemTypeID, null, DateTime.Parse(issueDate.ToString("dd-MMM-yyyy")), false, SCMFlag); //Bug ID 158...
string custItem = string.Empty;
foreach (DataRow theRow in dataTable.Rows)
{
custItem = AutoCompleteExtender.CreateAutoCompleteItem(theRow["ItemName"].ToString(), String.Format("{0};{1};{2}", theRow["ItemID"], theRow["ItemTypeID"], theRow["SellingPrice"]));
ar.Add(custItem);
}
return(ar);
}
public static List <string> SearchItems(string prefixText, int count)
{
List <string> ar = new List <string>();
IItemMaster itemManager = (IItemMaster)ObjectFactory.CreateInstance("BusinessProcess.Administration.BItemMaster, BusinessProcess.Administration");
//filling data from database
int excludeItemID = -1; //exclude billables
int.TryParse(System.Web.HttpContext.Current.Session["MainItemType"].ToString(), out excludeItemID);
int?filterItemID = null;
if (System.Web.HttpContext.Current.Session["SearchContextKey"].ToString() != "")
{
filterItemID = Convert.ToInt32(System.Web.HttpContext.Current.Session["SearchContextKey"].ToString());
}
else
{
return(ar);
}
DataTable dataTable = itemManager.FindItems(prefixText, filterItemID, excludeItemID, null, false);
string custItem = string.Empty;
foreach (DataRow theRow in dataTable.Select("ItemTypeName <> 'Billables'")) // double check to remove billables
{
custItem = AutoCompleteExtender.CreateAutoCompleteItem(theRow[1].ToString(),
String.Format("{0};{1};{2}", theRow["ItemID"], theRow["ItemTypeID"], theRow["ItemTypeName"]));
//theRow[0], theRow[2], theRow[3]));
ar.Add(custItem);
}
return(ar);
}
