/*
* //ponemos el status del pedido a planificad
* public static void UpdateStatusOrders(long idOrder)
* {
* var con = Properties.Settings.Default.EtasaConnectionString;
* try
* {
* using (SqlConnection connection = new SqlConnection(con))
* {
* connection.Open();
* SqlCommand cmd = new SqlCommand();
* cmd.Connection = connection;
* cmd.CommandText = "UPDATE Orders SET Status = @Status WHERE Id = @Id";
* cmd.Parameters.AddWithValue("@Id", idOrder);
* cmd.Parameters.AddWithValue("@Status", 2);
* cmd.ExecuteScalar();
* }
*
* }
* catch(Exception ex)
* {
*
* }
*
* }
*/
public static IEnumerable <Assignment> RequestAssignments(DateTime dateTime, string filterVehicle)
{
PlannerDataSet ds = new PlannerDataSet();
ds.EnforceConstraints = false;
string WhereQueryFilterVehicle = "";
PlannerDataSetTableAdapters.PlannerAssignmentsTableAdapter adapt = new PlannerDataSetTableAdapters.PlannerAssignmentsTableAdapter();
//si no hay filtro por vehiculo no realizamos ninguna acción
if (filterVehicle == "")
{
adapt.FillBy(ds.PlannerAssignments, dateTime.ToString());
}
//filtramos la misma consulta
else
{
WhereQueryFilterVehicle = string.IsNullOrWhiteSpace(filterVehicle) ? "0" : "0," + filterVehicle;
adapt.FillByDateAndVehicleIds(ds.PlannerAssignments, dateTime.ToString(), WhereQueryFilterVehicle);
}
var table = ds.PlannerAssignments;
foreach (DataRow row in table.Rows)
{
yield return(ConvertToAssignment(row, table));
}
}
public static IEnumerable <Order> RequestOrders(long AssignmentId, int IdRoute)
{
PlannerDataSet ds = new PlannerDataSet();
ds.EnforceConstraints = false;
PlannerDataSetTableAdapters.PlannerAssignmentsTableAdapter adapter = new PlannerDataSetTableAdapters.PlannerAssignmentsTableAdapter();
adapter.FillByAssigments(ds.PlannerAssignments, AssignmentId, IdRoute);
var table = ds.PlannerAssignments;
foreach (DataRow row in table.Rows)
{
yield return(ConvertToOrderFromPlanner(row, table));
}
}
