// GET: AspNetTimeTable/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetTimeTable aspNetTimeTable = db.AspNetTimeTables.Find(id);
if (aspNetTimeTable == null)
{
return(HttpNotFound());
}
ViewBag.RoomID = new SelectList(db.AspNetRooms, "Id", "Name", aspNetTimeTable.RoomID);
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTimeTable.SubjectID);
ViewBag.SlotID = new SelectList(db.AspNetTimeslots, "Id", "Name", aspNetTimeTable.SlotID);
DateTime Date = Convert.ToDateTime(aspNetTimeTable.Day);
string date = Date.ToString("yyyy-MM-dd");
ViewBag.Date = date;
var AllRoles = db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher"));
ViewBag.Teacher_ID = new SelectList(AllRoles, "Id", "Name", aspNetTimeTable.Teacher_ID);
return(View(aspNetTimeTable));
}
public ActionResult DeleteConfirmed(int id)
{
AspNetTimeTable aspNetTimeTable = db.AspNetTimeTables.Find(id);
db.AspNetTimeTables.Remove(aspNetTimeTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
//var AllEventsToDelete = db.Events.Where(x => x.TimeTableId == id).ToList();
// db.Events.RemoveRange(AllEventsToDelete);
//db.SaveChanges();
AspNetTimeTable aspNetTimeTable = db.AspNetTimeTables.Find(id);
db.AspNetTimeTables.Remove(aspNetTimeTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,RoomID,SlotID,SubjectID,TeacherID,Timestamp,Day")] AspNetTimeTable aspNetTimeTable)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTimeTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RoomID = new SelectList(db.AspNetRooms, "Id", "Name", aspNetTimeTable.RoomID);
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTimeTable.SubjectID);
ViewBag.SlotID = new SelectList(db.AspNetTimeslots, "Id", "Name", aspNetTimeTable.SlotID);
return(View(aspNetTimeTable));
}
public ActionResult Edit([Bind(Include = "Id,RoomID,SlotID,SubjectID,Teacher_ID,Day")] AspNetTimeTable aspNetTimeTable)
{
if (ModelState.IsValid)
{
aspNetTimeTable.IsPopulated = true;
db.Entry(aspNetTimeTable).State = EntityState.Modified;
db.SaveChanges();
}
var EventsToDelete = db.Events.Where(x => x.TimeTableId == aspNetTimeTable.Id);
db.Events.RemoveRange(EventsToDelete);
db.SaveChanges();
var subjectID = aspNetTimeTable.SubjectID;
var students = db.AspNetStudent_Subject.Where(x => x.SubjectID == subjectID).Select(x => x.StudentID).ToList();
string[] color = { "Red", "Blue", "Green", "Pink", "Orange" };
var TimeTable = db.AspNetTimeTables.Where(x => x.Id == aspNetTimeTable.Id).Include(x => x.AspNetRoom).Include(x => x.AspNetTimeslot).Include(x => x.AspNetSubject).Include(x => x.AspNetUser);
foreach (var items in students)
{
Random random = new Random();
int colorcode = random.Next(1, 5);
var newEvent = new Event();
newEvent.UserId = items;
newEvent.IsFullDay = false;
newEvent.IsPublic = false;
newEvent.Subject = TimeTable.Select(x => x.AspNetRoom.Name).FirstOrDefault() + "_" + TimeTable.Select(x => x.AspNetSubject.SubjectName).FirstOrDefault();
newEvent.SessionID = db.AspNetSessions.Where(x => x.Status == "Active").FirstOrDefault().Id;
newEvent.ThemeColor = color[colorcode];
DateTime?TimeSlotStartDateTime = TimeTable.Select(x => x.AspNetTimeslot.Start_Time).FirstOrDefault();
var starttime = TimeSlotStartDateTime.Value.ToString("hh:mm");
DateTime?TimeSlotEndDateTime = TimeTable.Select(x => x.AspNetTimeslot.End_Time).FirstOrDefault();
var Endtime = TimeSlotEndDateTime.Value.ToString("hh:mm");
var day = aspNetTimeTable.Day.Split(' ');
newEvent.Start = Convert.ToDateTime(day[0] + " " + starttime);
newEvent.End = Convert.ToDateTime(day[0] + " " + Endtime);
// newEvent.TimeTableId = aspNetTimeTable.Id;
db.Events.Add(newEvent);
}
db.SaveChanges();
//ViewBag.RoomID = new SelectList(db.AspNetRooms, "Id", "Name", aspNetTimeTable.RoomID);
//ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTimeTable.SubjectID);
//ViewBag.SlotID = new SelectList(db.AspNetTimeslots, "Id", "Name", aspNetTimeTable.SlotID);
return(RedirectToAction("Index"));
}
// GET: AspNetTimeTable/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetTimeTable aspNetTimeTable = db.AspNetTimeTables.Find(id);
if (aspNetTimeTable == null)
{
return(HttpNotFound());
}
return(View(aspNetTimeTable));
}
// GET: AspNetTimeTable/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetTimeTable aspNetTimeTable = db.AspNetTimeTables.Find(id);
if (aspNetTimeTable == null)
{
return(HttpNotFound());
}
ViewBag.RoomID = new SelectList(db.AspNetRooms, "Id", "Name", aspNetTimeTable.RoomID);
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTimeTable.SubjectID);
ViewBag.SlotID = new SelectList(db.AspNetTimeslots, "Id", "Name", aspNetTimeTable.SlotID);
return(View(aspNetTimeTable));
}
public ActionResult CreateTimetable()
{
var timelist = db.AspNetTimeTables.Where(x => x.IsPopulated == false).ToList();
foreach (var item in timelist)
{
var subjectID = item.SubjectID;
var students = db.AspNetStudent_Subject.Where(x => x.SubjectID == subjectID).Select(x => x.StudentID).ToList();
string[] color = { "Red", "Blue", "Green", "Yellow", "Orange", "Purple", "Aqua" };
foreach (var items in students)
{
Random random = new Random();
int colorcode = random.Next(1, 5);
var newEvent = new Event();
newEvent.UserId = items;
newEvent.IsFullDay = false;
newEvent.IsPublic = false;
newEvent.Subject = item.AspNetSubject.SubjectName + " (" + item.Description + ")";
newEvent.Description = "The Lecture of Subject '" + item.AspNetSubject.SubjectName + "(" + item.Description + ")" + "' will start on " + ((DateTime)item.AspNetTimeslot.Start_Time).ToString("hh:mm");
newEvent.SessionID = db.AspNetUsers_Session.Where(x => x.UserID == items).Select(x => x.SessionID).FirstOrDefault();
newEvent.ThemeColor = color[colorcode];
var starttime = ((DateTime)item.AspNetTimeslot.Start_Time).ToString("hh:mm");
var Endtime = ((DateTime)item.AspNetTimeslot.End_Time).ToString("hh:mm");
var day = item.Day.Split(' ');
newEvent.Start = Convert.ToDateTime(day[0] + " " + starttime);
newEvent.End = Convert.ToDateTime(day[0] + " " + Endtime);
newEvent.TimeTableId = item.Id;
db.Events.Add(newEvent);
}
}
foreach (var item in timelist)
{
AspNetTimeTable aspNetTimeTable = db.AspNetTimeTables.Find(item.Id);
aspNetTimeTable.IsPopulated = true;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult TimeTableFromFile()
{
var dbTransaction = db.Database.BeginTransaction();
HttpPostedFileBase file = Request.Files["subjects"];
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));
}
var studentList = new List <RegisterViewModel>();
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;
string ErrorMsg = null;
int rowIterator;
for (rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var TimeTable = new AspNetTimeTable();
var SessionName = workSheet.Cells[rowIterator, 6].Value.ToString();
int GetSessionID;
int GetClassID;
AspNetSession Session = db.AspNetSessions.Where(x => x.SessionName == SessionName).FirstOrDefault();
if (Session == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Session Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
GetSessionID = Session.Id;
GetClassID = db.AspNetClasses.Where(x => x.SessionID == GetSessionID).Select(x => x.Id).FirstOrDefault();
}
var CourseType = workSheet.Cells[rowIterator, 5].Value.ToString();
var CourseTypeLower = CourseType.ToLower();
if (CourseTypeLower == "css" || CourseTypeLower == "pms")
{
//valid course Type css or pms
}
else
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + "Course Type is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
var RoomName = workSheet.Cells[rowIterator, 1].Value.ToString();
//RoomID;
int RoomID = db.AspNetRooms.Where(x => x.Name == RoomName).FirstOrDefault().Id;
AspNetRoom room = new AspNetRoom();
room = db.AspNetRooms.Where(x => x.Name == RoomName).FirstOrDefault();
if (room == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + "Room Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
RoomID = room.Id;
}
var SlotName = workSheet.Cells[rowIterator, 2].Value.ToString();
//var SlotID = db.AspNetTimeslots.Where(x => x.Name == SlotName).FirstOrDefault().Id;
int SlotID = db.AspNetTimeslots.Where(x => x.Name == SlotName).FirstOrDefault().Id;
AspNetTimeslot slot = new AspNetTimeslot();
slot = db.AspNetTimeslots.Where(x => x.Name == SlotName).FirstOrDefault();
if (slot == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Slot Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
SlotID = slot.Id;
}
string SubName = workSheet.Cells[rowIterator, 3].Value.ToString();
int SubjectID;
AspNetSubject subject = new AspNetSubject();
subject = db.AspNetSubjects.Where(x => x.SubjectName == SubName && x.ClassID == GetClassID && x.CourseType == CourseType).FirstOrDefault();
if (subject == null)
{
ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Subject Name is not valid or empty";
TempData["ErrorMsg"] = ErrorMsg;
return(RedirectToAction("Create", "AspNetTimeTable"));
}
else
{
SubjectID = subject.Id;
}
//var UserName = workSheet.Cells[rowIterator, 4].Value.ToString();
//string TeacherID;
//AspNetUser teacher = new AspNetUser();
//teacher = db.AspNetUsers.Where(x => x.UserName == UserName).FirstOrDefault();
//if (teacher == null)
//{
// ErrorMsg = "Error in Row " + Convert.ToString(rowIterator - 1) + " Teacher Name is not valid or empty";
// TempData["ErrorMsg"] = ErrorMsg;
// return RedirectToAction("Create", "AspNetTimeTable");
//}
//else
//{
// TeacherID = teacher.Id;
//}
DateTime Day = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString());
var Description = (workSheet.Cells[rowIterator, 7].Value.ToString());
//var Date = workSheet.Cells[rowIterator, 5].Value.ToString();
//DateTime Day = DateTime.ParseExact(Date, "dd/MM/yyyy", null);
TimeTable.RoomID = RoomID;
TimeTable.SlotID = SlotID;
TimeTable.SubjectID = SubjectID;
TimeTable.Description = Description;
//TimeTable.Teacher_ID = TeacherID;
TimeTable.Day = Day.ToString();
TimeTable.IsPopulated = false;
// TimeTable.SessionID = GetSessionID;
db.AspNetTimeTables.Add(TimeTable);
db.SaveChanges();
}
}
dbTransaction.Commit();
// return RedirectToAction("Index", "AspNetTimeTable");
//catch (Exception e)
//{
// dbTransaction.Dispose();
//}
return(RedirectToAction("CreateTimetable"));
}