public ActionResult Edit(int?id) { try { DBmodel db = new DBmodel(); upload_file file = db.upload_file.Find(id); UploadFile model = new UploadFile(); if (file == null) { return(HttpNotFound()); } else { ViewBag.teachersList = new SelectList(GetteachersList(), "teacher_id", "teacher_name"); model.file_id = file.file_id; model.file_name = file.file_name; model.file_path = file.file_path; model.grade = file.grade; model.subject = file.subject; } return(View(model)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "Edit"))); } }
public ActionResult Delete(int?id) { try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DBmodel db = new DBmodel(); upload_file file = db.upload_file.Find(id); UploadFile model = new UploadFile(); if (file == null) { return(HttpNotFound()); } else { model.file_id = file.file_id; model.file_name = file.file_name; model.file_path = file.file_path; model.grade = file.grade; model.subject = file.subject; } return(View(model)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "Delete"))); } }
public ActionResult DeleteSucces(int id) { try { DBmodel db = new DBmodel(); upload_file file = db.upload_file.Find(id); upload_file_teacher teacher = db.upload_file_teacher.Find(id); //db.SaveChanges(); var directory = new DirectoryInfo(Server.MapPath("~/UploadedFiles")); //FileInfo[] getFile = directory.GetFiles(file.file_name+".*"); string getFile = directory.FullName + "\\" + file.file_name; System.IO.File.Delete(getFile); db.upload_file_teacher.Remove(teacher); db.upload_file.Remove(file); db.SaveChanges(); return(RedirectToAction("ViewList")); } catch (FileNotFoundException ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "DeleteSucces"))); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "DeleteSucces"))); } }
public ActionResult TeacherEditSucces(int id, TeacherUpload model) { try { if (ModelState.IsValid) { DBmodel db = new DBmodel(); upload_file file = db.upload_file.Find(id); string oldName = file.file_name; file.file_name = model.file_name.Trim(); int gradeID = model.grade_id; int subjectID = model.subject_id; var grade = db.GradeLists.Where(m => m.ID == gradeID) .Select(u => new { grade = u.Grade }).Single(); var subject = db.subjects.Where(m => m.subject_id == subjectID) .Select(u => new { subject = u.subject1 }).Single(); file.grade = grade.grade; file.subject = subject.subject; var directory = new DirectoryInfo(Server.MapPath("~/UploadedFiles")); string path = directory.FullName + "\\" + model.file_name; // path = "D:\\MVC\\Project\\Project\\UploadedFiles\\" + fileName; file.file_path = path.Trim(); //db.SaveChanges(); int fileID = model.file_id; db.Entry(file).State = EntityState.Modified; db.SaveChanges(); ChangeFileName(fileID, model.file_name, oldName); return(RedirectToAction("TeacherViewList")); } else { ViewBag.teachersList = new SelectList(GetteachersList(), "teacher_id", "teacher_name"); return(View(model)); } } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "TeacherEditSucces"))); } }
public ActionResult Edit(int?id) { try { DBmodel db = new DBmodel(); upload_file file = db.upload_file.Find(id); ViewBag.teachersList = new SelectList(GetteachersList(), "teacher_id", "teacher_name"); return(View(file)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "Edit"))); } }
public ActionResult TeacherEdit(int?id) { try { DBmodel db = new DBmodel(); upload_file file = db.upload_file.Find(id); TeacherUpload model = new TeacherUpload(); if (file == null) { return(HttpNotFound()); } else { int teacherID = Int32.Parse(Session["UserID"].ToString()); List <teacher_subject> subID = db.teacher_subject.Where(x => x.teacher_id == teacherID).ToList(); List <subject> subjects = new List <subject>(); foreach (var item in subID) { int subjectId = item.subject_id; subjects.Add(db.subjects.Where(x => x.subject_id == subjectId).FirstOrDefault()); } ViewBag.subList = new SelectList(subjects, "subject_id", "subject1"); model.file_id = file.file_id; model.file_name = file.file_name; model.file_path = file.file_path; model.grade = file.grade; model.subject = file.subject; } return(View(model)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "TeacherEditSucces"))); } }
public ActionResult Delete(int?id) { try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DBmodel db = new DBmodel(); upload_file file = db.upload_file.Find(id); if (file == null) { return(HttpNotFound()); } return(View(file)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "Delete"))); } }
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"))); } }