public void BirAltMenuSayfaLinkGuncelleSayfaNewItem(BirAltMenuler birAltMenu)
{
using (var db = new ContextDataModel())
{
db.BirAltMenuler.Attach(birAltMenu);
db.Entry(birAltMenu).Property(x => x.SayfaId).IsModified = true;
db.SaveChanges();
}
}
public void BirMenuSiraNoGuncelle(BirAltMenuler menu)
{
using (var db = new ContextDataModel())
{
db.BirAltMenuler.Attach(menu);
db.Entry(menu).Property(x => x.BirAltMenuSiraNo).IsModified = true;
db.SaveChanges();
}
}
public void BirAltMenuGuncelle(BirAltMenuler birAltMenu)
{
using (var db = new ContextDataModel())
{
db.BirAltMenuler.Attach(birAltMenu);
db.Entry(birAltMenu).Property(x => x.BirAltMenuAdi).IsModified = true;
db.Entry(birAltMenu).Property(x => x.LinkAdres).IsModified = true;
db.Entry(birAltMenu).Property(x => x.MenuId).IsModified = true;
db.Entry(birAltMenu).Property(x => x.UstKategoriId).IsModified = true;
db.Entry(birAltMenu).Property(x => x.SayfaId).IsModified = true;
db.Entry(birAltMenu).Property(x => x.SeoLink).IsModified = true;
db.SaveChanges();
};
}
public void BirAltMenuSiraNoGuncelleDeleteIsleminde(int SiraNo, int MenuId, int AltMenuId)
{
var query = (from l in _context.BirAltMenuler where l.BirAltMenuSiraNo == SiraNo && l.MenuId == MenuId && l.AltMenuId == AltMenuId select l).FirstOrDefault();
SiraNo = SiraNo - 1;
BirAltMenuler menu = new BirAltMenuler()
{
BirAltMenuAdi = query.BirAltMenuAdi,
MenuId = query.MenuId,
BirAltMenuSiraNo = SiraNo,
AltMenuId = query.AltMenuId,
BirAltMenuId = query.BirAltMenuId
};
ContextDataModel db = new ContextDataModel();
db.BirAltMenuler.Attach(menu);
db.Entry(menu).Property(x => x.BirAltMenuSiraNo).IsModified = true;
db.SaveChanges();
}
public BirAltMenuler BirAltMenuSiraBul(int BirAltMenuId)
{
var query = (from m in _context.Menuler
join n in _context.AltMenuler
on m.MenuId equals n.MenuId
from biralt in _context.BirAltMenuler
where biralt.MenuId == m.MenuId && biralt.AltMenuId == n.AltMenuId && biralt.BirAltMenuId == BirAltMenuId
select new { biralt.BirAltMenuSiraNo, biralt.AltMenuId, biralt.MenuId, biralt.BirAltMenuId }).First();
BirAltMenuler alt = new BirAltMenuler
{
BirAltMenuSiraNo = query.BirAltMenuSiraNo,
MenuId = query.MenuId,
AltMenuId = query.AltMenuId,
BirAltMenuId = query.BirAltMenuId
};
return(alt);
}
