Exemplo n.º 1
0
 private void btReserve_Click(object sender, EventArgs e)
 {
     label2.Text = "1";
     int memID= int.Parse(tbMemberID.Text);
     int bookID=int.Parse(tbBookID.Text);
     Reservation c = new Reservation(memID,bookID,DateTime.Now,'R');
     ReservationDA.Insert(c);
     DataSet ds = ReservationDA.SelectDS();
     DataView dv = new DataView(ds.Tables[0]);
     dv.RowFilter="borrowerNumber="+memID + "And status='R'";
     dataGridView1.DataSource=dv;
 }
Exemplo n.º 2
0
        public static bool Delete(Reservation c)
        {
            try
            {
                SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True");
                SqlCommand cmd = new SqlCommand("Delete Reservation where id = @id", cn);
                cmd.Parameters.AddWithValue("@id", c.Id);

                cn.Open();
                cmd.ExecuteNonQuery();
                cn.Close();

                return true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }
        }
Exemplo n.º 3
0
        public static bool Insert(Reservation c)
        {
            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", c.BorrowerNumber);
                cmd.Parameters.AddWithValue("@bookNumber", c.BookNumber);
                cmd.Parameters.AddWithValue("@date", c.Date);
                cmd.Parameters.AddWithValue("@status", c.Status);

                cn.Open();
                cmd.ExecuteNonQuery();
                cn.Close();
                return true;
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }
        }
Exemplo n.º 4
0
        public static bool Update(Reservation c)
        {
            try
            {
                SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True");
                SqlCommand cmd = new SqlCommand("Update Reservation set borrowerNumber = @borrowerNumber, "
                + "bookNumber = @bookNumber, date = @date, status=@status where id = @id", cn);
                cmd.Parameters.AddWithValue("@borrowerNumber", c.BorrowerNumber);
                cmd.Parameters.AddWithValue("@bookNumber", c.BookNumber);
                cmd.Parameters.AddWithValue("@date", c.Date);
                cmd.Parameters.AddWithValue("@status", c.Status);
                cmd.Parameters.AddWithValue("@id", c.Id);

                cn.Open();
                cmd.ExecuteNonQuery();
                cn.Close();

                return true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }
        }