public List<posts_view_model> getAllPosts(string search) { List<posts_view_model> postsList = new List<posts_view_model>(); try { ping_pakistanEntities db = new ping_pakistanEntities(); var pposts = (from post in db.posts join user in db.users on post.user_id equals user.id join category in db.categories on post.category_id equals category.id where post.is_approved != true && post.is_deleted != true select new posts_view_model { post_id = post.id, user_id = post.user_id, post_text = post.text, date_added = post.date_added, agree_count = post.agree_count, disagree_count = post.disagree_count, username = user.username, category_name = category.name, category_id = category.id }); postsList = pposts.ToList(); } catch (Exception ex) { } return postsList; }
public users GetUserByUsername(string username) { try { ping_pakistanEntities db = new ping_pakistanEntities(); return db.users.FirstOrDefault(u => u.username == username); } catch (Exception ex) { return null; } }
public List<users> getUsers(string search) { List<users> usersList = new List<users>(); try { ping_pakistanEntities db = new ping_pakistanEntities(); usersList = db.users.ToList(); } catch (Exception ex) { } return usersList; }
public int AddUser(users user) { try { ping_pakistanEntities db = new ping_pakistanEntities(); db.users.Add(user); db.SaveChanges(); return user.id; } catch(Exception ex) { return -1; } }
public List<posts> getPostsByCategoryId(int category_id, string search) { List<posts> postsList = new List<posts>(); try { ping_pakistanEntities db = new ping_pakistanEntities(); postsList = db.posts.Where(p => p.category_id == category_id && p.is_approved == true && p.is_deleted == true).ToList(); } catch (Exception ex) { } return postsList; }
public posts AddPost(posts post) { try { ping_pakistanEntities db = new ping_pakistanEntities(); db.posts.Add(post); db.SaveChanges(); return post; } catch (Exception ex) { return post; } }
public List<categories> getAllCategories(string search) { List<categories> categoryList = new List<categories>(); try { ping_pakistanEntities db = new ping_pakistanEntities(); categoryList = db.categories.ToList(); } catch (Exception ex) { } return categoryList; }
public categories AddCategory(categories category) { try { ping_pakistanEntities db = new ping_pakistanEntities(); db.categories.Add(category); db.SaveChanges(); return category; } catch (Exception ex) { return category; } }
public bool Authenticate(string username, string password) { try { ping_pakistanEntities db = new ping_pakistanEntities(); var user = db.users.Where(u => u.username == username && u.password == password); if (user.Count() > 0) { return true; } return false; } catch (Exception ex) { return false; } }
public bool VerifyCode(int user_id, string code) { bool isVerified = false; try { ping_pakistanEntities db = new ping_pakistanEntities(); var user = db.users.Where(p => p.id == user_id && p.verification_code == code); if(user.Count() > 0) { isVerified = true; } } catch(Exception ex) { } return isVerified; }
public bool DeletePost(int post_id) { try { ping_pakistanEntities db = new ping_pakistanEntities(); var _post = db.posts.FirstOrDefault(p => p.id == post_id); if (_post != null) { _post.is_deleted = true; } db.SaveChanges(); return true; } catch (Exception ex) { return false; } }
public bool UpdateApproveStatus(int post_id, bool status) { try { ping_pakistanEntities db = new ping_pakistanEntities(); var _post = db.posts.FirstOrDefault(p => p.id == post_id); if(_post != null) { _post.is_approved = status; } db.SaveChanges(); return true; } catch (Exception ex) { return false; } }