protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//if (Request.Form["_details"] != null)
//{
int event_fk = int.Parse(Request.QueryString["event_fk"]);
DateTime date = DateTime.Parse(Request.QueryString["date"]);
TimeSpan time = TimeSpan.Parse(Request.QueryString["time"]);
int activity_fk = int.Parse(Request.QueryString["activity_fk"]);
int guide_fk = int.Parse(Request.QueryString["guide_fk"]);
string comments_trans = Request.QueryString["comments_trans"];
TransportList list = new TransportList();
Event _event = db.Events.SingleOrDefault(a => a.ID == event_fk);
list.activity_name = _event.Activity.name;
list.comments_trans = _event.comments;
list.date = _event.date;
list.guide_name = _event.Guide.name;
list.passengers = GetPassengersList(event_fk);
TotalP = list.passengers.Sum(a => a.PAX);
list.pickup_time = _event.time.Value;
var PNRs = (from a in db.SoldActivities
where a.event_fk == event_fk && a.canceled == false
select a.PNR).ToList();
var flights = (from a in db.Clients
where PNRs.Contains(a.PNR)
select a.Flight1).Distinct();
list.flights = (from a in flights
select new FlightDTO {
num = a.num, date = a.date, time = a.time
}).ToList();
var agencies = from a in db.Clients
where PNRs.Contains(a.PNR)
select a.Agency.name;
db.Dispose();
DATA = Newtonsoft.Json.JsonConvert.SerializeObject(list);
Passengers = Newtonsoft.Json.JsonConvert.SerializeObject(list.passengers);
Flights = Newtonsoft.Json.JsonConvert.SerializeObject(list.flights);
DateStart = list.date.ToString("yyyy-MM-dd");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int event_fk = int.Parse(Request.QueryString["event_fk"]);
DateTime date = DateTime.Parse(Request.QueryString["date"]);
TimeSpan time = TimeSpan.Parse(Request.QueryString["time"]);
int activity_fk = int.Parse(Request.QueryString["activity_fk"]);
int guide_fk = int.Parse(Request.QueryString["guide_fk"]);
string comments_trans = Request.QueryString["comments_trans"];
TransportList list = new TransportList();
Event _event = db.Events.SingleOrDefault(a => a.ID == event_fk);
list.activity_name = _event.Activity.name;
list.comments_trans = _event.comments;
list.date = _event.date;
list.guide_name = _event.Guide.name;
list.pickup_time = _event.time.Value;
List <string> PNRs = (from a in db.SoldActivities
where a.event_fk == event_fk && a.canceled == false
select a.PNR).ToList();
var flights = (from a in db.Clients
where PNRs.Contains(a.PNR)
select a.Flight).Distinct();
list.flights = (from a in flights
select new FlightDTO {
num = a.num, date = a.date, time = a.time
}).ToList();
DateTime lastDepDate = (from a in db.Clients
where PNRs.Contains(a.PNR)
orderby a.date_dep descending
select a.date_dep).FirstOrDefault();
DateEnd = lastDepDate.ToString("yyyy-MM-dd");
list.tour_plan = GetTourPlan(_event.date, lastDepDate, event_fk);
var existing_tours_fks = list.tour_plan.Select(a => a.activity_fk).Distinct().ToList();
var existing_tours_names = from a in db.Activities
where existing_tours_fks.Contains(a.ID)
select a.subcat;
list.passengers = GetPassengersList(event_fk, PNRs, existing_tours_fks);
TotalP = list.passengers.Sum(a => a.PAX);
var agencies = from a in db.Clients
where PNRs.Contains(a.PNR)
select a.Agency.name;
TourNames = Newtonsoft.Json.JsonConvert.SerializeObject(existing_tours_names);
db.Dispose();
DATA = Newtonsoft.Json.JsonConvert.SerializeObject(list);
Passengers = Newtonsoft.Json.JsonConvert.SerializeObject(list.passengers);
TourPlan = Newtonsoft.Json.JsonConvert.SerializeObject(list.tour_plan);
Flights = Newtonsoft.Json.JsonConvert.SerializeObject(list.flights);
DateStart = list.date.ToString("yyyy-MM-dd");
}
}