public List <Rol> GetRolesUser(int id)
{
using (ModelContainer1 container1 = new ModelContainer1())
{
return(container1.ClienteSet.Single(u => u.Id == id)?.Rol.ToList());
};
}
public int GetColorB()
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.AllPagesSet select x).First();
return(page.ColorB);
}
public List <T> Filter(Expression <Func <T, bool> > predicate)
{
using (ModelContainer1 context = new ModelContainer1())
{
return((List <T>)context.Set <T>().Where(predicate).ToList());
}
}
public string GetContent(int id)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet where x.Id == id select x).First();
return(page.Content);
}
public T Single(Expression <Func <T, bool> > predicate)
{
using (ModelContainer1 context = new ModelContainer1())
{
return(context.Set <T>().FirstOrDefault(predicate));
}
}
public int GetLastPage()
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet orderby x.Id ascending select x).First();
return(page.Id);
}
public List <T> GetAll()
{
using (ModelContainer1 context = new ModelContainer1())
{
return((List <T>)context.Set <T>().ToList());
}
}
public string GetLogo()
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.AllPagesSet select x).First();
return(page.Logo);
}
public bool CheckEmail(string email)
{
using (ModelContainer1 context = new ModelContainer1())
{
return(context.ClienteSet.Any(u => u.Email == email));
}
}
public void UpdatePage(int id, string name)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet where x.Id == id select x).First();
page.Name = name;
mc.SaveChanges();
}
public void UpdateLogo(string html)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.AllPagesSet select x).First();
page.Logo = html;
mc.SaveChanges();
}
public void DeletePage(int id)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet where x.Id == id select x).First();
mc.PageSet.DeleteObject(page);
mc.SaveChanges();
}
public string GetMarker(int id)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet where x.Id == id select x).First();
string value = page.Marker_x + ";;;" + page.Marker_y + ";;;" + page.Marker_comment;
return(value);
}
public bool Create(T entity)
{
using (ModelContainer1 context = new ModelContainer1())
{
context.Set <T>().Add(entity);
return(context.SaveChanges() > 0);
}
}
public void SaveContent(string html, int id)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet where x.Id == id select x).First();
page.Content = html;
mc.SaveChanges();
}
public bool Delete(T entity)
{
using (ModelContainer1 context = new ModelContainer1())
{
context.Entry(entity).State = EntityState.Deleted;
return(context.SaveChanges() > 0);
}
}
public void Delete(Expression <Func <T, bool> > predicate)
{
using (ModelContainer1 context = new ModelContainer1())
{
var entities = context.Set <T>().Where(predicate).ToList();
entities.ForEach(x => context.Entry(x).State = EntityState.Deleted);
context.SaveChanges();
}
}
public bool CreatePedidoWithProducts(Pedido pedido)
{
using (ModelContainer1 container1 = new ModelContainer1())
{
container1.PedidoSet.Add(pedido);
pedido.Producto.ToList().ForEach(u => container1.Entry(u).State = EntityState.Unchanged);
return(container1.SaveChanges() > 0);
}
}
public bool CreateCliente(Cliente cliente)
{
using (ModelContainer1 context = new ModelContainer1())
{
context.ClienteSet.Add(cliente);
cliente.Rol.ToList().ForEach(u => context.Entry(u).State = EntityState.Unchanged);
return(context.SaveChanges() > 0);
}
}
public void CreatePage(string name)
{
ModelContainer1 mc = new ModelContainer1();
var newPage = new Page();
newPage.Name = name;
newPage.Content = "<li class='editable'>Welcome to the new site!</li><li> </li>";
mc.AddToPageSet(newPage);
mc.SaveChanges();
}
public void DeleteMarker(int siteId)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet where x.Id == siteId select x).First();
page.Marker_x = null;
page.Marker_y = null;
page.Marker_comment = null;
mc.SaveChanges();
}
public void AddMarker(int siteId, string markerX, string markerY, string comment)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.PageSet where x.Id == siteId select x).First();
page.Marker_x = markerX;
page.Marker_y = markerY;
page.Marker_comment = comment;
mc.SaveChanges();
}
public void UpdateColor(int red, int green, int blue)
{
ModelContainer1 mc = new ModelContainer1();
var page = (from x in mc.AllPagesSet select x).First();
page.ColorR = red;
page.ColorG = green;
page.ColorB = blue;
mc.SaveChanges();
}
public bool UpdateMultiplesStock(IDictionary <int, int> productosNewStock)
{
using (ModelContainer1 context = new ModelContainer1())
{
foreach (var productoNewStock in productosNewStock)
{
Producto producto = context.ProductoSet.Single(u => u.Id == productoNewStock.Key);
producto.Cantidad = producto.Cantidad - productoNewStock.Value;
}
return(context.SaveChanges() > 0);
}
}
public DataManager()
{
cont = new ModelContainer1();
UserRepo = new UserRepository(cont);
MetRepo = new MeterRepository(cont);
InstMetRepo = new InstMeterRepository(cont);
ParRepo = new ParametrRepository(cont);
TypeRepo = new TypeRepository(cont);
ReadRepo = new ReadingRepository(cont);
TarRepo = new TariffRepository(cont);
TimeSpanRepo = new TimeSpanRepository(cont);
DocRepo = new DocumentRepository(cont);
}
protected void Page_Load(object sender, EventArgs e)
{
ClientScriptManager cs = Page.ClientScript;
ModelContainer1 mc = new ModelContainer1();
var contentForAllPages = (from x in mc.AllPagesSet select x).First();
PageLogo = contentForAllPages.Logo;
cs.RegisterStartupScript(this.GetType(), "changecColor", "changeColor(" + contentForAllPages.ColorR + "," + contentForAllPages.ColorG + "," + contentForAllPages.ColorB + ");", true);
var defaultPage = (from x in mc.PageSet orderby x.Id ascending select x).First();
PagesCollection = "";
var pageCollection = (from x in mc.PageSet orderby x.Id ascending select x);
foreach (Model.Page p in pageCollection)
{
PagesCollection += "<li><a class='hovGradient' id='pageId" + p.Id + "' href='?pageId=" + p.Id + "'>" + p.Name + "</a></li>";
}
string pageId = Request.QueryString["pageId"];
if (pageId != null)
{
int id = int.Parse(pageId);
Model.Page page = null;
try
{
page = (from x in mc.PageSet where x.Id == id select x).First();
}
catch (Exception)
{ }
if (page == null)
{
page = (Model.Page)defaultPage;
Response.Redirect("Default.aspx?pageId=" + page.Id);
}
PageId = id;
PageContent = page.Content;
}
else
{
PageId = defaultPage.Id;
PageContent = defaultPage.Content;
}
}
public List <T> Filter(Expression <Func <T, bool> > predicate, List <Expression <Func <T, object> > > includes)
{
List <string> includelist = new List <string>();
foreach (var item in includes)
{
MemberExpression body = item.Body as MemberExpression;
if (body == null)
{
throw new ArgumentException("The body must be a member expression");
}
includelist.Add(body.Member.Name);
}
using (ModelContainer1 context = new ModelContainer1())
{
DbQuery <T> query = context.Set <T>();
includelist.ForEach(x => query = query.Include(x));
return((List <T>)query.Where(predicate).ToList());
}
}
public ParametrRepository(ModelContainer1 _cont)
{
cont = _cont;
}
public Pedido GetPedido(int id)
{
ModelContainer1 container1 = new ModelContainer1();
return(container1.PedidoSet.Single(u => u.Id == id));
}
public TariffRepository(ModelContainer1 _cont)
{
cont = _cont;
}
