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);
}
