public ThucDonUaThich[] LayDSThucDonYeuThich(int makhachhang)
{
Connect();
ThucDonUaThich[] kq;
SqlCommand cmd = new SqlCommand("spLayDSThucDonYeuThich", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@makhachhang", SqlDbType.Int);
cmd.Parameters["@makhachhang"].Value = makhachhang;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable tab = new DataTable();
da.Fill(tab);
kq = new ThucDonUaThich[tab.Rows.Count];
for (int i = 0; i < tab.Rows.Count; ++i)
{
object mon_an = GetDataFromDataRow(tab, i);
kq[i] = (ThucDonUaThich)mon_an;
}
Disconnect();
return(kq);
}
public int ThemThucDon(ThucDonUaThich thucdon)
{
int Kq = 0; // mã thực đơn
Connect();
SqlCommand cmd = new SqlCommand("spThemThucDonYeuThich", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mathucdon", SqlDbType.NVarChar);
cmd.Parameters.Add("@makhachhang", SqlDbType.Int);
cmd.Parameters["@mathucdon"].Value = thucdon.Ma_thuc_don;
cmd.Parameters["@makhachhang"].Value = thucdon.Ma_khach_hang;
cmd.Parameters.Add("@mathucdonyeudau", SqlDbType.Int);
cmd.Parameters["@mathucdonyeudau"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
int mathucdon = int.Parse(cmd.Parameters["@mathucdonyeudau"].Value.ToString());
Kq = mathucdon;
Disconnect();
}
catch (SqlException ex)
{
Disconnect();
throw ex;
}
return(Kq);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
ThucDonUaThich thucdon = new ThucDonUaThich();
thucdon.Ma_thuc_don_yeu_dau = int.Parse(dt.Rows[i]["MaThucDonYeuDau"].ToString());
thucdon.Ma_khach_hang = int.Parse(dt.Rows[i]["MaKhachHang"].ToString());
thucdon.Ma_thuc_don = int.Parse(dt.Rows[i]["MaThucDon"].ToString());
return((object)thucdon);
}
protected void ThemThucDon()
{
ThucDonUaThich[] arr;
arr = bus.LayDSThucDonYeuThich(int.Parse(Session["MaNguoiDung"].ToString()));
if (Session["MaThucDon"] != null)
{
ThucDonUaThich dto = new ThucDonUaThich();
int ma = int.Parse(Session["MaThucDon"].ToString());
if (arr == null)
{
dto.Ma_khach_hang = int.Parse(Session["MaNguoiDung"].ToString());
dto.Ma_thuc_don = ma;
bus.ThemThucDon(dto);
}
else
{
bool flag = false;
for (int i = 0; i < arr.Length; i++)
{
if (int.Parse(arr[i].Ma_thuc_don.ToString()) == ma)
{
flag = true;
}
}
if (flag == false)
{
dto.Ma_khach_hang = int.Parse(Session["MaNguoiDung"].ToString());
dto.Ma_thuc_don = ma;
bus.ThemThucDon(dto);
}
}
Session["MaThucDon"] = null;
XL_THE Kq = new XL_THE("DANH_SACH");
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
}
private void LayDSThucDon()
{
ThucDonYeuDauBUS tdydBus = new ThucDonYeuDauBUS();
ThucDonUaThich[] arr = tdydBus.LayDSThucDonYeuThich(int.Parse(Session["MaNguoiDung"].ToString()));
if (arr == null)
{
return;
}
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < arr.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonUaThich ThucDonUT = (ThucDonUaThich)arr[i];
ThucDonDTO thucdon = thucdonbus.ChiTietThucDon(ThucDonUT.Ma_thuc_don);
//ThucDonDTO thucdon = thucdonbus.ChiTietThucDon((int)arr[i]);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", thucdon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", thucdon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", thucdon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", thucdon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", thucdon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", thucdon.Diem_binh_chon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
public int ThemThucDon(ThucDonUaThich thucdon)
{
return(dao.ThemThucDon(thucdon));
}
