public bool SaveReportCombination(OrderDto dto, OrderDetailDto orderDetailDto, string orderTypeAbbrev, string remarksType = null)
{
var productList = _inventoryService.FindByProductId((int)orderDetailDto.ProductId);
ReportCombinationDto reportDto = new ReportCombinationDto()
{
TrackingID = 0,
ProductID = (long)orderDetailDto.ProductId,
RequestNum = dto.OrderNum,
DateCreated = System.DateTime.Now,
ProductQty = productList.Quantity,
Qty = orderDetailDto.Quantity,
BranchId = productList.BranchID
};
if (orderTypeAbbrev == Enums.OrderTypeAbbrev.SO.ToString())
{
reportDto.RequestType = Enums.OrderTypeAbbrev.SO.ToString();
//reportDto.SalesOrderQty = (productList.Quantity - orderDetailDto.Quantity);
reportDto.SalesOrderQty = orderDetailDto.Quantity;
}
else if (orderTypeAbbrev == Enums.OrderTypeAbbrev.PO.ToString())
{
reportDto.RequestType = Enums.OrderTypeAbbrev.PO.ToString();
if (!orderDetailDto.isNewPurchaseOrder)
{
//reportDto.PurchaseOrderQty = (productList.Quantity + orderDetailDto.Quantity);
reportDto.PurchaseOrderQty = orderDetailDto.Quantity;
}
else
{
reportDto.PurchaseOrderQty = orderDetailDto.Quantity;
}
}
else if (orderTypeAbbrev == Enums.OrderTypeAbbrev.CR.ToString())
{
reportDto.RequestType = Enums.OrderTypeAbbrev.CR.ToString();
reportDto.Remarks = dto.Remarks;
if (remarksType == "+")
{
//reportDto.PurchaseOrderQty = (productList.Quantity + orderDetailDto.Quantity);
reportDto.PurchaseOrderQty = (orderDetailDto.Quantity);
}
else if (remarksType == "-")
{
//reportDto.SalesOrderQty = (productList.Quantity - orderDetailDto.Quantity);
reportDto.SalesOrderQty = (orderDetailDto.Quantity);
}
}
if (_reportCombination.Insert(reportDto.DtoToEntity()).IsNull())
{
return(false);
}
return(true);
}
public long SaveSalesOrder(OrderDto dto)
{
this.salesOrder = dto.DtoToEntitySalesOrder();
if (_salesOrder.Insert(this.salesOrder).IsNull())
{
return(0);
}
return(this.salesOrder.SalesOrderID);
}
public long SavePurchaseOrder(OrderDto dto)
{
this.purchaseOrder = dto.DtoToEntityPurchaseOrder();
if (_purchaseOrder.Insert(this.purchaseOrder).IsNull())
{
return(0);
}
return(this.purchaseOrder.PurchaseOrderID);
}
public bool SavePurchaseOrderDetail(OrderDetailDto listDto)
{
this.purchaseOrderDetail = listDto.DtoToEntityPurchaseOrderDetail();
if (_purchaseOrderDetail.Insert(this.purchaseOrderDetail).IsNull())
{
return(false);
}
return(true);
}
//return results:
//result = 0 -> no error
//result = 1 -> system error
//result = 2 -> batch no error
//result = 3 -> bulk insert batchproductlog error
//result = 4 -> BATCH UPLOAD data message return <= 0
//result = 5 -> Successfully inserted ALL records
//result = 6 -> Successfully inserted but with errors
//result = 7 -> All records error
public int SaveBulkProducts(BatchSummariesDto dto, List <BatchProductLogDto> dtoList)
{
int result = 0;
if (!dto.IsNull())
{
this.batchSummary = dto.DtoToEntity();
var batchNoIdentity = _batchSummary.Insert(this.batchSummary).BatchNo;
if (!batchNoIdentity.IsNull() && batchNoIdentity <= 0)
{
result = 2;
}
else
{
if (!SaveProductBulk(dtoList, batchNoIdentity))
{
result = 3;
}
else
{
DataTable dtResultSet = new DataTable();
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "BatchNo", SqlValue = batchNoIdentity, SqlDbType = SqlDbType.BigInt
}
};
dtResultSet = _product.ExecuteSPReturnTable("uspBatchProductCreation", true, sqlParameters);
if (dtResultSet.Rows.Count <= 0)
{
result = 4;
}
else
{
if (dtResultSet.Rows[0][Globals.Result].ToString() == "5")
{
result = 0;
}
else if (dtResultSet.Rows[0][Globals.Result].ToString() == "6")
{
result = 6;
}
else if (dtResultSet.Rows[0][Globals.Result].ToString() == "7")
{
result = 7;
}
}
}
}
}
else
{
result = 1;
}
return(result);
}