public ActionResult Details(int id)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
Picture pic = dbc.Pictures.Include("Student").SingleOrDefault(p => p.Id == id);
return(View("Details", pic));
}
public ActionResult ViewAll()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
List <Picture> pics = dbc.Pictures.Include("Student").Where(p => p.Public.Equals("Yes")).ToList();
return(View(pics));
}
public ActionResult CountPic()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
List <Picture> pics = dbc.Pictures.Where(s => s.Public.Equals("Yes")).ToList();
return(View(pics));
}
//public ActionResult SearchBySchool(FormCollection form) {
// CTEFArtContestEntities dbc = new CTEFArtContestEntities();
// string school = form["schools"].ToString();
// List<Picture> pics = dbc.Pictures.Include("Student").Where(p => p.Student.School.Equals(school) && p.Public.Equals("Yes")).ToList();
// return View("ViewAll",pics);
//}
public ActionResult SearchByGrade(string[] grade)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
List <Picture> pics = dbc.Pictures.Include("Student").Where(p => grade.Contains(p.Student.Grade) && p.Public.Equals("Yes")).ToList();
return(View("ViewAll", pics));
}
public ActionResult DividePic()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
List <User> judge = dbc.Users.Where(u => u.UserTypeId == 2).ToList();
return(View(judge));
}
public ActionResult CreateJudge()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
CreateJudgeModel vm = new CreateJudgeModel();
//vm.UserType = dbc.UserTypes.ToList();
return(View(vm));
}
public ActionResult DisableStu(DisableStudentModel ds)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
dbc.Entry(ds.DisableStudent).State = System.Data.Entity.EntityState.Modified;
dbc.SaveChanges();
return(RedirectToAction("Index", "Admin"));
}
public ActionResult DisableStu()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
DisableStudentModel vm = new DisableStudentModel();
vm.DisableStudent = dbc.DisableStudents.Where(d => d.Id == 1).SingleOrDefault();
return(View(vm));
}
public ActionResult Score(ScoreViewModel sc)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
sc.PictureRate.Rate = sc.Score;
dbc.Entry(sc.PictureRate).State = System.Data.Entity.EntityState.Modified;
dbc.SaveChanges();
return(RedirectToAction("Index", "Judge"));
}
public ActionResult Larger(int id)
{
var userid = (int)Session["userid"];
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
ScoreViewModel vm = new ScoreViewModel();
vm.PictureRate = dbc.PictureRates.SingleOrDefault(p => p.PictureId == id && p.JudgeId == userid);
vm.Picture = dbc.Pictures.SingleOrDefault(p => p.Id == id);
return(View(vm));
}
public ActionResult DeleteMission(int id)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
List <PictureRate> pics = dbc.PictureRates.Where(p => p.JudgeId == id).ToList();
if (pics.Count() > 0)
{
dbc.PictureRates.RemoveRange(pics); dbc.SaveChanges();
return(RedirectToAction("ViewJudge"));
}
return(RedirectToAction("ViewJudge"));
}
public ActionResult CreateJudge(User user)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
if (user.UserName == null || user.Password == null || user.UserFirstName == null || user.UserLastName == null)
{
return(View());
}
user.UserTypeId = 2;
dbc.Users.Add(user);
dbc.SaveChanges();
return(RedirectToAction("ViewJudge", "Admin"));
}
public ActionResult RemoveJudge(int id)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
var target = dbc.Users.SingleOrDefault(j => j.Id == id);
List <PictureRate> prlist = dbc.PictureRates.Where(pr => pr.JudgeId == id).ToList();
if (target != null)
{
dbc.Users.Remove(target);
dbc.PictureRates.RemoveRange(prlist);
dbc.SaveChanges();
}
return(RedirectToAction("ViewJudge", "Admin"));
}
public ActionResult ChangeP(string password1, string password2, User user)
{
if (password1 != password2)
{
TempData["notice"] = "The password You just enter was different from the First one you enter";
return(RedirectToAction("ChangeP"));
}
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
var admin = dbc.Users.Where(u => u.UserTypeId == 1).SingleOrDefault();
admin.Password = password1;
dbc.Entry(admin).State = System.Data.Entity.EntityState.Modified;
dbc.SaveChanges();
return(RedirectToAction("Index"));
}
//[Authorize(Roles ="Admin")]
public ActionResult Index()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
if (Session["userid"] == null || !dbc.Users.Where(u => u.UserTypeId == 1).Select(u => u.Id).ToList().Contains((int)Session["userid"]))
{
return(RedirectToAction("Index", "Home"));
}
var userid = (int)Session["userid"];
AdminIndexViewModel vm = new AdminIndexViewModel();
vm.School = new SelectList(dbc.Pictures.Where(s => s.Public.Equals("Yes")).Select(s => s.Student.School), "School");
vm.Pictures = dbc.Pictures.Include("Student").Where(p => p.Public.Equals("Yes")).ToList();
return(View(vm));
}
//public ActionResult SearchBySchoolThenByGrade(FormCollection form,string grade) {
// CTEFArtContestEntities dbc = new CTEFArtContestEntities();
// string school = form["schools"].ToString();
// List<Picture> pics = dbc.Pictures.Include("Student").Where(p => p.Student.School.Equals(school) && p.Student.Grade.Equals(grade) && p.Public.Equals("Yes")).ToList();
// return View("ViewAll",pics);
//}
public void DSI()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
StringWriter sw = new StringWriter();
sw.WriteLine("\"Picture ID\"|\"Picture Title\"|\"Picture Upload Date\"|\"User ID\"|\"User FirstName\"|\"User MiddleName\"|\"User LastName\"|\"Grade\"|\"Age\"|\"Gender\"|\"School\"|\"Street\"|\"City\"|\"State\"|\"Zip Code\"|\"Teacher Title\"|\"Teacher FirstName\"|\"Teacher MiddleName\"|\"Teacher LastName\"|\"Parent LastName\"|\"Parent MiddleName\"|\"Parent FirstName\"|\"Parent Email\"|\"Parent Phone Number\"|\"UserName\"|\"Password\"|\"Picture Description\"");
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=ArtContestUserInfo.csv");
Response.ContentType = "text/csv";
foreach (var p in dbc.Pictures.Where(p => p.Public.Equals("Yes")))
{
var stu = dbc.Students.SingleOrDefault(s => s.Id == p.UserId);
sw.WriteLine(string.Format("\"{0}\"|\"{1}\"|\"{2}\"|\"{3}\"|\"{4}\"|\"{5}\"|\"{6}\"|\"{7}\"|\"{8}\"|\"{9}\"|\"{10}\"|\"{11}\"|\"{12}\"|\"{13}\"|\"{14}\"|\"{15}\"|\"{16}\"|\"{17}\"|\"{18}\"|\"{19}\"|\"{20}\"|\"{21}\"|\"{22}\"|\"{23}\"|\"{24}\"|\"{25}\"|\"{26}\"|", p.Id, p.Title, p.UploadDate, p.UserId, stu.User.UserFirstName, stu.User.UserMiddleName, stu.User.UserLastName, stu.Grade, stu.Age, stu.Gender, stu.School, stu.Street, stu.City, stu.State, stu.Zip, stu.TeacherTitle, stu.TeacherFirstName, stu.TeacherMiddleName, stu.TeacherLastName, stu.ParentLastName, stu.ParentMiddleName, stu.ParentFirstName, stu.ParentEmail, stu.ParentPhoneNumber, stu.User.UserName, stu.User.Password, p.Description));
}
Response.Write(sw.ToString());
Response.End();
}
public void DGI()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
StringWriter sw = new StringWriter();
sw.WriteLine("\"Picture ID\"|\"Judge ID\"|\"Score\"");
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=ArtContestScoreInfo.csv");
Response.ContentType = "text/csv";
foreach (var prs in dbc.PictureRates.GroupBy(prs => prs.PictureId))
{
foreach (var pr in prs)
{
sw.WriteLine(string.Format("\"{0}\"|\"{1}\"|\"{2}\"", pr.PictureId, pr.JudgeId, pr.Rate));
}
}
Response.Write(sw.ToString());
Response.End();
}
public ActionResult Index(LoginModel model)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
if (model.userName == null || model.password == null)
{
return(View());
}
var userList = dbc.Users.Select(u => u.UserName).ToList();
if (userList.Contains(model.userName) &&
model.password == dbc.Users.Where(u => u.UserName == model.userName).Select(u => u.Password).Single())
{
if (dbc.Users.Where(u => u.UserName == model.userName).Select(u => u.UserTypeId).SingleOrDefault() == 1)
{
Session["userid"] = dbc.Users.Where(s => s.UserName == model.userName).Select(u => u.Id).SingleOrDefault();
return(RedirectToAction("Index", "Admin"));
}
if (dbc.Users.Where(u => u.UserName == model.userName).Select(u => u.UserTypeId).SingleOrDefault() == 2)
{
Session["userid"] = dbc.Users.Where(s => s.UserName == model.userName).Select(u => u.Id).SingleOrDefault();
return(RedirectToAction("Index", "Judge"));
}
if (dbc.Users.Where(u => u.UserName == model.userName).Select(u => u.UserTypeId).SingleOrDefault() == 3)
{
if (dbc.DisableStudents.Where(d => d.Id == 1).Select(d => d.Disable).SingleOrDefault().Equals("yes"))
{
TempData["notice"] = "Sorry the due date past, you can't login.";
return(View());
}
else
{
model.PicPath = dbc.Pictures
.Where(p => p.UserId == dbc.Users.Where(u => model.userName == u.UserName)
.Select(u => u.Id).FirstOrDefault()).Select(p => p.PicturePath).ToList();
Session["userid"] = dbc.Users.Where(s => s.UserName == model.userName).Select(u => u.Id).SingleOrDefault();
return(RedirectToAction("Index", "StudentAccount"));
}
}
}
return(View());
}
public ActionResult ChangeP(string password1, string password2, User user)
{
if (password1 != password2)
{
TempData["notice"] = "The password You just enter was different from the First one you enter";
return(RedirectToAction("ChangeP"));
}
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
var judges = dbc.Users.Where(u => u.UserTypeId == 2).ToList();
foreach (var judge in judges)
{
if (judge.Id == (int)Session["userid"])
{
judge.Password = password1;
dbc.Entry(judge).State = System.Data.Entity.EntityState.Modified;
}
}
dbc.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult CheckPic(int id)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
CheckPicViewModel vm = new CheckPicViewModel();
vm.User = dbc.Users.SingleOrDefault(u => u.Id == id);
vm.PictureRates = dbc.PictureRates.Where(p => p.JudgeId == id).ToList();
vm.Grades = new HashSet <string>();
//vm.Grades = dbc.Students.Where(s=>s.Grade = )
var pics = new HashSet <Picture>();
foreach (var item in vm.PictureRates)
{
pics.Add(dbc.Pictures.Where(p => p.Id == item.PictureId).SingleOrDefault());
}
foreach (var item in pics)
{
vm.Grades.Add(dbc.Students.SingleOrDefault(s => s.Id == item.UserId).Grade);
}
return(View(vm));
}
// GET: JudgeAccount
public ActionResult Index()
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
if (Session["userid"] == null || !dbc.Users.Where(u => u.UserTypeId == 2).Select(u => u.Id).ToList().Contains((int)Session["userid"]))
{
return(RedirectToAction("Index", "Home"));
}
var userid = (int)Session["userid"];
var prs = dbc.PictureRates.Where(p => p.JudgeId == userid).ToList();
List <Picture> pics = new List <Picture>();
foreach (var pid in prs)
{
var pic = dbc.Pictures.SingleOrDefault(p => p.Id == pid.PictureId);
if (pic != null)
{
pics.Add(pic);
}
}
return(View(pics));
}
public ActionResult DividePic(int judgeId, string[] Grade)
{
if (Grade == null)
{
TempData["notice"] = "Please Don't leave the grade blank";
return(RedirectToAction("DividePic"));
}
foreach (var grade in Grade)
{
CTEFArtContestEntities dbc = new CTEFArtContestEntities();
List <Student> stus = dbc.Students.Where(s => s.Grade == grade).ToList();
foreach (var s in stus)
{
Picture pic = dbc.Pictures.Where(p => p.UserId == s.Id && p.Public.Equals("Yes")).SingleOrDefault();
if (pic == null)
{
TempData["notice"] = "One or more grades have empty pictures, System won't assign the empty picture";
continue;
}
PictureRate pr = new PictureRate();
pr.PictureId = pic.Id;
pr.JudgeId = judgeId;
pr.Rate = -1;
if (!dbc.PictureRates.Any(r => r.JudgeId == judgeId && r.PictureId == pr.PictureId))
{
dbc.PictureRates.Add(pr);
dbc.SaveChanges();
}
else
{
ModelState.AddModelError("You have Assign These Pictures to This Judge", "You have Assign These Pictures to This Judge");
}
}
}
return(RedirectToAction("ViewJudge", "Admin"));
}
