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 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"))); } }
public ActionResult EditSucces(int id, UploadFile 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; upload_file_teacher teacher = db.upload_file_teacher.Find(fileID); teacher.teacher_id = model.teacher_id; db.Entry(teacher).State = EntityState.Modified; db.Entry(file).State = EntityState.Modified; db.SaveChanges(); ChangeFileName(fileID, model.file_name, oldName); return(RedirectToAction("ViewList")); } else { ViewBag.teachersList = new SelectList(GetteachersList(), "teacher_id", "teacher_name"); return(View(model)); } } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "UploadFile", "EditSucces"))); } }