///////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// Creates a new object that is a copy of the current instance.
/// </summary>
/// <returns></returns>
public override object Clone()
{
DriverSpecialty obj = new DriverSpecialty();
this.CopyTo(obj);
return(obj);
}
///////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// Copies all the object's data to the target data object.
/// </summary>
/// <param name="obj">Target data object.</param>
public override void CopyTo(DataObject obj)
{
Debug.Assert(obj is DriverSpecialty);
DriverSpecialty spec = obj as DriverSpecialty;
spec.Name = this.Name;
spec.Comment = this.Comment;
}
private void processOrders(string path)
{
DataTable table = new DataTable();
table = ReadCSV(path);
foreach (DataRow row in table.Rows)
{
// Create New empty Order
CapacitiesInfo capInfo = m_application.Project.CapacitiesInfo;
OrderCustomPropertiesInfo propInfo = m_application.Project.OrderCustomPropertiesInfo;
ESRI.ArcLogistics.DomainObjects.Order resultOrder = new ESRI.ArcLogistics.DomainObjects.Order(capInfo, propInfo);
OrderCustomPropertiesInfo orderPropertiesInfo = resultOrder.CustomPropertiesInfo;
OrderCustomProperties orderProperties = resultOrder.CustomProperties;
CapacitiesInfo orderCapacitiesInfo = resultOrder.CapacitiesInfo;
Capacities orderCapacities = resultOrder.Capacities;
bool geocodeProvided = false;
bool geocodeCorrect = false;
double tempD;
DateTime TWdateTime;
Double tempX = 0.0;
Double tempY = 0.0;
// Insert Order Information
resultOrder.PlannedDate = m_application.CurrentDate;
for (int i = 0; i < table.Columns.Count; i++)
{
try
{
switch (table.Columns[i].ColumnName)
{
#region Case Statements
case "Name": resultOrder.Name = row["Name"].ToString(); break;
case "Address": resultOrder.Address.AddressLine = row["Address"].ToString(); break;
case "City": resultOrder.Address.Locality3 = row["City"].ToString(); break;
case "State": resultOrder.Address.StateProvince = row["State"].ToString(); break;
case "Zip": resultOrder.Address.PostalCode1 = row["Zip"].ToString(); break;
case "Zip4": resultOrder.Address.PostalCode2 = row["Zip4"].ToString(); break;
case "Country": resultOrder.Address.Country = row["Country"].ToString(); break;
case "PlannedDate":
DateTime tempDT = new DateTime();
if (System.DateTime.TryParse(row["PlannedDate"].ToString(), out tempDT))
resultOrder.PlannedDate = tempDT;
break;
case "Priority":
if (row["Priority"].ToString() == "High") resultOrder.Priority = OrderPriority.High;
else if (row["Priority"].ToString() == "Normal") resultOrder.Priority = OrderPriority.Normal;
break;
case "OrderType":
if (row["OrderType"].ToString() == "Pickup") resultOrder.Type = OrderType.Pickup;
else if (row["OrderType"].ToString() == "Delivery") resultOrder.Type = OrderType.Delivery;
break;
case "ServiceTime":
if (Double.TryParse(row["ServiceTime"].ToString(), out tempD))
resultOrder.ServiceTime = tempD;
break;
case "TimeWindowStart":
string tempS = row["TimeWindowStart"].ToString();
if (DateTime.TryParse(tempS, out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
resultOrder.TimeWindow.From = TWdateTime.TimeOfDay;
resultOrder.TimeWindow.IsWideOpen = false;
}
}
break;
case "TimeWindowFinish":
if (DateTime.TryParse(row["TimeWindowFinish"].ToString(), out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
resultOrder.TimeWindow.To = TWdateTime.TimeOfDay;
resultOrder.TimeWindow.IsWideOpen = false;
}
}
break;
case "TimeWindow2Start":
if (DateTime.TryParse(row["TimeWindow2Start"].ToString(), out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
resultOrder.TimeWindow2.From = TWdateTime.TimeOfDay;
resultOrder.TimeWindow2.IsWideOpen = false;
}
}
break;
case "TimeWindow2Finish":
if (DateTime.TryParse(row["TimeWindow2Finish"].ToString(), out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
resultOrder.TimeWindow2.To = TWdateTime.TimeOfDay;
resultOrder.TimeWindow2.IsWideOpen = false;
}
}
break;
case "MaxViolationTime":
if (Double.TryParse(row["MaxViolationTime"].ToString(), out tempD))
resultOrder.MaxViolationTime = tempD;
break;
case "VehicleSpecialties":
if (row["VehicleSpecialties"].ToString() != "")
{
string[] stringSeparators = new string[] { ";", "," };
string[] specialties = row["VehicleSpecialties"].ToString().Split(stringSeparators, StringSplitOptions.None);
foreach (string s in specialties)
{
VehicleSpecialty vs = new VehicleSpecialty();
vs.Name = s;
foreach (VehicleSpecialty V in m_application.Project.VehicleSpecialties)
{
if (String.Compare(V.Name, vs.Name, true) == 0)
{
V.CopyTo(vs);
m_application.Project.VehicleSpecialties.Remove(V);
break;
}
}
m_application.Project.VehicleSpecialties.Add(vs);
resultOrder.VehicleSpecialties.Add(vs);
}
}
break;
case "DriverSpecialties":
if (row["DriverSpecialties"].ToString() != "")
{
string[] stringSeparators2 = new string[] { ";", "," };
string[] specialties2 = row["DriverSpecialties"].ToString().Split(stringSeparators2, StringSplitOptions.None);
foreach (string s in specialties2)
{
DriverSpecialty ds = new DriverSpecialty();
ds.Name = s;
foreach (DriverSpecialty D in m_application.Project.DriverSpecialties)
{
if (String.Compare(D.Name, ds.Name, true) == 0)
{
D.CopyTo(ds);
m_application.Project.DriverSpecialties.Remove(D);
break;
}
}
m_application.Project.DriverSpecialties.Add(ds);
resultOrder.DriverSpecialties.Add(ds);
}
}
break;
case "X":
string x = row["X"].ToString();
if (x != "" && x != null)
if (Double.TryParse(row["X"].ToString(), out tempX))
{
if (tempX >= -180.0 && tempX <= 180.0 && tempX != 0.0)
{
geocodeProvided = true;
geocodeCorrect = true;
}
else if (tempX == 0.0)
geocodeCorrect = true;
}
break;
case "Y":
string y = row["Y"].ToString();
if (y != "" && y != null)
if (Double.TryParse(row["Y"].ToString(), out tempY))
{
if (tempY >= -90.0 && tempY <= 90.0 && tempY != 0)
{
geocodeProvided = true;
geocodeCorrect = true;
}
else if (tempY == 0.0)
geocodeCorrect = true;
}
break;
#endregion
}// End Switch
if (orderProperties.Count > 0 )
{
OrderCustomProperty orderPropertyInfoItem = null;
for (int j = 0; j < orderPropertiesInfo.Count; j++)
{
orderPropertyInfoItem = orderPropertiesInfo.ElementAt(j) as OrderCustomProperty;
string tempName = orderPropertyInfoItem.Name.Replace(" ", "");
if (tempName == table.Columns[i].ColumnName)
{
orderProperties[j] = (row[table.Columns[i].ToString()].ToString());
break;
}
}
}
if( orderCapacities.Count > 0)
{
CapacityInfo orderCapacityInfoItem = null;
for (int k = 0; k < orderCapacitiesInfo.Count; k++)
{
orderCapacityInfoItem = orderCapacitiesInfo.ElementAt(k);
string tempName = orderCapacityInfoItem.Name.Replace(" ", "");
if (tempName == table.Columns[i].ColumnName)
{
if(Double.TryParse(row[table.Columns[i].ToString()].ToString(), out tempD))
orderCapacities[k] = tempD;
break;
}
}
}
}
catch (Exception e)
{
string statusMessage = " Import from " + Params.Instance.importName + " encountered a problem: " + e.Message;
m_application.Messenger.AddError(statusMessage);
}
}
resultOrder.CustomProperties = orderProperties;
resultOrder.Capacities = orderCapacities;
if (geocodeProvided && geocodeCorrect)
{
AddressCandidate candidate1 = new AddressCandidate();
ESRI.ArcLogistics.Geometry.Point p = new ESRI.ArcLogistics.Geometry.Point(tempX, tempY);
candidate1.GeoLocation = p;
candidate1.Score = 100;
candidate1.Address = resultOrder.Address;
resultOrder.GeoLocation = candidate1.GeoLocation;
}
else
{
AddressCandidate candidate = m_application.Geocoder.Geocode(resultOrder.Address);
if (candidate != null)
resultOrder.GeoLocation = candidate.GeoLocation;
else
{
//TODO: Handle orders which were not geocoded!!
}
}
// Add Order
m_application.Project.Orders.Add(resultOrder);
}
}
public static void makeEdit(string field, string value)
{
field = field.Replace(" ", "");
string message = "Changing " + field + " to " + value + " for all seleced drivers.";
App.Current.Messenger.AddInfo(message);
ISupportSelection selector = (ISupportSelection)App.Current.MainWindow.CurrentPage;
for (int i = 0; i < selector.SelectedItems.Count; i++)
{
Driver driverRef = (Driver)selector.SelectedItems[i];
double tempD;
try
{
switch (field)
{
#region Case Statements
case "DriverName": driverRef.Name = value; break;
case "FixedCost":
if (Double.TryParse(value.ToString(), out tempD))
driverRef.FixedCost = tempD;
break;
case "PerHourSalary":
if (Double.TryParse(value.ToString(), out tempD))
driverRef.PerHourSalary = tempD;
break;
case "PerHourOTSalary":
if (Double.TryParse(value.ToString(), out tempD))
driverRef.PerHourOTSalary = tempD;
break;
case "Specialties":
if (value != "")
{
string[] stringSeparators2 = new string[] { ";", "," };
string[] specialties2 = value.Split(stringSeparators2, StringSplitOptions.None);
foreach (string s in specialties2)
{
DriverSpecialty ds = new DriverSpecialty();
ds.Name = s;
foreach (DriverSpecialty D in App.Current.Project.DriverSpecialties)
{
if (String.Compare(D.Name, ds.Name, true) == 0)
{
D.CopyTo(ds);
App.Current.Project.DriverSpecialties.Remove(D);
break;
}
}
foreach (DriverSpecialty D in driverRef.Specialties)
{
if (String.Compare(D.Name, ds.Name, true) == 0)
{
D.CopyTo(ds);
driverRef.Specialties.Remove(D);
break;
}
}
App.Current.Project.DriverSpecialties.Add(ds);
driverRef.Specialties.Add(ds);
}
}
break;
case "MobileDevice":
foreach (MobileDevice m in App.Current.Project.MobileDevices)
{
if (m.Name == value)
driverRef.MobileDevice = m;
}
break;
case "TimeBeforeOT":
if (Double.TryParse(value.ToString(), out tempD))
driverRef.TimeBeforeOT = tempD;
break;
case "Comment": driverRef.Comment = value; break;
#endregion
}// End Switch
}
catch (Exception e)
{
message = "Error: " + e.Message;
App.Current.Messenger.AddError(message);
}
}
App.Current.Project.Save();
}
public static void makeEdit(string field, string value)
{
field = field.Replace(" ", "");
string message = "Changing " + field + " to " + value + " for all seleced orders.";
App.Current.Messenger.AddInfo(message);
ISupportSelection selector = (ISupportSelection)App.Current.MainWindow.CurrentPage;
for(int i= 0;i<selector.SelectedItems.Count;i++)
{
// orderRef is a reference to the selected order [i]
Order orderRef = (ESRI.ArcLogistics.DomainObjects.Order)selector.SelectedItems[i];
OrderCustomPropertiesInfo orderPropertiesInfo = orderRef.CustomPropertiesInfo;
OrderCustomProperties orderProperties = orderRef.CustomProperties;
CapacitiesInfo orderCapacitiesInfo = orderRef.CapacitiesInfo;
Capacities orderCapacities = orderRef.Capacities;
double tempD;
DateTime TWdateTime;
try
{
switch (field)
{
#region Case Statements
case "Name": orderRef.Name = value; break;
case "Address": orderRef.Address.AddressLine = value; break;
case "City": orderRef.Address.Locality3 = value; break;
case "State": orderRef.Address.StateProvince = value; break;
case "Zip": orderRef.Address.PostalCode1 = value; break;
case "Zip4": orderRef.Address.PostalCode2 = value; break;
case "Country": orderRef.Address.Country = value; break;
case "PlannedDate":
DateTime tempDT = new DateTime();
if (System.DateTime.TryParse(value, out tempDT))
orderRef.PlannedDate = tempDT;
break;
case "Priority":
if (value == "High") orderRef.Priority = OrderPriority.High;
else if (value == "Normal") orderRef.Priority = OrderPriority.Normal;
break;
case "OrderType":
if (value == "Pickup")
orderRef.Type = OrderType.Pickup;
else if (value == "Delivery")
orderRef.Type = OrderType.Delivery;
break;
case "ServiceTime":
if (Double.TryParse(value.ToString(), out tempD))
orderRef.ServiceTime = tempD;
break;
case "TimeWindowStart":
string tempS = value;
if (DateTime.TryParse(tempS, out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
orderRef.TimeWindow.From = TWdateTime.TimeOfDay;
orderRef.TimeWindow.IsWideOpen = false;
}
}
break;
case "TimeWindowFinish":
if (DateTime.TryParse(value, out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
orderRef.TimeWindow.To = TWdateTime.TimeOfDay;
orderRef.TimeWindow.IsWideOpen = false;
}
}
break;
case "TimeWindow2Start":
if (DateTime.TryParse(value, out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
orderRef.TimeWindow2.From = TWdateTime.TimeOfDay;
orderRef.TimeWindow2.IsWideOpen = false;
}
}
break;
case "TimeWindow2Finish":
if (DateTime.TryParse(value, out TWdateTime))
{
if (TWdateTime.TimeOfDay != TimeSpan.Zero)
{
orderRef.TimeWindow2.To = TWdateTime.TimeOfDay;
orderRef.TimeWindow2.IsWideOpen = false;
}
}
break;
case "MaxViolationTime":
if (Double.TryParse(value, out tempD))
orderRef.MaxViolationTime = tempD;
break;
case "VehicleSpecialties":
if (value != "")
{
string[] stringSeparators = new string[] { ";", "," };
string[] specialties = value.Split(stringSeparators, StringSplitOptions.None);
foreach (string s in specialties)
{
VehicleSpecialty vs = new VehicleSpecialty();
vs.Name = s;
foreach (VehicleSpecialty V in App.Current.Project.VehicleSpecialties)
{
if (String.Compare(V.Name, vs.Name, true) == 0)
{
V.CopyTo(vs);
App.Current.Project.VehicleSpecialties.Remove(V);
break;
}
}
foreach (VehicleSpecialty V in orderRef.VehicleSpecialties)
{
if (String.Compare(V.Name, vs.Name, true) == 0)
{
V.CopyTo(vs);
orderRef.VehicleSpecialties.Remove(V);
break;
}
}
App.Current.Project.VehicleSpecialties.Add(vs);
orderRef.VehicleSpecialties.Add(vs);
}
}
break;
case "DriverSpecialties":
if (value != "")
{
string[] stringSeparators2 = new string[] { ";", "," };
string[] specialties2 = value.Split(stringSeparators2, StringSplitOptions.None);
foreach (string s in specialties2)
{
DriverSpecialty ds = new DriverSpecialty();
ds.Name = s;
foreach (DriverSpecialty D in App.Current.Project.DriverSpecialties)
{
if (String.Compare(D.Name, ds.Name, true) == 0)
{
D.CopyTo(ds);
App.Current.Project.DriverSpecialties.Remove(D);
break;
}
}
foreach (DriverSpecialty D in orderRef.DriverSpecialties)
{
if (String.Compare(D.Name, ds.Name, true) == 0)
{
D.CopyTo(ds);
orderRef.DriverSpecialties.Remove(D);
break;
}
}
App.Current.Project.DriverSpecialties.Add(ds);
orderRef.DriverSpecialties.Add(ds);
}
}
break;
//end of case statements
#endregion
}
#region Custom order properties and capacities
if (orderProperties.Count > 0)
{
OrderCustomProperty orderPropertyInfoItem = null;
for (int j = 0; j < orderPropertiesInfo.Count; j++)
{
orderPropertyInfoItem = orderPropertiesInfo.ElementAt(j) as OrderCustomProperty;
string tempName = orderPropertyInfoItem.Name.Replace(" ", "");
if (tempName == field)
{
orderRef.CustomProperties[j] = value;
break;
}
}
}
if (orderCapacities.Count > 0)
{
CapacityInfo orderCapacityInfoItem = null;
for (int k = 0; k < orderCapacitiesInfo.Count; k++)
{
orderCapacityInfoItem = orderCapacitiesInfo.ElementAt(k);
string tempName = orderCapacityInfoItem.Name.Replace(" ", "");
if (tempName == field)
{
if (Double.TryParse(value, out tempD))
orderRef.Capacities[k] = tempD;
break;
}
}
}
// End custom order properties and capacities
#endregion
}
catch (Exception e)
{
message = "Error: " + e.Message;
App.Current.Messenger.AddError(message);
}
}
App.Current.Project.Save();
}
///////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// Creates a new object that is a copy of the current instance.
/// </summary>
/// <returns></returns>
public override object Clone()
{
DriverSpecialty obj = new DriverSpecialty();
this.CopyTo(obj);
return obj;
}