public Error InsertOrUpdateProductLocation(ProductLocationModel productLocation, UserModel user, string lockGuid)
{
Error error = ValidateModel(productLocation);
if (!error.IsError)
{
// Check that the lock is still current
if (!db.IsLockStillValid(typeof(ProductLocation).ToString(), productLocation.Id, lockGuid))
{
error.SetError(EvolutionResources.errRecordChangedByAnotherUser, "LocationId");
}
else
{
ProductLocation temp = null;
if (productLocation.Id != 0)
{
temp = db.FindProductLocation(productLocation.Id);
}
if (temp == null)
{
temp = new ProductLocation();
}
Mapper.Map <ProductLocationModel, ProductLocation>(productLocation, temp);
db.InsertOrUpdateProductLocation(temp);
productLocation.Id = temp.Id;
}
}
return(error);
}
public ProductLocationModel FindProductLocationModel(CompanyModel company, ProductModel product, int locationId)
{
ProductLocationModel model = null;
var pl = db.FindProductLocation(company.Id, product.Id, locationId);
if (pl != null)
{
model = MapToModel(pl);
}
return(model);
}
public ProductLocationModel FindProductLocationModel(int id)
{
ProductLocationModel model = null;
var pl = db.FindProductLocation(id);
if (pl != null)
{
model = MapToModel(pl);
}
return(model);
}
private ProductLocationModel createProductLocation(CompanyModel company, ProductModel product,
LocationModel location, int qtyOnHand)
{
var model = new ProductLocationModel {
CompanyId = company.Id,
ProductId = product.Id,
LocationId = location.Id,
QuantityOnHand = qtyOnHand,
SellOnOrder = 0,
PurchaseOnOrder = 0
};
return(model);
}
public Error CompleteOrder(CompanyModel company, UserModel user, int purchaseOrderHeaderTempId)
{
// On entry, the order has already been saved back to the main tables
var error = new Error();
// Set the status of the order to closed
var poht = FindPurchaseOrderHeaderTempModel(purchaseOrderHeaderTempId, company, false);
if (poht == null)
{
error.SetRecordError("PurchaseOrderHeaderTemp", purchaseOrderHeaderTempId);
}
else
{
// Check if the order is already completed
var closedStatus = LookupService.FindPurchaseOrderHeaderStatusByValueModel(PurchaseOrderStatus.Closed).Id;
if (poht.POStatus == closedStatus)
{
error.SetError(EvolutionResources.errCantCloseAlreadyClosedPurchaseOrder);
}
else
{
// Lock the record (forces others to re-read)
string lgs = LockPurchaseOrderHeaderTemp(poht);
poht.POStatus = LookupService.FindPurchaseOrderHeaderStatusByValueModel(PurchaseOrderStatus.Closed).Id;
poht.CompletedDate = DateTimeOffset.Now;
error = InsertOrUpdatePurchaseOrderHeaderTemp(poht, user, lgs);
if (!error.IsError)
{
// Now get the main purchase order header
var poh = FindPurchaseOrderHeaderModel(poht.OriginalRowId, company, false);
if (poh != null)
{
// Lock it for writing
lgs = LockPurchaseOrderHeader(poh);
poh.POStatus = poht.POStatus;
poh.CompletedDate = poht.CompletedDate;
error = InsertOrUpdatePurchaseOrderHeader(poh, user, lgs);
if (!error.IsError)
{
// Move the allocations from received POs to existing stock
foreach (var allocation in db.FindAllocationsToPurchaseOrder(poh.Id)
.ToList())
{
allocation.PurchaseLineId = null;
db.InsertOrUpdateAllocation(allocation);
}
foreach (var orderLine in db.FindPurchaseOrderDetails(company.Id, poh.Id)
.ToList())
{
if (orderLine.ProductId != null)
{
var product = ProductService.FindProductModel(orderLine.ProductId.Value, null, null, false);
if (product != null)
{
// Set the QuantityOnHand in Product
double qtyOnHand = (product.QuantityOnHand == null ? 0 : product.QuantityOnHand.Value);
if (orderLine.OrderQty != null)
{
product.QuantityOnHand = qtyOnHand + orderLine.OrderQty.Value;
lgs = ProductService.LockProduct(product);
ProductService.InsertOrUpdateProduct(product, user, lgs);
}
// Set the QuantityOnHand in ItemLocation
var prodLocation = ProductService.FindProductLocationModel(company, product, poh.LocationId.Value);
if (prodLocation == null)
{
prodLocation = new ProductLocationModel {
CompanyId = company.Id,
ProductId = product.Id,
LocationId = poh.LocationId.Value,
QuantityOnHand = orderLine.OrderQty.Value,
SellOnOrder = 0,
PurchaseOnOrder = 0
};
}
else
{
prodLocation.QuantityOnHand += orderLine.OrderQty.Value;
}
lgs = ProductService.LockProductLocation(prodLocation);
ProductService.InsertOrUpdateProductLocation(prodLocation, user, lgs);
}
}
}
// Send the order to the Accounts system via the connector
AccountsConnector.AccountsConnector accountsConnector = new AccountsConnector.AccountsConnector(db);
error = accountsConnector.SendCompletedPurchaseOrderToAccounts(poh);
}
}
else
{
error.SetRecordError("PurchaseOrderHeader", poht.OriginalRowId);
}
}
}
}
return(error);
}
public string LockProductLocation(ProductLocationModel model)
{
return(db.LockRecord(typeof(ProductLocation).ToString(), model.Id));
}
public Error ValidateModel(ProductLocationModel model)
{
var error = new Error();
return(error);
}
