private void BoatDataCount() { BoatsDao boatsDao = new BoatsDaoImpl(); MembersDao membersDao = new MembersDaoImpl(); MembersEntity member = membersDao.getMemberByEmail(email); List <BoatsEntity> myBoats = boatsDao.GetAllBoatsByOwner(member); ResponseMessage.Add("BoatsCount", Convert.ToString(myBoats.Count)); }
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(); }
private void Register_Click(object sender, RoutedEventArgs e) { try { Validator registerValidator = new Validator(); if (imgBoatPicture.Tag == null) { imgBoatPicture.Tag = "Stock_transport_image.png"; } registerValidator.ValidationComponents.Add(new EmptyFieldValidator(imgBoatPicture.Tag.ToString(), "fénykép")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatLenght.Text, "Hossz")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatWidth.Text, "Szélesség")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatManpower.Text, "Kapacitás")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatName.Text, "Név")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatType.Text, "Típus")); registerValidator.ValidateElements(); BoatsDao boatsDao = new BoatsDaoImpl(); TransportDevicesEntity NewEntity = new TransportDevicesEntity(); dbc = AliveContext.Context; NewEntity.TransportDeviceId = dbc.Boats.OrderByDescending(u => u.BoatId).FirstOrDefault().BoatId; if (imgBoatPicture.Tag == null) { imgBoatPicture.Tag = "stock_boat_image.png"; } NewEntity.TransportDeviceImage = imgBoatPicture.Tag.ToString(); NewEntity.TransportDeviceLength = Convert.ToInt32(tbBoatLenght.Text); NewEntity.TransportDeviceWidth = Convert.ToInt32(tbBoatWidth.Text); NewEntity.TransportDeviceName = tbBoatName.Text; //boatsEntity.BoatRentals = null; NewEntity.TransportDeviceType = tbBoatType.Text; MembersDao membersDao = new MembersDaoImpl(); MembersEntity member = membersDao.getMemberByEmail(email); NewEntity.FKOwner = member; NewEntity.CarryingCapacity = Convert.ToInt32(tbBoatManpower.Text); RegisterTrasportDeviceService registerService = new RegisterTrasportDeviceService(ref NewEntity); MyBoatsAndDevicesWindow ToMyBoatsAndDevicesWindow = new MyBoatsAndDevicesWindow(email); //ToMyBoatsAndDevicesWindow.Show(); ; this.Close(); } catch (Exception ex) { new ExceptionToConsole(ex); } }
private void LoadSelectedBoat() { BoatsDao boatsDao = new BoatsDaoImpl(); BoatsEntity boat = boatsDao.GetBoatsById(Convert.ToInt32(id)); MembersDao membersDao = new MembersDaoImpl(); MembersEntity member = membersDao.getMemberByBoat(boat); ResponseMessage.Add("BoatName", boat.BoatName); ResponseMessage.Add("BoatImage", boat.BoatImage); ResponseMessage.Add("BoatType", boat.BoatType); ResponseMessage.Add("DailyPrice", Convert.ToString(boat.DailyPrice)); ResponseMessage.Add("WhereIsNowTheBoat", boat.WhereIsNowTheBoat); ResponseMessage.Add("IsLoan", Convert.ToString(boat.IsLoan)); ResponseMessage.Add("MaxPerson", Convert.ToString(boat.MaxPerson)); ResponseMessage.Add("MaxSpeed", Convert.ToString(boat.MaxSpeed)); ResponseMessage.Add("DiveDepth", Convert.ToString(boat.DiveDepth)); ResponseMessage.Add("Consumption", Convert.ToString(boat.Consumption)); ResponseMessage.Add("YearOfManufacture", Convert.ToString(boat.YearOfManufacture)); ResponseMessage.Add("BoatLength", Convert.ToString(boat.BoatLength)); ResponseMessage.Add("BoatWidth", Convert.ToString(boat.BoatWidth)); /*Member Adatok, ha az is kellene, például a foglalásnál*/ ResponseMessage.Add("email", member.Email); ResponseMessage.Add("password", member.Password); ResponseMessage.Add("permission", member.Permission.ToString()); char[] delimiter = { ' ' }; string[] memberName = member.MemberName.Split(delimiter); string[] firstnameaArray = memberName.Take(memberName.Count() - 1).ToArray(); string firstname = string.Join(" ", firstnameaArray); string lastname = memberName.Last(); ResponseMessage.Add("firstname", firstname); ResponseMessage.Add("lastname", lastname); ResponseMessage.Add("country", member.Country); ResponseMessage.Add("city", member.City); ResponseMessage.Add("street", member.Street); ResponseMessage.Add("houseNumber", member.HouseNumber); ResponseMessage.Add("MemberImage", member.MemberImage); /* ^^Member Adatok, ha az is kellene, például a foglalásnál*/ }
private void LoadMainBoatData() { BoatsDao boatsDao = new BoatsDaoImpl(); MembersDao membersDao = new MembersDaoImpl(); MembersEntity member = membersDao.getMemberByEmail(email); List <BoatsEntity> myBoats = boatsDao.GetAllBoatsByOwner(member); for (int i = 0; i < myBoats.Count; i++) { ResponseMessage.Add("boatName" + Convert.ToString(i), myBoats[i].BoatName); } for (int i = 0; i < myBoats.Count; i++) { ResponseMessage.Add("boatImage" + Convert.ToString(i), myBoats[i].BoatImage); } for (int i = 0; i < myBoats.Count; i++) { ResponseMessage.Add("boatId" + Convert.ToString(i), Convert.ToString(myBoats[i].BoatId)); } }
public LoadBookableBoatsService(DateTime startingDate, DateTime endingDate) { BookableBoatsUC = new BookableBoatsUC(); // ki kell valasztani azokat a halyokat, melyek: /* * - a startingDate nagyobb, mint a BoatRentals tablanak az endingDate-je * - az endingDate kisebb, mint a Boatrentals tablanak a startingDate-je * - foglalhato a hajo (isLoan mezo a Boats tablabol) */ BoatsDao bookableBoats = new BoatsDaoImpl(); BookableBoats = bookableBoats.GetBookableBoats(startingDate, endingDate); for (int i = 0; i < BookableBoats.Count; i++) { BookableBoatsUC.lbBookalbeShipsUC.Items.Add(BookableBoats[i].BoatName); } }
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; } }
private void Register_Click(object sender, RoutedEventArgs e) { try { Validator registerValidator = new Validator(); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatName.Text, "Név")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatType.Text, "Típus")); //registerValidator.ValidationComponents.Add(new EmptyFieldValidator(imgBoatPicture.Tag, "fénykép")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatLenght.Text, "Hossz")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatWidth.Text, "Szélesség")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatConsumption.Text, "Fogyasztás")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatPrice.Text, "Ár")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatDept.Text, "Merülési mélység")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatManpower.Text, "Max. Létszám")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatSpeed.Text, "Max. sebesség")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatPlace.Text, "Tartózkodási helye")); registerValidator.ValidationComponents.Add(new EmptyFieldValidator(tbBoatYear.Text, "Gyártási év")); registerValidator.ValidateElements(); BoatsDao boatsDao = new BoatsDaoImpl(); BoatsEntity boatsEntity = new BoatsEntity(); dbc = AliveContext.Context; boatsEntity.BoatId = dbc.Boats.OrderByDescending(u => u.BoatId).FirstOrDefault().BoatId; if (imgBoatPicture.Tag == null) { imgBoatPicture.Tag = "stock_boat_image.png"; } boatsEntity.BoatImage = imgBoatPicture.Tag.ToString(); boatsEntity.BoatLength = Convert.ToInt32(tbBoatLenght.Text); boatsEntity.BoatWidth = Convert.ToInt32(tbBoatWidth.Text); boatsEntity.BoatName = tbBoatName.Text; //boatsEntity.BoatRentals = null; boatsEntity.BoatType = tbBoatType.Text; boatsEntity.Consumption = Convert.ToInt32(tbBoatConsumption.Text); boatsEntity.DailyPrice = Convert.ToInt32(tbBoatPrice.Text); boatsEntity.DiveDepth = Convert.ToInt32(tbBoatDept.Text); MembersDao membersDao = new MembersDaoImpl(); MembersEntity member = membersDao.getMemberByEmail(email); boatsEntity.FKOwner = member; boatsEntity.IsLoan = tbIsLoan.IsChecked ?? false; boatsEntity.MaxPerson = Convert.ToInt32(tbBoatManpower.Text); boatsEntity.MaxSpeed = Convert.ToInt32(tbBoatSpeed.Text); boatsEntity.WhereIsNowTheBoat = tbBoatPlace.Text; boatsEntity.YearOfManufacture = Convert.ToInt32(tbBoatYear.Text); RegisterBoatService registerService = new RegisterBoatService(ref boatsEntity); MyBoatsAndDevicesWindow ToMyBoatsAndDevicesWindow = new MyBoatsAndDevicesWindow(email); //ToMyBoatsAndDevicesWindow.Show(); this.Close(); } catch (Exception ex) { new ExceptionToConsole(ex); } }