Exemplo n.º 1
0
        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;
            }
        }
Exemplo n.º 2
0
        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;
            }
        }