public Book RetrieveBookDetails(int BookID)
{
Book Book1 = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBookDetails(BookID);
if (reader != null)
{
if (reader.Read())
{
Book1 = new Book();
Book1.BookID = (int)reader["BookID"];
Book1.Title = (string)reader["Title"];
Book1.ISBN = (string)reader["ISBN"];
Book1.PublishYear = (string)reader["PublishYear"];
Book1.CoverPrice = (decimal)reader["CoverPrice"];
}
}
return(Book1);
}
public List <Book> RetrieveBooksList()
{
List <Book> books = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBooksList();
DataTable dt = SchemaInfo.CreateBookDetailsSchemaTable();
if (reader != null)
{
books = new List <Book>();
while (reader.Read())
{
books.Add(new Book
{
BookID = (int)reader["BookID"],
Title = (string)reader["Title"],
ISBN = (string)reader["ISBN"],
PublishYear = (string)reader["PublishYear"],
CoverPrice = (decimal)reader["CoverPrice"],
CheckOutStatusDescription = (string)reader["CheckOutStatusDescription"]
});
}
}
return(books);
}
public Borrower RetrieveBookBorrowerDetails(int bookId)
{
Borrower borrower = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBookBorrowerDetails(bookId);
if (reader != null)
{
if (reader.Read())
{
borrower = new Borrower();
borrower.Name = (string)reader["Name"];
borrower.MobileNo = (string)reader["Mobile"];
borrower.ReturnDate = (DateTime)reader["ReturnDate"];
borrower.Book = new Book()
{
ModifiedOn = (DateTime)reader["ModifiedOn"]
};
}
}
return(borrower);
}
public Book RetrieveBookDetails(int bookId)
{
Book book = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBooksList(bookId);
if (reader != null)
{
while (reader.Read())
{
book = new Book
{
BookID = (int)reader["BookID"],
Title = (string)reader["Title"],
ISBN = (string)reader["ISBN"],
PublishYear = (string)reader["PublishYear"],
CoverPrice = (decimal)reader["CoverPrice"],
ModifiedOn = (DateTime)reader["ModifiedOn"],
CheckOutStatusDescription = (string)reader["CheckOutStatusDescription"]
};
}
}
return(book);
}
public Borrower RetrieveBookBorrowerDetails(int BookID)
{
try
{
Borrower borrower = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBookBorrowerDetails(BookID);
if (reader != null)
{
if (reader.Read())
{
borrower = new Borrower();
borrower.Name = (string)reader["Name"];
borrower.MobileNo = (string)reader["Mobile"];
borrower.ReturnDate = (DateTime)reader["ReturnDate"];
}
}
return(borrower);
}
catch (Exception ex)
{
base.logger.SaveException(ex.Message);
}
return(null);
}
public List <Borrower> RetrieveBookCheckOutHistory(int BookID)
{
try
{
List <Borrower> borrowers = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBookCheckOutHistory(BookID);
if (reader != null)
{
borrowers = new List <Borrower>();
while (reader.Read())
{
borrowers.Add(new Borrower
{
Name = (string)reader["Name"],
CheckOutDate = (DateTime)reader["CheckOutDate"],
ReturnDate = (DateTime)reader["ReturnDate"]
});
}
}
return(borrowers);
}
catch (Exception ex)
{
base.logger.SaveException(ex.Message);
}
return(null);
}
public List <GazetteHoliday> RetriveGazetteHoliday()
{
//usp_RetriveGazetteHoliday
List <GazetteHoliday> GazetteHoliday = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetriveGazetteHoliday();
if (reader != null)
{
GazetteHoliday = new List <GazetteHoliday>();
while (reader.Read())
{
GazetteHoliday.Add(new GazetteHoliday
{
Id = (int)reader["Id"],
HolidayDate = (DateTime)reader["HolidayDate"],
Description = (string)reader["Description"]
});
}
}
return(GazetteHoliday);
}
public int CheckOut(int bookID, string Name, string MobileNo, string NationalID, DateTime checkOutDate, DateTime ReturnDate)
{
try
{
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
return(db.CheckOut(bookID, Name, MobileNo, NationalID, checkOutDate, ReturnDate));
}
catch (Exception ex)
{
base.logger.SaveException(ex.Message);
}
return(-1);
}
public int CheckIn(int bookID)
{
try
{
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
return(db.CheckIn(bookID));
}
catch (Exception ex)
{
base.logger.SaveException(ex.Message);
}
return(-1);
}
public List <Book> RetrieveBooksList()
{
try
{
List <Book> books = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBooksList();
DataTable dt = SchemaInfo.CreateBookDetailsSchemaTable();
if (reader != null)
{
books = new List <Book>();
while (reader.Read())
{
books.Add(new Book
{
BookID = (int)reader["BookID"],
Title = (string)reader["Title"],
ISBN = (string)reader["ISBN"],
PublishYear = (string)reader["PublishYear"],
CoverPrice = (decimal)reader["CoverPrice"],
CheckOutStatusDescription = (string)reader["CheckOutStatusDescription"]
,
CurrentBorrowerID = Convert.ToString(reader["CurrentBorrowerID"])
});
}
}
return(books);
}
catch (Exception ex)
{
base.logger.SaveException(ex.Message);
}
return(null);
}
public List <Borrower> RetrieveBookCheckOutHistory(int bookId)
{
List <Borrower> borrowers = null;
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
IDataReader reader = db.RetrieveBookCheckOutHistory(bookId);
if (reader != null)
{
borrowers = new List <Borrower>();
while (reader.Read())
{
borrowers.Add(new Borrower
{
Name = (string)reader["Name"],
CheckOutDate = (DateTime)reader["CheckOutDate"],
ReturnDate = (DateTime)reader["ReturnDate"]
});
}
}
return(borrowers);
}
public int CheckOut(int bookID, string Name, string MobileNo, string NationalID, DateTime checkOutDate, DateTime ReturnDate)
{
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
return(db.CheckOut(bookID, Name, MobileNo, NationalID, checkOutDate, ReturnDate));
}
public int CheckIn(int bookID)
{
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
return(db.CheckIn(bookID));
}
public int CheckIn(int bookId, DateTime modifiedOn)
{
BookCheckInCheckOutDBOperations db = BookCheckInCheckOutDBOperations.getInstance();
return(db.CheckIn(bookId, modifiedOn));
}
