private string GetOrderLink(OrderJoinData data)
{
string link = "<a href='{0}' target='_blank'>{1}</a>";
string url = "";
if (!string.IsNullOrEmpty(data.package.BoxID))
{
url = Url.Action("boxEdit", "directLine", new { id = data.package.BoxID });
}
else
{
switch (data.package.ProcessStatus)
{
case 1:
case 2:
url = Url.Action("waiting", "order", new { data.order.OrderID });
break;
case 3:
url = Url.Action("shipped", "order", new { data.order.OrderID });
break;
default:
url = Url.Action("index", "order", new { data.order.OrderID });
break;
}
}
return(string.Format(link, url, EnumData.ProcessStatusList()[(EnumData.ProcessStatus)data.package.ProcessStatus]));
}
public static JObject SetOrderExcelData(string type, OrderJoinData data, JObject obj)
{
switch (type)
{
case "order":
obj.Add("OrderID", data.order.OrderID);
obj.Add("OrderItemID", data.package.OrderItemID);
obj.Add("KitItemID", data.package.BundleItemID);
obj.Add("UserID", data.order.UserID);
obj.Add("UserName", data.order.UserName);
obj.Add("FirstName", data.order.Addresses.FirstName);
obj.Add("LastName", data.order.Addresses.LastName);
obj.Add("CompanyName", data.order.Addresses.CompanyName);
obj.Add("SiteCode", data.order.SiteCode);
obj.Add("TimeOfOrder", MyHelp.DateTimeWithZone(data.order.TimeOfOrder.Value).ToString("MM/dd/yyyy hh:mm:ss tt"));
obj.Add("SubTotal", data.order.SubTotal);
obj.Add("ShippingTotal", data.order.ShippingTotal);
obj.Add("OrderDiscountsTotal", data.order.OrderDiscountsTotal);
obj.Add("GrandTotal", data.order.GrandTotal);
obj.Add("Status", Enum.GetName(typeof(OrderStatusCode), data.order.StatusCode));
obj.Add("PaymentStatus", Enum.GetName(typeof(OrderPaymentStatus), data.order.PaymentStatus));
obj.Add("PaymentDate", MyHelp.DateTimeWithZone(data.order.PaymentDate.Value).ToString("MM/dd/yyyy hh:mm:ss tt"));
obj.Add("PaymentReferenceNumber", data.order.Payments.Any() ? data.order.Payments.First().TransactionReferenceNumber : "");
obj.Add("PaymentMethod", data.order.Payments.Any() ? Enum.GetName(typeof(PaymentMethod), data.order.Payments.First().PaymentMethod) : "");
obj.Add("ShippingStatus", Enum.GetName(typeof(OrderShippingStatus), data.order.ShippingStatus));
obj.Add("ShipDate", data.order.ShippingStatus == 3 && data.package.ShipDate != null ? MyHelp.DateTimeWithZone(data.package.ShipDate.Value).ToString("MM/dd/yyyy hh:mm:ss tt") : "");
obj.Add("ShipFirstName", data.order.Addresses.FirstName);
obj.Add("ShipLastName", data.order.Addresses.LastName);
obj.Add("ShipCompanyName", data.order.Addresses.CompanyName);
obj.Add("ShipAddress1", data.order.Addresses.StreetLine1);
obj.Add("ShipAddress2", data.order.Addresses.StreetLine2);
obj.Add("ShipCity", data.order.Addresses.City);
obj.Add("ShipState", data.order.Addresses.StateName);
obj.Add("ShipZipCode", data.order.Addresses.PostalCode);
obj.Add("ShipCountry", data.order.Addresses.CountryName);
obj.Add("OrderSource", data.order.OrderSource);
obj.Add("OrderSourceOrderID", data.order.OrderSourceOrderId);
obj.Add("eBaySalesRecordNumber", data.order.eBaySalesRecordNumber);
obj.Add("ShippingMethodSelected", data.package.ShippingMethodName);
obj.Add("IsRushOrder", data.order.RushOrder);
obj.Add("InvoicePrinted", data.order.InvoicePrinted);
obj.Add("InvoicePrintedDate", data.order.InvoicePrinted.Value ? MyHelp.DateTimeWithZone(data.order.InvoicePrintedDate.Value).ToString("MM/dd/yyyy hh:mm:ss tt") : "");
obj.Add("ShippingCarrier", data.package.Method != null ? data.package.Method.Carriers.Name : data.package.ShippingServiceCode);
obj.Add("PackageType", data.order.PackageType);
obj.Add("CompanyID", data.order.CompanyID);
obj.Add("OrderSourceOrderTotal", data.order.OrderSourceOrderTotal);
obj.Add("CustomerServiceStatus", Enum.GetName(typeof(OrderCustomerServiceStatus), data.order.CustomerServiceStatus));
obj.Add("TaxRate", data.order.TaxRate);
obj.Add("TaxTotal", data.order.TaxTotal);
obj.Add("GoogleOrderNumber", data.order.GoogleOrderNumber);
obj.Add("IsInDispute", data.order.IsInDispute);
obj.Add("DisputeStartedOn", data.order.IsInDispute.Value ? MyHelp.DateTimeWithZone(data.order.DisputeStartedOn.Value).ToString("MM/dd/yyyy hh:mm:ss tt") : "");
obj.Add("PaypalFeeTotal", data.order.PaypalFeeTotal);
obj.Add("PostingFeeTotal", data.order.PostingFeeTotal);
obj.Add("FinalValueTotal", data.order.FinalValueTotal);
obj.Add("ShippingWeightTotalOz", data.order.ShippingWeightTotalOz);
obj.Add("ProductID", data.item.ProductID);
obj.Add("Qty", data.item.Qty);
obj.Add("DisplayName", data.item.DisplayName);
obj.Add("LineTotal", data.item.LineTotal);
obj.Add("eBayItemID", data.item.eBayItemID);
obj.Add("BackOrderQty", data.item.BackOrderQty);
obj.Add("TrackingNumber", data.package.TrackingNumber);
obj.Add("SerialNumber", data.item.SerialNumbers.Any() ? data.item.SerialNumbers.First().SerialNumber : "");
obj.Add("UPC", data.item.Skus.UPC);
obj.Add("MarkettingSourceID", data.order.MarkettingSourceID);
break;
case "waiting":
case "shipped":
obj.Add("OrderID", data.order.OrderID);
obj.Add("PaymentDate", data.order.Payments.Any() ? MyHelp.DateTimeWithZone(data.order.Payments.First().AuditDate.Value).ToString("MM/dd/yyyy hh:mm:ss tt") : "");
obj.Add("ProductID", data.item.ProductID);
obj.Add("DisplayName", data.item.DisplayName);
obj.Add("Qty", 1);
obj.Add("Country", data.order.Addresses.CountryName);
obj.Add("Warehouse", data.item.ShipWarehouses.Name);
obj.Add("ShippingMethod", data.package.Method != null ? data.package.Method.Carriers.Name : data.package.ShippingServiceCode);
obj.Add("Export", Enum.GetName(typeof(EnumData.Export), data.package.Export != null ? data.package.Export : 0));
obj.Add("ExportMethod", Enum.GetName(typeof(EnumData.ExportMethod), data.package.ExportMethod != null ? data.package.ExportMethod : 0));
obj.Add("Status", Enum.GetName(typeof(OrderStatusCode), data.order.StatusCode));
obj.Add("Comment", data.package.Comment);
obj.Add("SerialNumber", data.item.SerialNumber);
obj.Add("DispatchDate", data.package.DispatchDate.HasValue ? data.package.DispatchDate.Value.ToString("MM/dd/yyyy hh:mm:ss tt") : "");
obj.Add("PickUpDate", data.package.ScanDateA.HasValue ? data.package.ScanDateA.Value.ToString("MM/dd/yyyy hh:mm:ss tt") : "");
obj.Add("Tracking", data.package.TrackingNumber);
obj.Add("DeliveryStatus", data.package.DeliveryStatus);
obj.Add("DispatchTime", "");
obj.Add("TransitTime", "");
obj.Add("RedirectWarehouse", data.item.ReturnWarehouses.Name);
obj.Add("RMA", data.package.RMAId.HasValue ? data.package.RMAId.ToString() : "");
break;
}
return(obj);
}
