public List <SpotModel> SpotGetAll(int id) { List <SpotModel> spots = new List <SpotModel>(); // Ouverture de la connexion SQL DbConnect.Instance().connection.Open(); // Création d'une commande SQL MySqlCommand cmd = DbConnect.Instance().connection.CreateCommand(); // Requete SQL cmd.CommandText = $"SELECT spot.* FROM spot WHERE id_site = {id}"; // On veut récupérer les données sous forme d'un liste d'objets MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { SpotModel spot = new SpotModel(0, "", "", 0); spot.id = reader.GetInt32(0); spot.nom = reader.GetString(1); spot.gps = reader.GetString(2); spot.id_site = reader.GetInt32(3); spots.Add(spot); } } else { Console.WriteLine("No row found"); } reader.Close(); DbConnect.Instance().connection.Close(); return(spots); }
protected void imgBtn_Click(object sender, ImageClickEventArgs e) { String arg = (String)((ImageButton)sender).CommandArgument; String[] values = arg.Split('|'); SpotModel spot = new SpotModel(); SpotLocation location = new SpotLocation(); location.state = values[0]; location.city = values[1]; location.zipcode = values[2]; spot.location = location; spot.name = values[3]; spot.introduction = values[4]; spot.price = values[5]; SpotRootObject rootObj = new SpotRootObject(); rootObj.key = spot; String json = JsonConvert.SerializeObject(rootObj); Session["SpotDetails"] = json; Response.Redirect("~/Member/SpotDetails"); }
public async Task <IActionResult> PutSpotModel([FromRoute] long id, [FromBody] SpotModel spotModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != spotModel.SpotId) { return(BadRequest()); } _context.Entry(spotModel).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SpotModelExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void loadReport() { staticTimer.reset(); staticTimer.start("Total"); Report report = reader.GetReport(selectedAction, selectedAggPos, selectedCllPos, selectedBoardType, selectedBoardSubtype); spot = new SpotModel(report); if (selectedCategory != null && spot.Categories.Contains((HandCategory)selectedCategory)) { typeList = spot.StrengthTree[(HandCategory)selectedCategory]; } else { typeList = null; selectedType = null; } // refresh typelist if (selectedType != null && typeList.Contains((HandType)selectedType)) { spot.LoadPlotModel((HandType)selectedType); NotifyOfPropertyChange(() => PlotModel); } else { selectedType = null; } NotifyOfPropertyChange(() => Spot); staticTimer.stop("Total"); staticTimer.log("Total"); }
public JsonResult GetSpots(Guid id) { var v = (from spot in _context.Spots join place in _context.Places on spot.PlaceID equals place.ID join user in _context.Users on place.UserID equals user.ID orderby spot.CreationDate descending where spot.IsActive && !spot.IsDone && user.ID != id select new { spot.ID, spot.Title, PlaceTitle = place.Title, UserName = user.Name, spot.LowSal, spot.HighSal, spot.Phone, spot.Description, spot.Days, spot.Minutes, spot.IsPM, spot.Gender, spot.IsDone }).ToList(); List <SpotModel> spotsResults = new List <SpotModel>(); for (int i = 0; i < v.Count; i++) { SpotModel spotModel = new SpotModel(); spotModel.ID = v[i].ID; spotModel.Title = v[i].Title; spotModel.PlaceTitle = v[i].PlaceTitle; spotModel.UserName = v[i].UserName; spotModel.LowSal = v[i].LowSal; spotModel.HighSal = v[i].HighSal; spotModel.Phone = v[i].Phone; spotModel.Description = v[i].Description; spotModel.Days = v[i].Days; spotModel.Minutes = v[i].Minutes; spotModel.IsPM = v[i].IsPM; spotModel.Gender = v[i].Gender; var x = _context.Stareds.Where(y => y.SpotID == v[i].ID && y.UserID == id)?.SingleOrDefault(); if (x != null) { spotModel.IsStared = true; } else { spotModel.IsStared = false; } spotsResults.Add(spotModel); } return(Json(spotsResults)); }
public async Task <IActionResult> PostSpotModel([FromBody] SpotModel spotModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Spots.Add(spotModel); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSpotModel", new { id = spotModel.SpotId }, spotModel)); }
public async Task <BusinessResult <Guid> > CreateSpot(SpotModel SpotModel) { var spotEntity = Mapper.Map <Spot>(SpotModel); spotEntity.CreatedDate = DateTime.Now; spotEntity.AreaId = null; spotEntity.PictureUrls = new string[] { "A", "B", "C" }; DbContext.Spots.Add(spotEntity); await DbContext.SaveChangesAsync(true); return(CreateSuccessResult(spotEntity.Id)); }
public void GetSpot() { DataServiceFactory.Connection = _connection; SimpleDataService <SpotModel> factory = DataServiceFactory.GetSpotFactory(); Assert.NotNull(factory); Guid spotId = Guid.Parse("610b3ec0-0d70-40a6-9d9f-5167a8135410"); SpotModel existingSpot = factory.GetItemAsync(spotId).Result; Assert.True(existingSpot.SpotMarker.Count > 0); }
protected void Page_Load(object sender, EventArgs e) { haishengService = new HaishengServiceRef.Service1Client(); String json = (String)Session["SpotDetails"]; spot = JsonConvert.DeserializeObject <SpotRootObject>(json).key; image.ImageUrl = "../ImgCache/" + spot.name + ".jpg"; name.Text = "<Strong><h3>" + spot.name + "</h3></Strong>"; address.Text = spot.location.city + ", " + spot.location.state + ", " + spot.location.zipcode; introduction.Text = spot.introduction; price.Text = "<Strong><h1>" + "$" + spot.price + "</h1></Strong>"; searchWeather(); searchPOI(); }
public void SaveFishingArea() { DataServiceFactory.Connection = _connection; SimpleDataService <FishingAreaModel> factory = DataServiceFactory.GetFishingAreaFactory(); Assert.NotNull(factory); Guid areaId = Guid.NewGuid(); FishingAreaModel tstFishingArea = new FishingAreaModel(); tstFishingArea.Id = areaId; tstFishingArea.ID_WaterModel = Guid.Parse("2a3eeecf-472c-4b0f-9df0-73386cb3b3f7"); tstFishingArea.Lat = 48.46; tstFishingArea.Lng = 13.9267; tstFishingArea.FishingArea = "Donau Obermühl"; tstFishingArea.IsNew = true; FishingAreaModel success = factory.SaveItemAsync(tstFishingArea).Result; Assert.True(success.Id != Guid.Empty); FishingAreaModel storedFishingArea = factory.GetItemAsync(areaId).Result; Assert.True(storedFishingArea.Id == areaId); Guid spotId = Guid.NewGuid(); SpotModel newSpot = new SpotModel(); newSpot.FishingArea = storedFishingArea; newSpot.Id = spotId; newSpot.Spot = "Zanderfelsen"; newSpot.ID_FishingArea = storedFishingArea.Id; newSpot.ID_SpotType = Guid.Parse("1fb8243b-a672-496b-955a-5930cb706250"); newSpot.IsNew = true; storedFishingArea.Spots.Add(newSpot); success = factory.SaveItemAsync(storedFishingArea).Result; Assert.True(success.Id != Guid.Empty); }
public string AddNewSpotItem(TradeSharpConnection context, SpotModel model) { var result = string.Empty; var newContext = EnsureContext(ref context); try { var spot = new SPOT { ComBase = model.ComBase, ComCounter = model.ComCounter, Title = model.Title, CodeFXI = model.CodeFXI, MinVolume = model.MinVolume, MinStepVolume = model.MinStepVolume, Precise = model.Precise, SwapBuy = model.SwapBuy, SwapSell = model.SwapSell, Description = model.Description }; context.SPOT.Add(spot); context.SaveChanges(); } catch (Exception ex) { Logger.Error("AddNewSpotItem()", ex); result = ex.Message; } finally { if (newContext != null) { newContext.Dispose(); } } return(result); }
protected void btnAddSpot_Click(Object sender, EventArgs e) { try { SpotRootObject rootObj = new SpotRootObject(); SpotModel spot = new SpotModel(); spot.name = Name.Text; MemoryStream ms = new MemoryStream(Img.FileBytes); byte[] array = ms.ToArray(); spot.imgBytes = array; //spot.imgStr = Encoding.UTF8.GetString(array,0,array.Length); SpotLocation location = new SpotLocation(); location.state = State.Text; location.city = City.Text; location.zipcode = ZipCode.Text; spot.location = location; spot.introduction = Introduction.Text; spot.price = Price.Text; rootObj.key = spot; String json = JsonConvert.SerializeObject(rootObj); Boolean flag = haishengService.addSpot(json); if (!flag) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "<script>$('#remindModal').modal('show');</script>", false); } } catch (Exception ex) { throw ex; } }
public string EditSpotItem(TradeSharpConnection context, SpotModel model) { var result = string.Empty; var newContext = EnsureContext(ref context); try { var itemToEdit = context.SPOT.Single(x => x.Title == model.Title); itemToEdit.ComBase = model.ComBase; itemToEdit.ComCounter = model.ComCounter; itemToEdit.Title = model.Title; itemToEdit.CodeFXI = model.CodeFXI; itemToEdit.MinVolume = model.MinVolume; itemToEdit.MinStepVolume = model.MinStepVolume; itemToEdit.Precise = model.Precise; itemToEdit.SwapBuy = model.SwapBuy; itemToEdit.SwapSell = model.SwapSell; itemToEdit.Description = model.Description; context.SaveChanges(); } catch (Exception ex) { Logger.Error("EditSpotItem()", ex); result = ex.Message; } finally { if (newContext != null) { newContext.Dispose(); } } return(result); }
public ActionResult EditSpot(SpotModel model) { if (!ModelState.IsValid) { return(Json(new { status = false, errorString = Resource.ErrorMessageInvalid }, JsonRequestBehavior.AllowGet)); } try { using (var ctx = DatabaseContext.Instance.Make()) { var result = spotRepository.EditSpotItem(ctx, model); return(String.IsNullOrEmpty(result) ? Json(new { status = true }, JsonRequestBehavior.AllowGet) : Json(new { status = false, errorString = Resource.ErrorMessage + ": " + result }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Logger.Error("EditSpot() error", ex); return(Json(new { status = false, errorString = Resource.ErrorMessage + ": " + ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetSpotsByPlace([FromBody] SearchModel model) { #region temp var temp = (from p in _context.Places join s in _context.Spots on p.ID equals s.PlaceID join u in _context.Users on p.UserID equals u.ID orderby s.CreationDate descending where s.IsActive && p.ID == model.PlaceID && (model.isAll || model.isStarred ? !s.IsDone : true) select new { s.ID, s.Title, PlaceTitle = p.Title, UserName = u.Name, s.LowSal, s.HighSal, s.Phone, s.Description, s.Days, s.Minutes, s.IsPM, s.Gender, s.IsDone, }).ToList(); #endregion List <SpotModel> spotModels = new List <SpotModel>(); foreach (var v in temp) { bool isStarred = false; if (model.isStarred) { if (_context.Stareds.Where(x => x.SpotID == v.ID && x.UserID == model.UserID)? .SingleOrDefault() != null) { isStarred = true; } else { continue; } } else { if (_context.Stareds.Where(x => x.SpotID == v.ID && x.UserID == model.UserID)? .SingleOrDefault() != null) { isStarred = true; } } SpotModel ssMM = new SpotModel(); ssMM.ID = v.ID; ssMM.Title = v.Title; ssMM.PlaceTitle = v.PlaceTitle; ssMM.UserName = v.UserName; ssMM.LowSal = v.LowSal; ssMM.HighSal = v.HighSal; ssMM.Phone = v.Phone; ssMM.Description = v.Description; ssMM.Days = v.Days; ssMM.Minutes = v.Minutes; ssMM.IsPM = v.IsPM; ssMM.Gender = v.Gender; ssMM.IsDone = v.IsDone; ssMM.IsStared = isStarred; spotModels.Add(ssMM); } return(Json(spotModels)); }