protected void popWorkshop_WindowCallback(object source, PopupWindowCallbackArgs e)
{
int workshopId = int.Parse(e.Parameter.Split('|')[1]);
Session["lastWorkshopId"] = workshopId;
var wWorkshop = new DekkOnline.Workshop();
if (workshopId > 0)
{
wWorkshop = (from w in db.Workshop where w.IdWorkshop == workshopId select w).FirstOrDefault();
}
if (e.Parameter.Split('|')[0] == "Load")
{
if (workshopId == 0)
{
txtName.Text = "";
txtAddress.Text = "";
txtPhone.Text = "";
txtEmail.Text = "";
Session["imgOurWorkshopURL"] = "";
popWorkshop.JSProperties.Add("cpImage", "");
}
else
{
txtName.Text = wWorkshop.Name;
txtAddress.Text = wWorkshop.Address;
txtPhone.Text = wWorkshop.Phone;
txtEmail.Text = wWorkshop.Email;
Session["imgOurWorkshopURL"] = wWorkshop.WorkImage == null || wWorkshop.WorkImage == "" ? "" : wWorkshop.WorkImage;
if (wWorkshop.WorkImage != null && wWorkshop.WorkImage.IndexOf("/photos/ourCategories/") == 0)
{
popWorkshop.JSProperties.Add("cpImage", wWorkshop.WorkImage);
}
else
{
popWorkshop.JSProperties.Add("cpImage", wWorkshop.WorkImage == null || wWorkshop.WorkImage == "" ? "" : ConfigurationManager.AppSettings["URLSTORE"] + wWorkshop.WorkImage);
}
}
}
else if (e.Parameter.Split('|')[0] == "Save")
{
wWorkshop.Name = txtName.Text;
wWorkshop.Address = txtAddress.Text;
wWorkshop.Phone = txtPhone.Text;
wWorkshop.Email = txtEmail.Text;
wWorkshop.WorkImage = Session["imgOurWorkshopURL"].ToString();
if (workshopId == 0)
{
wWorkshop.Status = true;
db.Workshop.InsertOnSubmit(wWorkshop);
}
db.SubmitChanges();
}
}
protected void popCategories_WindowCallback(object source, PopupWindowCallbackArgs e)
{
Guid cdpId = Guid.Parse(e.Parameter.Split('|')[1]);
Session["lastCdpId"] = cdpId;
var cCat = (from cdp in db.categoriesDPs where cdp.cdpId == cdpId select cdp).FirstOrDefault();
if (e.Parameter.Split('|')[0] == "Load")
{
txtCategories.Text = cCat.cdpName;
txtDescriptionDP.Text = cCat.cdpDescriptionDP;
txtDescription.Text = cCat.cdpDescription;
Session["imgCategoriesURL"] = cCat.cdpImage;
popCategories.JSProperties.Add("cpImage", cCat.cdpImage);
}
else if (e.Parameter.Split('|')[0] == "Copy")
{
txtDescription.Text = cCat.cdpDescriptionDP;
}
else if (e.Parameter.Split('|')[0] == "Save")
{
cCat.cdpName = txtCategories.Text;
cCat.cdpDescription = txtDescription.Text;
cCat.cdpImage = Session["imgCategoriesURL"].ToString();
cCat.cdpEdited = true;
db.SubmitChanges();
}
}
public static void changeStatusCategories(Guid cdpId)
{
var cCategorie = db.categoriesDPs.Where(c => c.cdpId == cdpId).FirstOrDefault();
cCategorie.cdpStatus = !cCategorie.cdpStatus;
cCategorie.cdpChangeStatus = DateTime.Now;
db.SubmitChanges();
}
protected void popBrands_WindowCallback(object source, PopupWindowCallbackArgs e)
{
Guid braId = Guid.Parse(e.Parameter.Split('|')[1]);
Session["lastBraId"] = braId;
var cBra = (from bra in db.brands where bra.braId == braId select bra).FirstOrDefault();
if (e.Parameter.Split('|')[0] == "Load")
{
txtBrands.Text = cBra.braName;
txtDescriptionDP.Text = "";
txtDescription.Text = cBra.braDescription;
txtCodeDP.Text = cBra.braCodeDP;
txtCode.Text = cBra.braCode;
spPriceP.Text = cBra.braPercent.HasValue == true?cBra.braPercent.Value.ToString() : "";
Session["imgBrandsURL"] = cBra.braImage;
popBrands.JSProperties.Add("cpImage", cBra.braImage);
}
else if (e.Parameter.Split('|')[0] == "Copy")
{
txtDescription.Text = txtCodeDP.Text;
txtCode.Text = cBra.braCodeDP;
}
else if (e.Parameter.Split('|')[0] == "Save")
{
cBra.braName = txtBrands.Text;
cBra.braDescription = txtDescription.Text;
cBra.braCode = txtCode.Text;
cBra.braImage = Session["imgBrandsURL"].ToString();
cBra.braEdited = true;
if (spPriceP.Text != "")
{
cBra.braPercent = int.Parse(spPriceP.Text);
}
else
{
cBra.braPercent = 0;
}
db.SubmitChanges();
}
}
protected void popCategories_WindowCallback(object source, PopupWindowCallbackArgs e)
{
int catId = int.Parse(e.Parameter.Split('|')[1]);
Session["lastCatId"] = catId;
var cCat = new category();
if (catId > 0)
{
cCat = (from cdp in db.categories where cdp.catId == catId select cdp).FirstOrDefault();
}
if (e.Parameter.Split('|')[0] == "Load")
{
if (catId == 0)
{
txtCategories.Text = "";
txtDescription.Text = "";
Session["imgOurCategoriesURL"] = "";
popCategories.JSProperties.Add("cpImage", "");
}
else
{
txtCategories.Text = cCat.catName;
txtDescription.Text = cCat.catDescription;
Session["imgOurCategoriesURL"] = cCat.catImage;
popCategories.JSProperties.Add("cpImage", cCat.catImage);
}
}
else if (e.Parameter.Split('|')[0] == "Save")
{
cCat.catName = txtCategories.Text;
cCat.catDescription = txtDescription.Text;
cCat.catImage = Session["imgOurCategoriesURL"].ToString();
if (catId == 0)
{
cCat.catStatus = true;
db.categories.InsertOnSubmit(cCat);
}
db.SubmitChanges();
}
}
public static string updateData(bool overwrite)
{
string cate = updateCategories(false);
string brand = updateBrands(false);
string prod = updateProductsAll(false);
dbDekkOnlineDataContext db = new dbDekkOnlineDataContext();
var dCategories = (from cat in db.categoriesDPs
where cat.cdpEdited == false && cat.products.Count() == 0
select cat).ToList();
var dBrands = (from bra in db.brands
where bra.braEdited == false && bra.products.Count() == 0
select bra).ToList();
db.categoriesDPs.DeleteAllOnSubmit(dCategories);
db.brands.DeleteAllOnSubmit(dBrands);
int cateU = int.Parse(cate.Split('|')[0]);
int cateI = int.Parse(cate.Split('|')[1]);
int brandU = int.Parse(brand.Split('|')[0]);
int brandI = int.Parse(brand.Split('|')[1]);
int prodU = int.Parse(prod.Split('|')[0]);
int prodI = int.Parse(prod.Split('|')[1]);
int total = cateU + cateI + brandU + brandI + prodU + prodI;
var nBS = new bitacoraSync();
DateTime now = DateTime.Now;
nBS.bitDate = now;
nBS.bitCategoriesInserted = cateI;
nBS.bitCategoriesUpdated = cateU;
nBS.bitBrandsInserted = brandI;
nBS.bitBrandsUpdated = brandU;
nBS.bitProductsInserted = prodI;
nBS.bitProductsUpdated = prodU;
db.bitacoraSyncs.InsertOnSubmit(nBS);
db.SubmitChanges();
return(prod);
}
protected void popProduct_WindowCallback(object source, PopupWindowCallbackArgs e)
{
int proId = int.Parse(e.Parameter.Split('|')[1]);
Session["lastProdId"] = proId;
var cProd = (from pro in db.products where pro.proId == proId select pro).FirstOrDefault();
string folder = "~\\photos\\products\\" + proId.ToString();
if (!System.IO.Directory.Exists(Server.MapPath(folder)))
{
Directory.CreateDirectory(Server.MapPath(folder));
}
xGalleries.Settings.InitialFolder = proId.ToString();
xGalleries.Refresh();
if (e.Parameter.Split('|')[0] == "Load")
{
cmbBrands.Value = cProd.braId.ToString();
if (cProd.categoriesDP.cdpStatus == true)
{
cmbCategories.Value = cProd.cdpId;
}
cmbOurCategories.Value = cProd.catId.ToString();
txtProduct.Text = cProd.proName;
memDescriptionDP.Text = cProd.proDescriptionDP;
txtCodeDP.Text = cProd.proCodeDP;
spProfileDP.Text = cProd.proDimensionProfileDP.ToString();
spWidthDP.Text = cProd.proDimensionWidthDP.ToString();
try { spDiameterDP.Text = cProd.proDimensionDiameterDP.ToString(); } catch { spDiameterDP.Text = ""; }
try { spLoadIndexDP.Text = cProd.proLoadIndexDP.ToString(); } catch { spLoadIndexDP.Text = ""; }
txtSpeedDP.Text = cProd.proSpeed;
txtFuelDP.Text = cProd.proFuelDP;
txtWetDP.Text = cProd.proWetDP;
txtNoiseDP.Text = cProd.proNoiseDP;
spCoverPriceDP.Text = cProd.proCoverPriceDP.ToString();
spSuggestedPriceDP.Text = cProd.proSuggestedPriceDP.ToString();
memDescription.Text = cProd.proDescription;
txtCode.Text = cProd.proCode;
spProfile.Text = cProd.proDimensionProfile.ToString();
spWidth.Text = cProd.proDimensionWidth.ToString();
try { spDiameter.Text = cProd.proDimensionDiameter.ToString(); } catch { spDiameter.Text = ""; }
try { spLoadIndex.Text = cProd.proLoadIndex.ToString(); } catch { spLoadIndex.Text = ""; }
txtSpeed.Text = cProd.proSpeed;
txtFuel.Text = cProd.proFuel;
txtWet.Text = cProd.proWet;
txtNoise.Text = cProd.proNoise;
spCoverPrice.Text = cProd.proCoverPrice.ToString();
var disc = cProd.proDiscount.HasValue ? cProd.proDiscount.Value : 0;
spSuggestedPrice.Text = (cProd.proCoverPrice * ((100 + (cProd.brand.braPercent.HasValue ? cProd.brand.braPercent.Value : 0)) / 100) - disc).ToString();
Session["imgURL"] = cProd.proImage;
popProduct.JSProperties.Add("cpImage", cProd.proImage);
}
else if (e.Parameter.Split('|')[0] == "Copy")
{
memDescription.Text = cProd.proDescriptionDP;
txtCode.Text = cProd.proCodeDP;
spProfile.Text = cProd.proDimensionProfileDP.ToString();
spWidth.Text = cProd.proDimensionWidthDP.ToString();
spDiameter.Text = cProd.proDimensionDiameterDP.ToString();
spLoadIndex.Text = cProd.proLoadIndexDP.ToString();
txtSpeed.Text = cProd.proSpeedDP;
txtFuel.Text = cProd.proFuelDP;
txtWet.Text = cProd.proWetDP;
txtNoise.Text = cProd.proNoiseDP;
spCoverPrice.Text = cProd.proCoverPriceDP.ToString();
//spSuggestedPrice.Text = cProd.proSuggestedPriceDP.ToString();
}
else if (e.Parameter.Split('|')[0] == "Save")
{
cProd.proName = txtProduct.Text;
cProd.proDescription = memDescription.Text;
cProd.proCode = txtCode.Text;
try { cProd.proDimensionProfile = int.Parse(spProfile.Text); } catch { }
try { cProd.proDimensionWidth = int.Parse(spWidth.Text); } catch { }
try { cProd.proDimensionDiameter = int.Parse(spDiameter.Text); } catch { }
cProd.proSpeed = txtSpeed.Text;
cProd.proFuel = txtFuel.Text;
cProd.proWet = txtWet.Text;
cProd.proNoise = txtNoise.Text;
try { cProd.proCoverPrice = decimal.Parse(spCoverPrice.Text); } catch { }
try {
var disc = cProd.proDiscount.HasValue ? cProd.proDiscount.Value : 0;
var spLast = (cProd.proCoverPrice * ((100 + (cProd.brand.braPercent.HasValue ? cProd.brand.braPercent.Value : 0)) / 100) - disc);
var spActual = decimal.Parse(spSuggestedPrice.Text);
if (spLast != spActual)
{
var dif = spLast - spActual;
cProd.proDiscount = disc - dif;
}
cProd.proSuggestedPrice = decimal.Parse(spSuggestedPrice.Text);
} catch { }
cProd.proTyreSize = cProd.proDimensionWidth.ToString() + cProd.proDimensionProfile.ToString() + cProd.proDimensionDiameter.ToString();
cProd.proImage = Session["imgURL"].ToString();
cProd.proEdited = true;
Guid braId = Guid.Parse(cmbBrands.Value.ToString());
//Guid cdpId = Guid.Parse(cmbCategories.Value.ToString());
int?catId = null;
if (cmbOurCategories.Value.ToString() != "")
{
catId = int.Parse(cmbOurCategories.Value.ToString());
}
cProd.braId = braId;
//cProd.cdpId = cdpId;
cProd.catId = catId;
cProd.proLastUpdate = DateTime.Now;
db.SubmitChanges();
}
}
public static int updateProductsBySku(Guid skuId)
{
dbDekkOnlineDataContext db = new dbDekkOnlineDataContext();
string token = generateToken();
string url = dekkProURL + "/GetProducts?";
url += "request.productSkuIds=" + skuId;
HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(url);
myReq.Accept = "application/json";
myReq.ContentType = "application/json";
//myReq.Method = "POST";
myReq.Headers["Authorization"] = "Bearer " + token;
WebResponse wr = myReq.GetResponse();
Stream receiveStream = wr.GetResponseStream();
StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8);
//string content = reader.ReadToEnd();
string json = reader.ReadToEnd();
productsDP lis = JsonConvert.DeserializeObject <productsDP>(json);
int inventory = 0;
var pdp = lis.productDP.FirstOrDefault();
var cBrands = db.brands.ToList();
string error = "";
try
{
dkGeneralInformation dgi = pdp.GeneralInformation;
dkTireInformation dti = pdp.TireInformation;
dkCategory dca = pdp.Category;
dkBrand dbr = pdp.Brand;
dkPricing dbp = pdp.Pricing;
Guid proUUID = dgi.ProductId;
try { inventory = pdp.Inventory.Sum(c => c.AvailableUnits); } catch { }
string fuel = "";
string wet = "";
string noise = "";
string speed = "";
try
{
var FWD = dti.Description.Split('-').ToList();
try { fuel = FWD[0].Replace(" ", "").Substring(FWD[0].IndexOf(':') + 1); } catch { }
try { wet = FWD[1].Replace(" ", ""); } catch { }
try { noise = FWD[2].Replace(" ", ""); } catch { }
try { speed = dti.Speed; } catch { }
}
catch
{
}
if (fuel.Length > 5)
{
fuel = fuel.Substring(0, 4);
}
if (wet.Length > 5)
{
wet = wet.Substring(0, 4);
}
if (noise.Length > 5)
{
noise = noise.Substring(0, 4);
}
//if (speed == "") continue;
product nProd = new product();
var cProd = db.products.Where(c => c.proSkuId == skuId);
if (cProd.FirstOrDefault() != null)
{
nProd = cProd.FirstOrDefault();
}
nProd.proUUID = dgi.ProductId;
Guid cdpId = Guid.Parse(dca.ProductCategoryId);
nProd.cdpId = cdpId;
Guid braId = Guid.Parse(dbr.BrandId);
if (cBrands.Where(c => c.braId == braId).Count() == 0)
{
brand nBra = new brand();
nBra.braId = Guid.Parse(dbr.BrandId);
nBra.braCode = dbr.Code;
nBra.braName = dbr.Name;
nBra.braNameDP = dbr.Name;
nBra.braCodeDP = dbr.Code;
nBra.barDescriptionDP = "";
nBra.braDescription = "";
nBra.braImage = "";
nBra.braEdited = false;
db.brands.InsertOnSubmit(nBra);
nProd.brand = nBra;
}
else
{
nProd.braId = braId;
}
try { nProd.proSkuId = Guid.Parse(dti.ProductSkuId); } catch { }
nProd.proSkuDP = dti.SkuCode;
if (nProd.proSkuDP == null)
{
nProd.proSkuDP = "";
}
nProd.proNameDP = dgi.Name;
nProd.proDescriptionDP = dgi.Name;
nProd.proCodeDP = dti.Code;
try { nProd.proDimensionProfileDP = int.Parse(dti.Dimension.Profile.Replace(".00", "")); } catch { };
try { nProd.proDimensionWidthDP = int.Parse(dti.Dimension.Width.Replace(".00", "")); } catch { };
try { nProd.proDimensionDiameterDP = int.Parse(dti.Dimension.Diameter.Replace(".00", "")); } catch { };
nProd.proCoverPriceDP = dbp.CoverPrice;
nProd.proSuggestedPriceDP = dbp.SuggestedPrice;
nProd.proRCRDP = dti.RollerCircumReference;
nProd.proLoadIndexDP = dti.LoadIndex;
nProd.proSpeedDP = dti.Speed;
nProd.proProductCodeDP = dgi.ProductCode;
nProd.proFuelDP = fuel;
nProd.proWetDP = wet;
nProd.proNoiseDP = noise;
string tyreSize = nProd.proDimensionWidthDP.ToString() + nProd.proDimensionProfileDP.ToString() + nProd.proDimensionDiameterDP.ToString();
nProd.proLastUpdateDP = DateTime.Now;
if (tyreSize.Length > 10)
{
tyreSize = tyreSize.Substring(0, 9);
}
nProd.proTyreSizeDP = tyreSize;
if (nProd.proEdited != true)
{
nProd.proSku = nProd.proSkuDP;
nProd.proName = nProd.proNameDP;
nProd.proDescription = nProd.proDescriptionDP;
nProd.proCode = nProd.proCodeDP;
nProd.proDimensionProfile = nProd.proDimensionProfileDP;
nProd.proDimensionWidth = nProd.proDimensionWidthDP;
nProd.proDimensionDiameter = nProd.proDimensionDiameterDP;
nProd.proCoverPrice = nProd.proCoverPriceDP;
nProd.proSuggestedPrice = nProd.proSuggestedPriceDP;
nProd.proRCR = nProd.proRCRDP;
nProd.proLoadIndex = nProd.proLoadIndexDP;
nProd.proSpeed = nProd.proSpeedDP;
nProd.proProductCode = nProd.proProductCodeDP;
nProd.proFuel = nProd.proFuelDP;
nProd.proWet = nProd.proWetDP;
nProd.proNoise = nProd.proNoiseDP;
nProd.proTyreSize = nProd.proTyreSizeDP;
nProd.proEdited = false;
nProd.proStatus = true;
nProd.proImage = "";
}
nProd.proInventory = inventory;
}
catch (Exception ex)
{
error += ex.ToString() + " | ";
}
db.SubmitChanges();
return(inventory);
}
public static void updateProductsByCategory(List <string> categories, ref int updates, ref int news, string find = "")
{
dbDekkOnlineDataContext db = new dbDekkOnlineDataContext();
string token = generateToken();
string url = dekkProURL + "/GetProducts?";
url += "request.timeStampFrom=" + lastUpdate.ToString("yyyy-MM-ddTHH:mm:ss") + "&";
foreach (string cat in categories)
{
url += "request.productCategoryIds=" + cat + "&";
}
url = url.TrimEnd('&');
HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(url);
myReq.Accept = "application/json";
myReq.ContentType = "application/json";
//myReq.Method = "POST";
myReq.Headers["Authorization"] = "Bearer " + token;
WebResponse wr = myReq.GetResponse();
Stream receiveStream = wr.GetResponseStream();
StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8);
//string content = reader.ReadToEnd();
string json = reader.ReadToEnd();
productsDP lis = JsonConvert.DeserializeObject <productsDP>(json);
int count = 0;
int nCount = 0;
var cProds = (from pro in db.products
where categories.Contains(pro.categoriesDP.cdpId.ToString())
select pro).ToList();
var cBrands = db.brands.ToList();
string error = "";
foreach (productDP pdp in lis.productDP)
{
try
{
dkGeneralInformation dgi = pdp.GeneralInformation;
dkTireInformation dti = pdp.TireInformation;
dkCategory dca = pdp.Category;
dkBrand dbr = pdp.Brand;
dkPricing dbp = pdp.Pricing;
Guid proUUID = dgi.ProductId;
bool findProduct = false;
if (dti.Code == find)
{
findProduct = true;
}
if (findProduct)
{
Console.Write(dgi.ProductId);
}
int inventory = 0;
try
{
string cdpIdCheck = dca.ProductCategoryId.ToUpper();
if (!categories.Contains(cdpIdCheck))
{
continue;
}
}
catch
{
continue;
}
try { inventory = pdp.Inventory.Sum(c => c.AvailableUnits); } catch { }
string fuel = "";
string wet = "";
string noise = "";
string speed = "";
try
{
var FWD = dti.Description.Split('-').ToList();
try { fuel = FWD[0].Replace(" ", "").Substring(FWD[0].IndexOf(':') + 1); } catch { }
try { wet = FWD[1].Replace(" ", ""); } catch { }
try { noise = FWD[2].Replace(" ", ""); } catch { }
try { speed = dti.Speed; } catch { }
}
catch
{
}
if (fuel.Length > 5)
{
fuel = fuel.Substring(0, 4);
}
if (wet.Length > 5)
{
wet = wet.Substring(0, 4);
}
if (noise.Length > 5)
{
noise = noise.Substring(0, 4);
}
//if (speed == "") continue;
product nProd = new product();
var cProd = cProds.Where(c => c.proUUID == proUUID);
if (cProd.FirstOrDefault() != null)
{
nProd = cProd.FirstOrDefault();
}
else
{
nCount++;
db.products.InsertOnSubmit(nProd);
}
nProd.proUUID = dgi.ProductId;
Guid cdpId = Guid.Parse(dca.ProductCategoryId);
nProd.cdpId = cdpId;
Guid braId = Guid.Parse(dbr.BrandId);
if (cBrands.Where(c => c.braId == braId).Count() == 0)
{
brand nBra = new brand();
nBra.braId = Guid.Parse(dbr.BrandId);
nBra.braCode = dbr.Code;
nBra.braName = dbr.Name;
nBra.braNameDP = dbr.Name;
nBra.braCodeDP = dbr.Code;
nBra.barDescriptionDP = "";
nBra.braDescription = "";
nBra.braImage = "";
nBra.braEdited = false;
db.brands.InsertOnSubmit(nBra);
nProd.brand = nBra;
}
else
{
nProd.braId = braId;
}
try { nProd.proSkuId = Guid.Parse(dti.ProductSkuId); } catch { }
nProd.proSkuDP = dti.SkuCode;
if (nProd.proSkuDP == null)
{
nProd.proSkuDP = "";
}
nProd.proNameDP = dgi.Name;
nProd.proDescriptionDP = dgi.Name;
nProd.proCodeDP = dti.Code;
try { nProd.proDimensionProfileDP = int.Parse(dti.Dimension.Profile.Replace(".00", "")); } catch { };
try { nProd.proDimensionWidthDP = int.Parse(dti.Dimension.Width.Replace(".00", "")); } catch { };
try { nProd.proDimensionDiameterDP = int.Parse(dti.Dimension.Diameter.Replace(".00", "")); } catch { };
nProd.proCoverPriceDP = dbp.CoverPrice;
nProd.proSuggestedPriceDP = dbp.SuggestedPrice;
nProd.proRCRDP = dti.RollerCircumReference;
nProd.proLoadIndexDP = dti.LoadIndex;
nProd.proSpeedDP = dti.Speed;
nProd.proProductCodeDP = dgi.ProductCode;
nProd.proFuelDP = fuel;
nProd.proWetDP = wet;
nProd.proNoiseDP = noise;
string tyreSize = nProd.proDimensionWidthDP.ToString() + nProd.proDimensionProfileDP.ToString() + nProd.proDimensionDiameterDP.ToString();
nProd.proLastUpdateDP = DateTime.Now;
if (tyreSize.Length > 10)
{
tyreSize = tyreSize.Substring(0, 9);
}
nProd.proTyreSizeDP = tyreSize;
if (nProd.proEdited != true)
{
nProd.proSku = nProd.proSkuDP;
nProd.proName = nProd.proNameDP;
nProd.proDescription = nProd.proDescriptionDP;
nProd.proCode = nProd.proCodeDP;
nProd.proDimensionProfile = nProd.proDimensionProfileDP;
nProd.proDimensionWidth = nProd.proDimensionWidthDP;
nProd.proDimensionDiameter = nProd.proDimensionDiameterDP;
nProd.proCoverPrice = nProd.proCoverPriceDP;
nProd.proSuggestedPrice = nProd.proSuggestedPriceDP;
nProd.proRCR = nProd.proRCRDP;
nProd.proLoadIndex = nProd.proLoadIndexDP;
nProd.proSpeed = nProd.proSpeedDP;
nProd.proProductCode = nProd.proProductCodeDP;
nProd.proFuel = nProd.proFuelDP;
nProd.proWet = nProd.proWetDP;
nProd.proNoise = nProd.proNoiseDP;
nProd.proTyreSize = nProd.proTyreSizeDP;
nProd.proEdited = false;
nProd.proStatus = true;
nProd.proImage = "";
}
nProd.proInventory = inventory;
count++;
}
catch (Exception ex)
{
error += ex.ToString() + " | ";
}
}
db.tokens.FirstOrDefault().tokStockLastUpdate = DateTime.Now;
db.SubmitChanges();
count = count - nCount;
news = nCount;
updates = count;
}
static string generateToken()
{
dbDekkOnlineDataContext db = new dbDekkOnlineDataContext();
DateTime now = DateTime.Now.Date;
string username = ConfigurationManager.AppSettings["dekkProUsername"];
string password = ConfigurationManager.AppSettings["dekkProPassword"];
dekkProURL = ConfigurationManager.AppSettings["dekkProUrl"];
var cToken = new token();
var checkTokens = (from tok in db.tokens where tok.tokDate >= now orderby tok.tokId descending select tok);
string token = "";
if (checkTokens.Count() > 0)
{
cToken = checkTokens.FirstOrDefault();
token = cToken.tokData;
lastUpdate = cToken.tokStockLastUpdate;
lastUpdateCats = cToken.tokCategoriesLastUpdate;
lastUpdateBrands = cToken.tokBrandsLastUpdate;
}
else
{
cToken = db.tokens.FirstOrDefault();
if (cToken == null)
{
cToken = new token();
db.tokens.InsertOnSubmit(cToken);
}
else
{
lastUpdate = cToken.tokStockLastUpdate;
}
cToken.tokDate = now;
string urlToken = ConfigurationManager.AppSettings["dekkProUrlTokken"];;
HttpWebRequest myRT = (HttpWebRequest)WebRequest.Create(urlToken);
myRT.ContentType = "application/x-www-form-urlencoded";
var postData = "grant_type=password";
postData += "&username="******"&password="******"POST";
myRT.ContentLength = data.Length;
Stream postStream = myRT.GetRequestStream();
postStream.Write(data, 0, data.Length);
postStream.Flush();
postStream.Close();
var response = (HttpWebResponse)myRT.GetResponse();
var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
token = responseString.Split(',')[0].Split(':')[1].Substring(1).TrimEnd('"');
cToken.tokData = token;
db.SubmitChanges();
}
return(token);
}
public static string updateBrands(bool overwrite)
{
dbDekkOnlineDataContext db = new dbDekkOnlineDataContext();
string token = generateToken();
string url = dekkProURL + "/GetProductBrands?";
url += "request.timeStampFrom=" + lastUpdateBrands.ToString("yyyy-MM-ddTHH:mm:ss");
HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(url);
myReq.Accept = "application/json";
myReq.ContentType = "application/json";
//myReq.Method = "POST";
myReq.Headers["Authorization"] = "Bearer " + token;
WebResponse wr = myReq.GetResponse();
Stream receiveStream = wr.GetResponseStream();
StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8);
//string content = reader.ReadToEnd();
string json = reader.ReadToEnd();
dkBrandsDP lis = JsonConvert.DeserializeObject <dkBrandsDP>(json);
var brands = db.brands.ToList();
int count = 0;
int nCount = 0;
foreach (var bra in lis.BrandsDekk)
{
Guid braId = Guid.Parse(bra.BrandId);
var cBra = brands.Where(c => c.braId == braId);
var nBra = new brand();
if (cBra.FirstOrDefault() != null)
{
nBra = cBra.FirstOrDefault();
}
else
{
nCount++;
db.brands.InsertOnSubmit(nBra);
}
nBra.braId = braId;
nBra.barDescriptionDP = bra.Description;
if (nBra.barDescriptionDP == null)
{
nBra.barDescriptionDP = "";
}
nBra.braNameDP = bra.Name;
nBra.braCodeDP = bra.Code;
if (nBra.braEdited != true)
{
nBra.braName = nBra.braNameDP;
nBra.braCode = nBra.braCodeDP;
nBra.braDescription = nBra.barDescriptionDP;
nBra.braImage = "";
}
count++;
}
db.tokens.FirstOrDefault().tokBrandsLastUpdate = DateTime.Now;
db.SubmitChanges();
count = count - nCount;
return(count.ToString() + "|" + nCount.ToString());
}
public static string updateCategories(bool overwrite)
{
dbDekkOnlineDataContext db = new dbDekkOnlineDataContext();
string token = generateToken();
string url = dekkProURL + "/GetProductCategories?";
url += "request.timeStampFrom=" + lastUpdateCats.ToString("yyyy-MM-ddTHH:mm:ss");
HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(url);
myReq.Accept = "application/json";
myReq.ContentType = "application/json";
//myReq.Method = "POST";
myReq.Headers["Authorization"] = "Bearer " + token;
WebResponse wr = myReq.GetResponse();
Stream receiveStream = wr.GetResponseStream();
StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8);
//string content = reader.ReadToEnd();
string json = reader.ReadToEnd();
dkCategoriesDP lis = JsonConvert.DeserializeObject <dkCategoriesDP>(json);
var categories = db.categoriesDPs.ToList();
int count = 0;
int nCount = 0;
foreach (var cat in lis.CategoriesDekk)
{
var nCat = new categoriesDP();
Guid cdpId = Guid.Parse(cat.ProductCategoryId);
var cCat = categories.Where(c => c.cdpId == cdpId);
if (cCat.FirstOrDefault() != null)
{
nCat = cCat.FirstOrDefault();
}
else
{
nCount++;
db.categoriesDPs.InsertOnSubmit(nCat);
nCat.cdpStatus = true;
}
nCat.cdpId = cdpId;
nCat.cdpDescriptionDP = cat.Description;
if (nCat.cdpDescriptionDP == null)
{
nCat.cdpDescriptionDP = "";
}
nCat.cdpNameDP = cat.Name;
try { if (cat.ProductCategoryParentId != "")
{
nCat.cdpParentId = Guid.Parse(cat.ProductCategoryParentId);
}
} catch { }
if (nCat.cdpEdited != true)
{
nCat.cdpDescription = nCat.cdpDescriptionDP;
nCat.cdpName = nCat.cdpNameDP;
nCat.cdpImage = "";
}
else
{
nCat.cdpStatus = false;
}
count++;
}
db.tokens.FirstOrDefault().tokCategoriesLastUpdate = DateTime.Now;
db.SubmitChanges();
count = count - nCount;
return(count.ToString() + "|" + nCount.ToString());
}