private void BtnLend_Click(object sender, EventArgs e)
{
dtoIssue.CardID = dtoCard.CardID;
dtoIssue.StaffID = Session.StaffWorking.StaffID;
dtoIssue.BookID = dtoBook.BookID;
dtoIssue.IssueDate = dtpIssueDate.Value;
dtoIssue.Notes = txtNotes.Text;
if (bllIssue.Add(dtoIssue))
{
DtoReturn dtoReturn = new DtoReturn(
bllReturn.GetNextID(),
dtoIssue.IssueID,
Session.StaffWorking.StaffID,
0,
DateTime.Now);
if (bllReturn.Add(dtoReturn))
{
MessageBox.Show(StringHelper.Notification.Success);
SaveHistory();
Close();
}
}
else
{
MessageBox.Show(StringHelper.Notification.SomethingWentWrong);
}
}
private void DgwHistoryReturn_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgwHistoryReturn.Rows.Count.Equals(0))
{
return;
}
string returnID = dgwHistoryReturn.CurrentRow.Cells["ReturnID"].Value.ToString();
dtoReturn = bllReturn.GetByID(returnID);
btnReturnDetails.Enabled = true;
}
private void ReturnBook_Load(object sender, EventArgs e)
{
txtReturnID.Text = bllReturn.GetNextID();
txtCardID.Text = dtoCard.CardID;
txtStaffID.Text = Session.StaffWorking.StaffID;
txtStaffName.Text = Session.StaffWorking.StaffName;
txtBookID.Text = dtoBook.BookID;
txtBookName.Text = dtoBook.BookName;
txtAuthorName.Text = dtoBook.AuthorName;
txtPublisherName.Text = dtoBook.PublisherName;
txtISBN.Text = dtoBook.ISBN;
txtIssueDate.Text = dtoIssue.IssueDate.ToString("dd / MM / yyyy");
txtReturnDate.Text = DateTime.Today.ToString("dd / MM / yyyy");
//
dtoReturn = bllReturn.GetByIssueID(dtoIssue.IssueID);
}
public bool ReturnBook(DtoReturn dtoReturn)
{
using (SqlConnection sqlConnection = data.GetConnect()) {
try {
sqlConnection.Open();
string sql = @"UPDATE [RETURN] SET BeReturned = 1, ReturnDate = @ReturnDate WHERE IssueID = @IssueID";
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
sqlCommand.Parameters.Add("@ReturnDate", SqlDbType.DateTime).Value = dtoReturn.ReturnDate;
sqlCommand.Parameters.Add("@IssueID", SqlDbType.NChar).Value = dtoReturn.IssueID;
sqlCommand.ExecuteNonQuery();
}
catch {
return(false);
}
}
return(true);
}
public bool Add(DtoReturn dtoReturn)
{
using (SqlConnection sqlConnection = data.GetConnect()) {
try {
sqlConnection.Open();
string sql = @"INSERT INTO [RETURN] VALUES(@ReturnID, @IssueID, @StaffID, @BeReturned, @ReturnDate)";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
cmd.Parameters.Add("@ReturnID", SqlDbType.NChar).Value = dtoReturn.ReturnID;
cmd.Parameters.Add("@IssueID", SqlDbType.NChar).Value = dtoReturn.IssueID;
cmd.Parameters.Add("@StaffID", SqlDbType.NChar).Value = dtoReturn.StaffID;
cmd.Parameters.Add("@BeReturned", SqlDbType.Int).Value = dtoReturn.BeReturned;
cmd.Parameters.Add("@ReturnDate", SqlDbType.Date).Value = dtoReturn.ReturnDate;
cmd.ExecuteNonQuery();
}
catch {
return(false);
}
}
return(true);
}
public bool UpdateReturn(DtoReturn dtoReturn)
{
using (SqlConnection sqlConnection = data.GetConnect()) {
try {
sqlConnection.Open();
string sql = @"UPDATE [RETURN] SET IssueID = @IssueID, StaffID = @StaffID, BeReturned = @BeReturned, ReturnDate = @ReturnDate WHERE ReturnID = @ReturnID";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
cmd.Parameters.Add("@ReturnID", SqlDbType.NChar).Value = dtoReturn.ReturnID;
cmd.Parameters.Add("@IssueID", SqlDbType.NChar).Value = dtoReturn.IssueID;
cmd.Parameters.Add("@StaffID", SqlDbType.NChar).Value = dtoReturn.StaffID;
cmd.Parameters.Add("@BeReturned", SqlDbType.Int).Value = dtoReturn.BeReturned;
cmd.Parameters.Add("@ReturnDate", SqlDbType.Date).Value = dtoReturn.ReturnDate;
cmd.ExecuteNonQuery();
}
catch {
return(false);
}
}
return(true);
}
public bool ReturnBook(DtoReturn dtoReturn)
{
return(dalIssue.ReturnBook(dtoReturn));
}
// not
public bool UpdateReturn(DtoReturn dtoReturn)
{
return(dalReturn.UpdateReturn(dtoReturn));
}
public bool Add(DtoReturn dtoReturn)
{
return(dalReturn.Add(dtoReturn));
}
public ReturnDetails(DtoCard dtoCard, DtoReturn dtoReturn)
{
InitializeComponent();
this.dtoCard = dtoCard;
this.dtoReturn = dtoReturn;
}
