public CatIdDataItem(DataItem item) { this.item = item; }
private string StorePix(DataItem dataItem) { if (dataItem.Picture == null) return string.Empty; if (!(dataItem.Picture is ExcelPicture)) return string.Empty; var pic = dataItem.Picture as ExcelPicture; var name = pic.Name + "." + pic.ImageFormat; var complName = storeDir + @"\" + name; while (File.Exists(complName)) { name = name.Replace("." + pic.ImageFormat, "1." + pic.ImageFormat); // prida k nazvu suboru "1".. complName = storeDir + @"\" + name; } pic.Image.Save(complName); return name; }
/// <summary> /// Nacita dalsi produkt /// </summary> /// <returns></returns> internal bool ProcessNextDataItemRoom31() { string code = string.Empty; // actualRowIndex je na prvom zazname.. obrazok by mal tento prekryvat // 7.7.2013 - obrazky pre room31 sa zatial neriesia /*object pic = FindPictureForActual(); if (pic != null) New.Picture = pic;*/ do { code = (sheet.Cells[actualRowIndex, codesColIndex].Value ?? string.Empty).ToString(); if (!string.IsNullOrEmpty(code)) { DataItem New = new DataItem(); // kod polozky New.Codes.Add(code); // popis - nazov a velkost var desc = (sheet.Cells[actualRowIndex, descColIndex].Value ?? string.Empty).ToString(); if (string.IsNullOrEmpty(New.Description)) New.Description = desc; // parsovanie velkosti SetSizesRoom31(New.Sizes); // rrp var rrp = (sheet.Cells[actualRowIndex, rrpColIndex].Value ?? string.Empty).ToString(); if (string.IsNullOrEmpty(New.Rrp)) New.Rrp = rrp; // supp var supp = (sheet.Cells[actualRowIndex, suppColIndex].Value ?? string.Empty).ToString(); if (string.IsNullOrEmpty(New.Supp)) New.Supp = supp; // presun na dalasi riadok actualRowIndex++; data.Add(New); } } while (!string.IsNullOrEmpty(code)); return true; }
private string GetNextLine(DataItem dataItem, bool useinternalcatids) { StringBuilder sb = new StringBuilder(); sb.Append("\"sk\",");//store sb.Append(dataItem.Codes[0] + ",");//sku sb.Append("\"Default\",");//_attribute_set sb.Append("\"simple\",");//_type sb.Append("\"0\",");//magmi:delete sb.Append("\"1\",");//status sb.Append("\"4\",");//visibility var desc = "\"" + dataItem.Description + "\","; sb.Append(desc);//name sb.Append(desc.ToLower().Replace(' ', '-').RemoveDiacritics());//url_key sb.Append("\"\",");//description sb.Append("\"\",");//short_description sb.Append("\"1\",");//enable_googlecheckout sb.Append("\"" + (useinternalcatids ? dataItem.CatId : CategoryIds) + "\",");//category_ids sb.Append("\"1\",");//weight sb.Append("\"" + dataItem.Rrp + "\",");//price sb.Append("\"" + dataItem.Rrp + "\",");//special_price sb.Append("\"" + DateTime.Now.ToString("yyyy-MM-dd") +"\",");//special_from_date sb.Append("\"2\",");//tax_class_id sb.Append("\"0\",");//manage_stock sb.Append("\"0\",");//use_config_manage_stock sb.Append("\"" + dataItem.Supp + "\",");//brand sb.Append("\"" + string.Join("|", dataItem.Sizes.ToArray()) + "\",");//Veľkosť:Dropdown:1 string picName = StorePix(dataItem); var compl = "\"" + picName + "\","; sb.Append(compl);//thumbnail sb.Append(compl);//small_image sb.Append(compl);//image sb.Append(compl);//media_gallery sb.Append("\"0\"");//media_gallery_reset return sb.ToString(); }
/// <summary> /// Nacita dalsi produkt /// </summary> /// <returns></returns> internal bool ProcessNextDataItemAdidasSLVR() { DataItem New = new DataItem(); string code = string.Empty; // actualRowIndex je na prvom zazname.. obrazok by mal tento prekryvat object pic = FindPictureForActual(); if (pic != null) New.Picture = pic; do { code = (sheet.Cells[actualRowIndex, codesColIndex].Value ?? string.Empty).ToString(); if (!string.IsNullOrEmpty(code)) { // kod polozky New.Codes.Add(code); // popis - nazov a velkost var desc = (sheet.Cells[actualRowIndex, descColIndex].Value ?? string.Empty).ToString(); if (string.IsNullOrEmpty(New.Description)) New.Description = GetDescription(desc); New.Sizes.Add(GetSize(desc)); // rrp var rrp = (sheet.Cells[actualRowIndex, rrpColIndex].Value ?? string.Empty).ToString(); if (string.IsNullOrEmpty(New.Rrp)) New.Rrp = rrp; // supp var supp = (sheet.Cells[actualRowIndex, suppColIndex].Value ?? string.Empty).ToString(); if (string.IsNullOrEmpty(New.Supp)) New.Supp = supp; // presun na dalasi riadok actualRowIndex++; } } while (!string.IsNullOrEmpty(code)); data.Add(New); return true; }