public ActionResult Edit([Bind(Include = "Id,TopicNo,TopicName,StartDate,EndDate,ChapterID,Status")] AspNetTopic aspNetTopic)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTopic).State = EntityState.Modified;
db.SaveChanges();
var status = db.AspNetTopics.Where(x => x.ChapterID == aspNetTopic.ChapterID).Select(x => x.Status).ToList();
bool completed = true;
foreach (var item in status)
{
if (item == false)
{
completed = false;
break;
}
}
AspNetChapter aspNetChapter = db.AspNetChapters.Where(x => x.Id == aspNetTopic.ChapterID).FirstOrDefault();
if (completed)
{
aspNetChapter.Status = true;
db.SaveChanges();
}
else
{
aspNetChapter.Status = false;
db.SaveChanges();
}
return(RedirectToAction("Dashboard", "Account"));
}
ViewBag.ChapterID = new SelectList(db.AspNetChapters, "Id", "ChapterName", aspNetTopic.ChapterID);
return(View(aspNetTopic));
}
public ActionResult Create(AspNetTopic aspNetTopic)
{
var dbTransaction = db.Database.BeginTransaction();
try
{
IEnumerable <string> topics = Request.Form["DynamicTextBox"].Split(',');
if (ModelState.IsValid)
{
foreach (var item in topics)
{
AspNetTopic aspnettopic = new AspNetTopic();
aspnettopic.SubjectID = aspNetTopic.SubjectID;
aspnettopic.TopicName = item;
db.AspNetTopics.Add(aspnettopic);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
dbTransaction.Commit();
}
catch (Exception) { dbTransaction.Dispose(); }
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTopic.SubjectID);
return(View(aspNetTopic));
}
public ActionResult DeleteConfirmed(int id)
{
AspNetTopic aspNetTopic = db.AspNetTopics.Find(id);
db.AspNetTopics.Remove(aspNetTopic);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,TopicName,SubjectID")] AspNetTopic aspNetTopic)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTopic).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTopic.SubjectID);
return(View(aspNetTopic));
}
// GET: AspNetTopic/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetTopic aspNetTopic = db.AspNetTopics.Find(id);
if (aspNetTopic == null)
{
return(HttpNotFound());
}
return(View(aspNetTopic));
}
// GET: AspNetTopic/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetTopic aspNetTopic = db.AspNetTopics.Find(id);
if (aspNetTopic == null)
{
return(HttpNotFound());
}
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTopic.SubjectID);
return(View(aspNetTopic));
}
public JsonResult Topic_status(int id)
{
AspNetTopic TopicStatus = db.AspNetTopics.Where(x => x.Id == id).Select(x => x).FirstOrDefault();
if (TopicStatus.Status == false)
{
TopicStatus.Status = true;
}
else if (TopicStatus.Status == true)
{
TopicStatus.Status = false;
}
db.SaveChanges();
return(Json(TopicStatus.Status, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "Id,TopicNo,TopicName,StartDate,EndDate,ChapterID,Status")] AspNetTopic aspNetTopic)
{
var dbTransaction = db.Database.BeginTransaction();
try
{
if (ModelState.IsValid)
{
db.AspNetTopics.Add(aspNetTopic);
db.SaveChanges();
}
dbTransaction.Commit();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var logMessage = "New Topic Added, SubjectID: " + aspNetTopic.ChapterID + ", Topic: " + aspNetTopic.TopicName;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
ViewBag.CreateTopic = "Topic created and updated successfully";
ViewBag.ClassID = new SelectList(db.AspNetSubjects.Where(x => x.TeacherID == TeacherID).Select(x => x.AspNetClass).Distinct(), "Id", "ClassName");
return(View("../Teacher_Dashboard/_Topics"));
}
catch (Exception)
{
dbTransaction.Dispose();
ViewBag.ChapterID = new SelectList(db.AspNetChapters.Where(x => x.AspNetSubject.AspNetClass.SessionID == SessionID), "Id", "ChapterName", aspNetTopic.ChapterID);
return(View(aspNetTopic));
}
ViewBag.ChapterID = new SelectList(db.AspNetChapters.Where(x => x.AspNetSubject.AspNetClass.SessionID == SessionID), "Id", "ChapterName", aspNetTopic.ChapterID);
return(View(aspNetTopic));
}
public ActionResult CurriculumFromFile()
{
HttpPostedFileBase file = Request.Files["curriculum"];
int SubjectID = Convert.ToInt32(Request.Form["SubjectID"]);
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
}
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 1; rowIterator <= noOfRow; rowIterator++)
{
var heading = workSheet.Cells[rowIterator, 1].Value.ToString();
if (heading == "Chapter")
{
rowIterator++;
AspNetChapter aspNetChapter = new AspNetChapter();
aspNetChapter.SubjectID = SubjectID;
aspNetChapter.ChapterNo = Convert.ToInt32(workSheet.Cells[rowIterator, 1].Value.ToString());
aspNetChapter.ChapterName = workSheet.Cells[rowIterator, 2].Value.ToString();
aspNetChapter.StartDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 3].Value.ToString());
aspNetChapter.EndDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString());
aspNetChapter.Status = Convert.ToBoolean(Convert.ToInt32(workSheet.Cells[rowIterator, 5].Value.ToString()));
db.AspNetChapters.Add(aspNetChapter);
db.SaveChanges();
}
else if (heading == "Topic")
{
int ChapterID = db.AspNetChapters.Max(item => item.Id);
rowIterator++;
AspNetTopic aspNetTopic = new AspNetTopic();
aspNetTopic.ChapterID = ChapterID;
aspNetTopic.TopicNo = Convert.ToDouble(workSheet.Cells[rowIterator, 1].Value.ToString());
aspNetTopic.TopicName = workSheet.Cells[rowIterator, 2].Value.ToString();
aspNetTopic.StartDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 3].Value.ToString());
aspNetTopic.EndDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString());
aspNetTopic.Status = Convert.ToBoolean(Convert.ToInt32(workSheet.Cells[rowIterator, 5].Value.ToString()));
db.AspNetTopics.Add(aspNetTopic);
db.SaveChanges();
}
else
{
int ChapterID = db.AspNetChapters.Max(item => item.Id);
AspNetTopic aspNetTopic = new AspNetTopic();
aspNetTopic.ChapterID = ChapterID;
aspNetTopic.TopicNo = Convert.ToDouble(workSheet.Cells[rowIterator, 1].Value.ToString());
aspNetTopic.TopicName = workSheet.Cells[rowIterator, 2].Value.ToString();
aspNetTopic.StartDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 3].Value.ToString());
aspNetTopic.EndDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString());
aspNetTopic.Status = Convert.ToBoolean(Convert.ToInt32(workSheet.Cells[rowIterator, 5].Value.ToString()));
db.AspNetTopics.Add(aspNetTopic);
db.SaveChanges();
}
}
}
return(RedirectToAction("Dashboard", "Teacher_Dashboard"));
}
