public UserLoginDTO LoginUser(UserLoginDTO login)
{
UserLoginDTO userData = new UserLoginDTO();
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
User user = context.Users.Where(x => x.Email == login.Email && x.Password == login.Password && x.IsDeleted == false).FirstOrDefault();
if (user != null)
{
userData.Email = user.Email;
return(userData);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool RegisterUser(UserRegisterDTO register)
{
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
context.Users.Add(new User()
{
FirstName = register.FirstName,
MiddleName = register.MiddleName,
LastName = register.LastName,
Email = register.Email,
Password = register.Password,
CreatedOn = DateTime.Now,
ModifiedOn = DateTime.Now
});
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <ArticleDTO> GetAllBlogPosts()
{
List <ArticleDTO> articleDTOList = new List <ArticleDTO>();
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
List <Article> articles = context.Articles.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id).ToList();
if (articles.Count > 0)
{
foreach (var item in articles)
{
articleDTOList.Add(new ArticleDTO
{
Id = item.Id,
Title = item.Title,
Tags = item.Tags,
ShortDesc = item.ShortDesc,
ArticleDesc = item.ArticleDesc
});
}
}
return(articleDTOList);
}
}
catch (Exception)
{
throw;
}
}
public bool UpdatePost(ArticleDTO data)
{
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
Article article = context.Articles.Where(x => x.Id == data.Id && x.IsDeleted == false).FirstOrDefault();
if (article != null)
{
article.Title = data.Title;
article.ShortDesc = data.ShortDesc;
article.Tags = data.Tags;
article.ArticleDesc = data.ArticleDesc;
article.ModifiedOn = DateTime.Now;
context.Entry(article).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <ArticleDTO> GetPostsByTag(string tagName)
{
List <ArticleDTO> articleDTOList = new List <ArticleDTO>();
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
List <Article> articles = context.Articles.Where(x => x.Tags == tagName && x.IsDeleted == false).ToList();
if (articles.Count > 0)
{
foreach (var item in articles)
{
articleDTOList.Add(new ArticleDTO
{
Id = item.Id,
Title = item.Title,
Tags = item.Tags,
ShortDesc = item.ShortDesc,
ArticleDesc = item.ArticleDesc
});
}
}
else
{
return(null);
}
return(articleDTOList);
}
}
catch (Exception)
{
throw;
}
}
public ArticleDTO GetPost(int articleId)
{
ArticleDTO articleDTO = new ArticleDTO();
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
Article article = context.Articles.Where(x => x.Id == articleId && x.IsDeleted == false).FirstOrDefault();
if (article != null)
{
articleDTO = new ArticleDTO
{
Id = article.Id,
Title = article.Title,
Tags = article.Tags,
ShortDesc = article.ShortDesc,
ArticleDesc = article.ArticleDesc
};
}
else
{
return(null);
}
return(articleDTO);
}
}
catch (Exception)
{
throw;
}
}
public List <string> GetAllTags()
{
List <string> articleTagList = new List <string>();
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
List <Article> articles = context.Articles.Where(x => x.IsDeleted == false).OrderBy(x => x.Tags).ToList();
if (articles.Count > 0)
{
foreach (var item in articles)
{
articleTagList.Add(item.Tags.ToString());
}
}
return(articleTagList.Distinct().ToList());
}
}
catch (Exception)
{
throw;
}
}
public bool DeletePost(int articleId)
{
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
Article article = context.Articles.Where(x => x.Id == articleId && x.IsDeleted == false).FirstOrDefault();
if (article != null)
{
article.IsDeleted = true;
article.ModifiedOn = DateTime.Now;
context.Entry(article).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool CreatePost(ArticleDTO data)
{
try
{
using (StoryboardDBEntities context = new StoryboardDBEntities())
{
context.Articles.Add(new Article()
{
Title = data.Title,
ShortDesc = data.ShortDesc,
Tags = data.Tags,
ArticleDesc = data.ArticleDesc,
CreatedOn = DateTime.Now,
ModifiedOn = DateTime.Now
});
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
