private void ImportData() { //MessageBox.Show(chkAutoGenerateBarcode.Checked.ToString()); //MessageBox.Show(chkSetRetailItem.Checked.ToString()); //MessageBox.Show(chkAutoCreate.Checked.ToString()); int iErrCount = 0; StockCodeList oList = dgvTempStockCodeList.DataSource as StockCodeList; for (int i = 0; i < oList.Count; i++) { if (string.IsNullOrEmpty(oList[i].Status)) { // Class/Appendix System.Guid a1Id = ImportAppendix1(oList[i].Season); System.Guid a2Id = ImportAppendix2(oList[i].Color); System.Guid a3Id = ImportAppendix3(oList[i].Size); System.Guid c1Id = ImportClass1(oList[i].Vendor); System.Guid c2Id = ImportClass2(oList[i].Gender); System.Guid c3Id = ImportClass3(oList[i].Collection); System.Guid c4Id = ImportClass4(oList[i].Group); System.Guid c5Id = ImportClass5(oList[i].Category); System.Guid c6Id = ImportClass6(oList[i].SubCat); // Product System.Guid productId = ImportProduct(oList[i]); ImportProductSupplement(productId, oList[i]); ImportProductCode(productId, a1Id, a2Id, a3Id, c1Id, c2Id, c3Id, c4Id, c5Id, c6Id); ImportProductRemarks(productId, oList[i]); ImportProductPrice(productId, oList[i]); // Generate Barcode if (chkAutoGenerateBarcode.Checked) { ImportProductBarcode(productId, oList[i]); } } else { iErrCount++; } if (i == (oList.Count - 1)) { if (iErrCount == 0) { MessageBox.Show("Success!", "Import Result"); } else { int succeedCount = oList.Count - iErrCount; MessageBox.Show(succeedCount.ToString() + " Succeed! " + iErrCount.ToString() + " Failed!", "Import Result"); } } } }
private void AddStockCodeToList(int iCount, string status, DataRow row, ref StockCodeList oList) { oList.Add(new StockCodeRec( iCount, status, Utility.VerifyQuotes(row[colClass1].ToString()), Utility.VerifyQuotes(row[colClass2].ToString()), Utility.VerifyQuotes(row[colClass3].ToString()), Utility.VerifyQuotes(row[colClass4].ToString()), Utility.VerifyQuotes(row[colClass5].ToString()), Utility.VerifyQuotes(row[colClass6].ToString()), row[colDESC].ToString(), Utility.VerifyQuotes(row[colSTKCode].ToString()), Utility.VerifyQuotes(row[colAppendix1].ToString()), Utility.VerifyQuotes(row[colAppendix2].ToString()), Utility.VerifyQuotes(row[colAppendix3].ToString()), row[colBasicPrice].ToString(), row[colVendorCurrency].ToString(), row[colVendorPrice].ToString(), row[colMEMO].ToString(), row[colPHOTO].ToString())); }
private StockCodeList GetStockList() { StockCodeList oList = new StockCodeList(); DataTable oTable = GetData(); if (oTable.Rows.Count > 0) { for (int iCount = 0; iCount < oTable.Rows.Count; iCount++) { DataRow row = oTable.Rows[iCount]; int rowNum = iCount + 1; if (!VerifyEmptyData(rowNum, row)) { string status = VerifyDataFieldSize(rowNum, row); //status += VerifyDuplicatedData(rowNum, row); AddStockCodeToList(rowNum, status, row, ref oList); } } } return(oList); }