private void updateCustom_Click(object sender, EventArgs e)
{
CheckOutUpdateSdi checkOutUpdateSdi = new CheckOutUpdateSdi();
checkOutUpdateSdi.Isbn = Convert.ToInt32(isbnTextBox.Text);
checkOutUpdateSdi.Grade = gradeTextBox.Text;
checkOutUpdateSdi.CheckOutDate = codTextBox.Value;
checkOutUpdateSdi.LibraryCardNumber = lcnTextBox.Text;
checkOutUpdateSdi.Checker = checkerTextBox.Text;
checkOutUpdateSdi.CurrentCondition = currentConditionTextBox.Text;
CheckOut checkOut = checkOutService.updateCheckOut(checkOutUpdateSdi);
if (checkOut != null)
{
this.Close();
checkOutForm.updateDataToTable(checkOut);
}
}
public CheckOut updateCheckOut(CheckOutUpdateSdi checkOutUpdateSdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
StringBuilder sql = new StringBuilder();
sql.Append(" update Check_Out set " +
" checker = @checker," +
" currentCondition = @currentcondition," +
" checkoutDate = @checkoutdate ");
sql.Append(" where isbn = @isbn and grade = @grade and libraryCardNumber = @librarycardnumber");
SqlCommand command = new SqlCommand(sql.ToString(), con);
command.Parameters.AddWithValue("checker", checkOutUpdateSdi.Checker);
command.Parameters.AddWithValue("currentCondition", checkOutUpdateSdi.CurrentCondition);
command.Parameters.AddWithValue("checkoutdate", checkOutUpdateSdi.CheckOutDate);
command.Parameters.AddWithValue("isbn", checkOutUpdateSdi.Isbn);
command.Parameters.AddWithValue("grade", checkOutUpdateSdi.Grade);
command.Parameters.AddWithValue("librarycardnumber", checkOutUpdateSdi.LibraryCardNumber);
command.ExecuteNonQuery();
con.Close();
return(this.getCheckOutByKey(checkOutUpdateSdi.LibraryCardNumber, checkOutUpdateSdi.Isbn, checkOutUpdateSdi.Grade));
}
public CheckOut updateCheckOut(CheckOutUpdateSdi checkOutUpdateSdi)
{
return(checkOutRepoService.updateCheckOut(checkOutUpdateSdi));
}
