string f = "فارسی";
string en = "انگلیسی";
if (txtBname.Text == "" || txtCount.Text == "" || txtauthor.Text == "" || txtIsbn.Text == "" || txtYear.Text == "" || cbPub.Text == "" || cbCat.Text == "")
MessageBox.Show("لطفا اطلاعات را کامل وارد کنید", "پیام", MessageBoxButtons.OK);
else
{
if (radioBtnTrans.Checked == true)
{
string add = "INSERT INTO book_tbl (" + "bname," + "bauthor," + "pid," + "isbn," + "catid," + "byear," + "bcount," + "blanguage," + "btranslator" + ")VALUES('" + txtBname.Text + "','" + txtauthor.Text + "','" + Int32.Parse(cbPub.SelectedValue.ToString()) + "','" + txtIsbn.Text + "','" + Int32.Parse(cbCat.SelectedValue.ToString()) + "','" + txtYear.Text + "','" + Int32.Parse(txtCount.Text) + "','" + f + "','" + txtTranslator.Text + "')";
catNewFrm.objcon.Open();
SqlCommand cmd = new SqlCommand(add, catNewFrm.objcon);
cmd.ExecuteNonQuery();
if (cmd.ExecuteNonQuery() == 1)
{
MessageBox.Show("درج اطلاعات با موفقیت انجام گردید");
cmd.Parameters.Clear();
}
else
{
MessageBox.Show("خطا");
}
catNewFrm.ds.Clear();
catNewFrm.da.Fill(catNewFrm.ds);
catNewFrm.objcon.Close();
}
else if(radiobtnNotrans.Checked==true)
{
string add = "INSERT INTO book_tbl (" + "bname," + "bauthor," + "pid," + "isbn," + "catid," + "byear," + "bcount," + "blanguage" + ")VALUES('" + txtBname.Text + "','" + txtauthor.Text + "','" + Int32.Parse(cbPub.SelectedValue.ToString()) + "','" + txtIsbn.Text + "','" + Int32.Parse(cbCat.SelectedValue.ToString()) + "','" + txtYear.Text + "','" + txtCount.Text + "','" + f + "')";
catNewFrm.objcon.Open();
SqlCommand cmd = new SqlCommand(add, catNewFrm.objcon);
cmd.ExecuteNonQuery();
if (cmd.ExecuteNonQuery() == 1)
{
MessageBox.Show("درج اطلاعات با موفقیت انجام گردید");
cmd.Parameters.Clear();
}
else
{
MessageBox.Show("خطا");
}
catNewFrm.ds.Clear();
catNewFrm.da.Fill(catNewFrm.ds);
catNewFrm.objcon.Close();
}
else if (radioBtnEnglish.Checked == true)
{
string add = "INSERT INTO book_tbl (" + "bname," + "bauthor," + "pid," + "isbn," + "catid," + "byear," + "bcount," + "blanguage" + ")VALUES('" + txtBname.Text + "','" + txtauthor.Text + "','" + Int32.Parse(cbPub.SelectedValue.ToString()) + "','" + txtIsbn.Text + "','" + Int32.Parse(cbCat.SelectedValue.ToString()) + "','" + txtYear.Text + "','" + txtCount.Text + "','" + en + "')";
catNewFrm.objcon.Open();
SqlCommand cmd = new SqlCommand(add, catNewFrm.objcon);
cmd.ExecuteNonQuery();
if (cmd.ExecuteNonQuery() == 1)
{
MessageBox.Show("درج اطلاعات با موفقیت انجام گردید");
cmd.Parameters.Clear();
}
else
{
MessageBox.Show("خطا");
}
catNewFrm.ds.Clear();
catNewFrm.da.Fill(catNewFrm.ds);
catNewFrm.objcon.Close();