public List<Maticsoft.Model.Shop.Products.SKUInfo> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.Shop.Products.SKUInfo> list = new List<Maticsoft.Model.Shop.Products.SKUInfo>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Model.Shop.Products.SKUInfo item = new Maticsoft.Model.Shop.Products.SKUInfo();
if ((dt.Rows[i]["SkuId"] != null) && (dt.Rows[i]["SkuId"].ToString() != ""))
{
item.SkuId = long.Parse(dt.Rows[i]["SkuId"].ToString());
}
if ((dt.Rows[i]["ProductId"] != null) && (dt.Rows[i]["ProductId"].ToString() != ""))
{
item.ProductId = long.Parse(dt.Rows[i]["ProductId"].ToString());
}
if ((dt.Rows[i]["SKU"] != null) && (dt.Rows[i]["SKU"].ToString() != ""))
{
item.SKU = dt.Rows[i]["SKU"].ToString();
}
if ((dt.Rows[i]["Weight"] != null) && (dt.Rows[i]["Weight"].ToString() != ""))
{
item.Weight = new int?(int.Parse(dt.Rows[i]["Weight"].ToString()));
}
if ((dt.Rows[i]["Stock"] != null) && (dt.Rows[i]["Stock"].ToString() != ""))
{
item.Stock = int.Parse(dt.Rows[i]["Stock"].ToString());
}
if ((dt.Rows[i]["AlertStock"] != null) && (dt.Rows[i]["AlertStock"].ToString() != ""))
{
item.AlertStock = int.Parse(dt.Rows[i]["AlertStock"].ToString());
}
if ((dt.Rows[i]["CostPrice"] != null) && (dt.Rows[i]["CostPrice"].ToString() != ""))
{
item.CostPrice = new decimal?(decimal.Parse(dt.Rows[i]["CostPrice"].ToString()));
}
if ((dt.Rows[i]["SalePrice"] != null) && (dt.Rows[i]["SalePrice"].ToString() != ""))
{
item.SalePrice = decimal.Parse(dt.Rows[i]["SalePrice"].ToString());
}
if ((dt.Rows[i]["Upselling"] != null) && (dt.Rows[i]["Upselling"].ToString() != ""))
{
if ((dt.Rows[i]["Upselling"].ToString() == "1") || (dt.Rows[i]["Upselling"].ToString().ToLower() == "true"))
{
item.Upselling = true;
}
else
{
item.Upselling = false;
}
}
list.Add(item);
}
}
return list;
}
private Maticsoft.Model.Shop.Products.SKUInfo GetSKUInfo4Obj(JsonData jsonData)
{
Maticsoft.Model.Shop.Products.SKUInfo info = null;
if (!jsonData.IsObject)
{
return null;
}
info = new Maticsoft.Model.Shop.Products.SKUInfo {
SKU = jsonData["SKU"].ToString()
};
string str = jsonData["CostPrice"].ToString();
if (!string.IsNullOrWhiteSpace(str))
{
info.CostPrice = new decimal?(Globals.SafeDecimal(str, (decimal) -1M));
}
info.SalePrice = Globals.SafeDecimal(jsonData["SalePrice"].ToString(), (decimal) -1M);
this.salePriceList.Add(info.SalePrice);
info.Stock = Globals.SafeInt(jsonData["Stock"].ToString(), -1);
info.AlertStock = Globals.SafeInt(jsonData["AlertStock"].ToString(), -1);
info.Weight = new int?(Globals.SafeInt(jsonData["Weight"].ToString(), -1));
info.Upselling = Globals.SafeBool(jsonData["Upselling"].ToString(), false);
if (jsonData["SKUItems"].IsArray && (jsonData["SKUItems"].Count > 0))
{
foreach (JsonData data in (IEnumerable) jsonData["SKUItems"])
{
string str2 = string.Empty;
if (!string.IsNullOrWhiteSpace(data["ImageUrl"].ToString()))
{
str2 = data["ImageUrl"].ToString().Replace(this.tempFile, this.skuImageFile);
string format = data["ImageUrl"].ToString().Replace(this.tempFile, "");
if (!this.skuImageList.Contains(string.Format(format, "T32X32_")))
{
this.skuImageList.Add(string.Format(format, "T32X32_"));
this.skuImageList.Add(string.Format(format, "T130X130_"));
this.skuImageList.Add(string.Format(format, "T300X390_"));
}
}
Maticsoft.Model.Shop.Products.SKUItem item = new Maticsoft.Model.Shop.Products.SKUItem {
AttributeId = Globals.SafeLong(data["AttributeId"].ToString(), (long) (-1L)),
ValueId = Globals.SafeLong(data["ValueId"].ToString(), (long) (-1L)),
ImageUrl = str2,
ValueStr = data["ValueStr"].ToString()
};
info.SkuItems.Add(item);
}
}
return info;
}
private List<Maticsoft.Model.Shop.Products.SKUInfo> GetSKUInfosData(string where, string orderby, int startIndex, int endIndex, out int dataCount, long productId)
{
Predicate<Maticsoft.Model.Shop.Products.SKUInfo> match = null;
long tmpSkuId;
List<Maticsoft.Model.Shop.Products.SKUInfo> list = new List<Maticsoft.Model.Shop.Products.SKUInfo>();
DataSet ds = this.dal.GetSKUListByPage(where, orderby, startIndex, endIndex, out dataCount, productId);
if (DataSetTools.DataSetIsNull(ds))
{
return null;
}
foreach (DataRow row in ds.Tables[0].Rows)
{
tmpSkuId = row.Field<long>("SkuId");
if (match == null)
{
match = info => info.SkuId == tmpSkuId;
}
Maticsoft.Model.Shop.Products.SKUInfo info = list.Find(match);
if (info == null)
{
info = new Maticsoft.Model.Shop.Products.SKUInfo {
SkuId = tmpSkuId,
ProductId = row.Field<long>("ProductId"),
SKU = row.Field<string>("SKU"),
Weight = row.Field<int?>("Weight"),
Stock = row.Field<int>("Stock"),
AlertStock = row.Field<int>("AlertStock"),
CostPrice = row.Field<decimal?>("CostPrice"),
SalePrice = row.Field<decimal>("SalePrice"),
Upselling = row.Field<bool>("Upselling"),
ProductName = row.Field<string>("ProductName"),
ProductImageUrl = row.Field<string>("ImageUrl"),
ProductThumbnailUrl = row.Field<string>("ThumbnailUrl1")
};
list.Add(info);
}
Maticsoft.Model.Shop.Products.SKUItem item = new Maticsoft.Model.Shop.Products.SKUItem {
AttributeId = row.Field<long>("AttributeId"),
ValueId = row.Field<long>("ValueId"),
ValueStr = row.Field<string>("ValueStr"),
ImageUrl = row.Field<string>("ImageUrl")
};
info.SkuItems.Add(item);
}
List<Maticsoft.Model.Shop.Products.SKUInfo> list2 = new List<Maticsoft.Model.Shop.Products.SKUInfo>();
dataCount = list.Count;
if (dataCount <= (startIndex - 1))
{
return list;
}
for (int i = startIndex - 1; (i < endIndex) && (i < list.Count); i++)
{
list2.Add(list[i]);
}
return list2;
}
public Maticsoft.Model.Shop.Products.SKUInfo GetModelBySKU(string sku)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT TOP 1 SkuId,ProductId,SKU,Weight,Stock,AlertStock,CostPrice,SalePrice,Upselling FROM Shop_SKUs ");
builder.Append(" WHERE SKU=@SKU");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SKU", SqlDbType.NVarChar, 50) };
cmdParms[0].Value = sku;
Maticsoft.Model.Shop.Products.SKUInfo info = new Maticsoft.Model.Shop.Products.SKUInfo();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if ((set.Tables[0].Rows[0]["SkuId"] != null) && (set.Tables[0].Rows[0]["SkuId"].ToString() != ""))
{
info.SkuId = long.Parse(set.Tables[0].Rows[0]["SkuId"].ToString());
}
if ((set.Tables[0].Rows[0]["ProductId"] != null) && (set.Tables[0].Rows[0]["ProductId"].ToString() != ""))
{
info.ProductId = long.Parse(set.Tables[0].Rows[0]["ProductId"].ToString());
}
if ((set.Tables[0].Rows[0]["SKU"] != null) && (set.Tables[0].Rows[0]["SKU"].ToString() != ""))
{
info.SKU = set.Tables[0].Rows[0]["SKU"].ToString();
}
if ((set.Tables[0].Rows[0]["Weight"] != null) && (set.Tables[0].Rows[0]["Weight"].ToString() != ""))
{
info.Weight = new int?(int.Parse(set.Tables[0].Rows[0]["Weight"].ToString()));
}
if ((set.Tables[0].Rows[0]["Stock"] != null) && (set.Tables[0].Rows[0]["Stock"].ToString() != ""))
{
info.Stock = int.Parse(set.Tables[0].Rows[0]["Stock"].ToString());
}
if ((set.Tables[0].Rows[0]["AlertStock"] != null) && (set.Tables[0].Rows[0]["AlertStock"].ToString() != ""))
{
info.AlertStock = int.Parse(set.Tables[0].Rows[0]["AlertStock"].ToString());
}
if ((set.Tables[0].Rows[0]["CostPrice"] != null) && (set.Tables[0].Rows[0]["CostPrice"].ToString() != ""))
{
info.CostPrice = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["CostPrice"].ToString()));
}
if ((set.Tables[0].Rows[0]["SalePrice"] != null) && (set.Tables[0].Rows[0]["SalePrice"].ToString() != ""))
{
info.SalePrice = decimal.Parse(set.Tables[0].Rows[0]["SalePrice"].ToString());
}
if ((set.Tables[0].Rows[0]["Upselling"] != null) && (set.Tables[0].Rows[0]["Upselling"].ToString() != ""))
{
if ((set.Tables[0].Rows[0]["Upselling"].ToString() == "1") || (set.Tables[0].Rows[0]["Upselling"].ToString().ToLower() == "true"))
{
info.Upselling = true;
return info;
}
info.Upselling = false;
}
return info;
}
