/// <summary>
/// Create Purchase Order
/// </summary>
/// <param name="purchaseOrderDataTransformation"></param>
/// <returns></returns>
public async Task <ResponseModel <PurchaseOrderDataTransformation> > CreatePurchaseOrder(PurchaseOrderDataTransformation purchaseOrderDataTransformation)
{
ResponseModel <PurchaseOrderDataTransformation> returnResponse = new ResponseModel <PurchaseOrderDataTransformation>();
PurchaseOrder purchaseOrder = new PurchaseOrder();
try
{
_purchaseOrderManagementDataService.OpenConnection(_connectionStrings.PrimaryDatabaseConnectionString);
_purchaseOrderManagementDataService.BeginTransaction((int)IsolationLevel.Serializable);
PurchaseOrderNumberSequence purchaseOrderNumberSequence = await _purchaseOrderManagementDataService.GetPurchaseOrderNumberSequence(purchaseOrderDataTransformation.AccountId);
if (purchaseOrderNumberSequence == null)
{
purchaseOrderNumberSequence = new PurchaseOrderNumberSequence();
purchaseOrderNumberSequence.AccountId = purchaseOrderDataTransformation.AccountId;
purchaseOrderNumberSequence.PurchaseOrderNumber = 100000;
await _purchaseOrderManagementDataService.CreatePurchaseOrderNumberSequence(purchaseOrderNumberSequence);
}
else
{
purchaseOrderNumberSequence.PurchaseOrderNumber = purchaseOrderNumberSequence.PurchaseOrderNumber + 1;
await _purchaseOrderManagementDataService.UpdatePurchaseOrderNumberSequence(purchaseOrderNumberSequence);
}
purchaseOrder.PurchaseOrderNumber = purchaseOrderNumberSequence.PurchaseOrderNumber;
purchaseOrder.AccountId = purchaseOrderDataTransformation.AccountId;
purchaseOrder.SupplierId = purchaseOrderDataTransformation.SupplierId;
purchaseOrder.PurchaseOrderStatusId = PurchaseOrderStatuses.Open;
purchaseOrder.OrderTotal = 0.0;
await _purchaseOrderManagementDataService.CreatePurchaseOrder(purchaseOrder);
//await _purchaseOrderManagementDataService.UpdateDatabase();
_purchaseOrderManagementDataService.CommitTransaction();
returnResponse.ReturnStatus = true;
}
catch (Exception ex)
{
_purchaseOrderManagementDataService.RollbackTransaction();
returnResponse.ReturnStatus = false;
returnResponse.ReturnMessage.Add(ex.Message);
}
finally
{
_purchaseOrderManagementDataService.CloseConnection();
}
purchaseOrderDataTransformation.PurchaseOrderId = purchaseOrder.PurchaseOrderId;
returnResponse.Entity = purchaseOrderDataTransformation;
return(returnResponse);
}