///<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);
}
