///<summary>Inserts one CanadianNetwork into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(CanadianNetwork canadianNetwork, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
canadianNetwork.CanadianNetworkNum = ReplicationServers.GetKey("canadiannetwork", "CanadianNetworkNum");
}
string command = "INSERT INTO canadiannetwork (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "CanadianNetworkNum,";
}
command += "Abbrev,Descript,CanadianTransactionPrefix,CanadianIsRprHandler) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(canadianNetwork.CanadianNetworkNum) + ",";
}
command +=
"'" + POut.String(canadianNetwork.Abbrev) + "',"
+ "'" + POut.String(canadianNetwork.Descript) + "',"
+ "'" + POut.String(canadianNetwork.CanadianTransactionPrefix) + "',"
+ POut.Bool(canadianNetwork.CanadianIsRprHandler) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
canadianNetwork.CanadianNetworkNum = Db.NonQ(command, true);
}
return(canadianNetwork.CanadianNetworkNum);
}
///<summary>Inserts one CanadianNetwork into the database. Returns the new priKey.</summary>
internal static long Insert(CanadianNetwork canadianNetwork)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
canadianNetwork.CanadianNetworkNum=DbHelper.GetNextOracleKey("canadiannetwork","CanadianNetworkNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(canadianNetwork,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
canadianNetwork.CanadianNetworkNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(canadianNetwork,false);
}
}
///<summary>Inserts one CanadianNetwork into the database. Returns the new priKey.</summary>
internal static long Insert(CanadianNetwork canadianNetwork)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
canadianNetwork.CanadianNetworkNum = DbHelper.GetNextOracleKey("canadiannetwork", "CanadianNetworkNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(canadianNetwork, true));
}
catch (Oracle.DataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
canadianNetwork.CanadianNetworkNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(canadianNetwork, false));
}
}
///<summary>Inserts one CanadianNetwork into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(CanadianNetwork canadianNetwork, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO canadiannetwork (";
if (!useExistingPK && isRandomKeys)
{
canadianNetwork.CanadianNetworkNum = ReplicationServers.GetKeyNoCache("canadiannetwork", "CanadianNetworkNum");
}
if (isRandomKeys || useExistingPK)
{
command += "CanadianNetworkNum,";
}
command += "Abbrev,Descript,CanadianTransactionPrefix,CanadianIsRprHandler) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(canadianNetwork.CanadianNetworkNum) + ",";
}
command +=
"'" + POut.String(canadianNetwork.Abbrev) + "',"
+ "'" + POut.String(canadianNetwork.Descript) + "',"
+ "'" + POut.String(canadianNetwork.CanadianTransactionPrefix) + "',"
+ POut.Bool(canadianNetwork.CanadianIsRprHandler) + ")";
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command);
}
else
{
canadianNetwork.CanadianNetworkNum = Db.NonQ(command, true, "CanadianNetworkNum", "canadianNetwork");
}
return(canadianNetwork.CanadianNetworkNum);
}
///<summary></summary>
public static void Insert(CanadianNetwork network)
{
if (PrefB.RandomKeys)
{
network.CanadianNetworkNum = MiscData.GetKey("canadiannetwork", "CanadianNetworkNum");
}
string command = "INSERT INTO canadiannetwork (";
if (PrefB.RandomKeys)
{
command += "CanadianNetworkNum,";
}
command += "Abbrev, Descript) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(network.CanadianNetworkNum) + "', ";
}
command +=
"'" + POut.PString(network.Abbrev) + "', "
+ "'" + POut.PString(network.Descript) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
network.CanadianNetworkNum = General.NonQ(command, true);
}
}
///<summary>Inserts one CanadianNetwork into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(CanadianNetwork canadianNetwork,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
canadianNetwork.CanadianNetworkNum=ReplicationServers.GetKey("canadiannetwork","CanadianNetworkNum");
}
string command="INSERT INTO canadiannetwork (";
if(useExistingPK || PrefC.RandomKeys) {
command+="CanadianNetworkNum,";
}
command+="Abbrev,Descript,CanadianTransactionPrefix,CanadianIsRprHandler) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(canadianNetwork.CanadianNetworkNum)+",";
}
command+=
"'"+POut.String(canadianNetwork.Abbrev)+"',"
+"'"+POut.String(canadianNetwork.Descript)+"',"
+"'"+POut.String(canadianNetwork.CanadianTransactionPrefix)+"',"
+ POut.Bool (canadianNetwork.CanadianIsRprHandler)+")";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
canadianNetwork.CanadianNetworkNum=Db.NonQ(command,true);
}
return canadianNetwork.CanadianNetworkNum;
}
private static string Run(int scriptNum, Carrier carrier, CanadianNetwork network, Provider prov, out Etrans etrans, DateTime reconciliationDate)
{
string retVal = "";
etrans = CanadianOutput.GetSummaryReconciliation(carrier, network, prov, reconciliationDate);
retVal += "Summary Reconciliation#" + scriptNum.ToString() + " successful.\r\n";
return(retVal);
}
///<summary></summary>
public static void Update(CanadianNetwork Cur)
{
string command = "UPDATE canadiannetwork SET "
+ "Abbrev = '" + POut.PString(Cur.Abbrev) + "' "
+ ",Descript='" + POut.PString(Cur.Descript) + "' "
+ "WHERE CanadianNetworkNum = '" + POut.PInt(Cur.CanadianNetworkNum) + "'";
General.NonQ(command);
}
private static string Run(int scriptNum, Carrier carrier, CanadianNetwork network, Provider prov, out Etrans etrans, DateTime reconciliationDate)
{
string retVal = "";
Clearinghouse clearinghouseHq = Canadian.GetCanadianClearinghouseHq(carrier);
Clearinghouse clearinghouseClin = Clearinghouses.OverrideFields(clearinghouseHq, Clinics.ClinicNum);
etrans = CanadianOutput.GetSummaryReconciliation(clearinghouseClin, carrier, network, prov, reconciliationDate);
retVal += "Summary Reconciliation#" + scriptNum.ToString() + " successful.\r\n";
return(retVal);
}
///<summary>Updates one CanadianNetwork in the database.</summary>
public static void Update(CanadianNetwork canadianNetwork)
{
string command = "UPDATE canadiannetwork SET "
+ "Abbrev = '" + POut.String(canadianNetwork.Abbrev) + "', "
+ "Descript = '" + POut.String(canadianNetwork.Descript) + "', "
+ "CanadianTransactionPrefix= '" + POut.String(canadianNetwork.CanadianTransactionPrefix) + "', "
+ "CanadianIsRprHandler = " + POut.Bool(canadianNetwork.CanadianIsRprHandler) + " "
+ "WHERE CanadianNetworkNum = " + POut.Long(canadianNetwork.CanadianNetworkNum);
Db.NonQ(command);
}
public static string RunTwo()
{
CanadianNetwork network = new CanadianNetwork();
network.Descript = "Network 2";
network.Abbrev = "Network 2";
network.CanadianNetworkNum = 2;
network.CanadianTransactionPrefix = "A";
Provider prov = Providers.GetProv(PrefC.GetLong(PrefName.PracticeDefaultProv));
Etrans etransAck;
return(Run(2, null, network, prov, out etransAck, new DateTime(1999, 6, 1)));
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<CanadianNetwork> TableToList(DataTable table){
List<CanadianNetwork> retVal=new List<CanadianNetwork>();
CanadianNetwork canadianNetwork;
for(int i=0;i<table.Rows.Count;i++) {
canadianNetwork=new CanadianNetwork();
canadianNetwork.CanadianNetworkNum = PIn.Long (table.Rows[i]["CanadianNetworkNum"].ToString());
canadianNetwork.Abbrev = PIn.String(table.Rows[i]["Abbrev"].ToString());
canadianNetwork.Descript = PIn.String(table.Rows[i]["Descript"].ToString());
canadianNetwork.CanadianTransactionPrefix= PIn.String(table.Rows[i]["CanadianTransactionPrefix"].ToString());
canadianNetwork.CanadianIsRprHandler = PIn.Bool (table.Rows[i]["CanadianIsRprHandler"].ToString());
retVal.Add(canadianNetwork);
}
return retVal;
}
///<summary>Inserts one CanadianNetwork into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(CanadianNetwork canadianNetwork)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(canadianNetwork, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
canadianNetwork.CanadianNetworkNum = DbHelper.GetNextOracleKey("canadiannetwork", "CanadianNetworkNum"); //Cacheless method
}
return(InsertNoCache(canadianNetwork, true));
}
}
///<summary></summary>
public static void Refresh()
{
string command = "SELECT * FROM canadiannetwork";
DataTable table = General.GetTable(command);
listt = new List <CanadianNetwork>();
CanadianNetwork network;
for (int i = 0; i < table.Rows.Count; i++)
{
network = new CanadianNetwork();
network.CanadianNetworkNum = PIn.PInt(table.Rows[i][0].ToString());
network.Abbrev = PIn.PString(table.Rows[i][1].ToString());
network.Descript = PIn.PString(table.Rows[i][2].ToString());
listt.Add(network);
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <CanadianNetwork> TableToList(DataTable table)
{
List <CanadianNetwork> retVal = new List <CanadianNetwork>();
CanadianNetwork canadianNetwork;
foreach (DataRow row in table.Rows)
{
canadianNetwork = new CanadianNetwork();
canadianNetwork.CanadianNetworkNum = PIn.Long(row["CanadianNetworkNum"].ToString());
canadianNetwork.Abbrev = PIn.String(row["Abbrev"].ToString());
canadianNetwork.Descript = PIn.String(row["Descript"].ToString());
canadianNetwork.CanadianTransactionPrefix = PIn.String(row["CanadianTransactionPrefix"].ToString());
canadianNetwork.CanadianIsRprHandler = PIn.Bool(row["CanadianIsRprHandler"].ToString());
retVal.Add(canadianNetwork);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <CanadianNetwork> TableToList(DataTable table)
{
List <CanadianNetwork> retVal = new List <CanadianNetwork>();
CanadianNetwork canadianNetwork;
for (int i = 0; i < table.Rows.Count; i++)
{
canadianNetwork = new CanadianNetwork();
canadianNetwork.CanadianNetworkNum = PIn.Long(table.Rows[i]["CanadianNetworkNum"].ToString());
canadianNetwork.Abbrev = PIn.String(table.Rows[i]["Abbrev"].ToString());
canadianNetwork.Descript = PIn.String(table.Rows[i]["Descript"].ToString());
canadianNetwork.CanadianTransactionPrefix = PIn.String(table.Rows[i]["CanadianTransactionPrefix"].ToString());
canadianNetwork.CanadianIsRprHandler = PIn.Bool(table.Rows[i]["CanadianIsRprHandler"].ToString());
retVal.Add(canadianNetwork);
}
return(retVal);
}
///<summary>Updates one CanadianNetwork in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(CanadianNetwork canadianNetwork, CanadianNetwork oldCanadianNetwork)
{
string command = "";
if (canadianNetwork.Abbrev != oldCanadianNetwork.Abbrev)
{
if (command != "")
{
command += ",";
}
command += "Abbrev = '" + POut.String(canadianNetwork.Abbrev) + "'";
}
if (canadianNetwork.Descript != oldCanadianNetwork.Descript)
{
if (command != "")
{
command += ",";
}
command += "Descript = '" + POut.String(canadianNetwork.Descript) + "'";
}
if (canadianNetwork.CanadianTransactionPrefix != oldCanadianNetwork.CanadianTransactionPrefix)
{
if (command != "")
{
command += ",";
}
command += "CanadianTransactionPrefix = '" + POut.String(canadianNetwork.CanadianTransactionPrefix) + "'";
}
if (canadianNetwork.CanadianIsRprHandler != oldCanadianNetwork.CanadianIsRprHandler)
{
if (command != "")
{
command += ",";
}
command += "CanadianIsRprHandler = " + POut.Bool(canadianNetwork.CanadianIsRprHandler) + "";
}
if (command == "")
{
return(false);
}
command = "UPDATE canadiannetwork SET " + command
+ " WHERE CanadianNetworkNum = " + POut.Long(canadianNetwork.CanadianNetworkNum);
Db.NonQ(command);
return(true);
}
///<summary>Returns true if Update(CanadianNetwork,CanadianNetwork) would make changes to the database.
///Does not make any changes to the database and can be called before remoting role is checked.</summary>
public static bool UpdateComparison(CanadianNetwork canadianNetwork, CanadianNetwork oldCanadianNetwork)
{
if (canadianNetwork.Abbrev != oldCanadianNetwork.Abbrev)
{
return(true);
}
if (canadianNetwork.Descript != oldCanadianNetwork.Descript)
{
return(true);
}
if (canadianNetwork.CanadianTransactionPrefix != oldCanadianNetwork.CanadianTransactionPrefix)
{
return(true);
}
if (canadianNetwork.CanadianIsRprHandler != oldCanadianNetwork.CanadianIsRprHandler)
{
return(true);
}
return(false);
}
///<summary>Inserts one CanadianNetwork into the database. Returns the new priKey.</summary>
public static long Insert(CanadianNetwork canadianNetwork)
{
return(Insert(canadianNetwork, false));
}
public static string SetInitialCarriers()
{
//We are starting with zero carriers
CanadianNetwork network = new CanadianNetwork();
network.Abbrev = "CDANET14";
network.Descript = "CDANET14";
network.CanadianTransactionPrefix = "CDANET14";
CanadianNetworks.Insert(network);
Carrier carrier = new Carrier();
carrier.IsCDA = true;
carrier.CarrierName = "Carrier 1";
carrier.CanadianNetworkNum = network.CanadianNetworkNum;
carrier.CDAnetVersion = "04";
carrier.ElectID = "666666";
carrier.CanadianEncryptionMethod = 2;
carrier.CanadianSupportedTypes
//claim_01 is implied
= CanSupTransTypes.CobClaimTransaction_07
//claimAck_11 is implied
//claimEob_21 is implied
| CanSupTransTypes.ClaimReversal_02
| CanSupTransTypes.ClaimReversalResponse_12
| CanSupTransTypes.PredeterminationSinglePage_03
| CanSupTransTypes.PredeterminationMultiPage_03
| CanSupTransTypes.RequestForOutstandingTrans_04
| CanSupTransTypes.EmailTransaction_24
| CanSupTransTypes.RequestForSummaryReconciliation_05
| CanSupTransTypes.RequestForPaymentReconciliation_06;
Carriers.Insert(carrier);
//Carrier2---------------------------------------------------
network = new CanadianNetwork();
network.Abbrev = "A";
network.Descript = "A";
network.CanadianTransactionPrefix = "A";
CanadianNetworks.Insert(network);
carrier = new Carrier();
carrier.IsCDA = true;
carrier.CarrierName = "Carrier 2";
carrier.CanadianNetworkNum = network.CanadianNetworkNum;
carrier.CDAnetVersion = "04";
carrier.ElectID = "777777";
carrier.CanadianEncryptionMethod = 1;
carrier.CanadianSupportedTypes
= CanSupTransTypes.EligibilityTransaction_08
//claim_01 is implied
//claimAck_11 is implied
//claimEob_21 is implied
| CanSupTransTypes.ClaimReversal_02
| CanSupTransTypes.PredeterminationSinglePage_03
| CanSupTransTypes.RequestForOutstandingTrans_04
| CanSupTransTypes.EmailTransaction_24
| CanSupTransTypes.RequestForPaymentReconciliation_06;
Carriers.Insert(carrier);
//Carrier3---------------------------------------------------
network = new CanadianNetwork();
network.Abbrev = "AB";
network.Descript = "AB";
network.CanadianTransactionPrefix = "AB";
CanadianNetworks.Insert(network);
carrier = new Carrier();
carrier.IsCDA = true;
carrier.CarrierName = "Carrier 3";
carrier.CanadianNetworkNum = network.CanadianNetworkNum;
carrier.CDAnetVersion = "04";
carrier.ElectID = "888888";
carrier.CanadianEncryptionMethod = 2;
carrier.CanadianSupportedTypes
= CanSupTransTypes.EligibilityTransaction_08
//claim_01 is implied
| CanSupTransTypes.CobClaimTransaction_07
//claimAck_11 is implied
//claimEob_21 is implied
| CanSupTransTypes.ClaimReversal_02
| CanSupTransTypes.PredeterminationSinglePage_03
| CanSupTransTypes.RequestForOutstandingTrans_04
| CanSupTransTypes.EmailTransaction_24
| CanSupTransTypes.RequestForPaymentReconciliation_06;
Carriers.Insert(carrier);
//Carrier4---------------------------------------------------
network = new CanadianNetwork();
network.Abbrev = "ABC";
network.Descript = "ABC";
network.CanadianTransactionPrefix = "ABC";
CanadianNetworks.Insert(network);
carrier = new Carrier();
carrier.IsCDA = true;
carrier.CarrierName = "Carrier 4";
carrier.CanadianNetworkNum = network.CanadianNetworkNum;
carrier.CDAnetVersion = "04";
carrier.ElectID = "999111";
carrier.CanadianEncryptionMethod = 2;
carrier.CanadianSupportedTypes
= CanSupTransTypes.EligibilityTransaction_08
//claim_01 is implied
| CanSupTransTypes.CobClaimTransaction_07
//claimAck_11 is implied
//claimEob_21 is implied
| CanSupTransTypes.ClaimReversal_02
| CanSupTransTypes.PredeterminationSinglePage_03
| CanSupTransTypes.RequestForOutstandingTrans_04
| CanSupTransTypes.EmailTransaction_24
| CanSupTransTypes.RequestForPaymentReconciliation_06;
Carriers.Insert(carrier);
//Carrier5---------------------------------------------------
network = new CanadianNetwork();
network.Abbrev = "V2CAR";
network.Descript = "V2CAR";
network.CanadianTransactionPrefix = "V2CAR";
CanadianNetworks.Insert(network);
carrier = new Carrier();
carrier.IsCDA = true;
carrier.CarrierName = "Carrier 5";
carrier.CanadianNetworkNum = network.CanadianNetworkNum;
carrier.CDAnetVersion = "02";
carrier.ElectID = "555555";
carrier.CanadianEncryptionMethod = 0; //not applicable
carrier.CanadianSupportedTypes
= CanSupTransTypes.EligibilityTransaction_08
| CanSupTransTypes.EligibilityResponse_18
//claim_01 is implied
//claimAck_11 is implied
//claimEob_21 is implied
| CanSupTransTypes.ClaimReversal_02
| CanSupTransTypes.PredeterminationSinglePage_03
| CanSupTransTypes.PredeterminationMultiPage_03;
Carriers.Insert(carrier);
//---------------------------------------------------------
//Used for Payment Reconciliation test #3 and Summary Reconciliation test #3
network = new CanadianNetwork();
network.Abbrev = "ABC";
network.Descript = "ABC";
network.CanadianTransactionPrefix = "ABC";
CanadianNetworks.Insert(network);
carrier = new Carrier();
carrier.IsCDA = true;
carrier.CarrierName = "111555";
carrier.CanadianNetworkNum = network.CanadianNetworkNum;
carrier.CDAnetVersion = "04";
carrier.ElectID = "111555";
carrier.CanadianEncryptionMethod = 0; //not applicable
carrier.CanadianSupportedTypes
= CanSupTransTypes.PaymentReconciliation_16;
Carriers.Insert(carrier);
return("Carrier objects set.\r\n");
}
///<summary>Updates one CanadianNetwork in the database.</summary>
internal static void Update(CanadianNetwork canadianNetwork)
{
string command="UPDATE canadiannetwork SET "
+"Abbrev = '"+POut.String(canadianNetwork.Abbrev)+"', "
+"Descript = '"+POut.String(canadianNetwork.Descript)+"', "
+"CanadianTransactionPrefix= '"+POut.String(canadianNetwork.CanadianTransactionPrefix)+"', "
+"CanadianIsRprHandler = "+POut.Bool (canadianNetwork.CanadianIsRprHandler)+" "
+"WHERE CanadianNetworkNum = "+POut.Long(canadianNetwork.CanadianNetworkNum);
Db.NonQ(command);
}
///<summary>Updates one CanadianNetwork in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables.</summary>
internal static void Update(CanadianNetwork canadianNetwork,CanadianNetwork oldCanadianNetwork)
{
string command="";
if(canadianNetwork.Abbrev != oldCanadianNetwork.Abbrev) {
if(command!=""){ command+=",";}
command+="Abbrev = '"+POut.String(canadianNetwork.Abbrev)+"'";
}
if(canadianNetwork.Descript != oldCanadianNetwork.Descript) {
if(command!=""){ command+=",";}
command+="Descript = '"+POut.String(canadianNetwork.Descript)+"'";
}
if(canadianNetwork.CanadianTransactionPrefix != oldCanadianNetwork.CanadianTransactionPrefix) {
if(command!=""){ command+=",";}
command+="CanadianTransactionPrefix = '"+POut.String(canadianNetwork.CanadianTransactionPrefix)+"'";
}
if(canadianNetwork.CanadianIsRprHandler != oldCanadianNetwork.CanadianIsRprHandler) {
if(command!=""){ command+=",";}
command+="CanadianIsRprHandler = "+POut.Bool(canadianNetwork.CanadianIsRprHandler)+"";
}
if(command==""){
return;
}
command="UPDATE canadiannetwork SET "+command
+" WHERE CanadianNetworkNum = "+POut.Long(canadianNetwork.CanadianNetworkNum);
Db.NonQ(command);
}
