public async Task EmailToProviderAsync(EnquiryDto T, Vacation stock, Resort resort, Supplier supplier, UnitSizes unitSize) { var message = new TemplatedPostmarkMessage { To = supplier.Email, From = EmailFrom, TemplateId = 13249489, TemplateModel = new Dictionary <string, object> { { "provider", supplier.Description }, { "resort", resort.Description }, { "arrival", stock.Arrival.Date.ToString("dd/MM/yyyy") }, { "nights", stock.Nights }, { "unitSize", unitSize.Description }, { "product_name", "Holiday Booker" }, { "company_name", "Holiday Booker" } } }; var client = new PostmarkClient("ba4b7707-54c8-49d7-83d5-e215483fe37c"); var sendResult = await client.SendMessageAsync(message); if (sendResult.Status == PostmarkStatus.Success) { Console.WriteLine(sendResult.Status); } else { Console.WriteLine(sendResult.Status); } }
public async Task EmailToClientAsync(EnquiryDto T, Vacation stock, Resort resort, Supplier supplier, UnitSizes unitSize) { var message = new TemplatedPostmarkMessage { To = T.Email, From = EmailFrom, TemplateId = 20752183, TemplateModel = new Dictionary <string, object> { { "name", T.Name }, { "resort", resort.Description }, { "date", stock.Arrival.Date.ToString("dd/MM/yyyy") }, { "nights", stock.Nights }, { "unitsize", unitSize.Description }, { "priceToPay", stock.Price2Pay }, { "link", resort.Link }, { "adults", T.Adults }, { "kids", T.Under12 }, { "note", T.Note } } }; var client = new PostmarkClient("ba4b7707-54c8-49d7-83d5-e215483fe37c"); var sendResult = await client.SendMessageAsync(message); if (sendResult.Status == PostmarkStatus.Success) { Console.WriteLine(sendResult.Status); } else { Console.WriteLine(sendResult.Status); } }
public ResortFixture() { ResortPostRequest = new ResortPostRequest { Name = "New Resort", City = "Rivne", Country = "Ukraine" }; Resort = new Resort { Id = 1, Name = "New Resort", City = "Rivne", Country = "Ukraine" }; ResortDto = new ResortDto { Id = 1, Name = "New Resort", City = "Rivne", Country = "Ukraine" }; ResortUpdateRequest = new ResortUpdateRequest { Id = 1, Name = "New Resort", City = "Rivne", Country = "Ukraine" }; }
public async Task <IActionResult> PutResort(int id, [FromBody] Resort resort) { if (id != resort.ResortId) { return(BadRequest()); } _context.Entry(resort).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ResortExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Address,PhoneNumber,WeekdayHours,WeekendHours,Description,Lodging,RentEquipment,Url,UrlImage,DailyCost")] Resort resort) { if (id != resort.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(resort); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ResortExists(resort.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(resort)); }
private static void UpdateResort(Resort resort, ScrapeResort scrape, ResortService resortService) { resort.ResortStats.BaseLevel = scrape.BaseLevel; resort.ResortStats.TopLevel = scrape.TopLevel; resort.ResortStats.VerticalDrop = scrape.VerticalDrop; resort.ResortStats.LiftTotal = scrape.LiftTotal; resort.ResortStats.QuadPlusCount = scrape.QuadPlusCount; resort.ResortStats.QuadCount = scrape.QuadCount; resort.ResortStats.TripleCount = scrape.TripleCount; resort.ResortStats.DoubleCount = scrape.DoubleCount; resort.ResortStats.SingleCount = scrape.SingleCount; resort.ResortStats.SurfaceCount = scrape.SurfaceCount; resort.ResortStats.GondolaCount = scrape.GondolaCount; resort.ResortStats.FunicularCount = scrape.FunicularCount; resort.ResortStats.SurfaceTrainCount = scrape.SurfaceTrainCount; resort.ResortStats.RunTotal = scrape.RunTotal; resort.ResortStats.RedRuns = scrape.RedRuns; resort.ResortStats.BlueRuns = scrape.BlueRuns; resort.ResortStats.GreenRuns = scrape.GreenRuns; resort.ResortStats.BlackRuns = scrape.BlackRuns; resort.ResortStats.LongestRunDistance = scrape.LongestRunDistance; resort.ResortStats.AverageSnowfall = scrape.AverageSnowfall; resort.ResortStats.SnowmakingCoverage = scrape.SnowmakingCoverage; resort.ResortStats.SkiableTerrianSize = scrape.SkiableTerrianSize; resort.Display = true; resortService.Update(resort); }
public Resort GetById(int id) { Resort getResort = new Resort(); using (SqlConnection conn = new SqlConnection(connectString)) { SqlCommand cmd = new SqlCommand(selectQuery + byId, conn); cmd.Parameters.AddWithValue("@id", id); try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { getResort = new Resort { Id = int.Parse(reader[0].ToString()), Name = reader[1].ToString(), Location = reader[2].ToString(), Image = reader[3].ToString() }; } } catch (Exception ex) { Console.WriteLine(ex); throw; } } return(getResort); }
public List <Resort> GetList() { List <Resort> resortList = new List <Resort>(); using (SqlConnection conn = new SqlConnection(connectString)) { SqlCommand cmd = new SqlCommand(selectQuery, conn); try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Resort getResort = new Resort { Id = int.Parse(reader[0].ToString()), Name = reader[1].ToString(), Location = reader[2].ToString(), Image = reader[3].ToString() }; resortList.Add(getResort); } } catch (Exception ex) { Console.WriteLine(ex); throw; } } return(resortList); }
public ActionResult EditResort(int Id) { Resort resort = repository.GetResortByID(Id); return(View(resort)); }
public ActionResult Create([Bind(Include = "Id,Description,AdultCapacity,ChildCapacity,ImgURL,Price,ImgName,ResortID")] Room room, String roomName, HttpPostedFileBase postedFile) { ModelState.Clear(); var myUniqueFileName = string.Format(@"{0}", Guid.NewGuid()); room.ImgURL = myUniqueFileName; TryValidateModel(room); if (ModelState.IsValid) { string serverPath = Server.MapPath("~/RoomUploads/"); string fileExtension = Path.GetExtension(postedFile.FileName); string filePath = room.ImgURL + fileExtension; room.ImgURL = filePath; postedFile.SaveAs(serverPath + room.ImgURL); int resortId = room.ResortID; Resort resort = db.Resorts.Find(resortId); room.Name = roomName; db.Rooms.Add(room); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ResortID = new SelectList(db.Resorts, "Id", "Name", room.ResortID); return(View(room)); }
public static string ResortSuits(this HtmlHelper helper, Resort resort) { if (!ResortSuitsGroup1Check(resort) && !ResortSuitsGroup2Check(resort) && !ResortSuitsGroup3Check(resort) && !ResortSuitsGroup4Check(resort)) { return("<div style=\"margin: 0;line-height: 1.3em;\">No \"Resort Suits\" ratings are available yet. Do you have an opinion? Then be the first to <a class=\"rate\" href=\"/review/" + resort.PrettyUrl + "?ReturnUrl=/resorts/" + resort.PrettyUrl + "\" id=\"rateReviewResort\">add your ratings</a></div>"); } int[,] group1 = GetGroup1Values(resort); string ret = "<table class='table1 nobord'>"; ret += "<tr><th class='ratinghead' colspan='2'>Ability most suits ...</th></tr>"; ret += "<tr><td style='width: 60%'>Expert</td><td><span title='" + group1[1, 0] + "% (" + group1[1, 1] + " votes)' style='background-position: -" + (100 - group1[1, 0]) + "px 0;' class='rating-bar green'>" + group1[1, 0] + "%</span></td></tr>"; ret += "<tr><td>Advanced</td><td><span title='" + group1[2, 0] + "% (" + group1[2, 1] + " votes)' style='background-position: -" + (100 - group1[2, 0]) + "px 0;' class='rating-bar green'>" + group1[2, 0] + "%</span></td></tr>"; ret += "<tr><td>Intermediate</td><td><span title='" + group1[3, 0] + "% (" + group1[3, 1] + " votes)' style='background-position: -" + (100 - group1[3, 0]) + "px 0;' class='rating-bar green'>" + group1[3, 0] + "%</span></td></tr>"; ret += "<tr><td>Beginner</td><td><span title='" + group1[4, 0] + "% (" + group1[4, 1] + " votes)' style='background-position: -" + (100 - group1[4, 0]) + "px 0;' class='rating-bar green'>" + group1[4, 0] + "%</span></td></tr>"; int[,] group2 = GetGroup2Values(resort); ret += "<tr><th class='ratinghead' colspan='2'>Nightlife is ...</th></tr>"; ret += "<tr><td style='width: 60%'>Lively</td><td><span title='" + group2[1, 0] + "% (" + group2[1, 1] + " votes)' style='background-position: -" + (100 - group2[1, 0]) + "px 0;' class='rating-bar green'>" + group2[1, 0] + "%</span></td></tr>"; ret += "<tr><td>Average</td><td><span title='" + group2[2, 0] + "% (" + group2[2, 1] + " votes)' style='background-position: -" + (100 - group2[2, 0]) + "px 0;' class='rating-bar green'>" + group2[1, 0] + "%</span></td></tr>"; ret += "<tr><td>Quiet</td><td><span title='" + group2[3, 0] + "% (" + group2[3, 1] + " votes)' style='background-position: -" + (100 - group2[3, 0]) + "px 0;' class='rating-bar green'>" + group2[1, 0] + "%</span></td></tr>"; int[,] group3 = GetGroup3Values(resort); ret += "<tr><th class='ratinghead' colspan='2'>Terrian suits ...</th></tr>"; ret += "<tr><td style='width: 60%'>Skiers</td><td><span title='" + group3[1, 0] + "% (" + group3[1, 1] + " votes)' style='background-position: -" + (100 - group3[1, 0]) + "px 0;' class='rating-bar green'>" + group3[1, 0] + "%</span></td></tr>"; ret += "<tr><td>Snowboarders</td><td><span title='" + group1[2, 0] + "% (" + group3[2, 1] + " votes)' style='background-position: -" + (100 - group3[2, 0]) + "px 0;' class='rating-bar green'>" + group3[1, 0] + "%</span></td></tr>"; ret += "<tr><td>Both</td><td><span title='" + group3[3, 0] + "% (" + group3[3, 1] + " votes)' style='background-position: -" + (100 - group3[3, 0]) + "px 0;' class='rating-bar green'>" + group3[1, 0] + "%</span></td></tr>"; int[,] group4 = GetGroup4Values(resort); ret += "<tr><th class='ratinghead' colspan='2'>Expense level ...</th></tr>"; ret += "<tr><td style='width: 60%'>Expensive</td><td><span title='" + group4[1, 0] + "% (" + group4[1, 1] + " votes)' style='background-position: -" + (100 - group4[1, 0]) + "px 0;' class='rating-bar green'>" + group4[1, 0] + "%</span></td></tr>"; ret += "<tr><td>Affordable</td><td><span title='" + group4[2, 0] + "% (" + group4[2, 1] + " votes)' style='background-position: -" + (100 - group4[2, 0]) + "px 0;' class='rating-bar green'>" + group4[1, 0] + "%</span></td></tr>"; ret += "<tr><td>Cheap</td><td><span title='" + group4[3, 0] + "% (" + group4[3, 1] + " votes)' style='background-position: -" + (100 - group4[3, 0]) + "px 0;' class='rating-bar green'>" + group4[1, 0] + "%</span></td></tr>"; ret += "</table>"; return(ret); }
public static void PopulateResorts(IEnumerable <XElement> resorts, IList <Resort> resortsList) { if (resorts.Any()) { foreach (var resort in resorts) { var hotelsList = new List <Hotel>(); var airportsList = new List <Airport>(); var rsCodeNode = resort.Descendants("ResortCode").FirstOrDefault(); var nmrName = resort.Descendants("Name").FirstOrDefault(); Resort resortObject = null; if (rsCodeNode != null && nmrName != null) { resortObject = new Resort { ResortCode = rsCodeNode.Value, Name = nmrName.Value }; resortsList.Add(resortObject); resortObject.Airports = airportsList; resortObject.Hotels = hotelsList; } var airportsEnvelope = resort.Descendants("Airports"); var airports = airportsEnvelope.Descendants("Airport"); PopulateAirports(airports, airportsList); var hotelsEnvelope = resort.Descendants("Hotels"); var hotels = hotelsEnvelope.Descendants("Hotel"); PopulateHotels(hotels, hotelsList); } } }
public string AddPictureResort(int Id, string Path) { int count = 0; Resort data = context.Resorts.Find(Id); count = data.Images.Count(); if (count > 5) { return(""); } try { Resort entity = context.Resorts.Find(Id); Image image = new Image(); string text = "\\Resort" + entity.ResortId + "Picturenr" + (count + 1).ToString() + ".jpg"; image.ImagePath = "~\\Images" + text; entity.Images.Add(image); context.SaveChanges(); return(text); } catch { return(""); } }
public async Task <ActionResult <Resort> > PostResort([FromBody] Resort resort) { _context.Resort.Add(resort); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetResort), new { id = resort.Id }, resort)); }
public ActionResult EditResort(Resort resort) { repository.ChangeResort(resort); return(RedirectToAction("Index", "Owner")); }
//Create a method for retrieving data public List <Resort> GetAllResort() { SqlConnection con = new SqlConnection(connectionString); string query = "SELECT * FROM Resort"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <Resort> resorts = new List <Resort>(); while (reader.Read()) { Resort resort = new Resort(); resort.ResortId = (int)reader["ResortId"]; resort.ResortName = reader["ResortName"].ToString(); resort.ResortInformation = reader["ResortInformation"].ToString(); resorts.Add(resort); } reader.Close(); con.Close(); return(resorts); }
public ActionResult DeleteConfirmed(int id) { Resort resort = db.Resort.Find(id); db.Lodgings.Remove(resort); db.SaveChanges(); return(RedirectToAction("Index")); }
public static bool ResortSuitsGroup1Check(Resort resort) { if (resort.ResortSuitsExpert == 0 && resort.ResortSuitsAdvanced == 0 && resort.ResortSuitsIntermediate == 0 && resort.ResortSuitsBeginner == 0) { return(false); } return(true); }
public static bool ResortSuitsGroup2Check(Resort resort) { if (resort.ResortSuitsLively == 0 && resort.ResortSuitsAverage == 0 && resort.ResortSuitsQuiet == 0) { return(false); } return(true); }
public static bool ResortSuitsGroup3Check(Resort resort) { if (resort.ResortSuitsSkiers == 0 && resort.ResortSuitsSnowboarders == 0 && resort.ResortSuitsBoth == 0) { return(false); } return(true); }
public ActionResult DeleteConfirmed(int id) { Resort resort = db.Resorts.Single(r => r.id == id); db.Resorts.DeleteObject(resort); db.SaveChanges(); return(RedirectToAction("Index")); }
public static bool ResortSuitsGroup4Check(Resort resort) { if (resort.ResortSuitsExpensive == 0 && resort.ResortSuitsAffordable == 0 && resort.ResortSuitsCheap == 0) { return(false); } return(true); }
public void Edit(Resort updatedResort) { Resort editResort = GetById(updatedResort.Id); editResort.Location = updatedResort.Location; editResort.Name = updatedResort.Name; editResort.Image = updatedResort.Image; }
public static Resort GetResortByName(string prettyUrl) { Resort resort = new Resort(); //TODO: put all this in a method SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQL2005_615410_sporthubConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand("GetResortByName", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@PrettyUrl", prettyUrl)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet dataSet = new DataSet(); da.Fill(dataSet); DataTable resortTable = dataSet.Tables[0]; DataTable continentTable = dataSet.Tables[1]; DataTable countryTable = dataSet.Tables[2]; DataTable regionTable = dataSet.Tables[3]; DataTable resortLinksTable = dataSet.Tables[4]; //TODO: error handle try { if (resortTable.Rows.Count > 0) { resort = DataConverter.ToType <Resort>(resortTable.Rows[0]); if (continentTable.Rows.Count > 0) { resort.Continent = DataConverter.ToType <Continent>(continentTable.Rows[0]); } if (countryTable.Rows.Count > 0) { resort.Country = DataConverter.ToType <Country>(countryTable.Rows[0]); } //TODO: regions if (resortLinksTable.Rows.Count > 0) { resort.ResortLinks = new List <ResortLink>(); foreach (DataRow resortLink in resortLinksTable.Rows) { resort.ResortLinks.Add(DataConverter.ToType <ResortLink>(resortLink)); } } } } catch (Exception ex) { var message = ex.Message; //TODO: error handle } return(resort); }
public ActionResult Edit([Bind(Include = "Id,Name,Country,Location,CheapestRoom,ImageUrl,Description")] Resort resort) { if (ModelState.IsValid) { _db.Entry(resort).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(resort)); }
public ActionResult Edit([Bind(Include = "Id,Name,Description,Address,ImgURL,ImgName,Rating,ResortLat,ResortLong")] Resort resort) { if (ModelState.IsValid) { db.Entry(resort).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("AdminIndex")); } return(View(resort)); }
public ActionResult Edit([Bind(Include = "Id,Name")] Resort resort) { if (ModelState.IsValid) { db.Entry(resort).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(resort)); }
public ActionResult Edit(Resort resort) { if (ModelState.IsValid) { db.Resorts.Attach(resort); db.ObjectStateManager.ChangeObjectState(resort, EntityState.Modified); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(resort)); }
public ActionResult Create([Bind(Include = "Id,Name")] Resort resort) { if (ModelState.IsValid) { db.Resorts.Add(resort); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(resort)); }
public ActionResult Edit([Bind(Include = "LodgingId,Name,Owner,IsResort,MilesFromNearestAirport,DestinationId,Entertainment,Activities")] Resort resort) { if (ModelState.IsValid) { db.Entry(resort).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DestinationId = new SelectList(db.Destinations, "DestinationId", "Name", resort.DestinationId); return(View(resort)); }
public void SaveResort(Resort resort) { if (resort.Id == 0) { Db.Resorts.Add(resort); } else { Resort dbEntry = Db.Resorts.Find(resort.Id); if (dbEntry != null) { dbEntry.Name = resort.Name; dbEntry.Description = resort.Description; dbEntry.PhotoData = resort.PhotoData; dbEntry.PhotoMimeType = resort.PhotoMimeType; } } Db.SaveChanges(); }
public ActionResult EditResort(Resort resort, HttpPostedFileBase uploadImage) { if (ModelState.IsValid && uploadImage != null) { byte[] imageData; using (var binaryReader = new BinaryReader(uploadImage.InputStream)) { imageData = binaryReader.ReadBytes(uploadImage.ContentLength); } resort.PhotoData = imageData; repository.SaveResort(resort); TempData["message"] = string.Format("{0} has been saved", resort.Id); return RedirectToAction("ResortList"); } else { return View(resort); } }
public static void ReadBuildResort() { int counter = 1; string line; System.IO.StreamReader file = new System.IO.StreamReader(@"rca.csv"); while ((line = file.ReadLine()) != null) { System.Console.WriteLine(line); string[] array; string[] separator = { "," }; if (counter > 0) { int uid = Idcount + counter-1; array = line.Split(separator, StringSplitOptions.None); Name[uid] = array[0]; resorts[counter] = new Resort(); resorts[counter].id=uid; resorts[counter].name = array[0]; double t=0; if (array[1] == "半天") { t = 0.5; resorts[counter].deftime = TimeSpan.FromHours(t * 8); } if (array[1] == "一天") { t = 1; resorts[counter].deftime = TimeSpan.FromHours(t * 8); } resorts[counter].test = resorts[counter].deftime; if (array[1] == "两天") { t = 2; resorts[counter].deftime = TimeSpan.FromHours(t * 8); t = 1; resorts[counter].test = TimeSpan.FromHours(t * 8); } if (array[2] != "") { resorts[counter].CityNear.Add(cities[Array.LastIndexOf(Name, array[2])]); double i = 0; double.TryParse(array[3], out i); { i = 2; } resorts[counter].CityNearTime.Add(TimeSpan.FromHours(i)); } if (array[4] != "") { resorts[counter].CityNear.Add(cities[Array.LastIndexOf(Name, array[4])]); double i = 0; if (double.TryParse(array[5], out i)) { { i = 2; } resorts[counter].CityNearTime.Add(TimeSpan.FromHours(i )); } } if (array[6] != "") { resorts[counter].CityNear.Add(cities[Array.LastIndexOf(Name, array[6])]); double i = 0; if (double.TryParse(array[7], out i)) { if (i > 2) { i = 2; } resorts[counter].CityNearTime.Add(TimeSpan.FromHours(i)); } } } counter++; } file.Close(); }