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