private void ImportProductPrice(Guid productId, StockCodeRec oRec)
{
ImportProductPrice(productId, ProductHelper.Prices.BASPRC.ToString(), "HKD", oRec.BASPRC);
ImportProductPrice(productId, ProductHelper.Prices.ORIPRC.ToString(), "HKD", "0");
ImportProductPrice(productId, ProductHelper.Prices.VPRC.ToString(), oRec.VCURR, oRec.VPRC);
ImportProductPrice(productId, ProductHelper.Prices.WHLPRC.ToString(), "HKD", "0");
}
private void ImportProductBarcode(Guid productId, StockCodeRec oRec)
{
using (var ctx = new EF6.RT2020Entities())
{
StringBuilder barcode = new StringBuilder();
barcode.Append(oRec.PLU); // STK_CODE
barcode.Append(oRec.Season); // Appendix1
barcode.Append(oRec.Color); // Appendix2
barcode.Append(oRec.Size); // Appendix3
//string sql = "ProductId = '" + productId.ToString() + "' AND Barcode = '" + barcode.ToString() + "'";
var oBarcode = ctx.ProductBarcode.Where(x => x.ProductId == productId && x.Barcode == barcode.ToString()).FirstOrDefault();
if (oBarcode == null)
{
oBarcode = new EF6.ProductBarcode();
oBarcode.ProductBarcodeId = Guid.NewGuid();
oBarcode.Barcode = barcode.ToString();
oBarcode.BarcodeType = "INTER";
oBarcode.PrimaryBarcode = true;
oBarcode.DownloadToPOS = chkSetRetailItem.Checked;
ctx.ProductBarcode.Add(oBarcode);
ctx.SaveChanges();
}
}
}
private Guid ImportProduct(StockCodeRec oRec)
{
Guid result = Guid.Empty;
StringBuilder productWhereClause = new StringBuilder();
productWhereClause.Append(" STKCODE = '").Append(oRec.PLU).Append("' ");
productWhereClause.Append(" AND APPENDIX1 = '").Append(oRec.Season).Append("' ");
productWhereClause.Append(" AND APPENDIX2 = '").Append(oRec.Color).Append("' ");
productWhereClause.Append(" AND APPENDIX3 = '").Append(oRec.Size).Append("' ");
productWhereClause.Append(" AND CLASS1 = '").Append(oRec.Vendor).Append("' ");
productWhereClause.Append(" AND CLASS2 = '").Append(oRec.Gender).Append("' ");
productWhereClause.Append(" AND CLASS3 = '").Append(oRec.Collection).Append("' ");
productWhereClause.Append(" AND CLASS4 = '").Append(oRec.Group).Append("' ");
productWhereClause.Append(" AND CLASS5 = '").Append(oRec.Category).Append("' ");
productWhereClause.Append(" AND CLASS6 = '").Append(oRec.SubCat).Append("' ");
using (var ctx = new EF6.RT2020Entities())
{
var oItem = ctx.Product.SqlQuery(string.Format("Select * from Product where {0}", productWhereClause.ToString())).FirstOrDefault();
if (oItem == null)
{
oItem = new EF6.Product();
oItem.ProductId = Guid.NewGuid();
oItem.STKCODE = oRec.PLU;
oItem.APPENDIX1 = oRec.Season;
oItem.APPENDIX2 = oRec.Color;
oItem.APPENDIX3 = oRec.Size;
oItem.CLASS1 = oRec.Vendor;
oItem.CLASS2 = oRec.Gender;
oItem.CLASS3 = oRec.Collection;
oItem.CLASS4 = oRec.Group;
oItem.CLASS5 = oRec.Category;
oItem.CLASS6 = oRec.SubCat;
oItem.ProductName = oRec.Description;
oItem.RetailPrice = Convert.ToDecimal(oRec.BASPRC);
oItem.DownloadToPOS = chkSetRetailItem.Checked;
//oItem.NatureId = System.Guid.Empty;
oItem.CreatedBy = ConfigHelper.CurrentUserId;
oItem.CreatedOn = DateTime.Now;
ctx.Product.Add(oItem);
}
oItem.ModifiedBy = ConfigHelper.CurrentUserId;
oItem.ModifiedOn = DateTime.Now;
ctx.SaveChanges();
result = oItem.ProductId;
}
return(result);
}
private void ImportProductSupplement(Guid productId, StockCodeRec oRec)
{
using (var ctx = new EF6.RT2020Entities())
{
//string sql = "ProductId = '" + productId.ToString() + "' AND VendorCurrencyCode = '" + oRec.VCURR + "'";
var oProdSupp = ctx.ProductSupplement.Where(x => x.ProductId == productId && x.VendorCurrencyCode == oRec.VCURR).FirstOrDefault();
if (oProdSupp == null)
{
oProdSupp = new EF6.ProductSupplement();
oProdSupp.SupplementId = Guid.NewGuid();
oProdSupp.ProductId = productId;
oProdSupp.VendorCurrencyCode = oRec.VCURR;
oProdSupp.VendorPrice = Convert.ToDecimal(oRec.VPRC);
ctx.ProductSupplement.Add(oProdSupp);
ctx.SaveChanges();
}
}
}
private void ImportProductRemarks(Guid productId, StockCodeRec oRec)
{
using (var ctx = new EF6.RT2020Entities())
{
string sql = "ProductId = '" + productId.ToString() + "'";
var oRemarks = ctx.ProductRemarks.Where(x => x.ProductId == productId).FirstOrDefault();
if (oRemarks == null)
{
oRemarks = new EF6.ProductRemarks();
oRemarks.ProductRemarksId = Guid.NewGuid();
oRemarks.ProductId = productId;
oRemarks.Photo = oRec.PhotoPath;
oRemarks.Notes = oRec.STK_MEMO;
oRemarks.DownloadToShop = chkSetRetailItem.Checked;
ctx.ProductRemarks.Add(oRemarks);
ctx.SaveChanges();
}
}
}
