private void Save()
{
if (AtMng.DB.Issue.HasErrors)
{
UIHelper.TableHasErrorsOnSaveMessBox(AtMng.DB);
}
else
{
try
{
string nodeKey = CurrentRow().IssueId.ToString();
SaveRtfValues();
this.issueBindingSource1.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetIssue());
bp.Update();
//LoadRoot();
setCurrentNode(nodeKey);
inEditMode = false;
lblRtfEdited.Visible = false;
SetRTFValues(false);
//TreeNode[] tn=treeView1.Nodes.Find(CurrentRow().ParentIssueId.ToString(), true);
//TreeNode nd = treeView1.SelectedNode;
//nd.Remove();
//tn[0].Nodes.Add(nd);
}
catch (Exception x)
{
throw x;
}
}
}
private void Delete()
{
try
{
if (UIHelper.ConfirmDelete())
{
CurrentRow().Delete();
this.issueBindingSource1.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetIssue());
bp.Update();
lmDatasets.appDB.IssueRow ir = (lmDatasets.appDB.IssueRow)treeView1.SelectedNode.PrevNode.Tag;
treeView1.SelectedNode.Remove();
setBindingSourcePosition(ir.IssueId);
setCurrentNode(ir.IssueId.ToString());
//treeView1.Enabled = true;
//LoadRoot();
}
}
catch (Exception x)
{
throw x;
}
}
private void Save()
{
if (AtMng.DB.Template.HasErrors || myDM.DB.Document.HasErrors)
{
UIHelper.TableHasErrorsOnSaveMessBox(AtMng.DB);
}
else
{
try
{
this.templateBindingSource.EndEdit();
ucDoc1.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetTemplate());
bp.AddForUpdate(myDM.GetDocContent());
bp.AddForUpdate(myDM.GetDocument());
bp.Update();
EditDocContents(false);
templateGridEX.Focus();
//causes currentchanged on binding source to fire - changing order
//Atmng.DB.Template.AcceptChanges();
//myDM.DB.Document.AcceptChanges();
//myDM.DB.DocContent.AcceptChanges();
}
catch (Exception x)
{
throw new Exception("Transaction Rolled Back", x);
}
}
}
private void AddExtensionToFileFormatTable(string ext, docDB.FileFormatDataTable ffTable)
{
if (obe == null)
{
obe = AtMng.GetCodeTableBE("FileFormat");
obe.Load();
}
CodesDB.FileFormatRow ffRow = (CodesDB.FileFormatRow)obe.Add(null);
ffRow.AllowEdit = false;
ffRow.AllowPreview = false;
ffRow.AllowSearch = true;
ffRow.AllowUpload = true;
ffRow.FileDescEng = "Lotus Notes Import";
ffRow.FileDescFre = "Lotus Notes Import";
ffRow.FileFormat = ext;
ffRow.IsBinary = false;
ffRow.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(obe);
bp.Update();
ffTable.ImportRow(ffRow);
}
private bool Save()
{
try
{
if (MessageBox.Show("All edits (to all records) will be saved. Are you sure you want to proceed?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
ucBFCode1.EndEdit();
aCBFBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.acMng.GetACBF());
bp.Update();
return(true);
}
else
{
return(false);
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
return(false);
}
}
private void Delete()
{
try
{
if (UIHelper.ConfirmDelete())
{
docDB.DocumentRow dr = AtMng.GetTemplate().GetTemplateDoc(CurrentRow());
CurrentRow().Delete();
if (dr != null)
{
dr.Delete();
}
this.templateBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetTemplate());
bp.AddForUpdate(myDM.GetDocContent());
bp.AddForUpdate(myDM.GetDocument());
bp.Update();
}
}
catch (Exception x)
{
throw new Exception("Transaction Rolled Back", x);
}
}
private void Save()
{
try
{
if (MessageBox.Show("All edits (to all records) will be saved. Are you sure you want to proceed?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
ddLookupGridEX.CurrentRow.EndEdit();
ddLookupGridEX.UpdateData();
ddLookupBindingSource.EndEdit();
if (ddGenericGridEX.CurrentRow != null)
{
ddGenericGridEX.CurrentRow.EndEdit();
}
ddGenericGridEX.UpdateData();
ddGenericBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetddLookup());
bp.AddForUpdate(AtMng.GetddGeneric());
bp.Update();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void Save()
{
if (AtMng.DB.Legislation.HasErrors || AtMng.DB.Provision.HasErrors)
{
UIHelper.TableHasErrorsOnSaveMessBox(AtMng.DB);
}
else
{
try
{
SaveRtfValues();
legislationBindingSource.EndEdit();
provisionBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetLegislation());
bp.AddForUpdate(AtMng.GetProvision());
bp.Update();
setEditMode(false);
SetRTFValues(false);
}
catch (Exception x)
{
throw x;
}
}
}
private void Delete()
{
try
{
if (MessageBox.Show("Your current selection will be deleted. Are you sure you want to proceed?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
int gridPos = activityCodeGridEX.CurrentRow.Position;
CurrentRow().Delete();
if (gridPos > activityCodeGridEX.RowCount)
{
activityCodeGridEX.Row = activityCodeGridEX.RowCount;
}
else
{
activityCodeGridEX.Row = gridPos;
}
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.acMng.GetActivityCode());
bp.Update();
}
else
{
return;
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
return;
}
}
private void Save()
{
cGridEX.CurrentRow.EndEdit();
cGridEX.UpdateData();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(obe);
bp.Update();
}
private void Save()
{
provinceGridEX.CurrentRow.EndEdit();
provinceGridEX.UpdateData();
provinceGridEX.Update();
provinceBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetProvince());
bp.AddForUpdate(AtMng.GetCity());
bp.Update();
}
private void pLOfficeBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
try
{
pLOfficeGridEX.CurrentRow.EndEdit();
pLOfficeGridEX.UpdateData();
pLOfficeBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetPLOffice());
bp.Update();
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void Delete()
{
try
{
if (MessageBox.Show("Are you sure you want to delete this Batch Review record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
CurrentRow().Delete();
batchBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetBatch());
bp.Update();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void Delete()
{
try
{
if (UIHelper.ConfirmDelete())
{
CurrentRow().Delete();
pLOfficeBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetPLOffice());
bp.Update();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void UpdateTemplates(TemplateExchange tex)
{
atriumBE.ACManager.ImportTable(myDM.DB.Document, tex.drs);
//need to load doccontent records
foreach (docDB.DocContentRow dcr in tex.dcrs)
{
myDM.GetDocContent().Load(dcr.DocId, null);// myDM.DB.Document.FindByDocId(dcr.DocId).CurrentVersion); //WI 73696 - added current version
}
atriumBE.ACManager.ImportTable(myDM.DB.DocContent, tex.dcrs);
atriumBE.ACManager.ImportTable(AtMng.DB.Template, tex.trs);
atLogic.BusinessProcess bpD = AtMng.GetBP();
bpD.AddForUpdate(myDM.DB.DocContent);
bpD.AddForUpdate(myDM.DB.Document);
bpD.AddForUpdate(AtMng.DB.Template);
bpD.Update();
}
private void Delete()
{
try
{
lmDatasets.ActivityConfig.ACMenuRow acmr = CurrentRow();
if (CurrentRow() == null)
{
return;
}
if (!AtMng.acMng.GetACMenu().CanDelete(acmr))
{
MessageBox.Show("Not Allowed to Delete", "Deleting Quick Menu", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (!UIHelper.ConfirmDelete())
{
return;
}
else
{
try
{
acmr.Delete();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.acMng.GetACMenu());
bp.Update();
}
catch (Exception x1)
{
AtMng.acMng.DB.ACMenu.RejectChanges();
throw x1;
}
}
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
public void CreateBatchRecord(List <DataRow> rowList)
{
foreach (DataRow dr in rowList)
{
MemberManagement.TribunalMemberAssignmentRow tmar = (MemberManagement.TribunalMemberAssignmentRow)dr;
if (!tmar.IsTentativeMemberIdNull())
{
tmar.ReadyToAssignDate = DateTime.Now;
lmDatasets.appDB.BatchRow br = (lmDatasets.appDB.BatchRow)AtMng.GetBatch().Add(null);
br.JobName = "CreateAC";
br.Parameters = String.Format("{0},{1},{2},{3},{4}", tmar.FileId, AtMng.GetSetting(AppIntSetting.AssignedVCAcId), DateTime.Today.ToString("yyyy-MM-dd"), "SSTDecision", tmar.SSTDecisionId);
}
}
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetBatch());
bp.AddForUpdate(GetTribunalMemberAssignment());
bp.Update();
}
private void Save()
{
if (AtMng.DB.Msg.HasErrors)
{
UIHelper.TableHasErrorsOnSaveMessBox(AtMng.DB);
}
else
{
try
{
msgBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetMsg());
bp.Update();
}
catch (Exception x)
{
throw x;
}
}
}
private void Save()
{
if (AtMng.DB.PLOffice.HasErrors)
{
UIHelper.TableHasErrorsOnSaveMessBox(AtMng.DB);
}
else
{
try
{
pLOfficeBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetPLOffice());
bp.Update();
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
}
private void Delete()
{
try
{ //not called
if (UIHelper.ConfirmDelete())
{
CurrentRow().Delete();
legislationBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetLegislation());
bp.AddForUpdate(AtMng.GetProvision());
bp.Update();
}
}
catch (Exception x)
{
throw x;
}
}
private void Save()
{
try
{
if (MessageBox.Show("All edits (to all records) will be saved. Are you sure you want to proceed?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
if (ddTableGridEX.CurrentRow != null)
{
ddTableGridEX.CurrentRow.EndEdit();
}
ddTableGridEX.UpdateData();
ddTableBindingSource.EndEdit();
if (ddFieldGridEX.CurrentRow != null)
{
ddFieldGridEX.CurrentRow.EndEdit();
}
ddFieldGridEX.UpdateData();
ddFieldBindingSource.EndEdit();
ddRuleBindingSource.EndEdit();
ddTableRuleBS.EndEdit();
aCDocumentationBindingSource.EndEdit();
ddFieldRuleMSg.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetddTable());
bp.AddForUpdate(AtMng.GetddField());
bp.AddForUpdate(AtMng.GetddRule());
bp.AddForUpdate(AtMng.acMng.GetACDocumentation());
bp.Update();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void Delete()
{
try
{
if (UIHelper.ConfirmDelete())
{
if (CurrentRow() != null)
{
CurrentRow().Delete();
}
this.office2JDBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.OfficeMng.GetOffice2JD());
bp.Update();
}
}
catch (Exception x)
{
throw x;
}
}
private void Save()
{
if (AtMng.acMng.DB.ACMenu.HasErrors)
{
UIHelper.TableHasErrorsOnSaveMessBox(AtMng.acMng.DB);
}
else
{
try
{
aCMenuGridEX.UpdateData();
aCMenuBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.acMng.GetACMenu());
bp.Update();
}
catch (Exception x)
{
throw x;
}
}
}
private void Save()
{
if (AtMng.DB.Batch.HasErrors)
{
MessageBox.Show("Cannot save while there are errors in the data.");
}
else
{
try
{
batchGridEX.UpdateData();
batchBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetBatch());
bp.Update();
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
}
private bool Save()
{
try
{
if (MessageBox.Show("All edits (to all records) will be saved. Are you sure you want to proceed?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
ucActivityCode1.EndEdit();
activityCodeBindingSource.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.acMng.GetActivityCode());
bp.Update();
pnlActivitiesList.Closed = false;
if (NewAcId != 0)
{
activityCodeBindingSource.Position = activityCodeBindingSource.Find("ActivityCodeID", NewAcId);
NewAcId = 0;
}
return(true);
}
else
{
return(false);
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
return(false);
}
}
public void ImportConfig(string file)
{
//this method provides a mechanism for moving config data from one install to another
ActivityConfig newConfig = new ActivityConfig();
newConfig.ReadXml(file);
if (newConfig.ACSeries.Count == 0)
{
throw new atLogic.AtriumException("The file you tried to import is not an Activity Config export.");
}
bool okToDelete = AtMng.GetSetting(AppBoolSetting.AllowActivityDeleteOnConfigPush);
try
{
AtMng.acMng.isMerging = true;
//process deletes
//check for used acseries first!
string filt = "";
string used = "";
foreach (ActivityConfig.ACSeriesRow trgDr in DB.ACSeries)
{
if (newConfig.ACSeries.PrimaryKey[0].DataType == typeof(string))
{
filt = newConfig.ACSeries.PrimaryKey[0].ColumnName + "='" + trgDr[newConfig.ACSeries.PrimaryKey[0].ColumnName].ToString() + "'";
}
else
{
filt = newConfig.ACSeries.PrimaryKey[0].ColumnName + "=" + trgDr[newConfig.ACSeries.PrimaryKey[0].ColumnName].ToString();
}
System.Data.DataRow[] srcDr = newConfig.ACSeries.Select(filt, "");
if (srcDr.Length == 0)
{
if (trgDr.StepType == (int)atriumBE.StepType.Activity)
{
int count = (int)AtMng.DALMngr.ExecuteScalarSQL("select count(*) from vactivity where acseriesid=" + trgDr.ACSeriesId.ToString());
if (count > 0)
{
if (okToDelete)
{
System.Data.DataTable dtA = AtMng.GetGeneralRec("select activityid,ts from vactivity where acseriesid=" + trgDr.ACSeriesId.ToString());
foreach (System.Data.DataRow drA in dtA.Rows)
{
AtMng.DALMngr.ExecuteSP("ActivityDelete", drA[0], null, drA[1]);
}
}
else
{
used += trgDr.StepCode + "; ";
}
}
}
//look in officemandate and remove
foreach (ActivityConfig.OfficeMandateRow omr in trgDr.GetOfficeMandateRows())
{
omr.Delete();
}
}
}
if (used.Length > 0)
{
DB.OfficeMandate.RejectChanges();
throw new Exception("The following steps have been used and can't be deleted:\n\r" + used);
}
DeleteFromTable(DB.Menu, newConfig.Menu);
DeleteFromTable(DB.ACTaskType, newConfig.ACTaskType);
DeleteFromTable(DB.OfficeMandate, newConfig.OfficeMandate);
DeleteFromTable(DB.ActivityField, newConfig.ActivityField);
DeleteFromTable(DB.ACDependency, newConfig.ACDependency);
DeleteFromTable(DB.ACBF, newConfig.ACBF);
DeleteFromTable(DB.ACFileType, newConfig.ACFileType);
DeleteFromTable(DB.ACConvert, newConfig.ACConvert);
DeleteFromTable(DB.ACMenu, newConfig.ACMenu);
DeleteFromTable(DB.ACDisb, newConfig.ACDisb);
DeleteFromTable(DB.ACSeries, newConfig.ACSeries);
DeleteFromTable(DB.ActivityCode, newConfig.ActivityCode);
DeleteFromTable(DB.Series, newConfig.Series);
DeleteFromTable(DB.ACMajor, newConfig.ACMajor);
DeleteFromTable(DB.ACDocumentation, newConfig.ACDocumentation);
DeleteFromTable(DB.ACControlType, newConfig.ACControlType);
DeleteFromTable(DB.ACDependencyType, newConfig.ACDependencyType);
DeleteFromTable(DB.ACSeriesType, newConfig.ACSeriesType);
DeleteFromTable(DB.SeriesPackage, newConfig.SeriesPackage);
DeleteFromTable(DB.SeriesStatus, newConfig.SeriesStatus);
//atLogic.BusinessProcess bpD = AtMng.GetBP();
//bpD.AddForUpdate(DB.OfficeMandate);
//bpD.AddForUpdate(DB.ActivityField);
//bpD.AddForUpdate(DB.ACDependency);
//bpD.AddForUpdate(DB.ACBF);
//bpD.AddForUpdate(DB.ACConvert);
//bpD.AddForUpdate(DB.ACFileType);
//bpD.AddForUpdate(DB.ACDisb);
//bpD.AddForUpdate(DB.ACMenu);
//bpD.AddForUpdate(DB.ACSeries);
//bpD.AddForUpdate(DB.ActivityCode);
//bpD.AddForUpdate(DB.Series);
//bpD.AddForUpdate(DB.ACMajor);
//bpD.AddForUpdate(DB.ACDocumentation);
//bpD.AddForUpdate(DB.ACControlType);
//bpD.AddForUpdate(DB.ACDependencyType);
//bpD.AddForUpdate(DB.ACSeriesType);
//bpD.AddForUpdate(DB.ACTaskType);
//bpD.AddForUpdate(DB.SeriesStatus);
//bpD.AddForUpdate(DB.SeriesPackage);
//bpD.AddForUpdate(DB.Menu);
//bpD.Update();
//process tables for add and update
ImportTable(DB.Menu, newConfig.Menu);
ImportTable(DB.ACTaskType, newConfig.ACTaskType);
ImportTable(DB.ACMajor, newConfig.ACMajor);
ImportTable(DB.Series, newConfig.Series);
ImportTable(DB.ActivityCode, newConfig.ActivityCode);
ImportTable(DB.ACSeries, newConfig.ACSeries);
ImportTable(DB.ActivityField, newConfig.ActivityField);
ImportTable(DB.ACBF, newConfig.ACBF);
ImportTable(DB.ACDependency, newConfig.ACDependency);
ImportTable(DB.ACFileType, newConfig.ACFileType);
ImportTable(DB.ACConvert, newConfig.ACConvert);
ImportTable(DB.ACMenu, newConfig.ACMenu);
ImportTable(DB.ACDisb, newConfig.ACDisb);
ImportTable(DB.OfficeMandate, newConfig.OfficeMandate);
ImportTable(DB.ACDocumentation, newConfig.ACDocumentation);
ImportTable(DB.ACControlType, newConfig.ACControlType);
ImportTable(DB.ACDependencyType, newConfig.ACDependencyType);
ImportTable(DB.ACSeriesType, newConfig.ACSeriesType);
ImportTable(DB.SeriesPackage, newConfig.SeriesPackage);
ImportTable(DB.SeriesStatus, newConfig.SeriesStatus);
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(DB.Menu);
bp.AddForUpdate(DB.ACTaskType);
bp.AddForUpdate(DB.ACMajor);
bp.AddForUpdate(DB.Series);
bp.AddForUpdate(DB.ActivityCode);
bp.AddForUpdate(DB.ACSeries);
bp.AddForUpdate(DB.ActivityField);
bp.AddForUpdate(DB.ACDependency);
bp.AddForUpdate(DB.ACBF);
bp.AddForUpdate(DB.ACConvert);
bp.AddForUpdate(DB.ACFileType);
bp.AddForUpdate(DB.ACDisb);
bp.AddForUpdate(DB.ACMenu);
bp.AddForUpdate(DB.OfficeMandate);
bp.AddForUpdate(DB.ACDocumentation);
bp.AddForUpdate(DB.ACControlType);
bp.AddForUpdate(DB.ACDependencyType);
bp.AddForUpdate(DB.ACSeriesType);
bp.AddForUpdate(DB.SeriesStatus);
bp.AddForUpdate(DB.SeriesPackage);
bp.Update();
AtMng.acMng.isMerging = false;;
}
catch (Exception x)
{
DB.RejectChanges();
AtMng.acMng.isMerging = false;
throw x;
}
}
private void SaveBatchJob()
{
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(AtMng.GetBatch());
bp.Update();
}
