public string CheckMadeIn(StorageItemJP store)
{
if (store.MadeIn == null || store.MadeIn == "")
{
return("item-deny");
}
return("");
}
public string CheckQuantity(StorageItemJP store)
{
if (store.Quantity <= 0 || store.Quantity == null)
{
return("item-deny");
}
return("");
}
public string CheckCategory(StorageItemJP store)
{
if (store.CategoryId == null)
{
return("item-deny");
}
return("");
}
public string CheckPriceTax(StorageItemJP store)
{
if (store.PriceTax <= 0 || store.PriceTax == null || store.PriceTax < 50)
{
return("item-deny");
}
return("");
}
public string CheckImageBase64(StorageItemJP store)
{
if (store.ImageBase64 == "" || store.ImageBase64 == null)
{
return("item-deny");
}
return("");
}
public string CheckLinkWeb(StorageItemJP store)
{
if (store.LinkWeb == "" || store.LinkWeb == null)
{
return("item-deny");
}
return("");
}
//Luu kho
public string CheckItem(StorageItemJP store)
{
if (store.NameEN == null || store.NameEN == "")
{
return("item-deny");
}
if (store.NameJP == null || store.NameJP == "")
{
return("item-deny");
}
if (store.JanCode == "" || store.JanCode == null)
{
return("item-deny");
}
if (store.JanCode.StartsWith("4") == false)
{
return("item-deny");
}
foreach (var item in keyJP.ToUpper().Split(','))
{
if (store.NameJP.ToUpper().Contains(item) || store.NameEN.ToUpper().Contains(item))
{
return("item-deny");
}
}
foreach (var item in keyEN.ToUpper().Split(','))
{
if (store.NameEN.ToUpper().Contains(item) || store.NameJP.ToUpper().Contains(item))
{
return("item-deny");
}
}
if (store.Quantity <= 0 || store.Quantity == null)
{
return("item-deny");
}
if (store.PriceTax <= 0 || store.PriceTax == null || store.PriceTax < 50)
{
return("item-deny");
}
if (store.LinkWeb == "" || store.LinkWeb == null)
{
return("item-deny");
}
if (store.ImageBase64 == "" || store.ImageBase64 == null)
{
return("item-deny");
}
return("");
}
public string CheckNameEN(StorageItemJP store)
{
if (store.NameEN == null || store.NameEN == "")
{
return("item-deny");
}
else
{
foreach (var item in keyEN.ToUpper().Split(','))
{
if (store.NameEN.ToUpper().Contains(item))
{
return("item-deny");
}
}
}
return("");
}
public void getOtherProductsDetail(string ItemCode, int SearchQuantity = 1, Guid?StoregeJPId = null)
{
try
{
StorageItemJP model = new StorageItemJP()
{
CreatedAt = DateTime.Now,
ProductCode = ItemCode, JanCode = ItemCode,
CreatedBy = user.Staff.UserName,
Id = Guid.NewGuid(),
Quantity = SearchQuantity,
StatusId = 1,
StoregeJPId = StoregeJPId,
UpdatedAt = DateTime.Now,
UpdatedBy = user.Staff.UserName
};
db.StorageItemJPs.Add(model);
db.SaveChanges();
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
public void Reseach(string SearchCode, int SearchQuantity, Guid StoregeJPId)
{
try
{
try
{
var item = db.WareHouseItems.First(n => n.ProductCode == SearchCode);
#region create model
StorageItemJP model = new StorageItemJP()
{
Amount = item.PriceTax * SearchQuantity,
CategoryId = item.CategoryId,
CategoryName = item.CategoryName,
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
Id = Guid.NewGuid(),
Image = item.Image,
JanCode = item.JanCode,
LinkWeb = item.LinkWeb,
MadeIn = item.MadeIn,
Material = item.Material,
NameEN = item.NameEN,
NameJP = item.NameJP,
Notes = item.Notes,
PriceTax = item.PriceTax,
ProductCode = item.ProductCode,
Quantity = SearchQuantity,
StatusId = 1,
StoregeJPId = StoregeJPId,
UpdatedAt = DateTime.Now,
UpdatedBy = user.Staff.UserName
};
#endregion
db.StorageItemJPs.Add(model);
db.SaveChanges();
}
catch
{
#region Research Product Internet
//rakuten
try { getRakutenProductsDetail(SearchCode, SearchQuantity, StoregeJPId); }
catch
{
//amazon
try { getAmazonJPProductsDetail(SearchCode, SearchQuantity, StoregeJPId); }
catch
{
//yahoo shopping
try { getYahooShoppingProductsDetail(SearchCode, SearchQuantity, StoregeJPId); }
catch
{
//Uniqlo
try { getUniqloProductsDetail(SearchCode, SearchQuantity, StoregeJPId); }
catch
{
//yahoo Auction
try { getYahooAuctionProductsDetail(SearchCode, SearchQuantity, StoregeJPId); }
catch
{
getOtherProductsDetail(SearchCode, SearchQuantity, StoregeJPId);
}
}
}
}
}
#endregion
}
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
public void SearchAndSave(SearchProductInfo item, string ItemCode, int SearchQuantity = 1, Guid?StoregeJPId = null)
{
StorageItemJP model = new StorageItemJP()
{
Amount = item.PriceTax * SearchQuantity,
CategoryId = item.CategoryId,
CategoryName = item.CategoryName,
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
Id = Guid.NewGuid(),
Image = item.Image,
JanCode = item.JanCode,
LinkWeb = item.LinkWeb,
MadeIn = "JAPAN",
Material = item.Material,
NameEN = item.NameEN,
NameJP = item.NameJP,
Notes = item.Notes,
PriceTax = item.PriceTax,
ProductCode = item.ProductCode,
Quantity = SearchQuantity,
StatusId = 1,
StoregeJPId = StoregeJPId,
UpdatedAt = DateTime.Now,
UpdatedBy = user.Staff.UserName
};
if (db.StorageItemJPs.Where(n => n.ProductCode == model.ProductCode && n.StoregeJPId == StoregeJPId).Count() == 0)
{
db.StorageItemJPs.Add(model);
}
WareHouseItem items = new WareHouseItem()
{
Amount = item.PriceTax * SearchQuantity,
CategoryId = item.CategoryId,
CategoryName = item.CategoryName,
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
Id = Guid.NewGuid(),
Image = item.Image,
JanCode = item.JanCode,
LinkWeb = item.LinkWeb,
MadeIn = "JAPAN",
Material = item.Material,
NameEN = item.NameEN,
NameJP = item.NameJP,
Notes = item.Notes,
PriceTax = item.PriceTax,
ProductCode = item.ProductCode,
Quantity = SearchQuantity,
UpdatedAt = DateTime.Now,
UpdatedBy = user.Staff.UserName
};
if (db.WareHouseItems.Where(n => n.ProductCode == model.ProductCode).Count() == 0)
{
db.WareHouseItems.Add(items);
}
db.SaveChanges();
}
public ActionResult StorageJPFull(string fileName = "")
{
//upload file
HttpPostedFileBase file = Request.Files[0];
fileName = file.FileName.DoiTenFile();
file.SaveAs(Server.MapPath("~/Uploads/StorageJP/" + fileName));
// Opening the Excel template...
FileStream fs = new FileStream(Server.MapPath("~/Uploads/StorageJP/" + fileName), FileMode.Open, FileAccess.Read);
// Getting the complete workbook...
ISheet sheet = null;
if (fileName.Contains(".xlsx"))
{
XSSFWorkbook templateWorkbook = new XSSFWorkbook(Server.MapPath("~/Uploads/StorageJP/" + fileName));
sheet = templateWorkbook.GetSheet("例");
}
else if (fileName.Contains(".xls"))
{
HSSFWorkbook templateWorkbook = new HSSFWorkbook(fs, true);
sheet = templateWorkbook.GetSheet("例");
}
//read excel
WebsiteHelpers websiteHelper = new WebsiteHelpers();
List <StorageJP> lstStorageJP = new List <StorageJP>();
List <StorageItemJP> lstStorageItemJP = new List <StorageItemJP>();
List <TrackingDetail> lstTrackingDetail = new List <TrackingDetail>();
Guid IdTracking = Guid.NewGuid();
#region read excel
//check column
string nameJP = "";
string trackingCode = "";
string urlReport = ConfigurationManager.AppSettings["url_report_storejp"];
Guid storeId = Guid.NewGuid();
for (int row = 3; row <= sheet.LastRowNum; row++)
{
nameJP = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Tên Hàng Jp(*)")).StringCellValue;
trackingCode = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Mã Tracking(*)")).StringCellValue;
if (nameJP == "" && trackingCode == "")
{
break;
}
if (trackingCode != "" && trackingCode != null)
{
IdTracking = Guid.NewGuid();
string size = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Size")).StringCellValue;
size = size.Replace("cm", "").Trim();
double sizeInput = double.Parse(size) / 3;
sizeInput = sizeInput - Math.Round(sizeInput / 3);
double dai = double.Parse(size) - 2 * sizeInput;
DateTime revice = new DateTime();
try
{
revice = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Ngày nhận")).DateCellValue;
}
catch {
try
{
revice = DateTime.ParseExact(sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Ngày nhận")).StringCellValue, "yyyy-MM-dd", null);
}
catch { }
}
if (lstStorageJP.Where(n => n.TrackingCode == trackingCode.Trim()).Count() == 0)
{
storeId = Guid.NewGuid();
StorageJP store = new Models.StorageJP()
{
Id = storeId,
AgencyId = user.Agency.Id,
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
DeliveryAddress = "",
StatusId = 6,
TrackingCode = trackingCode.Trim(),
ReceivedDate = revice,
Size = "size-input",
SizeInput = dai + " " + sizeInput + " " + sizeInput,
Notes = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Ghi chú")).StringCellValue,
ReceivedHour = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Giờ nhận")).StringCellValue,
Weigh = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Số Kg")).NumericCellValue
};
lstStorageJP.Add(store);
}
TrackingDetail detail = new TrackingDetail()
{
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
Id = IdTracking,
StoregeJPId = storeId,
UpdatedAt = DateTime.Now,
UpdatedBy = user.Staff.UserName,
TrackingSubCode = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Mã Tách Kiện(*)")).StringCellValue
};
lstTrackingDetail.Add(detail);
}
else
{
double price = 0;
try
{
price = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Giá(*)")).NumericCellValue;
}
catch { }
string namejp = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Tên Hàng Jp(*)")).StringCellValue;
string nameen = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Tên Hàng En")).StringCellValue;
string linkweb = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Weblink")).StringCellValue;
string Image = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Hình ảnh")).StringCellValue;
string base64Image = "";
StorageItemJP storejpItem = new StorageItemJP()
{
Amount = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Thành tiền")).NumericCellValue,
CategoryId = getCategory(sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Loại Hàng")).StringCellValue).Id,
CategoryName = getCategory(sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Loại Hàng")).StringCellValue).Name,
Component = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Thành Phần")).StringCellValue,
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
ImageBase64 = base64Image,
Image = Image,
ImageLinkWeb = Image,
JanCode = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Jan Code")).StringCellValue,
Material = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Chất liệu")).StringCellValue,
LinkWeb = linkweb,
MadeIn = getMadeIn(sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Xuất xứ(*)")).StringCellValue).Id + "",
NameEN = nameen,
NameJP = namejp,
PriceTax = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Giá(*)")).NumericCellValue,
ProductCode = "",
Quantity = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Số Lượng(*)")).NumericCellValue,
UpdatedAt = DateTime.Now,
StoregeJPId = storeId,
UpdatedBy = user.Staff.UserName,
TrackingDetailId = IdTracking
};
lstStorageItemJP.Add(storejpItem);
}
}
#endregion
//delete all data form db
var stores = db.StorageJPs.Where(n => n.AgencyId == user.Agency.Id);
foreach (var items in stores)
{
if (PageUtils.Status(items.Id).Value == "1")
{
var details = items.TrackingDetails.ToList();
foreach (var item in details)
{
var storeItems = item.StorageItemJPs.ToList();
foreach (var st in storeItems)
{
db.StorageItemJPs.Remove(st);
}
db.TrackingDetails.Remove(item);
}
db.StorageJPs.Remove(items);
}
}
db.SaveChanges();
//Insert database
foreach (var items in lstStorageJP)
{
db.StorageJPs.Add(items);
var details = lstTrackingDetail.Where(n => n.StoregeJPId == items.Id);
foreach (var item in details)
{
db.TrackingDetails.Add(item);
var itemstores = lstStorageItemJP.Where(n => n.TrackingDetailId == item.Id);
foreach (var store in itemstores)
{
db.StorageItemJPs.Add(store);
}
}
}
db.SaveChanges();
return(View());
}
public ActionResult StorageJP(Guid id, string fileName = "")
{
var StorageJP = db.StorageJPs.Find(id);
//upload file
HttpPostedFileBase file = Request.Files[0];
fileName = file.FileName.DoiTenFile();
file.SaveAs(Server.MapPath("~/Uploads/StorageJP/" + fileName));
//read file
// Opening the Excel template...
FileStream fs = new FileStream(Server.MapPath("~/Uploads/StorageJP/" + fileName), FileMode.Open, FileAccess.Read);
// Getting the complete workbook...
ISheet sheet = null;
if (fileName.Contains(".xlsx"))
{
XSSFWorkbook templateWorkbook = new XSSFWorkbook(Server.MapPath("~/Uploads/StorageJP/" + fileName));
sheet = templateWorkbook.GetSheet("例");
}
else if (fileName.Contains(".xls"))
{
HSSFWorkbook templateWorkbook = new HSSFWorkbook(fs, true);
sheet = templateWorkbook.GetSheet("例");
}
//read excel
WebsiteHelpers websiteHelper = new WebsiteHelpers();
List <StorageItemJP> lstStorageItemJP = new List <StorageItemJP>();
List <TrackingDetail> lstTrackingDetail = new List <TrackingDetail>();
Guid IdTracking = Guid.NewGuid();
#region read excel
//check column
string urlReport = ConfigurationManager.AppSettings["url_report_storejp"];
for (int row = 4; row <= sheet.LastRowNum; row++)
{
double price = 0;
try
{
price = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "GIA")).NumericCellValue;
}
catch (Exception ex) { }
string subcode = "";
try
{
subcode = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "SO KIEN")).StringCellValue;
try
{
subcode = int.Parse(subcode).ToString("00");
}
catch (Exception ex) { }
}
catch (Exception ex) { subcode = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "SO KIEN")).NumericCellValue.ToString("00"); }
if (price == 0 && subcode != "")
{
IdTracking = Guid.NewGuid();
TrackingDetail detail = new TrackingDetail()
{
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
Id = IdTracking,
StoregeJPId = StorageJP.Id,
Weigh = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "KG")).NumericCellValue,
UpdatedAt = DateTime.Now,
UpdatedBy = user.Staff.UserName,
StatusId = StorageJP.StatusId,
TrackingSubCode = subcode
};
lstTrackingDetail.Add(detail);
}
else if (price != 0)
{
string namejp = "";
string linkweb = ""; string ImageUrl = "";
string ImageBase64 = null;
try
{
namejp = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "TEN HANG_JP")).CellFormula;
namejp = namejp.Replace("HYPERLINK(", "").Replace(")", "").Replace("\"", "");
linkweb = namejp.Split(',')[0];
namejp = namejp.Split(',')[1];
}
catch (Exception ex)
{
namejp = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "TEN HANG_JP")).StringCellValue;
linkweb = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "WEBLINK")).StringCellValue;
}
if (linkweb.ToLower().Contains(urlReport.ToLower()))
{
string idItem = linkweb.Split('/')[linkweb.Split('/').Length - 1];
try
{
var item = db.StorageItemJPs.Find(Guid.Parse(idItem));
ImageBase64 = item.ImageBase64;
linkweb = item.LinkWeb;
ImageUrl = item.ImageLinkWeb;
}
catch (Exception ex) { }
}
else
{
try
{
ImageUrl = websiteHelper.GetImage(linkweb);
ImageBase64 = ImageUtils.Images(ImageUrl);
}
catch (Exception ex) { }
}
string component = "", material = "", JanCode = "";
try
{
component = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "THANH PHAN")).StringCellValue;
}
catch (Exception ex) { }
try
{
material = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "CHAT LIEU")).StringCellValue;
}
catch (Exception ex) { }
try
{
JanCode = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Jancode,mavach")).StringCellValue;
}
catch (Exception ex) { JanCode = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "Jancode,mavach")).NumericCellValue + ""; }
StorageItemJP storejpItem = new StorageItemJP()
{
Amount = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "THANH TIEN")).NumericCellValue,
CategoryId = getCategory(sheet.GetRow(row).GetCell(getIndexColumn(sheet, "LOAI HANG")).StringCellValue).Id,
CategoryName = getCategory(sheet.GetRow(row).GetCell(getIndexColumn(sheet, "LOAI HANG")).StringCellValue).Name,
Component = component,
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
CreatedBy = user.Staff.UserName,
ImageBase64 = ImageBase64,
ImageLinkWeb = ImageUrl,
JanCode = JanCode,
Material = material,
LinkWeb = linkweb,
MadeIn = getMadeIn(sheet.GetRow(row).GetCell(getIndexColumn(sheet, "XUAT XU")).StringCellValue).Id + "",
NameEN = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "TEN HANG_EN")).StringCellValue,
NameJP = namejp,
PriceTax = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "GIA")).NumericCellValue,
ProductCode = "",
Quantity = sheet.GetRow(row).GetCell(getIndexColumn(sheet, "SO LUONG")).NumericCellValue,
UpdatedAt = DateTime.Now,
StoregeJPId = StorageJP.Id,
UpdatedBy = user.Staff.UserName,
TrackingDetailId = IdTracking
};
lstStorageItemJP.Add(storejpItem);
}
}
#endregion
//delete all data form db
var details = StorageJP.TrackingDetails.ToList();
foreach (var item in details)
{
var stores = item.StorageItemJPs.ToList();
foreach (var st in stores)
{
db.StorageItemJPs.Remove(st);
}
db.TrackingDetails.Remove(item);
}
//Insert database
foreach (var item in lstTrackingDetail)
{
db.TrackingDetails.Add(item);
foreach (var store in lstStorageItemJP.Where(n => n.TrackingDetailId == item.Id))
{
db.StorageItemJPs.Add(store); db.SaveChanges();
}
}
db.SaveChanges();
return(View());
}
public int CheckItemCountOneColumn(StorageItemJP store, string type = "nameen")
{
int i = 0;
switch (type)
{
case "namejp":
{
if (store.NameJP == null || store.NameJP == "")
{
i += 1;
}
else
{
foreach (var item in keyJP.ToUpper().Split(','))
{
if (store.NameJP.ToUpper().Contains(item))
{
i += 1; break;
}
}
}
break;
}
case "nameen":
{
if (store.NameEN == null || store.NameEN == "")
{
i += 1;
}
else
{
foreach (var item in keyJP.ToUpper().Split(','))
{
if (store.NameEN.ToUpper().Contains(item))
{
i += 1; break;
}
}
}
break;
}
case "category":
{
if (store.CategoryId == null)
{
return(i += 1);
}
break;
}
case "image":
{
if (store.ImageBase64 == "" || store.ImageBase64 == null)
{
return(i += 1);
}
break;
}
case "jancode":
{
if (store.JanCode != null && store.JanCode != "")
{
if (store.JanCode.StartsWith("4") == false)
{
i += 1;
}
else
{
if (store.JanCode.Length != 13)
{
i += 1;
}
else
{
if (store.MadeIn != null && store.MadeIn == "108")
{
if (store.JanCode.StartsWith("450") == false)
{
if (store.JanCode.StartsWith("451") == false)
{
if (store.JanCode.StartsWith("452") == false)
{
if (store.JanCode.StartsWith("453") == false)
{
if (store.JanCode.StartsWith("454") == false)
{
if (store.JanCode.StartsWith("455") == false)
{
if (store.JanCode.StartsWith("456") == false)
{
if (store.JanCode.StartsWith("457") == false)
{
if (store.JanCode.StartsWith("458") == false)
{
if (store.JanCode.StartsWith("459") == false)
{
if (store.JanCode.StartsWith("490") == false)
{
if (store.JanCode.StartsWith("491") == false)
{
if (store.JanCode.StartsWith("492") == false)
{
if (store.JanCode.StartsWith("493") == false)
{
if (store.JanCode.StartsWith("494") == false)
{
if (store.JanCode.StartsWith("495") == false)
{
if (store.JanCode.StartsWith("496") == false)
{
if (store.JanCode.StartsWith("497") == false)
{
if (store.JanCode.StartsWith("498") == false)
{
if (store.JanCode.StartsWith("499") == false)
{
i += 1;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
break;
}
case "quantity":
{
if (store.Quantity <= 0 || store.Quantity == null)
{
i += 1;
}
break;
}
case "price":
{
if (store.PriceTax <= 0 || store.PriceTax == null || store.PriceTax < 50)
{
i += 1;
}
break;
}
case "linkweb":
{
if (store.LinkWeb == "" || store.LinkWeb == null)
{
return(i += 1);
}
break;
}
case "madein":
{
if (store.MadeIn == null || store.MadeIn == "")
{
return(i += 1);
}
break;
}
}
return(i);
}
public string CheckJanCode(StorageItemJP store)
{
if (store.JanCode != null && store.JanCode != "")
{
if (store.JanCode.StartsWith("4") == false)
{
return("item-deny");
}
else
{
if (store.JanCode.Length != 13)
{
return("item-deny");
}
else
{
if (store.MadeIn != null && store.MadeIn == "108")
{
if (store.JanCode.StartsWith("450") == false)
{
if (store.JanCode.StartsWith("451") == false)
{
if (store.JanCode.StartsWith("452") == false)
{
if (store.JanCode.StartsWith("453") == false)
{
if (store.JanCode.StartsWith("454") == false)
{
if (store.JanCode.StartsWith("455") == false)
{
if (store.JanCode.StartsWith("456") == false)
{
if (store.JanCode.StartsWith("457") == false)
{
if (store.JanCode.StartsWith("458") == false)
{
if (store.JanCode.StartsWith("459") == false)
{
if (store.JanCode.StartsWith("490") == false)
{
if (store.JanCode.StartsWith("491") == false)
{
if (store.JanCode.StartsWith("492") == false)
{
if (store.JanCode.StartsWith("493") == false)
{
if (store.JanCode.StartsWith("494") == false)
{
if (store.JanCode.StartsWith("495") == false)
{
if (store.JanCode.StartsWith("496") == false)
{
if (store.JanCode.StartsWith("497") == false)
{
if (store.JanCode.StartsWith("498") == false)
{
if (store.JanCode.StartsWith("499") == false)
{
return("item-deny");
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
return("");
}
public int CheckItemCount(StorageItemJP store)
{
int i = 0;
if (store.NameEN == null)
{
store.NameEN = "";
}
if (store.JanCode != null && store.JanCode != "")
{
if (store.JanCode.StartsWith("4") == false)
{
i += 1;
}
else
{
if (store.JanCode.Length != 13)
{
i += 1;
}
else
{
if (store.MadeIn != null && store.MadeIn == "108")
{
if (store.JanCode.StartsWith("450") == false)
{
if (store.JanCode.StartsWith("451") == false)
{
if (store.JanCode.StartsWith("452") == false)
{
if (store.JanCode.StartsWith("453") == false)
{
if (store.JanCode.StartsWith("454") == false)
{
if (store.JanCode.StartsWith("455") == false)
{
if (store.JanCode.StartsWith("456") == false)
{
if (store.JanCode.StartsWith("457") == false)
{
if (store.JanCode.StartsWith("458") == false)
{
if (store.JanCode.StartsWith("459") == false)
{
if (store.JanCode.StartsWith("490") == false)
{
if (store.JanCode.StartsWith("491") == false)
{
if (store.JanCode.StartsWith("492") == false)
{
if (store.JanCode.StartsWith("493") == false)
{
if (store.JanCode.StartsWith("494") == false)
{
if (store.JanCode.StartsWith("495") == false)
{
if (store.JanCode.StartsWith("496") == false)
{
if (store.JanCode.StartsWith("497") == false)
{
if (store.JanCode.StartsWith("498") == false)
{
if (store.JanCode.StartsWith("499") == false)
{
i += 1;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
if (store.NameJP == null || store.NameJP == "")
{
i += 1;
}
else
{
foreach (var item in keyJP.ToUpper().Split(','))
{
if (store.NameJP.ToUpper().Contains(item))
{
i += 1; break;
}
}
}
if (store.NameEN == null || store.NameEN == "")
{
i += 1;
}
else
{
foreach (var item in keyJP.ToUpper().Split(','))
{
if (store.NameEN.ToUpper().Contains(item))
{
i += 1; break;
}
}
}
if (store.Quantity <= 0 || store.Quantity == null)
{
i += 1;
}
if (store.PriceTax <= 0 || store.PriceTax == null || store.PriceTax < 50)
{
i += 1;
}
if (store.LinkWeb == "" || store.LinkWeb == null)
{
i += 1;
}
if (store.ImageBase64 == "" || store.ImageBase64 == null)
{
i += 1;
}
if (store.CategoryId == null)
{
i += 1;
}
if (store.MadeIn == null || store.MadeIn == "")
{
i += 1;
}
return(i);
}