public string SaveDocuments(Guid id, UnitDocument[] data) { if (!CanEditDocuments(this.permissions, id)) { ThrowAuthError(); } Data.SarUnit unit = db.Units.Include("Documents").Single(f => f.Id == id); var existingDocuments = db.UnitDocuments.Where(f => f.Unit.Id == id).ToDictionary(f => f.Id, f => f); List <UnitDocument> desiredDocuments = new List <UnitDocument>(data); foreach (var document in desiredDocuments) { Data.UnitDocument unitDocument; if (existingDocuments.TryGetValue(document.Id, out unitDocument)) { existingDocuments.Remove(document.Id); } if (string.IsNullOrWhiteSpace(document.Title)) { // If there's no name, delete it. if (unitDocument != null) { unit.Documents.Remove(unitDocument); } continue; } if (string.IsNullOrWhiteSpace(document.Url)) { return(string.Format("{0}'s url is blank", document.Title)); } if (unitDocument == null) { unitDocument = new Data.UnitDocument() { Type = Data.UnitDocumentType.Application }; unit.Documents.Add(unitDocument); } document.UpdateModel(unitDocument); } foreach (var leftover in existingDocuments.Values) { unit.Documents.Remove(leftover); } db.SaveChanges(); return("OK"); }
/// <summary> /// /// </summary> /// <param name="unit"></param> /// <param name="xl"></param> /// <param name="goodList"></param> private void GenerateMissionReadySheets(SarUnit unit, ExcelFile xl, ExcelSheet goodList) { IMissionReadyPlugin extension = null; string longName = this.settings.GroupFullName ?? this.settings.GroupName; IQueryable<UnitMembership> memberships = this.db.UnitMemberships.Include("Person.ComputedAwards.Course").Include("Status"); if (unit != null) { memberships = memberships.Where(um => um.Unit.Id == unit.Id); longName = unit.LongName; extension = this.extensions.For<IMissionReadyPlugin>(unit); } memberships = memberships.Where(um => um.EndTime == null && um.Status.IsActive); memberships = memberships.OrderBy(f => f.Person.LastName).ThenBy(f => f.Person.FirstName); goodList.Header = longName + " Mission Active Roster"; goodList.Footer = DateTime.Now.ToShortDateString(); var courses = (from c in this.db.TrainingCourses where c.WacRequired > 0 select c).OrderBy(x => x.DisplayName).ToList(); int headerIdx = 0; Action<string> appendHeader = head => { var cell = goodList.CellAt(0, headerIdx++); cell.SetValue(head); cell.SetBold(true); cell.SetTextWrap(true); }; Action<MissionReadyColumns> insertExtensionHeaders = group => { if (extension == null) return; foreach (var value in extension.GetHeadersAfter(group)) { appendHeader(value); } }; insertExtensionHeaders(MissionReadyColumns.Start); appendHeader("DEM"); insertExtensionHeaders(MissionReadyColumns.WorkerNumber); appendHeader("Lastname"); appendHeader("Firstname"); insertExtensionHeaders(MissionReadyColumns.Name); appendHeader("Card Type"); insertExtensionHeaders(MissionReadyColumns.WorkerType); foreach (var course in courses) { var cell = goodList.CellAt(0, headerIdx++); cell.SetValue(course.DisplayName); cell.SetBold(true); cell.SetTextWrap(true); } insertExtensionHeaders(MissionReadyColumns.Courses); ExcelSheet badList = xl.CopySheet(goodList.Name, "Non-Mission Members"); ExcelSheet nonFieldList = xl.CopySheet(goodList.Name, "Admin Members"); using (SheetAutoFitWrapper good = new SheetAutoFitWrapper(xl, goodList)) { using (SheetAutoFitWrapper bad = new SheetAutoFitWrapper(xl, badList)) { using (SheetAutoFitWrapper admin = new SheetAutoFitWrapper(xl, nonFieldList)) { int idx = 1; int c = 0; Guid lastId = Guid.Empty; foreach (UnitMembership membership in memberships) { Member member = membership.Person; if (member.Id == lastId) { continue; } lastId = member.Id; CompositeTrainingStatus stats = CompositeTrainingStatus.Compute(member, courses, DateTime.Now); SheetAutoFitWrapper wrap = bad; // If the person isn't supposed to keep up a WAC card, then they're administrative... if (membership.Status.WacLevel == WacLevel.None) { wrap = admin; } // If they're current on training and have a DEM card, they're good... else if (stats.IsGood && member.WacLevel != WacLevel.None) { wrap = good; } idx = wrap.Sheet.NumRows + 1; c = 0; Action<MissionReadyColumns> insertExtensionColumns = group => { if (extension == null) return; foreach (var value in extension.GetColumnsAfter(group, member)) { wrap.SetCellValue(value, idx, c++); } }; insertExtensionColumns(MissionReadyColumns.Start); wrap.SetCellValue(string.Format("{0:0000}", member.DEM), idx, c++); insertExtensionColumns(MissionReadyColumns.WorkerNumber); wrap.SetCellValue(member.LastName, idx, c++); wrap.SetCellValue(member.FirstName, idx, c++); insertExtensionColumns(MissionReadyColumns.Name); ExcelCell cell = wrap.Sheet.CellAt(idx, c); switch (member.WacLevel) { case WacLevel.Field: cell.SetFillColor(Color.Green); cell.SetFontColor(Color.White); break; case WacLevel.Novice: cell.SetFillColor(Color.Red); cell.SetFontColor(Color.White); break; case WacLevel.Support: cell.SetFillColor(Color.Orange); break; } wrap.SetCellValue(member.WacLevel.ToString(), idx, c++); insertExtensionColumns(MissionReadyColumns.WorkerType); foreach (var course in courses) { TrainingStatus stat = stats.Expirations[course.Id]; if ((stat.Status & ExpirationFlags.Okay) != ExpirationFlags.Okay) { wrap.Sheet.CellAt(idx, c).SetFillColor(Color.Pink); wrap.Sheet.CellAt(idx, c).SetBorderColor(Color.Red); } wrap.SetCellValue(stat.ToString(), idx, c); if (stat.Expires.HasValue) { wrap.Sheet.CellAt(idx, c).SetValue(stat.Expires.Value.Date.ToString("yyyy-MM-dd")); } c++; } insertExtensionColumns(MissionReadyColumns.Courses); if (wrap == bad) { wrap.Sheet.CellAt(idx, c).SetValue(member.ContactNumbers.Where(f => f.Type == "email").OrderBy(f => f.Priority).Select(f => f.Value).FirstOrDefault()); } insertExtensionColumns(MissionReadyColumns.End); idx++; } admin.Sheet.AutoFitAll(); good.Sheet.AutoFitAll(); bad.Sheet.AutoFitAll(); } } } }
/// <summary> /// /// </summary> /// <param name="unit"></param> /// <returns></returns> public Stream GetMissionReadyList(SarUnit unit) { string templateFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Templates", "Report", "missionready-template.xls"); ExcelFile xl; using (FileStream fs = new FileStream(templateFile, FileMode.Open, FileAccess.Read)) { xl = ExcelService.Read(fs, ExcelFileType.XLS); } var goodList = xl.GetSheet(0); GenerateMissionReadySheets(unit, xl, goodList); MemoryStream ms = new MemoryStream(); xl.Save(ms); ms.Seek(0, SeekOrigin.Begin); return ms; }
protected override void AddRosterRowFrom4x4Sheet(ExpandedRowsContext model, SarUnit unit, IRosterEntry row) { TrainingRoster mrow = (TrainingRoster)row; Guid personId = mrow.Person.Id; TrainingRoster newRow = new TrainingRoster { Training = (Training)model.SarEvent, Person = this.db.Members.Include("TrainingRosters").Single(f => f.Id == personId), TimeIn = mrow.TimeIn, TimeOut = mrow.TimeOut, Miles = mrow.Miles, }; mrow.Id = newRow.Id; this.db.TrainingRosters.Add(newRow); }
public MissionReadyExtension(SarUnit unit) { this.unit = unit; }
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); }