public HttpResponseMessage Edit(int id, string SiteName)
{
List <LocationIndicatorViewModel> lstLocationIndicatorViewModel = new List <LocationIndicatorViewModel>();
LocationIndicatorViewModel objLocationIndicatorViewModel = new LocationIndicatorViewModel();
objLocationIndicatorViewModel.SiteName = SiteName;
objLocationIndicatorViewModel.AreaOfInterestId = id;
using (ThomsonDbContext db = new ThomsonDbContext(SiteName))
{
objLocationIndicatorViewModel.Name = db.InterestLocation.First(m => m.AreaOfInterestId == id).Name;
objLocationIndicatorViewModel.LoctionIndicatorId = db.LocationIndicator.First(m => m.AreaOfInterestId == id).LoctionIndicatorId;
foreach (var item in db.LocationIndicator.Where(m => m.AreaOfInterestId == id))
{
MapLocation objMapLocation = new MapLocation();
objMapLocation.LoctionIndicatorId = item.LoctionIndicatorId;
objMapLocation.LoctionIndicator = item.LoctionIndicator;
objMapLocation.AreaOfInterestId = item.AreaOfInterestId;
objLocationIndicatorViewModel.lstMapLocations.Add(objMapLocation);
}
foreach (var item in db.NeighBourAreas.Where(m => m.AreaId == id))
{
NeighBourAreaMap objNeighBourMapLocation = new NeighBourAreaMap();
objNeighBourMapLocation.NeighBourId = item.NeighbourAreaId;
objNeighBourMapLocation.NeighBourName = item.AreaCode.ToString();
objNeighBourMapLocation.AreaOfInterestId = item.AreaId;
objLocationIndicatorViewModel.lstNeighBourMaps.Add(objNeighBourMapLocation);
}
}
lstLocationIndicatorViewModel.Add(objLocationIndicatorViewModel);
return(Request.CreateResponse(objLocationIndicatorViewModel));
}
public HttpResponseMessage DeleteLocationIndicator(LocationIndicatorViewModel objLocation)
{
try
{
using (ThomsonDbContext db = new ThomsonDbContext(objLocation.SiteName))
{
LocationIndicator objLocationIndicator = db.LocationIndicator.Where(b => b.LoctionIndicatorId == objLocation.LoctionIndicatorId).FirstOrDefault();
db.LocationIndicator.Remove(objLocationIndicator);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Delete(LocationIndicatorViewModel objLocation)
{
try
{
using (ThomsonDbContext db = new ThomsonDbContext(objLocation.SiteName))
{
var objAreaOfInterest = db.InterestLocation.Where(a => a.AreaOfInterestId == objLocation.AreaOfInterestId).FirstOrDefault();
db.InterestLocation.Remove(objAreaOfInterest);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public List <LocationIndicatorViewModel> Index(string SiteName)
{
//Assign the Default Site
if (!string.IsNullOrEmpty(SiteName) || SiteName == null)
{
SiteName = "Discovery1";
}
List <LocationIndicatorViewModel> lstLocationIndicatorViewModel = new List <LocationIndicatorViewModel>();
try
{
using (var db = new ThomsonDbContext(SiteName))
{
var interLocationsData = db.InterestLocation.ToList();
foreach (var item in interLocationsData.GroupBy(m => new { m.AreaOfInterestId, m.Name }))
{
LocationIndicatorViewModel objLocationIndicatorViewModel = new LocationIndicatorViewModel();
objLocationIndicatorViewModel.AreaOfInterestId = item.Key.AreaOfInterestId;
objLocationIndicatorViewModel.Name = item.Key.Name;
foreach (var item1 in db.LocationIndicator.Where(m => m.AreaOfInterestId == objLocationIndicatorViewModel.AreaOfInterestId))
{
objLocationIndicatorViewModel.LoctionIndicator += item1.LoctionIndicator + ",";
}
foreach (var item2 in db.NeighBourAreas.Where(m => m.AreaId == objLocationIndicatorViewModel.AreaOfInterestId))
{
objLocationIndicatorViewModel.NeighBourName += item2.AreaCode + ",";
}
lstLocationIndicatorViewModel.Add(objLocationIndicatorViewModel);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstLocationIndicatorViewModel);
}
public HttpResponseMessage Create(LocationIndicatorViewModel objlocationIndicator)
{
InterestLocation locationModel = new InterestLocation();
objlocationIndicator.SiteName = "Discovery1";
using (ThomsonDbContext db = new ThomsonDbContext(objlocationIndicator.SiteName))
{
if (!string.IsNullOrEmpty(objlocationIndicator.Name))
{
locationModel.Name = objlocationIndicator.Name;
db.InterestLocation.Add(locationModel);
db.SaveChanges();
}
var location = db.InterestLocation.Where(a => a.Name == locationModel.Name).SingleOrDefault();
if (!string.IsNullOrEmpty(objlocationIndicator.LoctionIndicator))
{
LocationIndicator indicatorModel = new LocationIndicator();
indicatorModel.LoctionIndicator = objlocationIndicator.LoctionIndicator;
indicatorModel.AreaOfInterestId = location.AreaOfInterestId;
db.LocationIndicator.Add(indicatorModel);
}
if (!string.IsNullOrEmpty(objlocationIndicator.NeighBourName))
{
NeighBourArea objNeighBourArea = new NeighBourArea();
objNeighBourArea.AreaId = location.AreaOfInterestId;
objNeighBourArea.AreaCode = objlocationIndicator.NeighBourName;
db.NeighBourAreas.Add(objNeighBourArea);
}
db.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Edit(LocationIndicatorViewModel locationIndicator)
{
try
{
using (ThomsonDbContext db = new ThomsonDbContext(locationIndicator.SiteName))
{
var objInterestLoction = db.InterestLocation.Where(p => p.AreaOfInterestId == locationIndicator.AreaOfInterestId).FirstOrDefault();
objInterestLoction.Name = locationIndicator.Name;
db.Entry(objInterestLoction).State = EntityState.Modified;
//var ab = fc["LoctionIndicator"].ToString();
//foreach (var item in fc["LoctionIndicator"].Split(','))
//{
// if (!string.IsNullOrEmpty(item))
// {
// LocationIndicator indicatorModel = new LocationIndicator();
// indicatorModel.LoctionIndicator = item.ToString();
// indicatorModel.AreaOfInterestId = objInterestLoction.AreaOfInterestId;
// db.LocationIndicator.Add(indicatorModel);
// }
//}
//foreach (var item in fc["NeighBourName"].Split(','))
//{
// if (!string.IsNullOrEmpty(item))
// {
// NeighBourArea objNeighBourArea = new NeighBourArea();
// objNeighBourArea.AreaCode = item;
// objNeighBourArea.AreaId = locationIndicator.AreaOfInterestId;
// db.NeighBourAreas.Add(objNeighBourArea);
// }
//}
foreach (var Item in locationIndicator.lstMapLocations)
{
var objlocationIndicator = new LocationIndicator();
if (db.LocationIndicator.Any(m => m.LoctionIndicatorId == Item.LoctionIndicatorId))
{
objlocationIndicator = db.LocationIndicator.Where(m => m.AreaOfInterestId == locationIndicator.AreaOfInterestId && m.LoctionIndicatorId == Item.LoctionIndicatorId).FirstOrDefault();
objlocationIndicator.LoctionIndicator = Item.LoctionIndicator;
db.Entry(objlocationIndicator).State = EntityState.Modified;
}
else
{
objlocationIndicator.LoctionIndicator = Item.LoctionIndicator;
objlocationIndicator.AreaOfInterestId = Item.AreaOfInterestId;
db.LocationIndicator.Add(objlocationIndicator);
}
}
foreach (var item in locationIndicator.lstNeighBourMaps)
{
var ObjNeighBourArea = new NeighBourArea();
if (db.NeighBourAreas.Any(m => m.NeighbourAreaId == item.NeighBourId))
{
ObjNeighBourArea = db.NeighBourAreas.Where(m => m.NeighbourAreaId == item.NeighBourId && m.AreaId == locationIndicator.AreaOfInterestId).FirstOrDefault();
ObjNeighBourArea.AreaCode = item.NeighBourName;
db.Entry(ObjNeighBourArea).State = EntityState.Modified;
}
else
{
ObjNeighBourArea.AreaCode = item.NeighBourName;
ObjNeighBourArea.AreaId = item.AreaOfInterestId;
db.NeighBourAreas.Add(ObjNeighBourArea);
}
}
db.SaveChanges();
}
}
catch (Exception ex)
{
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
