// GET: AttendanceMarking/Createz
public ActionResult AttendanceSheet()
{
ViewBag.ClassId = TempData["Classid"];
int classid = ViewBag.ClassId;
DateTime date = Convert.ToDateTime(TempData["date"]);
int attendancestatus = (from x in db.options where x.Options == "Present" select x.Id).FirstOrDefault();
string classname = (from x in db.classes where x.Id == classid select x.ClassName).FirstOrDefault();
AttendanceRecordsdata attendance = new AttendanceRecordsdata();
List <int> attendanceids = new List <int>();
var students = (from x in db.students where x.ClassId == classid select x).ToList();
//List<int> recordsids = new List<int>();
foreach (var i in students)
{
attendance.Classname = classname;
attendance.ClassId = i.ClassId;
attendance.Name = i.StudentName;
attendance.Studentid = i.Id;
attendance.dataofattendance = date;
attendance.Remarks = "";
attendance.StatusId = attendancestatus;
db.attendancerecords.Add(attendance);
db.SaveChanges();
db.Entry(attendance).GetDatabaseValues(); // getting recent value of the entity
attendanceids.Add(attendance.Id); //here i am inserting each attendance record primary key to the list for attendance sheet
}
TempData["Class"] = classid;
TempData["ListIds"] = attendanceids;
return(RedirectToAction("Index", "AttendanceRecordsdatas"));
}
public IHttpActionResult PutAttendanceRecordsdata(int id, AttendanceRecordsdata attendanceRecordsdata)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != attendanceRecordsdata.Id)
{
return(BadRequest());
}
db.Entry(attendanceRecordsdata).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AttendanceRecordsdataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
AttendanceRecordsdata attendanceRecordsdata = db.attendancerecords.Find(id);
db.attendancerecords.Remove(attendanceRecordsdata);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Studentid,Name,ClassId,Classname,dataofattendance,StatusId,Remarks")] AttendanceRecordsdata attendanceRecordsdata)
{
if (ModelState.IsValid)
{
db.Entry(attendanceRecordsdata).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StatusId = new SelectList(db.options, "Id", "Options", attendanceRecordsdata.StatusId);
return(View(attendanceRecordsdata));
}
public IHttpActionResult GetAttendanceRecordsdata(int id)
{
AttendanceRecordsdata attendanceRecordsdata = db.attendancerecords.Find(id);
if (attendanceRecordsdata == null)
{
return(NotFound());
}
return(Ok(attendanceRecordsdata));
}
public IHttpActionResult PostAttendanceRecordsdata(AttendanceRecordsdata attendanceRecordsdata)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.attendancerecords.Add(attendanceRecordsdata);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = attendanceRecordsdata.Id }, attendanceRecordsdata));
}
// GET: AttendanceRecordsPannel/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AttendanceRecordsdata attendanceRecordsdata = db.attendancerecords.Find(id);
if (attendanceRecordsdata == null)
{
return(HttpNotFound());
}
return(View(attendanceRecordsdata));
}
public IHttpActionResult DeleteAttendanceRecordsdata(int id)
{
AttendanceRecordsdata attendanceRecordsdata = db.attendancerecords.Find(id);
if (attendanceRecordsdata == null)
{
return(NotFound());
}
db.attendancerecords.Remove(attendanceRecordsdata);
db.SaveChanges();
return(Ok(attendanceRecordsdata));
}
// GET: AttendanceRecordsPannel/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AttendanceRecordsdata attendanceRecordsdata = db.attendancerecords.Find(id);
if (attendanceRecordsdata == null)
{
return(HttpNotFound());
}
ViewBag.StatusId = new SelectList(db.options, "Id", "Options", attendanceRecordsdata.StatusId);
return(View(attendanceRecordsdata));
}
public ActionResult Edit(AttendanceRecordsdata attendanceRecordsdata)
{
if (ModelState.IsValid)
{
if (attendanceRecordsdata.Remarks == null)
{
attendanceRecordsdata.Remarks = "Marked";
}
check = true;
db.Entry(attendanceRecordsdata).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
check = true;
ViewBag.StatusId = new SelectList(db.options, "Id", "Options", attendanceRecordsdata.StatusId);
return(View(attendanceRecordsdata));
}
