///<summary>Inserts one CDSPermission into the database. Returns the new priKey.</summary>
public static long Insert(CDSPermission cDSPermission)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
cDSPermission.CDSPermissionNum = DbHelper.GetNextOracleKey("cdspermission", "CDSPermissionNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(cDSPermission, true));
}
catch (Oracle.DataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
cDSPermission.CDSPermissionNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(cDSPermission, false));
}
}
///<summary>Inserts one CDSPermission into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(CDSPermission cDSPermission)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(cDSPermission, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
cDSPermission.CDSPermissionNum = DbHelper.GetNextOracleKey("cdspermission", "CDSPermissionNum"); //Cacheless method
}
return(InsertNoCache(cDSPermission, true));
}
}
///<summary>Returns true if Update(CDSPermission,CDSPermission) 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(CDSPermission cDSPermission, CDSPermission oldCDSPermission)
{
if (cDSPermission.UserNum != oldCDSPermission.UserNum)
{
return(true);
}
if (cDSPermission.SetupCDS != oldCDSPermission.SetupCDS)
{
return(true);
}
if (cDSPermission.ShowCDS != oldCDSPermission.ShowCDS)
{
return(true);
}
if (cDSPermission.ShowInfobutton != oldCDSPermission.ShowInfobutton)
{
return(true);
}
if (cDSPermission.EditBibliography != oldCDSPermission.EditBibliography)
{
return(true);
}
if (cDSPermission.ProblemCDS != oldCDSPermission.ProblemCDS)
{
return(true);
}
if (cDSPermission.MedicationCDS != oldCDSPermission.MedicationCDS)
{
return(true);
}
if (cDSPermission.AllergyCDS != oldCDSPermission.AllergyCDS)
{
return(true);
}
if (cDSPermission.DemographicCDS != oldCDSPermission.DemographicCDS)
{
return(true);
}
if (cDSPermission.LabTestCDS != oldCDSPermission.LabTestCDS)
{
return(true);
}
if (cDSPermission.VitalCDS != oldCDSPermission.VitalCDS)
{
return(true);
}
return(false);
}
///<summary>Updates one CDSPermission in the database.</summary>
public static void Update(CDSPermission cDSPermission)
{
string command = "UPDATE cdspermission SET "
+ "UserNum = " + POut.Long(cDSPermission.UserNum) + ", "
+ "SetupCDS = " + POut.Bool(cDSPermission.SetupCDS) + ", "
+ "ShowCDS = " + POut.Bool(cDSPermission.ShowCDS) + ", "
+ "ShowInfobutton = " + POut.Bool(cDSPermission.ShowInfobutton) + ", "
+ "EditBibliography= " + POut.Bool(cDSPermission.EditBibliography) + ", "
+ "ProblemCDS = " + POut.Bool(cDSPermission.ProblemCDS) + ", "
+ "MedicationCDS = " + POut.Bool(cDSPermission.MedicationCDS) + ", "
+ "AllergyCDS = " + POut.Bool(cDSPermission.AllergyCDS) + ", "
+ "DemographicCDS = " + POut.Bool(cDSPermission.DemographicCDS) + ", "
+ "LabTestCDS = " + POut.Bool(cDSPermission.LabTestCDS) + ", "
+ "VitalCDS = " + POut.Bool(cDSPermission.VitalCDS) + " "
+ "WHERE CDSPermissionNum = " + POut.Long(cDSPermission.CDSPermissionNum);
Db.NonQ(command);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<CDSPermission> TableToList(DataTable table){
List<CDSPermission> retVal=new List<CDSPermission>();
CDSPermission cDSPermission;
for(int i=0;i<table.Rows.Count;i++) {
cDSPermission=new CDSPermission();
cDSPermission.CDSPermissionNum= PIn.Long (table.Rows[i]["CDSPermissionNum"].ToString());
cDSPermission.UserNum = PIn.Long (table.Rows[i]["UserNum"].ToString());
cDSPermission.SetupCDS = PIn.Bool (table.Rows[i]["SetupCDS"].ToString());
cDSPermission.ShowCDS = PIn.Bool (table.Rows[i]["ShowCDS"].ToString());
cDSPermission.ShowInfobutton = PIn.Bool (table.Rows[i]["ShowInfobutton"].ToString());
cDSPermission.EditBibliography= PIn.Bool (table.Rows[i]["EditBibliography"].ToString());
cDSPermission.ProblemCDS = PIn.Bool (table.Rows[i]["ProblemCDS"].ToString());
cDSPermission.MedicationCDS = PIn.Bool (table.Rows[i]["MedicationCDS"].ToString());
cDSPermission.AllergyCDS = PIn.Bool (table.Rows[i]["AllergyCDS"].ToString());
cDSPermission.DemographicCDS = PIn.Bool (table.Rows[i]["DemographicCDS"].ToString());
cDSPermission.LabTestCDS = PIn.Bool (table.Rows[i]["LabTestCDS"].ToString());
cDSPermission.VitalCDS = PIn.Bool (table.Rows[i]["VitalCDS"].ToString());
retVal.Add(cDSPermission);
}
return retVal;
}
///<summary>Inserts one CDSPermission into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(CDSPermission cDSPermission, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO cdspermission (";
if (!useExistingPK && isRandomKeys)
{
cDSPermission.CDSPermissionNum = ReplicationServers.GetKeyNoCache("cdspermission", "CDSPermissionNum");
}
if (isRandomKeys || useExistingPK)
{
command += "CDSPermissionNum,";
}
command += "UserNum,SetupCDS,ShowCDS,ShowInfobutton,EditBibliography,ProblemCDS,MedicationCDS,AllergyCDS,DemographicCDS,LabTestCDS,VitalCDS) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(cDSPermission.CDSPermissionNum) + ",";
}
command +=
POut.Long(cDSPermission.UserNum) + ","
+ POut.Bool(cDSPermission.SetupCDS) + ","
+ POut.Bool(cDSPermission.ShowCDS) + ","
+ POut.Bool(cDSPermission.ShowInfobutton) + ","
+ POut.Bool(cDSPermission.EditBibliography) + ","
+ POut.Bool(cDSPermission.ProblemCDS) + ","
+ POut.Bool(cDSPermission.MedicationCDS) + ","
+ POut.Bool(cDSPermission.AllergyCDS) + ","
+ POut.Bool(cDSPermission.DemographicCDS) + ","
+ POut.Bool(cDSPermission.LabTestCDS) + ","
+ POut.Bool(cDSPermission.VitalCDS) + ")";
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command);
}
else
{
cDSPermission.CDSPermissionNum = Db.NonQ(command, true, "CDSPermissionNum", "cDSPermission");
}
return(cDSPermission.CDSPermissionNum);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <CDSPermission> TableToList(DataTable table)
{
List <CDSPermission> retVal = new List <CDSPermission>();
CDSPermission cDSPermission;
foreach (DataRow row in table.Rows)
{
cDSPermission = new CDSPermission();
cDSPermission.CDSPermissionNum = PIn.Long(row["CDSPermissionNum"].ToString());
cDSPermission.UserNum = PIn.Long(row["UserNum"].ToString());
cDSPermission.SetupCDS = PIn.Bool(row["SetupCDS"].ToString());
cDSPermission.ShowCDS = PIn.Bool(row["ShowCDS"].ToString());
cDSPermission.ShowInfobutton = PIn.Bool(row["ShowInfobutton"].ToString());
cDSPermission.EditBibliography = PIn.Bool(row["EditBibliography"].ToString());
cDSPermission.ProblemCDS = PIn.Bool(row["ProblemCDS"].ToString());
cDSPermission.MedicationCDS = PIn.Bool(row["MedicationCDS"].ToString());
cDSPermission.AllergyCDS = PIn.Bool(row["AllergyCDS"].ToString());
cDSPermission.DemographicCDS = PIn.Bool(row["DemographicCDS"].ToString());
cDSPermission.LabTestCDS = PIn.Bool(row["LabTestCDS"].ToString());
cDSPermission.VitalCDS = PIn.Bool(row["VitalCDS"].ToString());
retVal.Add(cDSPermission);
}
return(retVal);
}
///<summary>Inserts one CDSPermission into the database. Returns the new priKey.</summary>
public static long Insert(CDSPermission cDSPermission){
if(DataConnection.DBtype==DatabaseType.Oracle) {
cDSPermission.CDSPermissionNum=DbHelper.GetNextOracleKey("cdspermission","CDSPermissionNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(cDSPermission,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
cDSPermission.CDSPermissionNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(cDSPermission,false);
}
}
///<summary>Updates one CDSPermission 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(CDSPermission cDSPermission, CDSPermission oldCDSPermission)
{
string command = "";
if (cDSPermission.UserNum != oldCDSPermission.UserNum)
{
if (command != "")
{
command += ",";
}
command += "UserNum = " + POut.Long(cDSPermission.UserNum) + "";
}
if (cDSPermission.SetupCDS != oldCDSPermission.SetupCDS)
{
if (command != "")
{
command += ",";
}
command += "SetupCDS = " + POut.Bool(cDSPermission.SetupCDS) + "";
}
if (cDSPermission.ShowCDS != oldCDSPermission.ShowCDS)
{
if (command != "")
{
command += ",";
}
command += "ShowCDS = " + POut.Bool(cDSPermission.ShowCDS) + "";
}
if (cDSPermission.ShowInfobutton != oldCDSPermission.ShowInfobutton)
{
if (command != "")
{
command += ",";
}
command += "ShowInfobutton = " + POut.Bool(cDSPermission.ShowInfobutton) + "";
}
if (cDSPermission.EditBibliography != oldCDSPermission.EditBibliography)
{
if (command != "")
{
command += ",";
}
command += "EditBibliography = " + POut.Bool(cDSPermission.EditBibliography) + "";
}
if (cDSPermission.ProblemCDS != oldCDSPermission.ProblemCDS)
{
if (command != "")
{
command += ",";
}
command += "ProblemCDS = " + POut.Bool(cDSPermission.ProblemCDS) + "";
}
if (cDSPermission.MedicationCDS != oldCDSPermission.MedicationCDS)
{
if (command != "")
{
command += ",";
}
command += "MedicationCDS = " + POut.Bool(cDSPermission.MedicationCDS) + "";
}
if (cDSPermission.AllergyCDS != oldCDSPermission.AllergyCDS)
{
if (command != "")
{
command += ",";
}
command += "AllergyCDS = " + POut.Bool(cDSPermission.AllergyCDS) + "";
}
if (cDSPermission.DemographicCDS != oldCDSPermission.DemographicCDS)
{
if (command != "")
{
command += ",";
}
command += "DemographicCDS = " + POut.Bool(cDSPermission.DemographicCDS) + "";
}
if (cDSPermission.LabTestCDS != oldCDSPermission.LabTestCDS)
{
if (command != "")
{
command += ",";
}
command += "LabTestCDS = " + POut.Bool(cDSPermission.LabTestCDS) + "";
}
if (cDSPermission.VitalCDS != oldCDSPermission.VitalCDS)
{
if (command != "")
{
command += ",";
}
command += "VitalCDS = " + POut.Bool(cDSPermission.VitalCDS) + "";
}
if (command == "")
{
return(false);
}
command = "UPDATE cdspermission SET " + command
+ " WHERE CDSPermissionNum = " + POut.Long(cDSPermission.CDSPermissionNum);
Db.NonQ(command);
return(true);
}
///<summary>Inserts one CDSPermission into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(CDSPermission cDSPermission)
{
return(InsertNoCache(cDSPermission, false));
}
///<summary>Inserts one CDSPermission into the database. Provides option to use the existing priKey.</summary>
public static long Insert(CDSPermission cDSPermission,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
cDSPermission.CDSPermissionNum=ReplicationServers.GetKey("cdspermission","CDSPermissionNum");
}
string command="INSERT INTO cdspermission (";
if(useExistingPK || PrefC.RandomKeys) {
command+="CDSPermissionNum,";
}
command+="UserNum,SetupCDS,ShowCDS,ShowInfobutton,EditBibliography,ProblemCDS,MedicationCDS,AllergyCDS,DemographicCDS,LabTestCDS,VitalCDS) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(cDSPermission.CDSPermissionNum)+",";
}
command+=
POut.Long (cDSPermission.UserNum)+","
+ POut.Bool (cDSPermission.SetupCDS)+","
+ POut.Bool (cDSPermission.ShowCDS)+","
+ POut.Bool (cDSPermission.ShowInfobutton)+","
+ POut.Bool (cDSPermission.EditBibliography)+","
+ POut.Bool (cDSPermission.ProblemCDS)+","
+ POut.Bool (cDSPermission.MedicationCDS)+","
+ POut.Bool (cDSPermission.AllergyCDS)+","
+ POut.Bool (cDSPermission.DemographicCDS)+","
+ POut.Bool (cDSPermission.LabTestCDS)+","
+ POut.Bool (cDSPermission.VitalCDS)+")";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
cDSPermission.CDSPermissionNum=Db.NonQ(command,true);
}
return cDSPermission.CDSPermissionNum;
}
///<summary>Updates one CDSPermission 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(CDSPermission cDSPermission,CDSPermission oldCDSPermission){
string command="";
if(cDSPermission.UserNum != oldCDSPermission.UserNum) {
if(command!=""){ command+=",";}
command+="UserNum = "+POut.Long(cDSPermission.UserNum)+"";
}
if(cDSPermission.SetupCDS != oldCDSPermission.SetupCDS) {
if(command!=""){ command+=",";}
command+="SetupCDS = "+POut.Bool(cDSPermission.SetupCDS)+"";
}
if(cDSPermission.ShowCDS != oldCDSPermission.ShowCDS) {
if(command!=""){ command+=",";}
command+="ShowCDS = "+POut.Bool(cDSPermission.ShowCDS)+"";
}
if(cDSPermission.ShowInfobutton != oldCDSPermission.ShowInfobutton) {
if(command!=""){ command+=",";}
command+="ShowInfobutton = "+POut.Bool(cDSPermission.ShowInfobutton)+"";
}
if(cDSPermission.EditBibliography != oldCDSPermission.EditBibliography) {
if(command!=""){ command+=",";}
command+="EditBibliography = "+POut.Bool(cDSPermission.EditBibliography)+"";
}
if(cDSPermission.ProblemCDS != oldCDSPermission.ProblemCDS) {
if(command!=""){ command+=",";}
command+="ProblemCDS = "+POut.Bool(cDSPermission.ProblemCDS)+"";
}
if(cDSPermission.MedicationCDS != oldCDSPermission.MedicationCDS) {
if(command!=""){ command+=",";}
command+="MedicationCDS = "+POut.Bool(cDSPermission.MedicationCDS)+"";
}
if(cDSPermission.AllergyCDS != oldCDSPermission.AllergyCDS) {
if(command!=""){ command+=",";}
command+="AllergyCDS = "+POut.Bool(cDSPermission.AllergyCDS)+"";
}
if(cDSPermission.DemographicCDS != oldCDSPermission.DemographicCDS) {
if(command!=""){ command+=",";}
command+="DemographicCDS = "+POut.Bool(cDSPermission.DemographicCDS)+"";
}
if(cDSPermission.LabTestCDS != oldCDSPermission.LabTestCDS) {
if(command!=""){ command+=",";}
command+="LabTestCDS = "+POut.Bool(cDSPermission.LabTestCDS)+"";
}
if(cDSPermission.VitalCDS != oldCDSPermission.VitalCDS) {
if(command!=""){ command+=",";}
command+="VitalCDS = "+POut.Bool(cDSPermission.VitalCDS)+"";
}
if(command==""){
return;
}
command="UPDATE cdspermission SET "+command
+" WHERE CDSPermissionNum = "+POut.Long(cDSPermission.CDSPermissionNum);
Db.NonQ(command);
}
///<summary>Updates one CDSPermission in the database.</summary>
public static void Update(CDSPermission cDSPermission){
string command="UPDATE cdspermission SET "
+"UserNum = "+POut.Long (cDSPermission.UserNum)+", "
+"SetupCDS = "+POut.Bool (cDSPermission.SetupCDS)+", "
+"ShowCDS = "+POut.Bool (cDSPermission.ShowCDS)+", "
+"ShowInfobutton = "+POut.Bool (cDSPermission.ShowInfobutton)+", "
+"EditBibliography= "+POut.Bool (cDSPermission.EditBibliography)+", "
+"ProblemCDS = "+POut.Bool (cDSPermission.ProblemCDS)+", "
+"MedicationCDS = "+POut.Bool (cDSPermission.MedicationCDS)+", "
+"AllergyCDS = "+POut.Bool (cDSPermission.AllergyCDS)+", "
+"DemographicCDS = "+POut.Bool (cDSPermission.DemographicCDS)+", "
+"LabTestCDS = "+POut.Bool (cDSPermission.LabTestCDS)+", "
+"VitalCDS = "+POut.Bool (cDSPermission.VitalCDS)+" "
+"WHERE CDSPermissionNum = "+POut.Long(cDSPermission.CDSPermissionNum);
Db.NonQ(command);
}
