internal static bool Update(Model.Common.SearchBoxSetting s) { try { Model.Common.ArchiveCommonDataClassesDataContext db = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString); var sbs = db.SearchBoxSettings.Where(a => a.ID == s.ID).FirstOrDefault(); sbs.ArchiveSelected = s.ArchiveSelected; sbs.ArchiveFieldSelectedIndex = s.ArchiveFieldSelectedIndex; sbs.ConditionIdSelectedIndex = s.ConditionIdSelectedIndex; db.SubmitChanges(); return(true); } catch { return(false); } }
public static Model.Common.SearchBoxSetting GetDefault() { Model.Common.ArchiveCommonDataClassesDataContext dc = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString); int userCode = Setting.User.ThisProgram.GetCurrentUser <Model.Common.User>().Code; int ArchiveId = (int)EnumArchives.Student; try { ArchiveId = Convert.ToInt32(Setting.Archive.ThisProgram.SelectedArchiveTree.ArchiveID); } catch { ArchiveId = (int)EnumArchives.Student; } Model.Common.SearchBoxSetting sbs = dc.SearchBoxSettings.Where(q => q.UserCode == userCode && q.ArchiveSelected == ArchiveId).FirstOrDefault(); if (sbs != null) { return(sbs); } else { if (ArchiveId == (int)EnumArchives.Student) { sbs = new Model.Common.SearchBoxSetting(); sbs.ArchiveSelected = (int)EnumArchives.Student; sbs.UserCode = userCode; sbs.ArchiveFieldSelectedIndex = (int)EnumArchiveField.شماره_دانشجویی_کارمندی_اساتید; sbs.ConditionIdSelectedIndex = 1; return(sbs); } else { sbs = new Model.Common.SearchBoxSetting(); sbs.ArchiveSelected = ArchiveId; sbs.UserCode = userCode; sbs.ArchiveFieldSelectedIndex = (int)EnumArchiveField.نام_خانوادگی; sbs.ConditionIdSelectedIndex = 0; return(sbs); } } }
internal static bool Insert(int archivefieldselectedindex, int conditionselectedindex) { try { Model.Common.ArchiveCommonDataClassesDataContext db = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString); int userCode = Setting.User.ThisProgram.GetCurrentUser <Model.Common.User>().Code; int ArchiveId = (int)EnumArchives.Student; try { ArchiveId = Convert.ToInt32(Setting.Archive.ThisProgram.SelectedArchiveTree.ArchiveID); } catch { ArchiveId = (int)EnumArchives.Student; } Model.Common.SearchBoxSetting sbs = db.SearchBoxSettings.Where(q => q.UserCode == userCode && q.ArchiveSelected == ArchiveId).FirstOrDefault(); if (sbs == null) { sbs = new Model.Common.SearchBoxSetting(); sbs.ArchiveSelected = ArchiveId; sbs.UserCode = userCode; sbs.ArchiveFieldSelectedIndex = archivefieldselectedindex; sbs.ConditionIdSelectedIndex = conditionselectedindex; db.SearchBoxSettings.InsertOnSubmit(sbs); db.SubmitChanges(); return(true); } else { sbs.ArchiveSelected = ArchiveId; sbs.ArchiveFieldSelectedIndex = archivefieldselectedindex; sbs.ConditionIdSelectedIndex = conditionselectedindex; return(Update(sbs)); } } catch { return(false); } }
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e) { if (tabControl1.SelectedTab == tabPage1) { Model.Common.SearchBoxSetting sbs = Controller.Common.SearchBoxSettingController.GetDefault(); comboBoxExtendedField_Simple.SelectedIndex = sbs.ArchiveFieldSelectedIndex; comboBoxExtendedMethod_Simple.SelectedIndex = sbs.ConditionIdSelectedIndex; textBoxExtendedValue_Simple.Focus(); } else if (tabControl1.SelectedTab == tabPage2) { Model.Common.SearchBoxSetting sbs = Controller.Common.SearchBoxSettingController.GetDefault(); comboBoxExtendedField_Advance.SelectedIndex = sbs.ArchiveFieldSelectedIndex; comboBoxExtendedMethod_Advance.SelectedIndex = sbs.ConditionIdSelectedIndex; textBoxExtendedValue_Advance.Focus(); } }