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