Example #1
0
        public void Update(TacGia info)
        {
            string sqlQuery = "update TacGia" +
                              " set TenTG=N'" + info.TenTG + "'" +
                              "where MaTG='" + info.MaTG + "'";

            ExecuteNonQuery(sqlQuery);
        }
Example #2
0
        public void Insert(TacGia info)
        {
            string sqlQuery = "insert into TacGia values ('" +
                info.MaTG + "',N'" +
                info.TenTG + "')";

            ExecuteNonQuery(sqlQuery);
        }
        private void btSua_Click(object sender, RoutedEventArgs e)
        {
            TacGia tacGia = new TacGia() { MaTG = tbMaTacGia.Text, TenTG = tbTenTacGia.Text };

            TacGiaBUS bus = new TacGiaBUS();

            try
            {
                bus.Update(tacGia);

                MessageBox.Show("Sửa thành công !");
            }
            catch (Exception)
            {
                MessageBox.Show("Sửa thất bại !");
            }
           

            LoadData();
        }
        private void btThem_Click(object sender, RoutedEventArgs e)
        {
            TacGia tacGia = new TacGia() { MaTG = (++id).ToString(), TenTG = tbTenTacGia.Text };

            TacGiaBUS bus = new TacGiaBUS();

            try
            {
                bus.Insert(tacGia);

                MessageBox.Show("Thêm thành công !");
            }
            catch (Exception)
            {
                MessageBox.Show("Thêm thất bại !");
            }
            

            LoadData();
        }
Example #5
0
        public List<TacGia> GetList()
        {
            List<TacGia> list = new List<TacGia>();

            string sqlQuery = "select * from TacGia";

            reader = ExecuteReader(sqlQuery);

            while (reader.Read())
            {
                TacGia tacGia = new TacGia();

                tacGia.MaTG = reader["MaTG"].ToString();
                tacGia.TenTG = reader["TenTG"].ToString();
     
                list.Add(tacGia);
            }

            return list;
        }
Example #6
0
 public void Update(TacGia info)
 {
     data.Update(info);
 }
Example #7
0
 public void Insert(TacGia info)
 {
     data.Insert(info);
 }