public JsonResult GetListPromotion()
{
List <Models.KhuyenMai> PromotionList = new List <Models.KhuyenMai>();
Database db = new Database();
DataTable dt = db.Query("select MaSuKien, TenSuKien from KhuyenMai; ");
for (int i = 0; i < dt.Rows.Count; i++)
{
Models.KhuyenMai Promotion = new Models.KhuyenMai();
Promotion.MaKhuyenMai = dt.Rows[i]["MaSuKien"].ToString();
Promotion.TenSuKien = dt.Rows[i]["TenSuKien"].ToString();
PromotionList.Add(Promotion);
}
return(Json(PromotionList));
}
public JsonResult PromotionList()
{
List <Models.KhuyenMai> PromotionList = new List <Models.KhuyenMai>();
Database db = new Database();
DataTable dt = db.Query("select * from KhuyenMai ;");
for (int i = 0; i < dt.Rows.Count; i++)
{
Models.KhuyenMai Promotion = new Models.KhuyenMai();
Promotion.MaKhuyenMai = dt.Rows[i]["MaSuKien"].ToString();
Promotion.TenSuKien = dt.Rows[i]["TenSuKien"].ToString();
Promotion.NoiDung = dt.Rows[i]["NoiDung"].ToString();
Promotion.ChietKhau = Double.Parse(dt.Rows[i]["ChietKhau"].ToString());
Promotion.ThoiGianBD = dt.Rows[i]["ThoiGianBatDau"].ToString();
Promotion.ThoiGianKT = dt.Rows[i]["ThoiGianKetThuc"].ToString();
Promotion.Hinh = dt.Rows[i]["HinhAnh"].ToString();
PromotionList.Add(Promotion);
}
return(Json(PromotionList));
}
public void AddPromotion(Models.KhuyenMai a)
{
Database db = new Database();
db.Insert("insert into KhuyenMai values (N'" + a.TenSuKien + "', " + a.ChietKhau + ", '" + a.ThoiGianBD + "','" + a.ThoiGianKT + "', N'" + a.NoiDung + "', '" + a.Hinh + "');");
}
