public ActionResult Create(StudentAdvisingRemark studentadvisingremark, string opener_id = null)
{
if (ModelState.IsValid)
{
db.StudentAdvisingRemarks.Add(studentadvisingremark);
try
{
studentadvisingremark.created = DateTime.Now;
studentadvisingremark.created_by = User.Identity.Name;
studentadvisingremark.modified = DateTime.Now;
studentadvisingremark.modified_by = User.Identity.Name;
db.SaveChanges();
if (!String.IsNullOrEmpty(studentadvisingremark.filename) && !String.IsNullOrEmpty(studentadvisingremark.filepath))
{
var sourcePath = Server.MapPath("~/App_Data/" + studentadvisingremark.filepath);
var sourceFilepath = Path.Combine(sourcePath, studentadvisingremark.filename);
var destPath = Server.MapPath("~/App_Data/" + "Attachments/AdvisingRemark/" + studentadvisingremark.id);
var destFilepath = Path.Combine(destPath, studentadvisingremark.filename);
try
{
Directory.CreateDirectory(destPath);
}
catch (Exception e)
{
Session["FlashMessage"] = "Failed to create directory." + e.Message;
}
try
{
System.IO.File.Move(sourceFilepath, destFilepath);
studentadvisingremark.filepath = "Attachments/AdvisingRemark/" + studentadvisingremark.id;
db.SaveChanges();
}
catch (Exception e)
{
Session["FlashMessage"] = "Failed to move file." + e.Message;
}
}
//clear temp files uploaded but not used
if (Directory.Exists(Server.MapPath("~/App_Data/Temp/AdvisingRemark/" + User.Identity.Name)))
{
var files = Directory.GetFiles(Server.MapPath("~/App_Data/Temp/AdvisingRemark/" + User.Identity.Name));
foreach (var file in files)
{
System.IO.File.Delete(file);
}
}
}
catch (Exception e)
{
return(HttpNotFound("Failed to add remark.<br/><br/>" + e.Message));
}
}
return(RedirectToAction("AdvisingRemark", "StudentProfile", new { student_id = studentadvisingremark.student_id, opener_id = opener_id }));
}
public ActionResult Edit(int id = 0, string opener_id = null)
{
ViewBag.opener_id = opener_id;
StudentAdvisingRemark studentadvisingremark = db.StudentAdvisingRemarks.ToList().Where(p => p.id == id && (p.created_by == User.Identity.Name)).SingleOrDefault();
if (studentadvisingremark == null)
{
return(HttpNotFound("The record you selected does not exist. Please refresh the page."));
}
return(View(studentadvisingremark));
}
public ActionResult Delete(int id = 0, string opener_id = null)
{
StudentAdvisingRemark studentadvisingremark = db.StudentAdvisingRemarks.ToList().Where(p => p.id == id && (p.created_by == User.Identity.Name)).SingleOrDefault();
var student_id = studentadvisingremark.student_id;
if (studentadvisingremark == null)
{
return(HttpNotFound("The record you selected does not exist. Please refresh the page."));
}
db.StudentAdvisingRemarks.Remove(studentadvisingremark);
db.SaveChanges();
return(RedirectToAction("AdvisingRemark", "StudentProfile", new { student_id = student_id, opener_id = opener_id }));
}
public ActionResult Create(string student_id = null, string opener_id = null)
{
ViewBag.opener_id = opener_id;
var student = db.StudentProfiles.Find(student_id);
if (student == null)
{
return(HttpNotFound("Student Profile not found."));
}
StudentAdvisingRemark studentadvisingremark = new StudentAdvisingRemark
{
display_date = DateTime.Now,
@private = true,
student_id = student.id,
StudentProfile = student
};
return(View(studentadvisingremark));
}
public ActionResult Edit(StudentAdvisingRemark studentadvisingremark, string opener_id = null)
{
if (ModelState.IsValid)
{
var remark = db.StudentAdvisingRemarks.Find(studentadvisingremark.id);
if (remark.filename != studentadvisingremark.filename || remark.filepath != studentadvisingremark.filepath) // action only when existing filename is diff from posted one
{
if (!String.IsNullOrEmpty(remark.filename)) //delete existing file if filename id not empty
{
var path = Server.MapPath("~/App_Data/" + remark.filepath);
var filepath = Path.Combine(path, remark.filename);
if (System.IO.File.Exists(filepath))
{
try
{
System.IO.File.Delete(filepath);
}
catch (Exception e)
{
Session["FlashMessage"] = "Failed to delete attachment." + e.Message;
}
}
}
if (!String.IsNullOrEmpty(studentadvisingremark.filename) && !String.IsNullOrEmpty(studentadvisingremark.filepath)) // move the uploaded file to destination
{
var sourcePath = Server.MapPath("~/App_Data/" + studentadvisingremark.filepath);
var sourceFilepath = Path.Combine(sourcePath, studentadvisingremark.filename);
var destPath = Server.MapPath("~/App_Data/" + "Attachments/AdvisingRemark/" + studentadvisingremark.id);
var destFilepath = Path.Combine(destPath, studentadvisingremark.filename);
try
{
Directory.CreateDirectory(destPath);
}
catch (Exception e)
{
Session["FlashMessage"] = "Failed to create directory." + e.Message;
}
try
{
System.IO.File.Move(sourceFilepath, destFilepath);
studentadvisingremark.filepath = "Attachments/AdvisingRemark/" + studentadvisingremark.id;
}
catch (Exception e)
{
Session["FlashMessage"] = "Failed to move file." + e.Message;
}
}
//clear temp files uploaded but not used
if (Directory.Exists(Server.MapPath("~/App_Data/Temp/AdvisingRemark/" + studentadvisingremark.id)))
{
var files = Directory.GetFiles(Server.MapPath("~/App_Data/Temp/AdvisingRemark/" + studentadvisingremark.id));
foreach (var file in files)
{
System.IO.File.Delete(file);
}
}
}
studentadvisingremark.modified = DateTime.Now;
studentadvisingremark.modified_by = User.Identity.Name;
db.Entry(remark).CurrentValues.SetValues(studentadvisingremark);
db.SaveChanges();
}
return(RedirectToAction("AdvisingRemark", "StudentProfile", new { student_id = studentadvisingremark.student_id, opener_id = opener_id }));
}
