// Verify the data from excel file exists or not
private string VerifyDuplicatedData(int iCount, DataRow row)
{
iCount = iCount + 1;
StringBuilder returnResult = new StringBuilder();
StringBuilder verifiedResult = new StringBuilder();
verifiedResult.Append("Row#").Append(iCount.ToString()).Append(":");
int iLen = verifiedResult.ToString().Length;
// Check whether the StockCode is duplicate or not
//string sql = @"STKCODE = '" + Utility.VerifyQuotes(row[colSTKCode].ToString().Trim()) + "' AND APPENDIX1 = '" + Utility.VerifyQuotes(row[colAppendix1].ToString().Trim())
// + "' AND APPENDIX2 = '" + Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()) + "' AND APPENDIX3 = '" + Utility.VerifyQuotes(row[colAppendix3].ToString().Trim()) + "'";
//RT2020.DAL.Product oStockItem = RT2020.DAL.Product.LoadWhere(sql);
//if (oStockItem != null)
if (ProductHelper.IsDuplicated(
Utility.VerifyQuotes(row[colSTKCode].ToString().Trim()),
Utility.VerifyQuotes(row[colAppendix1].ToString().Trim()),
Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()),
Utility.VerifyQuotes(row[colAppendix3].ToString().Trim())))
{
returnResult.Append("Duplicated Stock Code;");
}
// Appendix1
//sql = "Appendix1Code = '" + Utility.VerifyQuotes(row[colAppendix1].ToString().Trim()) + "'";
//ProductAppendix1 oApp1 = ProductAppendix1.LoadWhere(sql);
//if (oApp1 != null)
if (ProductAppendix1Ex.IsAppendixCodeInUse(Utility.VerifyQuotes(row[colAppendix3].ToString())))
{
verifiedResult.Append(colAppendix1).Append(";");
}
// Appendix2
//sql = "Appednix2Code = '" + Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()) + "'";
//ProductAppendix2 oApp2 = ProductAppendix2.LoadWhere(sql);
//if (oApp2 != null)
if (ProductAppendix2Ex.IsAppendixCodeInUse(Utility.VerifyQuotes(row[colAppendix3].ToString())))
{
verifiedResult.Append(colAppendix2).Append(";");
}
// Appendix3
//sql = "Appendix3Code = '" + Utility.VerifyQuotes(row[colAppendix3].ToString().Trim()) + "'";
//ProductAppendix3 oApp3 = ProductAppendix3.LoadWhere(sql);
//if (oApp3 != null)
if (ProductAppendix3Ex.IsAppendixCodeInUse(Utility.VerifyQuotes(row[colAppendix3].ToString())))
{
verifiedResult.Append(colAppendix3).Append(";");
}
// Class1
//sql = "Class1Code = '" + Utility.VerifyQuotes(row[colClass1].ToString().Trim()) + "'";
//ProductClass1 oCls1 = ProductClass1.LoadWhere(sql);
//if (oCls1 != null)
if (ProductClass1Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass1].ToString().Trim())))
{
verifiedResult.Append(colClass1).Append(";");
}
// Class2
//sql = "Class2Code = '" + Utility.VerifyQuotes(row[colClass2].ToString().Trim()) + "'";
//ProductClass2 oCls2 = ProductClass2.LoadWhere(sql);
//if (oCls2 != null)
if (ProductClass2Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass2].ToString().Trim())))
{
verifiedResult.Append(colClass2).Append(";");
}
// Class3
//sql = "Class3Code = '" + Utility.VerifyQuotes(row[colClass3].ToString().Trim()) + "'";
//ProductClass3 oCls3 = ProductClass3.LoadWhere(sql);
//if (oCls3 != null)
if (ProductClass3Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass3].ToString().Trim())))
{
verifiedResult.Append(colClass3).Append(";");
}
// Class4
//sql = "Class4Code = '" + Utility.VerifyQuotes(row[colClass4].ToString().Trim()) + "'";
//ProductClass4 oCls4 = ProductClass4.LoadWhere(sql);
//if (oCls4 != null)
if (ProductClass4Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass4].ToString().Trim())))
{
verifiedResult.Append(colClass4).Append(";");
}
// Class5
//sql = "Class5Code = '" + Utility.VerifyQuotes(row[colClass5].ToString().Trim()) + "'";
//ProductClass5 oCls5 = ProductClass5.LoadWhere(sql);
//if (oCls5 != null)
if (ProductClass5Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass5].ToString().Trim())))
{
verifiedResult.Append(colClass5).Append(";");
}
// Class6
//sql = "Class6Code = '" + Utility.VerifyQuotes(row[colClass6].ToString().Trim()) + "'";
//ProductClass6 oCls6 = ProductClass6.LoadWhere(sql);
//if (oCls6 != null)
if (ProductClass6Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass6].ToString().Trim())))
{
verifiedResult.Append(colClass6).Append(";");
}
// Barcode
var barcode = Utility.VerifyQuotes(row[colSTKCode].ToString().Trim()) + Utility.VerifyQuotes(row[colAppendix1].ToString().Trim()) + Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()) + Utility.VerifyQuotes(row[colAppendix3].ToString().Trim());
var sql = "BARCODE = '" + barcode + "'";
if (ProductBarcodeEx.IsBarcodeInUse(barcode))
{
returnResult.Append("Duplicated Barcode;");
}
if (verifiedResult.ToString().Length > iLen)
{
duplicatedRec.Add(verifiedResult.ToString());
}
return(returnResult.ToString());
}
private void CheckBarcode()
{
int barcodeLen = 22;
bool isValid = false;
if (string.IsNullOrEmpty(txtBarcode.Text))
{
errorProvider.SetError(txtBarcode, "Can not be blank!");
}
else
{
if (txtBarcode.Text.Length > barcodeLen)
{
errorProvider.SetError(txtBarcode, "Invalid Barcode Length!");
}
else if (cboBarcodeType.Text.Length == 0)
{
errorProvider.SetError(cboBarcodeType, "Cannot be blank!");
}
else
{
errorProvider.SetError(txtBarcode, string.Empty);
errorProvider.SetError(cboBarcodeType, string.Empty);
isValid = true;
}
}
if (isValid)
{
string sql = "ProductId = '" + this.ProductId.ToString() + "' AND Barcode = '" + txtBarcode.Text.Trim() + "'";
//ProductBarcode oBarcode = ProductBarcode.LoadWhere(sql);
if (ProductBarcodeEx.IsBarcodeInUse(this.ProductId, txtBarcode.Text.Trim()))
{
errorProvider.SetError(txtBarcode, "Barcode Already Exists");
}
else
{
errorProvider.SetError(txtBarcode, string.Empty);
}
if (string.IsNullOrEmpty(errorProvider.GetError(txtBarcode)))
{
//Verify type and check digit
switch (cboBarcodeType.SelectedItem.ToString())
{
case "INTERNAL (128B)": // INTERNAL (128B)
txtBarcode.Text = Utility.VerifyQuotes(txtBarcode.Text);
if (txtBarcode.Text.Length > 22)
{
errorProvider.SetError(txtBarcode, "The length of Barcode(INTERNAL (128B)) must be <= 22!");
}
else
{
errorProvider.SetError(txtBarcode, string.Empty);
}
break;
case "EAN8": // EAN8 (GTIN-8)
if (txtBarcode.Text.Length != 8)
{
errorProvider.SetError(txtBarcode, "The length of Barcode(EAN8) must be 8!");
}
else if (!VerifyBarcodeNumber(txtBarcode.Text))
{
errorProvider.SetError(txtBarcode, "Barcode(EAN8) must be Numeric Only!");
}
else if (!VerifyBarcodeCheckDigit(txtBarcode.Text))
{
errorProvider.SetError(txtBarcode, "The Check Digit of Barcode(EAN8) is Not Valid!");
}
else
{
errorProvider.SetError(txtBarcode, string.Empty);
}
break;
case "EAN13": // EAN13 (GTIN-13)
if (txtBarcode.Text.Length != 13)
{
errorProvider.SetError(txtBarcode, "The length of Barcode(EAN13) must be 13!");
}
else if (!VerifyBarcodeNumber(txtBarcode.Text))
{
errorProvider.SetError(txtBarcode, "Barcode(EAN13) must be Numeric Only!");
}
else if (!VerifyBarcodeCheckDigit(txtBarcode.Text))
{
errorProvider.SetError(txtBarcode, "The Check Digit of Barcode(EAN13) is Not Valid!");
}
else
{
errorProvider.SetError(txtBarcode, string.Empty);
}
break;
case "UPC12": // UPC12 (GTIN-12)
if (txtBarcode.Text.Length != 12)
{
errorProvider.SetError(txtBarcode, "The length of Barcode(UPC12) must be 12!");
}
else if (!VerifyBarcodeNumber(txtBarcode.Text))
{
errorProvider.SetError(txtBarcode, "Barcode(UPC12) must be Numeric Only!");
}
else if (!VerifyBarcodeCheckDigit(txtBarcode.Text))
{
errorProvider.SetError(txtBarcode, "The Check Digit of Barcode(UPC12) is Not Valid!");
}
else
{
errorProvider.SetError(txtBarcode, string.Empty);
}
break;
}
}
}
}