public ActionResult Index() { UniversityMagazineDBContext db = new UniversityMagazineDBContext(); var model = db.TERMCONDITIONs.FirstOrDefault(); return(View(model)); }
public JsonResult GetDataChart() { var session = (UserLogin)Session[CommonConstants.USER_SESSION]; UniversityMagazineDBContext db = new UniversityMagazineDBContext(); if (session.RoleGroup == "MARKETINGMANAGER") { List <string> faculty = new List <string>(); List <int> article = new List <int>(); List <int> articleApprove = new List <int>(); List <int> image = new List <int>(); List <int> imageApprove = new List <int>(); foreach (var item in db.FACULTies) { faculty.Add(item.FACULTY_Code); article.Add(db.ARTICLEs.Where(x => x.FACULTY_Id == item.FACULTY_Id).Count()); articleApprove.Add(db.ARTICLEs.Where(x => x.FACULTY_Id == item.FACULTY_Id && x.ARTICLE_Status == true).Count()); image.Add(db.IMAGEs.Where(x => x.FACULTY_Id == item.FACULTY_Id).Count()); imageApprove.Add(db.IMAGEs.Where(x => x.FACULTY_Id == item.FACULTY_Id && x.IMAGE_Status == true).Count()); } return(Json(new { faculty = faculty, article = article, articleApprove = articleApprove, image = image, imageApprove = imageApprove }, JsonRequestBehavior.AllowGet)); } else if (session.RoleGroup == "MARKETINGCOORDINATOR") { var Article = db.ARTICLEs.Where(x => x.FACULTY_Id == db.ACCOUNTs.FirstOrDefault(y => y.ACCOUNT_Id == session.UserID).FACULTY_Id).Count(); var ArticleApproved = db.ARTICLEs.Where(x => x.FACULTY_Id == db.ACCOUNTs.FirstOrDefault(y => y.ACCOUNT_Id == session.UserID).FACULTY_Id&& x.ARTICLE_Status == true).Count(); var ArticleUnapproved = db.ARTICLEs.Where(x => x.FACULTY_Id == db.ACCOUNTs.FirstOrDefault(y => y.ACCOUNT_Id == session.UserID).FACULTY_Id&& x.ARTICLE_Status == false).Count(); var Image = db.IMAGEs.Where(x => x.FACULTY_Id == db.ACCOUNTs.FirstOrDefault(y => y.ACCOUNT_Id == session.UserID).FACULTY_Id).Count(); var ImageApproved = db.IMAGEs.Where(x => x.FACULTY_Id == db.ACCOUNTs.FirstOrDefault(y => y.ACCOUNT_Id == session.UserID).FACULTY_Id&& x.IMAGE_Status == true).Count(); var ImageUnapproved = db.IMAGEs.Where(x => x.FACULTY_Id == db.ACCOUNTs.FirstOrDefault(y => y.ACCOUNT_Id == session.UserID).FACULTY_Id&& x.IMAGE_Status == false).Count(); object[] parameters = { new SqlParameter("@faculty", db.ACCOUNTs.FirstOrDefault(y => y.ACCOUNT_Id == session.UserID).FACULTY_Id), }; var res = db.Database.SqlQuery <Top3AccountUploadModel>("Top3AccountUpload @faculty", parameters).ToList(); List <Top3AccountUploadModel> topUploadArticle = new List <Top3AccountUploadModel>(); foreach (var item in res) { topUploadArticle.Add(item); } return(Json(new { Article = Article, ArticleApprove = ArticleApproved, ArticleUnapproved = ArticleUnapproved, Image = Image, ImageApproved = ImageApproved, ImageUnapproved = ImageUnapproved, topUploadArticle = topUploadArticle }, JsonRequestBehavior.AllowGet)); } else if (session.RoleGroup == "STUDENT") { var Article = db.ARTICLEs.Where(x => x.ACCOUNT_Id == session.UserID).Count(); var ArticleApproved = db.ARTICLEs.Where(x => x.ACCOUNT_Id == session.UserID && x.ARTICLE_Status == true).Count(); var ArticleUnapproved = db.ARTICLEs.Where(x => x.ACCOUNT_Id == session.UserID && x.ARTICLE_Status == false).Count(); var Image = db.IMAGEs.Where(x => x.ACCOUNT_Id == session.UserID).Count(); var ImageApproved = db.IMAGEs.Where(x => x.ACCOUNT_Id == session.UserID && x.IMAGE_Status == true).Count(); var ImageUnapproved = db.IMAGEs.Where(x => x.ACCOUNT_Id == session.UserID && x.IMAGE_Status == false).Count(); return(Json(new { Article = Article, ArticleApprove = ArticleApproved, ArticleUnapproved = ArticleUnapproved, Image = Image, ImageApproved = ImageApproved, ImageUnapproved = ImageUnapproved }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index(TERMCONDITION tERMCONDITION) { UniversityMagazineDBContext db = new UniversityMagazineDBContext(); var model = db.TERMCONDITIONs.FirstOrDefault(); model.TERMCONDITION_Content = tERMCONDITION.TERMCONDITION_Content; db.SaveChanges(); return(RedirectToAction("Index")); }
public void SendComment(Guid?From, Guid?Article, string type) { Guid?Id = null; if (type == "Article") { var dao = new ArticleDAO(); var article = dao.GetById(Article); if (article.ACCOUNT_Id == From) { var To = new UniversityMagazineDBContext().ACCOUNTs.Where(x => x.ROLEGROUP.ROLEGROUP_Code == "MARKETINGCOORDINATOR" && x.FACULTY_Id == article.FACULTY_Id).FirstOrDefault().ACCOUNT_Id; if (type == "Article") { Id = new CommentArticleDAO().CreateNotificationComment(From, To, "/Upload/Articles/Article/" + article.ARTICLE_FileName, type); } LoadNotification(To); } else { if (type == "Article") { Id = new CommentArticleDAO().CreateNotificationComment(From, article.ACCOUNT_Id, "/MyUpload/File/" + article.ARTICLE_FileName, type); } LoadNotification(article.ACCOUNT_Id); } } else if (type == "Image") { var dao = new ImageDAO(); var image = dao.GetById(Article); if (image.ACCOUNT_Id == From) { var To = new UniversityMagazineDBContext().ACCOUNTs.Where(x => x.ROLEGROUP.ROLEGROUP_Code == "MARKETINGCOORDINATOR" && x.FACULTY_Id == image.FACULTY_Id).FirstOrDefault().ACCOUNT_Id; if (type == "Image") { Id = new CommentArticleDAO().CreateNotificationComment(From, To, "/Upload/Images/Image/" + image.IMAGE_FileName, type); } LoadNotification(To); } else { if (type == "Image") { Id = new CommentArticleDAO().CreateNotificationComment(From, image.ACCOUNT_Id, "/MyUpload/Image/" + image.IMAGE_FileName, type); } LoadNotification(image.ACCOUNT_Id); } } if (Id != null) { LoadDetailNotification(Id); } }
public CommentArticleDAO() { db = new UniversityMagazineDBContext(); }
public ImageDAO() { db = new UniversityMagazineDBContext(); }
public NotificationDAO() { db = new UniversityMagazineDBContext(); }
public LoginDAO() { db = new UniversityMagazineDBContext(); }
public FacultyDAO() { db = new UniversityMagazineDBContext(); }
public RoleGroupDAO() { db = new UniversityMagazineDBContext(); }
public AccountDAO() { db = new UniversityMagazineDBContext(); }
public ChatDAO() { db = new UniversityMagazineDBContext(); }