public static bool Insert(Reservation b) { try { string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString; SqlConnection cn = new SqlConnection(conn); 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; } }
protected void Button3_Click(object sender, EventArgs e) { memcode = int.Parse(TextBox1.Text); bookcode = int.Parse(TextBox3.Text); ReserveBL.getBooktitle(bookcode); DateTime reserveDate = new DateTime(); bool test = true; try { reserveDate = GetDate(TextBox5.Text.Trim()); } catch (Exception) { Console.WriteLine("Invalid Date ! Please try again !"); test = false; } 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]); GridViewReserved.DataSource = dv; GridViewReserved.DataBind(); Label8.Text = "" + ds.Tables[0].Rows.Count; Button2.Enabled = false; if (test == true) { Button3.Enabled = false; TextBox5.Enabled = false; } }