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