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)); }