private void AddNearCircle() { var db = HWLDBContext.GetDBContext(ShareConfiguration.DBConnectionString); t_near_circle model = new t_near_circle() { user_id = this.userId, content_info = this.messageModel.Content, content_type = CustomerEnumDesc.GetCircleContentType(this.messageModel.Content, null, null, this.messageModel.ImageUrls?.Count ?? 0), lat = this.positionModel.Lat, lon = this.positionModel.Lon, pos_desc = this.positionModel.PosDetails, pos_id = 0, image_urls = CircleImageParser.GetImageString(this.messageModel.ImageUrls), comment_count = 0, image_count = 0, like_count = 0, publish_time = DateTime.Now, update_time = DateTime.Now }; db.t_near_circle.Add(model); db.SaveChanges(); NearCircleStore.CreateNearCirclePos(model.id, model.lon, model.lat); //send im message to near users //... ... }
public override DeleteNearCircleInfoResponseBody ExecuteCore() { DeleteNearCircleInfoResponseBody res = new DeleteNearCircleInfoResponseBody() { Status = ResultStatus.Failed }; t_near_circle model = db.t_near_circle.Where(l => l.id == this.request.NearCircleId && l.user_id == this.request.UserId).FirstOrDefault(); if (model == null) { res.Status = ResultStatus.Success; return(res); } bool succ = NearCircleStore.DeleteNearCircleId(this.request.NearCircleId); if (succ) { var comments = db.t_near_circle_comment.Where(l => l.near_circle_id == this.request.NearCircleId).ToList(); if (comments != null && comments.Count > 0) { db.t_near_circle_comment.RemoveRange(comments); } var likes = db.t_near_circle_like.Where(l => l.near_circle_id == this.request.NearCircleId).ToList(); if (likes != null && likes.Count > 0) { db.t_near_circle_like.RemoveRange(likes); } } db.t_near_circle.Remove(model); db.SaveChanges(); res.Status = ResultStatus.Success; return(res); }