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