public bool Update(PhieuThuTienSH phieuThuTienSH)
{
try
{
string query = "SELECT * FROM PhieuThuTienSH";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connection);
table = GetData();
table.PrimaryKey = new DataColumn[] { table.Columns[0] };
DataRow row = table.Rows.Find(phieuThuTienSH.PhieuThuTienSHId);
if (row != null)
{
row["tinhTrang"] = phieuThuTienSH.TinhTrang;
row["PhongId"] = phieuThuTienSH.PhongId1;
row["NhanVienId"] = phieuThuTienSH.NhanVienId1;
row["NguoiDungId"] = phieuThuTienSH.NguoiDungId1;
row["ngayThu"] = phieuThuTienSH.NgayThu;
row["soDienDau"] = phieuThuTienSH.SoDienDau;
row["soDienCuoi"] = phieuThuTienSH.SoDienCuoi;
row["soNuocDau"] = phieuThuTienSH.SoNuocDau;
row["soNuocCuoi"] = phieuThuTienSH.SoNuocCuoi;
row["soDienThuc"] = phieuThuTienSH.SoDienThuc;
row["soNuocThuc"] = phieuThuTienSH.SoNuocThuc;
row["donGiaDien"] = phieuThuTienSH.DonGiaDien;
row["donGiaNuoc"] = phieuThuTienSH.DonGiaNuoc;
row["tienThuDien"] = phieuThuTienSH.TienThuDien;
row["tienThuNuoc"] = phieuThuTienSH.TienThuNuoc;
row["phiDichVu"] = phieuThuTienSH.PhiDichVu;
row["tong"] = phieuThuTienSH.Tong;
row["tenNguoiThu"] = phieuThuTienSH.TenNguoiThu;
row["ghiChu"] = phieuThuTienSH.GhiChu;
}
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(dataAdapter);
dataAdapter.Update(table);
return(true);
}
catch
{
return(false);
}
}
public bool Insert(PhieuThuTienSH phieuThuTienSH)
{
try
{
string query = "SELECT * FROM PhieuThuTienSH";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connection);
table = GetData();
DataRow row = table.NewRow();
row["tinhTrang"] = phieuThuTienSH.TinhTrang;
row["PhongId"] = phieuThuTienSH.PhongId1;
row["NhanVienId"] = phieuThuTienSH.NhanVienId1;
row["NguoiDungId"] = phieuThuTienSH.NguoiDungId1;
row["ngayThu"] = phieuThuTienSH.NgayThu;
row["soDienDau"] = phieuThuTienSH.SoDienDau;
row["soDienCuoi"] = phieuThuTienSH.SoDienCuoi;
row["soNuocDau"] = phieuThuTienSH.SoNuocDau;
row["soNuocCuoi"] = phieuThuTienSH.SoNuocCuoi;
row["soDienThuc"] = phieuThuTienSH.SoDienThuc;
row["soNuocThuc"] = phieuThuTienSH.SoNuocThuc;
row["donGiaDien"] = phieuThuTienSH.DonGiaDien;
row["donGiaNuoc"] = phieuThuTienSH.DonGiaNuoc;
row["tienThuDien"] = phieuThuTienSH.TienThuDien;
row["tienThuNuoc"] = phieuThuTienSH.TienThuNuoc;
row["phiDichVu"] = phieuThuTienSH.PhiDichVu;
row["tong"] = phieuThuTienSH.Tong;
row["tenNguoiThu"] = phieuThuTienSH.TenNguoiThu;
row["ghiChu"] = phieuThuTienSH.GhiChu;
table.Rows.Add(row);
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(dataAdapter);
dataAdapter.Update(table);
return(true);
}
catch
{
return(false);
}
}
