public IActionResult Index(int floor) { MySqlConnection con = new MySqlConnection("host=sql7.freemysqlhosting.net;user=sql7323917;password=s1VSnVYe3w;database=sql7323917;"); string sql = " SELECT area_number, area_amount FROM Camera "; MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); MySqlDataReader reader = cmd.ExecuteReader(); Dictionary <string, string> values = new Dictionary <string, string>(); while (reader.Read()) { string area_number = reader.GetString(0); string area_amount = reader.GetString(1); values.Add(area_number, area_amount); } foreach (KeyValuePair <string, string> entry in values) { Area area = _areaRepo.GetByAreaNumber(entry.Key); if (area != null) { area.Amount = Convert.ToInt32(entry.Value); _areaRepo.Update(area); } else { area = new Area(entry.Key, Convert.ToInt32(entry.Value)); _areaRepo.Add(area); } } con.Close(); _areaRepo.SaveChanges(); FloorPlanViewModel vm = new FloorPlanViewModel(); vm.Dimensions = _dimRepo.GetAll().Where(dim => dim.Floor == floor).ToList(); vm.Areas = _areaRepo.GetAll(); vm.FloorId = floor; return(View(vm)); }
public List <Dimension> GetAll() { List <Dimension> result = new List <Dimension>(); try { result = _DimensionRepository.GetAll(); return(result); } catch (Exception ex) { throw ex; } }
public async Task <List <GetAllDimensionViewModel> > Handle(GetAllDimensionQuery request, CancellationToken cancellationToken) { return(_mapper.Map <List <GetAllDimensionViewModel> >(await _repositoryDimension.GetAll())); }