public ActionResult Edit(int id, ExamUpload model)
{
DBmodel db = new DBmodel();
Exam2 exam = db.Exam2.Find(id);
if (ModelState.IsValid)
{
string oldName = exam.FileName;
exam.FileName = model.FileName;
int grade2 = model.grade_id;
int subject2 = model.subject_id;
var subject = db.subjects.Where(m => m.subject_id == subject2).Select(u => new { subject = u.subject1 }).Single();
var grade = db.GradeLists.Where(m => m.ID == grade2).Select(u => new { grade = u.Grade }).Single();
//file.FilePath = fullPath;
exam.Grade = grade.grade;
exam.Subject = subject.subject;
db.Entry(exam).State = EntityState.Modified;
db.SaveChanges();
int ExamID = model.ExamID;
Exam2 teacher = db.Exam2.Find(id);
teacher.ExamID = model.ExamID;
db.Entry(teacher).State = EntityState.Modified;
db.SaveChanges();
ChangeFileName(ExamID, model.FileName, oldName);
return(RedirectToAction("ViewList"));
}
else
{
List <grade> gradeList = db.grades.ToList();
ViewBag.grList = new SelectList(gradeList, "grade_id", "grade1");
List <subject> subjectList = db.subjects.ToList();
ViewBag.subList = new SelectList(subjectList, "subject_id", "subject1");
return(View(model));
}
}
public ActionResult Index(HttpPostedFileBase file, ExamUpload ex)
{
if (!ModelState.IsValid)
{
return(new JsonResult {
Data = "File not upload"
});
}
else
{
SipminiEntities2 DB = new SipminiEntities2();
Exam2 log = new Exam2();
var subject = DB.subjects.Where(m => m.subject_id == ex.subject_id).Select(u => new { subject = u.subject1 }).Single();
var grade = DB.grades.Where(m => m.grade_id == ex.grade_id).Select(u => new { grade = u.grade1 }).Single();
string path = Server.MapPath("~/App_Data/File");
string fileName = Path.GetFileName(file.FileName);
string fullPath = Path.Combine(path, fileName);
log.FileName = fileName;
log.FilePath = fullPath;
log.Grade = grade.grade;
log.Subject = subject.subject;
log.TeacherName = "ASDF";
DB.Exam2.Add(log);
DB.SaveChanges();
file.SaveAs(fullPath);
return(new JsonResult {
Data = "File uploaded"
});
}
}
public ActionResult Edit(int?id)
{
DBmodel db = new DBmodel();
Exam2 file = db.Exam2.Find(id);
ExamUpload model = new ExamUpload();
model.ExamID = file.ExamID;
model.subject1 = file.Subject;
model.grade1 = file.Grade;
model.TeacherName = file.TeacherName;
model.FileName = file.FileName;
model.FilePath = file.FilePath;
List <subject> subjectList = db.subjects.ToList();
ViewBag.subList = new SelectList(subjectList, "subject_id", "subject1");
List <grade> gradeList = db.grades.ToList();
ViewBag.grList = new SelectList(gradeList, "grade_id", "grade1");
return(View(model));
}
