public ActionResult LayChuyenMuc(int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
JsonSerializerSettings jss = new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
ChuyenMuc cm = shop.ChuyenMucs.SingleOrDefault(c => c.MaChuyenMuc == id);
var result = JsonConvert.SerializeObject(cm, Formatting.Indented, jss);
return(this.Json(result, JsonRequestBehavior.AllowGet));;
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
if (id > 0)
{
//cap nhat
ChuyenMuc cm = new ChuyenMuc();
cm.id = id;
cm.tenCM = tenCM.Text;
cm.moTa = moTa.Text;
cm.tuKhoa = tuKhoa.Text;
cm.idCha = Convert.ToInt32(ddCha.Text);
data.SuaChuyenMuc(cm);
Response.Redirect("ChuyenMuc.aspx");
}
else
{
//them moi
ChuyenMuc cm = new ChuyenMuc();
cm.tenCM = tenCM.Text;
cm.moTa = moTa.Text;
cm.tuKhoa = tuKhoa.Text;
cm.idCha = Convert.ToInt32(ddCha.Text);
data.ThemChuyenMuc(cm);
Response.Redirect("ChuyenMuc.aspx");
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
if (id > 0)
{
//cap nhat
ChuyenMuc cm = new ChuyenMuc();
cm.id = id;
cm.tenCM = tenCM.Text;
cm.moTa = moTa.Text;
cm.tuKhoa = tuKhoa.Text;
cm.idCha = Convert.ToInt32(ddCha.Text);
data.SuaChuyenMuc(cm);
Response.Redirect("ChuyenMuc.aspx");
}
else
{
//them moi
ChuyenMuc cm = new ChuyenMuc();
cm.tenCM = tenCM.Text;
cm.moTa = moTa.Text;
cm.tuKhoa = tuKhoa.Text;
cm.idCha = Convert.ToInt32(ddCha.Text);
data.ThemChuyenMuc(cm);
Response.Redirect("ChuyenMuc.aspx");
}
}
catch (Exception ex)
{
Response.Write("<script>alert(" + ex.Message + ");</script>");
}
}
public HttpResponseMessage Delete(HttpRequestMessage request, int id)
{
ChuyenMuc modelChuyenMuc = null;
try
{
var listBaiViet = _baiVietService.BaiVietWithIdChuyenMuc(id);
foreach (var item in listBaiViet)
{
var listBinhLuan = _binhLuanService.BinhLuanWithIdBaiViet(id);
foreach (var item2 in listBinhLuan)
{
_binhLuanService.Delete(item2.IdBinhLuan);
}
_chuyenMucService.SaveChange();
_baiVietService.Delete(item.IdBaiViet);
}
_chuyenMucService.SaveChange();
modelChuyenMuc = _chuyenMucService.Delete(id);
_chuyenMucService.SaveChange();
if (modelChuyenMuc != null)
{
Message = "Xóa chuyên mục thành công";
}
else
{
throw new DbEntityValidationException("Xóa chuyên mục không thành công");
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, modelChuyenMuc));
}
protected void btnThem_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
if (id > 0)
{
//cap nhat
ChuyenMuc cm = new ChuyenMuc();
cm.id = id;
cm.tenCM = tenCM.Text;
cm.moTa = moTa.Text;
cm.tuKhoa = tuKhoa.Text;
cm.idCha = Convert.ToInt32(ddCha.Text);
data.SuaChuyenMuc(cm);
Response.Redirect("ChuyenMuc.aspx");
}
else
{
//them moi
ChuyenMuc cm = new ChuyenMuc();
cm.tenCM = tenCM.Text;
cm.moTa = moTa.Text;
cm.tuKhoa = tuKhoa.Text;
cm.idCha = Convert.ToInt32(ddCha.Text);
data.ThemChuyenMuc(cm);
Response.Redirect("ChuyenMuc.aspx");
}
}
public HttpResponseMessage KhoaMo(HttpRequestMessage request, int id)
{
ChuyenMuc modelChuyenMuc = null;
try
{
_chuyenMucService.KhoaMo(id);
_chuyenMucService.SaveChange();
modelChuyenMuc = _chuyenMucService.GetById(id);
if (modelChuyenMuc != null)
{
if (modelChuyenMuc.TrangThai != null && (bool)modelChuyenMuc.TrangThai)
{
Message = "Mở chuyên mục thành công";
}
else
{
Message = "Khóa chuyên mục thành công";
}
}
else
{
throw new DbEntityValidationException("Khóa mở chuyên mục không thành công");
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, modelChuyenMuc));
}
protected void btnSaveChanges_Click(object sender, EventArgs e)
{
if (Request.QueryString["Action"] == "Edit")
{
int maChuyenMuc = Convert.ToInt32(txtMaChuyenMuc.Text);
ChuyenMuc obj = new ChuyenMuc(maChuyenMuc, txtTenChuyenMuc.Text);
XuLyChuyenMuc xl = new XuLyChuyenMuc();
int result = xl.SuaChuyenMuc(obj);
if (result <= 0)
{
lblError.ForeColor = Color.Red;
lblError.Text = "Sửa chuyên mục không thành công. Vui lòng kiểm tra lại dữ liệu";
}
else
{
lblError.ForeColor = Color.Blue;
lblError.Text = "Sửa dữ liệu thành công";
}
LoadChuyenMuc();
}
else
{
btnSave_Click(sender, e);
}
}
public ActionResult XoaChuyenMuc(int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
var model = new QuanLyChuyenMuc()
{
DanhSachChuyenMuc = KhoiTao("", 1)
};
ChuyenMuc cm = shop.ChuyenMucs.SingleOrDefault(c => c.MaChuyenMuc == id);
var dsSanPham = shop.SanPhams.Where(s => s.MaChuyenMuc == id);
foreach (var item in dsSanPham)
{
shop.SanPhams.Remove(item);
shop.SaveChanges();
}
shop.ChuyenMucs.Remove(cm);
shop.SaveChanges();
return(RedirectToAction("Index", model));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
public int ThemChuyenMuc(ChuyenMuc obj)
{
SqlParameter mcm = new SqlParameter("@idCategoryFood", obj.MaChuyenMuc);
SqlParameter tcm = new SqlParameter("@Name", obj.TenChuyenMuc);
SqlParameter[] sqlParams = { mcm, tcm };
return(dl.SaveChanges("INSERT INTO [dbo].[FoodCategory]([idCategoryFood],[Name]) VALUES(@idCategoryFood,@Name)", sqlParams));
}
public int SuaChuyenMuc(ChuyenMuc obj)
{
SqlParameter mcm = new SqlParameter("@idCategoryFood", obj.MaChuyenMuc);
SqlParameter tcm = new SqlParameter("@Name", obj.TenChuyenMuc);
SqlParameter[] sqlParams = { mcm, tcm };
return(dl.SaveChanges("UPDATE FoodCategory SET Name = @Name,idCategoryFood = @idCategoryFood", sqlParams));
}
public ActionResult LaySanPham(int id)
{
ShopEntities shop = new ShopEntities();
ChuyenMuc cm = shop.ChuyenMucs.SingleOrDefault(s => s.MaChuyenMuc == id);
ViewBag.TenChuyenMuc = cm.TenChuyenMuc;
ViewData["DanhSachChuyenMuc"] = shop.ChuyenMucs.Where(c => c.MaChuyenMucCha == cm.MaChuyenMucCha).ToList();
ViewData["DanhSachSanPham"] = shop.SanPhams.Where(s => s.MaChuyenMuc == id).ToList();
return(View("Index"));
}
public ActionResult ThemChuyenMucChinh(QuanLyChuyenMuc qlcm, string submit, int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
var model = new QuanLyChuyenMuc()
{
DanhSachChuyenMuc = KhoiTao("", 1)
};
if (submit == "Thêm")
{
ChuyenMuc cm = new ChuyenMuc();
cm.TenChuyenMuc = qlcm.ChuyenMuc.TenChuyenMuc;
cm.MaChuyenMucCha = qlcm.ChuyenMuc.MaChuyenMucCha;
cm.DacBiet = qlcm.ChuyenMuc.DacBiet;
if (qlcm.ChuyenMuc.DacBiet)
{
cm.NoiDung = qlcm.ChuyenMuc.NoiDung;
}
shop.ChuyenMucs.Add(cm);
shop.SaveChanges();
}
if (submit == "Sửa")
{
ChuyenMuc cm = shop.ChuyenMucs.SingleOrDefault(c => c.MaChuyenMuc == id);
cm.TenChuyenMuc = qlcm.ChuyenMuc.TenChuyenMuc;
cm.MaChuyenMucCha = qlcm.ChuyenMuc.MaChuyenMucCha;
cm.DacBiet = qlcm.ChuyenMuc.DacBiet;
if (qlcm.ChuyenMuc.DacBiet)
{
cm.NoiDung = qlcm.ChuyenMuc.NoiDung;
}
shop.SaveChanges();
}
return(RedirectToAction("Index", model));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int maChuyenMuc = Convert.ToInt32(txtMaChuyenMuc.Text);
ChuyenMuc obj = new ChuyenMuc(maChuyenMuc, txtTenChuyenMuc.Text);
XuLyChuyenMuc xl = new XuLyChuyenMuc();
int result = xl.ThemChuyenMuc(obj);
if (result <= 0)
{
lblError.ForeColor = Color.Red;
lblError.Text = "Thêm chuyên mục không thành công. Vui lòng kiểm tra lại dữ liệu";
}
else
{
lblError.ForeColor = Color.Blue;
lblError.Text = "Thêm dữ liệu thành công";
LoadChuyenMuc();
}
}
//chuyen muc
public ChuyenMuc GetAChuyenMuc(int id)
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM tblChuyenMuc WHERE id=@id";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader rd = cmd.ExecuteReader();
ChuyenMuc cm = new ChuyenMuc();
if (rd.Read())
{
cm.id = Convert.ToInt32(rd["id"]);
cm.tenCM = Convert.ToString(rd["tenCM"]);
cm.moTa = Convert.ToString(rd["moTa"]);
cm.tuKhoa = Convert.ToString(rd["tuKhoa"]);
cm.idCha = Convert.ToInt32(rd["idCha"]);
}
con.Close();
return cm;
}
public void ThemChuyenMuc(ChuyenMuc cm)
{
string sql = "INSERT INTO tblChuyenMuc(tenCM, moTa, tuKhoa,idCha) VALUES (@tenCM, @moTa, @tuKhoa,@idCha)";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@idCha", cm.idCha);
cmd.Parameters.Add("@tenCM", SqlDbType.NText);
cmd.Parameters["@tenCM"].Value = cm.tenCM;
cmd.Parameters.Add("@moTa", SqlDbType.NText);
cmd.Parameters["@moTa"].Value = cm.moTa;
cmd.Parameters.Add("@tuKhoa", SqlDbType.NText);
cmd.Parameters["@tuKhoa"].Value = cm.tuKhoa;
cmd.ExecuteNonQuery();
con.Close();
}
//chuyen muc
public ChuyenMuc GetAChuyenMuc(int id)
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM tblChuyenMuc WHERE id=@id";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader rd = cmd.ExecuteReader();
ChuyenMuc cm = new ChuyenMuc();
if (rd.Read())
{
cm.id = Convert.ToInt32(rd["id"]);
cm.tenCM = Convert.ToString(rd["tenCM"]);
cm.moTa = Convert.ToString(rd["moTa"]);
cm.tuKhoa = Convert.ToString(rd["tuKhoa"]);
cm.idCha = Convert.ToInt32(rd["idCha"]);
}
con.Close();
return(cm);
}
public void SuaChuyenMuc(ChuyenMuc cm)
{
string sql = "Update tblChuyenMuc set tenCM=@tenCM, moTa=@moTa, tuKhoa=@tuKhoa,idCha=@idCha WHERE id=@id";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@id", cm.id);
cmd.Parameters.AddWithValue("@idCha", cm.idCha);
cmd.Parameters.Add("@tenCM", SqlDbType.NText);
cmd.Parameters["@tenCM"].Value = cm.tenCM;
cmd.Parameters.Add("@moTa", SqlDbType.NText);
cmd.Parameters["@moTa"].Value = cm.moTa;
cmd.Parameters.Add("@tuKhoa", SqlDbType.NText);
cmd.Parameters["@tuKhoa"].Value = cm.tuKhoa;
cmd.ExecuteNonQuery();
con.Close();
}
public HttpResponseMessage GetById(HttpRequestMessage request, int id)
{
ChuyenMuc chuyenMucSingler = null;
try
{
chuyenMucSingler = _chuyenMucService.GetById(id);
if (chuyenMucSingler != null)
{
Message = "Thông tin chuyên mục với id: " + id;
}
else
{
throw new DbEntityValidationException(string.Format("Không tìm kiếm được chuyên mục với id {0}", id));
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, chuyenMucSingler));
}
public HttpResponseMessage Create(HttpRequestMessage request, ChuyenMuc chuyenMuc)
{
ChuyenMuc modelChuyenMuc = null;
try
{
modelChuyenMuc = _chuyenMucService.Add(chuyenMuc);
if (modelChuyenMuc != null)
{
Message = "Tạo mới chuyên mục thành công";
_chuyenMucService.SaveChange();
}
else
{
throw new DbEntityValidationException("tạo mới chuyên mục không thành công");
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, modelChuyenMuc));
}
protected void btnSave_Click(object sender, EventArgs e)
{
int trangThai = 1;
if (chkTrangThai.Checked == false)
{
trangThai = 0;
}
ChuyenMuc obj = new ChuyenMuc(txtTenChuyenMuc.Text, txtMoTa.Text, trangThai);
XuLyChuyenMuc xl = new XuLyChuyenMuc();
int result = xl.ThemChuyenMuc(obj);
if (result <= 0)
{
lblError.ForeColor = Color.Red;
lblError.Text = "Thêm chuyên mục không thành công. Vui lòng kiểm tra lại dữ liệu";
}
else
{
lblError.ForeColor = Color.Blue;
lblError.Text = "Thêm dữ liệu thành công";
LoadChuyenMuc();
}
}
public HttpResponseMessage Update(HttpRequestMessage request, ChuyenMuc chuyenMuc)
{
ChuyenMuc modelChuyenMuc = null;
try
{
_chuyenMucService.Update(chuyenMuc);
_chuyenMucService.SaveChange();
modelChuyenMuc = _chuyenMucService.GetById(chuyenMuc.IdChuyenMuc);
if (modelChuyenMuc != null)
{
Message = "Sửa thông tin chuyên mục thành công";
}
else
{
throw new DbEntityValidationException("sửa thông tin chuyên mục không thành công");
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, modelChuyenMuc));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddCha.DataSource = data.GetAllChuyenMuc();
ddCha.DataTextField = "tenCM";
ddCha.DataValueField = "id";
ddCha.DataBind();
FillData();
ListItem lst = new ListItem("===>Không<===", "0");
ddCha.Items.Insert(0, lst);
int id = Convert.ToInt32(Request.QueryString["id"]);
if (id > 0)
{
ChuyenMuc cm = new ChuyenMuc();
//get cm
cm = data.GetAChuyenMuc(id);
tenCM.Text = cm.tenCM;
moTa.Text = cm.moTa;
tuKhoa.Text = cm.tuKhoa;
ddCha.Text = cm.idCha.ToString();
}
}
}
public void ThemChuyenMuc(ChuyenMuc cm)
{
string sql = "INSERT INTO tblChuyenMuc(tenCM, moTa, tuKhoa,idCha) VALUES (@tenCM, @moTa, @tuKhoa,@idCha)";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@idCha", cm.idCha);
cmd.Parameters.Add("@tenCM", SqlDbType.NText);
cmd.Parameters["@tenCM"].Value = cm.tenCM;
cmd.Parameters.Add("@moTa", SqlDbType.NText);
cmd.Parameters["@moTa"].Value = cm.moTa;
cmd.Parameters.Add("@tuKhoa", SqlDbType.NText);
cmd.Parameters["@tuKhoa"].Value = cm.tuKhoa;
cmd.ExecuteNonQuery();
con.Close();
}
public void SuaChuyenMuc(ChuyenMuc cm)
{
string sql = "Update tblChuyenMuc set tenCM=@tenCM, moTa=@moTa, tuKhoa=@tuKhoa,idCha=@idCha WHERE id=@id" ;
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@id", cm.id);
cmd.Parameters.AddWithValue("@idCha", cm.idCha);
cmd.Parameters.Add("@tenCM", SqlDbType.NText);
cmd.Parameters["@tenCM"].Value = cm.tenCM;
cmd.Parameters.Add("@moTa", SqlDbType.NText);
cmd.Parameters["@moTa"].Value = cm.moTa;
cmd.Parameters.Add("@tuKhoa", SqlDbType.NText);
cmd.Parameters["@tuKhoa"].Value = cm.tuKhoa;
cmd.ExecuteNonQuery();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddCha.DataSource = data.GetAllChuyenMuc();
ddCha.DataTextField = "tenCM";
ddCha.DataValueField = "id";
ddCha.DataBind();
FillData();
ListItem lst = new ListItem("===>Không<===", "0");
ddCha.Items.Insert(0, lst);
int id = Convert.ToInt32(Request.QueryString["id"]);
if (id > 0)
{
ChuyenMuc cm = new ChuyenMuc();
//get cm
cm = data.GetAChuyenMuc(id);
tenCM.Text = cm.tenCM;
moTa.Text = cm.moTa;
tuKhoa.Text = cm.tuKhoa;
ddCha.Text = cm.idCha.ToString();
}
}
}
