/// <summary> /// 删除城市价格趋势 /// </summary> /// <param name="city">城市</param> public HttpResponseMessage Delete(string city) { if (string.IsNullOrEmpty(city)) { return new HttpResponseMessage(HttpStatusCode.BadRequest); } else { var entity = new CityPriceTrend() { City = city }; CityPriceTrendFunction cityPriceTrendFunction = new CityPriceTrendFunction(); int error = cityPriceTrendFunction.DeleteCityPriceTrend(entity); var response = GetResponse.PriceTrendResponse(error); return response; } }
//新增城市价格趋势 public int AddCityPriceTrend(CityPriceTrend entity) { using (var db = new HouseMarketEntities()) { if (db.CityPriceTrends.Any(c => c.City == entity.City && c.Date == entity.Date)) { return (int)Errors.PriceTrendErrors.RecordExisted; } else if (entity.ID != 0 || entity.City == null || entity.CityAvgPrice == null || entity.Date == null) { return (int)Errors.PriceTrendErrors.WrongParameter; } else { db.CityPriceTrends.Add(entity); db.SaveChanges(); return 0; } } }
//删除城市价格趋势 public int DeleteCityPriceTrend(CityPriceTrend entity) { using (var db = new HouseMarketEntities()) { if (entity.ID == 0) { return (int)Errors.PriceTrendErrors.NullParameter; } else { var cityPriceTrend = db.CityPriceTrends.FirstOrDefault(c => c.ID == entity.ID); if (cityPriceTrend == null) { return (int)Errors.PriceTrendErrors.PriceTrendIDNotExisted; } else { db.CityPriceTrends.Remove(cityPriceTrend); db.SaveChanges(); return 0; } } } }
//编辑城市价格趋势 public int EditCityPriceTrend(CityPriceTrend entity) { using (var db = new HouseMarketEntities()) { if (db.CityPriceTrends.Any(c => c.City == entity.City && c.Date == entity.Date)) { return (int)Errors.PriceTrendErrors.RecordExisted; } else if (entity.ID == 0) { return (int)Errors.PriceTrendErrors.NullParameter; } else if (entity.City == null || entity.CityAvgPrice == null || entity.Date == null) { return (int)Errors.PriceTrendErrors.WrongParameter; } else { var cityPriceTrend = db.CityPriceTrends.FirstOrDefault(c => c.ID == entity.ID); if (cityPriceTrend == null) { return (int)Errors.PriceTrendErrors.PriceTrendIDNotExisted; } else { PropertyFunction.CopyEntity(entity, cityPriceTrend); db.SaveChanges(); return 0; } } } }