public static bool Insert(Reservation b) { try { SqlConnection cn=new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Insert into Reservation(borrowerNumber,bookNumber,date,status) " + "values(@borrowerNumber,@bookNumber,@date,@status)", cn); cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber); cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber); cmd.Parameters.AddWithValue("@date", b.Date); cmd.Parameters.AddWithValue("@status", b.Status); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }
private void button3_Click(object sender, EventArgs e) { DateTime reserveDate = new DateTime(); try { reserveDate = GetDate(textBox4.Text.Trim()); } catch (Exception) { Console.WriteLine("Invalid Date ! Please try again !"); } Reservation re = new Reservation(memcode, bookcode, reserveDate); re.Id = ReserveBL.IDMax() + 1; ReserveDA.Insert(re); DataSet ds = ReserveBL.selectTableReservation(memcode); DataView dv = new DataView(ds.Tables[0]); dataGridView1.DataSource = dv; label6.Text = "" + ds.Tables[0].Rows.Count; }