public void Create_Insert_Get_Delete() { var model = new MyModel(); model.Name = Guid.NewGuid().ToString(); m_SqlRepository.Insert(model); var existingId = model.Id; model = m_SqlRepository.Get <MyModel>(i => i.Id == existingId); Assert.IsNotNull(model); var name = Guid.NewGuid().ToString(); model.Name = name; m_SqlRepository.Update(model); model = m_SqlRepository.Get <MyModel>(i => i.Id == existingId); Assert.AreEqual(name, model.Name); m_SqlRepository.Delete(model); model = m_SqlRepository.Get <MyModel>(i => i.Id == existingId); Assert.IsNull(model); }
public async Task <IActionResult> OnGetAsync() { try { #region واکشی مکان ها از دیتابیس SqlRepository <tblPalces> repPalce = new SqlRepository <tblPalces>(); double _NorthEastLat = double.Parse(Input.NorthEast.Split(new char[] { ',' })[0].Trim()); double _NorthEastLng = double.Parse(Input.NorthEast.Split(new char[] { ',' })[1].Trim()); double _SouthWestLat = double.Parse(Input.SouthWest.Split(new char[] { ',' })[0].Trim()); double _SouthWestLng = double.Parse(Input.SouthWest.Split(new char[] { ',' })[1].Trim()); var qLocalPlace = await repPalce.Get() //.Where(a => a.Zoom <= Input.Zoom) .Where(a => a.Name.Contains(Input.Address.Trim())) .Where(a => a.Lat <= _NorthEastLat) .Where(a => a.Lng <= _NorthEastLng) .Where(a => a.Lat >= _SouthWestLat) .Where(a => a.Lng >= _SouthWestLng) .Select(a => new vmCompo_ListSearch { ImgName = a.tblPalceCategoris.ImgName, Lat = a.Lat, Lng = a.Lng, Name = a.Name, Zoom = a.Zoom }) .OrderBy(a => a.Name) .Skip(0) .Take(5) .ToListAsync(); Data.AddRange(qLocalPlace); #endregion #region واکشی اطلاعات از سرویس دهنده ها var _data = await new ComponentWapper().GetDataAsync("http://photon.komoot.de/api/", new { q = Input.Address, limit = 5 }); var JsonData = JObject.Parse(_data); var qData = JsonData["features"].Select(a => new vmCompo_ListSearch { Lng = double.Parse(a["geometry"]["coordinates"][0].ToString()), Lat = double.Parse(a["geometry"]["coordinates"][1].ToString()), Name = (a["properties"]["state"] == null ? "" : (a["properties"]["state"] + ", ")) + a["properties"]["name"], Zoom = 13, ImgName = "marker-here.png" }).ToList(); Data.AddRange(qData); #endregion return(Page()); } catch (Exception ex) { logger.Error(ex); throw ex; } }
public async Task <IActionResult> OnGetAsync() { try { SqlRepository <tblPalces> repPalce = new SqlRepository <tblPalces>(); double _NorthEastLat = double.Parse(Input.NorthEast.Split(new char[] { ',' })[0].Trim()); double _NorthEastLng = double.Parse(Input.NorthEast.Split(new char[] { ',' })[1].Trim()); double _SouthWestLat = double.Parse(Input.SouthWest.Split(new char[] { ',' })[0].Trim()); double _SouthWestLng = double.Parse(Input.SouthWest.Split(new char[] { ',' })[1].Trim()); var qData = await repPalce.Get() .Where(a => a.Zoom <= Input.Zoom) .Where(a => a.Lat <= _NorthEastLat) .Where(a => a.Lng <= _NorthEastLng) .Where(a => a.Lat >= _SouthWestLat) .Where(a => a.Lng >= _SouthWestLng) .Select(a => new vmCompo_Places { Category = a.tblPalceCategoris.Title, ImgName = a.tblPalceCategoris.ImgName, Lat = a.Lat, Lng = a.Lng, Name = a.Name }).ToListAsync(); return(new JsonResult(qData)); } catch (Exception ex) { logger.Error(ex); throw ex; } }
public static async Task <tblUsers> GetUserDetailsAsync(this ClaimsPrincipal User) { var repUser = new SqlRepository <tblUsers>(); try { var qUser = await repUser.Get() .Where(a => a.UserName == User.Identity.Name) .Select(a => new tblUsers { Email = a.Email, Family = a.Family, Id = a.Id, Name = a.Name, UserName = a.UserName }) .SingleOrDefaultAsync(); return(qUser); } catch (Exception ex) { throw ex; } finally { repUser.Dispose(); } }
public static IEnumerable<Snapshot> GetSnapshots(SqlRepository Repository) { string Query = "SELECT Name, Active FROM " + _SnapshotTable; return Repository.Get<Snapshot>(Query, null, false); }