public MonAnYeuDauDTO[] LayDSMonAnYeuThich(int makhachhang)
{
Connect();
MonAnYeuDauDTO[] kq;
SqlCommand cmd = new SqlCommand("spLayDSMonAnYeuThich", 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 MonAnYeuDauDTO[tab.Rows.Count];
for (int i = 0; i < tab.Rows.Count; ++i)
{
object mon_an = GetDataFromDataRow(tab, i);
kq[i] = (MonAnYeuDauDTO)mon_an;
}
Disconnect();
return(kq);
}
public int ThemMonAnYeuDau(MonAnYeuDauDTO dto)
{
int Kq = 0;
Connect();
SqlCommand cmd = new SqlCommand("spThemMonAnYeuDau", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@makhachhang", SqlDbType.Int);
cmd.Parameters.Add("@mamon", SqlDbType.Int);
cmd.Parameters["@makhachhang"].Value = dto.Ma_khach_hang;
cmd.Parameters["@mamon"].Value = dto.Ma_mon;
cmd.Parameters.Add("@mamonyeudau", SqlDbType.Int);
cmd.Parameters["@mamonyeudau"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
Disconnect();
Kq = int.Parse(cmd.Parameters["@mamonyeudau"].Value.ToString());
}
catch (SqlException ex)
{
Disconnect();
}
return(Kq);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
MonAnYeuDauDTO monan = new MonAnYeuDauDTO();
monan.Ma_mon_yeu_dau = int.Parse(dt.Rows[i]["MaMonYeuDau"].ToString());
monan.Ma_khach_hang = int.Parse(dt.Rows[i]["MaKhachHang"].ToString());
monan.Ma_mon = int.Parse(dt.Rows[i]["MaMon"].ToString());
return((object)monan);
}
protected void ThemMonAn()
{
MonAnYeuDauBUS maydBus = new MonAnYeuDauBUS();
MonAnYeuDauDTO[] arr;
MonAnYeuDauDTO dto = new MonAnYeuDauDTO();
arr = maydBus.LayDSMonAnYeuThich(int.Parse(Session["MaNguoiDung"].ToString()));
if (Session["MaMon"] != null)
{
int ma = int.Parse(Session["MaMon"].ToString());
if (arr == null)
{
dto.Ma_khach_hang = int.Parse(Session["MaNguoiDung"].ToString());
dto.Ma_mon = ma;
bus.ThemMonAnYeuDau(dto);
}
else
{
bool flag = false;
for (int i = 0; i < arr.Length; i++)
{
if (int.Parse(arr[i].Ma_mon.ToString()) == ma)
{
flag = true;
}
}
if (flag == false)
{
dto.Ma_khach_hang = int.Parse(Session["MaNguoiDung"].ToString());
dto.Ma_mon = ma;
bus.ThemMonAnYeuDau(dto);
}
}
Session["MaMon"] = null;
XL_THE Kq = new XL_THE("DANH_SACH");
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
}
private void LayDSMonAn()
{
MonAnYeuDauBUS maydBus = new MonAnYeuDauBUS();
MonAnYeuDauDTO[] arr = maydBus.LayDSMonAnYeuThich(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("MonAn");
MonAnYeuDauDTO MonAnYeuDau = (MonAnYeuDauDTO)arr[i];
MonAnDTO monan = monanbus.ChiTietMonAn(MonAnYeuDau.Ma_mon);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_mon", monan.Ma_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_mon", monan.Ten_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", monan.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", monan.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", monan.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", monan.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 ThemMonAnYeuDau(MonAnYeuDauDTO dto)
{
return(dao.ThemMonAnYeuDau(dto));
}
