public Box GetCurrentBox(DirectLine directLine, int warehouseID, int methodID = 0)
{
MyHelp.Log("Box", null, string.Format("取得當前未出貨的{0} Box", directLine.Abbreviation), Session);
boxData = db.Box.Where(b => b.IsEnable && !b.IsReserved && b.DirectLine.Equals(directLine.ID) && b.WarehouseFrom.Equals(warehouseID) && b.FirstMileMethod.Equals(methodID) && b.ShippingStatus.Equals((byte)EnumData.DirectLineStatus.未發貨))
.OrderByDescending(b => b.Create_at).FirstOrDefault();
if (boxData == null)
{
MyHelp.Log("Box", null, string.Format("開始建立【{0}】新Box", directLine.Abbreviation), Session);
string boxID = string.Format("{0}-{1}", directLine.Abbreviation, TimeZoneConvert.Utc.ToString("yyyyMMdd"));
int count = db.Box.AsNoTracking().Where(b => b.IsEnable && b.DirectLine.Equals(directLine.ID) && b.BoxID.Contains(boxID)).Select(b => b.MainBox).Distinct().Count() + 1;
byte[] Byte = BitConverter.GetBytes(count);
Byte[0] += 64;
boxData = new Box()
{
IsEnable = true,
BoxID = string.Format("{0}-{1}", boxID, System.Text.Encoding.ASCII.GetString(Byte.Take(1).ToArray())),
DirectLine = directLine.ID,
FirstMileMethod = methodID,
WarehouseFrom = warehouseID,
BoxType = (byte)EnumData.DirectLineBoxType.DirectLine,
Create_at = TimeZoneConvert.Utc
};
boxData.MainBox = boxData.BoxID;
db.Entry(boxData).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
MyHelp.Log("Box", boxData.BoxID, string.Format("Box【{0}】建立完成", boxData.BoxID), Session);
}
return(boxData);
}
public void SaveChanges()
{
try
{
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
throw ex;
}
}
private void Sendle_Test(int OrderID)
{
var packageList = db.Box.Where(b => b.BoxID.Contains("ECOF-")).SelectMany(b => b.Packages.Where(p => p.IsEnable.Value)).ToList();
foreach (var package in packageList)
{
Sendle_API Sendle = new Sendle_API(package.Method.Carriers.CarrierAPI);
var order = Sendle.Order(package.TagNo);
package.TrackingNumber = order.sendle_reference;
db.Entry(package).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
//Packages package = db.Packages.First(p => p.IsEnable.Value && p.OrderID.Value.Equals(OrderID));
//Sendle_API Sendle = new Sendle_API(package.Method.Carriers.CarrierAPI);
//TrackOrder track = new TrackOrder();
//track.SetOrder(package.Orders, package);
//var result = track.Track();
//var result = Sendle.Create(package);
//var order = Sendle.Order(result.order_id);
//Sendle.Label(result.order_id, string.Format("{0}-{1}-{2}", package.Items.First().ProductID, package.OrderID.Value, result.sendle_reference), @"C:\Users\qdtuk\Downloads");
//var track = Sendle.Track(package.TrackingNumber);
//var cancel = Sendle.Cancel(result.order_id);
}
public string Update_Tracking(Packages package)
{
string Message = "";
try
{
MyHelp.Log("Packages", package.ID, string.Format("訂單【{0}】包裹SC更新", package.OrderID), Session);
if (!SCWS.Is_login)
{
throw new Exception("SC is not logged in!");
}
OrderData orderData = SCWS.Get_OrderData(package.OrderID.Value);
Order SC_order = orderData.Order;
Package SC_package = SC_order.Packages.FirstOrDefault(p => p.ID.Equals(package.ID));
if (SC_package == null)
{
MyHelp.Log("Packages", package.ID, "Not find package on SC website!", Session);
package.IsEnable = false;
SC_package = SC_order.Packages.First(p => p.ID.Equals(SC_order.Items.First(i => i.ID.Equals(package.Items.First(ii => ii.IsEnable.Value).ID)).PackageID));
var newPackage = db.Packages.AsNoTracking().First(p => p.ID.Equals(package.ID));
newPackage.ID = SC_package.ID;
db.Packages.Add(newPackage);
foreach (var item in package.Items)
{
item.PackageID = newPackage.ID;
}
foreach (var pick in db.PickProduct.Where(pick => pick.PackageID.Value.Equals(package.ID)))
{
pick.PackageID = newPackage.ID;
}
if (package.Label != null)
{
package.Label.PackageID = newPackage.ID;
}
db.SaveChanges();
MyHelp.Log("Packages", package.ID, string.Format("Change package {0} to {1}", package.ID, newPackage.ID), Session);
package = newPackage;
}
string carrier = "";
try
{
if (package.Method == null)
{
throw new Exception("Not find method!");
}
if (package.Method.Carriers == null)
{
throw new Exception("Not find carrir");
}
carrier = package.Method.Carriers.Name;
}
catch (Exception e)
{
MyHelp.Log("Packages", package.ID, e.Message, Session);
carrier = db.ShippingMethod.Find(package.ShippingMethod.Value).Carriers.Name;
}
SCWS.Update_PackageShippingStatus(SC_package, (package.UploadTracking ? package.TrackingNumber : ""), carrier);
if (db.Packages.AsNoTracking().Where(p => p.IsEnable.Value && p.OrderID.Value.Equals(package.OrderID.Value)).All(p => p.ProcessStatus.Equals((byte)EnumData.ProcessStatus.已出貨)))
{
if (SCWS.Update_OrderShippingStatus(SC_order, carrier))
{
var updatePackage = db.Packages.Find(package.ID);
updatePackage.WorkDays = 0;
var paymentDate = new TimeZoneConvert(package.Orders.Payments.FirstOrDefault()?.AuditDate ?? package.Orders.TimeOfOrder.Value, EnumData.TimeZone.EST).Utc;
var updateDate = DateTime.UtcNow;
var checkPoint = new DateTime(paymentDate.Year, paymentDate.Month, paymentDate.Day, 7, 0, 0, DateTimeKind.Utc);
do
{
if (paymentDate.CompareTo(checkPoint) < 0)
{
if (!checkPoint.DayOfWeek.Equals(DayOfWeek.Saturday) && !checkPoint.DayOfWeek.Equals(DayOfWeek.Sunday))
{
updatePackage.WorkDays++;
}
}
checkPoint = checkPoint.AddDays(1);
} while (checkPoint.CompareTo(updateDate) < 0);
db.SaveChanges();
MyHelp.Log("Packages", package.ID, string.Format("訂單【{0}】SC完成出貨", package.OrderID), Session);
}
}
foreach (Items item in package.Items.Where(i => i.IsEnable.Value).ToList())
{
if (item.SerialNumbers.Any())
{
SCWS.Update_ItemSerialNumber(item.ID, item.SerialNumbers.Select(s => s.SerialNumber).ToArray());
}
}
Message = Sync_Order(package.OrderID.Value);
}
catch (Exception e)
{
string[] serials = package.Items.Where(i => i.IsEnable.Value).SelectMany(i => i.SerialNumbers.Select(s => s.SerialNumber)).ToArray();
MyHelp.ErrorLog(e, string.Format("訂單包裹【{0}】更新失敗: #serials {1}", package.OrderID, string.Join(",", serials)), package.OrderID.ToString());
Message = e.InnerException != null && !string.IsNullOrEmpty(e.InnerException.Message) ? e.InnerException.Message : e.Message;
}
return(Message);
}