public async Task <int> UpdateOrderDetailStatus(OrderStatusHistory obj)
{
try
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@OrderStatusHistoryId", obj.OrderStatusHistoryId);
parameters.Add("@OrderDetailsID", obj.OrderDetailsID);
parameters.Add("@OrderStatusId", obj.OrderStatusId);
parameters.Add("@CreatedDate", obj.CreatedDate);
parameters.Add("@CreatedBy", obj.CreatedBy);
parameters.Add("@OrderId", obj.OrderId);
parameters.Add("@SetNo", obj.SetNo);
parameters.Add("@ProductId", obj.ProductId);
if (obj.OrderStatusId == 3)
{
parameters.Add("@TransportID", obj.TransportID);
parameters.Add("@DispatchDate", obj.DispatchDate);
parameters.Add("@Bilty", obj.Bilty);
}
var res = await SqlMapper.ExecuteAsync(con, "p_OrderStatusHistory_ins", param : parameters, commandType : StoredProcedure);
return(Convert.ToInt32(res));
}
catch (Exception ex)
{
throw (ex);
}
}
public string CreateOrderFromCart(Order order)
{
var autoNumber = context.AutoNumbers.FirstOrDefault(num => num.FormCode == "Order" && num.Year == DateTime.Today.Year) ??
new AutoNumber {
FormCode = "Order", Year = DateTime.Today.Year, LastNumber = 0
};
if (autoNumber.LastNumber == 0)
{
context.Add(autoNumber);
}
autoNumber.LastNumber++;
context.Add(order);
string prefix = String.Empty;
order.OrderNo = String.Format("{0}{1}{2}", prefix.RandomLetters(3).ToUpper(),
DateTime.Today.Year, autoNumber.LastNumber.ToString("00000"));
SetAuditFields(order);
var orderStatusHistory = new OrderStatusHistory();
orderStatusHistory.Order = order;
orderStatusHistory.IsActive = true;
orderStatusHistory.OrderStatusId = (int)OrderStatuses.Unpaid;
orderStatusHistory.CreatedBy = principal.Identity.Name;
orderStatusHistory.CreatedDate = DateTime.Now;
orderStatusHistory.EffectiveDate = DateTime.Today;
context.Add(orderStatusHistory);
context.SaveChanges();
return(order.OrderNo);
}
public void SetStatusOrder(int orderId, int orderStatusId, string notes, bool sendMail)
{
var order = context.Orders.SingleOrDefault(o => o.Id == orderId);
if (order != null)
{
order.OrderStatusId = orderStatusId;
var orderStatusHistory = new OrderStatusHistory();
orderStatusHistory.OrderId = orderId;
orderStatusHistory.IsActive = true;
orderStatusHistory.Notes = notes;
orderStatusHistory.SendMail = sendMail;
orderStatusHistory.OrderStatusId = orderStatusId;
orderStatusHistory.CreatedBy = principal.Identity.Name;
orderStatusHistory.EffectiveDate = DateTime.Today;
orderStatusHistory.CreatedDate = DateTime.Now;
context.Add(orderStatusHistory);
context.SaveChanges();
}
}
public Task <int> UpdateOrderDetailStatus(OrderStatusHistory obj)
{
return(_OrderRepository.UpdateOrderDetailStatus(obj));
}
