public ActionResult Create(UserGroupInstance usergroupinstance)
{
if (ModelState.IsValid)
{
db.UserGroupInstances.Add(usergroupinstance);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "UserName", usergroupinstance.UserId);
ViewBag.GroupInstanceId = new SelectList(db.GroupInstances, "GroupInstanceId", "GroupInstanceId", usergroupinstance.GroupInstanceId);
return View(usergroupinstance);
}
//this is a GroupInstanceId, not UserGroupInstanceId. TODO: make more obvious in routing.
//
// GET: /UserGroupInstance/Edit/5
public ActionResult Edit(string Date, int id = 0)
{
DateTime InstanceDate = Convert.ToDateTime(Date);
GroupInstance groupInstance = db.GroupInstances.Include(x => x.Group)
.Include(x => x.Group.Users)
.Where(x => x.GroupInstanceId == id).FirstOrDefault();
var ugi = new List<UserGroupInstance>();
if (groupInstance != null)
{
var group = GetGroupByDate(db.Groups.Include(x => x.Users), groupInstance.GroupId, InstanceDate);
var studentsInInstance = group.Users.Where(x => Roles.IsUserInRole(x.UserName, "Student") && x.FutureStudent == false);
var UserGroupInstances = db.UserGroupInstances.Include(x => x.GroupInstance).Include(x => x.User).Where(x => x.GroupInstanceId == id).ToList().Where(x=>x.InstanceDateTime.Date == InstanceDate.Date);
foreach (var student in studentsInInstance.Except(UserGroupInstances.Select(x => x.User)))
{
var newUserGroupInstance = new UserGroupInstance();
newUserGroupInstance.User = student;
newUserGroupInstance.UserId = student.UserId;
newUserGroupInstance.AttendanceTaken = DateTime.Now;
newUserGroupInstance.InstanceDateTime = InstanceDate;
newUserGroupInstance.Present = AttendanceType.NA;
newUserGroupInstance.GroupInstanceId = groupInstance.GroupInstanceId;
ugi.Add(newUserGroupInstance);
}
ugi.AddRange(UserGroupInstances);
}
var instances = new UserGroupInstanceEditViewModel();
instances.UserGroupInstances = ugi;
var students = ugi.Select(x => x.User);
instances.Students = db.Students.ToList().Except(students).ToList();
return View(instances);
}
public ActionResult Save(Dictionary<string,string> groups, int GroupInstanceId, string Date)
{
var InstanceDate = Convert.ToDateTime(Date);
//Jquery only sends string,string.
Dictionary<int, AttendanceType> groupsParsed = groups.ToDictionary(x => Convert.ToInt32(x.Key), x => (AttendanceType)Convert.ToInt32(x.Value));
var existingAttendance = db.UserGroupInstances.Include(x=>x.User)
.Where(x => x.GroupInstanceId == GroupInstanceId).ToList()
.Where(x => x.InstanceDateTime.Date == InstanceDate.Date);
var GroupInstance = db.GroupInstances.Include(x=>x.Group).Where(x => x.GroupInstanceId == GroupInstanceId).First();
var group = GetLatestGroup(GroupInstance.GroupId);
var PaymentProfileId = group.PaymentProfileId;
var paymentRule = db.PaymentRules.Where(x => x.PaymentProfileId == PaymentProfileId && x.EffectiveDate <= DateTime.Today).FirstOrDefault();
var amount = 0.0m;
if (paymentRule != null)
{
amount = paymentRule.Amount;
}
foreach (KeyValuePair<int, AttendanceType> kvp in groupsParsed)
{
var currentAttendance = existingAttendance.Where(x => x.UserId == kvp.Key).FirstOrDefault();
if (currentAttendance!=null)
{
if (currentAttendance.Present == kvp.Value)
{
continue;
}
else
{
if (currentAttendance.Present == AttendanceType.Absent || currentAttendance.Present == AttendanceType.Present)
{
if (kvp.Value == AttendanceType.AbsentWithExcuse || kvp.Value == AttendanceType.NA)
{
var Payment = new Payment()
{
comments = "Посещение изменено с \"" +
currentAttendance.Present.GetDescription() +
"\" на \"" + kvp.Value.GetDescription() +
"\" " + InstanceDate +
"- Возвращено через страницу посещений (" + Membership.GetUser().UserName + ")",
TransactionDateTime = DateTime.Now,
UserId = kvp.Key,
Amount = amount
};
db.Payments.Add(Payment);
db.SaveChanges();
}
}
if (currentAttendance.Present == AttendanceType.AbsentWithExcuse)
{
if (kvp.Value == AttendanceType.Absent || kvp.Value == AttendanceType.Present)
{
var Payment = new Payment()
{
comments = "Посещение изменено с \"" +
currentAttendance.Present.GetDescription() +
"\" на \"" + kvp.Value.GetDescription() +
"\" " + InstanceDate +
"- Списано через страницу посещений (" + Membership.GetUser().UserName + ")",
TransactionDateTime = DateTime.Now,
UserId = kvp.Key,
Amount = amount * -1
};
db.Payments.Add(Payment);
db.SaveChanges();
}
}
if (currentAttendance.Present == AttendanceType.NA)
{
if (kvp.Value == AttendanceType.Absent || kvp.Value == AttendanceType.Present)
{
var Payment = new Payment()
{
comments = kvp.Value.GetDescription() + " " + InstanceDate + "- Списано через страницу посещений (" + Membership.GetUser().UserName + ")",
TransactionDateTime = DateTime.Now,
UserId = kvp.Key,
Amount = amount * -1
};
db.Payments.Add(Payment);
db.SaveChanges();
}
}
currentAttendance.Present = kvp.Value;
db.Entry(currentAttendance).State = EntityState.Modified;
db.SaveChanges();
}
}
else
{
var newInstance = new UserGroupInstance() { UserId = kvp.Key,
InstanceDateTime = InstanceDate,
Present = kvp.Value,
GroupInstanceId = GroupInstanceId,
AttendanceTaken= DateTime.Now};
db.UserGroupInstances.Add(newInstance);
db.SaveChanges();
if (kvp.Value == AttendanceType.Absent || kvp.Value == AttendanceType.Present)
{
var Payment = new Payment()
{
comments = kvp.Value.GetDescription() + " " + InstanceDate + "- Списано через страницу посещений (" + Membership.GetUser().UserName + ")",
TransactionDateTime = DateTime.Now,
UserId = newInstance.UserId,
Amount = amount * -1
};
db.Payments.Add(Payment);
db.SaveChanges();
}
}
//var groupInstance = groupInstances.Where(x => x.UserGroupInstanceID == kvp.Key).First();
//var PaymentProfileId = db.GroupInstances.Include(x=>x.Group).Where(x => x.GroupInstanceId == groupInstance.GroupInstanceId).First().Group.PaymentProfileId;
//var amount = db.PaymentRules.Where(x => x.PaymentProfileId == PaymentProfileId && x.EffectiveDate <= DateTime.Today).First().Amount;
//groupInstance.Present = kvp.Value;
//if (kvp.Value == AttendanceType.Absent || kvp.Value == AttendanceType.Present)
//{
// Payment payment = new Payment();
// payment.Amount = amount*-1;
// payment.comments = "Списано через страницу посещений (" + Membership.GetUser().UserName + ")";
// payment.UserId = groupInstance.UserId;
// payment.TransactionDateTime = DateTime.Now;
// db.Payments.Add(payment);
//}
//db.Entry(groupInstance).State = EntityState.Modified;
}
db.SaveChanges();
return Content(Boolean.TrueString);
}
public ActionResult Edit(UserGroupInstance usergroupinstance)
{
if (ModelState.IsValid)
{
db.Entry(usergroupinstance).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "UserName", usergroupinstance.UserId);
ViewBag.GroupInstanceId = new SelectList(db.GroupInstances, "GroupInstanceId", "GroupInstanceId", usergroupinstance.GroupInstanceId);
return View(usergroupinstance);
}