public int EditAds(AttendanceSet attendanceSet)
{
db.Entry(attendanceSet).State = System.Data.Entity.EntityState.Modified;
int result = db.SaveChanges();
return(result);
}
public int DeleteAttendanceSet(int id)
{
AttendanceSet attendanceSet = db.AttendanceSet.Find(id);
db.AttendanceSet.Remove(attendanceSet);
int result = db.SaveChanges();
return(result);
}
public ActionResult Edit(AttendanceSet attendanceSet)
{
int result = bll.EditAttendanceSet(attendanceSet);
if (result != 0)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("EditAjax"));
}
public JsonResult EditAjax(int id)
{
AttendanceSet list = bll.SelectAttendanceSet(id);
//JsonSerializerSettings jsset = new JsonSerializerSettings();
//jsset.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
//string ret = JsonConvert.SerializeObject(list,jsset);
return(Json(list));
}
public static AttendanceSetViewModel FromModel(AttendanceSet model)
{
return(new AttendanceSetViewModel()
{
Id = model.Id,
Date = model.Date,
CapturedByMemberId = model.CapturedByMemberId,
CaptureTime = model.CaptureTime,
StructuralGroupId = model.StructuralGroupId
});
}
public ActionResult Add(AttendanceSet attendanceSet)
{
int result = bll.AddAllAttendanceSet(attendanceSet);
if (result != 0)
{
return(RedirectToAction("Index"));
}
else
{
Response.Write("出现错误");
return(View());
}
}
private void ValidateAttendanceSetOrThrow(AttendanceSet attendanceSet, UmbracoDatabase db)
{
if (attendanceSet.StructuralGroupId <= 0)
{
throw new Exception("Invalid group specified");
}
var requiredMembers = MemberHelper.GetMembers(ApplicationContext.DatabaseContext.Database, Services.MemberService, attendanceSet.StructuralGroupId, "Student");
if (attendanceSet.AttendanceRecords.Select(a => a.MemberId).Except(requiredMembers.Select(m => m.Id)).Any() ||
requiredMembers.Select(m => m.Id).Except(attendanceSet.AttendanceRecords.Select(a => a.MemberId)).Any())
{
throw new Exception("Attendance has not been captured for all members of the group");
}
if (!attendanceSet.AttendanceRecords.All(a => a.Attendance == (int)Attendance.Absent || a.Attendance == (int)Attendance.Present))
{
throw new Exception("Invalid present/absent status");
}
}
public AttendanceSetViewModel PostAttendanceSet(AttendanceSet attendanceSet)
{
var db = ApplicationContext.DatabaseContext.Database;
ValidateAttendanceSetOrThrow(attendanceSet, db);
attendanceSet.CaptureTime = DateTime.Now;
var currentMember = Members.GetCurrentMember();
attendanceSet.CapturedByMemberId = currentMember == null ? 0 : currentMember.Id;
attendanceSet.Date = attendanceSet.Date.Date;
db.Insert(attendanceSet);
foreach (var attendanceRecord in attendanceSet.AttendanceRecords)
{
attendanceRecord.AttendanceSetId = attendanceSet.Id;
db.Insert(attendanceRecord);
}
return(GetAttendanceSet(attendanceSet.StructuralGroupId, attendanceSet.Date));
}
public int AddAllAttendanceSet(AttendanceSet attendanceSet)
{
return(dal.AddAttendanceSet(attendanceSet));
}
public int EditAttendanceSet(AttendanceSet attendanceSet)
{
return(dal.EditAds(attendanceSet));
}
