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