///<summary>Creates new etrans object, does not insert to Etrans table though. Does insert EtransMessageText.</summary>
public static Etrans CreateEtrans(DateTime dateTimeTrans,long hqClearinghouseNum,string messageText,long userNum){
Etrans etrans=new Etrans();
etrans.DateTimeTrans=dateTimeTrans;
etrans.ClearingHouseNum=hqClearinghouseNum;
EtransMessageText etransMessageText=new EtransMessageText();
etransMessageText.MessageText=messageText;
EtransMessageTexts.Insert(etransMessageText);
etrans.EtransMessageTextNum=etransMessageText.EtransMessageTextNum;
etrans.UserNum=userNum;
return etrans;
}
///<summary>Inserts EtransMessageText row with given messageText then updates the etrans.EtransMessageTextNum in the DB based on given etransNum.
///CAUTION: This does not update the EtransMessageTextNum field of an object in memory.
///Instead it returns the inserted EtransMessageTextNum, this should be used to update the in memory object if needed.</summary>
public static long SetMessage(long etransNum,string messageText) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
return Meth.GetLong(MethodBase.GetCurrentMethod(),etransNum,messageText);
}
EtransMessageText msg=new EtransMessageText();
msg.MessageText=messageText;
EtransMessageTexts.Insert(msg);
//string command=
string command= "UPDATE etrans SET EtransMessageTextNum="+POut.Long(msg.EtransMessageTextNum)+" "
+"WHERE EtransNum = '"+POut.Long(etransNum)+"'";
Db.NonQ(command);
return msg.EtransMessageTextNum;
}
///<summary>Etrans type will be figured out by this class. Either TextReport, Acknowledge_997, Acknowledge_999, or StatusNotify_277.</summary>
public static void ProcessIncomingReport(DateTime dateTimeTrans, long clearinghouseNum, string messageText)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), dateTimeTrans, clearinghouseNum, messageText);
return;
}
Etrans etrans = new Etrans();
etrans.DateTimeTrans = dateTimeTrans;
etrans.ClearingHouseNum = clearinghouseNum;
EtransMessageText etransMessageText = new EtransMessageText();
etransMessageText.MessageText = messageText;
EtransMessageTexts.Insert(etransMessageText);
etrans.EtransMessageTextNum = etransMessageText.EtransMessageTextNum;
string command;
if (X12object.IsX12(messageText))
{
X12object Xobj = new X12object(messageText);
if (Xobj.IsAckInterchange())
{
etrans.Etype = EtransType.Ack_Interchange;
Etranss.Insert(etrans);
//At some point in the future, we should use TA101 to match to batch number and TA104 to get the ack code,
//then update historic etrans entries like we do for 997s, 999s and 277s.
}
else if (Xobj.Is997())
{
X997 x997 = new X997(messageText);
etrans.Etype = EtransType.Acknowledge_997;
etrans.BatchNumber = x997.GetBatchNumber();
Etranss.Insert(etrans);
string batchack = x997.GetBatchAckCode();
if (batchack == "A" || batchack == "R") //accepted or rejected
{
command = "UPDATE etrans SET AckCode='" + batchack + "', "
+ "AckEtransNum=" + POut.Long(etrans.EtransNum)
+ " WHERE BatchNumber=" + POut.Long(etrans.BatchNumber)
+ " AND ClearinghouseNum=" + POut.Long(clearinghouseNum)
+ " AND DateTimeTrans > " + POut.DateT(dateTimeTrans.AddDays(-14))
+ " AND DateTimeTrans < " + POut.DateT(dateTimeTrans.AddDays(1))
+ " AND AckEtransNum=0";
Db.NonQ(command);
}
else //partially accepted
{
List <int> transNums = x997.GetTransNums();
string ack;
for (int i = 0; i < transNums.Count; i++)
{
ack = x997.GetAckForTrans(transNums[i]);
if (ack == "A" || ack == "R") //accepted or rejected
{
command = "UPDATE etrans SET AckCode='" + ack + "', "
+ "AckEtransNum=" + POut.Long(etrans.EtransNum)
+ " WHERE BatchNumber=" + POut.Long(etrans.BatchNumber)
+ " AND TransSetNum=" + POut.Long(transNums[i])
+ " AND ClearinghouseNum=" + POut.Long(clearinghouseNum)
+ " AND DateTimeTrans > " + POut.DateT(dateTimeTrans.AddDays(-14))
+ " AND DateTimeTrans < " + POut.DateT(dateTimeTrans.AddDays(1))
+ " AND AckEtransNum=0";
Db.NonQ(command);
}
}
}
//none of the other fields make sense, because this ack could refer to many claims.
}
else if (Xobj.Is999())
{
X999 x999 = new X999(messageText);
etrans.Etype = EtransType.Acknowledge_999;
etrans.BatchNumber = x999.GetBatchNumber();
Etranss.Insert(etrans);
string batchack = x999.GetBatchAckCode();
if (batchack == "A" || batchack == "R") //accepted or rejected
{
command = "UPDATE etrans SET AckCode='" + batchack + "', "
+ "AckEtransNum=" + POut.Long(etrans.EtransNum)
+ " WHERE BatchNumber=" + POut.Long(etrans.BatchNumber)
+ " AND ClearinghouseNum=" + POut.Long(clearinghouseNum)
+ " AND DateTimeTrans > " + POut.DateT(dateTimeTrans.AddDays(-14))
+ " AND DateTimeTrans < " + POut.DateT(dateTimeTrans.AddDays(1))
+ " AND AckEtransNum=0";
Db.NonQ(command);
}
else //partially accepted
{
List <int> transNums = x999.GetTransNums();
string ack;
for (int i = 0; i < transNums.Count; i++)
{
ack = x999.GetAckForTrans(transNums[i]);
if (ack == "A" || ack == "R") //accepted or rejected
{
command = "UPDATE etrans SET AckCode='" + ack + "', "
+ "AckEtransNum=" + POut.Long(etrans.EtransNum)
+ " WHERE BatchNumber=" + POut.Long(etrans.BatchNumber)
+ " AND TransSetNum=" + POut.Long(transNums[i])
+ " AND ClearinghouseNum=" + POut.Long(clearinghouseNum)
+ " AND DateTimeTrans > " + POut.DateT(dateTimeTrans.AddDays(-14))
+ " AND DateTimeTrans < " + POut.DateT(dateTimeTrans.AddDays(1))
+ " AND AckEtransNum=0";
Db.NonQ(command);
}
}
}
//none of the other fields make sense, because this ack could refer to many claims.
}
else if (X277.Is277(Xobj))
{
X277 x277 = new X277(messageText);
etrans.Etype = EtransType.StatusNotify_277;
Etranss.Insert(etrans);
List <string> claimTrackingNumbers = x277.GetClaimTrackingNumbers();
for (int i = 0; i < claimTrackingNumbers.Count; i++)
{
string ack = x277.GetClaimInfo(claimTrackingNumbers[i])[3];
long claimNum = Claims.GetClaimNumForIdentifier(claimTrackingNumbers[i]);
//Locate the latest etrans entries for the claim based on DateTimeTrans with EType of ClaimSent or Claim_Ren and update the AckCode and AckEtransNum.
//We overwrite existing acks from 997s, 999s and older 277s.
command = "UPDATE etrans SET AckCode='" + ack + "', "
+ "AckEtransNum=" + POut.Long(etrans.EtransNum)
+ " WHERE EType IN (0,3) " //ClaimSent and Claim_Ren
+ " AND ClaimNum=" + POut.Long(claimNum)
+ " AND ClearinghouseNum=" + POut.Long(clearinghouseNum)
+ " AND DateTimeTrans > " + POut.DateT(dateTimeTrans.AddDays(-14))
+ " AND DateTimeTrans < " + POut.DateT(dateTimeTrans.AddDays(1));
Db.NonQ(command);
}
////none of the other fields make sense, because this ack could refer to many claims.
}
else //unknown type of X12 report.
{
etrans.Etype = EtransType.TextReport;
Etranss.Insert(etrans);
}
}
else //not X12
{
etrans.Etype = EtransType.TextReport;
Etranss.Insert(etrans);
}
}
///<summary>Sets the status of the claim to sent, usually as part of printing. Also makes an entry in etrans. If this is Canadian eclaims, then this function gets run first. If the claim is to be sent elecronically, then the messagetext is created after this method and an attempt is made to send the claim. Finally, the messagetext is added to the etrans. This is necessary because the transaction numbers must be incremented and assigned to each claim before creating the message and attempting to send. For Canadians, it will always record the attempt as an etrans even if claim is not set to status of sent.</summary>
public static Etrans SetClaimSentOrPrinted(long claimNum, long patNum, long clearinghouseNum, EtransType etype, int batchNumber)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetObject <Etrans>(MethodBase.GetCurrentMethod(), claimNum, patNum, clearinghouseNum, etype, batchNumber));
}
string command;
Etrans etrans = new Etrans();
//etrans.DateTimeTrans handled automatically
etrans.ClearingHouseNum = clearinghouseNum;
etrans.Etype = etype;
etrans.ClaimNum = claimNum;
etrans.PatNum = patNum;
//Get the primary and secondary carrierNums for this claim.
command = "SELECT carrier1.CarrierNum,carrier2.CarrierNum AS CarrierNum2 FROM claim "
+ "LEFT JOIN insplan insplan1 ON insplan1.PlanNum=claim.PlanNum "
+ "LEFT JOIN carrier carrier1 ON carrier1.CarrierNum=insplan1.CarrierNum "
+ "LEFT JOIN insplan insplan2 ON insplan2.PlanNum=claim.PlanNum2 "
+ "LEFT JOIN carrier carrier2 ON carrier2.CarrierNum=insplan2.CarrierNum "
+ "WHERE claim.ClaimNum=" + POut.Long(claimNum);
DataTable table = Db.GetTable(command);
etrans.CarrierNum = PIn.Long(table.Rows[0][0].ToString());
etrans.CarrierNum2 = PIn.Long(table.Rows[0][1].ToString()); //might be 0 if no secondary on this claim
etrans.BatchNumber = batchNumber;
//if(X837.IsX12(messageText)) {
// X837 x837=new X837(messageText);
// etrans.TransSetNum=x837.GetTransNum(claimNum);
//}
if (etype == EtransType.Claim_CA || etype == EtransType.ClaimCOB_CA || etype == EtransType.Predeterm_CA || etype == EtransType.PredetermEOB_CA)
{
etrans.OfficeSequenceNumber = 0;
//find the next officeSequenceNumber
command = "SELECT MAX(OfficeSequenceNumber) FROM etrans";
table = Db.GetTable(command);
if (table.Rows.Count > 0)
{
etrans.OfficeSequenceNumber = PIn.Int(table.Rows[0][0].ToString());
if (etrans.OfficeSequenceNumber == 999999) //if the office has sent > 1 million messages, and has looped back around to 1.
{
throw new ApplicationException
("OfficeSequenceNumber has maxed out at 999999. This program will need to be enhanced.");
}
}
#if DEBUG
etrans.OfficeSequenceNumber = PIn.Int(File.ReadAllText(@"..\..\..\TestCanada\LastOfficeSequenceNumber.txt"));
File.WriteAllText(@"..\..\..\TestCanada\LastOfficeSequenceNumber.txt", (etrans.OfficeSequenceNumber + 1).ToString());
#endif
etrans.OfficeSequenceNumber++;
//find the next CarrierTransCounter for the primary carrier
etrans.CarrierTransCounter = 0;
command = "SELECT MAX(CarrierTransCounter) FROM etrans "
+ "WHERE CarrierNum=" + POut.Long(etrans.CarrierNum);
table = Db.GetTable(command);
int tempcounter = 0;
if (table.Rows.Count > 0)
{
tempcounter = PIn.Int(table.Rows[0][0].ToString());
}
if (tempcounter > etrans.CarrierTransCounter)
{
etrans.CarrierTransCounter = tempcounter;
}
command = "SELECT MAX(CarrierTransCounter2) FROM etrans "
+ "WHERE CarrierNum2=" + POut.Long(etrans.CarrierNum);
table = Db.GetTable(command);
if (table.Rows.Count > 0)
{
tempcounter = PIn.Int(table.Rows[0][0].ToString());
}
if (tempcounter > etrans.CarrierTransCounter)
{
etrans.CarrierTransCounter = tempcounter;
}
if (etrans.CarrierTransCounter == 99999)
{
throw new ApplicationException("CarrierTransCounter has maxed out at 99999. This program will need to be enhanced.");
}
etrans.CarrierTransCounter++;
if (etrans.CarrierNum2 > 0) //if there is secondary coverage on this claim
{
etrans.CarrierTransCounter2 = 1;
command = "SELECT MAX(CarrierTransCounter) FROM etrans "
+ "WHERE CarrierNum=" + POut.Long(etrans.CarrierNum2);
table = Db.GetTable(command);
if (table.Rows.Count > 0)
{
tempcounter = PIn.Int(table.Rows[0][0].ToString());
}
if (tempcounter > etrans.CarrierTransCounter2)
{
etrans.CarrierTransCounter2 = tempcounter;
}
command = "SELECT MAX(CarrierTransCounter2) FROM etrans "
+ "WHERE CarrierNum2=" + POut.Long(etrans.CarrierNum2);
table = Db.GetTable(command);
if (table.Rows.Count > 0)
{
tempcounter = PIn.Int(table.Rows[0][0].ToString());
}
if (tempcounter > etrans.CarrierTransCounter2)
{
etrans.CarrierTransCounter2 = tempcounter;
}
if (etrans.CarrierTransCounter2 == 99999)
{
throw new ApplicationException("CarrierTransCounter has maxed out at 99999. This program will need to be enhanced.");
}
etrans.CarrierTransCounter2++;
}
}
command = "UPDATE claim SET ClaimStatus = 'S',"
+ "DateSent= " + POut.Date(MiscData.GetNowDateTime())
+ " WHERE claimnum = " + POut.Long(claimNum);
Db.NonQ(command);
EtransMessageText etransMessageText = new EtransMessageText();
etransMessageText.MessageText = "";
EtransMessageTexts.Insert(etransMessageText);
etrans.EtransMessageTextNum = etransMessageText.EtransMessageTextNum;
Etranss.Insert(etrans);
return(GetEtrans(etrans.EtransNum)); //Since the DateTimeTrans is set upon insert, we need to read the record again in order to get the date.
}
///<summary>Etrans type will be figured out by this class. Either TextReport, Acknowledge_997, or StatusNotify_277.</summary>
public static void ProcessIncomingReport(DateTime dateTimeTrans, long clearinghouseNum, string messageText)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), dateTimeTrans, clearinghouseNum, messageText);
return;
}
Etrans etrans = new Etrans();
etrans.DateTimeTrans = dateTimeTrans;
etrans.ClearingHouseNum = clearinghouseNum;
EtransMessageText etransMessageText = new EtransMessageText();
etransMessageText.MessageText = messageText;
EtransMessageTexts.Insert(etransMessageText);
etrans.EtransMessageTextNum = etransMessageText.EtransMessageTextNum;
string command;
if (X12object.IsX12(messageText))
{
X12object Xobj = new X12object(messageText);
if (Xobj.Is997())
{
X997 x997 = new X997(messageText);
etrans.Etype = EtransType.Acknowledge_997;
etrans.BatchNumber = x997.GetBatchNumber();
Etranss.Insert(etrans);
string batchack = x997.GetBatchAckCode();
if (batchack == "A" || batchack == "R") //accepted or rejected
{
command = "UPDATE etrans SET AckCode='" + batchack + "', "
+ "AckEtransNum=" + POut.Long(etrans.EtransNum)
+ " WHERE BatchNumber=" + POut.Long(etrans.BatchNumber)
+ " AND ClearinghouseNum=" + POut.Long(clearinghouseNum)
+ " AND DateTimeTrans > " + POut.DateT(dateTimeTrans.AddDays(-14))
+ " AND DateTimeTrans < " + POut.DateT(dateTimeTrans.AddDays(1))
+ " AND AckEtransNum=0";
Db.NonQ(command);
}
else //partially accepted
{
List <int> transNums = x997.GetTransNums();
string ack;
for (int i = 0; i < transNums.Count; i++)
{
ack = x997.GetAckForTrans(transNums[i]);
if (ack == "A" || ack == "R") //accepted or rejected
{
command = "UPDATE etrans SET AckCode='" + ack + "', "
+ "AckEtransNum=" + POut.Long(etrans.EtransNum)
+ " WHERE BatchNumber=" + POut.Long(etrans.BatchNumber)
+ " AND TransSetNum=" + POut.Long(transNums[i])
+ " AND ClearinghouseNum=" + POut.Long(clearinghouseNum)
+ " AND DateTimeTrans > " + POut.DateT(dateTimeTrans.AddDays(-14))
+ " AND DateTimeTrans < " + POut.DateT(dateTimeTrans.AddDays(1))
+ " AND AckEtransNum=0";
Db.NonQ(command);
}
}
}
//none of the other fields make sense, because this ack could refer to many claims.
}
else if (X277U.Is277U(Xobj))
{
etrans.Etype = EtransType.StatusNotify_277;
//later: analyze to figure out which e-claim is being referenced.
Etranss.Insert(etrans);
}
else //unknown type of X12 report.
{
etrans.Etype = EtransType.TextReport;
Etranss.Insert(etrans);
}
}
else //not X12
{
etrans.Etype = EtransType.TextReport;
Etranss.Insert(etrans);
}
}
