public ActionResult Create()
{
if (!Request.IsAuthenticated) return null;
var flight = new Flight
{
Date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day)
};
int val;
if (this.Request.Cookies != null)
{
if (this.Request.Cookies["StartTypeId"] != null && Int32.TryParse(this.Request.Cookies["StartTypeId"].Value, out val))
{
flight.StartTypeId = val;
}
int val2;
if (this.Request.Cookies["StartedFromId"] != null && Int32.TryParse(Request.Cookies["StartedFromId"].Value, out val2))
{
flight.StartedFromId = val2;
}
int val3;
if (this.Request.Cookies["LandedOnId"] != null && Int32.TryParse(Request.Cookies["LandedOnId"].Value, out val3))
{
flight.LandedOnId = val3;
}
}
this.PopulateViewBag(flight);
return View(flight);
}
public ActionResult Clone(Guid id)
{
if (!Request.IsAuthenticated) return null;
Flight originalFlight = this.db.Flights.Find(id);
var flight = new Flight
{
Date = originalFlight.Date,
PlaneId = originalFlight.PlaneId,
PilotId = originalFlight.PilotId,
PilotBackseatId = originalFlight.PilotBackseatId,
BetalerId = originalFlight.BetalerId,
StartTypeId = originalFlight.StartTypeId,
StartedFromId = originalFlight.StartedFromId,
LandedOnId = originalFlight.LandedOnId
};
this.PopulateViewBag(flight);
return View("Create", flight);
}
/// <summary>
/// Initializes a new instance of the <see cref="FlightVersionHistory"/> class.
/// </summary>
/// <param name="flight">
/// The flight.
/// </param>
/// <param name="entityState">
/// The entity state.
/// </param>
public FlightVersionHistory(Flight f, System.Data.EntityState entityState)
{
this.State = entityState.ToString();
this.FlightId = f.FlightId;
this.Created = DateTime.Now;
this.LastUpdated = f.LastUpdated;
this.LastUpdatedBy = f.LastUpdatedBy;
this.Description = f.Description;
this.Date = f.Date;
this.Departure = f.Departure;
this.Landing = f.Landing;
this.PlaneId = f.PlaneId;
this.PilotId = f.PilotId;
this.PilotBackseatId = f.PilotBackseatId;
this.BetalerId = f.BetalerId;
this.StartTypeId = f.StartTypeId;
this.StartedFromId = f.StartedFromId;
this.LandedOnId = f.LandedOnId;
this.TachoDeparture = f.TachoDeparture;
this.TachoLanding = f.TachoLanding;
}
/// <summary>
/// Import flight information from deprecated xml source
/// </summary>
/// <returns>Status report on the import job</returns>
/// <remarks>Will be removed to separate Assembly prior to beta release</remarks>
public string ImportFlightLog(string startStedetPath)
{
var startListeDataTable = new StartListeData.StartListeDataSet.StartListeDataTable();
if (global::System.IO.File.Exists(startStedetPath))
{
startListeDataTable.ReadXml(startStedetPath);
}
else
{
return startStedetPath + " <br/>Source Import file not found.";
}
int i = 0;
int omitted = 0;
int invalid = 0;
using (var db = new FlightContext())
{
var latestRecordKey = (from p in db.Flights select p.RecordKey).DefaultIfEmpty(0).Max();
var club = db.Clubs.First(c => c.ShortName == "ØSF");
var spilstart = db.StartTypes.First(c => c.Name == "Spilstart");
foreach (DataRow row in startListeDataTable.Rows)
{
if (i > 20)
{
break;
}
int rkey = 0;
// Custom data is not imported (could be old manual imported data)
if (!Int32.TryParse(row["RecordKey"].ToString(), out rkey))
{
invalid++;
continue;
}
if (rkey <= latestRecordKey)
{
omitted++;
continue;
}
// Allready imported
if (db.Flights.SingleOrDefault(f => f.RecordKey == rkey) != null)
{
omitted++;
continue;
}
// Starting location
var startedFrom = row["StartedFrom"].ToString().Trim();
Location departure = db.Locations.SingleOrDefault(l => l.Name.ToUpper() == startedFrom.ToUpper());
if (departure == null)
{
departure = new Location() { Name = startedFrom };
db.Locations.Add(departure);
db.SaveChanges();
}
// Landing location
var landedOn = row["landedOn"].ToString().Trim();
Location landing = db.Locations.SingleOrDefault(l => l.Name.ToUpper() == landedOn.ToUpper());
if ((!string.IsNullOrEmpty(landedOn)) && (landing == null))
{
landing = new Location() { Name = landedOn };
db.Locations.Add(landing);
db.SaveChanges();
}
// Plane
var planeName = row["PlaneName"].ToString().Trim();
Plane plane = db.Planes.SingleOrDefault(l => l.CompetitionId.ToUpper() == planeName.ToUpper());
if (plane == null)
{
double seats = 1;
if (((!string.IsNullOrEmpty(row["Pilot2_MemberId"].ToString())) &&
(row["Pilot2_MemberId"].ToString() != "0")) || (planeName == "R2") || (planeName == "RR"))
{
seats = 2;
}
plane = new Plane()
{
CompetitionId = planeName,
Registration = row["PlaneRegistration"].ToString().Trim(),
Seats = seats,
DefaultStartType = spilstart,
Engines = 0,
EntryDate = DateTime.Now
};
db.Planes.Add(plane);
db.SaveChanges();
}
// Pilot1
var pilot1 = row["Pilot1_MemberId"].ToString().Trim();
Pilot pilot = db.Pilots.SingleOrDefault(l => l.MemberId.ToUpper() == pilot1.ToUpper());
if (pilot == null)
{
pilot = new Pilot()
{
MemberId = pilot1,
UnionId = row["Pilot1_UnionId"].ToString().Trim(),
Name = row["Pilot1_Firstname"].ToString().Trim() + " " + row["Pilot1_Lastname"].ToString().Trim(),
Club = club
};
db.Pilots.Add(pilot);
db.SaveChanges();
}
// Pilot2
var pilot2 = row["Pilot2_MemberId"].ToString().Trim();
Pilot pilotBackseat = db.Pilots.SingleOrDefault(l => l.MemberId.ToUpper() == pilot2.ToUpper());
if ((!string.IsNullOrEmpty(pilot2)) && (pilot2 != "0") && (pilotBackseat == null))
{
pilotBackseat = new Pilot()
{
MemberId = pilot2,
UnionId = row["Pilot2_UnionId"].ToString().Trim(),
Name = row["Pilot2_Firstname"].ToString().Trim() + " " + row["Pilot2_Lastname"].ToString().Trim(),
Club = club
};
db.Pilots.Add(pilotBackseat);
db.SaveChanges();
}
// Payment
var betaler = row["Betaler_MemberId"].ToString().Trim();
Pilot pilotBetaler = db.Pilots.SingleOrDefault(l => l.MemberId.ToUpper() == betaler.ToUpper());
if (pilotBetaler == null)
{
pilotBetaler = new Pilot()
{
MemberId = betaler,
UnionId = row["Betaler_UnionId"].ToString().Trim(),
Name = row["Betaler_Firstname"].ToString().Trim() + " " + row["Betaler_Lastname"].ToString().Trim(),
Club = club
};
db.Pilots.Add(pilotBetaler);
db.SaveChanges();
}
// StartType
var startdesc = row["StartTypeDescription"].ToString().Trim();
var start = db.StartTypes.SingleOrDefault(s => s.Name == startdesc);
if (start == null)
{
start = new StartType()
{
Name = startdesc,
Club = club
};
db.StartTypes.Add(start);
db.SaveChanges();
}
// updater
var insertedBy = row["InsertedBy_Firstname"].ToString().Trim() + " " +
row["InsertedBy_Lastname"].ToString().Trim();
Pilot updater = db.Pilots.Where(l => l.Name.ToUpper() == insertedBy.ToUpper()).FirstOrDefault();
if (updater == null)
{
// Need memberId for creating member
}
// Remove time zone information on date
var startDateString = row["SDate"].ToString();
DateTime date = DateTime.Parse(startDateString);
date = DateTime.SpecifyKind(date, DateTimeKind.Utc);
// HACK: Fix for allowing the AppHarbor prod server to parse danish date xml on the english prod server into a utc time... im now desperate...
if (date.TimeOfDay != new TimeSpan(0, 0, 0))
{
date = date.AddHours(24 - date.TimeOfDay.Hours);
}
DateTime departureTime = DateTime.Parse(row["STime"].ToString());
departureTime = DateTime.SpecifyKind(departureTime, DateTimeKind.Utc);
DateTime landingTime = DateTime.Parse(row["LTime"].ToString());
landingTime = DateTime.SpecifyKind(landingTime, DateTimeKind.Utc);
var flight = new Flight
{
Date = date,
Departure = departureTime,
Landing = landingTime,
PlaneId = plane.PlaneId,
PilotId = pilot.PilotId,
BetalerId = pilotBetaler.PilotId,
StartedFromId = departure.LocationId
};
if (pilotBackseat != null)
{
flight.PilotBackseatId = pilotBackseat.PilotId;
}
if (landing != null)
{
flight.LandedOnId = landing.LocationId;
}
flight.LastUpdated = DateTime.Now;
if (updater != null)
{
flight.LastUpdatedBy = updater.ToString();
}
flight.StartType = start;
flight.StartCost = Double.Parse(row["StartCost"].ToString());
flight.FlightCost = Double.Parse(row["FlightCost"].ToString());
flight.TachoCost = Double.Parse(row["TachoCost"].ToString());
flight.TaskDistance = Int32.Parse(row["Km"].ToString());
flight.RecordKey = rkey; //// Int32.Parse(row["RecordKey"].ToString());
db.Flights.Add(flight);
db.SaveChanges();
i++;
}
}
string reloadTrigger = "Continuing import in 10 seconds...<script>setTimeout('window.location.reload()',5000);</script>";
// Done with import
if (i + omitted + invalid == startListeDataTable.Rows.Count)
reloadTrigger = "IMPORT FINISHED!";
return
string.Format(
"Imported {0} new flights.<br />Parsed {3} of {6}(allready imported {1}, skipped {2})<br /> <a href=\"{4}\">{5}</a><br /><br />{7}",
i,
omitted,
invalid,
i + omitted + invalid,
"/Flight",
"Back to list",
startListeDataTable.Rows.Count,
reloadTrigger);
////return RedirectToAction("Index");
}
public ActionResult Create(Flight flight)
{
if (!Request.IsAuthenticated) return null;
if (ModelState.IsValid)
{
// Remember base information in cookies
Response.Cookies["StartTypeId"].Value = flight.StartTypeId.ToString();
Response.Cookies["StartTypeId"].Expires = DateTime.Now.AddDays(31);
Response.Cookies["StartedFromId"].Value = flight.StartedFromId.ToString();
Response.Cookies["StartedFromId"].Expires = DateTime.Now.AddDays(31);
if (flight.LandedOnId != null)
{
Response.Cookies["LandedOnId"].Value = flight.LandedOnId.Value.ToString();
Response.Cookies["LandedOnId"].Expires = DateTime.Now.AddDays(31);
}
// Create base flight information fields
flight.FlightId = Guid.NewGuid();
flight.LastUpdated = DateTime.Now;
flight.LastUpdatedBy = Request.RequestContext.HttpContext.User.Identity.Name;
this.db.Flights.Add(flight);
this.db.SaveChanges();
return RedirectToAction("Grid");
}
this.PopulateViewBag(flight);
return View(flight);
}
public ActionResult Clone(Flight flight)
{
return Create(flight);
}
/// <summary>
/// Default ViewBag information for populating Flight select lists
/// </summary>
/// <param name="flight">The flight that is context to the dropdown lists</param>
private void PopulateViewBag(Flight flight)
{
this.ViewBag.PlaneId = new SelectList(this.db.Planes.Where(p => !p.ExitDate.HasValue || p.ExitDate.Value > DateTime.Today).OrderBy(p => p.CompetitionId), "PlaneId", "RenderName", (flight == null) ? (object)null : flight.PlaneId);
this.ViewBag.BetalerId = new SelectList(this.db.Pilots.OrderBy(p => p.Name), "PilotId", "RenderName", (flight == null) ? (object)null : flight.BetalerId);
this.ViewBag.PilotId = new SelectList(this.db.Pilots.OrderBy(p=>p.Name), "PilotId", "RenderName", (flight == null) ? (object)null : flight.PilotId);
this.ViewBag.PilotBackseatId = new SelectList(this.db.Pilots.OrderBy(p => p.Name), "PilotId", "RenderName", (flight == null) ? (object)null : flight.PilotBackseatId);
this.ViewBag.StartTypeId = new SelectList(this.db.StartTypes.OrderBy(p => p.Name), "StartTypeId", "Name", (flight == null) ? (object)null : flight.StartTypeId);
this.ViewBag.StartedFromId = new SelectList(this.db.Locations.OrderBy(p => p.Name), "LocationId", "Name", (flight == null) ? (object)null : flight.StartedFromId);
this.ViewBag.LandedOnId = new SelectList(this.db.Locations.OrderBy(p => p.Name), "LocationId", "Name", (flight == null) ? (object)null : flight.LandedOnId);
}
public ActionResult Edit(Flight flight)
{
if (!Request.IsAuthenticated) return null;
bool isEditable = false;
if (Request.RequestContext.HttpContext.User.IsInRole("Administrator")) { isEditable = true; }
if (Request.RequestContext.HttpContext.User.IsInRole("Editor")) { isEditable = true; }
if (flight.Date != null && flight.Date.AddDays(3) >= DateTime.Now)
{
isEditable = true;
}
if (!isEditable)
{
throw new SecurityAccessDeniedException(
string.Format("User {0} not allowed to edit this flight", this.Request.RequestContext.HttpContext.User.Identity.Name));
}
if (ModelState.IsValid)
{
this.db.Entry(flight).State = EntityState.Modified;
flight.LastUpdated = DateTime.Now;
flight.LastUpdatedBy = Request.RequestContext.HttpContext.User.Identity.Name;
this.db.SaveChanges();
return RedirectToAction("Grid");
}
ViewBag.ChangeHistory = this.GetChangeHistory(flight.FlightId);
ViewBag.FlightId = flight.FlightId;
this.PopulateViewBag(flight);
return View(flight);
}
