private void PassOrdersLeft()
{
Excel.Range range = monthlyExcelFile.ordersRange;
int length = ExcelUtil.GetLastRow(monthlyExcelFile.ordersRange.Worksheet);
for (int row = 2; row < length; row++)
{
if (IsAnyCellContainsValue(range, row))
{
OrderUtil.CheckOrderDesc(monthlyExcelFile.ordersRange, row);
ErrorUtil.IsInvoiceNumberOk(monthlyExcelFile.ordersRange, row, ColumnsOrder.InvoiceNumber);
ErrorUtil.CheckRecordType(monthlyExcelFile.ordersRange, row, RecordType.order);
OrderUtil.CheckReceivedAmount(monthlyExcelFile.ordersRange, row);
OrderUtil.CheckOrderNumber(monthlyExcelFile.ordersRange, row);
}
}
}
private bool AddOrder(int row)
{
if (!OrderUtil.CheckOrderDesc(monthlyExcelFile.ordersRange, row))
{
return(false);
}
Order order = new Order();
if (ErrorUtil.IsInvoiceNumberOk(monthlyExcelFile.ordersRange, row, ColumnsOrder.InvoiceNumber))
{
order.InvoiceNumber = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.InvoiceNumber);
}
else
{
return(false);
}
if (ErrorUtil.CheckRecordType(monthlyExcelFile.ordersRange, row, RecordType.order))
{
order.RecordType = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.RecordType);
}
if (OrderUtil.CheckReceivedAmount(monthlyExcelFile.ordersRange, row))
{
order.ReceivedAmount = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.RecivedAmount);
}
if (OrderUtil.CheckOrderNumber(monthlyExcelFile.ordersRange, row))
{
order.OrderNumber = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.OrderNumber);
}
order.StoreNumber = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.StoreNumber);
order.Date = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.Date);
order.EnteranceStampNum = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.EnteranceStampNum);
order.Discount = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.Discount);
order.DiscountPrecent = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.DiscountPrecent);
order.SaleDiscount = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.SaleDiscount);
order.SaleDiscountPrecent = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.SaleDiscountPrecent);
order.DistrbutionDiscount = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.DistrbutionDiscount);
order.DistrbutionDiscountPrecent = ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.DistrbutionDiscountPrecent);
Excel.Range cell = monthlyExcelFile.linesRange.Find(order.InvoiceNumber.TrimStart());
int cellRow;
int nextsRow = 1;
if (cell != null)
{
cellRow = cell.Row;
if (ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.OrderDesc).TrimStart()
== ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, cell.Row, ColumnsLines.OrderDesc).TrimStart())
{
AddLine(order, cell.Row);
}
cell = monthlyExcelFile.linesRange.Find(order.InvoiceNumber.TrimStart());
nextsRow = cell.Row;
while (cellRow != nextsRow)
{
cell = monthlyExcelFile.linesRange.FindNext(cell);
if (cell != null)
{
nextsRow = cell.Row;
if (ExcelUtil.GetStringValue(monthlyExcelFile.ordersRange, row, ColumnsOrder.OrderDesc).TrimStart()
== ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, cell.Row, ColumnsLines.OrderDesc).TrimStart())
{
AddLine(order, cell.Row);
}
}
}
}
if (order.Lines.Count < 1)
{
ErrorUtil.FinallizeErrorAndAdd(new Error {
Issue = "לא נמצאו שורות להזמנה"
}, row: 1, column: 1, range: monthlyExcelFile.linesRange);
return(false);
}
Invoice.GetInstance().AddOrder(order);
recordsToBeDeleted.Add(new RecordToBeDeleted {
Record = row, Sheet = Sheets.OrdersSheetNumber
});
return(true);
}
