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();
}
