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