public ActionResult GetFiles(TeacherRel model) { try { DBmodel db = new DBmodel(); string grades = null; string subject = null; if (Session["Grade"] != null && Session["Subject"] != null) { grades = Session["Grade"].ToString(); subject = Session["Subject"].ToString(); } else { ViewBag.sessionError = "Session time out"; return(RedirectToAction("Loginpage", "Login")); } List <upload_file> files = db.upload_file.Where(x => x.grade == grades && x.subject == subject).ToList(); return(View(files)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "GetFiles"))); } }
public ActionResult GetFiles(TeacherRel model) { try { DBmodel db = new DBmodel(); var grades = db.grades.Where(u => u.grade_id == model.grade_id) .Select(u => new { grade = u.grade1 }).Single(); var subjects = db.subjects.Where(u => u.subject_id == model.subject_id) .Select(u => new { subject = u.subject1 }).Single(); List <upload_file> files = db.upload_file.Where(x => x.grade == grades.grade && x.subject == subjects.subject).ToList(); return(View(files)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "GetFiles"))); } }
public ActionResult Index(IEnumerable <HttpPostedFileBase> files, TeacherRel model, String message) { try { DBmodel db = new DBmodel(); upload_file log = new upload_file(); upload_file_teacher log2 = new upload_file_teacher(); int count = 0; if (!ModelState.IsValid) { return(new JsonResult { Data = "File not uploaded" }); } else { if (files != null) { foreach (var file in files) { //check is the file name is already in the database string filename = file.FileName; List <upload_file> list = db.upload_file.ToList(); foreach (var item in list) { if (item.file_name.Contains(filename)) { ViewBag.DuplicateFile = "File name is already used!"; return(new JsonResult { Data = "File not uploaded, File name is already used!" }); } else { ViewBag.DuplicateFile = "File name is already used!"; } } if (file != null && file.ContentLength > 0) { var fileName = file.FileName; var path = Path.Combine(Server.MapPath("~/UploadedFiles"), fileName); log.file_name = fileName; log.file_path = path; log.upload_date = DateTime.Now; int gradeid = model.grade_id; int subjectid = model.subject_id; var grades = db.GradeLists.Where(u => u.ID == gradeid) .Select(u => new { grade = u.Grade }).Single(); var subjects = db.subjects.Where(u => u.subject_id == subjectid) .Select(u => new { subject = u.subject1 }).Single(); log.grade = grades.grade; log.subject = subjects.subject; //db.SaveChanges(); int teacherid = model.teacher_id; log2.teacher_id = teacherid; db.upload_file.Add(log); db.upload_file_teacher.Add(log2); file.SaveAs(path); db.SaveChanges(); count++; } } return(new JsonResult { Data = "Successfully file Uploaded" }); } else { return new JsonResult { Data = "File not uploaded" } }; } } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "Index"))); } }