public IHttpActionResult GetGeoHierarchy(int id)
{
GeoHierarchyViewModel geoHierarchyViewModel = new GeoHierarchyViewModel();
var geohierarchies = from GH in db.GeoHierarchies
join COU in db.Countries on GH.CountryId equals COU.Id
join STA in db.States on GH.StateId equals STA.Id
join ZON in db.Zones on GH.ZoneId equals ZON.Id
join BRA in db.Branches on GH.BranchId equals BRA.Id
join SUP in db.Users on GH.SupervisorId equals SUP.Id
join MAR in db.Users on GH.SupervisorId equals MAR.Id
select new GeoHierarchyViewModel
{
Id = GH.Id,
CountryId = GH.CountryId,
CountryName = COU.Name,
StateId = GH.StateId,
StateName = STA.Name,
ZoneId = GH.ZoneId,
ZoneName = ZON.Name,
BranchId = GH.BranchId,
BranchName = BRA.Name,
SupervisorId = GH.SupervisorId,
SupervisorName = SUP.FirstName + " " + SUP.LastName,
MarketingHierarchyUserId = GH.MarketingHierarchyUserId,
MarketingHierarchyUserName = MAR.FirstName + " " + MAR.LastName
};
if (geohierarchies == null)
{
return(NotFound());
}
geoHierarchyViewModel = geohierarchies.FirstOrDefault();
var schoolGeoHierarchyMapping = from S in db.Schools
join SGM in db.SchoolGeoHierarchyMapping on S.Id equals SGM.SchoolId
where SGM.GeoHierarchyId == id
select new SchoolGeoHierarchyMappingViewModel
{
Name = S.SchoolName,
Code = SGM.SchoolId.ToString()
};
geoHierarchyViewModel.SchoolGeoHierarchyMappingViewModels = schoolGeoHierarchyMapping.ToList();
return(Ok(geoHierarchyViewModel));
}
public IHttpActionResult PutGeoHierarchy(GeoHierarchyViewModel geoHierarchyViewModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
GeoHierarchy geoHierarchy = geoHierarchyViewModel;
db.Entry(geoHierarchy).State = EntityState.Modified;
db.SaveChanges();
List <SchoolGeoHierarchyMapping> lstSchoolGeoHierarchyMapping = db.SchoolGeoHierarchyMapping.Where(a => a.GeoHierarchyId == geoHierarchyViewModel.Id).ToList();
db.SchoolGeoHierarchyMapping.RemoveRange(lstSchoolGeoHierarchyMapping);
db.SaveChanges();
lstSchoolGeoHierarchyMapping.Clear();
foreach (SchoolGeoHierarchyMappingViewModel item in geoHierarchyViewModel.SchoolGeoHierarchyMappingViewModels)
{
lstSchoolGeoHierarchyMapping.Add(new SchoolGeoHierarchyMapping {
SchoolId = Convert.ToInt32(item.Code), GeoHierarchyId = geoHierarchyViewModel.Id
});
}
db.SchoolGeoHierarchyMapping.AddRange(lstSchoolGeoHierarchyMapping);
db.SaveChanges();
transaction.Commit();
}
catch (DbUpdateConcurrencyException)
{
transaction.Rollback();
if (!GeoHierarchyExists(geoHierarchyViewModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> PostGeoHierarchy(GeoHierarchyViewModel geoHierarchyViewModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (geoHierarchyViewModel.Id > 0)
{
return(PutGeoHierarchy(geoHierarchyViewModel));
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
GeoHierarchy geoHierarchy = geoHierarchyViewModel;
db.GeoHierarchies.Add(geoHierarchy);
await db.SaveChangesAsync();
List <SchoolGeoHierarchyMapping> lstSchoolGeoHierarchyMapping = new List <SchoolGeoHierarchyMapping>();
foreach (SchoolGeoHierarchyMappingViewModel item in geoHierarchyViewModel.SchoolGeoHierarchyMappingViewModels)
{
lstSchoolGeoHierarchyMapping.Add(new SchoolGeoHierarchyMapping {
SchoolId = Convert.ToInt32(item.Code), GeoHierarchyId = geoHierarchy.Id
});
}
db.SchoolGeoHierarchyMapping.AddRange(lstSchoolGeoHierarchyMapping);
await db.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
return(CreatedAtRoute("DefaultApi", new { id = geoHierarchyViewModel.Id }, geoHierarchyViewModel));
}
