private void LoadBookIssueForm()
{
if (_selectedId > 0)
{
var selectedbookIsbnNo = "";
using (var connection = new SqlConnection(@"data source=.\SQLEXPRESS;DATABASE=Library ;Integrated Security=true;")
)
{
var command = new SqlCommand("select Isbn from Book where BookId=@id", connection);
command.Parameters.AddWithValue("@id", _selectedId);
connection.Open();
var reader = command.ExecuteReader();
reader.Read();
selectedbookIsbnNo = reader.GetString(0);
}
this.Hide();
var objBookIssueForm = new BookIssueForm(selectedbookIsbnNo);
objBookIssueForm.Show();
}
else
{
var objDialogWindow = new DialogWindow("Please select book ISBN or a row to issue book", "Warning Dialog", DialogWindow.DialogBoxIconType.Exclamation);
objDialogWindow.ShowDialog();
}
}
private void StudentAddButton_Click(object sender, EventArgs e)
{
if (StudentIdTextBox.Text == "")
{
label8.Show();
}
if (StudentIdTextBox.Text != "")
{
label8.Hide();
}
if (StudentNameTextBox.Text == "")
{
label16.Show();
}
if (StudentNameTextBox.Text != "")
{
label16.Hide();
}
if (LibraryCardNoTextBox.Text == "")
{
label15.Show();
}
if (LibraryCardNoTextBox.Text != "")
{
label15.Hide();
}
if (DepartmentComboBox.Text == "")
{
label5.Show();
}
if (DepartmentComboBox.Text != "")
{
label5.Hide();
}
if (SessionComboBox.Text == "")
{
label6.Show();
}
if (SessionComboBox.Text != "")
{
label6.Hide();
}
if (StudentIdTextBox.Text == "" || StudentNameTextBox.Text == "" || LibraryCardNoTextBox.Text == "" || SessionComboBox.Text == "" || DepartmentComboBox.Text == "")
{
return;
}
if (!CheckIsStudentIdExist())
{
try
{
int departmentId;
using (
var con = new SqlConnection(@"data source=.\SQLEXPRESS;DATABASE=Library ;Integrated Security=true;")
)
{
con.Open();
var command = new SqlCommand("select DepartmentId from Department where DepartmentShortName='" + DepartmentComboBox.SelectedItem + "'or DepartmentFullName='" + DepartmentComboBox.SelectedItem + "' ", con);
SqlDataReader sqlDatRreader = command.ExecuteReader();
sqlDatRreader.Read();
departmentId = sqlDatRreader.GetInt32(0);
}
var stream = new FileStream(_op.FileName, FileMode.Open, FileAccess.Read);
var reader = new StreamReader(stream);
var imgData = new Byte[stream.Length - 1];
stream.Read(imgData, 0, (int)stream.Length - 1);
label7.Hide();
var sqlCommand =
new SqlCommand(
"insert into Student values(@StudentId,@Name,@LibraryCardNo,@DepartmentId,@SessionId,@Image) ",
_connection);
sqlCommand.Parameters.AddWithValue("@StudentId", StudentIdTextBox.Text);
sqlCommand.Parameters.AddWithValue("@DepartmentId", departmentId);
sqlCommand.Parameters.AddWithValue("@SessionId", SessionComboBox.SelectedValue);
sqlCommand.Parameters.AddWithValue("@Name", StudentNameTextBox.Text);
sqlCommand.Parameters.AddWithValue("@LibraryCardNo", LibraryCardNoTextBox.Text);
sqlCommand.Parameters.AddWithValue("@Image", imgData);
sqlCommand.ExecuteNonQuery();
_connection.Close();
if (Convert.ToInt32(label12.Text) == 3)
{
var sqlCommand1 =
new SqlCommand(
"select max(Id) from Student",
_connection);
_connection.Open();
var reader1 = sqlCommand1.ExecuteReader();
reader1.Read();
var id = reader1.GetInt32(0);
_connection.Close();
this.Hide();
var bookReservationPage = new BookIssueForm(id);
bookReservationPage.Closed += (s, args) => this.Close();
bookReservationPage.Show();
}
else
{
LoadStudentGridView();
MessageBox.Show(@"New student has been inserted successfully ", "", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
catch (Exception)
{
MessageBox.Show(@"Something is wrong.Please make sure that student image is uploaded and try again.", "",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
label7.Show();
}
}