public void AltMenuSayfaLinkGuncelleSayfaNewItem(AltSolMenuler altMenu)
{
using (var db = new ContextDataModel())
{
db.AltSolMenuler.Attach(altMenu);
db.Entry(altMenu).Property(x => x.SayfaId).IsModified = true;
db.SaveChanges();
}
}
public void SolMenuSiraNoGuncelle(AltSolMenuler menu)
{
using (var db = new ContextDataModel())
{
db.AltSolMenuler.Attach(menu);
db.Entry(menu).Property(x => x.AltSolMenuSiraNo).IsModified = true;
db.SaveChanges();
}
}
public AltSolMenuler AltSolMenuSiraBul(int AltSolMenuId)
{
var query = (from m in _context.SolMenu
join n in _context.AltSolMenuler
on m.SolMenuId equals n.SolMenuId
where n.AltSolMenuId == AltSolMenuId
select new { n.AltSolMenuSiraNo, m.SolMenuId }).FirstOrDefault();
AltSolMenuler alt = new AltSolMenuler
{
AltSolMenuSiraNo = query.AltSolMenuSiraNo,
SolMenuId = query.SolMenuId
};
return(alt);
}
public void AltSolMenuGuncelle(AltSolMenuler altmenu)
{
using (var db = new ContextDataModel())
{
db.AltSolMenuler.Attach(altmenu);
db.Entry(altmenu).Property(x => x.AltSolMenuAdi).IsModified = true;
db.Entry(altmenu).Property(x => x.LinkAdres).IsModified = true;
db.Entry(altmenu).Property(x => x.SolMenuId).IsModified = true;
db.Entry(altmenu).Property(x => x.UstKategoriId).IsModified = true;
db.Entry(altmenu).Property(x => x.SayfaId).IsModified = true;
db.SaveChanges();
};
}
public void AltSolMenuSiraNoGuncelleDeleteIsleminde(int SiraNo, int SolMenuId)
{
var query = (from l in _context.AltSolMenuler where l.AltSolMenuSiraNo == SiraNo && l.SolMenuId == SolMenuId select l).FirstOrDefault();
SiraNo = SiraNo - 1;
AltSolMenuler menu = new AltSolMenuler()
{
AltSolMenuAdi = query.AltSolMenuAdi,
SolMenuId = query.SolMenuId,
AltSolMenuSiraNo = SiraNo,
AltSolMenuId = query.AltSolMenuId
};
ContextDataModel db = new ContextDataModel();
db.AltSolMenuler.Attach(menu);
db.Entry(menu).Property(x => x.AltSolMenuSiraNo).IsModified = true;
db.SaveChanges();
}