public Dictionary<string,Prefm> Dict=new Dictionary<string,Prefm>();// cannot have a static variable here because we want something unique for each patient. ///<summary>Gets a pref of type string.</summary> public static string GetString(PrefmName prefmName) { try { PrefmC prefmC=Prefms.LoadPreferences(); if(!prefmC.Dict.ContainsKey(prefmName.ToString())) { throw new Exception(prefmName+" is an invalid pref name."); } return prefmC.Dict[prefmName.ToString()].ValueString; } catch(Exception ex) { return ""; } }
public Dictionary <string, Prefm> Dict = new Dictionary <string, Prefm>(); // cannot have a static variable here because we want something unique for each patient. ///<summary>Gets a pref of type string.</summary> public static string GetString(PrefmName prefmName) { try { PrefmC prefmC = Prefms.LoadPreferences(); if (!prefmC.Dict.ContainsKey(prefmName.ToString())) { throw new Exception(prefmName + " is an invalid pref name."); } return(prefmC.Dict[prefmName.ToString()].ValueString); } catch (Exception ex) { return(""); } }
///<summary>Returns true if a change was required, or false if no change needed. This method is no longer used and may be deleted later. Dennis Mathew: Dec 24, 2011</summary> public void UpdateString(long customerNum,PrefmName prefmName,string newValue) { string command="SELECT * FROM preferencem " +"WHERE CustomerNum =" +POut.Long(customerNum)+" AND PrefName = '"+POut.String(prefmName.ToString())+"'"; DataTable table=Db.GetTable(command); if(table.Rows.Count>0) { command = "UPDATE preferencem SET " +"ValueString = '"+POut.String(newValue)+"' " +"WHERE CustomerNum =" +POut.Long(customerNum)+" AND PrefName = '"+POut.String(prefmName.ToString())+"'"; Db.NonQ(command); } else { command = "INSERT into preferencem " +"(CustomerNum,PrefName,ValueString) VALUES " +"("+POut.Long(customerNum)+",'"+POut.String(prefmName.ToString())+"','"+POut.String(newValue)+"')"; Db.NonQ(command); } }
///<summary>Returns true if a change was required, or false if no change needed. This method is no longer used and may be deleted later. Dennis Mathew: Dec 24, 2011</summary> public void UpdateString(long customerNum, PrefmName prefmName, string newValue) { string command = "SELECT * FROM preferencem " + "WHERE CustomerNum =" + POut.Long(customerNum) + " AND PrefName = '" + POut.String(prefmName.ToString()) + "'"; DataTable table = Db.GetTable(command); if (table.Rows.Count > 0) { command = "UPDATE preferencem SET " + "ValueString = '" + POut.String(newValue) + "' " + "WHERE CustomerNum =" + POut.Long(customerNum) + " AND PrefName = '" + POut.String(prefmName.ToString()) + "'"; Db.NonQ(command); } else { command = "INSERT into preferencem " + "(CustomerNum,PrefName,ValueString) VALUES " + "(" + POut.Long(customerNum) + ",'" + POut.String(prefmName.ToString()) + "','" + POut.String(newValue) + "')"; Db.NonQ(command); } }