public async Task <CheckLists> UpdateCheckList(CheckLists list)
{
using (IDbConnection conn = Connection){
CheckLists _list = new CheckLists {
CHECKLISTID = list.CHECKLISTID,
TITLE = list.TITLE,
USERID = list.USERID,
CARDID = list.CARDID
};
var _params = new DynamicParameters();
_params.Add("@title", _list.TITLE);
_params.Add("@userid", _list.USERID);
_params.Add("@cardid", _list.CARDID);
_params.Add("@checklistid", _list.CHECKLISTID);
string sQuery = @"update CHECKLISTS set ";
sQuery += " TITLE=@title, ";
sQuery += " CARDID=@CARDID, ";
sQuery += " USERID=@USERID ";
sQuery += " where CHECKLISTID=@checklistid";
var affectedRows = await conn.ExecuteAsync(sQuery, _params);
if (affectedRows == 0)
{
return(null);
}
return(_list);
}
}
protected override List <CustomCell> GetListViewSubItems(CheckLists item)
{
var author = GlobalObjects.CaaEnvironment?.GetCorrector(item);
var subItems = new List <CustomCell>()
{
CreateRow(item.RevisionStatus.ToString(), item.RevisionStatus),
CreateRow(item.Source, item.Source),
CreateRow(item.SettingsIcao.AnnexRef, item.SettingsIcao.AnnexRef),
CreateRow(item.SettingsIcao.PartNumber, item.SettingsIcao.PartNumber),
CreateRow(item.SettingsIcao.PartName, item.SettingsIcao.PartName),
CreateRow(item.SettingsIcao.ChapterNumber, item.SettingsIcao.ChapterName),
CreateRow(item.SettingsIcao.ChapterName, item.SettingsIcao.ChapterName),
CreateRow(item.SettingsIcao.ItemNumber, item.SettingsIcao.ItemNumber),
CreateRow(item.SettingsIcao.ItemtName, item.SettingsIcao.ItemtName),
CreateRow(item.SettingsIcao.Standard, item.SettingsIcao.Standard),
CreateRow(item.Level.ToString(), item.Level),
CreateRow(item.EditionNumber.ToString(), item.EditionNumber),
CreateRow(item.RevisionNumber.ToString(), item.RevisionNumber),
CreateRow(item.Changes, item.Changes),
CreateRow(author, author),
};
return(subItems);
}
protected override List <CustomCell> GetListViewSubItems(CheckLists item)
{
var author = GlobalObjects.CaaEnvironment?.GetCorrector(item);
var subItems = new List <CustomCell>()
{
CreateRow(item.RevisionStatus.ToString(), item.RevisionStatus),
CreateRow(item.Settings.SectionNumber, item.Settings.SectionNumber),
CreateRow(item.Settings.SectionName, item.Settings.SectionName),
CreateRow(item.Settings.PartNumber, item.Settings.PartNumber),
CreateRow(item.Settings.PartName, item.Settings.PartName),
CreateRow(item.Settings.SubPartNumber, item.Settings.SubPartNumber),
CreateRow(item.Settings.SubPartName, item.Settings.SubPartName),
CreateRow(item.Settings.ItemNumber, item.Settings.ItemNumber),
CreateRow(item.Settings.ItemtName, item.Settings.ItemtName),
CreateRow(item.Settings.Requirement, item.Settings.Requirement),
CreateRow("", ""),
CreateRow(item.Source, item.Source),
CreateRow(item.Level.ToString(), item.Level),
CreateRow(item.EditionNumber.ToString(), item.EditionNumber),
CreateRow(item.RevisionNumber.ToString(), item.RevisionNumber),
CreateRow(item.Changes, item.Changes),
CreateRow(author, author)
};
return(subItems);
}
protected override IEnumerable <string> MergeDependencies(IJsonCard json, bool overwrite)
{
var properties = BadgesContext.Merge(json.Badges, overwrite)
.Select(p => $"{nameof(Card.Badges)}.{p}")
.ToList();
if (json.Actions != null)
{
Actions.Update(json.Actions.Select(a => a.GetFromCache <Action, IJsonAction>(Auth, overwrite)));
properties.Add(nameof(Card.Actions));
}
if (json.Attachments != null)
{
Attachments.Update(json.Attachments.Select(a => a.TryGetFromCache <Attachment, IJsonAttachment>(overwrite) ?? new Attachment(a, Data.Id, Auth)));
properties.Add(nameof(Card.Attachments));
}
if (json.CheckLists != null)
{
CheckLists.Update(json.CheckLists.Select(a => a.GetFromCache <CheckList, IJsonCheckList>(Auth, overwrite)));
properties.Add(nameof(Card.CheckLists));
}
if (json.Comments != null)
{
Comments.Update(json.Comments.Select(a => a.GetFromCache <Action, IJsonAction>(Auth, overwrite)));
properties.Add(nameof(Card.Comments));
}
if (json.CustomFields != null)
{
CustomFields.Update(json.CustomFields.Select(a => a.GetFromCache <CustomField, IJsonCustomField>(Auth, overwrite, Data.Id)));
properties.Add(nameof(Card.CustomFields));
}
if (json.Labels != null)
{
Labels.Update(json.Labels.Select(a => a.GetFromCache <Label, IJsonLabel>(Auth, overwrite)));
properties.Add(nameof(Card.Labels));
}
if (json.Members != null)
{
Members.Update(json.Members.Select(a => a.GetFromCache <Member, IJsonMember>(Auth, overwrite)));
properties.Add(nameof(Card.Members));
}
if (json.PowerUpData != null)
{
PowerUpData.Update(json.PowerUpData.Select(a => a.GetFromCache <PowerUpData, IJsonPowerUpData>(Auth, overwrite)));
properties.Add(nameof(Card.PowerUpData));
}
if (json.Stickers != null)
{
Stickers.Update(json.Stickers.Select(a => a.TryGetFromCache <Sticker, IJsonSticker>(overwrite) ?? new Sticker(a, Data.Id, Auth)));
properties.Add(nameof(Card.Stickers));
}
if (json.MembersVoted != null)
{
VotingMembers.Update(json.MembersVoted.Select(a => a.GetFromCache <Member, IJsonMember>(Auth, overwrite)));
properties.Add(nameof(Card.VotingMembers));
}
return(properties);
}
protected override List <CustomCell> GetListViewSubItems(CheckLists item)
{
var author = GlobalObjects.CaaEnvironment?.GetCorrector(item);
var condition = "Unknown";
var root = "";
var status = WorkFlowStatus.Unknown;
if (item.AuditCheck != null)
{
root = item.AuditCheck.Settings.RootCause;
status = WorkFlowStatus.GetItemById(item.AuditCheck.Settings.WorkflowStatusId);
if (item.AuditCheck.Settings.IsApplicable.HasValue && item.AuditCheck.Settings.IsApplicable.Value)
{
condition = "Not Applicable";
}
else
{
if (item.AuditCheck.Settings.IsSatisfactory.HasValue)
{
if (item.AuditCheck.Settings.IsSatisfactory.Value)
{
condition = "Satisfactory";
}
else
{
condition = "Not Satisfactory";
}
}
}
}
var subItems = new List <CustomCell>()
{
CreateRow(item.Settings.SectionNumber, item.Settings.SectionNumber),
CreateRow(item.Settings.SectionName, item.Settings.SectionName),
CreateRow(item.Settings.PartNumber, item.Settings.PartNumber),
CreateRow(item.Settings.PartName, item.Settings.PartName),
CreateRow(item.Settings.SubPartNumber, item.Settings.SubPartNumber),
CreateRow(item.Settings.SubPartName, item.Settings.SubPartName),
CreateRow(item.Settings.ItemNumber, item.Settings.ItemNumber),
CreateRow(item.Settings.Requirement, item.Settings.Requirement),
CreateRow(item.Level.ToString(), item.Level),
CreateRow(condition, condition),
CreateRow(root, root),
CreateRow(status.ToString(), status),
CreateRow(author, author)
};
return(subItems);
}
public CheckListCAPForm(CheckLists currentCheck, int auditId, bool editable = false)
{
_currentCheck = currentCheck;
_auditId = auditId;
InitializeComponent();
_animatedThreadWorker.DoWork += AnimatedThreadWorkerDoLoad;
_animatedThreadWorker.RunWorkerCompleted += BackgroundWorkerRunWorkerLoadCompleted;
_animatedThreadWorker.RunWorkerAsync();
}
public CheckListSAFAForm(CheckLists currentCheck, bool enable = true) : this()
{
_currentCheck = currentCheck;
_enable = enable;
_animatedThreadWorker.DoWork += AnimatedThreadWorkerDoLoad;
_animatedThreadWorker.RunWorkerCompleted += BackgroundWorkerRunWorkerLoadCompleted;
_animatedThreadWorker.RunWorkerAsync();
EnabledControls(enable);
}
protected override List <CustomCell> GetListViewSubItems(CheckLists item)
{
var author = GlobalObjects.CaaEnvironment?.GetCorrector(item);
var auditor = Specialist.Unknown.FirstName;
var auditee = Specialist.Unknown.FirstName;
var current = "";
var status = WorkFlowStatus.Unknown;
var stage = WorkFlowStage.Unknown;
if (item.AuditCheck != null)
{
status = WorkFlowStatus.GetItemById(item.AuditCheck.Settings.WorkflowStatusId);
stage = WorkFlowStage.GetItemById(item.AuditCheck.Settings.WorkflowStageId);
}
if (item.PelRecord != null)
{
auditor = $"{item.PelRecord?.Auditor.FirstName} {item.PelRecord?.Auditor.LastName}";
auditee = $"{item.PelRecord?.Auditee.FirstName} {item.PelRecord?.Auditee.LastName}";
if (item.PelRecord?.CurrentAuditor != null)
{
current = $"{item.PelRecord?.CurrentAuditor.FirstName} {item.PelRecord?.CurrentAuditor.LastName}";
}
else
{
current = $"My Tasks";
}
}
var subItems = new List <CustomCell>()
{
CreateRow(item.Source, item.Source),
CreateRow(item.SettingsIcao.AnnexRef, item.SettingsIcao.AnnexRef),
CreateRow(item.SettingsIcao.PartNumber, item.SettingsIcao.PartNumber),
CreateRow(item.SettingsIcao.PartName, item.SettingsIcao.PartName),
CreateRow(item.SettingsIcao.ChapterNumber, item.SettingsIcao.ChapterName),
CreateRow(item.SettingsIcao.ChapterName, item.SettingsIcao.ChapterName),
CreateRow(item.SettingsIcao.ItemNumber, item.SettingsIcao.ItemNumber),
CreateRow(item.SettingsIcao.ItemtName, item.SettingsIcao.ItemtName),
CreateRow(item.SettingsIcao.Standard, item.SettingsIcao.Standard),
CreateRow(item.Level.ToString(), item.Level),
CreateRow(stage.ToString(), stage),
CreateRow(status.ToString(), status),
CreateRow(auditor, item.PelRecord?.Auditor),
CreateRow(auditee, item.PelRecord?.Auditee),
CreateRow(current, item.PelRecord?.CurrentAuditor),
CreateRow(author, author),
};
return(subItems);
}
private void AnimatedThreadWorkerDoLoad(object sender, DoWorkEventArgs e)
{
if (_currentCheck == null)
{
return;
}
_currentCheck =
GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListDTO, CheckLists>(_currentCheck.ItemId);
_currentCheck.EditionNumber = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListRevisionDTO, CheckListRevision>(_currentCheck.EditionId)?.Number.ToString() ?? "";
if (_currentCheck.RevisionId.HasValue)
{
_currentCheck.RevisionNumber = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListRevisionDTO, CheckListRevision>(_currentCheck.RevisionId.Value)?.Number.ToString() ?? "";
}
_currentAuditCheck =
GlobalObjects.CaaEnvironment.NewLoader.GetObject <AuditCheckDTO, AuditCheck>(new List <Filter>()
{
new Filter("AuditId", _auditId),
new Filter("CheckListId", _currentCheck.ItemId),
});
if (_currentAuditCheck == null)
{
_currentAuditCheck = new AuditCheck()
{
CheckListId = _currentCheck.ItemId,
AuditId = _auditId
};
GlobalObjects.CaaEnvironment.NewKeeper.Save(_currentAuditCheck);
}
var records =
GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <CheckListRecordDTO, CheckListRecords>(
new Filter("CheckListId", _currentCheck.ItemId));
_currentCheck.CheckListRecords.Clear();
_currentCheck.CheckListRecords.AddRange(records);
_currentCheck.Level = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <FindingLevelsDTO, FindingLevels>(_currentCheck.Settings.LevelId) ??
FindingLevels.Unknown;
var record = GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <AuditPelRecordDTO, AuditPelRecord>(new List <Filter>()
{
new Filter("AuditId", _auditId),
new Filter("CheckListId", _currentAuditCheck.CheckListId),
});
var pel = record.FirstOrDefault();
_auditor = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <PelSpecialistDTO, PelSpecialist>(pel.AuditorId);
}
public CheckListAuditForm(CheckLists currentCheck, int auditId, bool editable = false)
{
InitializeComponent();
_currentCheck = currentCheck;
_auditId = auditId;
_editable = editable;
ButtonWf.Visible = _editable;
button1.Visible = _editable;
_animatedThreadWorker.DoWork += AnimatedThreadWorkerDoLoad;
_animatedThreadWorker.RunWorkerCompleted += BackgroundWorkerRunWorkerLoadCompleted;
_animatedThreadWorker.RunWorkerAsync();
}
protected override List <CustomCell> GetListViewSubItems(CheckLists item)
{
var author = GlobalObjects.CaaEnvironment?.GetCorrector(item);
var subItems = new List <CustomCell>()
{
CreateRow(item.Source, item.Source),
CreateRow(item.SettingsSafa.Item, item.SettingsSafa.Item),
CreateRow(item.SettingsSafa.Title, item.SettingsSafa.Title),
CreateRow(item.SettingsSafa.Standard, item.SettingsSafa.Standard),
CreateRow(item.SettingsSafa.StandardRef, item.SettingsSafa.StandardRef),
CreateRow(item.SettingsSafa.PdfCode, item.SettingsSafa.PdfCode),
CreateRow(author, author)
};
return(subItems);
}
public CheckListSAFARevEditForm(CheckLists check, CheckListRevision revision)
{
InitializeComponent();
_currentCheck = check;
_revision = revision;
UpdateInformation();
if (_revision.Status == EditionRevisionStatus.Current || _revision.Status == EditionRevisionStatus.Previous)
{
foreach (var c in this.Controls.OfType <Control>().Where(i => !(i.GetType() == typeof(Button))))
{
if (c.GetType().ToString() == "MetroFramework.Forms.MetroForm+MetroFormButton")
{
continue;
}
c.Enabled = false;
}
}
}
protected override List <CustomCell> GetListViewSubItems(CheckLists item)
{
var author = GlobalObjects.CaaEnvironment?.GetCorrector(item);
var subItems = new List <CustomCell>()
{
CreateRow(item.RevisionStatus.ToString(), item.RevisionStatus),
CreateRow(item.Source, item.Source),
CreateRow(item.SettingsSafa.Item, item.SettingsSafa.Item),
CreateRow(item.SettingsSafa.Title, item.SettingsSafa.Title),
CreateRow(item.SettingsSafa.Standard, item.SettingsSafa.Standard),
CreateRow(item.SettingsSafa.StandardRef, item.SettingsSafa.StandardRef),
CreateRow(item.SettingsSafa.PdfCode, item.SettingsSafa.PdfCode),
CreateRow(item.Level.ToString(), item.Level),
CreateRow(item.EditionNumber.ToString(), item.EditionNumber),
CreateRow(item.RevisionNumber.ToString(), item.RevisionNumber),
CreateRow(item.Changes, item.Changes),
CreateRow(author, author)
};
return(subItems);
}
public async Task <CheckLists> AddCheckList(CheckLists list)
{
using (IDbConnection conn = Connection){
CheckLists _list = new CheckLists {
CHECKLISTID = -1,
TITLE = list.TITLE,
USERID = list.USERID,
CARDID = list.CARDID,
ITEMS = new List <CheckListItems>()
};
var _params = new DynamicParameters();
_params.Add("@title", _list.TITLE);
_params.Add("@userid", _list.USERID);
_params.Add("@cardid", _list.CARDID);
_params.Add(name: "@v_checklistid", value: _list.CHECKLISTID, dbType: DbType.Int64,
direction: ParameterDirection.InputOutput);
string sQuery = @" begin ";
sQuery += " insert into CHECKLISTS(TITLE,USERID,CARDID) values (@title,@userid,@cardid) ";
sQuery += " set @v_checklistid=SCOPE_IDENTITY()";
sQuery += " end ";
//try{
var affectedRows = await conn.ExecuteAsync(sQuery, _params);
if (affectedRows > 0)
{
Int64 newListId = _params.Get <Int64>("@v_checklistid");
_list.CHECKLISTID = newListId;
}
// }catch(Exception ex){
// return null;
// }
return(_list);
}
}
public async Task <ActionResult <CheckLists> > UpdateCheckList([FromBody] CheckLists model)
{
var _list = new CheckLists
{
CHECKLISTID = model.CHECKLISTID,
TITLE = model.TITLE,
CARDID = model.CARDID,
USERID = model.USERID
};
var result = await _lists.UpdateCheckList(_list);
if (result == null)
{
return(BadRequest("Record is not updated 1"));
}
if (result.CHECKLISTID == -1)
{
return(BadRequest("Record is not updated 2"));
}
return(await Task.FromResult(_list));
}
public CheckListForm(CheckLists currentCheck, int revisionId) : this(currentCheck)
{
_revisionId = revisionId;
}
private void AnimatedThreadWorkerDoLoad(object sender, DoWorkEventArgs e)
{
if (_currentCheck == null)
{
return;
}
_fromList.Clear();
_toList.Clear();
_currentCheck = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListDTO, CheckLists>(_currentCheck.ItemId);
_currentCheck.EditionNumber = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListRevisionDTO, CheckListRevision>(_currentCheck.EditionId)?.Number.ToString() ?? "";
if (_currentCheck.RevisionId.HasValue)
{
_currentCheck.RevisionNumber = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListRevisionDTO, CheckListRevision>(_currentCheck.RevisionId.Value)?.Number.ToString() ?? "";
}
_currentAuditCheck =
GlobalObjects.CaaEnvironment.NewLoader.GetObject <AuditCheckDTO, AuditCheck>(new List <Filter>()
{
new Filter("AuditId", _auditId),
new Filter("CheckListId", _currentCheck.ItemId),
});
if (_currentAuditCheck == null)
{
_currentAuditCheck = new AuditCheck()
{
CheckListId = _currentCheck.ItemId,
AuditId = _auditId
};
GlobalObjects.CaaEnvironment.NewKeeper.Save(_currentAuditCheck);
}
var records =
GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <CheckListRecordDTO, CheckListRecords>(
new Filter("CheckListId", _currentCheck.ItemId));
_currentCheck.CheckListRecords.Clear();
_currentCheck.CheckListRecords.AddRange(records);
_currentCheck.Level = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <FindingLevelsDTO, FindingLevels>(_currentCheck.Settings.LevelId) ??
FindingLevels.Unknown;
var record = GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <AuditPelRecordDTO, AuditPelRecord>(new List <Filter>()
{
new Filter("AuditId", _auditId),
new Filter("CheckListId", _currentAuditCheck.CheckListId),
});
var pel = record.FirstOrDefault();
_auditor = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <PelSpecialistDTO, PelSpecialist>(pel.AuditorId);
var audit = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CAAAuditDTO, CAAAudit>(_auditId);
var roots = GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <RootCauseDTO, RootCause>(new Filter("OperatorId", new List <int>()
{
audit.OperatorId, AllOperators.Unknown.ItemId
}));
foreach (var root in roots)
{
if ((bool)_currentAuditCheck.Settings.RootCauseIds?.Any(i => i == root.ItemId))
{
_toList.Add(root);
}
else
{
_fromList.Add(root);
}
}
}
private void ButtonAddDisplayerRequested(object sender, ReferenceEventArgs e)
{
var check = new CheckLists
{
OperatorId = _operatorId,
ManualId = _manual.ItemId,
ProgramType = ProgramType.GetItemById(_manual.ProgramTypeId)
};
if (check.CheckUIType == CheckUIType.Iosa)
{
check.Settings = new CheckListSettings()
{
ProgramTypeId = _manual.ProgramType.ItemId
};
if (_parent.Type == RevisionType.Revision)
{
check.EditionId = -1;
var form = new CheckListForm.CheckListForm(check, _parent.ItemId);
if (form.ShowDialog() == DialogResult.OK)
{
AnimatedThreadWorker.RunWorkerAsync();
}
}
else
{
check.EditionId = _parent.ItemId;
var form = new CheckListForm.CheckListForm(check);
if (form.ShowDialog() == DialogResult.OK)
{
AnimatedThreadWorker.RunWorkerAsync();
}
}
}
else if (check.CheckUIType == CheckUIType.Safa)
{
check.SettingsSafa = new CheckListSettingsSAFA()
{
ProgramTypeId = _manual.ProgramType.ItemId
};
if (_parent.Type == RevisionType.Revision)
{
check.EditionId = -1;
var form = new CheckListForm.CheckListSAFAForm(check, _parent.ItemId);
if (form.ShowDialog() == DialogResult.OK)
{
AnimatedThreadWorker.RunWorkerAsync();
}
}
else
{
check.EditionId = _parent.ItemId;
var form = new CheckListForm.CheckListSAFAForm(check);
if (form.ShowDialog() == DialogResult.OK)
{
AnimatedThreadWorker.RunWorkerAsync();
}
}
}
else if (check.CheckUIType == CheckUIType.Icao)
{
check.SettingsIcao = new CheckListICAOSettings()
{
ProgramTypeId = _manual.ProgramType.ItemId
};
if (_parent.Type == RevisionType.Revision)
{
check.EditionId = -1;
var form = new CheckListForm.CheckListICAOForm(check, _parent.ItemId);
if (form.ShowDialog() == DialogResult.OK)
{
AnimatedThreadWorker.RunWorkerAsync();
}
}
else
{
check.EditionId = _parent.ItemId;
var form = new CheckListForm.CheckListICAOForm(check);
if (form.ShowDialog() == DialogResult.OK)
{
AnimatedThreadWorker.RunWorkerAsync();
}
}
}
else
{
MessageBox.Show($"For ProgramType:{_manual.ProgramType} form not found!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Cancel = true;
}
}
private void AnimatedThreadWorkerDoLoad(object sender, DoWorkEventArgs e)
{
if (_currentCheck == null)
{
return;
}
if (_currentCheck.AuditCheck.Settings.WorkflowStatusId == WorkFlowStatus.Open.ItemId &&
_currentCheck.AuditCheck.Settings.WorkflowStageId == WorkFlowStage.View.ItemId)
{
if (_currentCheck.PelRecord?.Auditor.ItemId == GlobalObjects.CaaEnvironment.IdentityUser.PersonnelId)
{
_currentCheck.AuditCheck.Settings.IsAuditorReview = true;
GlobalObjects.CaaEnvironment.NewKeeper.Save(_currentCheck.AuditCheck);
}
else if (_currentCheck.PelRecord?.Auditee.ItemId == GlobalObjects.CaaEnvironment.IdentityUser.PersonnelId)
{
_currentCheck.AuditCheck.Settings.IsAuditeeReview = true;
GlobalObjects.CaaEnvironment.NewKeeper.Save(_currentCheck.AuditCheck);
}
if (_currentCheck.AuditCheck.Settings.IsAuditorReview.HasValue && _currentCheck.AuditCheck.Settings.IsAuditeeReview.HasValue &&
_currentCheck.AuditCheck.Settings.IsAuditorReview.Value && _currentCheck.AuditCheck.Settings.IsAuditeeReview.Value)
{
_currentCheck.AuditCheck.Settings.WorkflowStatusId = WorkFlowStatus.Review.ItemId;
GlobalObjects.CaaEnvironment.NewKeeper.Save(_currentCheck.AuditCheck);
}
}
_currentCheck =
GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListDTO, CheckLists>(_currentCheck.ItemId);
_currentCheck.EditionNumber = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListRevisionDTO, CheckListRevision>(_currentCheck.EditionId)?.Number.ToString() ?? "";
if (_currentCheck.RevisionId.HasValue)
{
_currentCheck.RevisionNumber = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListRevisionDTO, CheckListRevision>(_currentCheck.RevisionId.Value)?.Number.ToString() ?? "";
}
_currentAuditCheck =
GlobalObjects.CaaEnvironment.NewLoader.GetObject <AuditCheckDTO, AuditCheck>(new List <Filter>()
{
new Filter("AuditId", _auditId),
new Filter("CheckListId", _currentCheck.ItemId),
});
if (_currentAuditCheck == null)
{
_currentAuditCheck = new AuditCheck()
{
CheckListId = _currentCheck.ItemId,
AuditId = _auditId
};
GlobalObjects.CaaEnvironment.NewKeeper.Save(_currentAuditCheck);
}
if (_currentAuditCheck.ItemId > 0)
{
_currentAuditCheckRecords = new List <AuditCheckRecord>(
GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <AuditCheckRecordDTO, AuditCheckRecord>(
new Filter("AuditRecordId", _currentAuditCheck.ItemId)));
}
else
{
_currentAuditCheckRecords = new List <AuditCheckRecord>();
}
var records =
GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <CheckListRecordDTO, CheckListRecords>(
new Filter("CheckListId", _currentCheck.ItemId));
foreach (var rec in records)
{
var find = _currentAuditCheckRecords.FirstOrDefault(i => i.CheckListRecordId == rec.ItemId);
if (find == null)
{
var newRecord = new AuditCheckRecord()
{
CheckListRecordId = rec.ItemId,
AuditRecordId = _currentAuditCheck.ItemId,
CheckListRecord = rec
};
GlobalObjects.CaaEnvironment.NewKeeper.Save(newRecord);
_currentAuditCheckRecords.Add(newRecord);
}
else
{
find.CheckListRecord = rec;
}
}
_currentCheck.CheckListRecords.Clear();
_currentCheck.CheckListRecords.AddRange(records);
_currentCheck.Level = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <FindingLevelsDTO, FindingLevels>(_currentCheck.Settings.LevelId) ??
FindingLevels.Unknown;
}
public virtual int Compare(GridViewRowInfo x, GridViewRowInfo y)
{
CheckLists xx = null;
CheckLists yy = null;
if (x.Tag is CheckLists)
{
xx = x.Tag as CheckLists;
}
if (y.Tag is CheckLists)
{
yy = y.Tag as CheckLists;
}
if (x.Tag is AuditPelRecord)
{
xx = (x.Tag as AuditPelRecord).CheckList;
}
if (y.Tag is AuditPelRecord)
{
yy = (y.Tag as AuditPelRecord).CheckList;
}
if (xx == null || y is null)
{
return(0);
}
if (xx.Settings == null || yy.Settings == null)
{
return(0);
}
var a = Regex.Replace($"{xx.SectionNumber}|{xx.PartNumber}|{xx.SubPartNumber}|{xx.ItemNumber}", @"\s+", " ");;
var b = Regex.Replace($"{yy.SectionNumber}|{yy.PartNumber}|{yy.SubPartNumber}|{yy.ItemNumber}", @"\s+", " ");;
var xParts = a.Split('|')
.SelectMany(i => i.Split(' '))
.SelectMany(i => i.Split('.'))
.ToArray();
var yParts = b.Split('|')
.SelectMany(i => i.Split(' '))
.SelectMany(i => i.Split('.'))
.ToArray();
xParts[xParts.Length - 1] = Regex.Replace(xParts[xParts.Length - 1], "[^0-9.]", "");
yParts[yParts.Length - 1] = Regex.Replace(yParts[yParts.Length - 1], "[^0-9.]", "");
var partsLength = Math.Max(xParts.Length, yParts.Length);
if (partsLength > 0)
{
for (var i = 0; i < partsLength; i++)
{
if (xParts.Length <= i)
{
return(-1); // 4.2 < 4.2.x
}
if (yParts.Length <= i)
{
return(1);
}
var xPart = xParts[i];
var yPart = yParts[i];
if (string.IsNullOrEmpty(xPart))
{
xPart = "0"; // 5..2->5.0.2
}
if (string.IsNullOrEmpty(yPart))
{
yPart = "0";
}
if (!int.TryParse(xPart, out var xInt) || !int.TryParse(yPart, out var yInt))
{
// 3.a.45 compare part as string
var abcCompare = xPart.CompareTo(yPart);
if (abcCompare != 0)
{
return(_sortMultiplier * abcCompare);
}
continue;
}
if (xInt != yInt)
{
return(_sortMultiplier * (xInt < yInt ? -1 : 1));
}
}
return(_sortMultiplier * -1);
//return 0;
}
// compare as string
return(_sortMultiplier * xx.CompareTo(yy));
}
public CheckListSAFAForm(CheckLists currentCheck, int revisionId) : this(currentCheck, true)
{
_revisionId = revisionId;
}
private void AnimatedThreadWorkerDoLoad(object sender, DoWorkEventArgs e)
{
_manual = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <StandartManualDTO, SmartCore.CAA.StandartManual.StandartManual>(_currentCheck.ManualId);
_levels.Clear();
_levels = GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <FindingLevelsDTO, FindingLevels>(new []
{
new Filter("OperatorId", _currentCheck.OperatorId),
new Filter("ProgramTypeId", _manual.ProgramTypeId),
});
if (_currentCheck == null)
{
return;
}
if (_currentCheck.ItemId > 0)
{
_currentCheck = GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListDTO, CheckLists>(_currentCheck.ItemId);
_currentCheck.AllRevisions.Clear();
var edition =
GlobalObjects.CaaEnvironment.NewLoader.GetObjectById <CheckListRevisionDTO, CheckListRevision>(_currentCheck.EditionId);
if (edition != null)
{
_currentCheck.AllRevisions.Add(new EditionRevisionView()
{
Date = edition.Date,
Number = edition.Number,
Remark = edition.Settings.Remark,
Type = edition.Type,
EffDate = edition.EffDate
});
}
var revisionRec = GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <CheckListRevisionRecordDTO, CheckListRevisionRecord>(new Filter("CheckListId", _currentCheck.ItemId));
if (revisionRec.Any())
{
var ids = revisionRec.Select(i => i.ParentId);
var revisions = GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <CheckListRevisionDTO, CheckListRevision>(new Filter("ItemId", ids));
foreach (var rec in revisionRec)
{
var revision = revisions.FirstOrDefault(i => i.ItemId == rec.ParentId);
if (revision == null)
{
continue;
}
_currentCheck.AllRevisions.Add(new EditionRevisionView()
{
Date = revision.Date,
Number = revision.Number,
Remark = string.Join(",", rec.Settings.ModData.OrderBy(i => i.Key).Select(i => i.Key)),
Type = revision.Type,
EffDate = revision.EffDate
});
}
}
var links = GlobalObjects.CaaEnvironment.NewLoader.GetObjectListAll <CAAItemFileLinkDTO, ItemFileLink>(new List <Filter>()
{
new Filter("ParentId", _currentCheck.ItemId),
new Filter("ParentTypeId", _currentCheck.SmartCoreObjectType.ItemId)
}, true);
var fileIds = links.Where(i => i.FileId.HasValue).Select(i => i.FileId.Value);
if (fileIds.Any())
{
var files = GlobalObjects.CaaEnvironment.NewLoader.GetObjectList <CAAAttachedFileDTO, AttachedFile>(new Filter("ItemId", values: fileIds));
foreach (var file in links)
{
var f = files.FirstOrDefault(i => i.ItemId == file.FileId)?.GetCopyUnsaved(false);
if (f == null)
{
continue;
}
f.ItemId = file.FileId.Value;
file.File = (AttachedFile)f;
}
}
_currentCheck.Files = new CommonCollection <ItemFileLink>(links);
_currentCheck.Level = _levels.FirstOrDefault(i => i.ItemId == _currentCheck.SettingsSafa.LevelId) ??
FindingLevels.Unknown;
}
}
public int Compare(Group <GridViewRowInfo> x, Group <GridViewRowInfo> y)
{
var xx = x.GetItems().FirstOrDefault()?.Tag;
var yy = y.GetItems().FirstOrDefault()?.Tag;
if (xx != null && yy != null)
{
CheckLists xxx = null;
CheckLists yyy = null;
if (xx is CheckLists)
{
xxx = xx as CheckLists;
}
if (yy is CheckLists)
{
yyy = yy as CheckLists;
}
if (xx is AuditPelRecord)
{
xxx = (xx as AuditPelRecord).CheckList;
}
if (yy is AuditPelRecord)
{
yyy = (yy as AuditPelRecord).CheckList;
}
if (xx == null || y is null)
{
return(0);
}
var xParts = xxx.Group;
var yParts = yyy.Group;
var partsLength = Math.Max(xParts.Length, yParts.Length);
if (partsLength > 0)
{
for (var i = 0; i < partsLength; i++)
{
if (xParts.Length <= i)
{
return(-1); // 4.2 < 4.2.x
}
if (yParts.Length <= i)
{
return(1);
}
var xPart = xParts[i];
var yPart = yParts[i];
if (string.IsNullOrEmpty(xPart))
{
xPart = "0"; // 5..2->5.0.2
}
if (string.IsNullOrEmpty(yPart))
{
yPart = "0";
}
if (!int.TryParse(xPart, out var xInt) || !int.TryParse(yPart, out var yInt))
{
// 3.a.45 compare part as string
var abcCompare = xPart.CompareTo(yPart);
if (abcCompare != 0)
{
return(-1 * abcCompare);
}
continue;
}
if (xInt != yInt)
{
return(xInt < yInt ? -1 : 1);
}
}
return(0);
}
}
return(-1);
//return ((object[])x.Key)[0].ToString().CompareTo(((object[])y.Key)[0].ToString());
}
