public static bool CheckDate(Excel.Range range, int row)
{
int column = ColumnsInvoice.Date;
if (!ErrorUtil.IsEmptyCell(range, row, column))
{
return(true);
}
return(false);
}
public static bool CheckSupplierNumber(Excel.Range range, int row)
{
//Check suppllier number not empty
int column = ColumnsInvoice.SupplierNumber;
if (!ErrorUtil.IsEmptyCell(range, row, column))
{
return(true);
}
return(false);
}
public static bool CheckReceivedAmount(Excel.Range range, int row)
{
//Check Received Amount not empty
Error error = null;
int column = ColumnsOrder.RecivedAmount;
bool result = false;
if (ErrorUtil.IsEmptyCell(range, row, column))
{
return(false);
}
//check is float
try
{
if (range.Cells[row, column].Value2 is float)
{
result = true;
}
}
catch
{
error = new Error();
error.Issue = "לא מספר עשרוני";
error.CurrentValue = range.Cells[row, column].Value2.ToString();
ErrorUtil.FinallizeErrorAndAdd(error, row, column, range);
result = false;
}
//check is positive
if (range.Cells[row, column].Value2 < 0)
{
if (!ErrorUtil.IsEmptyCell(range, row, column))
{
error = new Error();
error.Issue = "שדה לא חיובי";
error.CurrentValue = range.Cells[row, column].Value2.ToString();
}
else
{
error.Issue += Environment.NewLine + "שדה לא חיובי";
}
ErrorUtil.FinallizeErrorAndAdd(error, row, column, range);
return(result);
}
return(false);
}
public static bool CheckTaxAmount(Excel.Range range, int row)
{
//Check Tax Amount not empty
Error error = null;
int column = ColumnsInvoice.TaxAmount;
if (ExcelUtil.GetStringValue(range, row, column) != "")
{
//check Tax Amount is positive
if (range.Cells[row, column].Value2 < 0)
{
error = new Error();
error.Issue = "שדה לא חיובי";
error.CurrentValue = range.Cells[row, column].Value2.ToString();
ErrorUtil.FinallizeErrorAndAdd(error, row, column, range);
return(false);
}
return(true);
}
return(false);
}
public static bool CheckRecordType(Excel.Range range, int row, string type)
{
Error error = null;
int column = 1; //recordType always on column 1
if (!ErrorUtil.IsEmptyCell(range, row, column))
{
string value = ExcelUtil.GetStringValue(range, row, column);
if (value != type)
{
error = new Error();
error.Issue = $"ערך הרשומה לא {type}";
error.CurrentValue = value;
FinallizeErrorAndAdd(error, row, column, range);
return(false);
}
return(true);
}
return(false);
}
public static bool CheckOrderNumber(Excel.Range range, int row)
{
//Check order not empty
Error error = null;
int column = ColumnsOrder.OrderNumber;
if (!ErrorUtil.IsEmptyCell(range, row, column))
{
//if orderNum length is not 8
if (range.Cells[row, column].Value2.ToString().Length != 8)
{
error = new Error();
error.Issue = "שדה לא מכיל 8 תווים";
error.CurrentValue = range.Cells[row, column].Value2.ToString();
ErrorUtil.FinallizeErrorAndAdd(error, row, column, range);
return(false);
}
return(true);
}
return(false);
}
public static bool CheckOrderDesc(Excel.Range range, int row)
{
//Check orderDesc not empty
Error error = null;
int column = ColumnsOrder.OrderDesc;
bool result = false;
if (!ErrorUtil.IsEmptyCell(range, row, column))
{
if (!checkIfContainsExactDigitNumber(range.Cells[row, column].Value2.ToString(), 3))
{
error = new Error();
error.Issue = "לא מכיל קוד נק' מכירה";
error.CurrentValue = range.Cells[row, column].Value2.ToString();
ErrorUtil.FinallizeErrorAndAdd(error, row, column, range);
result = false;
}
if (!checkIfContainsExactDigitNumber(range.Cells[row, column].Value2.ToString(), 9))
{
if (error == null)
{
error = new Error();
error.Issue = "לא מכיל מס' הזמנה";
error.CurrentValue = range.Cells[row, column].Value2.ToString();
}
else
{
error.Issue += Environment.NewLine + "לא מכיל מס' הזמנה";
}
ErrorUtil.FinallizeErrorAndAdd(error, row, column, range);
return(result);
}
return(true);
}
return(false);
}