public static List <DBO.Language> GetListLanguage() { List <DBO.Language> result = new List <DBO.Language>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Language> list = bdd.T_Language.ToList(); foreach (T_Language language in list) { DBO.Language newLang = new DBO.Language() { Name = language.name, Id = language.id, ShortName = language.shortname }; result.Add(newLang); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static DBO.Article GetArticle(long id) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Article article = bdd.T_Article.Where(x => x.id == id).FirstOrDefault(); if (article != null) { DBO.Article result = new DBO.Article() { Id = article.id, Title = article.title, Content = article.content, CreatedDate = article.created_date, IdCreator = article.id_creator, Validated = article.validated }; return(result); } return(null); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }
public static bool CreateUser(DBO.User user) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_User newUser = new T_User() { email = user.Email, firstname = user.Firstname, lastname = user.Lastname, password = user.Password, role = (int)user.Role }; bdd.T_User.Add(newUser); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static DBO.Translation GetTranslationById(long id) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Translation translation = bdd.T_Translation.Where(x => x.id == id).FirstOrDefault(); if (translation != null) { DBO.Translation newTranslation = new DBO.Translation() { Content = translation.content, Id = translation.id, IdArticle = translation.id_article, IdLanguage = translation.id_language, IdTranslator = translation.id_translator, Validated = translation.validated }; return(newTranslation); } return(null); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }
public static bool CreateTranslation(DBO.Translation translation) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Translation newTranslation = new T_Translation() { content = translation.Content, id_article = translation.IdArticle, id_language = translation.IdLanguage, id_translator = translation.IdTranslator, validated = translation.Validated }; bdd.T_Translation.Add(newTranslation); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool UpdateTranslation(DBO.Translation translation) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Translation oldTranslation = bdd.T_Translation.Where(x => x.id == translation.Id).FirstOrDefault(); if (oldTranslation != null) { oldTranslation.content = translation.Content; oldTranslation.id_article = translation.IdArticle; oldTranslation.id_language = translation.IdLanguage; oldTranslation.id_translator = translation.IdTranslator; oldTranslation.validated = translation.Validated; bdd.SaveChanges(); return(true); } return(false); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static List <DBO.Translation> GetListNonValidatedTranslation() { List <DBO.Translation> result = new List <DBO.Translation>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Translation> translations = bdd.T_Translation.Where(x => x.validated == false).ToList(); foreach (T_Translation translation in translations) { DBO.Translation newTranslation = new DBO.Translation() { Content = translation.content, Id = translation.id, IdArticle = translation.id_article, IdLanguage = translation.id_language, IdTranslator = translation.id_translator, Validated = translation.validated }; result.Add(newTranslation); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static List <DBO.Comment> GetListCommentByArticle(long article_id) { List <DBO.Comment> result = new List <DBO.Comment>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Comment> list = bdd.T_Comment.Where(x => x.id_article == article_id).ToList(); foreach (T_Comment comment in list) { DBO.Comment newComment = new DBO.Comment() { Id = comment.id, Content = comment.content, IdArticle = comment.id_article, Date = comment.date, IdUser = comment.id_user }; result.Add(newComment); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static List <DBO.UserLike> GetListUserLikeByArticle(long article_id) { List <DBO.UserLike> result = new List <DBO.UserLike>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_User_Like> list = bdd.T_User_Like.Where(x => x.id_article == article_id).ToList(); foreach (T_User_Like userLike in list) { DBO.UserLike newLike = new DBO.UserLike() { Id = userLike.id, IdArticle = userLike.id_article, IdUser = userLike.id_user }; result.Add(newLike); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static bool CreateArticle(ref DBO.Article article) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Article newArticle = new T_Article() { title = article.Title, content = article.Content, id_creator = article.IdCreator, created_date = article.CreatedDate, validated = article.Validated }; bdd.T_Article.Add(newArticle); bdd.SaveChanges(); article.Id = newArticle.id; return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return(false); } }
public static List <DBO.ArticleAttach> GetListArticleAttachByArticle(long article_id) { List <DBO.ArticleAttach> result = new List <DBO.ArticleAttach>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Article_Attach> list = bdd.T_Article_Attach.Where(x => x.id_article == article_id).ToList(); foreach (T_Article_Attach ArticleAttach in list) { DBO.ArticleAttach newAttach = new DBO.ArticleAttach() { Id = ArticleAttach.id, IdArticle = ArticleAttach.id_article, FilePath = ArticleAttach.file_path, Name = ArticleAttach.name }; result.Add(newAttach); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static DBO.ArticleImage GetArticleImageByArticle(long article_id) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Article_Image ArticleImage = bdd.T_Article_Image.Where(x => x.id_article == article_id).First(); if (ArticleImage != null) { DBO.ArticleImage newAttach = new DBO.ArticleImage() { Id = ArticleImage.id, IdArticle = ArticleImage.id_article, ImagePath = ArticleImage.image_path, Name = ArticleImage.name }; return(newAttach); } return(null); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }
public static List <DBO.Article> GetListArticleByText(string word) { List <DBO.Article> result = new List <DBO.Article>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Article> list = bdd.T_Article.Where(x => x.content.Contains(word) || x.title.Contains(word)).ToList(); foreach (T_Article article in list) { DBO.Article newArticle = new DBO.Article() { Id = article.id, Title = article.title, Content = article.content, CreatedDate = article.created_date, Validated = article.validated, IdCreator = article.id_creator }; result.Add(newArticle); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static List <DBO.ArticleImage> GetListWithWord(string word) { List <DBO.ArticleImage> result = new List <DBO.ArticleImage>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Article_Image> list = bdd.T_Article_Image.Where(x => x.name.ToLower().Contains(word)).ToList(); foreach (T_Article_Image ArticleImage in list) { DBO.ArticleImage newAttach = new DBO.ArticleImage() { Id = ArticleImage.id, IdArticle = ArticleImage.id_article, ImagePath = ArticleImage.image_path, Name = ArticleImage.name }; result.Add(newAttach); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static DBO.User GetUserById(long id) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_User user = bdd.T_User.Where(x => x.id == id).FirstOrDefault(); if (user != null) { DBO.User result = new DBO.User() { Email = user.email, Firstname = user.firstname, Id = user.id, Lastname = user.lastname, Password = user.password, Role = (BusinessManagement.UserRoles.Roles)user.role }; return(result); } return(null); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }
public static List <DBO.Message> GetListMessageByUser(long user_id) { List <DBO.Message> result = new List <DBO.Message>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Message> list = bdd.T_Message.Where(x => x.id_sender == user_id || x.id_receiver == user_id).ToList(); foreach (T_Message message in list) { DBO.Message newMessage = new DBO.Message() { Content = message.content, Date = message.date, Id = message.id, IdReceiver = message.id_receiver, IdSender = message.id_sender, IsSeen = message.isSeen.Value }; result.Add(newMessage); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static bool UpdateArticle(DBO.Article article) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Article oldarticle = bdd.T_Article.Where(x => x.id == article.Id).FirstOrDefault(); if (oldarticle != null) { oldarticle.title = article.Title; oldarticle.content = article.Content; oldarticle.id_creator = article.IdCreator; oldarticle.validated = article.Validated; oldarticle.created_date = article.CreatedDate; bdd.SaveChanges(); return(true); } return(false); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static List <DBO.User> GetUsersUnderRole(long id, BusinessManagement.UserRoles.Roles role) { List <DBO.User> result = new List <DBO.User>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_User> list = bdd.T_User.Where(x => x.id != id && x.role <= (int)role).ToList(); foreach (T_User user in list) { DBO.User newUser = new DBO.User() { Email = user.email, Firstname = user.firstname, Id = user.id, Lastname = user.lastname, Password = user.password, Role = (BusinessManagement.UserRoles.Roles)user.role }; result.Add(newUser); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static bool CreateMessage(DBO.Message message) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Message newMessage = new T_Message() { content = message.Content, date = message.Date, id_receiver = message.IdReceiver, id_sender = message.IdSender, isSeen = message.IsSeen }; bdd.T_Message.Add(newMessage); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool DoesUserHaveNewMessage(int user_id) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Message message = bdd.T_Message.Where(x => x.id_receiver == user_id && x.isSeen == false).FirstOrDefault(); return(message != null); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool DeleteUser(long id) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { bdd.T_User.Remove(bdd.T_User.Where(x => x.id == id).FirstOrDefault()); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static List <Tuple <DBO.Article, List <DBO.Language> > > GetListArticleWithMissingTrans() { List <Tuple <DBO.Article, List <DBO.Language> > > result = new List <Tuple <DBO.Article, List <DBO.Language> > >(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { var list = bdd.T_Article.GroupJoin(bdd.T_Translation, article => article.id, translation => translation.id_article, (article, translation) => new { article, translation }).ToList(); foreach (var elm in list) { List <DBO.Language> languages = Language.GetListLanguage(); if (elm.translation.Count() != languages.Count) { DBO.Article newArticle = new DBO.Article() { Id = elm.article.id, Title = elm.article.title, Content = elm.article.content, CreatedDate = elm.article.created_date, Validated = elm.article.validated, IdCreator = elm.article.id_creator }; foreach (var obj in elm.translation) { foreach (var language in languages) { if (obj.id_language == language.Id) { languages.Remove(language); } } } Tuple <DBO.Article, List <DBO.Language> > item = new Tuple <DBO.Article, List <DBO.Language> >(newArticle, languages); result.Add(item); } } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static bool ValidateUser(string email, string password) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_User user = bdd.T_User.Where(x => x.email == email && x.password == password).FirstOrDefault(); if (user != null) { return(true); } return(false); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static string GetPasswordByUser(string email) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_User user = bdd.T_User.Where(x => x.email == email).FirstOrDefault(); if (user != null) { return(user.password); } return(""); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(""); } }
public static bool UpdateComment(DBO.Comment comment) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Comment oldComment = bdd.T_Comment.Where(x => x.id == comment.Id).FirstOrDefault(); oldComment.content = comment.Content; oldComment.id_article = comment.IdArticle; oldComment.id_user = comment.IdUser; oldComment.date = comment.Date; bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool UpdateMessage(DBO.Message message) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Message oldMessage = bdd.T_Message.Where(x => x.id == message.Id).FirstOrDefault(); oldMessage.content = message.Content; oldMessage.date = message.Date; oldMessage.id_receiver = message.IdReceiver; oldMessage.id_sender = message.IdSender; oldMessage.isSeen = message.IsSeen; bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool CreateLanguage(DBO.Language language) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Language newLanguage = new T_Language() { name = language.Name, shortname = language.ShortName }; bdd.T_Language.Add(newLanguage); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool UpdateLanguage(DBO.Language language) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Language oldLanguage = bdd.T_Language.Where(x => x.id == language.Id).FirstOrDefault(); if (oldLanguage != null) { oldLanguage.name = language.Name; oldLanguage.shortname = language.ShortName; bdd.SaveChanges(); return(true); } return(false); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool CreateUserLike(DBO.UserLike userLike) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_User_Like newUserLike = new T_User_Like() { id_article = userLike.IdArticle, id_user = userLike.IdUser }; bdd.T_User_Like.Add(newUserLike); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool CreateArticleImage(DBO.ArticleImage articleImage) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Article_Image newArticleAttach = new T_Article_Image() { id_article = articleImage.IdArticle, image_path = articleImage.ImagePath, name = articleImage.Name }; bdd.T_Article_Image.Add(newArticleAttach); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }