private void EI_WS(SST.ADMSLookupRow ADMSr, MapBE map, ADMS.ADMS_LookupClient ws)
{
ACEngine ace = myA.FM.CurrentActivityProcess.CurrentACE;
DataSet ds = ws.Get_ADMS_SST_Info(ADMSr.ReconID, ADMSr.SIN, ADMSr.BusinessNumber);
if (ds.Tables.Contains("ERROR"))
{
//get status message
ADMSr.Message = ds.Tables["ERROR"].Rows[0]["MESSAGE"].ToString();
if (ADMSr.Message.ToUpper() == "SUCCESS")
{
if (ds.Tables.Contains("ADMS_SST_INFO"))
{
DataTable dtR = ds.Tables["ADMS_SST_INFO"];
DataRow dr = dtR.Rows[0];
SST.SSTCaseRow scr = (SST.SSTCaseRow)myA.GetSSTCase().GetCurrentRow()[0];
// scr.AppelantSourceId = System.Convert.ToInt32(map.MapIn("AppelantSource", dr["CODE_SRC"].ToString()));
scr.ReconsiderationID = ADMSr.ReconID;
if (!dr.IsNull("DATE_DCSN_ISD"))
{
scr.OrigDecisionDate = System.Convert.ToDateTime(dr["DATE_DCSN_ISD"]);
}
int officeid = System.Convert.ToInt32(map.MapIn("Office", dr["ID_OFC_ANCHR"].ToString()));
atriumDB.FileOfficeRow focr = myA.FM.GetFileOffice().AddOfficeToFile(officeid, false, false, false);
focr.OfficeFileNum = scr.ReconsiderationID.ToString();
//find the gd account
OfficeManager om = myA.AtMng.GetOffice(focr.OfficeId);
if (om.DB.Officer.Rows.Count == 0)
{
om.GetOfficer().LoadByOfficeId(focr.OfficeId);
}
var oGD = from o in om.DB.Officer
where o.PositionCode == "GD"
select o;
if (oGD.Count() == 1)
{
atriumDB.FileContactRow fcr = myA.FM.GetFileContact().Add(oGD.Single(), "FHGD");
fcr.HideInToc = true;
}
if (ds.Tables.Contains("ADMS_SST_INFO_PARTICIPANTS"))
{
// string participantType = map.MapIn("Source2Participant", dr["CODE_SRC"].ToString());
foreach (DataRow drp in ds.Tables["ADMS_SST_INFO_PARTICIPANTS"].Rows)
{
bool isAppellant = false;
if (!ADMSr.IsSINNull() && !drp.IsNull("ID_SIN") && ADMSr.SIN == drp["ID_SIN"].ToString())
{
isAppellant = true;
}
else if (!ADMSr.IsBusinessNumberNull() && !drp.IsNull("ID_BSNS_NMBR"))
{
isAppellant = IsEmployerAppellant(ADMSr, drp, isAppellant);
}
if (isAppellant)
{
atriumDB.ContactRow pr = (atriumDB.ContactRow)ace.relTables["Party0"][0].Row;
atriumDB.FileContactRow fcr4 = (atriumDB.FileContactRow)ace.relTables["FileContact4"][0].Row;
SST.FilePartyRow fpr = (SST.FilePartyRow)ace.relTables["FileParty0"][0].Row;
fpr.IsAppellant = true;
pr.SIN = drp["ID_SIN"].ToString();
pr.ContactClass = "P";
//if (pr.GetColumnError("SIN") == Properties.Resources.DebtDuplicateSIN)
//changed test to test for Added as the column error would never be present on the exisiting contact after the swap
if (pr.RowState != DataRowState.Added)
{
//TFS#54669 CJW 2013-09-20 called in PersonBE beforechange now
//pr = myA.FM.GetPerson().SwapBySIN(pr, pr.SIN);
pr = (atriumDB.ContactRow)ace.relTables["Party0"][0].Row;
fcr4 = (atriumDB.FileContactRow)ace.relTables["FileContact4"][0].Row;
fpr = (SST.FilePartyRow)ace.relTables["FileParty0"][0].Row;
//alert user off swap
ADMSr.Message = Properties.Resources.ExistingPartyFound;
}
pr.LastName = drp["NAME_INDVDL_LST"].ToString();
pr.FirstName = drp["NAME_INDVDL_FRST"].ToString();
pr.LanguageCode = map.MapIn("LanguageCode", drp["CODE_LNG"].ToString());
pr.BusinessNumber = drp["ID_BSNS_NMBR"].ToString();
pr.LegalName = drp["NAME_ORG"].ToString();
pr.OperatingAs = drp["NAME_ORG_UNT"].ToString();
pr.PartyTypeCode = map.MapIn("ContactType", drp["CODE_PRTCPNT_TYP"].ToString());
fcr4.ContactId = pr.ContactId;
fcr4.ContactType = pr.PartyTypeCode;
fpr.FileContactId = fcr4.FileContactid;
pr.TelephoneNumber = drp["NMBR_TLPHN_AR_CD_H"].ToString() + "-" + drp["NMBR_TLPHN_LCL_H"].ToString();
if (!pr.IsAddressCurrentIDNull())
{
atriumDB.AddressRow ar = myA.FM.DB.Address.FindByAddressId(pr.AddressCurrentID);
ar.ContactId = pr.ContactId;
ar.EffectiveTo = DateTime.Today;
ar.AddressSourceCode = "HRDC";
ar.Address1 = drp["ADRS_LN_1"].ToString();
ar.Address2 = drp["ADRS_LN_2"].ToString();
ar.Address3 = drp["ADRS_LN_3"].ToString();
string prov = map.MapIn("Province", drp["CODE_PRVNC_OR_ST"].ToString());
if (prov != null)
{
DataTable dtProv = myA.FM.Codes("Province");
DataRow drs = dtProv.Rows.Find(prov);
if (drs != null)
{
ar.CountryCode = drs["CountryCode"].ToString();
}
else
{
ar.CountryCode = "CDN";
}
}
else
{
ar.CountryCode = map.MapIn("Country", drp["NAME_CNTRY"].ToString());
if (drp.IsNull("NAME_CNTRY") || ar.IsNull("CountryCode"))
{
ar.CountryCode = "CDN";
}
}
ar.ProvinceCode = prov;
ar.City = drp["ADRS_MNCPLTY"].ToString();
ar.PostalCode = drp["CODE_PSTL_OR_ZIP"].ToString();
}
}
else
{
//add other participants automatically
AddOtherParty(map, drp);
}
}
}
}
}
else if (ADMSr.Message.ToUpper() == "ERROR")
{
// ADMSr.SetColumnError("Message", ADMSr.Message);
ADMSr.Message = ds.Tables["ERROR"].Rows[0]["SQL"].ToString();
if (ADMSr.Message.StartsWith("ORA-01403"))
{
ADMSr.Message = "No matching reconsideration found in ADMS. / Aucune révision correspondante trouvée dans le SGPA.";
}
else if (ADMSr.Message.StartsWith("ORA-01422"))
{
ADMSr.Message = "More than one matching reconsideration found in ADMS. / Il y a plus qu'une révision correspondante trouvée dans le SGPA.";
}
else if (ADMSr.Message.StartsWith("ORA-1017"))
{
ADMSr.Message = "Configuration problem with ADMS EI web service. Contact IT support. / Il y a un problème de configuration avec le service web A-E SGPA. Contactez le support TI.";
}
else if (ADMSr.Message.StartsWith("ORA-12154"))
{
ADMSr.Message = "Configuration problem with ADMS EI web service. Contact IT support. / Il y a un problème de configuration avec le service web A-E SGPA. Contactez le support TI.";
}
}
}
}
private void AddOtherParty(MapBE map, DataRow drp)
{
atriumDB.ContactRow pr = null;
//search for party
if (!drp.IsNull("ID_SIN"))
{
string SIN = drp["ID_SIN"].ToString();
myA.FM.GetPerson().LoadBySIN(SIN);
var ps = from p in myA.FM.DB.Contact
where !p.IsSINNull() && p.SIN == SIN
select p;
if (ps.Count() == 1)
{
pr = ps.Single();
}
}
if (pr == null)
{
//create party
pr = (atriumDB.ContactRow)myA.FM.GetPerson().Add(null);
pr.SIN = drp["ID_SIN"].ToString();
}
pr.ContactClass = "P";
//if (drp.IsNull("NAME_INDVDL_LST"))
// pr.LastName = "Resources";
//else
pr.LastName = drp["NAME_INDVDL_LST"].ToString();
//if (drp.IsNull("NAME_INDVDL_FRST"))
// pr.FirstName = "Human";
//else
pr.FirstName = drp["NAME_INDVDL_FRST"].ToString();
pr.LanguageCode = map.MapIn("LanguageCode", drp["CODE_LNG"].ToString());
pr.BusinessNumber = drp["ID_BSNS_NMBR"].ToString();
pr.LegalName = drp["NAME_ORG"].ToString();
pr.OperatingAs = drp["NAME_ORG_UNT"].ToString();
pr.PartyTypeCode = map.MapIn("ContactType", drp["CODE_PRTCPNT_TYP"].ToString());
pr.TelephoneNumber = drp["NMBR_TLPHN_AR_CD_H"].ToString() + "-" + drp["NMBR_TLPHN_LCL_H"].ToString();
//create address
atriumDB.AddressRow ar = (atriumDB.AddressRow)myA.FM.GetAddress().Add(pr);
// ar.ContactId = pr.ContactId;
ar.EffectiveTo = DateTime.Today;
ar.AddressSourceCode = "HRDC";
ar.Address1 = drp["ADRS_LN_1"].ToString();
ar.Address2 = drp["ADRS_LN_2"].ToString();
ar.Address3 = drp["ADRS_LN_3"].ToString();
string prov = map.MapIn("Province", drp["CODE_PRVNC_OR_ST"].ToString());
if (prov != null)
{
DataTable dtProv = myA.FM.Codes("Province");
DataRow drs = dtProv.Rows.Find(prov);
if (drs != null)
{
ar.CountryCode = drs["CountryCode"].ToString();
}
else
{
ar.CountryCode = "CDN";
}
}
else
{
ar.CountryCode = map.MapIn("Country", drp["NAME_CNTRY"].ToString());
if (drp.IsNull("NAME_CNTRY") || ar.IsNull("CountryCode"))
{
ar.CountryCode = "CDN";
}
}
ar.ProvinceCode = prov;
ar.City = drp["ADRS_MNCPLTY"].ToString();
ar.PostalCode = drp["CODE_PSTL_OR_ZIP"].ToString();
// pr.AddressCurrentID = ar.AddressId;
//create filecontact
atriumDB.FileContactRow fcrp = (atriumDB.FileContactRow)myA.FM.GetFileContact().Add(myA.FM.CurrentFile);
fcrp.ContactId = pr.ContactId;
fcrp.ContactType = pr.PartyTypeCode;
//create fileparty
SST.FilePartyRow fpr = (SST.FilePartyRow)myA.GetFileParty().Add(myA.FM.CurrentFile);
// fpr.PartyId = pr.PartyId;
// fpr.ContactTypeCode = pr.PartyTypeCode;
fpr.IsPending = true;
fpr.FileContactId = fcrp.FileContactid;
}
private void EP_WS(SST.ADMSLookupRow ADMSr, MapBE map, ADMS.ADMS_LookupClient ws)
{
//only add other parties
ACEngine ace = myA.FM.CurrentActivityProcess.CurrentACE;
DataSet ds = ws.Get_ADMS_SST_Info(ADMSr.ReconID, ADMSr.SIN, ADMSr.BusinessNumber);
if (ds.Tables.Contains("ERROR"))
{
//get status message
ADMSr.Message = ds.Tables["ERROR"].Rows[0]["MESSAGE"].ToString();
if (ADMSr.Message.ToUpper() == "SUCCESS")
{
if (ds.Tables.Contains("ADMS_SST_INFO"))
{
DataTable dtR = ds.Tables["ADMS_SST_INFO"];
DataRow dr = dtR.Rows[0];
if (ds.Tables.Contains("ADMS_SST_INFO_PARTICIPANTS"))
{
// string participantType = map.MapIn("Source2Participant", dr["CODE_SRC"].ToString());
foreach (DataRow drp in ds.Tables["ADMS_SST_INFO_PARTICIPANTS"].Rows)
{
bool isAppellant = false;
if (!ADMSr.IsSINNull() && !drp.IsNull("ID_SIN") && ADMSr.SIN == drp["ID_SIN"].ToString())
{
isAppellant = true;
}
else if (!ADMSr.IsBusinessNumberNull() && !drp.IsNull("ID_BSNS_NMBR"))
{
isAppellant = IsEmployerAppellant(ADMSr, drp, isAppellant);
}
if (isAppellant)
{
////ignore
//atriumDB.ContactRow pr = (atriumDB.ContactRow)ace.relTables["Party0"][0].Row;
//atriumDB.FileContactRow fcr4 = (atriumDB.FileContactRow)ace.relTables["FileContact4"][0].Row;
//SST.FilePartyRow fpr = (SST.FilePartyRow)ace.relTables["FileParty0"][0].Row;
//fpr.IsAppellant = true;
//pr.SIN = drp["ID_SIN"].ToString();
//pr.ContactClass = "P";
//if (pr.GetColumnError("SIN") == Properties.Resources.DebtDuplicateSIN)
//{
// //TFS#54669 CJW 2013-09-20 called in PersonBE beforechange now
// //pr = myA.FM.GetPerson().SwapBySIN(pr, pr.SIN);
// pr = (atriumDB.ContactRow)ace.relTables["Party0"][0].Row;
// fcr4 = (atriumDB.FileContactRow)ace.relTables["FileContact4"][0].Row;
// fpr = (SST.FilePartyRow)ace.relTables["FileParty0"][0].Row;
// //alert user off swap
// ADMSr.Message = Properties.Resources.ExistingPartyFound;
//}
//pr.LastName = drp["NAME_INDVDL_LST"].ToString();
//pr.FirstName = drp["NAME_INDVDL_FRST"].ToString();
//pr.LanguageCode = map.MapIn("LanguageCode", drp["CODE_LNG"].ToString());
//pr.BusinessNumber = drp["ID_BSNS_NMBR"].ToString();
//pr.LegalName = drp["NAME_ORG"].ToString();
//pr.OperatingAs = drp["NAME_ORG_UNT"].ToString();
//pr.PartyTypeCode = map.MapIn("ContactType", drp["CODE_PRTCPNT_TYP"].ToString());
//fcr4.ContactId = pr.ContactId;
//fcr4.ContactType = pr.PartyTypeCode;
//fpr.FileContactId = fcr4.FileContactid;
//pr.TelephoneNumber = drp["NMBR_TLPHN_AR_CD_H"].ToString() + "-" + drp["NMBR_TLPHN_LCL_H"].ToString();
//if (!pr.IsAddressCurrentIDNull())
//{
// atriumDB.AddressRow ar = myA.FM.DB.Address.FindByAddressId(pr.AddressCurrentID);
// ar.ContactId = pr.ContactId;
// ar.EffectiveTo = DateTime.Today;
// ar.AddressSourceCode = "HRDC";
// ar.Address1 = drp["ADRS_LN_1"].ToString();
// ar.Address2 = drp["ADRS_LN_2"].ToString();
// ar.Address3 = drp["ADRS_LN_3"].ToString();
// ar.CountryCode = map.MapIn("Country", drp["NAME_CNTRY"].ToString());
// if (drp.IsNull("NAME_CNTRY"))
// ar.CountryCode = "CDN";
// ar.ProvinceCode = map.MapIn("Province", drp["CODE_PRVNC_OR_ST"].ToString());
// ar.City = drp["ADRS_MNCPLTY"].ToString();
// ar.PostalCode = drp["CODE_PSTL_OR_ZIP"].ToString();
//}
}
else
{
//add other participants automatically
string pt = map.MapIn("ContactType", drp["CODE_PRTCPNT_TYP"].ToString());
if (pt == "PCL" || pt == "PEMP")
{
AddOtherParty(map, drp);
}
}
}
}
}
}
else if (ADMSr.Message.ToUpper() == "ERROR")
{
//ADMSr.SetColumnError("Message", ADMSr.Message);
ADMSr.Message = ds.Tables["ERROR"].Rows[0]["SQL"].ToString();
if (ADMSr.Message.StartsWith("ORA-01403"))
{
ADMSr.Message = "No matching reconsideration found in ADMS. / Aucune révision correspondante trouvée dans le SGPA.";
}
else if (ADMSr.Message.StartsWith("ORA-01422"))
{
ADMSr.Message = "More than one matching reconsideration found in ADMS. / Il y a plus qu'une révision correspondante trouvée dans le SGPA.";
}
else if (ADMSr.Message.StartsWith("ORA-1017"))
{
ADMSr.Message = "Configuration problem with ADMS EI web service. Contact IT support. / Il y a un problème de configuration avec le service web A-E SGPA. Contactez le support TI.";
}
else if (ADMSr.Message.StartsWith("ORA-12154"))
{
ADMSr.Message = "Configuration problem with ADMS EI web service. Contact IT support. / Il y a un problème de configuration avec le service web A-E SGPA. Contactez le support TI.";
}
}
}
}