public void TestMethod2() { DbQuery dc = SingletonObject.GetDbQuery(); bool result = dc.IsAdminPassword("admin"); Assert.IsTrue(result); }
public void TestMethod5() { DbQuery dc = SingletonObject.GetDbQuery(); bool result = dc.IsAdminPassword("password"); Assert.IsFalse(result); }
/// <summary> /// ユーザ名からユーザID取得 /// </summary> /// <param name="userName"></param> /// <returns></returns> private string GetUserId(string userName) { DbQuery dc = SingletonObject.GetDbQuery(); string[] data = dc.SelectUserId(userName); return((data == null) ? null : data[0]); }
/// <summary> /// 分類名から分類ID取得 /// </summary> /// <param name="categroyName"></param> /// <returns></returns> private string GetCategoryId(string categroyName) { DbQuery dc = SingletonObject.GetDbQuery(); string[] data = dc.SelectGenreId(categroyName); return((data == null) ? null : data[0]); }
/// <summary> /// 削除ボタン /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { bool valueEqual = ValueCompare(); bool cancelSelected = valueEqual ? !base.AskMessageBox(GlobalDefine.MESSAGE_ASK_DELETE) : !base.AskMessageBox(GlobalDefine.MESSAGE_ASK_DELETE_CHANGE); if (cancelSelected) { return; } DbQuery dc = SingletonObject.GetDbQuery(); dc.DeleteBook(txtId.Text); MessageBox.Show(GlobalDefine.MESSAGE_COMPLETE_DELETE); mode = MODE.DEL; this.Close(); }
/// <summary> /// 確定ボタンのロジック /// </summary> public void Apply(TextBox textBox) { if (CheckTextBox(textBox.Text)) { MessageBox.Show(GlobalDefine.ERROR_CODE[7].message); textBox.Focus(); return; } DbQuery dc = SingletonObject.GetDbQuery(); if (dc.IsAdminPassword(textBox.Text)) { MessageBox.Show(GlobalDefine.MESSAGE_ADMIN_MODE_ENABLE); menuEnable(); this.Close(); } else { MessageBox.Show(GlobalDefine.ERROR_CODE[8].message, GlobalDefine.CAUTION); textBox.Clear(); textBox.Focus(); } }
/// <summary> /// 確定ボタン /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnApply_Click(object sender, EventArgs e) { if (mode == MODE.MOD) { bool valueEqual = ValueCompare(); if (valueEqual) { MessageBox.Show(GlobalDefine.MESSAGE_NOT_CHANGE_UPDATE); return; } } ApplyButtonCheck(); if (mode == MODE.ADD) { if (!base.AskMessageBox(GlobalDefine.MESSAGE_ASK_REGISTRATION)) { return; } // ID MAX値取得 DbQuery dc = SingletonObject.GetDbQuery(); DBAdapter dba = SingletonObject.GetDbAdapter(); // 新規ID取得(MAX値+1) string newStringId = dba.GetMaxID(nameof(GlobalDefine.BOOK_ID), GlobalDefine.BOOK_MASTER); newStringId = newStringId.Substring(1); int newId = int.Parse(newStringId) + 1; // 0埋めして新規ID作成 string newIdText = string.Format("B{0:D3}", newId); // テーブルに新規レコードを追加する dc.InsertBookMaster(newIdText, this.txtTitle.Text, this.userId, this.dateArrival.Value, this.cmbCategory1.SelectedValue.ToString(), this.cmbCategory2.SelectedValue.ToString(), this.cmbCategory3.SelectedValue.ToString() ); dc.InsertBookStatus(newIdText); MessageBox.Show(GlobalDefine.MESSAGE_COMPLETE_REGISTRATION); this.txtId.Text = newIdText; FormControlsEnabledOnLoad(true); SaveTempValue(); mode = MODE.MOD; return; } if (mode == MODE.MOD) { if (!base.AskMessageBox(GlobalDefine.MESSAGE_ASK_UPDATE)) { return; } // テーブル更新 DbQuery dc = SingletonObject.GetDbQuery(); DBAdapter dba = SingletonObject.GetDbAdapter(); dc.UpdateBookMaster(this.txtTitle.Text, this.userId, this.dateArrival.Value, this.cmbCategory1.SelectedValue.ToString(), this.cmbCategory2.SelectedValue.ToString(), this.cmbCategory3.SelectedValue.ToString(), this.txtId.Text ); MessageBox.Show(GlobalDefine.MESSAGE_COMPLETE_UPDATE); SaveTempValue(); } }