///<summary>Inserts one AutoCodeCond into the database. Returns the new priKey.</summary>
public static long Insert(AutoCodeCond autoCodeCond)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
autoCodeCond.AutoCodeCondNum = DbHelper.GetNextOracleKey("autocodecond", "AutoCodeCondNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(autoCodeCond, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
autoCodeCond.AutoCodeCondNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(autoCodeCond, false));
}
}
///<summary></summary>
public static void Update(AutoCodeCond Cur){
string command = "UPDATE autocodecond SET "
+"autocodeitemnum='"+POut.PInt(Cur.AutoCodeItemNum)+"'"
+",cond ='" +POut.PInt((int)Cur.Cond)+"'"
+" WHERE autocodecondnum = '"+POut.PInt(Cur.AutoCodeCondNum)+"'";
General.NonQ(command);
}
///<summary>Inserts one AutoCodeCond into the database. Provides option to use the existing priKey.</summary>
public static long Insert(AutoCodeCond autoCodeCond, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
autoCodeCond.AutoCodeCondNum = ReplicationServers.GetKey("autocodecond", "AutoCodeCondNum");
}
string command = "INSERT INTO autocodecond (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "AutoCodeCondNum,";
}
command += "AutoCodeItemNum,Cond) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(autoCodeCond.AutoCodeCondNum) + ",";
}
command +=
POut.Long(autoCodeCond.AutoCodeItemNum) + ","
+ POut.Int((int)autoCodeCond.Cond) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
autoCodeCond.AutoCodeCondNum = Db.NonQ(command, true, "AutoCodeCondNum", "autoCodeCond");
}
return(autoCodeCond.AutoCodeCondNum);
}
private void butOK_Click(object sender, System.EventArgs e)
{
if (textADA.Text == "")
{
MessageBox.Show(Lan.g(this, "Code cannot be left blank."));
listConditions.SelectedIndex = -1;
FillList();
return;
}
AutoCodeItemCur.CodeNum = ProcedureCodes.GetCodeNum(textADA.Text);
if (IsNew)
{
AutoCodeItems.Insert(AutoCodeItemCur);
}
else
{
AutoCodeItems.Update(AutoCodeItemCur);
}
AutoCodeConds.DeleteForItemNum(AutoCodeItemCur.AutoCodeItemNum);
for (int i = 0; i < listConditions.SelectedIndices.Count; i++)
{
AutoCodeCond AutoCodeCondCur = new AutoCodeCond();
AutoCodeCondCur.AutoCodeItemNum = AutoCodeItemCur.AutoCodeItemNum;
AutoCodeCondCur.Cond = (AutoCondition)listConditions.SelectedIndices[i];
AutoCodeConds.Insert(AutoCodeCondCur);
}
DialogResult = DialogResult.OK;
}
///<summary>Updates one AutoCodeCond 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(AutoCodeCond autoCodeCond, AutoCodeCond oldAutoCodeCond)
{
string command = "";
if (autoCodeCond.AutoCodeItemNum != oldAutoCodeCond.AutoCodeItemNum)
{
if (command != "")
{
command += ",";
}
command += "AutoCodeItemNum = " + POut.Long(autoCodeCond.AutoCodeItemNum) + "";
}
if (autoCodeCond.Cond != oldAutoCodeCond.Cond)
{
if (command != "")
{
command += ",";
}
command += "Cond = " + POut.Int((int)autoCodeCond.Cond) + "";
}
if (command == "")
{
return(false);
}
command = "UPDATE autocodecond SET " + command
+ " WHERE AutoCodeCondNum = " + POut.Long(autoCodeCond.AutoCodeCondNum);
Db.NonQ(command);
return(true);
}
///<summary></summary>
public static void Delete(AutoCodeCond Cur)
{
string command = "DELETE from autocodecond WHERE autocodecondnum = '"
+ POut.PInt(Cur.AutoCodeCondNum) + "'";
General.NonQ(command);
}
///<summary>Inserts one AutoCodeCond into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(AutoCodeCond autoCodeCond, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO autocodecond (";
if (!useExistingPK && isRandomKeys)
{
autoCodeCond.AutoCodeCondNum = ReplicationServers.GetKeyNoCache("autocodecond", "AutoCodeCondNum");
}
if (isRandomKeys || useExistingPK)
{
command += "AutoCodeCondNum,";
}
command += "AutoCodeItemNum,Cond) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(autoCodeCond.AutoCodeCondNum) + ",";
}
command +=
POut.Long(autoCodeCond.AutoCodeItemNum) + ","
+ POut.Int((int)autoCodeCond.Cond) + ")";
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command);
}
else
{
autoCodeCond.AutoCodeCondNum = Db.NonQ(command, true, "AutoCodeCondNum", "autoCodeCond");
}
return(autoCodeCond.AutoCodeCondNum);
}
///<summary>Inserts one AutoCodeCond into the database. Returns the new priKey.</summary>
internal static long Insert(AutoCodeCond autoCodeCond)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
autoCodeCond.AutoCodeCondNum=DbHelper.GetNextOracleKey("autocodecond","AutoCodeCondNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(autoCodeCond,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
autoCodeCond.AutoCodeCondNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(autoCodeCond,false);
}
}
///<summary></summary>
public static void Insert(AutoCodeCond Cur){
string command= "INSERT INTO autocodecond (AutoCodeItemNum,Cond) "
+"VALUES ("
+"'"+POut.PInt(Cur.AutoCodeItemNum)+"', "
+"'"+POut.PInt((int)Cur.Cond)+"')";
//MessageBox.Show(string command);
Cur.AutoCodeCondNum=General.NonQ(command,true);
}
///<summary>Updates one AutoCodeCond in the database.</summary>
public static void Update(AutoCodeCond autoCodeCond)
{
string command = "UPDATE autocodecond SET "
+ "AutoCodeItemNum= " + POut.Long(autoCodeCond.AutoCodeItemNum) + ", "
+ "Cond = " + POut.Int((int)autoCodeCond.Cond) + " "
+ "WHERE AutoCodeCondNum = " + POut.Long(autoCodeCond.AutoCodeCondNum);
Db.NonQ(command);
}
///<summary>Returns true if Update(AutoCodeCond,AutoCodeCond) 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(AutoCodeCond autoCodeCond, AutoCodeCond oldAutoCodeCond)
{
if (autoCodeCond.AutoCodeItemNum != oldAutoCodeCond.AutoCodeItemNum)
{
return(true);
}
if (autoCodeCond.Cond != oldAutoCodeCond.Cond)
{
return(true);
}
return(false);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<AutoCodeCond> TableToList(DataTable table){
List<AutoCodeCond> retVal=new List<AutoCodeCond>();
AutoCodeCond autoCodeCond;
for(int i=0;i<table.Rows.Count;i++) {
autoCodeCond=new AutoCodeCond();
autoCodeCond.AutoCodeCondNum= PIn.Long (table.Rows[i]["AutoCodeCondNum"].ToString());
autoCodeCond.AutoCodeItemNum= PIn.Long (table.Rows[i]["AutoCodeItemNum"].ToString());
autoCodeCond.Cond = (OpenDentBusiness.AutoCondition)PIn.Int(table.Rows[i]["Cond"].ToString());
retVal.Add(autoCodeCond);
}
return retVal;
}
//public static Hashtable HList;
///<summary></summary>
public static void Refresh(){
string command="SELECT * from autocodecond ORDER BY cond";
DataTable table=General.GetTable(command);
//HList=new Hashtable();
List=new AutoCodeCond[table.Rows.Count];
for(int i=0;i<List.Length;i++){
List[i]=new AutoCodeCond();
List[i].AutoCodeCondNum= PIn.PInt (table.Rows[i][0].ToString());
List[i].AutoCodeItemNum= PIn.PInt (table.Rows[i][1].ToString());
List[i].Cond=(AutoCondition)PIn.PInt(table.Rows[i][2].ToString());
//HList.Add(List[i].AutoCodeItemNum,List[i]);
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <AutoCodeCond> TableToList(DataTable table)
{
List <AutoCodeCond> retVal = new List <AutoCodeCond>();
AutoCodeCond autoCodeCond;
foreach (DataRow row in table.Rows)
{
autoCodeCond = new AutoCodeCond();
autoCodeCond.AutoCodeCondNum = PIn.Long(row["AutoCodeCondNum"].ToString());
autoCodeCond.AutoCodeItemNum = PIn.Long(row["AutoCodeItemNum"].ToString());
autoCodeCond.Cond = (OpenDentBusiness.AutoCondition)PIn.Int(row["Cond"].ToString());
retVal.Add(autoCodeCond);
}
return(retVal);
}
///<summary>Inserts one AutoCodeCond into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(AutoCodeCond autoCodeCond)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(autoCodeCond, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
autoCodeCond.AutoCodeCondNum = DbHelper.GetNextOracleKey("autocodecond", "AutoCodeCondNum"); //Cacheless method
}
return(InsertNoCache(autoCodeCond, true));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <AutoCodeCond> TableToList(DataTable table)
{
List <AutoCodeCond> retVal = new List <AutoCodeCond>();
AutoCodeCond autoCodeCond;
for (int i = 0; i < table.Rows.Count; i++)
{
autoCodeCond = new AutoCodeCond();
autoCodeCond.AutoCodeCondNum = PIn.Long(table.Rows[i]["AutoCodeCondNum"].ToString());
autoCodeCond.AutoCodeItemNum = PIn.Long(table.Rows[i]["AutoCodeItemNum"].ToString());
autoCodeCond.Cond = (AutoCondition)PIn.Int(table.Rows[i]["Cond"].ToString());
retVal.Add(autoCodeCond);
}
return(retVal);
}
///<summary>Inserts one AutoCodeCond into the database. Provides option to use the existing priKey.</summary>
public static long Insert(AutoCodeCond autoCodeCond,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
autoCodeCond.AutoCodeCondNum=ReplicationServers.GetKey("autocodecond","AutoCodeCondNum");
}
string command="INSERT INTO autocodecond (";
if(useExistingPK || PrefC.RandomKeys) {
command+="AutoCodeCondNum,";
}
command+="AutoCodeItemNum,Cond) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(autoCodeCond.AutoCodeCondNum)+",";
}
command+=
POut.Long (autoCodeCond.AutoCodeItemNum)+","
+ POut.Int ((int)autoCodeCond.Cond)+")";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
autoCodeCond.AutoCodeCondNum=Db.NonQ(command,true);
}
return autoCodeCond.AutoCodeCondNum;
}
///<summary>Inserts one AutoCodeCond into the database. Returns the new priKey.</summary>
public static long Insert(AutoCodeCond autoCodeCond)
{
return(Insert(autoCodeCond, false));
}
///<summary>Updates one AutoCodeCond in the database.</summary>
internal static void Update(AutoCodeCond autoCodeCond)
{
string command="UPDATE autocodecond SET "
+"AutoCodeItemNum= "+POut.Long (autoCodeCond.AutoCodeItemNum)+", "
+"Cond = "+POut.Int ((int)autoCodeCond.Cond)+" "
+"WHERE AutoCodeCondNum = "+POut.Long(autoCodeCond.AutoCodeCondNum);
Db.NonQ(command);
}
///<summary>Updates one AutoCodeCond 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(AutoCodeCond autoCodeCond,AutoCodeCond oldAutoCodeCond)
{
string command="";
if(autoCodeCond.AutoCodeItemNum != oldAutoCodeCond.AutoCodeItemNum) {
if(command!=""){ command+=",";}
command+="AutoCodeItemNum = "+POut.Long(autoCodeCond.AutoCodeItemNum)+"";
}
if(autoCodeCond.Cond != oldAutoCodeCond.Cond) {
if(command!=""){ command+=",";}
command+="Cond = "+POut.Int ((int)autoCodeCond.Cond)+"";
}
if(command==""){
return;
}
command="UPDATE autocodecond SET "+command
+" WHERE AutoCodeCondNum = "+POut.Long(autoCodeCond.AutoCodeCondNum);
Db.NonQ(command);
}
