public List <MenuViewModel> GetUserMenus(string roleId)
{
List <MenuViewModel> UserMenus = new List <MenuViewModel>();
try
{
DataSet ds;
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
string query = "select menus.* from userclaims join menus on userclaims.MenuId = menus.MenuId where RoleId =" + roleId + "";
ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count > 0)
{
UserMenus = (from row in ds.Tables[0].AsEnumerable()
select new MenuViewModel
{
Name = Convert.ToString(row["Name"]),
Action = Convert.ToString(row["Action"]),
Controller = Convert.ToString(row["Controller"]),
Childmenus = Convert.ToString(row["Childmenus"]),
Parent = Convert.ToString(row["Parent"]),
Icon = Convert.ToString(row["Icon"]),
Parenticon = Convert.ToString(row["Parenticon"])
}).ToList();
}
}
catch (Exception ex)
{
}
return(UserMenus);
}
public List <ItemNumDescriptionViewModel> GetItemNameDescriptionByItemNumOrDescription(string ItemNum = "", string ItemDescription = "", string OperationType = "Contains")
{
List <ItemNumDescriptionViewModel> itemList = new List <ItemNumDescriptionViewModel>();
try
{
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
DataSet ds = new DataSet();
string query = "";
if (OperationType == "Contains")
{
query = "select REPLACE(Itemnum, '\n', '')Itemnum, Description from items where Itemnum =" + ItemNum + " union all select REPLACE(Itemnum, '\n', '')Itemnum, Description from items where Itemnum like '%" + ItemNum + "%' and Itemnum !=" + ItemNum + " limit 10";
ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count == 0)
{
query = "select REPLACE(Itemnum, '\n', '')Itemnum, Description from items where description like '%" + ItemDescription + "%' ORDER BY itemnum DESC limit 10";
}
}
else
{
query = "select REPLACE(Itemnum, '\n', '')Itemnum, Description from items where Itemnum =" + ItemNum + " union all select REPLACE(Itemnum, '\n', '')Itemnum, Description from items where Itemnum like '" + ItemNum + "%' and Itemnum !=" + ItemNum + " limit 10";
ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count == 0)
{
query = "select REPLACE(Itemnum, '\n', '')Itemnum, Description from items where description like '" + ItemDescription + "%' ORDER BY itemnum DESC limit 10";
}
}
ds = dbfunction.GetDataset(query);
itemList = (from row in ds.Tables[0].AsEnumerable()
select new ItemNumDescriptionViewModel
{
Itemnum = Regex.Replace(Convert.ToString(row["Itemnum"]), @"\t|\n|\r", ""),
Description = Regex.Replace(Convert.ToString(row["Description"]), @"\t|\n|\r", "")
}).ToList();
}
catch (Exception ex)
{
}
return(itemList);
}
public List <String> GetItemNums()
{
List <String> itemList = new List <String>();
try
{
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
DataSet ds = new DataSet();
string query = "select REPLACE(Itemnum, '\n', '')Itemnum, Description from items ORDER BY itemnum DESC";
ds = dbfunction.GetDataset(query);
itemList = (from row in ds.Tables[0].AsEnumerable()
select Regex.Replace(Convert.ToString(row["Itemnum"]), @"\t|\n|\r", "")
).ToList();
}
catch (Exception ex)
{
}
return(itemList);
}
public ItemViewModel GetNextItemDetailByItemNumOrDescription(string ItemNum = "", bool IsNext = true)
{
ItemViewModel model = new ItemViewModel();
try
{
DataSet ds;
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
List <string> ItemNums = GetItemNums();
for (int i = 0; i < ItemNums.Count; i++)
{
if (ItemNums[i] == ItemNum)
{
if (IsNext)
{
model.Itemnum = ItemNums[i + 1];
}
else
{
model.Itemnum = ItemNums[i - 1];
}
i = ItemNums.Count;
break;
}
}
string query = "select * from items where REPLACE(Itemnum, '\n', '') = '" + model.Itemnum + "'";
ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count > 0)
{
var row = ds.Tables[0].Rows[0];
model.Category = Convert.ToString(row["Category"]);
model.Itemnum = Convert.ToString(row["Itemnum"]);
model.Itemnum = Regex.Replace(model.Itemnum, @"\t|\n|\r", "");
model.Description = Convert.ToString(row["Description"]);
model.Description = Regex.Replace(model.Description, @"\t|\n|\r", "");
model.Class = Convert.ToString(row["Class"]);
model.Landedcost = Convert.ToString(row["Landedcost"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Landedcost"]);
model.Cost = Convert.ToString(row["Cost"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Cost"]);
model.Min1 = Convert.ToString(row["Min1"]) == "" ? (int?)null : Convert.ToInt32(row["Min1"]);
model.Price1 = Convert.ToString(row["Price1"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Price1"]);
model.Min2 = Convert.ToString(row["Min2"]) == "" ? (int?)null : Convert.ToInt32(row["Min2"]);
model.Price2 = Convert.ToString(row["Price2"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Price2"]);
model.Min3 = Convert.ToString(row["Min3"]) == "" ? (int?)null : Convert.ToInt32(row["Min3"]);
model.Price3 = Convert.ToString(row["Price3"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Price3"]);
model.Onhand = Convert.ToString(row["Onhand"]) == "" ? (int?)null : Convert.ToInt32(row["Onhand"]);
model.Commited = Convert.ToString(row["Commited"]) == "" ? (int?)null : Convert.ToInt32(row["Commited"]);
model.Onorder = Convert.ToString(row["Onorder"]) == "" ? (int?)null : Convert.ToInt32(row["Onorder"]);
model.Onwater = Convert.ToString(row["Onwater"]) == "" ? (int?)null : Convert.ToInt32(row["Onwater"]);
model.Ytdsold = Convert.ToString(row["Ytdsold"]) == "" ? (int?)null : Convert.ToInt32(row["Ytdsold"]);
model.Ytdsales = Convert.ToString(row["Ytdsales"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Ytdsales"]);
model.Lysold = Convert.ToString(row["Lysold"]) == "" ? (int?)null : Convert.ToInt32(row["Lysold"]);
model.Lysales = Convert.ToString(row["Lysales"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Lysales"]);
model.Upc = Convert.ToString(row["Upc"]);
model.Size = Convert.ToString(row["Size"]);
model.Selectioncode = Convert.ToString(row["Selectioncode"]);
model.Selectiondesc = Convert.ToString(row["Selectiondesc"]);
model.PatternCode = Convert.ToString(row["PatternCode"]);
model.PatternDesc = Convert.ToString(row["PatternDesc"]);
model.UsageCode = Convert.ToString(row["UsageCode"]);
model.UsageDesc = Convert.ToString(row["UsageDesc"]);
model.Vendor = Convert.ToString(row["Vendor"]);
model.Vendorcode = Convert.ToString(row["Vendorcode"]);
model.Pforeign = Convert.ToString(row["Cost"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Pforeign"]);
model.Weight = Convert.ToString(row["Cost"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Weight"]);
model.Defectivecount = Convert.ToString(row["Defectivecount"]) == "" ? (int?)null : Convert.ToInt32(row["Defectivecount"]);
model.Costprev = Convert.ToString(row["Costprev"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Costprev"]);
model.Listprev = Convert.ToString(row["Listprev"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Listprev"]);
model.Pack = Convert.ToString(row["Pack"]) == "" ? (int?)null : Convert.ToInt32(row["Pack"]);
model.Casepack = Convert.ToString(row["Casepack"]) == "" ? (int?)null : Convert.ToInt32(row["Casepack"]);
model.Innerpack = Convert.ToString(row["Casepack"]) == "" ? (int?)null : Convert.ToInt32(row["Innerpack"]);
model.X = Convert.ToString(row["X"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["X"]);
model.Y = Convert.ToString(row["Y"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Y"]);
model.Z = Convert.ToString(row["Z"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Z"]);
model.CF = Convert.ToString(row["CF"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["CF"]);
model.Xi = Convert.ToString(row["Xi"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Xi"]);
model.Yi = Convert.ToString(row["Yi"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Yi"]);
model.Zi = Convert.ToString(row["Zi"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Zi"]);
model.C1 = Convert.ToString(row["C1"]) == "" ? (int?)null : Convert.ToInt32(row["C1"]);
if (row["Ship1"] != null)
{
model.Ship1 = Convert.ToString(row["Ship1"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["Ship1"]);
}
if (row["Eta1"] != null)
{
model.Eta1 = Convert.ToString(row["Eta1"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["Eta1"]);
}
model.C2 = Convert.ToInt32(row["C2"]);
if (row["Ship2"] != null)
{
model.Ship2 = Convert.ToString(row["Ship2"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["Ship2"]);
}
if (row["Eta2"] != null)
{
model.Eta2 = Convert.ToString(row["Eta2"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["Eta2"]);
}
model.C3 = Convert.ToString(row["C3"]) == "" ? (int?)null : Convert.ToInt32(row["C3"]);
if (row["Ship3"] != null)
{
model.Ship3 = Convert.ToString(row["Ship3"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["Ship3"]);
}
if (row["Eta3"] != null)
{
model.Eta3 = Convert.ToString(row["Eta3"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["Eta3"]);
}
model.Origin = Convert.ToString(row["Origin"]);
model.Deptnum = Convert.ToString(row["Deptnum"]);
model.Deptname = Convert.ToString(row["Deptname"]);
model.Buyer = Convert.ToString(row["Buyer"]);
model.Volume = Convert.ToString(row["Volume"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Volume"]);
model.Available = Convert.ToString(row["Available"]) == "" ? (double?)null : Convert.ToDouble(row["Available"]);
if (row["Createdon"] != null)
{
model.Createdon = Convert.ToDateTime(row["Createdon"]);
}
model.Deleted = Convert.ToInt32(row["Deleted"]);
model.Proposal = Convert.ToString(row["Proposal"]);
model.ItemLength = Convert.ToString(row["ItemLength"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["ItemLength"]);
model.ItemWidth = Convert.ToString(row["ItemWidth"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["ItemWidth"]);
model.ItemHeight = Convert.ToString(row["ItemHeight"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["ItemHeight"]);
model.MaterialCode = Convert.ToString(row["MaterialCode"]);
model.MaterialDesc = Convert.ToString(row["MaterialDesc"]);
model.GeneralCode = Convert.ToString(row["GeneralCode"]);
model.GeneralDesc = Convert.ToString(row["GeneralDesc"]);
model.CaseLength = Convert.ToString(row["CaseLength"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["CaseLength"]);
model.CaseWidth = Convert.ToString(row["CaseWidth"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["CaseWidth"]);
model.BoxLength = Convert.ToString(row["BoxLength"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["BoxLength"]);
model.BoxWidth = Convert.ToString(row["BoxWidth"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["BoxWidth"]);
model.BoxHeight = Convert.ToString(row["BoxHeight"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["BoxHeight"]);
model.Qrsselcode = Convert.ToString(row["Qrsselcode"]);
model.Qrsseldesc = Convert.ToString(row["Qrsseldesc"]);
query = "select * from items where REPLACE(Itemnum, '\n', '') = '" + model.Itemnum + "' and ( ISNULL(`HEANDB`.`items`.`deletedon`) AND ((`HEANDB`.`items`.`category` BETWEEN 3 AND 6) OR (`HEANDB`.`items`.`category` = 13)) AND ((`HEANDB`.`items`.`onorder` > 0) OR (`HEANDB`.`items`.`onwater` > 0) OR (`HEANDB`.`items`.`onhand` > 50) OR ((`HEANDB`.`items`.`onhand` > 9) AND (`HEANDB`.`items`.`hasLocation` = 1)) OR (`HEANDB`.`items`.`generalCode` = _latin1'NEW') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSN') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSI') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSL') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSF')) AND (`HEANDB`.`items`.`generalCode` <> _latin1'EXL') AND (`HEANDB`.`items`.`generalCode` <> _latin1'TRE') AND (`HEANDB`.`items`.`generalCode` <> _latin1'CON') AND (`HEANDB`.`items`.`itemnum` REGEXP _latin1'^[0-9]') AND (`HEANDB`.`items`.`price1` > 0) AND (COALESCE(`HEANDB`.`items`.`usageCode`,_latin1'') <> _latin1'') AND (COALESCE(`HEANDB`.`items`.`patternCode`,_latin1'') <> _latin1'') AND (`HEANDB`.`items`.`hasPhoto` = 1) AND (`HEANDB`.`items`.`factoryPhoto` = 0 ) ) ";
ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count > 0)
{
model.RulePassed = "1";
}
else
{
model.RulePassed = "0";
}
}
}
catch (Exception ex)
{
}
return(model);
}
public ItemViewModel GetItemDetailByItemNumOrDescription(string ItemNum = "", string ItemDescription = "")
{
ItemViewModel model = new ItemViewModel();
try
{
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
string query = "";
if (ItemNum != "")
{
query = "select * from items where REPLACE(Itemnum, '\n', '') = '" + ItemNum + "' ";
}
else if (ItemDescription != "")
{
query = "select * from items where description = '" + ItemDescription + "' ";
}
else
{
query = "select * from items ORDER BY itemnum DESC limit 1 ";
}
DataSet ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count > 0)
{
var row = ds.Tables[0].Rows[0];
model.Category = Convert.ToString(row["category"]);
model.Itemnum = Convert.ToString(row["itemnum"]);
model.Itemnum = Regex.Replace(model.Itemnum, @"\t|\n|\r", "");
model.Description = Convert.ToString(row["description"]);
model.Description = Regex.Replace(model.Description, @"\t|\n|\r", "");
model.Class = Convert.ToString(row["class"]);
model.Landedcost = Convert.ToString(row["landedcost"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["landedcost"]);
model.Cost = Convert.ToString(row["cost"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["cost"]);
model.Min1 = Convert.ToString(row["min1"]) == "" ? (int?)null : Convert.ToInt32(row["min1"]);
model.Price1 = Convert.ToString(row["price1"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["price1"]);
model.Min2 = Convert.ToString(row["min2"]) == "" ? (int?)null : Convert.ToInt32(row["min2"]);
model.Price2 = Convert.ToString(row["price2"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["price2"]);
model.Min3 = Convert.ToString(row["min3"]) == "" ? (int?)null : Convert.ToInt32(row["min3"]);
model.Price3 = Convert.ToString(row["price3"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["price3"]);
model.Onhand = Convert.ToString(row["onhand"]) == "" ? (int?)null : Convert.ToInt32(row["onhand"]);
model.Commited = Convert.ToString(row["commited"]) == "" ? (int?)null : Convert.ToInt32(row["commited"]);
model.Onorder = Convert.ToString(row["onorder"]) == "" ? (int?)null : Convert.ToInt32(row["onorder"]);
model.Onwater = Convert.ToString(row["Onwater"]) == "" ? (int?)null : Convert.ToInt32(row["Onwater"]);
model.Ytdsold = Convert.ToString(row["ytdsold"]) == "" ? (int?)null : Convert.ToInt32(row["ytdsold"]);
model.Ytdsales = Convert.ToString(row["ytdsales"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["ytdsales"]);
model.Lysold = Convert.ToString(row["lysold"]) == "" ? (int?)null : Convert.ToInt32(row["lysold"]);
model.Lysales = Convert.ToString(row["lysales"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["lysales"]);
model.Upc = Convert.ToString(row["upc"]);
model.Size = Convert.ToString(row["size"]);
model.Selectioncode = Convert.ToString(row["selectioncode"]);
model.Selectiondesc = Convert.ToString(row["selectiondesc"]);
model.PatternCode = Convert.ToString(row["patternCode"]);
model.PatternDesc = Convert.ToString(row["patternDesc"]);
model.UsageCode = Convert.ToString(row["usageCode"]);
model.UsageDesc = Convert.ToString(row["usageDesc"]);
model.Vendor = Convert.ToString(row["vendor"]);
model.Vendorcode = Convert.ToString(row["vendorcode"]);
model.Pforeign = Convert.ToString(row["pforeign"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["pforeign"]);
model.Weight = Convert.ToString(row["weight"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["weight"]);
model.Defectivecount = Convert.ToString(row["defectivecount"]) == "" ? (int?)null : Convert.ToInt32(row["defectivecount"]);
model.Costprev = Convert.ToString(row["costprev"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["costprev"]);
model.Listprev = Convert.ToString(row["listprev"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["listprev"]);
model.Pack = Convert.ToString(row["pack"]) == "" ? (int?)null : Convert.ToInt32(row["pack"]);
model.Casepack = Convert.ToString(row["casepack"]) == "" ? (int?)null : Convert.ToInt32(row["casepack"]);
model.Innerpack = Convert.ToString(row["innerpack"]) == "" ? (int?)null : Convert.ToInt32(row["innerpack"]);
model.X = Convert.ToString(row["X"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["X"]);
model.Y = Convert.ToString(row["Y"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Y"]);
model.Z = Convert.ToString(row["Z"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["Z"]);
model.CF = Convert.ToString(row["CF"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["CF"]);
model.Xi = Convert.ToString(row["xi"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["xi"]);
model.Yi = Convert.ToString(row["yi"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["yi"]);
model.Zi = Convert.ToString(row["zi"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["zi"]);
model.C1 = Convert.ToString(row["C1"]) == "" ? (int?)null : Convert.ToInt32(row["C1"]);
if (row["ship1"] != null)
{
model.Ship1 = Convert.ToString(row["ship1"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["ship1"]);
}
if (row["eta1"] != null)
{
model.Eta1 = Convert.ToString(row["eta1"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["eta1"]);
}
model.C2 = Convert.ToString(row["c2"]) == "" ? (Int32?)null : Convert.ToInt32(row["c2"]);
if (row["ship2"] != null)
{
model.Ship2 = Convert.ToString(row["ship2"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["ship2"]);
}
if (row["eta2"] != null)
{
model.Eta2 = Convert.ToString(row["eta2"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["eta2"]);
}
model.C3 = Convert.ToString(row["c3"]) == "" ? (int?)null : Convert.ToInt32(row["c3"]);
if (row["ship3"] != null)
{
model.Ship3 = Convert.ToString(row["ship3"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["ship3"]);
}
if (row["eta3"] != null)
{
model.Eta3 = Convert.ToString(row["eta3"]) == "" ? (DateTime?)null : Convert.ToDateTime(row["eta3"]);
}
model.Origin = Convert.ToString(row["origin"]);
model.Deptnum = Convert.ToString(row["deptnum"]);
model.Deptname = Convert.ToString(row["deptname"]);
model.Buyer = Convert.ToString(row["buyer"]);
model.Volume = Convert.ToString(row["volume"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["volume"]);
model.Available = Convert.ToString(row["available"]) == "" ? (double?)null : Convert.ToDouble(row["available"]);
if (row["createdon"] != null)
{
model.Createdon = Convert.ToDateTime(row["createdon"]);
}
model.Deleted = Convert.ToString(row["deleted"]) == "" ? 0 : Convert.ToInt32(row["deleted"]);
model.Proposal = Convert.ToString(row["proposal"]);
model.ItemLength = Convert.ToString(row["itemLength"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["itemLength"]);
model.ItemWidth = Convert.ToString(row["itemWidth"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["itemWidth"]);
model.ItemHeight = Convert.ToString(row["itemHeight"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["itemHeight"]);
model.MaterialCode = Convert.ToString(row["materialCode"]);
model.MaterialDesc = Convert.ToString(row["materialDesc"]);
model.GeneralCode = Convert.ToString(row["generalCode"]);
model.GeneralDesc = Convert.ToString(row["generalDesc"]);
model.CaseLength = Convert.ToString(row["caseLength"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["caseLength"]);
model.CaseWidth = Convert.ToString(row["caseWidth"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["caseWidth"]);
model.Casepack = Convert.ToString(row["caseWidth"]) == "" ? (Int32?)null : Convert.ToInt32(row["caseWidth"]);
model.BoxLength = Convert.ToString(row["boxLength"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["boxLength"]);
model.BoxWidth = Convert.ToString(row["boxWidth"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["boxWidth"]);
model.BoxHeight = Convert.ToString(row["boxHeight"]) == "" ? (Decimal?)null : Convert.ToDecimal(row["boxHeight"]);
//model.Qrsselcode = Convert.ToString(row["qrsselcode"]);
//model.Qrsseldesc = Convert.ToString(row["qrsseldesc"]);
if (ItemNum != "")
{
query = "select * from items where REPLACE(Itemnum, '\n', '') = '" + ItemNum + "' and ( ISNULL(`HEANDB`.`items`.`deletedon`) AND ((`HEANDB`.`items`.`category` BETWEEN 3 AND 6) OR (`HEANDB`.`items`.`category` = 13)) AND ((`HEANDB`.`items`.`onorder` > 0) OR (`HEANDB`.`items`.`onwater` > 0) OR (`HEANDB`.`items`.`onhand` > 50) OR ((`HEANDB`.`items`.`onhand` > 9) AND (`HEANDB`.`items`.`hasLocation` = 1)) OR (`HEANDB`.`items`.`generalCode` = _latin1'NEW') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSN') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSI') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSL') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSF')) AND (`HEANDB`.`items`.`generalCode` <> _latin1'EXL') AND (`HEANDB`.`items`.`generalCode` <> _latin1'TRE') AND (`HEANDB`.`items`.`generalCode` <> _latin1'CON') AND (`HEANDB`.`items`.`itemnum` REGEXP _latin1'^[0-9]') AND (`HEANDB`.`items`.`price1` > 0) AND (COALESCE(`HEANDB`.`items`.`usageCode`,_latin1'') <> _latin1'') AND (COALESCE(`HEANDB`.`items`.`patternCode`,_latin1'') <> _latin1'') AND (`HEANDB`.`items`.`hasPhoto` = 1) AND (`HEANDB`.`items`.`factoryPhoto` = 0 ) ) ";
}
else if (ItemDescription != "")
{
query = "select * from items where description = '" + ItemDescription + "' ( ISNULL(`HEANDB`.`items`.`deletedon`) AND ((`HEANDB`.`items`.`category` BETWEEN 3 AND 6) OR (`HEANDB`.`items`.`category` = 13)) AND ((`HEANDB`.`items`.`onorder` > 0) OR (`HEANDB`.`items`.`onwater` > 0) OR (`HEANDB`.`items`.`onhand` > 50) OR ((`HEANDB`.`items`.`onhand` > 9) AND (`HEANDB`.`items`.`hasLocation` = 1)) OR (`HEANDB`.`items`.`generalCode` = _latin1'NEW') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSN') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSI') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSL') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSF')) AND (`HEANDB`.`items`.`generalCode` <> _latin1'EXL') AND (`HEANDB`.`items`.`generalCode` <> _latin1'TRE') AND (`HEANDB`.`items`.`generalCode` <> _latin1'CON') AND (`HEANDB`.`items`.`itemnum` REGEXP _latin1'^[0-9]') AND (`HEANDB`.`items`.`price1` > 0) AND (COALESCE(`HEANDB`.`items`.`usageCode`,_latin1'') <> _latin1'') AND (COALESCE(`HEANDB`.`items`.`patternCode`,_latin1'') <> _latin1'') AND (`HEANDB`.`items`.`hasPhoto` = 1) AND (`HEANDB`.`items`.`factoryPhoto` = 0 ) ) ";
}
else
{
query = "select * from items where ( ISNULL(`HEANDB`.`items`.`deletedon`) AND ((`HEANDB`.`items`.`category` BETWEEN 3 AND 6) OR (`HEANDB`.`items`.`category` = 13)) AND ((`HEANDB`.`items`.`onorder` > 0) OR (`HEANDB`.`items`.`onwater` > 0) OR (`HEANDB`.`items`.`onhand` > 50) OR ((`HEANDB`.`items`.`onhand` > 9) AND (`HEANDB`.`items`.`hasLocation` = 1)) OR (`HEANDB`.`items`.`generalCode` = _latin1'NEW') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSN') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSI') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSL') OR (`HEANDB`.`items`.`generalCode` = _latin1'SSF')) AND (`HEANDB`.`items`.`generalCode` <> _latin1'EXL') AND (`HEANDB`.`items`.`generalCode` <> _latin1'TRE') AND (`HEANDB`.`items`.`generalCode` <> _latin1'CON') AND (`HEANDB`.`items`.`itemnum` REGEXP _latin1'^[0-9]') AND (`HEANDB`.`items`.`price1` > 0) AND (COALESCE(`HEANDB`.`items`.`usageCode`,_latin1'') <> _latin1'') AND (COALESCE(`HEANDB`.`items`.`patternCode`,_latin1'') <> _latin1'') AND (`HEANDB`.`items`.`hasPhoto` = 1) AND (`HEANDB`.`items`.`factoryPhoto` = 0 ) ) ORDER BY itemnum DESC limit 1 ";
}
ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count > 0)
{
model.RulePassed = "1";
}
else
{
model.RulePassed = "0";
}
}
}
catch (Exception ex)
{
}
return(model);
}