/// <summary>Returns a Prefm object when provided with the PrefName. Note that the CustomerNum field of the return object is not populated. </summary> public static Prefm GetPrefm(String PrefName) { Pref pref = Prefs.GetPref(PrefName); Prefm prefm = ConvertToM(pref); return(prefm); }
/// <summary>converts a Pref to a Prefm object</summary> public static Prefm ConvertToM(Pref pref){ Prefm prefm=new Prefm(); prefm.PrefNum=pref.PrefNum; prefm.PrefmName=pref.PrefName; prefm.ValueString=pref.ValueString; return prefm; }
/// <summary>converts a Pref to a Prefm object</summary> public static Prefm ConvertToM(Pref pref) { Prefm prefm = new Prefm(); prefm.PrefNum = pref.PrefNum; prefm.PrefmName = pref.PrefName; prefm.ValueString = pref.ValueString; return(prefm); }
public static void UpdatePreference(Prefm prefm) { string command="SELECT * FROM preferencem " +"WHERE CustomerNum =" +POut.Long(prefm.CustomerNum)+" AND PrefNum = "+POut.Long(prefm.PrefNum); DataTable table=Db.GetTable(command); if(table.Rows.Count>0) { command = "UPDATE preferencem SET " +"ValueString = '"+POut.String(prefm.ValueString)+"' " +"WHERE CustomerNum =" +POut.Long(prefm.CustomerNum)+" AND PrefNum = "+POut.Long(prefm.PrefNum); Db.NonQ(command); } else { command = "INSERT into preferencem " +"(CustomerNum,PrefNum,PrefName,ValueString) VALUES " +"("+POut.Long(prefm.CustomerNum)+","+POut.Long(prefm.PrefNum)+",'"+POut.String(prefm.PrefmName.ToString())+"','"+POut.String(prefm.ValueString)+"')"; Db.NonQ(command); } }
public static PrefmC LoadPreferences(long customerNum) { string command="SELECT * FROM preferencem WHERE CustomerNum = "+POut.Long(customerNum); DataTable table=Db.GetTable(command); Prefm prefm=new Prefm(); PrefmC prefmc=new PrefmC(); for(int i=0;i<table.Rows.Count;i++) { prefm=new Prefm(); if(table.Columns.Contains("PrefNum")) { prefm.PrefNum=PIn.Long(table.Rows[i]["PrefNum"].ToString()); } prefm.PrefmName=PIn.String(table.Rows[i]["PrefName"].ToString()); prefm.ValueString=PIn.String(table.Rows[i]["ValueString"].ToString()); prefmc.Dict.Add(prefm.PrefmName,prefm); } HttpContext.Current.Session["prefmC"]=prefmc; return prefmc; }
public static void UpdatePreference(Prefm prefm) { string command = "SELECT * FROM preferencem " + "WHERE CustomerNum =" + POut.Long(prefm.CustomerNum) + " AND PrefNum = " + POut.Long(prefm.PrefNum); DataTable table = Db.GetTable(command); if (table.Rows.Count > 0) { command = "UPDATE preferencem SET " + "ValueString = '" + prefm.ValueString + "' " + "WHERE CustomerNum =" + POut.Long(prefm.CustomerNum) + " AND PrefNum = " + POut.Long(prefm.PrefNum); Db.NonQ(command); } else { command = "INSERT into preferencem " + "(CustomerNum,PrefNum,PrefName,ValueString) VALUES " + "(" + POut.Long(prefm.CustomerNum) + "," + POut.Long(prefm.PrefNum) + ",'" + POut.String(prefm.PrefmName.ToString()) + "','" + POut.String(prefm.ValueString) + "')"; Db.NonQ(command); } }
public static PrefmC LoadPreferences(long customerNum) { string command = "SELECT * FROM preferencem WHERE CustomerNum = " + POut.Long(customerNum); DataTable table = Db.GetTable(command); Prefm prefm = new Prefm(); PrefmC prefmc = new PrefmC(); for (int i = 0; i < table.Rows.Count; i++) { prefm = new Prefm(); if (table.Columns.Contains("PrefNum")) { prefm.PrefNum = PIn.Long(table.Rows[i]["PrefNum"].ToString()); } prefm.PrefmName = PIn.String(table.Rows[i]["PrefName"].ToString()); prefm.ValueString = PIn.String(table.Rows[i]["ValueString"].ToString()); prefmc.Dict.Add(prefm.PrefmName, prefm); } HttpContext.Current.Session["prefmC"] = prefmc; return(prefmc); }
public void SetPreference(String RegistrationKey,Prefm prefm) { try { Logger.Information("In SetPreference"); customerNum=util.GetDentalOfficeID(RegistrationKey); if(customerNum==0) { return; } else { prefm.CustomerNum=customerNum; Prefms.UpdatePreference(prefm); } } catch(Exception ex) { Logger.LogError("IpAddress="+HttpContext.Current.Request.UserHostAddress+" DentalOfficeID="+customerNum,ex); throw new Exception("Exception in SetPreference"); } }
/// <remarks/> public void SetPreferenceAsync(string RegistrationKey, Prefm prefm, object userState) { if ((this.SetPreferenceOperationCompleted == null)) { this.SetPreferenceOperationCompleted = new System.Threading.SendOrPostCallback(this.OnSetPreferenceOperationCompleted); } this.InvokeAsync("SetPreference", new object[] { RegistrationKey, prefm}, this.SetPreferenceOperationCompleted, userState); }
/// <remarks/> public void SetPreferenceAsync(string RegistrationKey, Prefm prefm) { this.SetPreferenceAsync(RegistrationKey, prefm, null); }
public void SetPreference(string RegistrationKey, Prefm prefm) { this.Invoke("SetPreference", new object[] { RegistrationKey, prefm}); }