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 static string GetColorPlanned()
{
PlannerDataSet ds = new PlannerDataSet();
ds.EnforceConstraints = false;
string colourPlanned = "";
DataTable ColourPlanned = new DataTable();
PlannerDataSetTableAdapters.StatusTableAdapter adapter = new PlannerDataSetTableAdapters.StatusTableAdapter();
ColourPlanned = adapter.GetDataStatusById(2);
colourPlanned = ColourPlanned.Rows[0][2].ToString();
return(colourPlanned);
}
