public ActionResult DeleteConfirmed(int id)
{
AspnetStudentLink aspnetStudentLink = db.AspnetStudentLinks.Find(id);
db.AspnetStudentLinks.Remove(aspnetStudentLink);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name,URL,LessonId,CreationDate")] AspnetStudentLink aspnetStudentLink)
{
if (ModelState.IsValid)
{
db.Entry(aspnetStudentLink).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LessonId = new SelectList(db.AspnetLessons, "Id", "Name", aspnetStudentLink.LessonId);
return(View(aspnetStudentLink));
}
// GET: AspnetStudentLinks/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspnetStudentLink aspnetStudentLink = db.AspnetStudentLinks.Find(id);
if (aspnetStudentLink == null)
{
return(HttpNotFound());
}
return(View(aspnetStudentLink));
}
// GET: AspnetStudentLinks/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspnetStudentLink aspnetStudentLink = db.AspnetStudentLinks.Find(id);
if (aspnetStudentLink == null)
{
return(HttpNotFound());
}
ViewBag.LessonId = new SelectList(db.AspnetLessons, "Id", "Name", aspnetStudentLink.LessonId);
return(View(aspnetStudentLink));
}
public ActionResult Create(LessonViewModel LessonViewModel)
{
AspnetLesson Lesson = new AspnetLesson();
Lesson.Name = LessonViewModel.LessonName;
Lesson.Video_Url = LessonViewModel.LessonVideoURL;
Lesson.TopicId = LessonViewModel.TopicId;
Lesson.DurationMinutes = LessonViewModel.LessonDuration;
Lesson.StartTime = LessonViewModel.StartTime;
Lesson.EndTime = LessonViewModel.EndTime;
Lesson.AddLink = LessonViewModel.AddLink;
Lesson.CreationDate = LessonViewModel.CreationDate;
Lesson.Description = LessonViewModel.LessonDescription;
Lesson.CreationDate = DateTime.Now;
db.AspnetLessons.Add(Lesson);
db.SaveChanges();
HttpPostedFileBase Assignment = Request.Files["Assignment"];
HttpPostedFileBase Attachment1 = Request.Files["Attachment1"];
HttpPostedFileBase Attachment2 = Request.Files["Attachment2"];
HttpPostedFileBase Attachment3 = Request.Files["Attachment3"];
if (Assignment.ContentLength > 0)
{
var fileName = Path.GetFileName(Assignment.FileName);
Assignment.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName);
AspnetStudentAssignment studentAssignment = new AspnetStudentAssignment();
studentAssignment.FileName = fileName;
studentAssignment.Name = LessonViewModel.AssignmentName;
string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate);
if (DueDate == "1/1/0001 12:00:00 AM")
{
studentAssignment.DueDate = null;
}
else
{
studentAssignment.DueDate = LessonViewModel.AssignmentDueDate;
}
studentAssignment.Description = LessonViewModel.AssignmentDescription;
studentAssignment.CreationDate = DateTime.Now;
studentAssignment.LessonId = Lesson.Id;
db.AspnetStudentAssignments.Add(studentAssignment);
db.SaveChanges();
}
if (Attachment1.ContentLength > 0)
{
var fileName = Path.GetFileName(Attachment1.FileName);
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName);
AspnetStudentAttachment studentAttachment1 = new AspnetStudentAttachment();
studentAttachment1.Name = LessonViewModel.AttachmentName1;
studentAttachment1.Path = fileName;
studentAttachment1.CreationDate = DateTime.Now;
studentAttachment1.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment1);
db.SaveChanges();
}
if (Attachment2.ContentLength > 0)
{
var fileName = Path.GetFileName(Attachment2.FileName);
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName);
AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment();
studentAttachment2.Name = LessonViewModel.AttachmentName2;
studentAttachment2.Path = fileName;
studentAttachment2.CreationDate = DateTime.Now;
studentAttachment2.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment2);
db.SaveChanges();
}
if (Attachment3.ContentLength > 0)
{
var fileName = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl1 != null)
{
AspnetStudentLink link1 = new AspnetStudentLink();
link1.URL = LessonViewModel.LinkUrl1;
link1.CreationDate = DateTime.Now;
link1.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link1);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl2 != null)
{
AspnetStudentLink link2 = new AspnetStudentLink();
link2.URL = LessonViewModel.LinkUrl2;
link2.CreationDate = DateTime.Now;
link2.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link2);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl3 != null)
{
AspnetStudentLink link3 = new AspnetStudentLink();
link3.URL = LessonViewModel.LinkUrl3;
link3.CreationDate = DateTime.Now;
link3.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link3);
db.SaveChanges();
}
return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics"));
}
public ActionResult Edit(LessonViewModel LessonViewModel)
{
AspnetLesson Lesson = db.AspnetLessons.Where(x => x.Id == LessonViewModel.Id).FirstOrDefault();
Lesson.Name = LessonViewModel.LessonName;
Lesson.Video_Url = LessonViewModel.LessonVideoURL;
Lesson.TopicId = LessonViewModel.TopicId;
Lesson.DurationMinutes = LessonViewModel.LessonDuration;
Lesson.Description = LessonViewModel.LessonDescription;
db.SaveChanges();
HttpPostedFileBase Assignment = Request.Files["Assignment"];
HttpPostedFileBase Attachment1 = Request.Files["Attachment1"];
HttpPostedFileBase Attachment2 = Request.Files["Attachment2"];
HttpPostedFileBase Attachment3 = Request.Files["Attachment3"];
var fileName = "";
if (Assignment.ContentLength > 0)
{
fileName = Path.GetFileName(Assignment.FileName);
Assignment.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName);
}
AspnetStudentAssignment studentAssignment = db.AspnetStudentAssignments.Where(x => x.LessonId == Lesson.Id).FirstOrDefault();
if (studentAssignment != null)
{
if (fileName != "")
{
studentAssignment.FileName = fileName;
}
studentAssignment.Name = LessonViewModel.AssignmentName;
string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate);
if (DueDate == "1/1/0001 12:00:00 AM")
{
studentAssignment.DueDate = null;
}
else
{
studentAssignment.DueDate = LessonViewModel.AssignmentDueDate;
}
studentAssignment.Description = LessonViewModel.AssignmentDescription;
db.SaveChanges();
}
else
{
if (Assignment.ContentLength > 0)
{
AspnetStudentAssignment studentAssignment1 = new AspnetStudentAssignment();
studentAssignment1.FileName = fileName;
studentAssignment1.Name = LessonViewModel.AssignmentName;
string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate);
if (DueDate == "1/1/0001 12:00:00 AM")
{
studentAssignment1.DueDate = null;
}
else
{
studentAssignment1.DueDate = LessonViewModel.AssignmentDueDate;
}
studentAssignment1.Description = LessonViewModel.AssignmentDescription;
studentAssignment1.CreationDate = DateTime.Now;
studentAssignment1.LessonId = Lesson.Id;
db.AspnetStudentAssignments.Add(studentAssignment1);
db.SaveChanges();
}
}
List <AspnetStudentAttachment> studentAttachments = db.AspnetStudentAttachments.Where(x => x.LessonId == Lesson.Id).ToList();
List <AspnetStudentLink> studentLinks = db.AspnetStudentLinks.Where(x => x.LessonId == Lesson.Id).ToList();
//db.AspnetStudentAttachments.RemoveRange(studentAttachments);
//db.SaveChanges();
db.AspnetStudentLinks.RemoveRange(studentLinks);
db.SaveChanges();
SEA_DatabaseEntities db1 = new SEA_DatabaseEntities();
List <AspnetStudentAttachment> studentAttachments1 = db1.AspnetStudentAttachments.Where(x => x.LessonId == Lesson.Id).ToList();
int TotalAttachments = studentAttachments1.Count;
if (TotalAttachments == 0)
{
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment1 = new AspnetStudentAttachment();
studentAttachment1.Name = LessonViewModel.AttachmentName1;
studentAttachment1.Path = fileName1;
studentAttachment1.CreationDate = DateTime.Now;
studentAttachment1.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment1);
db.SaveChanges();
}
if (Attachment2.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment2.FileName);
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment();
studentAttachment2.Name = LessonViewModel.AttachmentName2;
studentAttachment2.Path = fileName1;
studentAttachment2.CreationDate = DateTime.Now;
studentAttachment2.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment2);
db.SaveChanges();
}
if (Attachment3.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName1;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
}
else
{
if (TotalAttachments == 1)
{
var FirstElement = studentAttachments1.ElementAt(0);
FirstElement.Name = LessonViewModel.AttachmentName1;
var FileName = FirstElement.Path;
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
FileName = fileName1;
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
}
FirstElement.Path = FileName;
db1.SaveChanges();
if (Attachment2.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment2.FileName);
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment();
studentAttachment2.Name = LessonViewModel.AttachmentName2;
studentAttachment2.Path = fileName1;
studentAttachment2.CreationDate = DateTime.Now;
studentAttachment2.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment2);
db.SaveChanges();
}
if (Attachment3.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName1;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
}
else if (TotalAttachments == 2)
{
var FirstElement = studentAttachments1.ElementAt(0);
FirstElement.Name = LessonViewModel.AttachmentName1;
var FileName0 = FirstElement.Path;
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
FileName0 = fileName1;
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
}
FirstElement.Path = FileName0;
db1.SaveChanges();
var SecondElement = studentAttachments1.ElementAt(1);
SecondElement.Name = LessonViewModel.AttachmentName2;
var FileName1 = SecondElement.Path;
if (Attachment2.ContentLength > 0)
{
var fileName2 = Path.GetFileName(Attachment2.FileName);
FileName1 = fileName2;
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName2);
}
SecondElement.Path = FileName1;
db1.SaveChanges();
if (Attachment3.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName1;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
}
else
{
var FirstElement = studentAttachments1.ElementAt(0);
FirstElement.Name = LessonViewModel.AttachmentName1;
var FileName0 = FirstElement.Path;
if (Attachment1.ContentLength > 0)
{
var fileName1 = Path.GetFileName(Attachment1.FileName);
FileName0 = fileName1;
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1);
}
FirstElement.Path = FileName0;
db1.SaveChanges();
var SecondElement = studentAttachments1.ElementAt(1);
SecondElement.Name = LessonViewModel.AttachmentName2;
var FileName1 = SecondElement.Path;
if (Attachment2.ContentLength > 0)
{
var fileName2 = Path.GetFileName(Attachment2.FileName);
FileName1 = fileName2;
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName2);
}
SecondElement.Path = FileName1;
db1.SaveChanges();
var ThirdElement = studentAttachments1.ElementAt(2);
ThirdElement.Name = LessonViewModel.AttachmentName3;
var FileName2 = ThirdElement.Path;
if (Attachment3.ContentLength > 0)
{
var fileName3 = Path.GetFileName(Attachment3.FileName);
FileName2 = fileName3;
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName3);
}
ThirdElement.Path = FileName2;
db1.SaveChanges();
}
}
if (LessonViewModel.LinkUrl1 != null)
{
AspnetStudentLink link1 = new AspnetStudentLink();
link1.URL = LessonViewModel.LinkUrl1;
link1.CreationDate = DateTime.Now;
link1.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link1);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl2 != null)
{
AspnetStudentLink link2 = new AspnetStudentLink();
link2.URL = LessonViewModel.LinkUrl2;
link2.CreationDate = DateTime.Now;
link2.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link2);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl3 != null)
{
AspnetStudentLink link3 = new AspnetStudentLink();
link3.URL = LessonViewModel.LinkUrl3;
link3.CreationDate = DateTime.Now;
link3.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link3);
db.SaveChanges();
}
return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics"));
}
public ActionResult Create(LessonViewModel LessonViewModel)
{
AspnetLesson Lesson = new AspnetLesson();
Lesson.Name = LessonViewModel.LessonName;
Lesson.Video_Url = LessonViewModel.LessonVideoURL;
Lesson.TopicId = LessonViewModel.TopicId;
Lesson.DurationMinutes = LessonViewModel.LessonDuration;
Lesson.IsActive = LessonViewModel.IsActive;
Lesson.CreationDate = LessonViewModel.CreationDate;
Lesson.Description = LessonViewModel.LessonDescription;
Lesson.OrderBy = LessonViewModel.OrderBy;
Lesson.CreationDate = DateTime.Now;
string EncrID = Lesson.Name + Lesson.Description + Lesson.Id;
Lesson.EncryptedID = Encrpt.Encrypt(EncrID, true);
var newString = Regex.Replace(Lesson.EncryptedID, @"[^0-9a-zA-Z]+", "s");
// Lesson.EncryptedID.Replace('/', 's').Replace('-','s').Replace('+','s').Replace('%','s').Replace('&','s');
Lesson.EncryptedID = newString;
db.AspnetLessons.Add(Lesson);
db.SaveChanges();
//Lesson_Session lessonSession = new Lesson_Session();
//lessonSession.LessonId = Lesson.Id;
//lessonSession.SessionId = LessonViewModel.SessionId;
//lessonSession.StartDate = LessonViewModel.StartDate;
//lessonSession.DueDate = LessonViewModel.DueDate;
//db.Lesson_Session.Add(lessonSession);
//db.SaveChanges();
HttpPostedFileBase Assignment = Request.Files["Assignment"];
HttpPostedFileBase Attachment1 = Request.Files["Attachment1"];
HttpPostedFileBase Attachment2 = Request.Files["Attachment2"];
HttpPostedFileBase Attachment3 = Request.Files["Attachment3"];
if (Assignment.ContentLength > 0)
{
var fileName = Path.GetFileName(Assignment.FileName);
Assignment.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName);
AspnetStudentAssignment studentAssignment = new AspnetStudentAssignment();
studentAssignment.FileName = fileName;
studentAssignment.Name = LessonViewModel.AssignmentName;
string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate);
if (DueDate == "1/1/0001 12:00:00 AM")
{
studentAssignment.DueDate = null;
}
else
{
studentAssignment.DueDate = LessonViewModel.AssignmentDueDate;
}
studentAssignment.Description = LessonViewModel.AssignmentDescription;
studentAssignment.CreationDate = DateTime.Now;
studentAssignment.LessonId = Lesson.Id;
db.AspnetStudentAssignments.Add(studentAssignment);
db.SaveChanges();
}
if (Attachment1.ContentLength > 0)
{
var fileName = Path.GetFileName(Attachment1.FileName);
Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName);
AspnetStudentAttachment studentAttachment1 = new AspnetStudentAttachment();
studentAttachment1.Name = LessonViewModel.AttachmentName1;
studentAttachment1.Path = fileName;
studentAttachment1.CreationDate = DateTime.Now;
studentAttachment1.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment1);
db.SaveChanges();
}
if (Attachment2.ContentLength > 0)
{
var fileName = Path.GetFileName(Attachment2.FileName);
Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName);
AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment();
studentAttachment2.Name = LessonViewModel.AttachmentName2;
studentAttachment2.Path = fileName;
studentAttachment2.CreationDate = DateTime.Now;
studentAttachment2.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment2);
db.SaveChanges();
}
if (Attachment3.ContentLength > 0)
{
var fileName = Path.GetFileName(Attachment3.FileName);
Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName);
AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment();
studentAttachment3.Name = LessonViewModel.AttachmentName3;
studentAttachment3.Path = fileName;
studentAttachment3.CreationDate = DateTime.Now;
studentAttachment3.LessonId = Lesson.Id;
db.AspnetStudentAttachments.Add(studentAttachment3);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl1 != null)
{
AspnetStudentLink link1 = new AspnetStudentLink();
link1.URL = LessonViewModel.LinkUrl1;
link1.CreationDate = DateTime.Now;
link1.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link1);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl2 != null)
{
AspnetStudentLink link2 = new AspnetStudentLink();
link2.URL = LessonViewModel.LinkUrl2;
link2.CreationDate = DateTime.Now;
link2.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link2);
db.SaveChanges();
}
if (LessonViewModel.LinkUrl3 != null)
{
AspnetStudentLink link3 = new AspnetStudentLink();
link3.URL = LessonViewModel.LinkUrl3;
link3.CreationDate = DateTime.Now;
link3.LessonId = Lesson.Id;
db.AspnetStudentLinks.Add(link3);
db.SaveChanges();
}
return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics"));
}
