///<summary>Converts a DataTable to a list of objects.</summary>
public static List <OIDInternal> TableToList(DataTable table)
{
List <OIDInternal> retVal = new List <OIDInternal>();
OIDInternal oIDInternal;
foreach (DataRow row in table.Rows)
{
oIDInternal = new OIDInternal();
oIDInternal.OIDInternalNum = PIn.Long(row["OIDInternalNum"].ToString());
string iDType = row["IDType"].ToString();
if (iDType == "")
{
oIDInternal.IDType = (OpenDentBusiness.IdentifierType) 0;
}
else
{
try{
oIDInternal.IDType = (OpenDentBusiness.IdentifierType)Enum.Parse(typeof(OpenDentBusiness.IdentifierType), iDType);
}
catch {
oIDInternal.IDType = (OpenDentBusiness.IdentifierType) 0;
}
}
oIDInternal.IDRoot = PIn.String(row["IDRoot"].ToString());
retVal.Add(oIDInternal);
}
return(retVal);
}
///<summary>Updates one OIDInternal 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(OIDInternal oIDInternal, OIDInternal oldOIDInternal)
{
string command = "";
if (oIDInternal.IDType != oldOIDInternal.IDType)
{
if (command != "")
{
command += ",";
}
command += "IDType = '" + POut.String(oIDInternal.IDType.ToString()) + "'";
}
if (oIDInternal.IDRoot != oldOIDInternal.IDRoot)
{
if (command != "")
{
command += ",";
}
command += "IDRoot = '" + POut.String(oIDInternal.IDRoot) + "'";
}
if (command == "")
{
return(false);
}
command = "UPDATE oidinternal SET " + command
+ " WHERE OIDInternalNum = " + POut.Long(oIDInternal.OIDInternalNum);
Db.NonQ(command);
return(true);
}
///<summary>Inserts one OIDInternal into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(OIDInternal oIDInternal, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO oidinternal (";
if (!useExistingPK && isRandomKeys)
{
oIDInternal.OIDInternalNum = ReplicationServers.GetKeyNoCache("oidinternal", "OIDInternalNum");
}
if (isRandomKeys || useExistingPK)
{
command += "OIDInternalNum,";
}
command += "IDType,IDRoot) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(oIDInternal.OIDInternalNum) + ",";
}
command +=
"'" + POut.String(oIDInternal.IDType.ToString()) + "',"
+ "'" + POut.String(oIDInternal.IDRoot) + "')";
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command);
}
else
{
oIDInternal.OIDInternalNum = Db.NonQ(command, true, "OIDInternalNum", "oIDInternal");
}
return(oIDInternal.OIDInternalNum);
}
///<summary>Inserts one OIDInternal into the database. Provides option to use the existing priKey.</summary>
public static long Insert(OIDInternal oIDInternal, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
oIDInternal.OIDInternalNum = ReplicationServers.GetKey("oidinternal", "OIDInternalNum");
}
string command = "INSERT INTO oidinternal (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "OIDInternalNum,";
}
command += "IDType,IDRoot) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(oIDInternal.OIDInternalNum) + ",";
}
command +=
"'" + POut.String(oIDInternal.IDType.ToString()) + "',"
+ "'" + POut.String(oIDInternal.IDRoot) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
oIDInternal.OIDInternalNum = Db.NonQ(command, true, "OIDInternalNum", "oIDInternal");
}
return(oIDInternal.OIDInternalNum);
}
///<summary>Inserts one OIDInternal into the database. Returns the new priKey.</summary>
public static long Insert(OIDInternal oIDInternal)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
oIDInternal.OIDInternalNum = DbHelper.GetNextOracleKey("oidinternal", "OIDInternalNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(oIDInternal, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
oIDInternal.OIDInternalNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(oIDInternal, false));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <OIDInternal> TableToList(DataTable table)
{
List <OIDInternal> retVal = new List <OIDInternal>();
OIDInternal oIDInternal;
for (int i = 0; i < table.Rows.Count; i++)
{
oIDInternal = new OIDInternal();
oIDInternal.OIDInternalNum = PIn.Long(table.Rows[i]["OIDInternalNum"].ToString());
string iDType = table.Rows[i]["IDType"].ToString();
if (iDType == "")
{
oIDInternal.IDType = (IdentifierType)0;
}
else
{
try{
oIDInternal.IDType = (IdentifierType)Enum.Parse(typeof(IdentifierType), iDType);
}
catch {
oIDInternal.IDType = (IdentifierType)0;
}
}
oIDInternal.IDRoot = PIn.String(table.Rows[i]["IDRoot"].ToString());
retVal.Add(oIDInternal);
}
return(retVal);
}
///<summary>Updates one OIDInternal in the database.</summary>
public static void Update(OIDInternal oIDInternal)
{
string command = "UPDATE oidinternal SET "
+ "IDType = '" + POut.String(oIDInternal.IDType.ToString()) + "', "
+ "IDRoot = '" + POut.String(oIDInternal.IDRoot) + "' "
+ "WHERE OIDInternalNum = " + POut.Long(oIDInternal.OIDInternalNum);
Db.NonQ(command);
}
///<summary>Returns true if Update(OIDInternal,OIDInternal) 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(OIDInternal oIDInternal, OIDInternal oldOIDInternal)
{
if (oIDInternal.IDType != oldOIDInternal.IDType)
{
return(true);
}
if (oIDInternal.IDRoot != oldOIDInternal.IDRoot)
{
return(true);
}
return(false);
}
private int sortOIDsByIDType(OIDInternal a, OIDInternal b)
{
if (a.IDType > b.IDType)
{
return(1);
}
if (a.IDType < b.IDType)
{
return(-1);
}
return(0); //should never happen.
}
///<summary>Inserts one OIDInternal into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(OIDInternal oIDInternal)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(oIDInternal, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
oIDInternal.OIDInternalNum = DbHelper.GetNextOracleKey("oidinternal", "OIDInternalNum"); //Cacheless method
}
return(InsertNoCache(oIDInternal, true));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<OIDInternal> TableToList(DataTable table){
List<OIDInternal> retVal=new List<OIDInternal>();
OIDInternal oIDInternal;
for(int i=0;i<table.Rows.Count;i++) {
oIDInternal=new OIDInternal();
oIDInternal.OIDInternalNum= PIn.Long (table.Rows[i]["OIDInternalNum"].ToString());
string iDType=table.Rows[i]["IDType"].ToString();
if(iDType==""){
oIDInternal.IDType =(IdentifierType)0;
}
else try{
oIDInternal.IDType =(IdentifierType)Enum.Parse(typeof(IdentifierType),iDType);
}
catch{
oIDInternal.IDType =(IdentifierType)0;
}
oIDInternal.IDRoot = PIn.String(table.Rows[i]["IDRoot"].ToString());
retVal.Add(oIDInternal);
}
return retVal;
}
///<summary>Inserts one OIDInternal into the database. Returns the new priKey.</summary>
public static long Insert(OIDInternal oIDInternal){
if(DataConnection.DBtype==DatabaseType.Oracle) {
oIDInternal.OIDInternalNum=DbHelper.GetNextOracleKey("oidinternal","OIDInternalNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(oIDInternal,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
oIDInternal.OIDInternalNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(oIDInternal,false);
}
}
///<summary>Inserts one OIDInternal into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(OIDInternal oIDInternal)
{
return(InsertNoCache(oIDInternal, false));
}
///<summary>Inserts one OIDInternal into the database. Provides option to use the existing priKey.</summary>
public static long Insert(OIDInternal oIDInternal,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
oIDInternal.OIDInternalNum=ReplicationServers.GetKey("oidinternal","OIDInternalNum");
}
string command="INSERT INTO oidinternal (";
if(useExistingPK || PrefC.RandomKeys) {
command+="OIDInternalNum,";
}
command+="IDType,IDRoot) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(oIDInternal.OIDInternalNum)+",";
}
command+=
"'"+POut.String(oIDInternal.IDType.ToString())+"',"
+"'"+POut.String(oIDInternal.IDRoot)+"')";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
oIDInternal.OIDInternalNum=Db.NonQ(command,true);
}
return oIDInternal.OIDInternalNum;
}
///<summary>Updates one OIDInternal 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>
public static void Update(OIDInternal oIDInternal,OIDInternal oldOIDInternal){
string command="";
if(oIDInternal.IDType != oldOIDInternal.IDType) {
if(command!=""){ command+=",";}
command+="IDType = '"+POut.String(oIDInternal.IDType.ToString())+"'";
}
if(oIDInternal.IDRoot != oldOIDInternal.IDRoot) {
if(command!=""){ command+=",";}
command+="IDRoot = '"+POut.String(oIDInternal.IDRoot)+"'";
}
if(command==""){
return;
}
command="UPDATE oidinternal SET "+command
+" WHERE OIDInternalNum = "+POut.Long(oIDInternal.OIDInternalNum);
Db.NonQ(command);
}
///<summary>Updates one OIDInternal in the database.</summary>
public static void Update(OIDInternal oIDInternal){
string command="UPDATE oidinternal SET "
+"IDType = '"+POut.String(oIDInternal.IDType.ToString())+"', "
+"IDRoot = '"+POut.String(oIDInternal.IDRoot)+"' "
+"WHERE OIDInternalNum = "+POut.Long(oIDInternal.OIDInternalNum);
Db.NonQ(command);
}
