public KhuyenMai GetOneKm(string id)
{
DataTable dt = db.GetData("SELECT * FROM khuyenMai WHERE maKm='" + id + "'");
KhuyenMai l = new KhuyenMai();
l.maKm = dt.Rows[0][0].ToString();
l.maSp = dt.Rows[0][1].ToString();
l.tenKm = dt.Rows[0][2].ToString();
l.ngayBatDau = dt.Rows[0][3].ToString();
l.ngayKetThuc = dt.Rows[0][4].ToString();
return(l);
}
public List <KhuyenMai> GetAllKm()
{
DataTable dt = db.GetData("SELECT * FROM khuyenMai");
List <KhuyenMai> li = new List <KhuyenMai>();
foreach (DataRow dr in dt.Rows)
{
KhuyenMai l = new KhuyenMai();
l.maKm = dr[0].ToString();
l.maSp = dr[1].ToString();
l.tenKm = dr[2].ToString();
l.ngayBatDau = dr[3].ToString();
l.ngayKetThuc = dr[4].ToString();
li.Add(l);
}
return(li);
}
public void suaKm(KhuyenMai x)
{
string sql = "UPDATE khuyenMai SET maSp = '" + x.maSp + "', tenKm = N'" + x.tenKm + "' , ngayBatDau = '" + getDate(x.ngayBatDau) + "' , ngayKetThuc = '" + getDate(x.ngayKetThuc) + "' WHERE maKm = '" + x.maKm + "'";
db.WriteData(sql);
}
public void themKm(KhuyenMai x)
{
string sql = "INSERT INTO khuyenMai VALUES('" + x.maKm + "','" + x.maSp + "',N'" + x.tenKm + "' ,'" + getDate(x.ngayBatDau) + "','" + getDate(x.ngayKetThuc) + "')";
db.WriteData(sql);
}
