private void LoadPreferences(Control CurrentControl) { DBPreferences dbp = new DBPreferences(UserID); string t = CurrentControl.GetType().Name.ToString(); switch (t) { case "RefreshTimeSelectControl": RefreshTimeSelectControl rtsc = (RefreshTimeSelectControl)CurrentControl; if (dbp.RefreshTime == 10 * 60000) { rtsc.radioButton1.Checked = true; } if (dbp.RefreshTime == 30 * 60000) { rtsc.radioButton2.Checked = true; } if (dbp.RefreshTime == 60 * 60000) { rtsc.radioButton3.Checked = true; } if (dbp.RefreshTime == 120 * 60000) { rtsc.radioButton4.Checked = true; } if (dbp.RefreshTime == 180 * 60000) { rtsc.radioButton5.Checked = true; } if (dbp.RefreshTime == 240 * 60000) { rtsc.radioButton6.Checked = true; } break; case "ColorSelectControl": ColorSelectControl csc = (ColorSelectControl)CurrentControl; if (dbp.NoteColor == csc.panel1.BackColor.ToArgb()) { csc.radioButton1.Checked = true; } if (dbp.NoteColor == csc.panel2.BackColor.ToArgb()) { csc.radioButton2.Checked = true; } if (dbp.NoteColor == csc.panel3.BackColor.ToArgb()) { csc.radioButton3.Checked = true; } if (dbp.NoteColor == csc.panel4.BackColor.ToArgb()) { csc.radioButton4.Checked = true; } if (dbp.NoteColor == csc.panel5.BackColor.ToArgb()) { csc.radioButton5.Checked = true; } break; } }
public DBPreferences(int UID) { DA.SelectCommand.CommandText = "select * from " + Base.BaseName + "..PREFERENCES where IDUSER = "******"t") == 0) { int color = new ColorSelectControl().panel1.BackColor.ToArgb(); int rtime = 10 * (60000);//10 minutes in miliseconds DA.InsertCommand.CommandText = "insert into " + Base.BaseName + "..PREFERENCES (IDUSER,REFRESHTIME,COLOR) " + " values (" + UID + "," + rtime + "," + color + ")"; DA.InsertCommand.Connection.Open(); DA.InsertCommand.ExecuteNonQuery(); DA.InsertCommand.Connection.Close(); this.RefreshTime = rtime; this.NoteColor = color; } else { this.RefreshTime = (int)DS.Tables["t"].Rows[0]["REFRESHTIME"]; this.NoteColor = (int)DS.Tables["t"].Rows[0]["COLOR"]; } }
private void button1_Click(object sender, EventArgs e) { DBPreferences dbp = new DBPreferences(this.UserID); switch (CurrentControl.GetType().Name) { case "RefreshTimeSelectControl": RefreshTimeSelectControl rtsc = (RefreshTimeSelectControl)CurrentControl; if (rtsc.radioButton1.Checked) { dbp.SaveRefreshTime(UserID.ToString(), 10 * 60000); mf.SetRefreshTime(10 * 60000); } if (rtsc.radioButton2.Checked) { dbp.SaveRefreshTime(UserID.ToString(), 30 * 60000); mf.SetRefreshTime(30 * 60000); } if (rtsc.radioButton3.Checked) { dbp.SaveRefreshTime(UserID.ToString(), 60 * 60000); mf.SetRefreshTime(60 * 60000); } if (rtsc.radioButton4.Checked) { dbp.SaveRefreshTime(UserID.ToString(), 120 * 60000); mf.SetRefreshTime(120 * 60000); } if (rtsc.radioButton5.Checked) { dbp.SaveRefreshTime(UserID.ToString(), 180 * 60000); mf.SetRefreshTime(180 * 60000); } if (rtsc.radioButton6.Checked) { dbp.SaveRefreshTime(UserID.ToString(), 240 * 60000); mf.SetRefreshTime(240 * 60000); } break; case "ColorSelectControl": ColorSelectControl csc = (ColorSelectControl)CurrentControl; if (csc.radioButton1.Checked) { dbp.SaveNoteColor(UserID.ToString(), csc.panel1.BackColor.ToArgb()); mf.SetNoteColor(csc.panel1.BackColor.ToArgb()); } if (csc.radioButton2.Checked) { dbp.SaveNoteColor(UserID.ToString(), csc.panel2.BackColor.ToArgb()); mf.SetNoteColor(csc.panel2.BackColor.ToArgb()); } if (csc.radioButton3.Checked) { dbp.SaveNoteColor(UserID.ToString(), csc.panel3.BackColor.ToArgb()); mf.SetNoteColor(csc.panel3.BackColor.ToArgb()); } if (csc.radioButton4.Checked) { dbp.SaveNoteColor(UserID.ToString(), csc.panel4.BackColor.ToArgb()); mf.SetNoteColor(csc.panel4.BackColor.ToArgb()); } if (csc.radioButton5.Checked) { dbp.SaveNoteColor(UserID.ToString(), csc.panel5.BackColor.ToArgb()); mf.SetNoteColor(csc.panel5.BackColor.ToArgb()); } break; } button1.Enabled = false; }