protected void rgFieldTrips_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Data.Trip newTrip = new Data.Trip();
newTrip.office_id = Convert.ToInt32((item.FindControl("rddlOffice") as RadDropDownList).SelectedValue);
newTrip.user_id = (item.FindControl("rddlAssignedTo2") as RadDropDownList).SelectedValue.ToString();
newTrip.trip_nm = (item.FindControl("rtbTripName2") as RadTextBox).Text;
RadListBox assigned_sites = (item.FindControl("rlbSitesEnd2") as RadListBox);
db.Trips.InsertOnSubmit(newTrip);
db.SubmitChanges();
List <Data.TripSite> tripSites = new List <Data.TripSite>();
foreach (RadListBoxItem site in assigned_sites.Items)
{
tripSites.Add(new Data.TripSite()
{
trip_id = newTrip.trip_id, site_id = Convert.ToInt32(site.Value)
});
}
db.TripSites.InsertAllOnSubmit(tripSites);
db.SubmitChanges();
DisplayMessage(false, "The field trip was added!");
}
protected void Page_Load(object sender, EventArgs e)
{
int trip_id = Convert.ToInt32(Request.QueryString["ID"]);
Data.Trip trip = db.Trips.Where(p => p.trip_id == trip_id).FirstOrDefault();
ltlTripName.Text = trip.trip_nm;
dlSites.DataSource = trip.TripSites.Select(p => new { site_no = p.Site.site_no, station_nm = p.Site.station_full_nm }).OrderBy(p => p.site_no);
dlSites.DataBind();
}
protected void Page_Load(object sender, System.EventArgs e)
{
int TripID = Convert.ToInt32(Request.QueryString["trip_id"]);
if (TripID > 0)
{
currTrip = db.Trips.FirstOrDefault(p => p.trip_id == TripID);
OfficeID = (int)currTrip.office_id;
WSCID = (int)currTrip.Office.wsc_id;
lblTripName.Text = currTrip.trip_nm + " - " + currTrip.user_id;
if (!Page.IsPostBack)
{
SetupBasicGMapDisplay(OfficeID);
AddOfficeToMap(OfficeID);
AddSitesToMap(WSCID, OfficeID, TripID);
}
}
else
{
//Show error message
}
}
public static bool IsEnded(this Data.Trip trip)
{
return(trip.EndTime != null);
}
public PatchTrip()
{
_entity = new Data.Trip();
}
public PatchTrip(Data.Trip entity)
{
_entity = entity;
}
