public bool IssueBookBLL(LibraryTransaction library) { bool status = false; try { status = obj.IssueBook(library); } catch (BooksException ex) { throw ex; } return(status); }
public bool IssueBook(LibraryTransaction libTransaction) { bool status = false; try { cmd = conn.CreateCommand(); cmd.CommandText = "sp_IssueBook"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BookCode", libTransaction.BookCode); cmd.Parameters.AddWithValue("@Rollno", libTransaction.Rollno); cmd.Parameters.AddWithValue("@Std", libTransaction.Std); cmd.Parameters.AddWithValue("@Div", libTransaction.Div); cmd.Parameters.AddWithValue("@IssueDate", libTransaction.BookIssueDate); cmd.Parameters.AddWithValue("@ExpectedReturnDate", libTransaction.ExpectedReturnDate); conn.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { status = true; } } catch (BooksException ex) { throw ex; } finally { conn.Close(); } return(status); }
static void IssueBookPL() { try { LibraryTransaction library = new LibraryTransaction(); Console.WriteLine("Enter BookCode: "); library.BookCode = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter RollNo: "); library.Rollno = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Std: "); library.Std = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Div: "); library.Div = Console.ReadLine(); library.BookIssueDate = DateTime.Today; library.ExpectedReturnDate = library.BookIssueDate.AddDays(10); if (caller.IssueBookBLL(library)) { Console.WriteLine("Book issued Successfully"); } else { Console.WriteLine("Something went wrong, please try again!"); } } catch (BooksException ex) { throw ex; } }
public bool ReturnBook(LibraryTransaction libTransaction) { bool status = false; try { cmd = conn.CreateCommand(); cmd.CommandText = "sp_searchStudent"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Rollno", libTransaction.Rollno); cmd.Parameters.AddWithValue("@Std", libTransaction.Std); cmd.Parameters.AddWithValue("@Div", libTransaction.Div); cmd.Parameters.AddWithValue("@BookCode", libTransaction.BookCode); conn.Open(); reader = cmd.ExecuteReader(); if (reader.HasRows) { status = true; LibraryTransaction lib = null; while (reader.Read()) { lib = new LibraryTransaction { Rollno = reader.GetInt32(0), Std = reader.GetInt32(1), Div = reader.GetString(2), BookCode = reader.GetInt32(3), ExpectedReturnDate = reader.GetDateTime(4), Fine = reader.GetDouble(5) }; } if (libTransaction.ActualReturnDate > lib.ExpectedReturnDate) { Console.WriteLine("You have to pay Fine !"); cmd = conn.CreateCommand(); cmd.CommandText = "sp_UpdateReturnBooks"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Rollno", libTransaction.Rollno); cmd.Parameters.AddWithValue("@Std", libTransaction.Std); cmd.Parameters.AddWithValue("@Div", libTransaction.Div); cmd.Parameters.AddWithValue("@ActualReturnDate", libTransaction.ActualReturnDate); cmd.Parameters.AddWithValue("@Fine", libTransaction.Fine); int count = cmd.ExecuteNonQuery(); if (count > 0) { status = true; } } else { Console.WriteLine("No need to pay Fine!"); } } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(status); }