private void GenerateDatabase()
{
var dbContext = AliveContext.Context;
dbContext.Database.Create();
//fill the database with temporarily data
MembersDao mem = new MembersDaoImpl();
List <MembersEntity> mems = mem.GetTemplateMembers();
for (int i = 0; i < mems.Count; i++)
{
dbContext.Members.Add(mems[i]);
}
dbContext.SaveChanges();
BoatsDao boat = new BoatsDaoImpl();
List <BoatsEntity> boats = boat.GetTemplateBoats();
for (int i = 0; i < boats.Count; i++)
{
dbContext.Boats.Add(boats.SingleOrDefault(b => b.BoatId == i));
}
dbContext.SaveChanges();
TransportDevicesDao device = new TransportDevicesDaoImpl();
List <TransportDevicesEntity> devices = device.GetTemplateTransportDevices();
for (int i = 0; i < devices.Count; i++)
{
dbContext.TransportDevices.Add(devices.SingleOrDefault(d => d.TransportDeviceId == i));
}
dbContext.SaveChanges();
RentRequestsDao rent = new RentRequestsDaoImpl();
List <RentRequestsEntity> rents = rent.GetTemplateRentRequests();
for (int i = 0; i < rents.Count; i++)
{
dbContext.RentRequests.Add(rents[i]);
}
dbContext.SaveChanges();
BoatRentalsDao boatRent = new BoatRentalsDaoImpl();
List <BoatRentalsEntity> boatRents = boatRent.GetTemplateBoatRents();
for (int i = 0; i < boatRents.Count; i++)
{
dbContext.BoatRentals.Add(boatRents[i]);
}
dbContext.SaveChanges();
}
public void LoadData(string email)
{
this.email = email;
MembersDaoImpl Members = new MembersDaoImpl();
RentRequestsDaoImpl RentRequests = new RentRequestsDaoImpl();
BoatsDaoImpl Boats = new BoatsDaoImpl();
int vaneuj = 0;
foreach (var Hajok in Boats.GetAllBoatsByOwner(Members.getMemberByEmail(email)))
{
foreach (var Requests in RentRequests.GetAllRentRequestsByBoatToBorrow(Hajok))
{
if (Requests.HowManyPersonWillTravel > 0)
{
vaneuj++;
}
}
}
if (vaneuj != 0)
{
foreach (var Hajok in Boats.GetAllBoatsByOwner(Members.getMemberByEmail(email)))
{
foreach (var Requests in RentRequests.GetAllRentRequestsByBoatToBorrow(Hajok))
{
if (Requests.HowManyPersonWillTravel > 0)
{
GlobalRequest = Requests;
lbNotification.Visibility = Visibility.Hidden;
btAccept.Visibility = Visibility.Visible;
btDecline.Visibility = Visibility.Visible;
cv1.Visibility = Visibility.Visible;
cv2.Visibility = Visibility.Visible;
cv3.Visibility = Visibility.Visible;
tbRenterEmail.Text = Requests.WhoBorrows.Email;
tbRenterName.Text = Requests.WhoBorrows.MemberName;
tbRenterResidency.Text = Requests.WhoBorrows.City;
tbStartPlace.Text = Requests.FromWhere;
tbEndPlace.Text = Requests.ToWhere;
tbPeople.Text = Requests.HowManyPersonWillTravel.ToString();
tbBoatName.Text = Requests.ToWhere;
dpEnd.Text = Requests.EndDate.ToString();
dpEnd.IsEnabled = false;
dpStart.Text = Requests.StartingDate.ToString();
dpStart.IsEnabled = false;
tbBoatName.Text = Hajok.BoatName;
tbBoatPlace.Text = Hajok.WhereIsNowTheBoat;
tbBoatDept.Text = Hajok.DiveDepth.ToString();
tbBoatPrice.Text = Hajok.DailyPrice.ToString();
tbBoatConsumption.Text = Hajok.Consumption.ToString();
tbBoatType.Text = Hajok.BoatType;
tbBoatManpower.Text = Hajok.MaxPerson.ToString();
tbBoatSpeed.Text = Hajok.MaxSpeed.ToString();
tbBoatWidth.Text = Hajok.BoatWidth.ToString();
tbBoatLenght.Text = Hajok.BoatLength.ToString();
tbBoatYear.Text = Hajok.YearOfManufacture.ToString();
LoadUserDataService loadUserDataService = new LoadUserDataService(email);
imgRenterPicture.Tag = loadUserDataService.ResponseMessage["MemberImage"];
var uri = new Uri(Convert.ToString(imgRenterPicture.Tag), UriKind.Absolute);
var bitmap = new BitmapImage(uri);
imgRenterPicture.Source = bitmap;
LoadSelectedBoatService loadSelectedBoatService = new LoadSelectedBoatService(Convert.ToString(Requests.BoatToBorrow.BoatId));
imgBoatPicture.Source = LoadImage(loadSelectedBoatService.ResponseMessage["BoatImage"]);
imgBoatPicture.Tag = loadSelectedBoatService.ResponseMessage["BoatImage"];
}
}
}
}
else
{
btAccept.Visibility = Visibility.Hidden;
btDecline.Visibility = Visibility.Hidden;
cv1.Visibility = Visibility.Hidden;
cv2.Visibility = Visibility.Hidden;
cv3.Visibility = Visibility.Hidden;
lbNotification.Visibility = Visibility.Visible;
}
}
