public CountryBase AddCountry(CountryAdd newItem) { if (!CurrentDbContext.CountryDB.Any(a => a.Name.Contains(newItem.Name))) { var addedItem = CurrentDbContext.CountryDB.Add(Mapper.Map <Country>(newItem)); addedItem.SeoName = SeoManager.GetSeoLocation(addedItem.Name); CurrentDbContext.SaveChanges(); return((addedItem == null) ? null : Mapper.Map <CountryBase>(addedItem)); } return(null); }
/// <summary> /// Get one ad with details for ListDetail.cshtml /// </summary> /// <param name="stringId"></param> /// <returns></returns>w public ClassifiedAdWithDetail GetClassifiedAdWithDetails(string stringId) { // Check for session id var ad = CurrentDbContext.ClassifiedDB.ProjectTo <ClassifiedAdWithDetail>().FirstOrDefault(x => x.StringId == stringId); if (ad != null) { ad.SeoCategory = SeoManager.GetSeoCategory(ad.Category.Id, ad.SubCategory.Id); ad.SeoLocation = SeoManager.GetSeoLocation(ad.Country.Id, ad.Region.Id); } return(ad); }
public RegionBase EditRegion(RegionEdit editItem) { var o = CurrentDbContext.RegionDB.Include("Country").SingleOrDefault(r => r.Id == editItem.Id); if (o != null) { o.Name = editItem.Name; o.Lat = editItem.Lat; o.Lng = editItem.Lng; o.Zoom = editItem.Zoom; o.SeoName = SeoManager.GetSeoLocation(o.Country.Name, o.Name); CurrentDbContext.SaveChanges(); } return((o == null) ? null : Mapper.Map <RegionBase>(editItem)); }
public RegionBase AddRegion(RegionAdd newItem) { // get associated object var o = CurrentDbContext.CountryDB.Include("Regions").SingleOrDefault(a => a.Id == newItem.CountryId); if (o == null) { return(Mapper.Map <RegionBase>(newItem)); } // check for duplicate region var dup = o.Regions.SingleOrDefault(a => a.Name == newItem.Name); if (!o.Regions.Any(a => a.Name == newItem.Name)) { var addedItem = CurrentDbContext.RegionDB.Add(Mapper.Map <Region>(newItem)); addedItem.Country = o; addedItem.SeoName = SeoManager.GetSeoLocation(addedItem.Country.Name, addedItem.Name); o.RegionCount++; CurrentDbContext.SaveChanges(); return((addedItem == null) ? null : Mapper.Map <RegionBase>(addedItem)); } return(Mapper.Map <RegionBase>(newItem)); }