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