public async Task <ReturnResponse <ResponseDetail> > AddRegion(string region)
{
try
{
if (!await _context.Region.AnyAsync(x => x.Name.ToLower() == region.ToLower()))
{
await _context.Region.AddAsync(new Region
{
Name = region
});
if (await _context.SaveChangesAsync() == 1)
{
return(GlobalReturnService.ResponseData(HttpStatusCode.OK, "Success",
true));
}
return(GlobalReturnService.ResponseData(HttpStatusCode.InternalServerError, "Something Went Wrong, while updating entries",
false));
}
else
{
return(GlobalReturnService.ResponseData(HttpStatusCode.Conflict, "region already Exist",
false));
}
}
catch (Exception e)
{
return(GlobalReturnService.ResponseData(HttpStatusCode.InternalServerError, "Something Went Wrong, please contact admin",
false));
}
}
public async Task <ReturnResponse <ResponseDetail> > AddTemperature(int buildingId, string temperature)
{
try
{
if (await _context.Buildings.AnyAsync(x => x.Id == buildingId))
{
var buildingDetails = await _context.Buildings.FirstOrDefaultAsync(x => x.Id == buildingId);
if (buildingDetails != null)
{
buildingDetails.Temperature = temperature;
if (await _context.SaveChangesAsync() == 1)
{
return(GlobalReturnService.ResponseData(HttpStatusCode.OK, "temperature Updated Successfully",
true));
}
}
return(GlobalReturnService.ResponseData(HttpStatusCode.NotFound, "Something went wrong while fetching records",
false));
}
return(GlobalReturnService.ResponseData(HttpStatusCode.NotFound, "Building Not Found",
false));
}
catch (Exception e)
{
return(GlobalReturnService.ResponseData(HttpStatusCode.InternalServerError, "Something Went Wrong, please contact admin",
false));
}
}
public async Task <ReturnResponse <ResponseDetail <List <MasterModel> > > > GetSites()
{
var regions = await _context.Sites.Select(x => new MasterModel
{
Id = x.Id,
Name = x.Name
}).ToListAsync();
return(GlobalReturnService.ResponseData <List <MasterModel> >(HttpStatusCode.OK, "success",
false, regions));
}
public async Task <ReturnResponse <ResponseDetail <string> > > GetTemperature(string region, string location, string site, string building)
{
try
{
if (await _context.Region.AnyAsync(x => x.Name.ToLower() == region.ToLower()))
{
var regions = await _context.Region.FirstOrDefaultAsync(x => x.Name.ToLower() == region.ToLower());
if (await _context.Cities.AnyAsync(x =>
x.Name.ToLower() == location.ToLower() && x.RegionId == regions.Id))
{
var locations = await _context.Cities.FirstOrDefaultAsync(x =>
x.Name.ToLower() == location.ToLower() && x.RegionId == regions.Id);
if (await _context.Sites.AnyAsync(x =>
x.CitiesId == locations.Id && x.Name.ToLower() == site.ToLower()))
{
var sites = await _context.Sites.FirstOrDefaultAsync(x =>
x.CitiesId == locations.Id && x.Name.ToLower() == site.ToLower());
if (await _context.Buildings.AnyAsync(x =>
x.Name.ToLower() == building.ToLower() && x.SitesId == sites.Id))
{
var buildings = await _context.Buildings.FirstOrDefaultAsync(x =>
x.Name.ToLower() == building.ToLower() && x.SitesId == sites.Id);
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.OK, "Success",
true, $"building Name: {buildings.Name}, Area:{buildings.Area}, Temperature: {buildings.Temperature}"));
}
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.NotFound, "building is not found",
false, ""));
}
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.NotFound, "Site is not found",
false, ""));
}
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.NotFound, "City is not found",
false, ""));
}
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.NotFound, "Region Not Found",
false, ""));
}
catch (Exception ex)
{
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.OK, "Something went wrong",
false, ""));
}
}
public async Task <ReturnResponse <ResponseDetail <List <BuildingDetails> > > > GetBuildings()
{
var regions = await _context.Buildings.Include(x => x.Sites).Include(x => x.Sites.Cities).Include(x => x.Sites.Cities.Region).Select(x => new BuildingDetails
{
Region = x.Sites.Cities.Region.Name,
Location = x.Sites.Cities.Name,
Site = x.Sites.Name,
Building = x.Name,
Temperature = x.Temperature,
Area = x.Area
}).ToListAsync();
return(GlobalReturnService.ResponseData <List <BuildingDetails> >(HttpStatusCode.OK, "success",
true, regions));
}
public async Task <ReturnResponse <ResponseDetail <List <MasterModel> > > > GetCities()
{
try
{
var regions = await _context.Cities.Select(x => new MasterModel
{
Id = x.Id,
Name = x.Name
}).ToListAsync();
return(GlobalReturnService.ResponseData <List <MasterModel> >(HttpStatusCode.OK, "success",
false, regions));
}
catch (Exception ex)
{
return(GlobalReturnService.ResponseData <List <MasterModel> >(HttpStatusCode.InternalServerError, ex.Message,
false, null));
}
}
public async Task <ReturnResponse <ResponseDetail <string> > > GetTemperatureById(int buildingId)
{
try
{
if (await _context.Buildings.AnyAsync(x => x.Id == buildingId))
{
var buildingDetails = await _context.Buildings.FirstOrDefaultAsync(x => x.Id == buildingId);
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.OK, "Success",
true, $"Temperature is :{buildingDetails.Temperature}"));
}
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.NotFound, "Building Not Found",
false, ""));
}
catch (Exception ex)
{
return(GlobalReturnService.ResponseData <string>(HttpStatusCode.OK, "Something went wrong",
false, ""));
}
}
public async Task <ReturnResponse <ResponseDetail> > AddBuilding(string name, int siteId, string area)
{
try
{
if (!await _context.Buildings.AnyAsync(x => x.Name.ToLower() == name.ToLower()))
{
if (await _context.Sites.AnyAsync(x => x.Id == siteId))
{
await _context.Buildings.AddAsync(new Building
{
Name = name,
Area = area,
SitesId = siteId
});
if (await _context.SaveChangesAsync() == 1)
{
return(GlobalReturnService.ResponseData(HttpStatusCode.OK, "Success",
true));
}
return(GlobalReturnService.ResponseData(HttpStatusCode.InternalServerError, "Something Went Wrong, while updating entries",
false));
}
return(GlobalReturnService.ResponseData(HttpStatusCode.NotFound, "Site Not Found",
false));
}
else
{
return(GlobalReturnService.ResponseData(HttpStatusCode.Conflict, "region already Exist",
false));
}
}
catch (Exception e)
{
return(GlobalReturnService.ResponseData(HttpStatusCode.InternalServerError, "Something Went Wrong, please contact admin",
false));
}
}
