private void SaveAgent(object sender, RoutedEventArgs e) { try { using (ModelBD model = new ModelBD()) { int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]); Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault(); int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault(); realtors.FIO = FIOText.Text; realtors.Percent = int.Parse(PercentText.Text); model.Entry(realtors).State = System.Data.Entity.EntityState.Modified; model.SaveChanges(); SetChangeComboBox(realtors, apartament); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SaveAP(object sender, RoutedEventArgs e) { try { using (ModelBD model = new ModelBD()) { int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault(); int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]); Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault(); apartament.StreetName = STNameText.Text; apartament.HouseNumber = HouseNumText.Text; apartament.ApartamentNumber = int.Parse(APNumText.Text); apartament.SquareApartament = double.Parse(SquareText.Text); apartament.AmountRoom = int.Parse(AmountRoomText.Text); apartament.Price = decimal.Parse(PriceText.Text); model.Entry(apartament).State = System.Data.Entity.EntityState.Modified; model.SaveChanges(); SetChangeComboBox(realtors, apartament); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DeleteAP(object sender, RoutedEventArgs e) { try { using (ModelBD model = new ModelBD()) { int idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartaments = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault(); model.Apartaments.Remove(apartaments); model.SaveChanges(); int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]); Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault(); int? idAPart = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartament = model.Apartaments.Where(p => p.ID == idAPart).FirstOrDefault(); SetChangeComboBox(realtors, apartament); ClearTextBoxAP(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void AddAgentIntoBD(object sender, RoutedEventArgs e) { try { string _fio = FIOText.Text; int? _percent = int.Parse(PercentText.Text); if (_fio == "" && _percent == null || _fio != "" && _percent == null || _fio == "" && _percent != null) { MessageBox.Show("Не все поля заполненны!"); } else { using (ModelBD model = new ModelBD()) { Realtors realtors = new Realtors { FIO = _fio, Percent = _percent }; model.Realtors.Add(realtors); model.SaveChanges(); MessageBox.Show("Агент успешно добавлен"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult Edit(int id, Realtors realtors) { try { realtorsRepository.Update(realtors); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public ActionResult Create(Realtors message) { try { realtorsRepository.Add(message); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
//We can you this method to the get the Item of a specific username private async Task <Realtors> RealtorExists(string username) { string url = server + "/realtorusername?username="******"&includeAssets=false" + "&" + apiKey; Realtors item = new Realtors(); HttpResponseMessage response = await client.GetAsync(url); if (response.IsSuccessStatusCode) { string json = await response.Content.ReadAsStringAsync(); item = JsonConvert.DeserializeObject <Realtors>(json); } return(item); }
public async Task <ActionResult> DeleteRealtor(int id) { if (!await _realtorRepository.RealtorExists(id)) { return(NotFound()); } Realtors realtorEntityDelete = await _realtorRepository.GetRealtorById(id, true); if (realtorEntityDelete == null) { return(NotFound()); } _realtorRepository.DeleteRealtor(realtorEntityDelete); if (!await _realtorRepository.Save()) { return(StatusCode(500, "A problem happened while handling your request.")); } return(NoContent()); }
private void SetChangeComboBox(Realtors realtors, Apartaments apartament) { try { APComb.Items.Clear(); FIOComb.Items.Clear(); SetComboBox(); using (ModelBD model = new ModelBD()) { FIOComb.SelectedItem = realtors.FIO + " - ID: " + realtors.ID; APComb.SelectedItem = apartament.StreetName + " - ID: " + apartament.ID; } } catch (Exception ex) { } }
public async Task <IActionResult> RealtorRegister([Bind("Id,Username,Password,Firstname,Lastname")] Realtors realtors) { if (ModelState.IsValid) { string json = JsonConvert.SerializeObject(realtors); //Converting the input into a JSON object //Passing the json object of our stuff, and the headers in the response StringContent content = new StringContent(json, Encoding.UTF8, "application/json"); string url = server + "?" + apiKey; HttpResponseMessage response = await client.PostAsync(url, content); if (response.IsSuccessStatusCode) { return(RedirectToAction(nameof(First))); } return(RedirectToAction(nameof(First))); } return(View(realtors)); }
private void FIOComb_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (APComb.SelectedItem != null && FIOComb.SelectedItem != null) { using (ModelBD model = new ModelBD()) { int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]); Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault(); FIOText.Text = realtors.FIO; PercentText.Text = realtors.Percent.ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public async Task <IActionResult> RealtorLogin([Bind("Username,Password")] Realtors realtorUser) { if (ModelState.IsValid && realtorUser != null) { Realtors userItem = new Realtors(); try { string usernameEntered = realtorUser.Username.ToString(); string passwordEntered = realtorUser.Password.ToString(); userItem = await RealtorExists(usernameEntered); if (!(userItem == null)) { if (userItem.Username.ToString() != usernameEntered || userItem.Password.ToString() != passwordEntered) { ViewBag.result = "User not found."; } else if (userItem.Username.ToString() == usernameEntered && userItem.Password.ToString() == passwordEntered) { //Storing the Id of the realtor in the session, which will help to retrieve the Assets HttpContext.Session.SetInt32("realtorId", userItem.Id); return(RedirectToAction("AssetIndex", "Assets")); } } else { ViewBag.result = "User does not exist, please register"; } } catch (Exception e) { ViewBag.result = e.Message; } } ViewBag.result = "Username or Password are incorrect. Please try again."; return(View("First")); }
public void Update(Realtors realtors) { context.Realtors.Update(realtors); context.SaveChanges(); }
public void Add(Realtors realtors) { context.Realtors.Add(realtors); context.SaveChanges(); }
//Deleting a Realtor public void DeleteRealtor(Realtors realtors) { _context.Realtor.Remove(realtors); }
//Adding a Realtor public async Task AddRealtor(Realtors realtor) { await _context.Realtor.AddAsync(realtor); }