public AircraftEditViewModel(Aircraft entity)
{
Id = entity.Id;
Name = entity.Name;
RegistrationNumber = entity.RegistrationNumber;
this.Model = entity.Model;
TypeDesignation = entity.TypeDesignation;
Make = entity.Make;
Year = entity.Year;
MaxGrossWeight = entity.MaxGrossWeight;
FuelCapacity = entity.FuelCapacity;
//FuelTabCapacity = entity.FuelTabCapacity;
UsefulLoad = entity.UsefulLoad;
//EmptyWeight = entity.EmptyWeight;
//EmptyCG = entity.EmptyCG;
CruiseSpeed = entity.CruiseSpeed;
MaxRange = entity.MaxRange;
Description = entity.Description;
EquipmentList = entity.EquipmentList;
CheckoutRequirements = entity.CheckoutRequirements;
OperationalNotes = entity.OperationalNotes;
HourlyRate = entity.HourlyRate;
BasedAt = entity.BasedAt;
Status = entity.Status;
StatusNotes = entity.StatusNotes;
if (entity.Owners != null)
Owners = entity.Owners.Select(o =>
new AircraftOwnerInfo() { OwnerId = o.Id, Name = o.FirstName + " " + o.LastName })
.ToList();
if (entity.Images != null)
Images = entity.Images.ToList();
StatusValues = new SelectList(Enum.GetValues(typeof(AircraftStatus)).Cast<AircraftStatus>().Select(i => i.ToString()).ToList(), entity.Status);
}
public void UpdateAircraft(Aircraft aircraft)
{
_repository.Attach<Aircraft>(aircraft);
_repository.UnitOfWork.SaveChanges();
}
public Aircraft AddAircraft(Aircraft aircraft)
{
_repository.Add<Aircraft>(aircraft);
_repository.UnitOfWork.SaveChanges();
return _repository.FindOne<Aircraft>(a => a.RegistrationNumber == aircraft.RegistrationNumber);
}
private Aircraft CopyDataFromViewModel(Aircraft entity, AircraftEditViewModel viewModel)
{
entity.Year = viewModel.Year;
entity.BasedAt = viewModel.BasedAt;
entity.Make = viewModel.Make;
entity.CheckoutRequirements = viewModel.CheckoutRequirements;
entity.CruiseSpeed = viewModel.CruiseSpeed;
entity.Description = viewModel.Description;
entity.EquipmentList = viewModel.EquipmentList;
entity.FuelCapacity = viewModel.FuelCapacity;
entity.HourlyRate = viewModel.HourlyRate;
entity.MaxGrossWeight = viewModel.MaxGrossWeight;
entity.MaxRange = viewModel.MaxRange;
entity.Model = viewModel.Model;
entity.Name = viewModel.Name;
entity.OperationalNotes = viewModel.OperationalNotes;
entity.RegistrationNumber = viewModel.RegistrationNumber;
entity.Status = viewModel.Status;
entity.StatusNotes = viewModel.StatusNotes;
entity.TypeDesignation = viewModel.TypeDesignation;
entity.UsefulLoad = viewModel.UsefulLoad;
return entity;
}
public ActionResult Create(AircraftEditViewModel viewModel)
{
if (ModelState.IsValid)
{
if (_dataService.GetAircraftByRegNumber(viewModel.RegistrationNumber) == null)
{
Aircraft entity = new Aircraft();
entity = CopyDataFromViewModel(entity, viewModel);
_dataService.AddAircraft(entity);
return RedirectToAction("Index");
}
else
{
ModelState.AddModelError("RegistrationNumber", "Aircraft with registration number already exists in the database");
}
}
return View(viewModel);
}
//public void ImportMembers()
//{
// IEnumerator<NtfcDataSet.MembershipRow> rows = _dataSet.Membership.GetEnumerator();
// while (rows.MoveNext())
// {
// var srcMember = rows.Current;
// Login login = _dbContext.Logins.FirstOrDefault(l => l.Username == srcMember.Member_ID);
// // skip users that don't have logins
// if (login == null)
// continue;
// if (srcMember.IsFirst_NameNull())
// continue;
// if (srcMember.First_Name.Trim() == String.Empty || srcMember.First_Name == "----")
// continue;
// Member member = new Member();
// member.LoginId = login.Id;
// member.AddressLine_1 = !srcMember.IsAddressNull() ? srcMember.Address : null;
// member.Phone = !srcMember.IsHome_PhoneNull() ? srcMember.Home_Phone : null;
// member.AltPhone = !srcMember.IsWork_PhoneNull() ? srcMember.Work_Phone : null;
// member.City = !srcMember.IsCityNull() ? srcMember.City : null;
// member.Zip = !srcMember.IsZipNull() ? srcMember.Zip : null;
// member.PrimaryEmail = !srcMember.IsEmailNull() ? srcMember.Email : null;
// member.SecondaryEmail = !srcMember.Isemail2Null() ? srcMember.email2 : null;
// member.EmergencyName = !srcMember.IsE_First_NameNull() ? srcMember.E_First_Name + srcMember.E_Last_Name : null;
// member.EmergencyPhone = !srcMember.IsE_Home_PhoneNull() ? srcMember.E_Home_Phone : null;
// member.FirstName = srcMember.First_Name;
// member.LastName = srcMember.Last_Name;
// member.LastMedical = !srcMember.IsMedical_DateNull() ? (DateTime?)srcMember.Medical_Date : null;
// member.MemberSince = srcMember.Membership_Date;
// if (!srcMember.IsBirthdateNull())
// {
// DateTime dob = DateTime.MinValue;
// if (DateTime.TryParse(srcMember.Birthdate, out dob))
// member.BirthDate = dob;
// }
// member.PilotStatus = !srcMember.IsPilot_statusNull() ? srcMember.Pilot_status : null;
// _dbContext.Members.Add(member);
// }
// _dbContext.SaveChanges();
//}
public void ImportAircraft()
{
IEnumerator<NtfcDataSet.AircraftRow> rows = _dataSet.Aircraft.GetEnumerator();
Role ownerRole = _dbContext.Roles.First(r => r.Name.Contains("Owner"));
while (rows.MoveNext())
{
var row = rows.Current;
if (row.Tail_No == "N971BG" || row.Tail_No == "N2590H")
continue;
Aircraft aircraft = new Aircraft();
aircraft.Year = "";
aircraft.Make = "";
aircraft.CheckoutRequirements = row.Checkout;
aircraft.CruiseSpeed = Convert.ToInt16(row.Speed);
aircraft.Description = row.Description;
aircraft.EquipmentList = row.Equipment;
aircraft.FuelCapacity = Convert.ToInt16(row.FuelCap);
aircraft.HourlyRate = Convert.ToInt16(row.Hourly_Rate);
aircraft.MaxGrossWeight = Convert.ToInt16(row.MaxGrossWgt);
aircraft.MaxRange = Convert.ToInt16(row.Range);
aircraft.Model = row.Model;
aircraft.Name = String.Empty;
aircraft.RegistrationNumber = row.Tail_No;
aircraft.Status = AircraftStatus.Online.ToString();
aircraft.StatusNotes = String.Empty;
aircraft.TypeDesignation = String.Empty;
aircraft.UsefulLoad = (int)Convert.ToDouble(row.UsefulLoad);
aircraft.TypeDesignation = row.AC_Type;
aircraft.BasedAt = "TKI";
Login owner1 = _dbContext.Logins.Where(l => l.MemberPIN == row.Owner_MID).Include(l => l.ClubMember).FirstOrDefault();
owner1.ClubMember.First().Roles.Add(ownerRole);
aircraft.Owners = new List<Member>();
aircraft.Owners.Add(owner1.ClubMember.First());
if (!row.Isowner2_MIDNull())
{
string id = row.owner2_MID;
Login owner2 = _dbContext.Logins.Where(l => l.MemberPIN == id).Include(l => l.ClubMember).FirstOrDefault();
if (owner2 != null)
{
owner2.ClubMember.First().Roles.Add(ownerRole);
aircraft.Owners.Add(owner2.ClubMember.First());
}
}
_dbContext.Aircraft.Add(aircraft);
_dbContext.SaveChanges();
}
}