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