private bool SaveCustomerPrice(CustomerPriceDto dto)
{
bool isSuccess = false;
var customerPrices = _customerPriceService.GetAll().Where(cp => cp.ProductId == dto.ProductId && cp.CustomerId == dto.CustomerId).FirstOrDefault();
if (!customerPrices.IsNull())
{
if (_customerPriceService.DeleteDetails(dto.CustomerId, dto.ProductId))
{
if (_customerPriceService.SaveDetails(dto))
{
isSuccess = true;
}
}
}
else
{
if (_customerPriceService.SaveDetails(dto))
{
isSuccess = true;
}
}
return(isSuccess);
}
public bool SaveCustomerPrice(CustomerPriceDto customerPriceDetails)
{
this.customerprice = customerPriceDetails.DtoToEntity();
if (this._customerprice.Insert(this.customerprice).IsNull())
{
return(false);
}
return(true);
}
public bool UpdateCustomerPrice(CustomerPriceDto newCustomerPriceDetails)
{
var updatedCustomerPriceDetails = this.customerprice;
updatedCustomerPriceDetails = new CustomerPrice
{
CustomerPriceID = newCustomerPriceDetails.CustomerPriceId,
CustomerID = newCustomerPriceDetails.CustomerId,
Price = newCustomerPriceDetails.Price,
ProductID = newCustomerPriceDetails.ProductId
};
return(true);
}
public static IOBalanceEntity.CustomerPrice DtoToEntity(this CustomerPriceDto dto)
{
IOBalanceEntity.CustomerPrice entity = null;
if (!dto.IsNull())
{
entity = new IOBalanceEntity.CustomerPrice
{
CustomerID = dto.CustomerId,
Price = dto.Price,
ProductID = dto.ProductId
};
}
return(entity);
}
public virtual ActionResult SaveSalesOrder(List <SalesOrderListDto> dto, string SalesNo, int CustomerId)
{
bool isSuccess = false;
int createdBy = 1;
DateTime dateNow = DateTime.Now;
string alertMsg = string.Empty;
long salesOrderId = 0;
if (!dto.IsNull())
{
SalesOrderDto orderDto = new SalesOrderDto()
{
CreatedBy = createdBy,
DateCreated = dateNow,
SalesNo = SalesNo,
CustomerId = CustomerId,
SalesOrderId = 0,
IsPrinted = true,
IsCorrected = false
};
salesOrderId = _orderService.SaveSalesOrder(orderDto);
if (salesOrderId == 0)
{
alertMsg = "Error in inserting Order Id";
}
else
{
foreach (var oDetail in dto)
{
SalesOrderDetailDto orderDetailDto = new SalesOrderDetailDto()
{
SalesOrderId = salesOrderId,
ProductId = oDetail.ProductId,
SalesPrice = oDetail.SalesPrice,
Quantity = oDetail.Quantity,
UnitPrice = oDetail.UnitPrice,
DateCreated = dateNow,
CreatedBy = createdBy
};
_orderService.SaveSalesOrderDetail(orderDetailDto);
var productDetails = _inventoryService.GetAll().Where(p => p.ProductId == oDetail.ProductId).FirstOrDefault();
productDetails.Quantity = (productDetails.Quantity - oDetail.Quantity);
_inventoryService.UpdateDetails(productDetails);
CustomerPriceDto customerPriceDto = new CustomerPriceDto()
{
Price = oDetail.UnitPrice,
ProductId = oDetail.ProductId,
CustomerId = CustomerId,
CreatedBy = createdBy,
DateCreated = dateNow
};
SaveCustomerPrice(customerPriceDto);
}
isSuccess = true;
alertMsg = Messages.InsertSuccess;
}
}
var jsonResult = new
{
isSuccess = isSuccess,
alertMsg = alertMsg,
salesOrderId = salesOrderId,
customerId = CustomerId,
salesNo = SalesNo
};
return(Json(jsonResult, JsonRequestBehavior.AllowGet));
}
public virtual ActionResult QueueSalesOrder(List <SalesOrderListDto> dto, int CustomerId, long salesOrderId)
{
bool isSuccess = false;
int createdBy = 1;
DateTime dateNow = DateTime.Now;
string alertMsg = string.Empty;
if (!dto.IsNull())
{
var oldSalesOrderDto = _orderService.GetAllSalesOrder().Where(so => so.OrderId == salesOrderId).FirstOrDefault();
if (oldSalesOrderDto.IsNull())
{
alertMsg = "No queue order selected";
}
else
{
SalesOrderDto orderDto = new SalesOrderDto()
{
CreatedBy = createdBy,
DateCreated = dateNow,
SalesNo = oldSalesOrderDto.SalesNo,
CustomerId = oldSalesOrderDto.CustomerId,
SalesOrderId = salesOrderId,
IsPrinted = false,
IsCorrected = false
};
if (_orderService.UpdateSalesOrder(orderDto) <= 0)
{
alertMsg = "Error in updating queue order id";
}
else
{
if (!_orderService.DeleteAllSalesOrderDetail(salesOrderId))
{
alertMsg = "Error in deleting all queue order details";
}
else
{
foreach (var oDetail in dto)
{
SalesOrderDetailDto orderDetailDto = new SalesOrderDetailDto()
{
SalesOrderId = salesOrderId,
ProductId = oDetail.ProductId,
SalesPrice = oDetail.SalesPrice,
Quantity = oDetail.Quantity,
UnitPrice = oDetail.UnitPrice,
DateCreated = dateNow,
CreatedBy = createdBy
};
_orderService.SaveSalesOrderDetail(orderDetailDto);
var productDetails = _inventoryService.GetAll().Where(p => p.ProductId == oDetail.ProductId).FirstOrDefault();
productDetails.Quantity = (productDetails.Quantity - oDetail.Quantity);
_inventoryService.UpdateDetails(productDetails);
CustomerPriceDto customerPriceDto = new CustomerPriceDto()
{
Price = oDetail.UnitPrice,
ProductId = oDetail.ProductId,
CustomerId = CustomerId,
CreatedBy = createdBy,
DateCreated = dateNow
};
SaveCustomerPrice(customerPriceDto);
}
isSuccess = true;
alertMsg = Messages.UpdateSuccess;
}
}
}
}
var jsonResult = new
{
isSuccess = isSuccess,
alertMsg = alertMsg
};
return(Json(jsonResult, JsonRequestBehavior.AllowGet));
}
