private void newStudentToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
var studentInsertForm = new StudentInsertForm();
studentInsertForm.Show();
}
private void BookReservationButton_Click_1(object sender, EventArgs e)
{
if (StudentIdTextBox.Text == "")
{
label6.Show();
}
if (StudentIdTextBox.Text != "")
{
label6.Hide();
}
if (BookIdTextBox.Text == "")
{
label8.Show();
}
if (BookIdTextBox.Text != "")
{
label8.Hide();
}
if (DepartmentComboBox.Text == "")
{
label7.Show();
}
if (DepartmentComboBox.Text != "")
{
label7.Hide();
}
if (BorrowDatePicker.Text == "")
{
label9.Show();
}
if (BorrowDatePicker.Text != "")
{
label9.Hide();
}
if (ReturnDatePicker.Text == "")
{
label10.Show();
}
if (ReturnDatePicker.Text != "")
{
label10.Hide();
}
if (StudentIdTextBox.Text == "" || DepartmentComboBox.Text == "" || BookIdTextBox.Text == "")
{
return;
}
if (CheckIsStudentIsRegistered())
{
if (CheckIsIsbnExist())
{
if (!CheckIsCurrentStudentHasAlreadyAnyResetvationOfBook())
{
if (IsCurrentBookAvailable())
{
int studentId;
int bookId;
int departmentId;
using (var connection =
new SqlConnection(Connection)
)
{
var sqlCommand1 =
new SqlCommand(
"select BookId from Book where Isbn=@Isbn ",
connection);
sqlCommand1.Parameters.AddWithValue("@Isbn", BookIdTextBox.Text);
var sqlCommand2 =
new SqlCommand(
"select DepartmentId from Department where DepartmentShortName=@Department or DepartmentFullName=@Department ",
connection);
sqlCommand2.Parameters.AddWithValue("@Department", DepartmentComboBox.Text);
var sqlCommand3 =
new SqlCommand(
"select Id from Student where StudentId=@IStudentId ",
connection);
sqlCommand3.Parameters.AddWithValue("@IStudentId", StudentIdTextBox.Text);
connection.Open();
var reader1 = sqlCommand1.ExecuteReader();
reader1.Read();
bookId = reader1.GetInt32(0);
connection.Close();
connection.Open();
var reader2 = sqlCommand2.ExecuteReader();
reader2.Read();
departmentId = reader2.GetInt32(0);
connection.Close();
connection.Open();
var reader3 = sqlCommand3.ExecuteReader();
reader3.Read();
studentId = reader3.GetInt32(0);
}
using (var connection =
new SqlConnection(Connection)
)
{
var sqlCommand =
new SqlCommand(
"insert into Borrow(StudentId,DayOfBorrowed,DayOfReturn,BookId,DepartmentId) values(@StudentId,@BorrowDate,@ReturnDate,@BookId,@DepartmentId) ",
connection);
sqlCommand.Parameters.AddWithValue("@StudentId", studentId);
sqlCommand.Parameters.AddWithValue("@BorrowDate",
Convert.ToDateTime(BorrowDatePicker.Text));
sqlCommand.Parameters.AddWithValue("@ReturnDate", Convert.ToDateTime(ReturnDatePicker.Text));
sqlCommand.Parameters.AddWithValue("@BookId", bookId);
sqlCommand.Parameters.AddWithValue("@DepartmentId", departmentId);
connection.Open();
sqlCommand.ExecuteNonQuery();
MessageBox.Show(@"Book Reservation has been completed successfully.", "",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(@"Sorry, this book of ISBN '" + BookIdTextBox.Text + @"' is not available now.", "", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(@"There is already a Reservation for this Student.This time no more reservation is allowed.", "", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(@"Book's ISBN not found", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
var result = MessageBox.Show(@"It seems that Id " + StudentIdTextBox.Text + @" not registered yet. Would you like to registered it now?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
this.Hide();
var studentInsertForm = new StudentInsertForm(3);
studentInsertForm.Closed += (s, args) => this.Close();
studentInsertForm.Show();
}
}
}