private void btnSave_Click(object sender, EventArgs e)
{
SachKhuyenMai sachKhuyenMai = new SachKhuyenMai
{
MaSach = Convert.ToInt32(txtIDBook.Text),
MucGiamGia = (float)Convert.ToDouble(txtDiscount.Text)
};
BLL_SachKhuyenMai.Instance.ExecuteSachKM_BLL(sachKhuyenMai);
Show(txtSearchName.Text);
ResetGUI();
}
public bool AddSachKM_DAL(SachKhuyenMai sachKhuyenMai)
{
string query = string.Format("insert into SachKhuyenMai values ({0}, {1})", sachKhuyenMai.MaSach, sachKhuyenMai.MucGiamGia);
if (DBHelper.Instance.ExecuteDB(query))
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateSachKM_DAL(SachKhuyenMai sachKhuyenMai)
{
string query = string.Format("Update SachKhuyenMai set MucGiamGia = {0} where SachKhuyenMai.MaSach = {1} ",
sachKhuyenMai.MaSach, sachKhuyenMai.MucGiamGia);
if (DBHelper.Instance.ExecuteDB(query))
{
return(true);
}
else
{
return(false);
}
}
//hàm lấy thông tin sách chưa có trong table sachKhuyenMai
public void ExecuteSachKM_BLL(SachKhuyenMai sachKhuyenMai)
{
bool check = false;
foreach (DataRow i in DAL_SachKhuyenMai.Instance.getAllSachKhuyenMai().Rows)
{
if (sachKhuyenMai.MaSach == Convert.ToInt32(i["MaSach"]))
{
check = true;
break;
}
}
if (check)
{
BLL_SachKhuyenMai.Instance.UpdateSachKM_BLL(sachKhuyenMai);
}
else
{
BLL_SachKhuyenMai.Instance.AddSachKM_BLL(sachKhuyenMai);
}
}
public bool UpdateSachKM_BLL(SachKhuyenMai sachKhuyenMai)
{
return(DAL_SachKhuyenMai.Instance.UpdateSachKM_DAL(sachKhuyenMai));
}
public bool AddSachKM_BLL(SachKhuyenMai sachKhuyenMai)
{
return(DAL_SachKhuyenMai.Instance.AddSachKM_DAL(sachKhuyenMai));
}
