public ActionResult Add(ChuDe cd)
{
KhachHang kh = Session["KhachHang"] as KhachHang;
if (kh == null)
{
return(RedirectToAction("Index", "DangNhap"));
}
else if (kh.LoaiKH == "Khách Hàng")
{
return(RedirectToAction("Index", "Home"));
}
else
{
using (var db = new BookContext())
{
Log log = new Log();
log.TacVu = "Admin";
log.ThoiGian = DateTime.Now;
log.TaiKhoan = kh.TaiKhoan;
log.HanhDong = "Đã thêm chủ đề có tên là " + cd.TenChuDe;
db.Log.Add(log);
ChuDe chuDe = new ChuDe();
chuDe.TenChuDe = cd.TenChuDe;
db.ChuDe.Add(chuDe);
db.SaveChanges();
Session["ListCD"] = db.ChuDe.Where(i => i.flag == false).ToList();
return(RedirectToAction("Index", "ChuDe"));
}
}
}
public ActionResult Edit(ChuDe item)
{
if (ModelState.IsValid)
{
if (item.ChuDeID == -1)
{
item.UserModified = item.UserCreated = User.Username;
item.DateModified = item.DateCreated = DateTime.UtcNow;
ChuDeManager.Instance.CreateItem(item);
}
else
{
var existingItem = ChuDeManager.Instance.GetItem(item.ChuDeID);
existingItem.Ten = item.Ten;
existingItem.MoTa = item.MoTa;
existingItem.ThuTu = item.ThuTu;
existingItem.UserModified = User.Username;
existingItem.DateModified = DateTime.UtcNow;
ChuDeManager.Instance.UpdateItem(existingItem);
}
return(RedirectToDefaultRoute());
}
else
{
return(View(item));
}
}
// POST: api/ChuDe
public ChuDe Post([FromBody] ChuDe chude)
{
ChuDe cd = new ChuDe();
SqlConnection conn = DataProvider.Connect();
conn.Open();
if (cd.kiemtra(chude.maChuDe))
{
String sQuery = "INSERT INTO [dbo].[ChuDe]([MaCD],[TenCD],[MaMonHoc],[TrangThai],[MaGV])VALUES(@macd,@tencd,@mamonhoc,@trangthai,@magv)";
SqlCommand insertcommand = new SqlCommand(sQuery, conn);
insertcommand.Parameters.AddWithValue("@macd", chude.maChuDe);
insertcommand.Parameters.AddWithValue("@tencd", chude.tenChuDe);
insertcommand.Parameters.AddWithValue("@mamonhoc", chude.maMonHoc);
insertcommand.Parameters.AddWithValue("@trangthai", chude.trangThai);
insertcommand.Parameters.AddWithValue("@magv", chude.maGiaoVien);
int result = insertcommand.ExecuteNonQuery();
conn.Close();
cd = cd.cd(chude.maChuDe);
if (result > 0)
{
return(cd);
}
}
else
{
return(cd);
}
return(cd);
}
// GET: api/ChuDe/5
public IEnumerable <ChuDe> Get(string machude)
{
ChuDe cd = new ChuDe();
cd = cd.cd(machude);
yield return(cd);
}
public ActionResult Update(ChuDe cd)
{
KhachHang kh = Session["KhachHang"] as KhachHang;
if (kh == null)
{
return(RedirectToAction("Index", "DangNhap"));
}
else if (kh.LoaiKH == "Khách Hàng")
{
return(RedirectToAction("Index", "Home"));
}
else
{
ChuDe chuDe = db.ChuDe.Find((Session["ChuDe"] as ChuDe).MaChuDe);
if (chuDe.TenChuDe != cd.TenChuDe)
{
Log log = new Log();
log.TacVu = "Admin";
log.ThoiGian = DateTime.Now;
log.TaiKhoan = kh.TaiKhoan;
log.HanhDong = "Đã thay đổi chủ đề có tên là " + chuDe.TenChuDe + " thành " + cd.TenChuDe;
db.Log.Add(log);
}
chuDe.TenChuDe = cd.TenChuDe;
db.SaveChanges();
return(RedirectToAction("Index", "ChuDe"));
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (textBoxCategoryName.Text == "")
{
MessageBox.Show("Hãy nhập tên chủ đề !");
}
else
{
var category = new ChuDe()
{
TenCD = textBoxCategoryName.Text
};
ChuDeDao dao = new ChuDeDao();
var res = dao.insertCategory(category.TenCD);
if (res > 0)
{
MessageBox.Show("Thêm thành công !");
clearAll();
}
else
{
MessageBox.Show("Chưa thêm được !");
}
}
}
public IHttpActionResult PutChuDe(int id, ChuDe chuDe)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != chuDe.IDChuDe)
{
return(BadRequest());
}
db.Entry(chuDe).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ChuDeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// Hàm lấy thông tin để đưa lên modal sửa
/// Author Date Comments
/// DangBQ 27/09/19 Tạo mới
/// </summary>
/// <param name="id">Id của chủ đề cần sửa</param>
/// <returns>Đối tượng chủ đề lấy được</returns>
public ActionResult LayChiTietById(string id)
{
try
{
if (!string.IsNullOrEmpty(id))
{
int chuDeId = -1;
int.TryParse(id, out chuDeId);
if (chuDeId > 0)
{
ChuDe objChuDe = DataProvider.Entities.ChuDes.Where(p => p.Id == chuDeId).First();
//Tạo đối tượng trả về
/*VaiTro objReturn = new VaiTro();
* objReturn.Id = objChuDe.Id;
* objReturn.TenVaiTro = obj.TenVaiTro;
* objReturn.MoTa = obj.MoTa;*/
return(Json(objChuDe, JsonRequestBehavior.AllowGet));
}
}
return(Json(new VaiTro(), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new JsonPostBack("Có lỗi xảy ra. Chi tiết: " + ex.Message, false), JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteConfirmed(string id)
{
try
{
int d = db.Saches.Count(sp => sp.MaChuDe == id);
if (d > 0)
{
throw new Exception("Chủ đề đã có sản phẩm rồi !!!!!!");
}
ChuDe chuDe = db.ChuDes
.Find(id);
if (chuDe == null)
{
throw new Exception("Chủ đề đã bị xóa rồi !!!!!!");
}
db.ChuDes.Remove(chuDe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
object cauThongBao = $"Lỗi không hủy được dữ liệu.<br/>Lý do: {ex.Message}";
return(View("Error2", cauThongBao));
}
}
public ActionResult Index(ChuDe cd)
{
var tk = Session["TaiKhoan"] as KhachHang;
if (tk == null)
{
return(View("../Login/Index"));
}
else
{
if (tk.LoaiTK != "Admin")
{
return(View("../Home/Index"));
}
else
{
if (Session["UpdateCD"] == null)
{
var db = new ChuDeDAO();
db.InsertCD(cd);
Session["ListCD"] = null;
return(RedirectToAction("Reset", "ChuDe", new { area = "Admin" }));
}
else
{
var dao = new ChuDeDAO();
var cd1 = Session["UpdateCD"] as ChuDe;
dao.UpdateCD(cd1.IdChuDe, cd);
Session["UpdateCD"] = null;
Session["ListCD"] = null;
return(RedirectToAction("Reset", "ChuDe", new { area = "Admin" }));
}
}
}
}
private ChuDe CatchTopic(int index, string content)
{
ChuDe cd = new ChuDe();
switch (index)
{
case 0:
cd.IDTopic = "CayCoi";
break;
case 1:
cd.IDTopic = "ConVat";
break;
case 2:
cd.IDTopic = "DoVui";
break;
case 3:
cd.IDTopic = "LichSu";
break;
case 4:
cd.IDTopic = "TheGioi";
break;
case 5:
cd.IDTopic = "TheThao";
break;
}
cd.NameTopic = content;
return(cd);
}
public void Remove(int?Id)
{
ChuDe findResults = webEnglishDBContext.ChuDe.Find(Id);
webEnglishDBContext.ChuDe.Remove(findResults);
webEnglishDBContext.SaveChanges();
}
private void cmdGhi_Click(object sender, EventArgs e)
{
if (txtChuDe.Text.Trim() != "")
{
ChuDe cd = new ChuDe();
cd.Ten_Chu_De = txtChuDe.Text.Trim();
if (_Action == "Add")
{
obj.add(cd);
MessageBox.Show("Tạo tài khoản thành công!");
changeControlState(true);
gridChuDe.DataSource = null;
gridChuDe.DataSource = obj.listChude();
}
if (_Action == "Edit")
{
cd.ID = id_;
obj.update(cd);
MessageBox.Show("Sửa tên chủ đề thành công!");
changeControlState(true);
gridChuDe.DataSource = null;
gridChuDe.DataSource = obj.listChude();
}
}
else
{
MessageBox.Show("Vui lòng nhập tên chủ đề.");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Quyen"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
if (Session["Quyen"].ToString() != "1")
{
Response.Redirect("Default.aspx");
}
}
string Id = Request.QueryString["Id"];
try
{
ChuDe c = new ChuDe();
c.MaChuDe = Convert.ToInt32(Id);
c.XoaChuDe();
Response.Redirect("Default.aspx?Function=QuanLyChuDe");
}
catch
{ }
}
public bool Update(ChuDe model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "sp_chude_update",
"@id", model.id,
"@idcd", model.idcd,
"@tieude", model.tieude,
/* "@ngaydang", model.ngaydang, */
"@noidung", model.noidung);
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string Id = Request.QueryString["Id"];
if (Session["MaNguoiDung"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
if (Session["Quyen"].ToString() != "1")
{
if (Id != null)
{
ThanhVien_ChuDe tv = new ThanhVien_ChuDe();
tv.MaChuDe = Convert.ToInt32(Id);
if (tv.LayMaNguoiDung() != Convert.ToInt32(Session["MaNguoiDung"]))
{
Response.Redirect("Default.aspx");
}
}
else
{
Response.Redirect("Default.aspx");
}
}
}
if (!Page.IsPostBack)
{
ChuDe c = new ChuDe();
c.MaChuDe = Convert.ToInt32(Id);
txtTen.Text = c.ChiTietChuDe()["tenchude"].ToString();
}
}
// GET: AdminChuDe/Details/5
public ActionResult Details(string id)
{
User nguoiDung = Session["NguoiDung"] as User;
if (nguoiDung != null)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
//Nếu id = null hoặc < 1 thì quay về trang Index
try
{
ChuDe chuDe = db.ChuDes
.Find(id);
if (chuDe == null)
{
throw new Exception($"Mã chủ đề = " + id + " không tồn tại!!!");
}
return(View(chuDe));
}
catch (Exception ex)
{
object cauThongBao = $"Lỗi truy cập dữ liệu.<br/>Lý do: {ex.Message}";
return(View("Error2", cauThongBao));
}
}
else
{
return(RedirectToAction("Login", "AdminUser"));
}
}
public void DeleteCDTest1()// Xoa doi tuong ton tai
{
ChuDe test = new ChuDe();
test.IdChuDe = 4;
Assert.AreEqual(true, dao.DeleteCDTestCase(test.IdChuDe));
}
public ViewResult XemChiTiet(int MaSach = 0)
{
Sach sach = db.Saches.SingleOrDefault(n => n.MaSach == MaSach);
if (sach == null)
{
//Trả về trang báo lỗi
Response.StatusCode = 404;
return(null);
}
ChuDe chuDe = db.ChuDes.Single(n => n.MaChuDe == sach.MaChuDe);
ViewBag.TenChuDe = chuDe.TenChuDe;
//ChuDe cd = db.ChuDes.Single(n => n.MaChuDe == sach.MaChuDe);
//ViewBag.TenCD = cd.TenChuDe;
//ViewBag.TenChuDe = db.ChuDes.Single(n => n.MaChuDe == sach.MaChuDe).TenChuDe;
NXB nXB = db.NXBs.Single(n => n.MaNXB == sach.MaNXB);
ViewBag.TenNhaXuatBan = nXB.TenNXB;
var list = (from s in db.SoHuus
where s.MaSach == MaSach
select s).ToList();
foreach (var item in list)
{
ViewBag.TenTacGia = db.TacGias.Single(n => n.MaTacGia == item.MaTacGia).TenTacGia;
}
return(View(sach));
}
public void UpdateCD(long idChuDe, ChuDe chuDe)
{
var cd = db.ChuDes.Find(idChuDe);
cd.Ten = chuDe.Ten;
cd.XuatXu = chuDe.XuatXu;
db.SaveChanges();
}
public void UpdateItem(ChuDe t)
{
using (IDataContext ctx = DataContext.Instance())
{
var rep = ctx.GetRepository <ChuDe>();
rep.Update(t);
}
}
public bool Delete(ChuDe entity)
{
var model = _context.ChuDes.Find(entity.Id);
_context.ChuDes.Remove(model);
_context.SaveChanges();
return(true);
}
public ActionResult DeleteConfirmed(int id)
{
ChuDe chuDe = db.ChuDes.Find(id);
db.ChuDes.Remove(chuDe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ChuDe c = new ChuDe();
rptData.DataSource = c.DanhSachChuDe();
rptData.DataBind();
}
}
public ActionResult ThemMoiChuDe(ChuDe chude)
{
if (ModelState.IsValid)
{
kn.ChuDes.Add(chude);
kn.SaveChanges();
}
return(View());
}
public ActionResult ChudeCreate(ChuDe cd)
{
if (cd.ten.Trim().ToString() != "")
{
_database.ChuDes.Add(cd);
_database.SaveChanges();
}
return(RedirectToAction("ChudeManager"));
}
public void InsertCDTest()
{
ChuDe test = new ChuDe();
test.Ten = "AAAAAAA";
test.XuatXu = "In";
test.flag = true;
Assert.AreEqual(true, dao.InsertCDTestCase(test, test.IdChuDe));
}
public ActionResult Edit([Bind(Include = "MaChuDe,TenChuDe")] ChuDe chuDe)
{
if (ModelState.IsValid)
{
db.Entry(chuDe).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chuDe));
}
public ActionResult ThemChuDe(ChuDe cd)
{
if (ModelState.IsValid)
{
db.ChuDes.Add(cd);
db.SaveChanges();
}
return(RedirectToAction("XemChuDe"));
}
public void UpdateCDTest()
{
ChuDe test = new ChuDe();
test.IdChuDe = 3;
test.Ten = "BBBBBBB";
test.XuatXu = "Out";
test.flag = true;
Assert.AreEqual(true, dao.UpdateCDTestCase(test, test.IdChuDe));
}
