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)); }