public List<Guid> SaveToLocal(OrderExportDocument document,TransactionType type)
{
var savedIds = new List<Guid>();
var result = 0;
using (var db=new AlidiLocalImportDatabaseContext())
{
//Find if the ExternalRef is present in local db so that we can mark it as exported in hq,
//So that it is never exported again
if(db.TransactionImports.Any(p=>p.ExternalRef==document.ExternalRef))
{
var confirmListBypass = new List<Guid>();
confirmListBypass.Add(Guid.NewGuid());
return confirmListBypass;
}
foreach (var lineItem in document.LineItems)
{
var id = Guid.NewGuid();
var transactionImport = new TransactionImport();
transactionImport.Id = id;
transactionImport.OutletCode = document.OutletCode;
transactionImport.OutletName = document.OutletName;
transactionImport.ExternalRef = document.ExternalRef;
transactionImport.GenericRef = document.OrderRef;
//var date = Convert.ToDateTime(document.OrderDate);
//var date2 = DateTime.Parse(document.OrderDate);
transactionImport.TransactionIssueDate = document.OrderDate;
transactionImport.TransactionDueDate = document.OrderDueDate;
transactionImport.TransactionType = (int)type;
//LineItems
transactionImport.ProductCode = lineItem.ProductCode;
transactionImport.Quantity = lineItem.Quantity;
transactionImport.TotalNet = lineItem.LineItemTotalNet;
transactionImport.TotalVat = lineItem.VatPerUnit;
transactionImport.VatClass = lineItem.VatClass;
transactionImport.SalesmanCode = document.SalesmanCode;
transactionImport.LineItemValue = lineItem.Price;
transactionImport.ExportStatus=(int)ExportStatus.New;
db.TransactionImports.Add(transactionImport);
savedIds.Add(id);
}
result=db.SaveChanges();
}
if (result > 0)
{
return savedIds;
}
return null;
}
public void SaveToQuickBooks(TransactionImport transactionImport)
{
throw new NotImplementedException();
}
private OrderExportDocument Map(TransactionImport transactionImport)
{
throw new NotImplementedException();
}
