private void addNewBookToolStripMenuItem1_Click(object sender, EventArgs e)
{
frmaddnewbook obj = new frmaddnewbook();
bool frmpresent = CheckForDuplicationForm(obj);
if (frmpresent)
{
return;
}
else if (!frmpresent)
{
obj.MdiParent = this;
obj.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
string query = "select Registration_Id from tbl_registration where Registration_Id='" + txtregid.Text + "'";
try
{
con.DBOpenConnection();
SqlCommand cmd = new SqlCommand(query, DBConnect.DBConnection);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
//while (dr.Read())
//{
groupBox2.Visible = true;
txtregid.ReadOnly = true;
string NQuery = "select * from tbl_BooksInfo where Status='True'";
try
{
dr.Close();
con.OpenConnection();
SqlCommand ncmd = new SqlCommand(NQuery, DBConnect.Connection);
SqlDataReader Ndr = cmd.ExecuteReader();
if (Ndr.HasRows)
{
//cbbookname.Items.Add("Select Book");
////cbauthor.Items.Add("Select Author");
//cbedition.Items.Add("Select Edition");
//cbedition.SelectedText = "Select Edition";
//cbbookname.SelectedText = "Select Book";
////cbauthor.SelectedText = "Select Author";
Ndr.Close();
//try
//{
string myquery = "select distinct BookName from tbl_BooksInfo where Status='True' order by BookName";
//con.OpenConnection();
SqlDataAdapter adap = new SqlDataAdapter(myquery, DBConnect.Connection);
DataTable newdt = new DataTable();
adap.Fill(newdt);
DataRow row = newdt.NewRow();
row["BookName"] = "Select Book";
newdt.Rows.InsertAt(row, 0);
cbbookname.DataSource = newdt;
cbbookname.DisplayMember = "BookName";
cbbookname.ValueMember = "BookName";
//}
//catch (SqlException ex)
//{
// MessageBox.Show(ex.Message);
//}
//finally
//{
// con.CloseConnection();
//}
}
else
{
MessageBox.Show("No Book Available \nPlease Add Book First");
frmaddnewbook obj = new frmaddnewbook();
obj.Show();
this.Dispose();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.CloseConnection();
}
//}
}
else
{
lblerror.Text = "Record Not Found \nPlease Register student First";
lblerror.ForeColor = Color.Red;
txtregid.Focus();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.DBCloseConnection();
}
}
