public MembersEntity getMemberBTransportDevice(TransportDevicesEntity transportDevice) { var linqQuery = from row in dbc.Members where row.Email.Equals(transportDevice.FKOwner.Email) select row; List <MembersEntity> membersList = linqQuery.ToList(); MembersEntity member = GetSingleResultWithoutExc(membersList); return(member); }
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); } }
public void RegisterService(ref TransportDevicesEntity transportDevicesEntity) { dbc = AliveContext.Context; dbc.TransportDevices.Add(transportDevicesEntity); dbc.SaveChanges(); FeedbackMessage = "Sikeres regisztráció!"; ServiceStatus = Status.OK; // it must be a method if (!string.IsNullOrEmpty(FeedbackMessage) && !string.IsNullOrWhiteSpace(FeedbackMessage)) { new PrintMessageBox(FeedbackMessage, ServiceStatus); } }
private void LoadSelectedTransportDevice() { TransportDevicesDao transportDevicesDao = new TransportDevicesDaoImpl(); TransportDevicesEntity transportDevice = transportDevicesDao.GetTransportDevicesById(Convert.ToInt32(id)); MembersDao membersDao = new MembersDaoImpl(); MembersEntity member = membersDao.getMemberBTransportDevice(transportDevice); ResponseMessage.Add("TransportDeviceName", transportDevice.TransportDeviceName); ResponseMessage.Add("CarryingCapacity", Convert.ToString(transportDevice.CarryingCapacity)); ResponseMessage.Add("TransportDeviceType", Convert.ToString(transportDevice.TransportDeviceType)); ResponseMessage.Add("TransportDeviceLength", Convert.ToString(transportDevice.TransportDeviceLength)); ResponseMessage.Add("TransportDeviceWidth", Convert.ToString(transportDevice.TransportDeviceWidth)); ResponseMessage.Add("TransportDeviceImage", Convert.ToString(transportDevice.TransportDeviceImage)); /*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*/ }
public void UpdateTransportDeviceData() { dbc = AliveContext.Context; TransportDevicesEntity transportDeviceData = dbc.TransportDevices.SingleOrDefault(m => m.TransportDeviceId.Equals(TransportDeviceId)); transportDeviceData.TransportDeviceId = this.TransportDeviceId; transportDeviceData.TransportDeviceName = this.TransportDeviceName; transportDeviceData.CarryingCapacity = this.CarryingCapacity; transportDeviceData.TransportDeviceType = this.TransportDeviceType; transportDeviceData.TransportDeviceLength = this.TransportDeviceLength; transportDeviceData.TransportDeviceWidth = this.TransportDeviceWidth; transportDeviceData.TransportDeviceImage = this.TransportDeviceImage; dbc.SaveChanges(); FeedbackMessage = "Adatok sikeresen módosítva!"; ServiceStatus = Status.OK; // it must be a method if (!string.IsNullOrEmpty(FeedbackMessage) && !string.IsNullOrWhiteSpace(FeedbackMessage)) { new PrintMessageBox(FeedbackMessage, ServiceStatus); } }
public RegisterTrasportDeviceService(ref TransportDevicesEntity transportDevicesEntity) { RegisterService(ref transportDevicesEntity); }