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; }