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 <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 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 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 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);
}
}
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);
}
