void functionAdd(object postText) { string[] vallString = (string[])postText; #region описание модели //id //откуда взят //дата публикации //текст //количество комментариев //количество лайков //количество дизлайков //количество репостов //количество репостов пользователями //public int Id { get; set; } //public string post_id { get; set; } //public string from_id { get; set; } //public string date { get; set; } //public string text { get; set; } //public string count_comments { get; set; } //public string count_likes { get; set; } //public string count_user_likes { get; set; } //public string count_repost { get; set; } //public string count_user_repost { get; set; } #endregion using (ContextGroupWallTextPost db = new ContextGroupWallTextPost()) { GroupWallTextPost cgp = new GroupWallTextPost { post_id = Convert.ToInt32(vallString[0]), from_id = Convert.ToInt32(vallString[1]), date = Convert.ToInt32(vallString[2]), text = vallString[3], count_comments = Convert.ToInt32(vallString[4]), count_likes = Convert.ToInt32(vallString[5]), count_user_likes = Convert.ToInt32(vallString[6]), count_repost = Convert.ToInt32(vallString[7]), count_user_repost = Convert.ToInt32(vallString[8]), postedTable = false }; db.GroupWallTextPosts.Add(cgp); db.SaveChanges(); } }
private void bdVallUpdate(int Id) { using (ContextGroupWallTextPost db = new ContextGroupWallTextPost()) { GroupWallTextPost PostedParametr = db.GroupWallTextPosts.Find(Id); PostedParametr.postedTable = true; db.SaveChanges(); } }
private bool bdChek(string[] postText) { int postID = Convert.ToInt32(postText[0]); int groupID = Convert.ToInt32(postText[1]); using (ContextGroupWallTextPost db = new ContextGroupWallTextPost()) { var tt = db.GroupWallTextPosts.Where(p => p.post_id == postID).Intersect(db.GroupWallTextPosts.Where(p => p.from_id == groupID)); if (tt.Count() == 0) { return(true); } return(false); } }
private static void parametrUpdate(int groupId) { using (ContextGroupWallTextPost db = new ContextGroupWallTextPost()) { var tt = db.GroupWallTextPosts .Select(p => new { Text = p.text, LickeCount = p.count_likes, RepostCount = p.count_repost, PostedTable = p.postedTable, postId = p.post_id, groupId = p.from_id, ID = p.Id }) .Where(p => p.PostedTable == false && p.groupId == groupId) //.Intersect(db.GroupWallTextPosts.Where(p => p.from_id == groupId)) .OrderByDescending(p => p.LickeCount) .Take(10); foreach (var p in tt) { PostInfo[i, 0] = Convert.ToString(p.LickeCount); PostInfo[i, 1] = Convert.ToString(p.RepostCount); PostInfo[i, 2] = p.Text; PostInfo[i, 3] = Convert.ToString(p.postId); PostInfo[i, 4] = Convert.ToString(p.groupId); PostInfo[i, 5] = Convert.ToString(p.ID); i++; } i = 0; } }