public UnitOfWork(IDbConnection connection)
{
_connection = connection;
AccountDao = new AccountDao(connection);
BusCoordinateDao = new BusCoordinateDao(connection);
BusDao = new BusDao(connection);
BusDriverDao = new BusDriverDao(connection);
CityDao = new CityDao(connection);
CountryDao = new CountryDao(connection);
DistanceDao = new DistanceDao(connection);
DistrictDao = new DistrictDao(connection);
DriverDao = new DriverDao(connection);
DriverContactDao = new DriverContactDao(connection);
LocationDao = new LocationDao(connection);
LookupsDao = new LookupsDao(connection);
LookupValuesDao = new LookupValuesDao(connection);
RepairSpecialistDao = new RepairSpecialistDao(connection);
RoleDao = new RoleDao(connection);
RouteDao = new RouteDao(connection);
RouteLocationDao = new RouteLocationDao(connection);
TripDao = new TripDao(connection);
TripBusDao = new TripBusDao(connection);
TripBusDriverDao = new TripBusDriverDao(connection);
UserDao = new UserDao(connection);
VehicleDao = new VehicleDao(connection);
ScheduleDao = new ScheduleDao(connection);
ScheduleLocationDao = new ScheduleLocationDao(connection);
StoredProcedureDao = new StoredProcedureDao(connection);
}
public ActionResult Delete(int id)
{
var dao = new CityDao();
dao.Delete(id);
return(RedirectToAction("Index"));
}
// GET: Admin/City
public ActionResult Index(string searchString, int page = 1, int pageSize = 5)
{
var dao = new CityDao();
var model = dao.LissAllPaging(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public JsonResult ChangeStatus(long id)
{
var result = new CityDao().ChangeStatus(id);
return(Json(new
{
status = result
}));
}
public void SetViewBag(string selectedId = null)
{
var dao = new CityDao();
var condao = new ContratorDao();
var builderdao = new BuilderDao();
var productdao = new ProductDao();
ViewBag.CityID = new SelectList(dao.ToList(), "CityID", "Name", selectedId);
ViewBag.Contrator = new SelectList(condao.ToListActive(), "ContratorID", "ContraName", selectedId);
ViewBag.Builder = new SelectList(builderdao.ToListActive(), "BuilderID", "BuilderName", selectedId);
ViewBag.Products = productdao.ToListActive();
}
public ActionResult Edit(City city)
{
if (ModelState.IsValid)
{
var dao = new CityDao();
var result = dao.Update(city);
if (result)
{
return(RedirectToAction("Index", "City"));
}
else
{
ModelState.AddModelError("", "Cập nhật khu vực không thành công");
}
}
return(View("Edit"));
}
public ActionResult Create(City city)
{
if (ModelState.IsValid)
{
var dao = new CityDao();
city.CreatedDate = DateTime.Now;
long id = dao.Insert(city);
if (id > 0)
{
return(RedirectToAction("Index", "City"));
}
else
{
ModelState.AddModelError("", "Thêm khu vực không thành công");
}
}
return(View("Create"));
}
public InfoCityReport DoAttack(bool reboot)
{
if (reboot)
{
_cityDao = new CityDao();
}
//si solo existe uno, es el ganador
if (_cityDao.CheckIfExistCitiesNotConquered())
{
var cityWin = _cityDao.GetRandomCityNotConquered();
var listExcluded = new List <int>()
{
cityWin.Id
};
var city = new List <City>()
{
cityWin
};
var cityDefeated = GetCityDefeated(city, cityWin.Id, listExcluded, cityWin.Id);
var result = new InfoCityReport();
result.CityWin.Name = cityWin.Name;
result.CityDefeated.Name = cityDefeated.Name;
if (cityDefeated.ConqueredBy.HasValue)
{
var previousCityConquer = _cityDao.GetCityById(cityDefeated.ConqueredBy.Value);
result.CityDefeated.Conquered = previousCityConquer.Name;
}
_cityDao.SaveConqueredCity(cityWin.Id, cityDefeated.Id);
return(result);
}
return(new InfoCityReport()
{
CityWin = new InfoCity()
{
Name = _cityDao.GetCityNotConquered().First().Name
}
});
}
// 分块获取选框
private void checkBoxBlock_CheckedChanged(object sender, EventArgs e)
{
bool isBlock = checkBoxBlock.Checked;
buttonBlock.Enabled = isBlock;
panelBlock.Enabled = isBlock;
if (isBlock) // 选取
{
// 检查是否有对应矢量
string cityName = comboBoxCity.SelectedItem.ToString();
city = CityDao.SelectByName(cityName);
if (city == null)
{
MessageBox.Show("此城市没有相应的矢量数据，无法分块获取POI");
checkBoxBlock.Checked = false;
}
}
}
// GET: Supplier/Details/5
public ActionResult Details(long id)
{
SupplierDao bdDao = new SupplierDao();
var sl = bdDao.FindByID(id);
if (sl.Status == true)
{
ViewBag.Status = "Kích hoạt";
}
else
{
ViewBag.Status = "Khóa";
}
var dao = new CityDao();
var ct = dao.FindByID(sl.CityID);
ViewBag.CityName = ct[0].Name;
var disDao = new DistrictDao();
var dist = disDao.FindByID(sl.CityID, sl.DistrictID);
ViewBag.DistName = dist.Name;
return(View(sl));
}
public BaseController()
{
_customerDao = new CustomerDao();
_cityDao = new CityDao();
_phoneDao = new PhoneDao();
}
public ActionResult Edit(int id)
{
var city = new CityDao().ViewDetail(id);
return(View(city));
}
public void SetViewBagCity(long?selectedId = null)
{
var dao = new CityDao();
ViewBag.CityID = new SelectList(dao.LissAllCity(), "ID", "Name", selectedId);
}
// 点击分块建议按钮
private void buttonBlock_Click(object sender, EventArgs e)
{
// 关键字
string keyWord = getKeyWord();
if (string.IsNullOrEmpty(keyWord))
{
MessageBox.Show("请输入自定义关键字");
return;
}
// 获取对应矢量
string cityName = comboBoxCity.SelectedItem.ToString();
City city = CityDao.SelectByName(cityName);
if (city == null)
{
MessageBox.Show("此城市没有相应的矢量数据，无法分块获取POI");
return;
}
int fid = Convert.ToInt32(city.Id);
// 开始请求
Region region = comboBoxCity.SelectedItem as Region;
handler = new PlaceAPIHandler(region, keyWord);
int totalNum = handler.GetTotalNum((comboBoxProvince.SelectedItem as Region).Name);
if (totalNum < 0) // 返回错误
{
MessageBox.Show(PlaceAPIHandler.GetErrMsg(totalNum));
}
else if (totalNum <= 400)
{
MessageBox.Show(string.Format("区域：{0}，关键词：{1}，共有 {2} 个结果，无需分块", region.Name, keyWord,
totalNum));
checkBoxBlock.Checked = false;
}
else // 有结果
{
int blockNum = totalNum / 400 + 1; // 最少分块数
Envelope envelope = GisUtil.GetEnvelope(fid);
double x = envelope.MaxX - envelope.MinX;
double y = envelope.MaxY - envelope.MinY;
int xNum = 1;
int yNum = 1;
if (x <= y)
{
double r = y / x;
xNum = Convert.ToInt32(Math.Sqrt(blockNum / r)) + 1;
yNum = Convert.ToInt32(xNum * r) + 1;
}
else
{
double r = x / y;
yNum = Convert.ToInt32(Math.Sqrt(blockNum / r)) + 1;
xNum = Convert.ToInt32(yNum * r) + 1;
}
xNum *= 2;
yNum *= 2;
MessageBox.Show(string.Format("区域：{0}，关键词：{1}，共有 {2} 个结果。建议分块为 {3} 行，{4} 列",
region.Name, keyWord, totalNum, yNum, xNum));
// 自动调整行列分块数
if (xNum > 20)
{
comboBoxBlockCol.Items.Clear();
for (int i = 1; i <= xNum + 10; i++)
{
comboBoxBlockCol.Items.Add(i);
}
}
comboBoxBlockCol.SelectedIndex = xNum - 1;
if (yNum > 20)
{
comboBoxBlockRow.Items.Clear();
for (int j = 1; j <= yNum + 10; j++)
{
comboBoxBlockRow.Items.Add(j);
}
}
comboBoxBlockRow.SelectedIndex = yNum - 1;
}
}
public CityService(CityDao cityDao, ILogger <CityService> logger)
{
this.cityDao = cityDao;
this.logger = logger;
}
public CitiesService()
{
_cityDao = new CityDao();
}
public void SetViewBag(string selectedId = null)
{
var dao = new CityDao();
ViewBag.CityID = new SelectList(dao.ToList(), "CityID", "Name", selectedId);
}
private LivedoorWeatherProvider()
{
weatherDatas = new ConcurrentStack <City>();
dao = new CityDao();
}
public EventTimeService(CityDao cityDao, SunriseSunsetHttpDao sunriseSunsetHttpDao, ILogger <EventTimeService> logger)
{
this.cityDao = cityDao;
this.sunriseSunsetHttpDao = sunriseSunsetHttpDao;
this.logger = logger;
}
