public static POSItem Search(string itemBarcode, string locationCode, bool isKitOrder, int isFirstOrder, ref string dbMessage)
{
try
{
POSItem item = null;
DBParameterList dbParamList = new DBParameterList();
List <POSItem> itemList = new List <POSItem>();
dbParamList.Add(new DBParameter("@itemBarcode", itemBarcode, DbType.String));
dbParamList.Add(new DBParameter("@inputParam", locationCode, DbType.String));
dbParamList.Add(new DBParameter("@isKitOrder", isKitOrder, DbType.Boolean));
dbParamList.Add(new DBParameter("@isFirstOrder", isFirstOrder, DbType.Int32));
dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH));
using (DataTaskManager dtManager = new DataTaskManager())
{
DataSet ds = dtManager.ExecuteDataSet(SP_BarcodeItems_Search, dbParamList);
if (ds != null)
{
DataRow[] rows = ds.Tables[0].Select();
item = CreateItem(rows[0]);
}
}
return(item);
}
catch (Exception ex)
{
throw ex;
}
}
private static void AddHierarchyChildren(POSItem item, DataSet ds, DataTable dt, int max)
{
DataRow[] rows = dt.Select("ParentId=" + item.Id);
if (rows.Length == 0)
{
if (item.Level == max)
{
//ADD ITEMS HERE
AddItemChildrem(item, ds.Tables[2]);
}
}
else
{
for (int i = 0; i < rows.Length; i++)
{
//ADD HIERARCHIES - CHILDREN
POSItem item1 = CreateItem(rows[i]);
AddHierarchyChildren(item1, ds, ds.Tables[1], max);
if (item1.POSItems.Count > 0)
{
item.POSItems.Add(item1);
}
}
}
}
private static void AddItemChildrem(POSItem item, DataTable dataTable)
{
DataRow[] rows = dataTable.Select("ParentId = " + item.Id);
for (int i = 0; i < rows.Length; i++)
{
POSItem item1 = CreateItem(rows[i]);
item.POSItems.Add(item1);
}
}
public static List <POSItem> Search(string locationCode, bool isKitOrder, int isFirstOrder, ref string dbMessage)
{
try
{
DBParameterList dbParamList = new DBParameterList();
List <POSItem> itemList = new List <POSItem>();
dbParamList.Add(new DBParameter("@inputParam", locationCode, DbType.String));
dbParamList.Add(new DBParameter("@isKitOrder", isKitOrder, DbType.Boolean));
dbParamList.Add(new DBParameter("@isFirstOrder", isFirstOrder, DbType.Int32));
dbParamList.Add(new DBParameter("@forSkinCareItem", Common.ForSkinCareItem, DbType.Boolean));
dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH));
using (DataTaskManager dtManager = new DataTaskManager())
{
DataSet ds = dtManager.ExecuteDataSet(SP_ITEMS_SEARCH, dbParamList);
if (ds != null)
{
if (ds.Tables.Count > 2)
{
int min = Convert.ToInt32(ds.Tables[0].Rows[0]["Min"]);
int max = Convert.ToInt32(ds.Tables[0].Rows[0]["Max"]);
DataRow[] rows = ds.Tables[1].Select("Level = " + min);
for (int i = 0; i < rows.Length; i++)
{
POSItem item = CreateItem(rows[i]);
AddHierarchyChildren(item, ds, ds.Tables[1], max);
if (item.POSItems.Count > 0)
{
itemList.Add(item);
}
}
}
}
}
return(itemList);
}
catch (Exception ex)
{
throw ex;
}
}
