public InventioNavigationNode Read(int id)
{
InventioNavigationNode ret = new InventioNavigationNode();
using (InventioEntities context = new InventioEntities())
{
Navigation selected = context.Navigation.Where <Navigation>(s => s.Id == id).FirstOrDefault <Navigation>();
if (selected != null)
{
ret = InventioAdapter(selected);
ret.ChildNodes = ReadChilds(selected.Id);
//// Hijos
if (ret.ChildNodes != null && ret.ChildNodes.Count > 0)
{
for (int i = 0; i < ret.ChildNodes.Count; i++)
{
ret.ChildNodes[i] = Read(ret.ChildNodes[i].Id);
}
}
}
}
return(ret);
}
public void Update(InventioNavigationNode node)
{
Navigation data = EFAdapter(node);
using (InventioEntities context = new InventioEntities())
{
context.Navigation.Attach(data);
context.Entry(data).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Update(InventioPage page)
{
Pages data = EFAdapter(page);
using (InventioEntities context = new InventioEntities())
{
context.Pages.Attach(data);
context.Entry(data).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Delete(int Id)
{
using (InventioEntities context = new InventioEntities())
{
Navigation selected = context.Navigation.FirstOrDefault <Navigation>(n => n.Id == Id);
if (selected != null)
{
context.Navigation.Attach(selected);
context.Navigation.Remove(selected);
context.SaveChanges();
}
}
}
public void Delete(int Id)
{
using (InventioEntities context = new InventioEntities())
{
Pages selected = context.Pages.FirstOrDefault <Pages>(p => p.Id == Id);
if (selected != null)
{
context.Pages.Attach(selected);
context.Pages.Remove(selected);
context.SaveChanges();
}
}
}
public void Update(InventioLayout layout)
{
// TODO REVISAR NO TESTEADO
Layouts data = EFAdapter(layout);
using (InventioEntities context = new InventioEntities())
{
context.Layouts.Attach(data);
context.Entry(data).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Delete(int Id)
{
using (InventioEntities context = new InventioEntities())
{
Layouts selected = context.Layouts.FirstOrDefault <Layouts>(l => l.Id == Id);
if (selected != null)
{
context.Layouts.Attach(selected);
context.Layouts.Remove(selected);
context.SaveChanges();
}
}
}
public InventioLayout Read(int id)
{
InventioLayout ret = new InventioLayout();
using (InventioEntities context = new InventioEntities())
{
Layouts selected = context.Layouts.Where <Layouts>(s => s.Id == id).FirstOrDefault <Layouts>();
if (selected != null)
{
ret = InventioAdapter(selected);
}
}
return(ret);
}
public Nullable <int> Create(InventioLayout layout)
{
Nullable <int> ret = null;
Layouts data = EFAdapter(layout);
using (InventioEntities context = new InventioEntities())
{
context.Layouts.Add(data);
context.SaveChanges();
ret = data.Id;
}
return(ret);
}
public InventioPage SelectByPath(string path)
{
InventioPage ret = null;
using (InventioEntities context = new InventioEntities())
{
Pages selected = context.Pages.FirstOrDefault <Pages>(p => p.Path.ToLower() == path.ToLower());
if (selected != null)
{
ret = InventioAdapter(selected);
}
}
return(ret);
}
public Nullable <int> Create(InventioNavigationNode node)
{
Nullable <int> ret = null;
Navigation data = EFAdapter(node);
using (InventioEntities context = new InventioEntities())
{
context.Navigation.Add(data);
context.SaveChanges();
ret = data.Id;
}
return(ret);
}
public InventioPage Read(int id)
{
InventioPage ret = new InventioPage();
using (InventioEntities context = new InventioEntities())
{
Pages selected = context.Pages.Where <Pages>(p => p.Id == id).FirstOrDefault <Pages>();
if (selected != null)
{
ret = InventioAdapter(selected);
}
}
return(ret);
}
public Nullable <int> Create(InventioPage page)
{
Nullable <int> ret = null;
// TODO CHECK PATH no existe ya !!!!
Pages data = EFAdapter(page);
using (InventioEntities context = new InventioEntities())
{
context.Pages.Add(data);
context.SaveChanges();
ret = data.Id;
}
return(ret);
}
public InventioNavigationNode SelectByPath(string path)
{
InventioNavigationNode ret = null;
if (!string.IsNullOrWhiteSpace(path))
{
using (InventioEntities context = new InventioEntities())
{
Navigation selected = context.Navigation.FirstOrDefault <Navigation>(n => n.Path.ToLower() == path.ToLower());
if (selected != null)
{
ret = Read(selected.Id);
}
}
}
return(ret);
}
public InventioLayout SelectByTitle(string title)
{
InventioLayout ret = null;
if (!string.IsNullOrWhiteSpace(title))
{
using (InventioEntities context = new InventioEntities())
{
Layouts selected = context.Layouts.Where <Layouts>(s => s.Title.ToLower() == title.ToLower()).FirstOrDefault <Layouts>();
if (selected != null)
{
ret = InventioAdapter(selected);
}
}
}
return(ret);
}
public List <InventioNavigationNode> ReadChilds(Nullable <int> ParentId)
{
List <InventioNavigationNode> ret = null;
using (InventioEntities context = new InventioEntities())
{
List <Navigation> selected = context.Navigation.Where <Navigation>(s => s.ParentId == ParentId).ToList <Navigation>();
if (selected != null && selected.Count > 0)
{
ret = new List <InventioNavigationNode>();
foreach (Navigation child in selected)
{
ret.Add(InventioAdapter(child));
}
}
}
return(ret);
}
public List <InventioLayout> SelectAll()
{
List <InventioLayout> ret = null;
using (InventioEntities context = new InventioEntities())
{
if (context.Layouts != null && context.Layouts.Count() > 0)
{
ret = new List <InventioLayout>();
foreach (Layouts layout in context.Layouts)
{
InventioLayout newlayout = InventioAdapter(layout);
if (newlayout != null)
{
ret.Add(newlayout);
}
}
}
}
return(ret);
}
