public List <VatPham> LayToanBoVatPham()
{
List <VatPham> dsvp = new List <VatPham>();
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.ThongTinVatPham(0)";
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
VatPham vp = new VatPham();
vp.MaVP = reader.GetInt32(0);
vp.TenVP = reader.GetString(1);
vp.TenNguoiBan = reader.GetString(2);
vp.SDT = reader.GetString(3);
vp.ThanhPho = reader.GetString(4);
vp.MoTa = reader.GetString(5);
vp.TinhTrang = reader.GetString(6);
vp.GiaTien = reader.GetInt64(7);
vp.TheLoai = reader.GetString(8);
int temp = reader.GetInt32(9);
vp.NgayDang = ChuyenThoiGian(temp);
vp.LinkHinhAnh = new List <string>();
vp.LinkHinhAnh.Add(reader.GetString(10));
vp.ChatLuong = reader.GetInt32(11);
vp.DiaDiem = reader.GetString(12);
dsvp.Add(vp);
}
reader.Close();
return(dsvp);
}
public List <VatPham> LayVatPhamDangBan(string sdt)
{
List <VatPham> dsvp = new List <VatPham>();
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.VatPhamDaDangCua(@sdt)";
command.Connection = conn;
command.Parameters.Add("@sdt", SqlDbType.NChar).Value = sdt;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
VatPham vp = new VatPham();
vp.MaVP = reader.GetInt32(0);
vp.TenVP = reader.GetString(1);
vp.GiaTien = reader.GetInt64(2);
int temp = reader.GetInt32(3);
vp.NgayDang = ChuyenThoiGian(temp);
vp.LinkHinhAnh = new List <string>();
vp.LinkHinhAnh.Add(reader.GetString(4));
vp.KiemDuyet = reader.GetInt32(5);
vp.NgungBan = reader.GetInt32(6);
dsvp.Add(vp);
}
reader.Close();
return(dsvp);
}
public List <VatPham> LayVatPham(int MaDM, int Trang)
{
int start = (Trang - 1) * 12;
List <VatPham> dsvp = new List <VatPham>();
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
if (Trang > 0)
{
command.CommandText = "select * from dbo.DanhSachVatPham(@MaDM) order by NgayDang OFFSET " + start + " ROWS FETCH NEXT 12 ROWS ONLY;";
}
else
{
command.CommandText = "select * from dbo.DanhSachVatPham(@MaDM)";
}
command.Connection = conn;
command.Parameters.Add("@MaDM", SqlDbType.Int).Value = MaDM;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
VatPham vp = new VatPham();
vp.MaVP = reader.GetInt32(0);
vp.TenVP = reader.GetString(1);
vp.TenNguoiBan = reader.GetString(2);
vp.SDT = reader.GetString(3);
vp.ThanhPho = reader.GetString(4);
vp.MoTa = reader.GetString(5);
vp.TinhTrang = reader.GetString(6);
vp.GiaTien = reader.GetInt64(7);
vp.TheLoai = reader.GetString(8);
int temp = reader.GetInt32(9);
vp.NgayDang = ChuyenThoiGian(temp);
vp.LinkHinhAnh = new List <string>();
vp.LinkHinhAnh.Add(reader.GetString(10));
vp.ChatLuong = reader.GetInt32(11);
vp.DiaDiem = reader.GetString(12);
vp.LoaiTK = reader.GetInt32(13);
vp.MaTP = reader.GetInt32(14);
dsvp.Add(vp);
}
reader.Close();
return(dsvp);
}
public VatPham ThongTinChiTietVatPham(int MaVP)
{
VatPham vp = new VatPham();
try
{
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.ThongTinVatPham(@MaVP)";
command.Connection = conn;
command.Parameters.Add("@MaVP", SqlDbType.Int).Value = MaVP;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
vp.MaVP = reader.GetInt32(0);
vp.TenVP = reader.GetString(1);
vp.TenNguoiBan = reader.GetString(2);
vp.SDT = reader.GetString(3);
vp.ThanhPho = reader.GetString(4);
vp.MoTa = reader.GetString(5);
vp.TinhTrang = reader.GetString(6);
vp.GiaTien = reader.GetInt64(7);
vp.TheLoai = reader.GetString(8);
int temp = reader.GetInt32(9);
vp.NgayDang = ChuyenThoiGian(temp);
vp.ChatLuong = reader.GetInt32(11);
vp.DiaDiem = reader.GetString(12);
vp.MaDM = reader.GetInt32(13);
vp.LuotThich = reader.GetInt32(14);
reader.Close();
vp.LinkHinhAnh = LayHinhAnh(vp.MaVP);
}
}
catch
{
}
return(vp);
}
public List <VatPham> TimKiemVP(string str, int MaTL)
{
List <VatPham> dsvp = new List <VatPham>();
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.TimKiem(@str,@MaTL)";
command.Connection = conn;
command.Parameters.Add("@MaTL", SqlDbType.Int).Value = MaTL;
command.Parameters.Add("@str", SqlDbType.NVarChar).Value = str;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
VatPham vp = new VatPham();
vp.MaVP = reader.GetInt32(0);
vp.TenVP = reader.GetString(1);
vp.TenNguoiBan = reader.GetString(2);
vp.SDT = reader.GetString(3);
vp.ThanhPho = reader.GetString(4);
vp.MoTa = reader.GetString(5);
vp.TinhTrang = reader.GetString(6);
vp.GiaTien = reader.GetInt64(7);
vp.TheLoai = reader.GetString(8);
int temp = reader.GetInt32(9);
vp.NgayDang = ChuyenThoiGian(temp);
vp.LinkHinhAnh = new List <string>();
vp.LinkHinhAnh.Add(reader.GetString(10));
vp.ChatLuong = reader.GetInt32(11);
vp.DiaDiem = reader.GetString(12);
vp.LoaiTK = reader.GetInt32(13);
dsvp.Add(vp);
}
reader.Close();
return(dsvp);
}
public List <VatPham> VatPhamDaThich(string sdt)
{
List <VatPham> dsvp = new List <VatPham>();
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.DanhSachVatPham(0) where MaVP in (select MaVP from YeuThich where SDT= @sdt)";
command.Connection = conn;
command.Parameters.Add("@sdt", SqlDbType.NChar).Value = sdt;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
VatPham vp = new VatPham();
vp.MaVP = reader.GetInt32(0);
vp.TenVP = reader.GetString(1);
vp.TenNguoiBan = reader.GetString(2);
vp.SDT = reader.GetString(3);
vp.ThanhPho = reader.GetString(4);
vp.MoTa = reader.GetString(5);
vp.TinhTrang = reader.GetString(6);
vp.GiaTien = reader.GetInt64(7);
vp.TheLoai = reader.GetString(8);
int temp = reader.GetInt32(9);
vp.NgayDang = ChuyenThoiGian(temp);
vp.LinkHinhAnh = new List <string>();
vp.LinkHinhAnh.Add(reader.GetString(10));
vp.ChatLuong = reader.GetInt32(11);
vp.DiaDiem = reader.GetString(12);
vp.LoaiTK = reader.GetInt32(13);
dsvp.Add(vp);
}
reader.Close();
return(dsvp);
}