public ActionResult SaveNewCategory(DanhMucTinTuc model)
{
JavaScriptSerializer js = new JavaScriptSerializer();
try
{
if (model.NewCategoryID == 0)
{
if (!ModelState.IsValid)
{
string fail = "Có lỗi xảy ra. Vui lòng kiểm tra lại!";
return(Json(new { status = false, failReason = js.Serialize(fail) }));
}
model.NgayTao = DateTime.Now;
newCategoryRepository.Save(model);
string addSuccess = "Thêm mới Danh Mục Tin Tức thành công!";
return(Json(new { status = true, success = js.Serialize(addSuccess) }));
}
if (!ModelState.IsValid)
{
string fail = "Có lỗi xảy ra. Vui lòng kiểm tra lại!";
return(Json(new { status = false, failReason = js.Serialize(fail) }));
}
newCategoryRepository.Save(model);
string updateSuccess = "Cập nhật Danh Mục Tin Tức thành công!";
return(Json(new { status = true, success = js.Serialize(updateSuccess) }));
}
catch (Exception ex)
{
string fail = ex.Message;
return(Json(new { status = false, failReason = js.Serialize(fail) }));
}
}
public void Save(DanhMucTinTuc NewCategory)
{
var saveNewCategory = GetById(NewCategory.NewCategoryID);
try {
if (saveNewCategory == null)
{
NewCategory.TrangThai = true;
NewCategory.NgayTao = DateTime.Now;
context.DanhMucTinTucs.Add(NewCategory);
}
else
{
saveNewCategory.Ten = NewCategory.Ten;
saveNewCategory.ThuTuHienThi = NewCategory.ThuTuHienThi;
saveNewCategory.NgayChinhSua = DateTime.Now;
saveNewCategory.NguoiChinhSua = NewCategory.NguoiChinhSua;
saveNewCategory.TrangThai = NewCategory.TrangThai;
saveNewCategory.ParentID = NewCategory.ParentID;
var model = context.TinTucs.Where(x => x.NewCategoryID == saveNewCategory.NewCategoryID).ToList();
foreach (var item in model)
{
item.TrangThai = NewCategory.TrangThai;
}
}
context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void Delete(DanhMucTinTuc NewCategory)
{
var deleteNew = GetById(NewCategory.NewCategoryID);
if (deleteNew != null)
{
deleteNew.TrangThai = false;
}
context.SaveChanges();
}
protected void submit_edit_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(hidden_id.Value);
DanhMucTinTuc cate = new DanhMucTinTuc();
cate.TenDanhMuc = txtTenDanhMuc_edit.Text;
cate.MoTa = txtMoTa_edit.Text;
cate.status = checkStatus_edit.Checked;;
obj.update(cate, id);
//load list
Response.Redirect(Request.Url.ToString());
}
public ActionResult Edit(DanhMucTinTuc model)
{
if (string.IsNullOrWhiteSpace(model.Ten))
{
ModelState.AddModelError("", "Vui lòng nhập tên danh mục");
}
if (ModelState.IsValid)
{
model.NguoiChinhSua = User.Identity.GetUserName();
newCategoryRepository.Save(model);
return(RedirectToAction("Index"));
}
return(View());
}
public void Delete(DanhMucTinTuc NewCategory)
{
try
{
var delete = context.DanhMucTinTucs.FirstOrDefault(x => x.NewCategoryID == NewCategory.NewCategoryID);
if (delete != null)
{
var listParentId = context.DanhMucTinTucs.Select(x => x.ParentID).ToList();
var check = true;
if (NewCategory.NewCategoryID == 10014 || NewCategory.NewCategoryID == 10015 || NewCategory.NewCategoryID == 8)
{
check = false;
}
foreach (var parentId in listParentId)
{
if (parentId == NewCategory.NewCategoryID)
{
check = false;
}
}
if (check == false)
{
throw new Exception("Bạn Không Thể Xóa Danh Mục Cha");
}
context.DanhMucTinTucs.Remove(delete);
}
context.SaveChanges();
}
catch (DbUpdateException ex)
{
var sqlex = ex.InnerException.InnerException as SqlException;
if (sqlex != null)
{
switch (sqlex.Number)
{
case 547: throw new Exception("Xóa Thất Bại - Danh Mục Đang Được Sử Dụng Ở Chức Năng Khác !"); //FK exception
case 2627:
case 2601:
throw new Exception("Lỗi Khóa Chính"); //primary key exception
default: throw sqlex; //otra excepcion que no controlo.
}
}
throw ex;
}
}
public void Save(DanhMucTinTuc NewCategory)
{
var saveNewCategory = GetById(NewCategory.NewCategoryID);
if (saveNewCategory == null)
{
NewCategory.TrangThai = true;
NewCategory.NgayTao = DateTime.Now;
context.DanhMucTinTucs.Add(NewCategory);
}
else
{
saveNewCategory.Ten = NewCategory.Ten;
saveNewCategory.ThuTuHienThi = NewCategory.ThuTuHienThi;
}
context.SaveChanges();
}
protected void submit_create_Click(object sender, EventArgs e)
{
//kiem tra trong
if (txtMoTa_create.Text == "" || txtTenDanhMuc_create.Text == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "vanh", "blank()", true);
return;
}
//them
DanhMucTinTuc cate = new DanhMucTinTuc();
cate.TenDanhMuc = txtTenDanhMuc_create.Text;
cate.MoTa = txtMoTa_create.Text;
/*cate.status = true;
* if (!checkStatus_create.Checked) cate.status = false;*/
cate.status = checkStatus_create.Checked;
cate.created_at = DateTime.Now;
obj.create(cate);
//load list
Response.Redirect(Request.Url.ToString());
}
public void update(DanhMucTinTuc c, int id)
{
string sql = "update tbl_DanhMucTinTuc set TenDanhMuc = N'" + c.TenDanhMuc + "', MoTa = N'" + c.MoTa + "', status = '" + c.status + "' where id = '" + id + "'";
obj.ExecuteNonQuery(sql);
}
public void create(DanhMucTinTuc c)
{
string sql = "insert tbl_DanhMucTinTuc values(N'" + c.TenDanhMuc + "' , N'" + c.MoTa + "', '" + c.status + "', '" + c.created_at + "' )";
obj.ExecuteNonQuery(sql);
}
