///<summary>Updates one AllergyDefm in the database.</summary> internal static void Update(AllergyDefm allergyDefm){ string command="UPDATE allergydefm SET " +"Description = '"+POut.String(allergyDefm.Description)+"', " +"Snomed = "+POut.Int ((int)allergyDefm.Snomed)+", " +"MedicationNum= "+POut.Long (allergyDefm.MedicationNum)+" " +"WHERE CustomerNum = "+POut.Long(allergyDefm.CustomerNum)+" AND AllergyDefNum = "+POut.Long(allergyDefm.AllergyDefNum); Db.NonQ(command); }
///<summary>Converts one AllergyDef object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static AllergyDefm ConvertToM(AllergyDef allergyDef) { AllergyDefm allergyDefm=new AllergyDefm(); //CustomerNum cannot be set. Remains 0. allergyDefm.AllergyDefNum=allergyDef.AllergyDefNum; allergyDefm.Description =allergyDef.Description; allergyDefm.Snomed =allergyDef.Snomed; allergyDefm.MedicationNum=allergyDef.MedicationNum; return allergyDefm; }
///<summary>Updates one AllergyDefm in the database.</summary> internal static void Update(AllergyDefm allergyDefm) { string command = "UPDATE allergydefm SET " + "Description = '" + POut.String(allergyDefm.Description) + "', " + "Snomed = " + POut.Int((int)allergyDefm.Snomed) + ", " + "MedicationNum= " + POut.Long(allergyDefm.MedicationNum) + " " + "WHERE CustomerNum = " + POut.Long(allergyDefm.CustomerNum) + " AND AllergyDefNum = " + POut.Long(allergyDefm.AllergyDefNum); Db.NonQ(command); }
///<summary>Converts one AllergyDef object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static AllergyDefm ConvertToM(AllergyDef allergyDef) { AllergyDefm allergyDefm = new AllergyDefm(); //CustomerNum cannot be set. Remains 0. allergyDefm.AllergyDefNum = allergyDef.AllergyDefNum; allergyDefm.Description = allergyDef.Description; allergyDefm.Snomed = allergyDef.Snomed; allergyDefm.MedicationNum = allergyDef.MedicationNum; return(allergyDefm); }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List<AllergyDefm> TableToList(DataTable table){ List<AllergyDefm> retVal=new List<AllergyDefm>(); AllergyDefm allergyDefm; for(int i=0;i<table.Rows.Count;i++) { allergyDefm=new AllergyDefm(); allergyDefm.CustomerNum = PIn.Long (table.Rows[i]["CustomerNum"].ToString()); allergyDefm.AllergyDefNum= PIn.Long (table.Rows[i]["AllergyDefNum"].ToString()); allergyDefm.Description = PIn.String(table.Rows[i]["Description"].ToString()); allergyDefm.Snomed = (SnomedAllergy)PIn.Int(table.Rows[i]["SnomedType"].ToString()); allergyDefm.MedicationNum= PIn.Long (table.Rows[i]["MedicationNum"].ToString()); retVal.Add(allergyDefm); } return retVal; }
///<summary>Usually set useExistingPK=true. Inserts one AllergyDefm into the database.</summary> internal static long Insert(AllergyDefm allergyDefm,bool useExistingPK){ if(!useExistingPK) { allergyDefm.AllergyDefNum=ReplicationServers.GetKey("allergydefm","AllergyDefNum"); } string command="INSERT INTO allergydefm ("; command+="AllergyDefNum,"; command+="CustomerNum,Description,Snomed,MedicationNum) VALUES("; command+=POut.Long(allergyDefm.AllergyDefNum)+","; command+= POut.Long (allergyDefm.CustomerNum)+"," +"'"+POut.String(allergyDefm.Description)+"'," + POut.Int ((int)allergyDefm.Snomed)+"," + POut.Long (allergyDefm.MedicationNum)+")"; Db.NonQ(command);//There is no autoincrement in the mobile server. return allergyDefm.AllergyDefNum; }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List <AllergyDefm> TableToList(DataTable table) { List <AllergyDefm> retVal = new List <AllergyDefm>(); AllergyDefm allergyDefm; for (int i = 0; i < table.Rows.Count; i++) { allergyDefm = new AllergyDefm(); allergyDefm.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString()); allergyDefm.AllergyDefNum = PIn.Long(table.Rows[i]["AllergyDefNum"].ToString()); allergyDefm.Description = PIn.String(table.Rows[i]["Description"].ToString()); allergyDefm.Snomed = (SnomedAllergy)PIn.Int(table.Rows[i]["Snomed"].ToString()); allergyDefm.MedicationNum = PIn.Long(table.Rows[i]["MedicationNum"].ToString()); retVal.Add(allergyDefm); } return(retVal); }
///<summary>Usually set useExistingPK=true. Inserts one AllergyDefm into the database.</summary> internal static long Insert(AllergyDefm allergyDefm, bool useExistingPK) { if (!useExistingPK) { allergyDefm.AllergyDefNum = ReplicationServers.GetKey("allergydefm", "AllergyDefNum"); } string command = "INSERT INTO allergydefm ("; command += "AllergyDefNum,"; command += "CustomerNum,Description,Snomed,MedicationNum) VALUES("; command += POut.Long(allergyDefm.AllergyDefNum) + ","; command += POut.Long(allergyDefm.CustomerNum) + "," + "'" + POut.String(allergyDefm.Description) + "'," + POut.Int((int)allergyDefm.Snomed) + "," + POut.Long(allergyDefm.MedicationNum) + ")"; Db.NonQ(command); //There is no autoincrement in the mobile server. return(allergyDefm.AllergyDefNum); }