public async Task <IHttpActionResult> PutOpenHouse(int id, OpenHouse openHouse) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != openHouse.OpenHouseId) { return(BadRequest()); } db.Entry(openHouse).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OpenHouseExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void CreateOpenHouse(OpenHouse openHouse) { EstateBrokersContext dbcontext = new EstateBrokersContext(); dbcontext.OpenHouses.Add(openHouse); dbcontext.SaveChanges(); }
public void CreateOpenHouse(OpenHouse openHouse) { try { EFDatabase ef = new EFDatabase(); ef.CreateOpenHouse(openHouse); } catch (Exception) { throw; } }
public async Task <IHttpActionResult> PostOpenHouse(OpenHouse openHouse) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.OpenHouses.Add(openHouse); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = openHouse.OpenHouseId }, openHouse)); }
/// <summary> /// Knappen opretter en instans af OpenHouse klassen og kalder metoden /// ReturnOpenHouseEvenly. Information herfra inds�ttes i openHousePairs variablen /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnMakeSelection_Click(object sender, EventArgs e) { priceCasePair.Clear(); foreach (Case cases in properties) { priceCasePair.Add(new KeyValuePair <decimal, Case>(cases.NewestAskingPrice, cases)); } OpenHouse openHouse = new OpenHouse(agents, priceCasePair); openHousePairs = openHouse.ReturnOpenHouseEvenly(); UpdateList(); }
public async Task <IHttpActionResult> DeleteOpenHouse(int id) { OpenHouse openHouse = await db.OpenHouses.FindAsync(id); if (openHouse == null) { return(NotFound()); } db.OpenHouses.Remove(openHouse); await db.SaveChangesAsync(); return(Ok(openHouse)); }
public async Task <OpenHouseViewModel> Handle(CreateOpenHouseCommand request, CancellationToken cancellationToken) { var oh = new OpenHouse(request.RentalPropertyId, request.OpenhouseDate, request.StartTime, request.EndTime, request.IsActive, request.Notes, DateTime.Now, DateTime.Now); var listing = await _context.PropertyListing .Include(l => l.Contact) .Include(l => l.RentalProperty) .FirstAsync(l => l.RentalPropertyId == request.RentalPropertyId); _context.OpenHouse.Add(oh); var newOpenHouse = new OpenHouseViewModel(); newOpenHouse.OpenhouseDate = request.OpenhouseDate; newOpenHouse.IsActive = request.IsActive; newOpenHouse.StartTime = request.StartTime; newOpenHouse.EndTime = request.EndTime; newOpenHouse.Notes = request.Notes; var openProeprty = _context.RentalProperty.Include(a => a.Address).FirstOrDefault(p => p.Id == request.RentalPropertyId); newOpenHouse.RentalPropertyId = openProeprty.Id; newOpenHouse.PropertyName = openProeprty.PropertyName; newOpenHouse.PropertyType = openProeprty.PropertyType; newOpenHouse.streetCity = openProeprty.Address.StreetNum; newOpenHouse.streetCity = openProeprty.Address.City; newOpenHouse.PropertyType = openProeprty.Address.StateProvince; newOpenHouse.streetPostZipCode = openProeprty.Address.ZipPostCode; newOpenHouse.Listing = listing; newOpenHouse.Viewers = null; try { await _context.SaveChangesAsync(); newOpenHouse.Id = oh.Id; // Send message to message queue if needed } catch (Exception ex) { throw ex; } return(newOpenHouse); //throw new NotImplementedException(); }
private void updateNextOpenHouseDate() { if (co != null) { OpenHouse oh = OpenHouseControllerSingleton.Instance().GetNextOpenHouse(co.CaseOrderId); if (oh != null) { lbl_nextOpenHouse.Text = Convert.ToDateTime(oh.Date).ToShortDateString(); } else { lbl_nextOpenHouse.Text = "Ingen planlagte"; } } }
public ActionResult FinalPage(OpenHouse oh) { using (OpenHouseContext ohc = new OpenHouseContext()) { int idToUse = ohc.OpenHouse.Select(m => m.id).Max(); // get latest if needed var data = ohc.OpenHouse.Where(m => m.id == idToUse).FirstOrDefault(); data.Announcements = oh.Announcements; data.OpenDays = oh.OpenDays; data.WhatToBring = oh.WhatToBring; ohc.SaveChanges(); } return(RedirectToAction("Index", "Admin")); }
public HttpResponseMessage Put(OpenHouse openhouse) { HttpResponseMessage response; try { openHouseRepository.UpdateOpenHouse(openhouse); openHouseRepository.Save(); } catch (Exception ex) { response = Request.CreateResponse(HttpStatusCode.InternalServerError, "Error"); return(response); } response = Request.CreateResponse(HttpStatusCode.OK, "Success"); return(response); }
public async Task <IActionResult> OpenHouseSubmission(OpenHouseViewModel model) { if (ModelState.IsValid) { AppUser AppUser = await _userManager.FindByIdAsync(model.AppUserId); var openHouse = new OpenHouse(model, AppUser); _repo.AddEntity(openHouse); _repo.SaveChanges(); var emailOpenHouseViewModel = new EmailOpenHouseViewModel(model, AppUser); _emailSender.SendEmailAsync("*****@*****.**", $"{AppUser.FirstName} {AppUser.LastName} has submitted an Open House", "OpenHouseSubmission", emailOpenHouseViewModel); ModelState.Clear(); return(Redirect("/OpenHouseSubmission/OpenHouseSuccess")); } /* Read http://blog.staticvoid.co.nz/2012/entity_framework-navigation_property_basics_with_code_first/ */ return(View()); }
public async Task <IHttpActionResult> PostOpenHouse(OpenHouse openHouse) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } openHouse.OpenHouseCreatedDateTime = openHouse.OpenHouseLastUpdatedDateTime = DateTime.Now; db.OpenHouses.Add(openHouse); await db.SaveChangesAsync(); //load listing name db.Entry(openHouse).Reference(x => x.Listing).Load(); var openHouseDTO = new OpenHouseDTO() { OpenHouseId = openHouse.OpenHouseId, OpenHouseBeginDate = openHouse.OpenHouseBeginDate, OpenHouseEndDate = openHouse.OpenHouseEndDate, ListingId = openHouse.ListingId, ListingName = openHouse.Listing.ListingName }; return(CreatedAtRoute("DefaultApi", new { id = openHouse.OpenHouseId }, openHouseDTO)); }
public void InsertOpenHouse(OpenHouse openHouse) { openHouseContext.OpenHouses.Add(openHouse); }
public void DeleteOpenHouse(int openHouseId) { OpenHouse openHouse = openHouseContext.OpenHouses.Find(openHouseId); openHouseContext.OpenHouses.Remove(openHouse); }
public void DeleteOpenHouse(OpenHouse OpenHouse) { OpenHouseRepository.Delete(OpenHouse); }
public void UpdateOpenHouse(OpenHouse OpenHouse) { OpenHouseRepository.Update(OpenHouse); }
public void InsertOpenHouse(OpenHouse OpenHouse) { OpenHouseRepository.Insert(OpenHouse); }
public void RegisterDefaultAdmin(String secretCode) { if (secretCode.Equals("7617ed14946fe0c5005b301a30b15820e8a012db")) { XmlDocument doc = new XmlDocument(); //doc.Load("books.xml"); doc.Load(System.Web.Hosting.HostingEnvironment.MapPath("~/admin.xml")); //Display all the book titles. XmlNodeList nodes = doc.DocumentElement.SelectNodes("/admin"); foreach (XmlNode node in nodes) { string adminEmail = node.SelectSingleNode("email").InnerText; string pass = node.SelectSingleNode("pass").InnerText; var user = new ApplicationUser { UserName = adminEmail, Email = adminEmail }; var result = UserManager.Create(user, pass); if (result.Succeeded) { // Create the Users Model UserModel _userModel = new UserModel(); using (UserContext db = new UserContext()) { Guid newGuid = Guid.Parse(user.Id); /* * Need to create the association between database * Should create this on user registration which should be first form! * NOTE! We are not creating the array'd objects yet as we need to still * figure out how to handle them in the database */ _userModel.UserID = newGuid; _userModel.Email = user.Email; //_userModel.Birthday = new Date(); //_userModel.Birthday _userModel.Birthday = DateTime.Now; _userModel.BirthPlace = new BirthPlaceLocation(); _userModel.BirthPlace.UserID = newGuid; _userModel.ConsideredRaceAndEthnicity = new RaceEthnicity(); _userModel.ConsideredRaceAndEthnicity.UserID = newGuid; _userModel.HealthInfo = new Health(); _userModel.HealthInfo.UserID = newGuid; _userModel.HealthInfo.SeriousInjuryOrSurgeryDate = DateTime.Now; _userModel.SchoolInfo = new SchoolInfo(); _userModel.SchoolInfo.UserID = newGuid; _userModel.LivesWith = new LivesWith(); _userModel.LivesWith.UserID = newGuid; _userModel.MilitaryInfo = new MilitaryInfo(); _userModel.MailingAddress = new Address(); _userModel.MailingAddress.UserID = newGuid; _userModel.Name = new Name(); _userModel.Name.UserID = newGuid; _userModel.PhoneInfo = new Phone(); _userModel.PhoneInfo.UserID = newGuid; _userModel.ResidentAddress = new Address(); _userModel.ResidentAddress.UserID = newGuid; _userModel.Retainment = new Retained(); _userModel.Retainment.UserID = newGuid; _userModel.StudentChildCare = new ChildCare(); _userModel.StudentChildCare.UserID = newGuid; _userModel.StudentsParentingPlan = new ParentPlan(); _userModel.StudentsParentingPlan.UserID = newGuid; _userModel.LastUpdateDate = DateTime.Now; _userModel.role = new Roles(); _userModel.role.isAdmin = true; // now add the form info db.Users.Add(_userModel); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } } if (!CheckIfOpenHouseTableExists()) { OpenHouse ohObj = new OpenHouse(); ohObj.OpenDays = "Every Tuesday at 5:30PM & Thursday at 11AM"; ohObj.WhatToBring = "A picture id as well as signed forms"; using (OpenHouseContext ohc = new OpenHouseContext()) { ohc.OpenHouse.Add(ohObj); try { ohc.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } } if (!CheckIfIncomeTableExists()) { //await SignInManager.SignInAsync(user, isPersistent: false, rememberBrowser: false); string[] income1 = { "$ 0 to 1, 860", "$ 0 to 930", "$ 0 to 859", "$ 0 to 430", "$ 0 to 22,311" }; string[] income2 = { "$ 1,861 to 2,504", "$ 931 to 1,252", "$ 860 to 1,156", "$ 431 to 578", "$ 22,312 to 30,044" }; string[] income3 = { "$ 2,505 to 3,149", "$ 1,253 to 1,575", "$ 1,157 to 1,453", "$ 579 to 727", "$ 30,045 to 37,777" }; string[] income4 = { "$ 3,150 to 3,793", "$ 1,576 to 1,897", "$ 1,454 to 1,751", "$ 728 to 876", "$ 37,778 to 45,510" }; string[] income5 = { "$ 3,794 to 4,437", "$ 1,898 to 2,219", "$ 1,752 to 2,048", "$ 877 to 1,024", "$ 46,511 to 53,243" }; string[] income6 = { "$ 4,438 to 5,082", "$ 2,220 to 2,541", "$ 2,049 to 2,346", "$ 1,025 to 1,173", "$ 53,244 to 60,976" }; string[] income7 = { "$ 5,083 to 5,726", "$ 2,542 to 2,863", "$ 2,347 to 2,643", "$ 1,174 to 1,322", "$ 60,977 to 68,709" }; string[] income8 = { "$ 5,727 to 6,371", "$ 2,864 to 3,186", "$ 2,644 to 2,941", "$ 1,323 to 1,471", "$ 68,710 to 76,442" }; string[] income9 = { "$ 6,372 to 7,016", "$ 3, 187 to 3,509", "$ 2,942 to 3,239", "$ 1,472 to 1,620", "$ 76,443 to 84,175" }; string[] income10 = { "$ 7,107 to 7,661", "$ 3,510 to 3,832", "$ 3,240 to 3,537", "$ 1,621 to 1,769", "$ 84,176 to 91,908" }; string[] income11 = { "$ 7,662 to 8,306", "$ 3,833 to 4,155", "$ 3,538 to 3,835", "$ 1,770 to 1,918", "$ 91,909 to 99,641" }; string[] income12 = { "$ 8,307 to 8,951", "$ 4,156 to 4,478", "$ 3,836 to 4,133", "$ 1,919 to 2,067", "$ 99,642 to 107,374" }; string[] income13 = { "$ 8,952 to 9,596", "$ 4,479 to 4,801", "$ 4,134 to 4,431", "$ 2,068 to 2,216", "$ 107,375 to 115,107" }; string[] income14 = { "$ 9,597 to 10,241", "$ 4,802 to 5,124", "$ 4,432 to 4,729", "$ 2,217 to 2,365", "$ 115,108 to 122,840" }; string[] income15 = { "$ 10,242 to 10,886", "$ 5,125 to 5,447", "$ 4,730 to 5,027", "$ 2,366 to 2,514", "$ 122,841 to 130,573" }; using (var ic = new IncomeContext()) { List <string[]> list = new List <string[]>(); list.Add(income1); list.Add(income2); list.Add(income3); list.Add(income4); list.Add(income5); list.Add(income6); list.Add(income7); list.Add(income8); list.Add(income9); list.Add(income10); list.Add(income11); list.Add(income12); list.Add(income13); list.Add(income14); list.Add(income15); FamilyIncome income = new FamilyIncome(); income.incomeTable = new List <IncomeTable>(); income.id = 0; income.EffectiveDates = "Income Chart Effective from July 1, 2017 through June 30, 2018"; income.IncomeTableYears = "2017-18 Family Income Survey"; for (int i = 0; i < list.Count; i++) { IncomeTable table = new IncomeTable(); table.Monthly = list[i][0]; table.TwiceMonthly = list[i][1]; table.TwoWeeks = list[i][2]; table.Weekly = list[i][3]; table.Annually = list[i][4]; income.incomeTable.Add(table); } ic.Income.Add(income); try { ic.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } } } } }
public void CreateOpenHouse(OpenHouse item) { throw new NotImplementedException(); }
public void UpdateOpenHouse(OpenHouse openHouse) { openHouseContext.Entry(openHouse).State = EntityState.Modified; }