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