public void Calculate_MissionHours() { TestContext db = new TestContext(); var me = db.Members.Add(new Member()); Func <int, double, string, string, MissionRoster> createMission = (daysAgo, hours, role, type) => { Mission m = db.Missions.Add(new Mission { StartTime = DateTime.Now.AddDays(-daysAgo).AddHours(-1), MissionType = type }); MissionRoster r = db.MissionRosters.Add(new MissionRoster { Person = me, Mission = m, TimeIn = DateTime.Now.AddDays(-daysAgo), TimeOut = DateTime.Now.AddDays(-daysAgo).AddHours(hours), InternalRole = role }); return(r); }; createMission(15, 3.5, "field", "search"); createMission(63, 8.0, "field", "resecue"); var satisfies = createMission(80, 4, "field", "urban,search"); createMission(100, 23, "field", "search"); var course = db.TrainingCourses.Add(new TrainingCourse { DisplayName = "Target", FullName = "Target", ValidMonths = 36 }); db.TrainingRules.Add(new TrainingRule { RuleText = string.Format("Mission(12:%:36)>{0}", course.Id) }); TrainingRecordCalculator calc = new TrainingRecordCalculator(db); var result = calc.Calculate(new[] { me }, DateTime.Now); Assert.AreEqual(1, result.Count, "awarded records"); var record = db.ComputedTrainingAwards.Single(); Assert.AreEqual(satisfies.TimeIn.Value.AddMonths(course.ValidMonths.Value), record.Expiry.Value, "go back until we have the hours, add course months"); }
protected override void AddRosterRowFrom4x4Sheet(ExpandedRowsContext model, SarUnit unit, IRosterEntry row) { MissionRoster mrow = (MissionRoster)row; Guid personId = mrow.Person.Id; MissionRoster newRow = new MissionRoster { Mission = (Mission)model.SarEvent, Unit = unit, Person = this.db.Members.Include("MissionRosters").Single(f => f.Id == personId), TimeIn = mrow.TimeIn, TimeOut = mrow.TimeOut, Miles = mrow.Miles, InternalRole = mrow.InternalRole }; mrow.Id = newRow.Id; this.db.MissionRosters.Add(newRow); }
protected override void AddRosterRowFrom4x4Sheet(ExpandedRowsContext model, SarUnit unit, IRosterEntry row) { MissionRoster mrow = (MissionRoster)row; Guid personId = mrow.Person.Id; MissionRoster newRow = new MissionRoster { Mission = (Mission)model.SarEvent, Unit = unit, Person = this.db.Members.Include("MissionRosters").Single(f => f.Id == personId), TimeIn = mrow.TimeIn, TimeOut = mrow.TimeOut, Miles = mrow.Miles, InternalRole = mrow.InternalRole }; mrow.Id = newRow.Id; this.db.MissionRosters.Add(newRow); }
public ActionResult Review4x4Roster(bool?bot) { if (!Has4x4RosterPermissions()) { return(CreateLoginRedirect()); } // Value is pre-incremented in while loop. int startRow = 13; if (Request.Files.Count != 1) { throw new InvalidOperationException("Can only submit one roster"); } var postedFile = Request.Files[0]; byte[] fileData = new byte[postedFile.ContentLength]; postedFile.InputStream.Read(fileData, 0, fileData.Length); var stream = new System.IO.MemoryStream(fileData); stream.Position = 0; ExcelFile xl = null; // new ExcelFile(); if (postedFile.FileName.EndsWith(".xlsx", StringComparison.OrdinalIgnoreCase)) { xl = ExcelService.Read(postedFile.InputStream, ExcelFileType.XLSX); } else { xl = ExcelService.Read(postedFile.InputStream, ExcelFileType.XLS); } ExcelSheet sheet = xl.GetSheet(0); object start = sheet.CellAt(13, 4).StringValue.ToUpperInvariant().Replace("DATE", "").Replace("TIME", "").Replace("IN", "").Replace("OUT", "").Trim(); DateTime startDate = DateTime.Parse(start.ToString()); ExpandedRowsContext model = new ExpandedRowsContext(); model.EventId = Guid.NewGuid(); if (typeof(E) == typeof(Mission)) { model.Type = RosterType.Mission; model.SarEvent = new Mission { Id = model.EventId }; } else { model.Type = RosterType.Training; model.SarEvent = new Training { Id = model.EventId }; } model.SarEvent.StateNumber = sheet.CellAt(9, 2).StringValue.Split(' ')[0]; model.SarEvent.Title = sheet.CellAt(10, 2).StringValue; model.SarEvent.Location = sheet.CellAt(11, 2).StringValue; model.SarEvent.County = sheet.CellAt(9, 10).StringValue.ToLowerInvariant(); model.BadRows = new List <IRosterEntry>(); model.Rows = new List <IRosterEntry>(); model.NumDays = 3; model.RosterStart = startDate; SarUnit unit = this.db.Units.Where(f => f.DisplayName == "4x4").Single(); //ctx.Detach(unit); while (!string.IsNullOrWhiteSpace((sheet.CellAt(++startRow, 1).StringValue ?? "").ToString())) { R roster = new R(); string name = sheet.CellAt(startRow, 1).StringValue; string dem = sheet.CellAt(startRow, 2).StringValue.PadLeft(4, '0'); var member = this.db.Members .Where(f => f.LastName + ", " + f.FirstName == name && f.DEM == dem) .SingleOrDefault(); if (member == null) { //throw new InvalidOperationException(string.Format("Member {0} not found", sheet.CellAt(startRow, 1])); continue; } // ctx.Detach(member); roster.Person = member; for (int i = 0; i < 3; i++) { string v = (sheet.CellAt(startRow, 8 - i * 2).StringValue ?? "").ToString(); if (!string.IsNullOrWhiteSpace(v)) { v = v.PadLeft(4, '0'); int hours = int.Parse(v.Substring(0, 2)); int minutes = int.Parse(v.Substring(2, 2)); roster.TimeIn = startDate.AddDays(2 - i).AddHours(hours).AddMinutes(minutes); } v = (sheet.CellAt(startRow, 5 + i * 2).StringValue ?? "").ToString(); if (!string.IsNullOrWhiteSpace(v)) { v = v.PadLeft(4, '0'); int hours = int.Parse(v.Substring(0, 2)); int minutes = int.Parse(v.Substring(2, 2)); roster.TimeOut = startDate.AddDays(i).AddHours(hours).AddMinutes(minutes); } } string miles = (sheet.CellAt(startRow, 11).StringValue ?? "").ToString(); if (miles != "") { double numericMiles; if (double.TryParse(miles, out numericMiles)) { roster.Miles = (int)Math.Ceiling(numericMiles); } } MissionRoster missionRoster = roster as MissionRoster; if (missionRoster != null) { missionRoster.Unit = unit; if ("CO".Equals(sheet.CellAt(startRow, 3).StringValue)) { missionRoster.InternalRole = "InTown"; } else if ("OL".Equals(sheet.CellAt(startRow, 3).StringValue)) { missionRoster.InternalRole = "OL"; } else if (new[] { "AS", "ATL", "OUA", "TL", "TLT", "TM" }.Contains(sheet.CellAt(startRow, 3).StringValue)) { missionRoster.InternalRole = "Field"; } else if ("VAN".Equals(sheet.CellAt(startRow, 3).StringValue)) { missionRoster.InternalRole = "Base"; } else { missionRoster.InternalRole = "Responder"; } } model.Rows.Add(roster); } if (model.Rows.Count > 0) { model.SarEvent.StartTime = model.Rows.Min(f => f.TimeIn).Value; model.SarEvent.StopTime = model.Rows.Max(f => f.TimeOut).Value; } DateTime early = model.SarEvent.StartTime.AddDays(-1); DateTime late = model.SarEvent.StartTime.AddDays(1); E[] alternates = this.GetEventSource().Where(f => f.StateNumber == model.SarEvent.StateNumber || (f.StartTime > early && f.StartTime < late)).OrderBy(f => f.StartTime).ToArray(); ViewData["alternateMissions"] = alternates; ViewData["CanEditRoster"] = false; ViewData["IsTemp"] = true; SetSessionValue("reviewRosterBot", bot); SetSessionValue("reviewRoster", model); SetSessionValue("reviewRosterData", fileData); SetSessionValue("reviewRosterName", postedFile.FileName); return(View(model)); }