public static string GetColorLoaded(int orderTripId)
{
PlannerDataSet ds = new PlannerDataSet();
ds.EnforceConstraints = false;
string color = "#FE2E2E";
DataTable tripsdatatable = new DataTable();
int status = 0;
PlannerDataSetTableAdapters.TripsTableAdapter adapter = new PlannerDataSetTableAdapters.TripsTableAdapter();
tripsdatatable = adapter.GetDataByIdTrips(orderTripId);
if (tripsdatatable.Rows.Count > 0)
{
status = Convert.ToInt32(tripsdatatable.Rows[0]["Status"].ToString().Trim());
if (status == 3)
{
DataTable Colour = new DataTable();
PlannerDataSetTableAdapters.StatusTableAdapter adapter2 = new PlannerDataSetTableAdapters.StatusTableAdapter();
adapter2.FillByStatus(ds.Status, status);
var table = ds.Status;
if (table.Rows.Count > 0)
{
color = table.Rows[0]["Color"].ToString().Trim();
}
}
}
return(color);
}
public void RorderAssigments(ListView listViewLeft)
{
PlannerDataSetTableAdapters.TripsTableAdapter TripTable = new PlannerDataSetTableAdapters.TripsTableAdapter();
//obtenemos la lista de viajes del pedido
int contadorDeposiciones = 1;
foreach (Order order in listViewLeft.ItemsSource)
{
int posicion = listViewLeft.Items.IndexOf(order);
Console.WriteLine(order.Client.Name + " POS:" + posicion.ToString());
PlannerDataSet.TripsDataTable dataTable = TripTable.GetDataTripsByOrderId(Convert.ToInt32(order.Id));
//recorremos la tabla de viajes por pedidos
foreach (PlannerDataSet.TripsRow row in dataTable.Rows)
{
row.Position = contadorDeposiciones;
TripTable.Update(row);
contadorDeposiciones = contadorDeposiciones + 1;
}
}
}