Ejemplo n.º 1
0
        public bool checkDuplicateRecord(ShiftRecordModels model)
        {
            List<ShiftRecord> records = db.ShiftRecords.Where(s => s.volunteerId == model.volunteerId && s.startOn != null && s.endOn != null && s.recordId != model.recordId).ToList();
            if (records != null)
            {
                foreach (var item in records)
                {
                    // 1. Case:
                    //
                    //       TS-------TE
                    //    BS------BE
                    //
                    // TS is after BS but before BE
                    if (model.startOn != null)
                    {
                        if (model.startOn >= item.startOn && model.startOn < item.endOn)
                        {
                            return true;
                        }
                    }

                    // 2. Case
                    //
                    //    TS-------TE
                    //        BS---------BE
                    //
                    // TE is before BE but after BS
                    if (model.endOn != null)
                    {
                        if (model.endOn > item.startOn && model.endOn <= item.endOn)
                        {
                            return true;
                        }
                    }

                    // 3. Case
                    //
                    //  TS----------TE
                    //     BS----BE
                    //
                    // TS is before BS and TE is after BE
                    if (model.startOn != null && model.endOn != null)
                    {
                        if (model.startOn <= item.startOn && model.endOn >= item.endOn)
                        {
                            return true;
                        }
                    }
                }
            }
            return false;
        }
Ejemplo n.º 2
0
 private ShiftRecordModels convertToShiftRecordModels(ShiftRecord model)
 {
     ShiftRecordModels record = new ShiftRecordModels();
     record.volunteerId = model.volunteerId;
     record.teamName = model.teamName;
     record.startOn = model.startOn;
     record.endOn = model.endOn;
     record.recordId = model.recordId;
     record.earnHours = model.earnHours;
     record.earnedBucks = model.earnedBucks;
     return record;
 }
Ejemplo n.º 3
0
        private decimal CalculateExtraEarnHours(ShiftRecordModels model)
        {
            int maxHours = 5;
            int doublePayStartHours = 22;

            DateTime tStart = model.startOn;
            DateTime tEnd = DateTime.Now;
            TimeSpan ts = new TimeSpan(doublePayStartHours, 0, 0);

            if (model.endOn != null)
            {
                tEnd = (System.DateTime)model.endOn;
            }

            if ((tStart.Day == tEnd.Day) && (tStart.Hour < doublePayStartHours && tEnd.Hour < doublePayStartHours))
            {
                // tStar and tEnd at the same day and both are before 10 pm
                return 0;
            }
            else if (tStart.Hour >= doublePayStartHours && tEnd >= tStart.AddHours(maxHours))
            {
                // if tStart after 10 pm and tEnd - tStar > 4 hours, return max hours
                return maxHours;
            }
            else if ((tStart.Hour <= doublePayStartHours && tEnd.Hour >= doublePayStartHours) || (tEnd.Day > tStart.Day))
            {
                // if tStart before 10 pm, but tEnd after 10 pm
                // or if tEnd Day end in another day
                // set start time become 10 pm
                tStart = tStart.Date + ts;
                TimeSpan difference = tEnd - tStart;
                decimal diffHours = (decimal)Math.Round(difference.TotalHours, 1, MidpointRounding.AwayFromZero);
                if (diffHours >= maxHours)
                {
                    // if hours > max hours, retunr max hours
                    return maxHours;
                }
                else
                {
                    return diffHours;
                }
            }
            return 0;
        }
Ejemplo n.º 4
0
 private decimal CalculateEarnHours(ShiftRecordModels model)
 {
     DateTime tStart = model.startOn;
     DateTime tEnd = DateTime.Now;
     if (model.endOn != null)
     {
         tEnd = (System.DateTime)model.endOn;
     }
     TimeSpan difference = tEnd - tStart;
     decimal diffHours = (decimal)Math.Round(difference.TotalHours, 1, MidpointRounding.AwayFromZero);
     return diffHours;
 }
Ejemplo n.º 5
0
        public ActionResult VolunteerHistoryCreate(ShiftRecordModels model)
        {
            model.startOn = getSignInOutTime(model.startOn);

            bool isDuplicationRecord = checkDuplicateRecord(model);
            if (isDuplicationRecord == true)
            {
                int volunteerId = (int)model.volunteerId;
                ViewBag.Message = duplicate_time_frame_msg;

                decimal earnedTotalBucks = getTotalEarnedBucks(volunteerId);
                ViewBag.EarnedTotalBucks = earnedTotalBucks;
                decimal earnedTotalHours = getTotalEarnedHours(volunteerId);
                ViewBag.EarnedTotalHours = earnedTotalHours;

                ViewBag.LastRecord = GetLastShiftRecord(volunteerId);
                ViewBag.Volunteer = db.Volunteers.Find(volunteerId);
                return View(GetVolunteerShiftRecords(volunteerId));
            }
            else
            {
                ShiftRecord target = new ShiftRecord();
                target.teamName = model.teamName;
                target.volunteerId = model.volunteerId;
                target.startOn = model.startOn;
                target.createOn = DateTime.Now;
                target.createBy = WebSecurity.CurrentUserName;
                target.modifiedOn = DateTime.Now;
                target.modifiedBy = WebSecurity.CurrentUserName;
                target.earnedBucks = 0;
                target.earnHours = 0;
                db.ShiftRecords.Add(target);
                db.SaveChanges();
                return RedirectToAction("VolunteerHistory/" + model.volunteerId, "Volunteer");
            }
        }
Ejemplo n.º 6
0
        public ActionResult VolunteerHistory(ShiftRecordModels model)
        {
            ViewBag.Message = "";

            model.endOn = getSignInOutTime((DateTime)model.endOn);

            Definition def = db.Definitions.Where(d => d.keyName == "BucksPerShift").FirstOrDefault();

            var calOrgHours = from r in db.ShiftRecords
                              where r.volunteerId == model.volunteerId
                              group r.earnHours by r.earnHours into data
                              select new
                              {
                                  earnedTotalHours = data.Sum()
                              };
            decimal oldHoursTotal = calOrgHours.AsEnumerable().Sum(r => r.earnedTotalHours);

            Definition defPlateauHours = db.Definitions.Where(d => d.keyName == "PlateauHours").FirstOrDefault();

            int plateauHours = int.Parse(defPlateauHours.keyValue);

            bool isDuplicateRecord = checkDuplicateRecord(model);

            if ((model.startOn < model.endOn) && (isDuplicateRecord == false))
            {
                if (model != null && ModelState.IsValid)
                {
                    {
                        var target = db.ShiftRecords.Find(model.recordId);
                        target.volunteerId = model.volunteerId;
                        target.teamName = model.teamName;
                        target.endOn = model.endOn;
                        target.modifiedOn = DateTime.Now;
                        target.modifiedBy = WebSecurity.CurrentUserName;
                        target.earnHours = CalculateEarnHours(model);
                        target.earnedBucks = decimal.Parse(def.keyValue) * (target.earnHours + CalculateExtraEarnHours(model));
                        db.Entry(target).State = EntityState.Modified;
                        db.SaveChanges();
                    }
                }
            }

            decimal earnedTotalBucks = getTotalEarnedBucks((int)model.volunteerId);
            ViewBag.EarnedTotalBucks = earnedTotalBucks;
            decimal earnedTotalHours = getTotalEarnedHours((int)model.volunteerId);
            ViewBag.EarnedTotalHours = earnedTotalHours;

            if (model.startOn >= model.endOn)
            {
                ViewBag.Message = startTime_endTime_error_msg;
            }
            else if (isDuplicateRecord == true)
            {
                ViewBag.Message = duplicate_time_frame_msg;
            }
            else if ((oldHoursTotal < plateauHours) && (earnedTotalHours >= plateauHours))
            {
                Definition defHonorMessage = db.Definitions.Where(d => d.keyName == "HonorMessage").FirstOrDefault();
                ViewBag.Message = defHonorMessage.keyValue;
            }

            ViewBag.LastRecord = GetLastShiftRecord((int)model.volunteerId);
            ViewBag.Volunteer = db.Volunteers.Find((int)model.volunteerId);
            return View(GetVolunteerShiftRecords((int)model.volunteerId));
        }
Ejemplo n.º 7
0
        public ActionResult ShiftRecord_Update([DataSourceRequest] DataSourceRequest request, ShiftRecordModels model)
        {
            Definition def = db.Definitions.Where(d => d.keyName == "BucksPerShift").FirstOrDefault();

            if (model != null && ModelState.IsValid)
            {
                {
                    var target = db.ShiftRecords.Find(model.recordId);
                    target.volunteerId = model.volunteerId;
                    target.teamName = model.teamName;
                    target.startOn = getSignInOutTime((DateTime)model.startOn);
                    target.endOn = getSignInOutTime((DateTime)model.endOn);
                    target.modifiedOn = DateTime.Now;
                    target.modifiedBy = WebSecurity.CurrentUserName;
                    target.earnHours = CalculateEarnHours(model);
                    target.earnedBucks = decimal.Parse(def.keyValue) * (target.earnHours + CalculateExtraEarnHours(model));
                    db.Entry(target).State = EntityState.Modified;
                    db.SaveChanges();
                }
            }
            return Json(ModelState.ToDataSourceResult());
        }
Ejemplo n.º 8
0
 public ActionResult ShiftRecord_Delete([DataSourceRequest] DataSourceRequest request, ShiftRecordModels model)
 {
     if (model != null && ModelState.IsValid)
     {
         ShiftRecord record = db.ShiftRecords.Find(model.recordId);
         if (record != null)
         {
             db.ShiftRecords.Remove(record);
             db.SaveChanges();
         }
     }
     return Json(ModelState.ToDataSourceResult());
 }
Ejemplo n.º 9
0
        public ShiftRecordModels GetLastShiftRecord(int id = 0)
        {
            ShiftRecord model = db.ShiftRecords.Where(a => a.endOn == null && a.volunteerId == id).FirstOrDefault();
            if (model == null)
            {
                return null;
            }
            else
            {
                ShiftRecordModels target = new ShiftRecordModels();
                target.volunteerId = model.volunteerId;
                target.teamName = model.teamName;
                target.recordId = model.recordId;
                target.startOn = model.startOn;

                return target;
            }
        }