public ActionResult Edit([Bind(Include = "SignIn,SignOut,session_sessionID,student_StudentID")] studentsession studentsession)
{
if (ModelState.IsValid)
{
db.Entry(studentsession).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.session_sessionID = new SelectList(db.sessions, "sessionID", "Date", studentsession.session_sessionID);
ViewBag.student_StudentID = new SelectList(db.students, "StudentID", "GivenName", studentsession.student_StudentID);
return(View(studentsession));
}
public ActionResult Create(string code)
{
if (ModelState.IsValid)
{
string studentID = "100100100";
session result = null;
bool check = false;
studentsession old = null;
DateTime now = DateTime.Now;
foreach (var item in db.sessions)
{
if (item.Code.Equals(code))
{
result = item;
}
}
foreach (var ss in db.studentsessions)
{
if (ss.student_StudentID.Equals(studentID) && ss.session_sessionID.Equals(result.sessionID))
{
check = true;
old = ss;
}
}
if (check)
{
if (old.SignOut.Equals(null))
{
old.SignOut = now.TimeOfDay;
db.Entry(old).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
studentsession record = new studentsession(studentID, result.sessionID, signIn: now.TimeOfDay);
db.studentsessions.Add(record);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View());
}
// GET: Teacher/Edit/5
public ActionResult Edit(int?session_sessionID, string student_StudentID)
{
if (student_StudentID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
studentsession studentsession = db.studentsessions.Find(session_sessionID, student_StudentID);
if (studentsession == null)
{
return(HttpNotFound());
}
ViewBag.session_sessionID = new SelectList(db.sessions, "sessionID", "Date", studentsession.session_sessionID);
ViewBag.student_StudentID = new SelectList(db.students, "StudentID", "GivenName", studentsession.student_StudentID);
return(View(studentsession));
}
// GET: Teacher/Details/5
public ActionResult Details(int?session_sessionID, string student_StudentID)
{
if (student_StudentID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
studentsession studentsession = db.studentsessions.Find(session_sessionID, student_StudentID);
if (studentsession == null)
{
return(HttpNotFound());
}
//studentsession data = db.studentsessions.Find(session_sessionID,student_StudentID);
//if (data == null)
//{
// return HttpNotFound();
//}
//var groupedData = db.studentsessions.Where(s => s.student_StudentID == data.student_StudentID).ToList();
//return View(groupedData);
//String connectionString = "Data Source=LAPTOP-I9V7HD8J\SQLEXPRESS01;Initial Catalog=TafeDB;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework";
//String sql = "SELECT * FROM students";
//System.Data.SqlClient.SqlCommand cmd = new SqlCommand(sql, connectionString);
//using (System.Data.SqlClient.SqlConnection connectionString = new System.Data.SqlClient.SqlConnection(connectionString))
//{
// connectionString.Open();
// System.Data.SqlClient.SqlDataReader rdr = cmd.ExecuteReader();
//}
//ViewData.Add("students", rdr);
// String sql = "SELECT * FROM studentssession";
//ViewBag.session_sessionID = new SelectList(db.sessions, "sessionID", "Date");
//ViewBag.student_StudentID = new SelectList(db.students, "StudentID", "GivenName");
//return View();
ViewBag.Message = student_StudentID;
var studentsessions = db.studentsessions.Include(s => s.session).Include(s => s.student);
return(View(studentsessions));
}
