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()); }