protected override void AfterAdd(DataRow row)
{
atriumDB.AppointmentRow dr = (atriumDB.AppointmentRow)row;
string ObjectName = this.myAppointmentDT.TableName;
//System.Diagnostics.Debug.WriteLine(dr["ContactId"] + dr.RowState.ToString() );
dr.ApptId = this.myA.AtMng.PKIDGet(ObjectName, 10);
if (dr.IsNull("FileId"))
{
dr.FileId = myA.CurrentFileId;
}
dr.Type = 0;
dr.ShowAsBusy = true;
dr.AllDayEvent = false;
dr.Subject = "...";
dr.Tentative = false;
dr.Vacation = false;
DateTime d = DateTime.Now.AddHours(1);
dr.StartDateLocal = new DateTime(d.Year, d.Month, d.Day, d.Hour, 0, 0);
dr.StartDate = dr.StartDateLocal.ToUniversalTime();
d = d.AddHours(1);
dr.EndDateLocal = new DateTime(d.Year, d.Month, d.Day, d.Hour, 0, 0);
dr.EndDate = dr.EndDateLocal.ToUniversalTime();
dr.OriginalRecurrence = false;
//atriumDB.AttendeeRow ar = (atriumDB.AttendeeRow)myA.GetAttendee().Add(dr);
//ar.ContactId = myA.AtMng.WorkingAsOfficer.OfficerId;
//ar.Accepted = true;
EFileBE.XmlAddToc(myA.CurrentFile, "appointment", "Calendar", "Calendrier", 119);
}
private void MyXml(CLAS.InsolvencyRow r, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='insolvency' and @id=" + r.InsolvencyID.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "insolvency");
}
xe.SetAttribute("id", r.InsolvencyID.ToString());
string dischargeable = Properties.Resources.BKCSLDischargeable;
if (r.CSLNonDischargeable)
{
dischargeable = Properties.Resources.BKCSLNonDischargeable;
}
string title = r.InsolvencyType.ToString();
title += " - " + r.InsolvencyFiledDate.ToString("yyyy/MM/dd") + dischargeable;
xe.SetAttribute("titlee", title);
xe.SetAttribute("titlef", title);
if (!r.IsProvenClaimAmountNull())
{
xe.SetAttribute("tooltipee", r.ProvenClaimAmount.ToString("C"));
xe.SetAttribute("tooltipef", r.ProvenClaimAmount.ToString("C"));
}
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "insolvency", "Insolvency", "Insolvabilité", 240);
xes.AppendChild(xe);
}
}
private void MyXml(CLAS.FileAccountRow r, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='account' and @id=" + r.FileAccountId.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "account");
xe.SetAttribute("supertype", "fileaccount");
}
xe.SetAttribute("id", r.FileAccountId.ToString());
xe.SetAttribute("titlee", r["AccountTypeCode"].ToString() + " (" + r["DARSAccountType"].ToString() + ")");
xe.SetAttribute("titlef", r["AccountTypeCode"].ToString() + " (" + r["DARSAccountType"].ToString() + ")");
if (r.ActiveWithJustice)
{
xe.SetAttribute("tooltipe", "Assigned");
xe.SetAttribute("strikeout", "false");
}
else
{
xe.SetAttribute("tooltipe", "Not Assigned");
xe.SetAttribute("strikeout", "true");
}
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "account", "Accounts", "Comptes", 220);
xes.AppendChild(xe);
}
}
private void MyXml(CLAS.JudgmentRow jr, System.Xml.XmlDocument xd)
{
if (jr.ProcessTypeCode != "TP")
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='judgment' and @id=" + jr.JudgmentID.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "judgment");
}
xe.SetAttribute("id", jr.JudgmentID.ToString());
string title = "";
bool isTextStruckout = false;
if (!jr.IsActionNumberNull())
{
title += jr.ActionNumber;
}
if (!jr.IsWithdrawalRemovalDateNull())
{
isTextStruckout = true;
string withdrawnTooltipE = "Judgment Withdrawal/Removal Date: " + jr.WithdrawalRemovalDate.ToString("yyyy/MM/dd");
string withdrawnTooltipF = "Jugement retiré le : " + jr.WithdrawalRemovalDate.ToString("yyyy/MM/dd");
xe.SetAttribute("tooltipe", withdrawnTooltipE);
xe.SetAttribute("tooltipf", withdrawnTooltipF);
title += " (" + Properties.Resources.JudgmentJudgmentDate + " " + jr.JudgmentDate.ToString("yyyy/MM/dd") + ")";
}
else if (!jr.IsJudgmentDateNull())
{
title += " (" + Properties.Resources.JudgmentJudgmentDate + " " + jr.JudgmentDate.ToString("yyyy/MM/dd") + ")";
}
else if (!jr.IsDefenceDateNull())
{
title += " (" + Properties.Resources.JudgmentDefenceDate + " " + jr.DefenceDate.ToString("yyyy/MM/dd") + ")";
}
else if (!jr.IsStatementofClaimServedDateNull())
{
title += " (" + Properties.Resources.JudgmentStatementofClaimServedDate + " " + jr.StatementofClaimServedDate.ToString("yyyy/MM/dd") + ")";
}
else if (!jr.IsStatementofClaimIssuedDateNull())
{
title += " (" + Properties.Resources.JudgmentStatementofClaimIssuedDate + " " + jr.StatementofClaimIssuedDate.ToString("yyyy/MM/dd") + ")";
}
xe.SetAttribute("titlee", title);
xe.SetAttribute("titlef", title);
xe.SetAttribute("strikeout", isTextStruckout.ToString().ToLower());
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "judgment", "Litigation", "Litige", 250);
xes.AppendChild(xe);
}
}
}
private void MyXml(atriumDB.FileOfficeRow r, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='fileoffice' and @id=" + r.FileOfficeId.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "fileoffice");
}
xe.SetAttribute("id", r.FileOfficeId.ToString());
xe.SetAttribute("officeid", r.OfficeId.ToString());
string titlee = r.OfficeCode + " - " + r.OfficeName;
string titlef = r.OfficeCode + " - " + r.OfficeNameFre;
if (!r.IsOfficeFileNumNull())
{
titlee += " (" + r.OfficeFileNum + ")";
titlef += " (" + r.OfficeFileNum + ")";
}
xe.SetAttribute("titlee", titlee);
xe.SetAttribute("titlef", titlef);
string tooltipe = "";
string tooltipf = "";
if (r.IsClient)
{
tooltipe = "Client Office";
tooltipf = "Bureau client";
}
else if (r.IsLead)
{
tooltipe = "Lead Office";
tooltipf = "Bureau responsable";
}
else if (r.IsOwner)
{
tooltipe = "Owner Office";
tooltipf = "Bureau propriétaire du dossier";
}
//xe.SetAttribute("icon", "28"); //office icon
xe.SetAttribute("tooltipe", tooltipe);
xe.SetAttribute("tooltipf", tooltipf);
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "basecontacts", "Contacts", "Contacts", 210);
//System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "fileoffice", "Offices", "Bureaux",320);
xes.AppendChild(xe);
}
}
private void MyXml(CLAS.DebtRow r, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='account' and @id=" + r.FileAccountId.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "account");
xe.SetAttribute("supertype", "debt");
}
string dType = "DARS";
if (r.MSOAOverDARS)
{
dType = "MSOA";
}
if (r.StatBarred)
{
dType = Properties.Resources.TocDebtStatuteBarred;
}
xe.SetAttribute("id", r.FileAccountId.ToString());
xe.SetAttribute("titlee", r["AccountTypeCode"].ToString() + " (" + r["DARSAccountType"].ToString() + ") - " + dType);
xe.SetAttribute("titlef", r["AccountTypeCode"].ToString() + " (" + r["DARSAccountType"].ToString() + ") - " + dType);
if (r.ActiveWithJustice)
{
xe.SetAttribute("tooltipe", r["AccountTypeDescEng"].ToString() + " / Active");
xe.SetAttribute("tooltipf", r["AccountTypeDescEng"].ToString() + " / Actif");
xe.SetAttribute("strikeout", "false");
}
else
{
if (r.StatBarred)
{
xe.SetAttribute("tooltipe", r["AccountTypeDescEng"].ToString() + " / Statute-Barred");
xe.SetAttribute("tooltipf", r["AccountTypeDescEng"].ToString() + " / Prescrit");
}
else
{
xe.SetAttribute("tooltipe", r["AccountTypeDescEng"].ToString() + " / Non-Active");
xe.SetAttribute("tooltipf", r["AccountTypeDescEng"].ToString() + " / Non actif");
}
xe.SetAttribute("strikeout", "true");
}
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "account", "Accounts", "Comptes", 220);
xes.AppendChild(xe);
}
}
private void Init(atriumManager atMng)
{
base.DAL = atMng.DALMngr;
RuleHandler = atMng.RuleHandler;
myatMng = atMng;
MyDS = new atriumDB();;
MyDS.EnforceConstraints = false;
MyDS.RemotingFormat = SerializationFormat.Binary;
DB.Lang = myatMng.AppMan.Language;
myMngrs.Add(DB.DataSetName, this);
EFileBE tmp = EFile;
DB.FileMetaType.Merge(myatMng.CodeDB.FileMetaType);
DB.FileType.Merge(myatMng.CodeDB.FileType);
}
public void MyXml(atriumDB.EFileRow efr, System.Xml.XmlDocument xd)
{
int i = 0;
foreach (atriumDB.SRPRow sr in myA.DB.SRP.Select("FileId=" + efr.FileId.ToString(), "SRPDate desc"))
{
i++;
if (i >= 4)
{
break;
}
MyXml(sr, xd);
}
if (i == 0) // no SRP, new office
{
EFileBE.XmlAddToc(xd, "srp", "SRP Info", "Info SDP", 250);
}
}
private void MyXml(CLAS.CompOfferRow r, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='compoffer' and @id=" + r.CompOfferId.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "compoffer");
}
xe.SetAttribute("id", r.CompOfferId.ToString());
CLAS.CompOfferDetailRow cor = myA.DB.CompOfferDetail.FindByCompOfferDetailId(r.CurrentOfferId);
string title = "";
if (r.Active)
{
title = cor.CompOfferDate.ToString("yyyy/MM/dd") + ": " + cor.CompOfferAmount.ToString("C");
}
else
{
if (!r.IsTermsDefaultedDateNull())
{
title = "Terms Defaulted: " + r.TermsDefaultedDate.ToString("yyyy/MM/dd");
}
else if (!r.IsTermsFulfilledDateNull())
{
title = "Terms Fulfilled: " + r.TermsFulfilledDate.ToString("yyyy/MM/dd");
}
else
{
title = cor.CompOfferDate.ToString("yyyy/MM/dd") + ": Inactive";
}
}
xe.SetAttribute("titlee", title);
xe.SetAttribute("titlef", title);
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "compoffer", "Compromise Offers", "Offres de règlement", 229);
xes.AppendChild(xe);
}
}
public void MyXml(atriumDB.SRPRow sr, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xeb = EFileBE.XmlAddFld(xd, "srp", "Agent Billings", "Facturation de mandataire", 250);
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xeb, "srp" + sr.SRPID.ToString(), "SRP " + sr.SRPDate.ToString("yyyy/MM/dd"), "SDP " + sr.SRPDate.ToString("yyyy/MM/dd"), 250);
System.Xml.XmlElement xe = xd.CreateElement("toc");
xe.SetAttribute("supertype", "srp");
xe.SetAttribute("type", "srp");
xe.SetAttribute("id", sr.SRPID.ToString());
xe.SetAttribute("titlee", "SRP Info");
xe.SetAttribute("titlef", "Info SDP");
xes.AppendChild(xe);
System.Xml.XmlElement xeIRP = xd.CreateElement("toc");
xeIRP.SetAttribute("supertype", "srp");
xeIRP.SetAttribute("type", "srpdetail");
xeIRP.SetAttribute("id", sr.SRPID.ToString());
xeIRP.SetAttribute("titlee", "SRP Detail");
xeIRP.SetAttribute("titlef", "Détails SDP");
xes.AppendChild(xeIRP);
if (myA.LeadOfficeMng.CurrentOffice.UsesBilling)
{
System.Xml.XmlElement xeBR = xd.CreateElement("toc");
xeBR.SetAttribute("supertype", "srp");
xeBR.SetAttribute("type", "billingreview");
xeBR.SetAttribute("id", sr.SRPID.ToString());
xeBR.SetAttribute("titlee", "Billing Review");
xeBR.SetAttribute("titlef", "Révision de facturation");
xes.AppendChild(xeBR);
}
//if (xes.ParentNode == null)
//{
// System.Xml.XmlElement xeb = EFileBE.XmlAddFld(xd, "srp", "Agent Billings", "Agent Billings", 250);
// xeb.AppendChild(xes);
//}
}
private void MyXml(CLAS.HardshipRow r, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='hardship' and @id=" + r.HardshipId.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "hardship");
xe.SetAttribute("supertype", "bankruptcy");
}
xe.SetAttribute("id", r.HardshipId.ToString());
string title = r.RequestDate.ToString("yyyy/MM/dd");
xe.SetAttribute("titlee", title);
xe.SetAttribute("titlef", title);
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "hardship", "Hardships", "Hardships", 240);
xes.AppendChild(xe);
}
}
private void MyXml(Advisory.OpinionRow r, System.Xml.XmlDocument xd)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='opinion' and @id=" + r.OpinionId.ToString() + "]");
if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("type", "opinion");
}
xe.SetAttribute("id", r.OpinionId.ToString());
//if(! r.IsOfficerCodeNull())
// xe.SetAttribute("assignedtocode",r.OfficerCode.ToString());
string title = "";
if (!r.IsNumberNull())
{
title = r.Number.ToString();
}
if (!r.IsCompletedDateNull())
{
title += "(" + atriumRes.OpinionCompletedDate + ": " + r.CompletedDate.ToString("yyyy/MM/dd") + ")";
}
else if (!r.IsRequestDateNull())
{
title += atriumRes.OpinionRequestDate + ": " + r.RequestDate.ToString("yyyy/MM/dd");
}
xe.SetAttribute("titlee", title);
xe.SetAttribute("titlef", title);
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = EFileBE.XmlAddFld(xd, "opinions", "Opinions", "Opinions", 150);
xes.AppendChild(xe);
}
}
protected override void AfterUpdate(DataRow row)
{
SST.SSTDecisionRow dr = (SST.SSTDecisionRow)row;
EFileBE.XmlAddToc(myA.FM.CurrentFile, "sstdecision", "Tribunal Member Decisions", "Décisions de Membre du Tribunal", 112);
}
private void MyXml(atriumDB.FileContactRow fcr, System.Xml.XmlDocument xd)
{
try
{
//JLL: MODIFIED 2009/07/24: take FileContact.Active into account - remove where not active
bool removeNode = false;
if (!fcr.HideInToc)
{
System.Xml.XmlElement xe = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@supertype='contact' and @id=" + fcr.FileContactid.ToString() + "]");
if (!fcr.Active)
{
removeNode = true;
}
else if (xe == null)
{
xe = xd.CreateElement("toc");
xe.SetAttribute("supertype", "contact");
}
if (removeNode)
{
RemoveFileContactFromXML(xe);
}
else
{
xe.SetAttribute("id", fcr.FileContactid.ToString());
//if (fcr.IsLastNameNull())
//{
// xe.SetAttribute("titlee", String.Format(atriumRes.FileContactXmlTitle + " (" + fcr.ContactTypeDescEng.ToString() + ")", fcr.LegalName, ""));
// xe.SetAttribute("titlef", String.Format(atriumRes.FileContactXmlTitle + " (" + fcr.ContactTypeDescFre.ToString() + ")", fcr.LegalName, ""));
//}
//else
//{
// xe.SetAttribute("titlee", String.Format(atriumRes.FileContactXmlTitle + " (" + fcr.ContactTypeDescEng.ToString() + ")", fcr.LastName, fcr.FirstName));
// xe.SetAttribute("titlef", String.Format(atriumRes.FileContactXmlTitle + " (" + fcr.ContactTypeDescFre.ToString() + ")", fcr.LastName, fcr.FirstName));
//}
xe.SetAttribute("titlee", String.Format(atriumRes.FileContactXmlTitle + " (" + fcr.ContactTypeDescEng.ToString() + ")", fcr.DisplayName, ""));
xe.SetAttribute("titlef", String.Format(atriumRes.FileContactXmlTitle + " (" + fcr.ContactTypeDescFre.ToString() + ")", fcr.DisplayName, ""));
if (fcr.ContactType == "FDB")
{
CLAS.DebtorRow debtor = myA.GetCLASMng().GetDebtor().CurrentDebtor;
xe.SetAttribute("type", "opponent");
//check for Contact/Notes
if (debtor != null && !debtor.IsNotesNull())
{
//tweek title
xe.SetAttribute("titlee", "*** " + xe.GetAttribute("titlee") + " ***");
xe.SetAttribute("titlef", "*** " + xe.GetAttribute("titlef") + " ***");
xe.SetAttribute("bold", "true");
xe.SetAttribute("tooltipe", "There are notes");
xe.SetAttribute("tooltipf", "Il y a des notes");
}
else
{
xe.SetAttribute("bold", "false");
xe.SetAttribute("tooltipe", "");
xe.SetAttribute("tooltipf", "");
}
//2014-06-11
//JLL
//calculate address country to determine icon
//assumes data is already loaded
//DOES NOT WORK WHEN OPENING A FILE; CONTACT ROW IS NULL ... ARG
if (debtor != null && !debtor.IsAddressCurrentIDNull())
{
atriumDB.AddressRow dbAddress = myA.DB.Address.FindByAddressId(debtor.AddressCurrentID);
if (dbAddress != null)
{
string country = dbAddress.CountryCode;
switch (country)
{
case "CDN":
xe.SetAttribute("icon", "34");
break;
case "USA":
xe.SetAttribute("icon", "35");
break;
default:
xe.SetAttribute("icon", "36");
break;
}
}
}
}
else
{
xe.SetAttribute("type", "contact");
}
if (xe.GetAttribute("isParticipant") != "true" && !fcr.IsOfficeIdNull())
{
xe.SetAttribute("icon", "43"); //atrium officer; not necessarily a user
}
if (xe.ParentNode == null)
{
System.Xml.XmlElement xes = null;
if (fcr.IsOfficeIdNull())
{
xes = EFileBE.XmlAddFld(xd, "basecontacts", "Contacts", "Contacts", 210);
xes.AppendChild(xe);
}
else
{
System.Xml.XmlElement xe1 = (System.Xml.XmlElement)xd.SelectSingleNode("//toc[@type='fileoffice' and @officeid=" + fcr.OfficeId.ToString() + "]");
if (xe1 != null)
{
xe1.AppendChild(xe);
}
else
{
xes = EFileBE.XmlAddFld(xd, "basecontacts", "Contacts", "Contacts", 210);
xes.AppendChild(xe);
}
//xes.AppendChild(xe);
//xes = EFileBE.XmlAddFld(xe1, "contacts", "Contacts", "Contacts", 320);
//else
//{
//JLL: Bug 2009/07/24
//When new contact is added through process (CM03.02), and no File Office record is present,
// it sticks File Contact record on first "contact" match on filestructxml document
// xes = EFileBE.XmlAddFld(xd, "contacts", "Contacts", "Contacts", 320);
//}
}
//xes.AppendChild(xe);
}
}
}
}
catch (Exception x)
{ }
}
protected override void AfterUpdate(DataRow row)
{
CLAS.FileHistoryRow dr = (CLAS.FileHistoryRow)row;
EFileBE.XmlAddToc(myA.FM.CurrentFile, "filehistory", "File History", "Cheminement de dossier", 130);
}
protected override void AfterUpdate(DataRow row)
{
CLAS.CBDetailRow dr = (CLAS.CBDetailRow)row;
EFileBE.XmlAddToc(myA.FM.CurrentFile, "cbdetail", "Payments Received", "Paiements reçus", 110);
}
protected override void AfterUpdate(DataRow row)
{
atriumDB.RiskAssessmentRow dr = (atriumDB.RiskAssessmentRow)row;
EFileBE.XmlAddToc(dr.EFileRow, "riskassessment", "Legal Risk Management", "Gestion du risque juridique", 140);
}
protected override void AfterUpdate(DataRow row)
{
CLAS.CashBlotterRow dr = (CLAS.CashBlotterRow)row;
EFileBE.XmlAddToc(myA.FM.CurrentFile, "cashblotter", "Cash Blotter", "Cash Blotter", 120);
}
public void MyXml(atriumDB.EFileRow efr, System.Xml.XmlDocument xd, officeDB.OfficeRow or)
{
EFileBE.XmlAddToc(xd, "office", "Office", "Bureau", 160, or.OfficeId.ToString());
EFileBE.XmlAddToc(xd, "officer", "Personnel", "Personnel", 170);
}
protected override void AfterUpdate(DataRow row)
{
SST.SSTRequestRow dr = (SST.SSTRequestRow)row;
EFileBE.XmlAddToc(myA.FM.CurrentFile, "sstrequest", "Correspondence Requests", "Demandes de correspondances", 111);
}
protected override void AfterUpdate(DataRow dr)
{
CLAS.TaxingRow r = (CLAS.TaxingRow)dr;
EFileBE.XmlAddToc(myA.FM.CurrentFile, "taxing", "Taxing recommendations", "Recommendations de taxation", 200);
}
protected override void AfterUpdate(DataRow dr)
{
CLAS.OfficeAccountRow r = (CLAS.OfficeAccountRow)dr;
EFileBE.XmlAddToc(myA.AtMng.GetFile(r.FileId).CurrentFile, "officeaccount", "Acomptes de bureau", "Office Account", 180);
}