public CheckOut insertCheckOut(CheckOutInsertSdi checkOutInsertSdi) { con = SqlServerConnection.getConnnection(); con.Open(); StringBuilder sql = new StringBuilder(); sql.Append("insert into Check_Out (libraryCardNumber,isbn,grade,checker,checkoutdate,currentCondition) values(@librarycardnumber,@isbn,@grade,@checker,@checkoutdate,@currentcondition)"); SqlCommand command = new SqlCommand(sql.ToString(), con); command.Parameters.AddWithValue("librarycardnumber", checkOutInsertSdi.LibraryCardNumber); command.Parameters.AddWithValue("isbn", checkOutInsertSdi.Isbn); command.Parameters.AddWithValue("grade", checkOutInsertSdi.Grade); command.Parameters.AddWithValue("checkoutdate", checkOutInsertSdi.CheckOutDate); command.Parameters.AddWithValue("checker", checkOutInsertSdi.Checker); command.Parameters.AddWithValue("currentCondition", checkOutInsertSdi.CurrentCondition); command.ExecuteNonQuery(); con.Close(); return(this.getCheckOutByKey(checkOutInsertSdi.LibraryCardNumber, checkOutInsertSdi.Isbn, checkOutInsertSdi.Grade)); }
private void insertCustom_Click(object sender, EventArgs e) { if (checkOutService.isExistCheckOut(lcnTextBox.Text, Convert.ToInt32(isbnTextBox.Text), gradeTextBox.Text)) { MessageBox.Show("Exchange already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!checkOutService.isExistISBNInMedia(Convert.ToInt32(isbnTextBox.Text))) { MessageBox.Show("isbn does not exist", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!checkOutService.isExistGradeInCondition(gradeTextBox.Text)) { MessageBox.Show("grade does not exist", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!checkOutService.isExistLibraryCardNumberInPatron(lcnTextBox.Text)) { MessageBox.Show("library card number does not exist", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!checkOutService.isExistEmplIdInEmployee(checkerTextBox.Text)) { MessageBox.Show("imployeeId does not exist", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { CheckOutInsertSdi checkOutInsertSdi = new CheckOutInsertSdi(); checkOutInsertSdi.LibraryCardNumber = lcnTextBox.Text; checkOutInsertSdi.Isbn = Convert.ToInt32(isbnTextBox.Text); checkOutInsertSdi.Grade = gradeTextBox.Text; checkOutInsertSdi.CheckOutDate = codTextBox.Value; checkOutInsertSdi.Checker = checkerTextBox.Text; checkOutInsertSdi.CurrentCondition = currentConditionTextBox.Text; CheckOut checkout = checkOutService.insertCheckOut(checkOutInsertSdi); if (checkout != null) { this.Close(); checkOutForm.addDataToTable(checkout); } } }
public CheckOut insertCheckOut(CheckOutInsertSdi checkOutInsertSdi) { return(checkOutRepoService.insertCheckOut(checkOutInsertSdi)); }