public static bool CapNhatChiTietGoiMonTheoMaGoiMon(ChiTietGoiMonDTO ctgm)
{
bool kq;
string sql = string.Format("update ChiTietGoiMon set MaThucDon = {0), SoLuong = {1} where MaGoiMon where MaGoiMon = {2}", ctgm.MaTD, ctgm.SoLuong, ctgm.MaGoiMon);
kq = SqlDataAccessHelper.ExecuteNonQuery(sql);
return(kq);
}
public static bool ThemChiTietGoiMon(ChiTietGoiMonDTO ctgm)
{
bool kq;
ctgm.MaCTGoiMon = MaTuTang();
string sql = string.Format("insert into ChiTietGoiMon values ({0}, {1}, {2}, {3}, {4})", ctgm.MaCTGoiMon, ctgm.MaGoiMon, ctgm.MaTD, ctgm.DonGia, ctgm.SoLuong);
kq = SqlDataAccessHelper.ExecuteNonQuery(sql);
return(kq);
}
//Rút trích dữ liêu: select
public static List <ChiTietGoiMonDTO> LayDSCTGMTuMaGoiMon(int maGoiMon)
{
List <ChiTietGoiMonDTO> _ds = new List <ChiTietGoiMonDTO>();
string sql = "select * from ChiTietGoiMon where MaGoiMon = " + maGoiMon;
DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ChiTietGoiMonDTO ctgm = new ChiTietGoiMonDTO();
ctgm.MaCTGoiMon = int.Parse(dt.Rows[i]["MaCTGoiMon"].ToString());
ctgm.MaGoiMon = int.Parse(dt.Rows[i]["MaGoiMon"].ToString());
ctgm.MaTD = int.Parse(dt.Rows[i]["MaThucDon"].ToString());
ctgm.DonGia = double.Parse(dt.Rows[i]["DonGia"].ToString());
ctgm.SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString());
_ds.Add(ctgm);
}
return(_ds);
}
public static bool ThemChiTietGoiMon(ChiTietGoiMonDTO ctgm)
{
bool kq = ChiTietGoiMonDAO.ThemChiTietGoiMon(ctgm);
return(kq);
}
