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