private List <Class_PhieuDatBan> test1()
{
string sql = "SELECT * FROM PhieuDatban";
List <Class_PhieuDatBan> list = new List <Class_PhieuDatBan>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=ADMIN\SQLEXPRESS;Initial Catalog=QLNhaHang;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string MaPhieu = reader.GetString(0);
string MaNhanVien = reader.GetString(1);
string MaKhach = reader.GetString(2);
DateTime NgayDat = reader.GetDateTime(3);
DateTime NgayDung = reader.GetDateTime(4);
decimal TongTien = reader.GetDecimal(5);
Class_PhieuDatBan Test = new Class_PhieuDatBan(MaPhieu, MaKhach, MaNhanVien, NgayDat, NgayDung, TongTien);
list.Add(Test);
}
}
}
con.Close();
return(list);
}
public new List <Class_PhieuDatBan> Select()
{
string sql = "SELECT * FROM PhieuDatban";
List <Class_PhieuDatBan> list = new List <Class_PhieuDatBan>();
query.ketnoiSQL();
using (DbDataReader reader = query.Reader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
string MaPhieu = reader.GetString(0);
string MaNhanVien = reader.GetString(1);
string MaKhach = reader.GetString(2);
DateTime NgayDat = reader.GetDateTime(3);
DateTime NgayDung = reader.GetDateTime(4);
double TongTien;
var Tg = reader.GetValue(5);
if (Tg == DBNull.Value)
{
TongTien = 0;
}
else
{
TongTien = Convert.ToDouble(Tg);
}
Class_PhieuDatBan Test = new Class_PhieuDatBan(MaPhieu, MaKhach, MaNhanVien, NgayDat, NgayDung, TongTien);
list.Add(Test);
}
}
}
query.DongketnoiSQL();
return(list);
}
public void update(Class_PhieuDatBan PDB)
{
string sql = "UPDATE PhieuDatBan WHERE SET MaPhieu=" + PDB.MaPhieu1 + ",MaKhach=N'" +
PDB.MaKhach1 + "', MaNhanVien=N'" + PDB.MaNhanVien1 + "', NgayDat='" + PDB.NgayDat1
+ ",NgayDung=N'" + PDB.NgayDung1 + ",TongTien=N'" + PDB.TongTien1 + "')";
query.insert(sql);
}
public void insert(Class_PhieuDatBan PDB)
{
string sql = "INSERT INTO PhieuDatBan(MaPhieu,MaKhach,MaNhanVien,NgayDat,NgayDung,TongTien) VALUES(";
sql += PDB.MaPhieu1 + ",N'" + PDB.MaKhach1 + "',N'" + PDB.MaNhanVien1 + "',N'" + PDB.NgayDat1 + "',N'"
+ PDB.NgayDung1 + "',N'" + PDB.TongTien1 + "')";
query.insert(sql);
}
public new List <Class_PhieuDatBan> Select()
{
string sql = "SELECT * FROM PhieuDatban";
List <Class_PhieuDatBan> list = new List <Class_PhieuDatBan>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=DESKTOP-MFCIF4Q\SQLEXPRESS;Initial Catalog=QLNhaHang;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string MaPhieu = reader.GetString(0);
string MaNhanVien = reader.GetString(1);
string MaKhach = reader.GetString(2);
DateTime NgayDat = reader.GetDateTime(3);
DateTime NgayDung = reader.GetDateTime(4);
double TongTien;
var Tg = reader.GetValue(5);
if (Tg == DBNull.Value)
{
TongTien = 0;
}
else
{
TongTien = Convert.ToDouble(Tg);
}
Class_PhieuDatBan Test = new Class_PhieuDatBan(MaPhieu, MaKhach, MaNhanVien, NgayDat, NgayDung, TongTien);
list.Add(Test);
}
}
}
con.Close();
return(list);
}
public void delete(Class_PhieuDatBan PDB)
{
string sql = "DELETE FROM PhieuDatBan WHERE MaPhieu = " + PDB.MaPhieu1;
query.insert(sql);
}
