public Entidades.Helpers.Paginado SelectAll(int skip, int take)
{
try
{
var data = new Entidades.Helpers.Paginado();
List<Entidades.Helpers.Tablas> t = new List<Entidades.Helpers.Tablas>();
using (var context = new BarandillasEntities())
{
var query = (from p in context.Tablas_BD where p.Estatus == true
orderby p.TablaID
select p)
.Skip(skip)
.Take(take)
.ToList();
foreach (var i in query)
{
t.Add(new Entidades.Helpers.Tablas { TablaID = i.TablaID, NombreTabla = i.Nombre, Descripcion = i.Descripcion, TipoTabla = i.TipoTabla, Estatus = i.Estatus });
}
data.Customers = t;
data.TotalRecords = (from p in context.Tablas_BD
select p).Count();
return data;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List<int> tablasRelacionadas(int id)
{
try
{
List<int> data = new List<int>();
using (var context = new BarandillasEntities())
{
var query = (from i in context.RelacionesDeTablas
where i.TablaID == id
select i.TablaRelacionada).ToList();
if (query.Count > 0)
{
foreach (var i in query)
{
data.Add(i);
}
}
else
{
data.Add(0);
}
return data;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List<Tuple<int, string>> selectTables()
{
try
{
List<Tuple<int, string>> tablas = new List<Tuple<int, string>>();
using(var context = new BarandillasEntities())
{
var query = (from t in context.Tablas_BD
orderby t.TablaID
select new
{
ID = t.TablaID,
Nombretabla = t.Nombre
}).ToList();
foreach(var i in query)
{
tablas.Add(new Tuple<int, string>(i.ID, i.Nombretabla));
}
return tablas;
}
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}
public string Insert(Tablas_BD tablas)
{
try
{
using (var context = new BarandillasEntities())
{
context.Tablas_BD.Add(tablas);
context.SaveChanges();
return tablas.Nombre;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int Insert(RelacionesTablas_BD tablas)
{
try
{
using (var context = new BarandillasEntities())
{
context.RelacionesTablas_BD.Add(tablas);
context.SaveChanges();
return tablas.RelacionID;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public string Delete(int id)
{
try
{
using (var context = new BarandillasEntities())
{
Tablas_BD tabla = context.Tablas_BD.Find(id);
tabla.Estatus = false;
context.Entry(tabla).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return tabla.Nombre;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Entidades.Helpers.PaginadoRelacion selectAll(int skip, int take)
{
try
{
var data = new Entidades.Helpers.PaginadoRelacion();
List<Relaciones> t = new List<Relaciones>();
using (var context = new BarandillasEntities())
{
var query = (from p in context.RelacionesDeTablas
group p by new { p.TablaID, p.Nombre } into i
select new
{
TablaID = i.Key.TablaID,
NombreTabla = i.Key.Nombre,
Count = i.Count()
})
.OrderBy(i => i.TablaID)
.Skip(skip)
.Take(take)
.ToList().Distinct();
foreach (var i in query)
{
t.Add(new Relaciones { TablaID = i.TablaID, NombreTabla = i.NombreTabla, Count = i.Count});
}
data.Customers = t;
data.TotalRecords = t.Count();
return data;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public string Delete(int id)
{
try
{
string data = null;
using (var context = new BarandillasEntities())
{
var query = (from i in context.RelacionesTablas_BD
where i.TablaBaseID == id
select i).ToList();
data = query[0].Tablas_BD.Nombre;
foreach(var d in query)
{
context.RelacionesTablas_BD.Remove(d);
}
context.SaveChanges();
return data;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public string Update(Tablas_BD tablas)
{
try
{
using (var context = new BarandillasEntities())
{
context.Entry(tablas).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return tablas.Nombre;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
