public async Task <dynamic> traLoiBinhLuan(BinhLuanHoiDap binhLuan)
{
DateTime now = DateTime.Now;
string ngay = now.ToString();
using (var connection = new SqlConnection(connectionstr))
{
try
{
var p = new DynamicParameters();
p.Add("@MaBL", binhLuan.MaBL);
p.Add("@NoiDung", binhLuan.NoiDung);
p.Add("@MaNV", binhLuan.MaNV);
p.Add("@NgayTao", ngay);
connection.Query <string>(@"INSERT INTO DBO.TRALOIBL (MaBL, MaNV, NoiDung ,NgayTao)
VALUES(@MaBL, @MaNV, @NoiDung, @NgayTao)", p, commandType: CommandType.Text);
}
catch (Exception ex)
{
return(ex);
}
}
dynamic result = await this.chiTietBinhLuanAD(binhLuan.MaBL);
return(result);
}
public async Task <dynamic> chiTietBinhLuanAD(int maBL)
{
ChiTietBinhLuanVM chiTietBL = new ChiTietBinhLuanVM();
using (var connection = new SqlConnection(connectionstr))
{
var result = connection.QuerySingleOrDefault <ChiTietBinhLuanVM>(" SELECT MaBL,NgayTao, DanhGia, NoiDung, SP.MaSP, TenSP," +
" SP.DonGia, SP.HinhAnh, SP.TrangThai, SP.SoLuongTon, MaKH, ND.HoTen, ND.TaiKhoan, ND.Email, ND.SoDT " +
"FROM BINHLUAN BL " +
"INNER JOIN SANPHAM_LOAI SP ON BL.MaSP = SP.MaSP " +
"INNER JOIN NGUOIDUNG ND ON BL.MaKH = ND.MaND " +
"WHERE BL.MaBL =" + maBL, commandType: CommandType.Text);
if (result == null)
{
return("Review is not exitst");
}
string queryND = "select TaiKhoan, HoTen, Email, SoDT, DiaChi from NGUOIDUNG where MaND =" + result.MaKH;
NguoiDungInforVM khachHang = connection.QuerySingleOrDefault <NguoiDungInforVM>(queryND, commandType: CommandType.Text);
chiTietBL.MaBL = result.MaBL;
chiTietBL.NoiDung = result.NoiDung;
chiTietBL.DanhGia = result.DanhGia;
chiTietBL.NgayTao = result.NgayTao;
chiTietBL.MaSP = result.MaSP;
chiTietBL.MaKH = result.MaKH;
chiTietBL.KhachHang = khachHang;
string querySP = "select MaSP, HinhAnh, TenSP, SoLuongTon, TrangThai, DonGia from SANPHAM_LOAI where MaSP ='" + result.MaSP + "'";
SanPhamVM sanPham = connection.QuerySingleOrDefault <SanPhamVM>(querySP, commandType: CommandType.Text);
chiTietBL.SanPham = sanPham;
var lstBL = connection.Query <BinhLuanHoiDap>("SELECT * FROM TRALOIBL WHERE MaBL=" + maBL, commandType: CommandType.Text);
if (lstBL != null)
{
foreach (var bl in lstBL)
{
BinhLuanHoiDap binhLuan = new BinhLuanHoiDap();
binhLuan.MaTL = bl.MaTL;
binhLuan.MaBL = bl.MaBL;
binhLuan.MaNV = bl.MaNV;
binhLuan.NgayTao = bl.NgayTao;
binhLuan.NoiDung = bl.NoiDung;
chiTietBL.dsHoiDap.Add(binhLuan);
}
}
}
return(chiTietBL);
}
public async Task <List <DSBinhLuanMaSP> > layDSBinhLuanSP(string maSP)
{
List <DSBinhLuanMaSP> dsbinhLuanMaSP = new List <DSBinhLuanMaSP>();
using (var connection = new SqlConnection(connectionstr))
{
var lstbinhLuan = connection.Query <BinhLuanDSVM>("select BL.MaBL, BL.DanhGia, BL.NoiDung, " +
"BL.NgayTao, TaiKhoan = (select TaiKhoan from NGUOIDUNG ND WHERE ND.MaND = BL.MaKH), " +
"TenSP = (select SP.TenSP from SANPHAM_LOAI SP WHERE SP.MaSP = BL.MaSP) from BINHLUAN BL WHERE BL.MaSP= '" + maSP + "' ORDER BY BL.MaBL DESC", commandType: CommandType.Text);
foreach (var result in lstbinhLuan)
{
DSBinhLuanMaSP dsbinhLuan = new DSBinhLuanMaSP();
BinhLuanDSVM chiTietBL = new BinhLuanDSVM();
chiTietBL.MaBL = result.MaBL;
chiTietBL.TenSP = result.TenSP;
chiTietBL.TaiKhoan = result.TaiKhoan;
chiTietBL.NoiDung = result.NoiDung;
chiTietBL.DanhGia = result.DanhGia;
chiTietBL.NgayTao = result.NgayTao;
dsbinhLuan.binhLuan = chiTietBL;
var lstBL = connection.Query <BinhLuanHoiDap>("SELECT * FROM TRALOIBL WHERE MaBL=" + result.MaBL, commandType: CommandType.Text);
if (lstBL != null)
{
foreach (var bl in lstBL)
{
BinhLuanHoiDap binhLuan = new BinhLuanHoiDap();
binhLuan.MaTL = bl.MaTL;
binhLuan.MaBL = bl.MaBL;
binhLuan.MaNV = bl.MaNV;
binhLuan.NgayTao = bl.NgayTao;
binhLuan.NoiDung = bl.NoiDung;
dsbinhLuan.dsHoiDap.Add(binhLuan);
}
}
dsbinhLuanMaSP.Add(dsbinhLuan);
}
{
}
}
return(dsbinhLuanMaSP);
}
public async Task <dynamic> xoaTraLoiBinhLuan(String MaTL)
{
int maBL = 0;
using (var connection = new SqlConnection(connectionstr))
{
var p = new DynamicParameters();
p.Add("@TABLE", "TRALOIBL");
p.Add("@ID", MaTL);
BinhLuanHoiDap binhLuan = connection.QuerySingleOrDefault <BinhLuanHoiDap>("SP_GETDETAILBYID", p, commandType: CommandType.StoredProcedure);
if (binhLuan == null)
{
return("Review is not exit");
}
maBL = binhLuan.MaBL;
connection.Query("SP_DELETE", p, commandType: CommandType.StoredProcedure);
}
dynamic result = await this.chiTietBinhLuanAD(maBL);
return(result);
}
public async Task <ActionResult> TraLoiBinhLuan(BinhLuanHoiDap binhLuan)
{
dynamic result = await _binhLuanRepository.traLoiBinhLuan(binhLuan);
return(Ok(result));
}
