///<summary>Inserts one EServiceBilling into the database. Returns the new priKey.</summary>
public static long Insert(EServiceBilling eServiceBilling)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
eServiceBilling.EServiceBillingNum = DbHelper.GetNextOracleKey("eservicebilling", "EServiceBillingNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(eServiceBilling, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
eServiceBilling.EServiceBillingNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(eServiceBilling, false));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EServiceBilling> TableToList(DataTable table)
{
List <EServiceBilling> retVal = new List <EServiceBilling>();
EServiceBilling eServiceBilling;
foreach (DataRow row in table.Rows)
{
eServiceBilling = new EServiceBilling();
eServiceBilling.EServiceBillingNum = PIn.Long(row["EServiceBillingNum"].ToString());
eServiceBilling.RegistrationKeyNum = PIn.Long(row["RegistrationKeyNum"].ToString());
eServiceBilling.CustPatNum = PIn.Long(row["CustPatNum"].ToString());
eServiceBilling.BillingCycleDay = PIn.Int(row["BillingCycleDay"].ToString());
eServiceBilling.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
eServiceBilling.DateTimeProceduresPosted = PIn.DateT(row["DateTimeProceduresPosted"].ToString());
eServiceBilling.DateOfBill = PIn.Date(row["DateOfBill"].ToString());
eServiceBilling.MonthOfBill = PIn.Date(row["MonthOfBill"].ToString());
eServiceBilling.BillCycleStart = PIn.Date(row["BillCycleStart"].ToString());
eServiceBilling.BillCycleEnd = PIn.Date(row["BillCycleEnd"].ToString());
eServiceBilling.UsageCycleStart = PIn.Date(row["UsageCycleStart"].ToString());
eServiceBilling.UsageCycleEnd = PIn.Date(row["UsageCycleEnd"].ToString());
eServiceBilling.ProceduresJson = PIn.String(row["ProceduresJson"].ToString());
eServiceBilling.ChargesJson = PIn.String(row["ChargesJson"].ToString());
eServiceBilling.NexmoInfoJson = PIn.String(row["NexmoInfoJson"].ToString());
eServiceBilling.LogInfo = PIn.String(row["LogInfo"].ToString());
retVal.Add(eServiceBilling);
}
return(retVal);
}
///<summary>Updates one EServiceBilling in the database.</summary>
public static void Update(EServiceBilling eServiceBilling)
{
string command = "UPDATE eservicebilling SET "
+ "RegistrationKeyNum = " + POut.Long(eServiceBilling.RegistrationKeyNum) + ", "
+ "CustPatNum = " + POut.Long(eServiceBilling.CustPatNum) + ", "
+ "BillingCycleDay = " + POut.Int(eServiceBilling.BillingCycleDay) + ", "
//DateTimeEntry not allowed to change
+ "DateTimeProceduresPosted= " + POut.DateT(eServiceBilling.DateTimeProceduresPosted) + ", "
+ "DateOfBill = " + POut.Date(eServiceBilling.DateOfBill) + ", "
+ "MonthOfBill = " + POut.Date(eServiceBilling.MonthOfBill) + ", "
+ "BillCycleStart = " + POut.Date(eServiceBilling.BillCycleStart) + ", "
+ "BillCycleEnd = " + POut.Date(eServiceBilling.BillCycleEnd) + ", "
+ "UsageCycleStart = " + POut.Date(eServiceBilling.UsageCycleStart) + ", "
+ "UsageCycleEnd = " + POut.Date(eServiceBilling.UsageCycleEnd) + ", "
+ "ProceduresJson = " + DbHelper.ParamChar + "paramProceduresJson, "
+ "ChargesJson = " + DbHelper.ParamChar + "paramChargesJson, "
+ "NexmoInfoJson = " + DbHelper.ParamChar + "paramNexmoInfoJson, "
+ "LogInfo = " + DbHelper.ParamChar + "paramLogInfo, "
+ "ItemizedCharges = " + DbHelper.ParamChar + "paramItemizedCharges "
+ "WHERE EServiceBillingNum = " + POut.Long(eServiceBilling.EServiceBillingNum);
if (eServiceBilling.ProceduresJson == null)
{
eServiceBilling.ProceduresJson = "";
}
OdSqlParameter paramProceduresJson = new OdSqlParameter("paramProceduresJson", OdDbType.Text, POut.StringParam(eServiceBilling.ProceduresJson));
if (eServiceBilling.ChargesJson == null)
{
eServiceBilling.ChargesJson = "";
}
OdSqlParameter paramChargesJson = new OdSqlParameter("paramChargesJson", OdDbType.Text, POut.StringParam(eServiceBilling.ChargesJson));
if (eServiceBilling.NexmoInfoJson == null)
{
eServiceBilling.NexmoInfoJson = "";
}
OdSqlParameter paramNexmoInfoJson = new OdSqlParameter("paramNexmoInfoJson", OdDbType.Text, POut.StringParam(eServiceBilling.NexmoInfoJson));
if (eServiceBilling.LogInfo == null)
{
eServiceBilling.LogInfo = "";
}
OdSqlParameter paramLogInfo = new OdSqlParameter("paramLogInfo", OdDbType.Text, POut.StringParam(eServiceBilling.LogInfo));
if (eServiceBilling.ItemizedCharges == null)
{
eServiceBilling.ItemizedCharges = "";
}
OdSqlParameter paramItemizedCharges = new OdSqlParameter("paramItemizedCharges", OdDbType.Text, POut.StringParam(eServiceBilling.ItemizedCharges));
Db.NonQ(command, paramProceduresJson, paramChargesJson, paramNexmoInfoJson, paramLogInfo, paramItemizedCharges);
}
///<summary>Inserts one EServiceBilling into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EServiceBilling eServiceBilling)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(eServiceBilling, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
eServiceBilling.EServiceBillingNum = DbHelper.GetNextOracleKey("eservicebilling", "EServiceBillingNum"); //Cacheless method
}
return(InsertNoCache(eServiceBilling, true));
}
}
///<summary>Returns true if Update(EServiceBilling,EServiceBilling) 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(EServiceBilling eServiceBilling, EServiceBilling oldEServiceBilling)
{
if (eServiceBilling.RegistrationKeyNum != oldEServiceBilling.RegistrationKeyNum)
{
return(true);
}
if (eServiceBilling.CustPatNum != oldEServiceBilling.CustPatNum)
{
return(true);
}
if (eServiceBilling.BillingCycleDay != oldEServiceBilling.BillingCycleDay)
{
return(true);
}
//DateTimeEntry not allowed to change
if (eServiceBilling.DateTimeProceduresPosted != oldEServiceBilling.DateTimeProceduresPosted)
{
return(true);
}
if (eServiceBilling.DateOfBill.Date != oldEServiceBilling.DateOfBill.Date)
{
return(true);
}
if (eServiceBilling.MonthOfBill.Date != oldEServiceBilling.MonthOfBill.Date)
{
return(true);
}
if (eServiceBilling.BillCycleStart.Date != oldEServiceBilling.BillCycleStart.Date)
{
return(true);
}
if (eServiceBilling.BillCycleEnd.Date != oldEServiceBilling.BillCycleEnd.Date)
{
return(true);
}
if (eServiceBilling.UsageCycleStart.Date != oldEServiceBilling.UsageCycleStart.Date)
{
return(true);
}
if (eServiceBilling.UsageCycleEnd.Date != oldEServiceBilling.UsageCycleEnd.Date)
{
return(true);
}
if (eServiceBilling.ProceduresJson != oldEServiceBilling.ProceduresJson)
{
return(true);
}
if (eServiceBilling.ChargesJson != oldEServiceBilling.ChargesJson)
{
return(true);
}
if (eServiceBilling.NexmoInfoJson != oldEServiceBilling.NexmoInfoJson)
{
return(true);
}
if (eServiceBilling.LogInfo != oldEServiceBilling.LogInfo)
{
return(true);
}
return(false);
}
///<summary>Updates one EServiceBilling 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(EServiceBilling eServiceBilling, EServiceBilling oldEServiceBilling)
{
string command = "";
if (eServiceBilling.RegistrationKeyNum != oldEServiceBilling.RegistrationKeyNum)
{
if (command != "")
{
command += ",";
}
command += "RegistrationKeyNum = " + POut.Long(eServiceBilling.RegistrationKeyNum) + "";
}
if (eServiceBilling.CustPatNum != oldEServiceBilling.CustPatNum)
{
if (command != "")
{
command += ",";
}
command += "CustPatNum = " + POut.Long(eServiceBilling.CustPatNum) + "";
}
if (eServiceBilling.BillingCycleDay != oldEServiceBilling.BillingCycleDay)
{
if (command != "")
{
command += ",";
}
command += "BillingCycleDay = " + POut.Int(eServiceBilling.BillingCycleDay) + "";
}
//DateTimeEntry not allowed to change
if (eServiceBilling.DateTimeProceduresPosted != oldEServiceBilling.DateTimeProceduresPosted)
{
if (command != "")
{
command += ",";
}
command += "DateTimeProceduresPosted = " + POut.DateT(eServiceBilling.DateTimeProceduresPosted) + "";
}
if (eServiceBilling.DateOfBill.Date != oldEServiceBilling.DateOfBill.Date)
{
if (command != "")
{
command += ",";
}
command += "DateOfBill = " + POut.Date(eServiceBilling.DateOfBill) + "";
}
if (eServiceBilling.MonthOfBill.Date != oldEServiceBilling.MonthOfBill.Date)
{
if (command != "")
{
command += ",";
}
command += "MonthOfBill = " + POut.Date(eServiceBilling.MonthOfBill) + "";
}
if (eServiceBilling.BillCycleStart.Date != oldEServiceBilling.BillCycleStart.Date)
{
if (command != "")
{
command += ",";
}
command += "BillCycleStart = " + POut.Date(eServiceBilling.BillCycleStart) + "";
}
if (eServiceBilling.BillCycleEnd.Date != oldEServiceBilling.BillCycleEnd.Date)
{
if (command != "")
{
command += ",";
}
command += "BillCycleEnd = " + POut.Date(eServiceBilling.BillCycleEnd) + "";
}
if (eServiceBilling.UsageCycleStart.Date != oldEServiceBilling.UsageCycleStart.Date)
{
if (command != "")
{
command += ",";
}
command += "UsageCycleStart = " + POut.Date(eServiceBilling.UsageCycleStart) + "";
}
if (eServiceBilling.UsageCycleEnd.Date != oldEServiceBilling.UsageCycleEnd.Date)
{
if (command != "")
{
command += ",";
}
command += "UsageCycleEnd = " + POut.Date(eServiceBilling.UsageCycleEnd) + "";
}
if (eServiceBilling.ProceduresJson != oldEServiceBilling.ProceduresJson)
{
if (command != "")
{
command += ",";
}
command += "ProceduresJson = " + DbHelper.ParamChar + "paramProceduresJson";
}
if (eServiceBilling.ChargesJson != oldEServiceBilling.ChargesJson)
{
if (command != "")
{
command += ",";
}
command += "ChargesJson = " + DbHelper.ParamChar + "paramChargesJson";
}
if (eServiceBilling.NexmoInfoJson != oldEServiceBilling.NexmoInfoJson)
{
if (command != "")
{
command += ",";
}
command += "NexmoInfoJson = " + DbHelper.ParamChar + "paramNexmoInfoJson";
}
if (eServiceBilling.LogInfo != oldEServiceBilling.LogInfo)
{
if (command != "")
{
command += ",";
}
command += "LogInfo = " + DbHelper.ParamChar + "paramLogInfo";
}
if (command == "")
{
return(false);
}
if (eServiceBilling.ProceduresJson == null)
{
eServiceBilling.ProceduresJson = "";
}
OdSqlParameter paramProceduresJson = new OdSqlParameter("paramProceduresJson", OdDbType.Text, eServiceBilling.ProceduresJson);
if (eServiceBilling.ChargesJson == null)
{
eServiceBilling.ChargesJson = "";
}
OdSqlParameter paramChargesJson = new OdSqlParameter("paramChargesJson", OdDbType.Text, eServiceBilling.ChargesJson);
if (eServiceBilling.NexmoInfoJson == null)
{
eServiceBilling.NexmoInfoJson = "";
}
OdSqlParameter paramNexmoInfoJson = new OdSqlParameter("paramNexmoInfoJson", OdDbType.Text, eServiceBilling.NexmoInfoJson);
if (eServiceBilling.LogInfo == null)
{
eServiceBilling.LogInfo = "";
}
OdSqlParameter paramLogInfo = new OdSqlParameter("paramLogInfo", OdDbType.Text, eServiceBilling.LogInfo);
command = "UPDATE eservicebilling SET " + command
+ " WHERE EServiceBillingNum = " + POut.Long(eServiceBilling.EServiceBillingNum);
Db.NonQ(command, paramProceduresJson, paramChargesJson, paramNexmoInfoJson, paramLogInfo);
return(true);
}
///<summary>Inserts one EServiceBilling into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EServiceBilling eServiceBilling, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO eservicebilling (";
if (!useExistingPK && isRandomKeys)
{
eServiceBilling.EServiceBillingNum = ReplicationServers.GetKeyNoCache("eservicebilling", "EServiceBillingNum");
}
if (isRandomKeys || useExistingPK)
{
command += "EServiceBillingNum,";
}
command += "RegistrationKeyNum,CustPatNum,BillingCycleDay,DateTimeEntry,DateTimeProceduresPosted,DateOfBill,MonthOfBill,BillCycleStart,BillCycleEnd,UsageCycleStart,UsageCycleEnd,ProceduresJson,ChargesJson,NexmoInfoJson,LogInfo) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(eServiceBilling.EServiceBillingNum) + ",";
}
command +=
POut.Long(eServiceBilling.RegistrationKeyNum) + ","
+ POut.Long(eServiceBilling.CustPatNum) + ","
+ POut.Int(eServiceBilling.BillingCycleDay) + ","
+ DbHelper.Now() + ","
+ POut.DateT(eServiceBilling.DateTimeProceduresPosted) + ","
+ POut.Date(eServiceBilling.DateOfBill) + ","
+ POut.Date(eServiceBilling.MonthOfBill) + ","
+ POut.Date(eServiceBilling.BillCycleStart) + ","
+ POut.Date(eServiceBilling.BillCycleEnd) + ","
+ POut.Date(eServiceBilling.UsageCycleStart) + ","
+ POut.Date(eServiceBilling.UsageCycleEnd) + ","
+ DbHelper.ParamChar + "paramProceduresJson,"
+ DbHelper.ParamChar + "paramChargesJson,"
+ DbHelper.ParamChar + "paramNexmoInfoJson,"
+ DbHelper.ParamChar + "paramLogInfo)";
if (eServiceBilling.ProceduresJson == null)
{
eServiceBilling.ProceduresJson = "";
}
OdSqlParameter paramProceduresJson = new OdSqlParameter("paramProceduresJson", OdDbType.Text, eServiceBilling.ProceduresJson);
if (eServiceBilling.ChargesJson == null)
{
eServiceBilling.ChargesJson = "";
}
OdSqlParameter paramChargesJson = new OdSqlParameter("paramChargesJson", OdDbType.Text, eServiceBilling.ChargesJson);
if (eServiceBilling.NexmoInfoJson == null)
{
eServiceBilling.NexmoInfoJson = "";
}
OdSqlParameter paramNexmoInfoJson = new OdSqlParameter("paramNexmoInfoJson", OdDbType.Text, eServiceBilling.NexmoInfoJson);
if (eServiceBilling.LogInfo == null)
{
eServiceBilling.LogInfo = "";
}
OdSqlParameter paramLogInfo = new OdSqlParameter("paramLogInfo", OdDbType.Text, eServiceBilling.LogInfo);
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramProceduresJson, paramChargesJson, paramNexmoInfoJson, paramLogInfo);
}
else
{
eServiceBilling.EServiceBillingNum = Db.NonQ(command, true, paramProceduresJson, paramChargesJson, paramNexmoInfoJson, paramLogInfo);
}
return(eServiceBilling.EServiceBillingNum);
}
///<summary>Inserts one EServiceBilling into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EServiceBilling eServiceBilling)
{
return(InsertNoCache(eServiceBilling, false));
}
///<summary>Inserts one EServiceBilling into the database. Provides option to use the existing priKey.</summary>
public static long Insert(EServiceBilling eServiceBilling, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
eServiceBilling.EServiceBillingNum = ReplicationServers.GetKey("eservicebilling", "EServiceBillingNum");
}
string command = "INSERT INTO eservicebilling (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "EServiceBillingNum,";
}
command += "RegistrationKeyNum,CustPatNum,BillingCycleDay,DateTimeEntry,DateTimeProceduresPosted,DateOfBill,MonthOfBill,BillCycleStart,BillCycleEnd,UsageCycleStart,UsageCycleEnd,ProceduresJson,ChargesJson,NexmoInfoJson,LogInfo,ItemizedCharges) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(eServiceBilling.EServiceBillingNum) + ",";
}
command +=
POut.Long(eServiceBilling.RegistrationKeyNum) + ","
+ POut.Long(eServiceBilling.CustPatNum) + ","
+ POut.Int(eServiceBilling.BillingCycleDay) + ","
+ DbHelper.Now() + ","
+ POut.DateT(eServiceBilling.DateTimeProceduresPosted) + ","
+ POut.Date(eServiceBilling.DateOfBill) + ","
+ POut.Date(eServiceBilling.MonthOfBill) + ","
+ POut.Date(eServiceBilling.BillCycleStart) + ","
+ POut.Date(eServiceBilling.BillCycleEnd) + ","
+ POut.Date(eServiceBilling.UsageCycleStart) + ","
+ POut.Date(eServiceBilling.UsageCycleEnd) + ","
+ DbHelper.ParamChar + "paramProceduresJson,"
+ DbHelper.ParamChar + "paramChargesJson,"
+ DbHelper.ParamChar + "paramNexmoInfoJson,"
+ DbHelper.ParamChar + "paramLogInfo,"
+ DbHelper.ParamChar + "paramItemizedCharges)";
if (eServiceBilling.ProceduresJson == null)
{
eServiceBilling.ProceduresJson = "";
}
OdSqlParameter paramProceduresJson = new OdSqlParameter("paramProceduresJson", OdDbType.Text, POut.StringParam(eServiceBilling.ProceduresJson));
if (eServiceBilling.ChargesJson == null)
{
eServiceBilling.ChargesJson = "";
}
OdSqlParameter paramChargesJson = new OdSqlParameter("paramChargesJson", OdDbType.Text, POut.StringParam(eServiceBilling.ChargesJson));
if (eServiceBilling.NexmoInfoJson == null)
{
eServiceBilling.NexmoInfoJson = "";
}
OdSqlParameter paramNexmoInfoJson = new OdSqlParameter("paramNexmoInfoJson", OdDbType.Text, POut.StringParam(eServiceBilling.NexmoInfoJson));
if (eServiceBilling.LogInfo == null)
{
eServiceBilling.LogInfo = "";
}
OdSqlParameter paramLogInfo = new OdSqlParameter("paramLogInfo", OdDbType.Text, POut.StringParam(eServiceBilling.LogInfo));
if (eServiceBilling.ItemizedCharges == null)
{
eServiceBilling.ItemizedCharges = "";
}
OdSqlParameter paramItemizedCharges = new OdSqlParameter("paramItemizedCharges", OdDbType.Text, POut.StringParam(eServiceBilling.ItemizedCharges));
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramProceduresJson, paramChargesJson, paramNexmoInfoJson, paramLogInfo, paramItemizedCharges);
}
else
{
eServiceBilling.EServiceBillingNum = Db.NonQ(command, true, "EServiceBillingNum", "eServiceBilling", paramProceduresJson, paramChargesJson, paramNexmoInfoJson, paramLogInfo, paramItemizedCharges);
}
return(eServiceBilling.EServiceBillingNum);
}
