public LectureNoteViewModel Update(LectureNoteEditModel lectureNote)
{
LectureNote updateLectureNote = _mapper.Map <LectureNoteEditModel, LectureNote>(lectureNote);
LectureNote updatednote = _unitOfWork.LectureNotes.Update(updateLectureNote);
return(_mapper.Map <LectureNote, LectureNoteViewModel>(updatednote));
}
/// <summary>
/// Creates an instance of LectureNote from the data record in the database.
/// </summary>
/// <param name="myRecord">Single row of record.</param>
/// <returns>An LectureNote.</returns>
private static LectureNote FillRecord(IDataRecord myRecord)
{
LectureNote myLectureNote = new LectureNote();
//myLectureNote.CourseId = myRecord.GetString(myRecord.GetOrdinal("CourseID"));
myLectureNote.LectureId = myRecord.GetInt32(myRecord.GetOrdinal("LectureID"));
myLectureNote.LTitle = myRecord.GetString(myRecord.GetOrdinal("LTitle"));
myLectureNote.LFileLocation = myRecord.GetString(myRecord.GetOrdinal("LFileLocation"));
return(myLectureNote);
}
private async Task UpdateRatingAsync(string postId)
{
LectureNote lectureNote = _unitOfWork.LectureNotes.Get(postId);
if (lectureNote != null)
{
lectureNote.AverageRating = _unitOfWork.LectureNoteRatings.GetAverageRating(postId);
_unitOfWork.LectureNotes.Update(lectureNote);
await _unitOfWork.SaveAsync();
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
LectureNote lNote = new LectureNote();
lNote.LectureId = -1;
lNote.CourseId = Session["courseID"].ToString();
//Check whether or not the title is specified.
if (txtboxLectureTitle.Text == String.Empty)
{
ClientScript.RegisterStartupScript(this.GetType(), "errorTitle",
"alert('Please provide title of the lecture note!!!');", true);
}
else
{
lNote.LTitle = txtboxLectureTitle.Text;
//Check whether or not there is valid file to upload.
if (fileuploadLectureNote.HasFile)
{
if (fileuploadLectureNote.PostedFile.ContentType.ToLower() == "application/pdf" ||
fileuploadLectureNote.PostedFile.ContentType.ToLower() == "application/x-mspowerpoint")
{
//Append date and time in the filename to make it unique.
string filename = Path.GetFileNameWithoutExtension(fileuploadLectureNote.FileName) +
DateTime.Now.ToString("_yyyy_mm_dd_HH_mm_ss");
string extension = Path.GetExtension(fileuploadLectureNote.FileName);
string directory = Server.MapPath("~/CourseMaterials/" + Session["courseID"] + "/LectureNote");
//Create directory if no folder toa save the lecture note
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
lNote.LFileLocation = directory + "/" + filename + extension;
fileuploadLectureNote.SaveAs(lNote.LFileLocation);
ClientScript.RegisterStartupScript(this.GetType(), "successUpload",
"alert('Uploaded successfully!!!');", true);
LectureNoteController.Save(lNote);
Response.Redirect("~/InstructorSite/formManageLectureNote.aspx");
}
else //If the file format is invalid.
{
ClientScript.RegisterStartupScript(this.GetType(), "fileFormatError",
"alert('File format error: Only pdf or ppt files are allowed!!!');",
true);
}
}
else //If the path doesn't contain any file
{
ClientScript.RegisterStartupScript(this.GetType(), "failUpload",
"alert('Please specify the file to upload.!!!');", true);
}
}
}
// GET: AssignCourse/Delete/5
public ActionResult DeleteLectureNote(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LectureNote ln = db.LectureNotes.Find(id);
if (ln == null)
{
return(HttpNotFound());
}
return(View(ln));
}
public ActionResult DeleteLectureNoteConfirmed(int id)
{
LectureNote ln = db.LectureNotes.Find(id);
string fullPath = Server.MapPath("~/App_Data/LectureNotes/" + ln.PdfLectureNote);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
db.LectureNotes.Remove(ln);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <LectureNoteViewModel> CreateAsync(LectureNoteViewModel lectureNote)
{
LectureNote lectureNoteModel = _mapper.Map <LectureNoteViewModel, LectureNote>(lectureNote);
lectureNoteModel.Author = await _unitOfWork.UserManager.FindByNameAsync(lectureNote.AuthorUsername);
lectureNoteModel.AverageRating = 0.0;
lectureNoteModel.DateOfCreate = DateTime.Now;
lectureNoteModel.DateOfLastChange = DateTime.Now;
lectureNoteModel.Specialty = await _specialtyNumberService.CreateSpecialtyNumberAsync(lectureNote.SpecialtyNumber);
lectureNoteModel = _unitOfWork.LectureNotes.Add(lectureNoteModel);
await _unitOfWork.SaveAsync();
return(_mapper.Map <LectureNote, LectureNoteViewModel>(lectureNoteModel));
}
public ActionResult UploadNote(HttpPostedFileBase PdfLectureNote, string CourseId)
{
string path = Server.MapPath("~/App_Data/LectureNotes/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
if (PdfLectureNote.ContentLength >= 6000000)
{
ViewData["CourseId"] = CourseId;
ViewData["FileSize"] = PdfLectureNote.ContentLength / 1000000;
return(View("NewNotes"));
}
var supportedTypes = new[] { "pdf" };
var fileExt = System.IO.Path.GetExtension(PdfLectureNote.FileName).Substring(1);
if (!supportedTypes.Contains(fileExt))
{
ViewData["CourseId"] = CourseId;
ViewData["FileType"] = fileExt;
return(View("NewNotes"));
}
Course course = new Course();
if (PdfLectureNote != null)
{
string fileName = Path.GetFileName(PdfLectureNote.FileName);
PdfLectureNote.SaveAs(path + fileName);
LectureNote ln = new LectureNote();
ln.Id = 0;
ln.LectureDate = DateTime.UtcNow;
ln.PdfLectureNote = fileName;
course = db.Courses.ToList().Where(c => c.Id == int.Parse(CourseId)).First();
ln.Course = course;
if (ModelState.IsValid)
{
db.LectureNotes.Add(ln);
db.SaveChanges();
}
}
return(View("CourseDetails", course));
}
/// <summary>
/// Saves an LectureNote in the database.
/// </summary>
/// <param name="myLectureNote">The LectureNote to store.</param>
/// <returns>The new LectureNote id if the LectureNote is new in the database or the existing ID when an record was updated.</returns>
public static int Save(LectureNote myLectureNote)
{
int result = 0;
using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString))
{
SqlCommand myCommand = new SqlCommand("spInsertUpdateLectureNote", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@courseID", myLectureNote.CourseId);
myCommand.Parameters.AddWithValue("@ltitle", myLectureNote.LTitle);
myCommand.Parameters.AddWithValue("@lfilelocation", myLectureNote.LFileLocation);
DbParameter retValue = myCommand.CreateParameter();
retValue.Direction = ParameterDirection.ReturnValue;
myCommand.Parameters.Add(retValue);
myConnection.Open();
myCommand.ExecuteNonQuery();
result = Convert.ToInt32(retValue.Value);
myConnection.Close();
}
return(result);
}
/// <summary>
/// Gets an instance of LectureNote.
/// </summary>
/// <param name="lectureID">A unique ID of the lecture.</param>
/// <returns>A LectureNote if it matches, otherwise null.</returns>
public static LectureNote GetItem(int lectureID)
{
LectureNote myLectureNote = null;
using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString))
{
SqlCommand myCommand = new SqlCommand("spSelectSingleLectureNote", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@lid", lectureID);
myConnection.Open();
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
if (myDataReader.Read())
{
myLectureNote = FillRecord(myDataReader);
}
myDataReader.Close();
}
myConnection.Close();
}
return(myLectureNote);
}
public ActionResult NewLectureNote(int Id = 0, int SubjectId = 0)
{
if (Id == 0 && SubjectId == 0)
{
return(Redirect("/Admin/Assignments"));
}
if (Id != 0)
{
using (EastWoodEntities db = new EastWoodEntities())
{
var note = db.LectureNotes.Where(w => w.LectureNoteid == Id).FirstOrDefault();
note.Subject = note.Subject;
note.Attachments = db.Attachments.
Where(w => w.AttachmentReferenceId == note.LectureNoteid && w.AttachmentReferenceType == AttachmentReferenceTypes.LECTURE_NOTE)
.ToList();
return(View(note));
}
}
LectureNote sub = new LectureNote();
sub.SubjectId = SubjectId;
return(View(sub));
}
public LectureNoteViewModel GetById(string id)
{
LectureNote lectureNote = _unitOfWork.LectureNotes.Get(id);
return(_mapper.Map <LectureNote, LectureNoteViewModel>(lectureNote));
}
public static int Save(LectureNote myLectureNote)
{
return(LectureNoteDA.Save(myLectureNote));
}
public ActionResult NewLectureNote(LectureNote lectureNote)
{
using (EastWoodEntities db = new EastWoodEntities())
{
// Get all files from Request object
HttpFileCollectionBase files = Request.Files;
List <Attachment> attachments = new List <Attachment>();
// create Item
if (lectureNote.LectureNoteid != 0)
{
var a = db.LectureNotes.Where(w => w.LectureNoteid == lectureNote.LectureNoteid).FirstOrDefault();
a.LectureNoteName = lectureNote.LectureNoteName;
a.LectureNoteDescription = lectureNote.LectureNoteDescription;
a.LectureNoteSubmittedOn = DateTime.Now;
a.LectureNoteDate = lectureNote.LectureNoteDate;
}
else
{
lectureNote.LectureNoteSubmittedOn = DateTime.Now;
db.LectureNotes.Add(lectureNote);
}
db.SaveChanges();
int fileCount = db.Attachments
.Where(w => w.AttachmentReferenceId == lectureNote.LectureNoteid && w.AttachmentReferenceType == AttachmentReferenceTypes.LECTURE_NOTE)
.Count();
if (Request.Files.Count > 0)
{
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
string fname;
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
string[] find = fname.Split('.');
string extention = find[find.Length - 1];
fname = lectureNote.LectureNoteName + "_" + (i + fileCount) + "." + extention;
// Get the complete folder path and store the file inside it.
var finalName = Path.Combine(Server.MapPath("~/Uploads/"), fname);
file.SaveAs(finalName);
// Create attachment
Attachment attachment = new Attachment();
attachment.AttachmentName = fname;
attachment.AttachmentUrl = "/Uploads/" + fname;
attachment.AttachmentReferenceType = AttachmentReferenceTypes.LECTURE_NOTE;
attachment.AttachmentReferenceId = lectureNote.LectureNoteid;
attachment.AttachmentFileSize = file.ContentLength;
db.Attachments.Add(attachment);
db.SaveChanges();
}
}
}
return(Redirect("/Admin/LectureNotes/" + lectureNote.SubjectId));
}
