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