public PipeComponentImporter(Workbook workbook, Dictionary<Int32, List<CellValue>> pipeComponentCellValuesToCheck, string tagNumberCellName, string lineNumberCellName, string pandIDCellName) { mTagNumberCellName = tagNumberCellName; mLineNumberCellName = lineNumberCellName; mPandIDCellName = pandIDCellName; mCee = new CmsEquipmentEntities(); mWorkbook = workbook; mPipeComponentCellValuesToCheck = pipeComponentCellValuesToCheck; mExistingPipes = mCee.Pipes .Include("Area") .Include("PipeClass") .Include("PipeSize") .Include("PipeFluidCode") .Include("PipeCategory") .Include("PipeSpecialFeature").ToList(); mImportResult = mCee.PipeComponents .Include("Pipe") .Include("Pipe.Area") .Include("PipeComponentType").ToList(); mDocumentTypes = mCee.DocumentTypes.ToList(); mExistingPipeComponentTypes = mCee.PipeComponentTypes.ToList(); mExistingPipeComponentProperties = mCee.PipeComponentProperties.ToList(); mDrawings = (from x in mDocumentTypes where x.Name == "Drawing" select x.Documents).FirstOrDefault().ToList(); }
public PipeImporter(Workbook workbook, Dictionary<Int32, List<CellValue>> pipeCellValuesToCheck, string lineNumberCellName, string pandIdCellName) { mWorkbook = workbook; mPipeCellValuesToCheck = pipeCellValuesToCheck; mLineNumberCellName = lineNumberCellName; mPandIdCellName = pandIdCellName; mCee = new CmsEquipmentEntities(); }
public void DoWork(Form1 form) { mForm = form; mOldIssuesDataContext = new OldIssuesDataContext(); mCee = new CmsEquipmentEntities(); try { if (form.AllExceptIssues) { //UpdateIssueAreas(); //UpdateAreas(); ImportIssueCategories(); ImportRoles(); AddPriviledges(); AddSecurityObjects(); ImportUsers(); AssignRolePrivileges(); ImportIssueClassification(); ImportDocumentTypes(); ImportDocumentAutors(); ImportDocuments(); ImportIssueRiskLikelihood(); ImportPcsEquipment(); ImportIssuePriority(); ImportIssueStatus(); ImportIssueType(); ImportDistributionListType(); ImportDistributionList(); ImportDistribution(); //PopulateAttachmentTypes(); PopulateIssueRiskCategory(); PopulateIssueRiskType(); //ImportMechanicalTypes(); //ImportMechanicalEquipment(); } else { ImportIssues(); } } catch (Exception ex) { string message = String.Format("Error: {0} Stack Trace {1}, Inner Exeption {2}", ex.Message, ex.StackTrace, ex.InnerException == null ? String.Empty : ex.InnerException.Message); mForm.AddMessage(MessageType.Error, message); } mForm.AddMessage(MessageType.Info, ""); mForm.AddMessage(MessageType.Info, "-------------------- Done --------------------"); mForm.AddMessage(MessageType.Info, ""); }
private void ImportMechanicalEquipment_DoWork(object sender, DoWorkEventArgs e) { CmsEquipmentEntities cmsEquipmentEntities = new CmsEquipmentEntities(); var mechanicalEquipments = (from x in cmsEquipmentEntities.MechanicalEquipments select x).ToList(); foreach (var mechanicalEquipment in mechanicalEquipments) { //B-313-DRY-001 AddMessage(MessageType.Added, String.Format("Processing Mechanical Equipment Id '{0}' Name '{1}' .", mechanicalEquipment.Id, mechanicalEquipment.Name)); var array = mechanicalEquipment.Name.Split('-'); if (array.Length > 1) { int areaNumber = -1; if (int.TryParse(array[1], out areaNumber)) { var area = (from x in cmsEquipmentEntities.Areas where x.AreaNumber == areaNumber select x).FirstOrDefault(); if (area == null) { AddMessage(MessageType.Warning, String.Format("Could not find Assigned Area name '{0}' from Mechanical Equipment Id '{1}' Name '{2}'.", areaNumber, mechanicalEquipment.Id, mechanicalEquipment.Name)); AddMessage(MessageType.Added, String.Format("Addign new Area name '{0}'.", areaNumber)); cmsEquipmentEntities.Areas.AddObject(new Area { Name = areaNumber.ToString(), AreaNumber = areaNumber }); cmsEquipmentEntities.SaveChanges(); area = (from x in cmsEquipmentEntities.Areas where x.AreaNumber == areaNumber select x).FirstOrDefault(); } if (area != null) { mechanicalEquipment.AreaId = area.Id; AddMessage(MessageType.Added, String.Format("Assigned Area Id '{0}' Name '{1}' to Mechanical Equipment Id '{2}' Name '{3}' .", area.Id, area.Name, mechanicalEquipment.Id, mechanicalEquipment.Name)); } else { AddMessage(MessageType.Warning, String.Format("Wrong name of Mechanical Equipment Id '{0}' Name '{1}'. Adding Unknow Area.", mechanicalEquipment.Id, mechanicalEquipment.Name)); mechanicalEquipment.AreaId = ((from x in cmsEquipmentEntities.Areas where x.Name == "Unknown" select x).FirstOrDefault()).Id; } } else { AddMessage(MessageType.Warning, String.Format("Could not recognise Assigned Area name '{0}' from Mechanical Equipment Id '{1}' Name '{2}'. Adding Unknow Area.", areaNumber, mechanicalEquipment.Id, mechanicalEquipment.Name)); mechanicalEquipment.AreaId = ((from x in cmsEquipmentEntities.Areas where x.Name == "Unknown" select x).FirstOrDefault()).Id; } } else { AddMessage(MessageType.Warning, String.Format("Wrong name of Mechanical Equipment Id '{0}' Name '{1}'. Adding Unknow Area.", mechanicalEquipment.Id, mechanicalEquipment.Name)); mechanicalEquipment.AreaId = ((from x in cmsEquipmentEntities.Areas where x.Name == "Unknown" select x).FirstOrDefault()).Id; } } cmsEquipmentEntities.SaveChanges(); }
private void btnCleanUpDupDocVersions_Click(object sender, EventArgs e) { AddMessage(MessageType.Info, "Starting"); try { CmsEquipmentEntities cmsEquipmentEntities = new CmsEquipmentEntities(); List<DocumentVersion> docVersionsToDelete = new List<DocumentVersion>(); List<string> foldersToDelete = new List<string>(); List<DocumentVersion> documentVersions = (from x in cmsEquipmentEntities.DocumentVersions select x).ToList(); foreach (DocumentVersion documentVersion in documentVersions) { List<DocumentVersion> dups = (from x in documentVersions where x.Version == documentVersion.Version && x.DocumentId == documentVersion.DocumentId select x).ToList(); if (dups.Count > 1) { //we have dups //leave one behind List<DocumentVersion> versions = (from x in dups orderby x.Id descending select x).Skip(1).ToList(); List<string> folders = (from x in dups orderby x.Id descending select x.Path).Skip(1).ToList(); if (versions.Count > 0) { //still have dups foreach (DocumentVersion version in versions) { int count = (from x in docVersionsToDelete where x.Id == version.Id select x.Id).Count(); if (count==0) { //not been added AddMessage(MessageType.Info, string.Format("Doc ID :{0}, dups count: {1}", documentVersion.DocumentId, versions.Count)); docVersionsToDelete.Add(version); foldersToDelete.AddRange(folders); } } } } } AddMessage(MessageType.Info, "doc version to delete = " + docVersionsToDelete.Count); foreach (DocumentVersion version in docVersionsToDelete) { cmsEquipmentEntities.DeleteObject(version); } cmsEquipmentEntities.SaveChanges(SaveOptions.None); foreach (string s in foldersToDelete) { string configPath = @"D:\cmsRoot\CMS Document Versions\"; string path = Path.Combine(configPath, s); if (Directory.Exists(path)) { Directory.Delete(path, true); } } AddMessage(MessageType.Info, "Finished"); } catch (Exception ex) { AddMessage(MessageType.Error, ex.ToString()); } }
public Form1() { InitializeComponent(); mCee = new CmsEquipmentEntities(); }
private static string BuildReleatedIssuesText(int issueId) { using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { cee.ContextOptions.LazyLoadingEnabled = false; List<string> links = new List<string>(); List<IssueRelatedIssue> relatedIssues = (from x in cee.IssueRelatedIssues.Include("RelatedIssue") orderby x.RelatedIssueId descending where x.IssueId == issueId select x).ToList(); string url = Util.GetAppSettingValue(Common.AppSettingKey.ApplicationUrl); foreach (IssueRelatedIssue relatedIssue in relatedIssues) { string issueIdHef = string.Format(@"<a href='{0}?issueid={1}'>{1} - {2}</a>", url, relatedIssue.RelatedIssueId.ToString(), relatedIssue.RelatedIssue.Name); links.Add(issueIdHef); } return string.Join("<br />", links.ToArray()); } }
private static Dictionary<string, string> ParseEmail(IEnumerable<IssueDistributionUser> users) { Dictionary<string, string> ret = new Dictionary<string, string>(); using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { foreach (IssueDistributionUser distributionUser in users) { User uq = (from u in cee.Users where u.Id == distributionUser.UserId && u.ActiveUser select u).FirstOrDefault(); if (uq != null && !string.IsNullOrEmpty(uq.EmailAddress) && !ret.ContainsKey(uq.EmailAddress.Trim())) { ret.Add(uq.EmailAddress.Trim(), string.Format("{0} {1}", uq.FirstName, uq.LastName)); } } } return ret; }
private static string BuildLatestResponseText(Issue issue) { using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { cee.ContextOptions.LazyLoadingEnabled = true; IssueResponse latestResponse = (from resp in cee.IssueResponses .Include("IssueStatus") where resp.IssueId == issue.Id orderby resp.Date descending select resp).FirstOrDefault(); if (latestResponse == null) { return NORESPONSETEXT; } if (string.IsNullOrEmpty(latestResponse.ResponseText)) { return NORESPONSETEXT; } return latestResponse.ResponseText; } }
private static string BuildHighestRiskText(int issueId, IssuueRiskTypeId riskTypeId) { //1=initial //2==final IssueRisk highestRisk = null; int highestRating = 0; using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { List<IssueRisk> issueRisks = (from x in cee.IssueRisks .Include("IssueRiskMatrix") .Include("IssueRiskMatrix.IssueRiskRating") where x.IssueId == issueId && x.IssueRiskType.Id == (int)riskTypeId select x).ToList(); foreach (IssueRisk issueRisk in issueRisks) { if (issueRisk.IssueRiskMatrix.RiskRatingNumber > highestRating) { highestRating = issueRisk.IssueRiskMatrix.RiskRatingNumber; highestRisk = issueRisk; } } } if (highestRisk != null) { return String.Format("{0} - {1}", highestRating, highestRisk.IssueRiskMatrix.IssueRiskRating.Name); } return "-"; }
private static StringBuilder BuildCategories(Issue issue) { using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { //Details - CATEGORIES IList<IssueAssignedCategory> issueCategories = (from p in cee.IssueAssignedCategories.Include("IssueCategory") where p.Issue.Id == issue.Id select p).ToList(); StringBuilder sb = new StringBuilder(); for (int index = 0; index < issueCategories.Count; index++) { IssueAssignedCategory assignedCategory = issueCategories[index]; sb.Append(assignedCategory.IssueCategory.Name); if (index < issueCategories.Count) { sb.Append(", "); } } return sb; } }
private static StringBuilder BuildAreas(Issue issue) { using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { //Details - AREAS IList<IssueArea> issueAreas = (from p in cee.IssueAreas.Include("Area") where p.IssueId == issue.Id select p).ToList(); StringBuilder sb = new StringBuilder(); for (int index = 0; index < issueAreas.Count; index++) { IssueArea issueArea = issueAreas[index]; sb.Append(issueArea.Area.Name); if (index < issueAreas.Count) { sb.Append(", "); } } return sb; } }
private static string BuildActionsAssignedToText(int issueId) { using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { cee.ContextOptions.LazyLoadingEnabled = true; string[] list = (from x in cee.IssueRelatedActions where x.IssueId == issueId orderby x.AssignedToUser.LastName select x.AssignedToUser.FirstName + " " + x.AssignedToUser.LastName).Distinct().ToArray(); string joined = string.Join(", ", list); return joined; } }