private void B_Add_DB_Click(object sender, EventArgs e)
{
int error = 0;
try
{
if (B_Add_Name.Text.Equals(""))
{
MessageBox.Show("책이름을 확인하여 주십시오", "Information");
error++;
}
else if (B_Add_Writer.Text.Equals(""))
{
MessageBox.Show("작가명을 확인하여 주십시오", "Information");
error++;
}
else if (!(B_Add_Realse1.Text.Length == 4) || !(B_Add_Realse2.Text.Length == 2) || !(B_Add_Realse3.Text.Length == 2))
{
MessageBox.Show("출판년도를 확인하여 주십시오", "Information");
B_Add_Realse1.Text = "";
B_Add_Realse2.Text = "";
B_Add_Realse3.Text = "";
error++;
}
else if (!(Convert.ToInt32(B_Add_Realse1.Text) > 1000) || !(Convert.ToInt32(B_Add_Realse2.Text) > 0) || !(Convert.ToInt32(B_Add_Realse2.Text) < 13) || !(Convert.ToInt32(B_Add_Realse3.Text) > 0) || !(Convert.ToInt32(B_Add_Realse3.Text) < 32))
{
MessageBox.Show("출판년도를 확인하여 주십시오", "Information");
B_Add_Realse1.Text = "";
B_Add_Realse2.Text = "";
B_Add_Realse3.Text = "";
error++;
}
if (error == 0)
{
string Realse = B_Add_Realse1.Text + "-" + B_Add_Realse2.Text + "-" + B_Add_Realse3.Text;
string str = "INSERT INTO book (name,writer,realse) VALUES('" + B_Add_Name.Text + "','" + B_Add_Writer.Text + "','" + Realse + "');";
MySqlCommand cmd = new MySqlCommand(str, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("추가 완료", "Information");
Form1 fa = (Form1)this.Owner;
fa.Book_DB_List();
B_Add_Name.Text = "";
B_Add_Writer.Text = "";
B_Add_Realse1.Text = "";
B_Add_Realse2.Text = "";
B_Add_Realse3.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show("출판년도를 확인하여 주십시오", "Information");
B_Add_Realse1.Text = "";
B_Add_Realse2.Text = "";
B_Add_Realse3.Text = "";
error++;
}
}
