public void TestCreateRouteInSummitGroup() { ICountryDao countryDao = new CountryDao(_graphClient); Country newCountry = new Country { Name = "Deutschland" }; countryDao.Create(newCountry); IAreaDao areaDao = new AreaDao(_graphClient); Area area = new Area(); areaDao.Create(newCountry, area); ISummitGroupDao summitGroupDao = new SummitGroupDao(_graphClient); SummitGroup summitGroup = new SummitGroup { Name = "Gipfelgruppe" }; summitGroupDao.Create(area, summitGroup); IRoutesDao routeDao = new RouteDao(_graphClient); Route newRoute = new Route { Name = "Jakobsweg" }; routeDao.CreateIn(summitGroup, newRoute); IList <Route> allRoutes = _graphClient.Cypher.Match("(route:Route)") .Return(route => route.As <Route>()) .Results.ToList(); Assert.AreEqual(1, allRoutes.Count); }
public FrmArea() { InitializeComponent(); stationDao = new StationDao(); areaDao = new AreaDao(); loungeDao = new LoungeDao(); }
/// <summary> /// 根据省市区名称获取对应的省市区编码 add by caoheyang 20150407 /// </summary> /// <param name="model">参数实体</param> /// <returns></returns> public string GetOpenCode(Ets.Model.ParameterModel.Area.ParaAreaNameInfo model) { var redis = new ETS.NoSql.RedisCache.RedisCache(); string key = MD5.Encrypt(string.Format("{0}_{1}_{2}", model.ProvinceName, model.CityName, model.AreaName).Replace(" ", "")); string cacheValue = redis.Get <string>(key); if (string.IsNullOrWhiteSpace(cacheValue)) { DMAreaCodeInfo tempModel = new AreaDao().GetOpenCodeSql(model); if (tempModel == null) { return(null); } else if (tempModel.AreaIsOpen == 0 || tempModel.ProvinceIsOpen == 0 || tempModel.CityIsOpen == 0) { redis.Set(key, SystemConst.CityOpenInfo, DateTime.Now.AddDays(30)); } else { redis.Set(key, string.Format("{0}_{1}_{2}", tempModel.ProvinceCode, tempModel.CityCode, tempModel.AreaCode) , DateTime.Now.AddDays(30)); } } return(redis.Get <string>(key)); }
public static void downloadArea() { String StationID = ManageLOG.getValueFromRegistry(Configurations.AppRegName, "StationID"); int total = 0; int success = 0; AreaDao dao = new AreaDao(); List <ModelArea> lists = dao.Select(" Where area_station=" + StationID); if (lists != null) { total = lists.Count; logger.Debug("# Start download [AREA] from server."); foreach (ModelArea model in lists) { List <ModelArea> tmp = dao.SelectOffine(" Where id='" + model.id + "'"); if (tmp != null) { if (tmp.Count > 0) { } else { if (dao.InsertOffline(model)) { success++; } } } } logger.Debug("# Summary=> Total Download total: " + total + " success: " + success + " fail: " + (total - success)); logger.Debug("# End Download data from server."); } }
public void TestGetRoutesInSummitGroup() { ICountryDao countryDao = new CountryDao(_graphClient); Country country = new Country { Name = "Deutschland" }; countryDao.Create(country); IAreaDao areaDao = new AreaDao(_graphClient); Area area = new Area(); areaDao.Create(country, area); ISummitGroupDao summitGroupDao = new SummitGroupDao(_graphClient); SummitGroup summitGroup = new SummitGroup { Name = "Gipfelgruppe" }; summitGroupDao.Create(area, summitGroup); IRoutesDao routeDao = new RouteDao(_graphClient); Route created = routeDao.CreateIn(summitGroup, new Route { Name = "Jakobsweg" }); IList <Route> routesInArea = routeDao.GetRoutesIn(summitGroup); Assert.AreEqual(1, routesInArea.Count); Assert.AreEqual("Jakobsweg", routesInArea.First().Name); Assert.AreEqual(created.Name, routesInArea.First().Name); }
public static void Update(Area item) { AreaEntity entity; entity = AreaMapper.Get(item); AreaDao.Update(entity); }
public void Insert(DataTable areaTable) { using (PersistentManager pm = new PersistentManager()) { AreaDao areaDao = new AreaDao(); areaDao.BatchInsertArea(areaTable); } }
public void Save(string sortID, string areaCode) { using (PersistentManager pm = new PersistentManager()) { AreaDao areaDao = new AreaDao(); areaDao.UpdateEntity(sortID, areaCode); } }
public List <AreaBean> ListarAreaPerfil(int idperfil) { areadao = new AreaDao(); var areas = new List <AreaBean>(); areas = areadao.ListarAreaPerfil(idperfil); return(areas); }
public static int Add(Area item) { AreaEntity entity; entity = AreaMapper.Get(item); item.Id = AreaDao.Add(entity); return(item.Id); }
public ActionResult getAreasInteres() { using (var AreaDao = new AreaDao()) { IList <Area> tiendas = AreaDao.GetAll <Area>(); return(Json(tiendas, JsonRequestBehavior.AllowGet)); } }
public List <AreaBean> ListarAreas() { areadao = new AreaDao(); var areas = new List <AreaBean>(); areas = areadao.ListarArea(); return(areas); }
public static decimal GetDeliveryFee(List <CartInfo> cartInfoList, AddressInfo addressInfo, DeliveryInfo deliveryInfo) { if (cartInfoList == null || deliveryInfo == null) { return(0); } var startStandards = deliveryInfo.StartStandards; var startFees = deliveryInfo.StartFees; var addStandards = deliveryInfo.AddStandards; var addFees = deliveryInfo.AddFees; if (addressInfo != null) { var areaInfoList = AreaDao.GetAreaInfoList(deliveryInfo.Id); foreach (var areaInfo in areaInfoList) { var cities = areaInfo.Cities.Split(',').ToList(); foreach (var city in cities) { if (!addressInfo.Location.Contains(city)) { continue; } startStandards = areaInfo.StartStandards; startFees = areaInfo.StartFees; addStandards = areaInfo.AddStandards; addFees = areaInfo.AddFees; } } } var count = 0; foreach (var cartInfo in cartInfoList) { if (cartInfo.IsDelivery) { count += cartInfo.Count; } } var deliveryFee = startFees; if (count > startStandards) { var add = count - startStandards; if (addStandards > 0 && addFees > 0) { deliveryFee += Math.Floor(Convert.ToDecimal(add / addStandards)) * addFees; } } return(deliveryFee); }
public void TestDeleteInUse() { Area area = _dataGenerator.CreateArea(); Route route = _dataGenerator.CreateRouteInArea(area: area); IAreaDao areaDao = new AreaDao(_graphClient); Action action = () => areaDao.Delete(area); action.ShouldThrow <NodeInUseException>(); }
public void TestDeleteNotInUse() { Country country = _dataGenerator.CreateCountry(); Area area = _dataGenerator.CreateArea(country: country); IAreaDao areaDao = new AreaDao(_graphClient); areaDao.Delete(area); Assert.AreEqual(0, areaDao.GetAllIn(country).Count); }
public void TestIsInUseByRoute() { Area area = _dataGenerator.CreateArea(); Route route = _dataGenerator.CreateRouteInArea(area: area); IAreaDao areaDao = new AreaDao(_graphClient); bool isInUse = areaDao.IsInUse(area); Assert.IsTrue(isInUse); }
public FrmStaff() { InitializeComponent(); userDao = new UserDao(); staffDao = new StaffDao(); stationDao = new StationDao(); loungeDao = new LoungeDao(); roleDao = new RoleDao(); areaDao = new AreaDao(); }
public static Area Get(int id) { Area item; AreaEntity entity; entity = AreaDao.Get(id); item = AreaMapper.Get(entity); return(item); }
public void TestIsInUseBySummitGroup() { Area area = _dataGenerator.CreateArea(); SummitGroup summitGroup = _dataGenerator.CreateSummitGroup(area: area); IAreaDao areaDao = new AreaDao(_graphClient); bool isInUse = areaDao.IsInUse(area); Assert.IsTrue(isInUse); }
public void TestGetPage() { IAreaDao area = new AreaDao(); int count = 0; IList <TravelAgent.Model.Area> list = area.Get("", 2, 10, out count); foreach (TravelAgent.Model.Area item in list) { Console.WriteLine(item.ShortName); } }
public int GetCount(string filter) { int count = 0; using (PersistentManager pm = new PersistentManager()) { AreaDao areaDao = new AreaDao(); count = areaDao.FindCount(filter); } return(count); }
public void Add() { IAreaDao area = new AreaDao(); IList <TravelAgent.Model.Area> list = area.Get("Pid = 510000"); //Assert.IsNotNull(list); foreach (TravelAgent.Model.Area item in list) { Console.WriteLine(item.Name); } }
public DataTable GetAll(int pageIndex, int pageSize, string filter) { DataTable table = null; using (PersistentManager pm = new PersistentManager()) { AreaDao areaDao = new AreaDao(); table = areaDao.FindAll((pageIndex - 1) * pageSize, pageSize, filter); } return(table); }
public void TestUpdate() { Country country = _dataGenerator.CreateCountry(); Area area = _dataGenerator.CreateArea(country: country, name: "oldname"); area.Name = "newname"; IAreaDao areaDao = new AreaDao(_graphClient); areaDao.Save(area); Assert.AreEqual("newname", areaDao.GetAllIn(country).First().Name); }
public void TestCreateAndGetAll() { Country country = _dataGenerator.CreateCountry(); AreaDao dao = new AreaDao(_graphClient); Area created = _dataGenerator.CreateArea(country: country); IEnumerable <Area> areasInCountry = dao.GetAllIn(country); Assert.AreEqual(1, areasInCountry.Count()); Assert.AreEqual(created.Name, areasInCountry.First().Name); Assert.AreEqual(created.Id, areasInCountry.First().Id); Assert.AreEqual(created.Id, areasInCountry.First().Id); }
public JsonResult CreateAccount(string accountName, string accountPass, string typeOfAccount) { var checkCreate = new AccountDao().createAccount(accountName, Encryptor.MD5Hash(accountPass), typeOfAccount); var listArea = new AreaDao().ListArea(); var listJob = new JobMajorDao().ListJobMain(); return(Json(new { userId = checkCreate, listArea = listArea, listJob = listJob })); }
public Area CreateArea(string name = "Gebiet", Country country = null) { if (country == null) { country = CreateCountry(); } AreaDao areaDao = new AreaDao(_graphClient); Area newArea = new Area() { Name = name }; return(areaDao.Create(country, newArea)); }
public static void Delete(Area item) { try { AreaEntity entity; entity = AreaMapper.Get(item); AreaDao.Delete(entity); } catch (Exception) { throw; } }
public string GetSelectedCities() { var areaInfo = AreaDao.GetAreaInfo(_areaId); if (string.IsNullOrEmpty(areaInfo.Cities)) { return("[]"); } var builder = new StringBuilder(); foreach (var city in areaInfo.Cities.Split(',')) { builder.Append($"'{city}',"); } builder.Length--; return($"[{builder}]"); }
public static List <Area> GetAll() { try { List <Area> lista; List <AreaEntity> entities; entities = AreaDao.GetAll(); lista = AreaMapper.GetAll(entities); return(lista); } catch (Exception) { throw; } }