public int InsertBorrowingInformation(CheckOutSummery checkOutSummeryEntity)
{
var insertUserStmt =
@"INSERT INTO [dbo].[CheckOutSummery]([User],[Book],[CheckInDate],[CheckOutDate],[IsOverDue],[NumberOfDays])
VALUES ('{0}','{1}','{2}',{3},{4})";
return(ExecuteCommand(string.Format(insertUserStmt,
checkOutSummeryEntity.User.Id,
checkOutSummeryEntity.Book.Id,
checkOutSummeryEntity.CheckInDate,
checkOutSummeryEntity.CheckOutDate,
checkOutSummeryEntity.IsOverDue = false,
checkOutSummeryEntity.NumberOfDays)));
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
var selectedBookID = 0;
if (!string.IsNullOrWhiteSpace(Request.QueryString["bookID"]))
{
selectedBookID = int.Parse(Request.QueryString["bookID"]);
}
else
{
Utilities.setPageMessage("Please select a book.", Utilities.severity.error, Page.Master);
return;
}
var dbOperations = new DataEntryDataContext();
var bookName = txtName.Text;
var mobileNo = txtMobile.Text;
var nationalID = txtNationalID.Text;
var checkOutDate = DateTime.Parse(lblCheckOutDate.Text);
var checkOutSummery = new CheckOutSummery();
checkOutSummery.Book.Id = selectedBookID;
checkOutSummery.User.Id = dbOperations.GetUserIdByMobileNumber(mobileNo);
checkOutSummery.CheckOutDate = checkOutDate;
var result = dbOperations.InsertBorrowingInformation(checkOutSummery);
if (result == 0)
{
Utilities.setPageMessage("Encountered an error while checking out.", Utilities.severity.error,
Page.Master);
return;
}
Utilities.setPageMessage("Book has been checked out in the name of " + txtName.Text,
Utilities.severity.info, Page.Master);
DisplayBookCheckOutHistory(selectedBookID);
}
