public IHttpActionResult PutHT_PHAN_HOI_PHAN_MEM(PhanHoi phanhoi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//Lưu thông tin nhập kho
//HT_PHAN_HOI_PHAN_MEM ph = new HT_PHAN_HOI_PHAN_MEM();
var ph = db.HT_PHAN_HOI_PHAN_MEM.Where(x => x.ID == phanhoi.ID).FirstOrDefault();
ph.NHAN_VIEN_PHAN_HOI = phanhoi.NHAN_VIEN_PHAN_HOI;
ph.THONG_TIN_PHAN_HOI = phanhoi.THONG_TIN_PHAN_HOI;
ph.THONG_TIN_PHAN_HOI_TOT = phanhoi.THONG_TIN_PHAN_TOT;
ph.THONG_TIN_PHAN_HOI_TRUNG_BINH = phanhoi.THONG_TIN_PHAN_HOI_TRUNG_BINH;
ph.THONG_TIN_PHAN_HOI_KHONG_TOT = phanhoi.THONG_TIN_PHAN_HOI_KHONG_TOT;
ph.THONG_TIN_PHAN_HOI_LUNG_TUNG = phanhoi.THONG_TIN_PHAN_HOI_LUNG_TUNG;
ph.NGUOI_DUYET = phanhoi.NGUOI_DUYET;
ph.NGAY_DUYET = DateTime.Today.Date;
ph.TINH_DIEM = Convert.ToInt32(phanhoi.TINH_DIEM);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
throw;
}
return(Ok(ph.THONG_TIN_PHAN_HOI));
}
public ActionResult FeedBack(PhanHoi feedback)
{
ThongBaoMvc thongbao;
var user = kiemtra.getUser(User.Identity.Name);
db.PhanHois.Add(new PhanHoi {
Comments = feedback.Comments, Datecomments = DateTime.Now, UserID = user.Id
});
try {
db.SaveChanges();
thongbao = new ThongBaoMvc {
CssClassName = "success", Message = "Chúng tôi đã nhận phản hồi từ bạn! Cảm ơn đã sử dụng phần mềm của chúng tôi"
};
TempData["ResultAction"] = thongbao;
}
catch (Exception e)
{
thongbao = new ThongBaoMvc {
CssClassName = "danger", Message = "Lỗi"
};
TempData["ResultAction"] = thongbao;
log.Error("Có lỗi trong quá trình gửi phản hồi! Mong bạn thử lại :" + e.Message);
return(View(feedback));
}
return(View(feedback));
}
public async Task <ActionResult <PhanHoi> > PostPhanHoi(PhanHoi phanHoi)
{
_context.PhanHois.Add(phanHoi);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPhanHoi", new { id = phanHoi.IdPH }, phanHoi));
}
//=========================================================================== Phản hồi blog
public ActionResult P_hoi_blog(string noidung)
{
if (ModelState.IsValid)
{
PhanHoi phanhoi = new PhanHoi();
if (Session["ThanhVien"] != null)
{
if (noidung != null)
{
ThanhVien tv = Session["ThanhVien"] as ThanhVien;
Blog blg = Session["Ctiet_Blog"] as Blog;
phanhoi.ID_blog = blg.MaBlog;
phanhoi.ID_user = tv.ID_user;
phanhoi.NgayDang = DateTime.Now;
phanhoi.TieuDe = null;
phanhoi.NoiDung = noidung;
db.PhanHois.Add(phanhoi);
db.SaveChanges();
return(RedirectToAction("ChitietBlog", "Home", new { id = blg.MaBlog }));
}
else
{
ModelState.AddModelError("", "Bạn chưa nhập nội dung!");
}
}
else
{
ModelState.AddModelError("", "Bạn cần đăng nhập để gửi phản hồi!");
}
}
return(RedirectToAction("Login"));
}
public async Task <IActionResult> PutPhanHoi(string id, PhanHoi phanHoi)
{
if (id != phanHoi.TaiKhoan)
{
return(BadRequest());
}
_context.Entry(phanHoi).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PhanHoiExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Edit(int id, [Bind("Id,NgayKham,MaSoBenhNhan,HoVaTen,Email,NgaySinh,GioiTinh,DienThoai,NoiDung,NgayGui,DaXem,FkLoaiPhanHoi,FkNgonNgu,NoiDungTraLoi,NgayTraLoi,FkUserTraLoi,DiaChi,IsShow,TieuDe")] PhanHoi phanHoi)
{
if (id != phanHoi.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var listNgonNgu = await GetListNgonNguAsync();
ViewBag.ListNgonNgu = listNgonNgu;
_context.Update(phanHoi);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PhanHoiExists(phanHoi.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["FkNgonNgu"] = new SelectList(_context.NgonNgu, "Id", "Id", phanHoi.FkNgonNgu);
ViewData["FkUserTraLoi"] = new SelectList(_context.User, "UserName", "UserName", phanHoi.FkUserTraLoi);
return(View(phanHoi));
}
public IHttpActionResult PostHT_PHAN_HOI_PHAN_MEM(PhanHoi phanhoi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//Lưu thông tin nhập kho
HT_PHAN_HOI_PHAN_MEM ph = new HT_PHAN_HOI_PHAN_MEM();
ph.NGAY_PHAN_HOI = DateTime.Today.Date;
ph.NHAN_VIEN_PHAN_HOI = phanhoi.NHAN_VIEN_PHAN_HOI;
ph.THONG_TIN_PHAN_HOI = phanhoi.THONG_TIN_PHAN_HOI;
db.HT_PHAN_HOI_PHAN_MEM.Add(ph);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
throw;
}
return(Ok(ph.THONG_TIN_PHAN_HOI));
}
public List <PhanHoi> xoaphanhoi(int ph)
{
PhanHoi ph_db = ctx.PhanHois.Where(x => x.MaPhanHoi == ph).SingleOrDefault();
ctx.PhanHois.Remove(ph_db);
ctx.SaveChanges();
return(ctx.PhanHois.ToList());
}
public ActionResult DeleteConfirmed(int id)
{
PhanHoi phanHoi = db.PhanHoi.Find(id);
db.PhanHoi.Remove(phanHoi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "IDkhachhang,TenKhachHang,Ykien")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.Entry(phanHoi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phanHoi));
}
public ActionResult Edit([Bind(Include = "MaPhanHoi,TenNguoiPhanHoi,NoiDung,NgayPhanHoi")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.Entry(phanHoi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phanHoi));
}
public IActionResult Contact(PhanHoi model)
{
model.TinhTrang = 0;//
DateTime currentDate = DateTime.Now;
model.NgayPhanHoi = currentDate;
phanhoiRepository.themphanhoi(model);
//ViewBag.mess = "thong tin đã được gửi";
return(View(model));
}
public ActionResult Edit([Bind(Include = "MaPhanHoi,HoTen,Email,DiaChi,SDT,NoiDung")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.Entry(phanHoi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phanHoi));
}
public ActionResult Create([Bind(Include = "IDkhachhang,TenKhachHang,Ykien")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.PhanHois.Add(phanHoi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phanHoi));
}
public void DanhGiaSp(PhanHoi ph)
{
try
{
db.PhanHois.Add(ph);
db.SaveChanges();
}
catch (Exception)
{
}
}
public ActionResult Create([Bind(Include = "PhanHoiId,NoiDung")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.phanHois.Add(phanHoi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phanHoi));
}
public ActionResult Edit([Bind(Include = "MaPhanHoi,MaNguoiDung,NoiDung,NgayPhanHoi")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.Entry(phanHoi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs, "MaNguoiDung", "TenNguoiDung", phanHoi.MaNguoiDung);
return(View(phanHoi));
}
public ActionResult Create([Bind(Include = "MaPhanHoi,HoTen,Email,DiaChi,SDT,NoiDung")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.PhanHoi.Add(phanHoi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phanHoi));
}
public ActionResult PhanHoi(PhanHoi ph)
{
DanhGiaSpDao dgDao = new DanhGiaSpDao();
if (ModelState.IsValid)
{
dgDao.DanhGiaSp(ph);
return(View("CamOn"));
}
return(View("Index"));
}
public ActionResult DanhGiaSp(PhanHoi ph, int masanpham)
{
SanPhamDao spDao = new SanPhamDao();
DanhGiaSpDao dgDao = new DanhGiaSpDao();
if (ModelState.IsValid)
{
dgDao.DanhGiaSp(ph);
}
return(View("ChiTietSp", spDao.searchProduct(masanpham)));
}
public ActionResult Create([Bind(Include = "MaPhanHoi,TenNguoiPhanHoi,NoiDung,NgayPhanHoi")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.PhanHois.Add(phanHoi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phanHoi));
}
public ActionResult XoaYKien(int MaPH = 0)
{
if (ModelState.IsValid)
{
PhanHoi ph = cn.PhanHois.SingleOrDefault(n => n.MaPH == MaPH);
cn.PhanHois.Remove(ph);
cn.SaveChanges();
SetAlert("Xóa thành công", "success");
}
return(View());
}
public ActionResult Detail(string maPH)
{
PhanHoi ph = context.PhanHois.SingleOrDefault(n => n.MaPhanHoi == maPH);
if (ph == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(ph));
}
public IHttpActionResult GetPhanHoi(int id)
{
PhanHoi phanHoi = db.PhanHoi.Find(id);
if (phanHoi == null)
{
return(NotFound());
}
return(Ok(phanHoi));
}
public ActionResult Edit([Bind(Include = "Id,KhachHangId,NoiDung,NgayTao,Status")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.Entry(phanHoi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.KhachHangId = new SelectList(db.KhachHang, "Id", "Ten", phanHoi.KhachHangId);
return(View(phanHoi));
}
public ActionResult Create([Bind(Include = "MaPhanHoi,MaNguoiDung,NoiDung,NgayPhanHoi")] PhanHoi phanHoi)
{
if (ModelState.IsValid)
{
db.PhanHois.Add(phanHoi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs, "MaNguoiDung", "TenNguoiDung", phanHoi.MaNguoiDung);
return(View(phanHoi));
}
protected void btnCapnhat_Click(object sender, EventArgs e)
{
DataAccess data = new DataAccess();
ThanhVien tv = (ThanhVien)Session["thanhvien"];
PhanHoi ph = new PhanHoi();
ph.id_TV = tv.id;
ph.noiDung = txtNoiDung.Text;
ph.ngayGui = Convert.ToDateTime(DateTime.Now);
data.ThemLienHe(ph);
Response.Write("<script>alert('Cảm ơn bạn đã gửi liên hệ với chúng tôi');</script>");
txtNoiDung.Text = "";
}
public int phanhoi_tao(string HoTen, byte Tuoi, string DiaChi, string TieuDe, string NoiDung)
{
PhanHoi ph = new PhanHoi();
ph.TieuDe = TieuDe;
ph.HoTen = HoTen;
ph.DiaChi = DiaChi;
ph.NoiDung = NoiDung;
ph.Tuoi = Tuoi;
ph.IP = CommonFunc.getIPAddress();
return(ph.Add());
}
public PhanHoi suaphanhoi(PhanHoi ph)
{
PhanHoi ph_db = ctx.PhanHois.Where(x => x.MaPhanHoi == ph.MaPhanHoi).SingleOrDefault();
//MaPhanHoi, NoiDungPhanHoi, TinhTrang, NgayPhanHoi, TieuDe, Email, HoTen
ph_db.NoiDungPhanHoi = ph.NoiDungPhanHoi;
ph_db.TinhTrang = ph.TinhTrang;
ph_db.NgayPhanHoi = ph.NgayPhanHoi;
ph_db.TieuDe = ph.TieuDe;
ctx.SaveChanges();
return(ph);
}
public IHttpActionResult PostPhanHoi(PhanHoi phanHoi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
phanHoi.NgayTao = DateTime.Now;
phanHoi.Status = false;
db.PhanHoi.Add(phanHoi);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = phanHoi.Id }, phanHoi));
}
protected void btnCapnhat_Click(object sender, EventArgs e)
{
DataAccess data = new DataAccess();
ThanhVien tv = (ThanhVien)Session["thanhvien"];
PhanHoi ph = new PhanHoi();
ph.id_TV = tv.id;
ph.noiDung = txtNoiDung.Text;
ph.ngayGui = Convert.ToDateTime(DateTime.Now);
data.ThemLienHe(ph);
Response.Write("<script>alert('Cảm ơn bạn đã gửi liên hệ với chúng tôi');</script>");
txtNoiDung.Text = "";
}
protected void btnCapnhat_Click(object sender, EventArgs e)
{
try
{
DataAccess data = new DataAccess();
ThanhVien tv = (ThanhVien)Session["thanhvien"];
PhanHoi ph = new PhanHoi();
ph.id_TV = tv.id;
ph.tieuDe = txtTieuDe.Text;
ph.noiDung = txtNoiDung.Text;
ph.ngayGui = Convert.ToDateTime(DateTime.Now);
data.ThemLienHe(ph);
Response.Write("<script>alert('Cảm ơn bạn đã gửi liên hệ với chúng tôi');</script>");
txtNoiDung.Text = "";
txtTieuDe.Text = "";
//Response.Redirect("/");
}
catch (Exception ex)
{
Response.Write("<script>alert(" + ex.Message + ");</script>");
}
}
public void ThemLienHe(PhanHoi ph)
{
string sql = "INSERT INTO tblPhanHoi(id_TV, noiDung,ngayGui) VALUES(@id_TV, @noiDung,@ngayGui)";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@id_TV", ph.id_TV);
cmd.Parameters.AddWithValue("@ngayGui", ph.ngayGui);
cmd.Parameters.Add("@noiDung", SqlDbType.NText);
cmd.Parameters["@noiDung"].Value = ph.noiDung;
cmd.ExecuteNonQuery();
con.Close();
}
