public List <Post> getPostsAll()
{
using (var ctxNew = new VFDSEntities())
{
return(ctxNew.Database.SqlQuery <Post>("exec spGetPosts").ToList <Post>());
}
}
public MetaData getMetaDataByPostID(string PostID)
{
using (var ctxNew = new VFDSEntities())
{
return(ctxNew.MetaDatas.SingleOrDefault(metadata => metadata.Post_ID == PostID));
}
}
public Post getPostByID(string ID)
{
using (var ctxNew = new VFDSEntities())
{
return(ctxNew.Posts.SingleOrDefault(post => post.Post_ID == ID));
}
}
public User getUserByCredential(string email, string password)
{
using (var ctxNew = new VFDSEntities())
{
return(ctxNew.Users.SingleOrDefault(user => user.User_Email == email && user.User_Password == password));
}
}
public void saveMetaData(MetaData metaData)
{
using (var ctxNew = new VFDSEntities())
{
ctxNew.MetaDatas.Add(metaData);
ctxNew.SaveChanges();
}
}
public void savePost(Post post)
{
using (var ctxNew = new VFDSEntities())
{
ctxNew.Posts.Add(post);
ctxNew.SaveChanges();
}
}
public bool getUserExistByEmail(string email)
{
using (var ctx = new VFDSEntities())
{
var value = ctx.Database.SqlQuery <bool>("exec spUserNameExists " + email);
return(Convert.ToBoolean(value));
}
}
public void createUser(string email, string password, string fname, string lname)
{
using (var ctxNew = new VFDSEntities())
{
try
{
ctxNew.Users.Add(new User {
User_Email = email, User_Password = password, User_First_Name = fname, User_Last_Name = lname
});
ctxNew.SaveChanges();
}
catch (Exception ex)
{
}
}
}
