private static String getProductJsonIncludePage(DataTable dt,int index) { if (dt != null) { List<ProductModel> details = new List<ProductModel>(); foreach (DataRow dtrow in dt.Rows) { ProductModel obj = new ProductModel(); obj.PrdRedirectUrl = dtrow["prdRedirectUrl"].ToString(); obj.Name = dtrow["name"].ToString(); obj.PrdUrl = dtrow["prdUrl"].ToString(); obj.Img = dtrow["imageUrl"].ToString(); obj.SeoUrl = dtrow["seourl"].ToString(); obj.SubCatId = dtrow["subCatid"].ToString(); obj.Storeid = dtrow["storeid"].ToString(); obj.RegularPrice = dtrow["regularprice"].ToString(); obj.OfferPrice = dtrow["offerprice"].ToString(); obj.UniqueId = dtrow["uniqueId"].ToString(); obj.PrdId = dtrow["prdid"].ToString(); obj.pageSize = AppConstants.PRODUCT_PAGE_SIZE.ToString(); obj.pageNext = (index + AppConstants.PRODUCT_PAGE_SIZE + 1).ToString(); details.Add(obj); } JavaScriptSerializer ser = new JavaScriptSerializer(); return ser.Serialize(details); } else { return "No Product Found"; } }
public void updateProducts(MyCategory category) { FlipkartProductModel exm = JsonConvert.DeserializeObject<FlipkartProductModel>(HttpGet(category.availableVariants.version.get)); ProductModel prdModel = new ProductModel(); ProductDAL dal = new ProductDAL(); while (exm.nextUrl != null) { foreach (ProductInfoList item in exm.productInfoList) { ProductAttributes att = new ProductAttributes(); ProductIdentifier idt = new ProductIdentifier(); att = item.productBaseInfo.productAttributes; idt = item.productBaseInfo.productIdentifier; prdModel.UniqueId = Guid.NewGuid().ToString().Substring(0, 8); prdModel.PrdId = idt.productId; prdModel.Name = att.title; if (att.productDescription == null) { att.productDescription = FlipkartConstants.INVALID_DESCRIPTION; } prdModel.Description = att.productDescription; prdModel.PrdUrl = att.productUrl; prdModel.PrdRedirectUrl = att.productUrl; if (att.imageUrls._275x275 == null) { att.imageUrls._275x275 = FlipkartConstants.DEFAULT_IMAGE; } prdModel.Img = att.imageUrls._275x275; prdModel.Width = FlipkartConstants.DEFAULT_IMAGE_WIDTH_AND_HEIGHT_275PX; prdModel.Height = FlipkartConstants.DEFAULT_IMAGE_WIDTH_AND_HEIGHT_275PX; prdModel.Storeid = FlipkartConstants.FLIPKART_STORE_ID_FOKATDEALS; prdModel.RegularPrice = att.maximumRetailPrice.amount + " Rs."; prdModel.OfferPrice = att.sellingPrice.amount + " Rs."; prdModel.SubCatId = category.apiName; prdModel.CreatedOn = System.DateTime.Now + ""; prdModel.ExpireOn = ""; String status = ""; if (att.inStock) { status = "A"; } else { status = "D"; } prdModel.Status = status; prdModel.Custom1 = att.productBrand; prdModel.Custom2 = att.codAvailable + ""; int i = dal.InsertProducts(prdModel); } exm = JsonConvert.DeserializeObject<FlipkartProductModel>(HttpGet(exm.nextUrl)); } }
public int InsertProducts(ProductModel prdModel) { try { SqlCommand cmd = new SqlCommand("usp_InsertProduct", con); cmd.Parameters.AddWithValue("@uniquId", prdModel.UniqueId); cmd.Parameters.AddWithValue("@prdid", prdModel.PrdId); cmd.Parameters.AddWithValue("@name", prdModel.Name); cmd.Parameters.AddWithValue("@desc", prdModel.Description); cmd.Parameters.AddWithValue("@prdUrl", prdModel.PrdUrl); cmd.Parameters.AddWithValue("@prdre", prdModel.PrdRedirectUrl); cmd.Parameters.AddWithValue("@img", prdModel.Img); cmd.Parameters.AddWithValue("@w", prdModel.Width); cmd.Parameters.AddWithValue("@h", prdModel.Height); cmd.Parameters.AddWithValue("@storeid", prdModel.Storeid); cmd.Parameters.AddWithValue("@reg", prdModel.RegularPrice); cmd.Parameters.AddWithValue("@sell", prdModel.OfferPrice); cmd.Parameters.AddWithValue("@catid", prdModel.SubCatId); cmd.Parameters.AddWithValue("@status", prdModel.Status); cmd.Parameters.AddWithValue("@c1", prdModel.Custom1); cmd.Parameters.AddWithValue("@c2", prdModel.Custom2); cmd.CommandType = CommandType.StoredProcedure; con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); return i; } catch { return -99; } }