///<summary>Inserts one FormularyMed into the database. Returns the new priKey.</summary>
internal static long Insert(FormularyMed formularyMed)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
formularyMed.FormularyMedNum = DbHelper.GetNextOracleKey("formularymed", "FormularyMedNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(formularyMed, true));
}
catch (Oracle.DataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
formularyMed.FormularyMedNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(formularyMed, false));
}
}
///<summary>Updates one FormularyMed 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(FormularyMed formularyMed, FormularyMed oldFormularyMed)
{
string command = "";
if (formularyMed.FormularyNum != oldFormularyMed.FormularyNum)
{
if (command != "")
{
command += ",";
}
command += "FormularyNum = " + POut.Long(formularyMed.FormularyNum) + "";
}
if (formularyMed.MedicationNum != oldFormularyMed.MedicationNum)
{
if (command != "")
{
command += ",";
}
command += "MedicationNum = " + POut.Long(formularyMed.MedicationNum) + "";
}
if (command == "")
{
return;
}
command = "UPDATE formularymed SET " + command
+ " WHERE FormularyMedNum = " + POut.Long(formularyMed.FormularyMedNum);
Db.NonQ(command);
}
///<summary>Inserts one FormularyMed into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(FormularyMed formularyMed, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
formularyMed.FormularyMedNum = ReplicationServers.GetKey("formularymed", "FormularyMedNum");
}
string command = "INSERT INTO formularymed (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "FormularyMedNum,";
}
command += "FormularyNum,MedicationNum) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(formularyMed.FormularyMedNum) + ",";
}
command +=
POut.Long(formularyMed.FormularyNum) + ","
+ POut.Long(formularyMed.MedicationNum) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
formularyMed.FormularyMedNum = Db.NonQ(command, true);
}
return(formularyMed.FormularyMedNum);
}
///<summary>Inserts one FormularyMed into the database. Returns the new priKey.</summary>
internal static long Insert(FormularyMed formularyMed)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
formularyMed.FormularyMedNum=DbHelper.GetNextOracleKey("formularymed","FormularyMedNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(formularyMed,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
formularyMed.FormularyMedNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(formularyMed,false);
}
}
///<summary>Updates one FormularyMed in the database.</summary>
internal static void Update(FormularyMed formularyMed)
{
string command = "UPDATE formularymed SET "
+ "FormularyNum = " + POut.Long(formularyMed.FormularyNum) + ", "
+ "MedicationNum = " + POut.Long(formularyMed.MedicationNum) + " "
+ "WHERE FormularyMedNum = " + POut.Long(formularyMed.FormularyMedNum);
Db.NonQ(command);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <FormularyMed> TableToList(DataTable table)
{
List <FormularyMed> retVal = new List <FormularyMed>();
FormularyMed formularyMed;
for (int i = 0; i < table.Rows.Count; i++)
{
formularyMed = new FormularyMed();
formularyMed.FormularyMedNum = PIn.Long(table.Rows[i]["FormularyMedNum"].ToString());
formularyMed.FormularyNum = PIn.Long(table.Rows[i]["FormularyNum"].ToString());
formularyMed.MedicationNum = PIn.Long(table.Rows[i]["MedicationNum"].ToString());
retVal.Add(formularyMed);
}
return(retVal);
}
///<summary>Inserts one FormularyMed into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(FormularyMed formularyMed,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
formularyMed.FormularyMedNum=ReplicationServers.GetKey("formularymed","FormularyMedNum");
}
string command="INSERT INTO formularymed (";
if(useExistingPK || PrefC.RandomKeys) {
command+="FormularyMedNum,";
}
command+="FormularyNum,MedicationNum) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(formularyMed.FormularyMedNum)+",";
}
command+=
POut.Long (formularyMed.FormularyNum)+","
+ POut.Long (formularyMed.MedicationNum)+")";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
formularyMed.FormularyMedNum=Db.NonQ(command,true);
}
return formularyMed.FormularyMedNum;
}
///<summary>Updates one FormularyMed 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(FormularyMed formularyMed,FormularyMed oldFormularyMed)
{
string command="";
if(formularyMed.FormularyNum != oldFormularyMed.FormularyNum) {
if(command!=""){ command+=",";}
command+="FormularyNum = "+POut.Long(formularyMed.FormularyNum)+"";
}
if(formularyMed.MedicationNum != oldFormularyMed.MedicationNum) {
if(command!=""){ command+=",";}
command+="MedicationNum = "+POut.Long(formularyMed.MedicationNum)+"";
}
if(command==""){
return;
}
command="UPDATE formularymed SET "+command
+" WHERE FormularyMedNum = "+POut.Long(formularyMed.FormularyMedNum);
Db.NonQ(command);
}
///<summary>Updates one FormularyMed in the database.</summary>
internal static void Update(FormularyMed formularyMed)
{
string command="UPDATE formularymed SET "
+"FormularyNum = "+POut.Long (formularyMed.FormularyNum)+", "
+"MedicationNum = "+POut.Long (formularyMed.MedicationNum)+" "
+"WHERE FormularyMedNum = "+POut.Long(formularyMed.FormularyMedNum);
Db.NonQ(command);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List<FormularyMed> TableToList(DataTable table)
{
List<FormularyMed> retVal=new List<FormularyMed>();
FormularyMed formularyMed;
for(int i=0;i<table.Rows.Count;i++) {
formularyMed=new FormularyMed();
formularyMed.FormularyMedNum= PIn.Long (table.Rows[i]["FormularyMedNum"].ToString());
formularyMed.FormularyNum = PIn.Long (table.Rows[i]["FormularyNum"].ToString());
formularyMed.MedicationNum = PIn.Long (table.Rows[i]["MedicationNum"].ToString());
retVal.Add(formularyMed);
}
return retVal;
}
