public void Update(HoaDon info) { string date = info.NgayLapHD.Month + "/" + info.NgayLapHD.Day + "/" + info.NgayLapHD.Year; string sqlQuery = "update HoaDon" + " set TenKH=N'" + info.TenKH + "'," + "NgayLapHD='"+date+"'"+ "where MaHD='" + info.MaHD + "'"; ExecuteNonQuery(sqlQuery); }
public void Insert(HoaDon info) { string date = info.NgayLapHD.Month + "/" + info.NgayLapHD.Day + "/" + info.NgayLapHD.Year; string sqlQuery = "insert into HoaDon values ('" + info.MaHD + "',N'" + info.TenKH + "','" + date + "')"; ExecuteNonQuery(sqlQuery); }
private void btSua_Click(object sender, RoutedEventArgs e) { Entity.HoaDon info = new Entity.HoaDon() { MaHD = tbMaHoaDon.Text, TenKH = tbTenKhachHang.Text, NgayLapHD = (DateTime)datePicker.SelectedDate }; try { hoaDonBus.Update(info); 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) { Entity.HoaDon info = new Entity.HoaDon() {MaHD=(++id).ToString(), TenKH=tbTenKhachHang.Text, NgayLapHD=(DateTime)datePicker.SelectedDate}; tenKhachHang = tbTenKhachHang.Text; // try { hoaDonBus.Insert(info); MessageBox.Show("Thêm thành công !"); LoadData(); ChiTietHoaDon chiTietHoaDon = new ChiTietHoaDon(tenKhachHang, (DateTime)datePicker.SelectedDate,id.ToString()); chiTietHoaDon.WindowStartupLocation = WindowStartupLocation.CenterScreen; chiTietHoaDon.ShowDialog(); } //catch (Exception) //{ // MessageBox.Show("Thêm thất bại !"); //} }
public List<HoaDon> GetList() { List<HoaDon> list = new List<HoaDon>(); string sqlQuery = "select * from HoaDon"; reader = ExecuteReader(sqlQuery); while (reader.Read()) { HoaDon hoaDon = new HoaDon(); hoaDon.MaHD = reader["MaHD"].ToString(); hoaDon.TenKH = reader["TenKH"].ToString(); hoaDon.NgayLapHD = (DateTime)reader["NgayLapHD"]; list.Add(hoaDon); } return list; }
private void btThem_Click(object sender, RoutedEventArgs e) { Entity.HoaDon info = new Entity.HoaDon() { MaHD = (++id).ToString(), TenKH = tbTenKhachHang.Text, NgayLapHD = (DateTime)datePicker.SelectedDate }; tenKhachHang = tbTenKhachHang.Text; // try { hoaDonBus.Insert(info); MessageBox.Show("Thêm thành công !"); LoadData(); ChiTietHoaDon chiTietHoaDon = new ChiTietHoaDon(tenKhachHang, (DateTime)datePicker.SelectedDate, id.ToString()); chiTietHoaDon.WindowStartupLocation = WindowStartupLocation.CenterScreen; chiTietHoaDon.ShowDialog(); } //catch (Exception) //{ // MessageBox.Show("Thêm thất bại !"); //} }
public void Update(HoaDon info) { data.Update(info); }
public void Insert(HoaDon info) { data.Insert(info); }