public Order_Tracking GetOrderTracker(Order_Tracking ordertracking)
{
string fetchOrderTracker = $"SELECT * FROM Mobifix_DB.ORDER_TRACKING WHERE LOWER (ORDER_TRACKING_ID) = '{ ordertracking.OrderTrackingID.ToString() }'";
var dtResult = MySqlOrderTrackingHelper.ExecuteQuery(fetchOrderTracker);
var getordertracker = FillOrderTrackingModel(dtResult);
return(getordertracker.FirstOrDefault <Order_Tracking>());
}
public void addOrderTrackingReport(Order_Tracking tracking)
{
try
{
db.Order_Trackings.Add(tracking);
db.SaveChanges();
}
catch (Exception ex) { }
}
public void AddOrderTrackingReport(Order_Tracking tracking)
{
try
{
ModelsContext.Order_Trackings.Add(tracking);
ModelsContext.SaveChanges();
}
catch (Exception ex) { }
}
public IHttpActionResult UpdateOrderTrackingStatus([FromBody] Order_Tracking ordertracker)
{
var ordertrackerRepo = new OrderTrackingRepository();
var result = ordertrackerRepo.UpdateOrderTrackingStatus(ordertracker);
if (result <= 0)
{
return(Ok("Error occurred while updating the order tracking status"));
}
return(Ok("Order Tracking Status Updated"));
}
public IHttpActionResult GetOrderTracker(Order_Tracking ordertracking)
{
var ordertrackerRepo = new OrderTrackingRepository();
var getordertracker = ordertrackerRepo.GetOrderTracker(ordertracking);
if (getordertracker == null)
{
return(NotFound());
}
return(Ok(getordertracker));
}
public void expectedDeliveryDateReport(Order order)
{
try
{
var expected_Date = DateTime.Now.AddDays(3);
do
{
expected_Date = expected_Date.AddDays(1);
} while (expected_Date.DayOfWeek.ToString().ToLower() == "sunday" ||
expected_Date.DayOfWeek.ToString().ToLower() == "saturday");
if (IsDeliveryRequested(order.Order_ID))
{
addOrderTrackingReport(new Order_Tracking()
{
order_ID = order.Order_ID,
date = DateTime.Now,
status = "Expected delivery on " + expected_Date.ToLongDateString() + " before 5pm",
Recipient = ""
});
Order_Tracking ot = new Order_Tracking();
if (ot.date.Date >= expected_Date.Date)
{
ot.status = "Delivered!";
}
}
else
{
expected_Date = DateTime.Now.AddHours(1);
addOrderTrackingReport(new Order_Tracking()
{
order_ID = order.Order_ID,
date = DateTime.Now,
status = "Can be collected during business hours as from " + expected_Date.ToLongDateString() + " " + expected_Date.ToLongTimeString(),
Recipient = ""
});
}
}
catch (Exception ex) { }
}
private IList <Order_Tracking> FillOrderTrackingModel(DataTable dtOrderTrackers)
{
var ordertrackerList = new List <Order_Tracking>();
if (null != dtOrderTrackers && dtOrderTrackers.Rows.Count > 0)
{
foreach (DataRow row in dtOrderTrackers.Rows)
{
var ordertracker = new Order_Tracking();
ordertracker.OrderTrackingID = Convert.ToInt32(row["ORDER_TRACKING_ID"]);
ordertracker.OrderFKId = Convert.ToInt32(row["FK_ORDER_ID"]);
ordertracker.ORDERSTATUSID = Convert.ToInt32(row["FK_ORDER_STATUS_ID"]);
ordertracker.OrdertrackingDate = Convert.ToDateTime(row["ORDER_TRACKING_DATE"]);
ordertracker.Comment = Convert.ToString(row["EXTRA_COMMENTS"]);
ordertracker.CREATEDDATE = Convert.ToDateTime(row["CREATED_DATE"]);
ordertracker.CREATEDBY = Convert.ToInt32(row["CREATED_BY"]);
ordertracker.LASTMODIFIEDDATE = Convert.ToDateTime(row["LASTMODIFIED_DATE"]);
ordertracker.LASTMODIFIEDBY = Convert.ToInt32(row["LASTMODIFIED_BY"]);
ordertrackerList.Add(ordertracker);
}
}
return(ordertrackerList);
}
public int UpdateOrderTrackingStatus(Order_Tracking ordertracker)
{
string updateOrderTrackingInfo = $"UPDATE Mobifix_DB.ORDER_TRACKING SET FK_ORDER_STATUS_ID = '{ordertracker.ORDERSTATUSID}' WHERE LOWER(ORDER_TRACKING_ID) = '{ordertracker.OrderTrackingID.ToString()}' ";
return(MySqlOrderTrackingHelper.ExecuteNonQuery(updateOrderTrackingInfo));
}
