public ActionResult Update_HieuLuc_Cha(string sMaDMC, string sHienThi) { int madm = int.Parse(sMaDMC); bool hienthi = (sHienThi == "true" ? true : false); DanhMucCha dmc = db.DanhMucChas.SingleOrDefault(r => r.MaDMC == madm); if (dmc != null) { dmc.HienThi = hienthi; } db.SaveChanges(); return(Json(0, JsonRequestBehavior.AllowGet)); }
public ActionResult INSERT_UPDATE_DANHMUC(string sLOAI, string sMADMCHA, string sTENMDC, string sSITE, string sHIENTHI, string sSTT, string sLID, string sMaDMCon, string Bien) { int smdmc = int.Parse(sMADMCHA); if (sLOAI == "dmcha") { string cssClassCha = "menu-icon fa fa-th"; DanhMucCha dmc = db.DanhMucChas.SingleOrDefault(r => r.MaDMC == smdmc); if (dmc != null) { dmc.ThuTu = int.Parse(sSTT); dmc.HienThi = (sHIENTHI == "true" ? true : false); DanhMucChaCT dmcCT = db.DanhMucChaCTs.SingleOrDefault(r => r.MaDMC == smdmc && r.LID.Equals(sLID)); if (dmcCT != null) { dmcCT.TenDMC = sTENMDC; } else { dmcCT = new DanhMucChaCT(); dmcCT.MaDMC = smdmc; dmcCT.LID = sLID; dmcCT.TenDMC = sTENMDC; db.DanhMucChaCTs.Add(dmcCT); } } else { int madmcha = 0, madmcha_old = 0; if (Bien == "0") { madmcha = db.DanhMucChas.Select(x => x.MaDMC).DefaultIfEmpty(0).Max() + 1; dmc = new DanhMucCha(); dmc.MaDMC = madmcha; dmc.CssClass = cssClassCha; dmc.ThuTu = int.Parse(sSTT); dmc.HienThi = (sHIENTHI == "true" ? true : false); db.DanhMucChas.Add(dmc); } else { madmcha_old = db.DanhMucChas.Select(x => x.MaDMC).DefaultIfEmpty(0).Max(); } DanhMucChaCT dmcCT = db.DanhMucChaCTs.SingleOrDefault(r => r.MaDMC == (Bien == "0" ? madmcha : madmcha_old) && r.LID.Equals(sLID)); if (dmcCT != null) { dmcCT.TenDMC = sTENMDC; } else { dmcCT = new DanhMucChaCT(); dmcCT.MaDMC = (Bien == "0" ? madmcha : madmcha_old); dmcCT.LID = sLID; dmcCT.TenDMC = sTENMDC; db.DanhMucChaCTs.Add(dmcCT); } } } else if (sLOAI == "dmcon") { int smdmcon = int.Parse(sMaDMCon); string cssclassCon = "fm-user-secret"; DanhMuc dm = db.DanhMucs.SingleOrDefault(a => a.MaDM == smdmcon); if (dm != null) { dm.Site = sSITE; dm.ThuTu = int.Parse(sSTT); dm.HienThi = (sHIENTHI == "true" ? true : false); DanhMucCT dmCT = db.DanhMucCTs.SingleOrDefault(a => a.MaDM == smdmcon && a.LID.Equals(sLID)); if (dmCT != null) { dmCT.TenDM = sTENMDC; } else { dmCT = new DanhMucCT(); dmCT.MaDM = smdmcon; db.DanhMucCTs.Add(dmCT); } } else { int mdm = 0, madm_old = 0; if (Bien == "0") { mdm = db.DanhMucs.Select(a => a.MaDM).DefaultIfEmpty(0).Max() + 1; dm = new DanhMuc(); dm.MaDM = mdm; dm.MaDMC = smdmc; dm.Site = sSITE; dm.ThuTu = int.Parse(sSTT); dm.HienThi = (sHIENTHI == "true" ? true : false); dm.Icon = cssclassCon; db.DanhMucs.Add(dm); } else { madm_old = db.DanhMucs.Select(a => a.MaDM).DefaultIfEmpty(0).Max(); } DanhMucCT dmCT = db.DanhMucCTs.SingleOrDefault(a => a.MaDM == (Bien == "0" ? mdm : madm_old) && a.LID.Equals(sLID)); if (dmCT != null) { dmCT.TenDM = sTENMDC; } else { dmCT = new DanhMucCT(); dmCT.MaDM = (Bien == "0" ? mdm : madm_old); dmCT.TenDM = sTENMDC; dmCT.LID = sLID; db.DanhMucCTs.Add(dmCT); } } } db.SaveChanges(); return(Json("ins", JsonRequestBehavior.AllowGet));//Insert DMC }