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); }