public async Task <Contato> GetContatoById(int?id) { using (MainModelContainer db = new MainModelContainer()) { return(await db.ContatoSet.FindAsync(id)); } }
public async Task <Funcionario> GetFuncionarioByEmail(string email) { using (MainModelContainer db = new MainModelContainer()) { return(await db.FuncionarioSet.Where(f => f.Email.Equals(email)).FirstOrDefaultAsync()); } }
public async Task <List <Contato> > GetAll() { using (MainModelContainer db = new MainModelContainer()) { return(await db.ContatoSet.ToListAsync()); } }
public async Task <Funcionario> GetFuncionarioById(int id) { using (MainModelContainer db = new MainModelContainer()) { return(await db.FuncionarioSet.FindAsync(id)); } }
public ActionResult Index() { using (var ctx = new MainModelContainer()) { var asdasd = ctx.CreateEntityByType("Governmentprogram", false); } return(View()); }
/// <summary> /// Inicializar el Contexto de Base de Datos utilizado por éste Repositorio. /// </summary> /// <param name="dbContext">Contenedor de las Clases (Contexto de Base de Datos)</param> public IRepository(MainModelContainer dbContext = null) { if (dbContext == null) { return; } this._context = dbContext; this._dbSet = dbContext.Set <TEntity>(); }
public async Task <int> CreateContato(Contato contato) { using (MainModelContainer db = new MainModelContainer()) { db.ContatoSet.Add(contato); int result = await db.SaveChangesAsync(); return(result); } }
public async Task <int> CreateFuncionario(Funcionario fun) { using (MainModelContainer db = new MainModelContainer()) { db.FuncionarioSet.Add(fun); int result = await db.SaveChangesAsync(); return(result); } }
public async Task <int> DeleteFuncionario(int id) { using (MainModelContainer db = new MainModelContainer()) { int result = 0; var funcionario = db.FuncionarioSet.Find(id); if (funcionario != null) { db.FuncionarioSet.Remove(funcionario); result = await db.SaveChangesAsync(); } return(result); } }
public async Task <int> UpdateFuncionario(Funcionario fun) { using (MainModelContainer db = new MainModelContainer()) { int result = 0; var funcionario = db.FuncionarioSet.Find(fun.Id); if (funcionario != null) { funcionario.Email = fun.Email; funcionario.Nome = fun.Nome; funcionario.Telefone = fun.Telefone; result = await db.SaveChangesAsync(); } return(result); } }
/// <summary> /// Crea la abstracción de acceso como Repositorio a Recompensas. /// </summary> /// <param name="dbContext"> /// Contexto de BD, normalmente {MainModelContainer}. /// </param> public RewardRepository(MainModelContainer dbContext) : base(dbContext) { }
private void SeedWiki(MainModelContainer context) { if (!context.WikiPages.Any(x => x.ViewPath == "Wiki/Index.cshtml")) { context.WikiPages.Add(new WikiPage() { IsSystemPage = true, ViewPath = "Wiki/Index.cshtml", PageTitle = "Wiki Index", Content = @"@*<razor>*@ @{Html.RenderAction(""Pages"");}@*</razor>*@", }); } if (!context.WikiPages.Any(x => x.ViewPath == "Wiki/Comments.cshtml")) { context.WikiPages.AddOrUpdate(x => x.ViewPath, new WikiPage() { ViewPath = "Wiki/Comments.cshtml", PageTitle = "Wiki Comments", IsSystemPage = true, Content = @"@model RuPM.Controllers.WikiController.CommentsModel <div class=""comments"">@*<razor>*@@foreach (var comment in Model.Comments) { <article class=""comment byuser comment-author-admin bypostauthor even thread-even depth-1"" id=""*****@*****.**""><header> <h4>@comment.Author.Login</h4> <time>@comment.CreatedDate.ToString(""dd/MM/yyyy hh:mm"")</time></header> <section> <p>@comment.Text</p> </section> <footer><a rel=""nofollow"" class=""comment-reply-link"" href=""https://edu.rubius.com/a-ty-znaesh-chto-takoe-scada/?replytocom=8#respond"" onclick=""return addComment.moveForm( "comment-8", "8", "respond", "232" )"" aria-label=""Reply to admin"">Reply</a> <a class=""comment-edit-link"" href=""https://edu.rubius.com/wp-admin/comment.php?action=editcomment&c=8"">Edited</a></footer></article> }@*</razor>*@</div> <div id=""respond"" class=""comment-respond"">@*<razor>*@ <h3 id=""reply-title"" class=""comment-reply-title"">Leave a Reply</h3> @using (Html.BeginForm(""CreateComment"", ""Wiki"", FormMethod.Post, new {@class=""comment-form""})) { <p class=""comment-form-comment"">@Html.ValidationSummary() @Html.HiddenFor(x => x.Form.WikiPageId) @Html.TextAreaFor(x => x.Form.Text, new {rows=8})</p> <p class=""form-submit""><input name=""submit"" type=""submit"" id=""submit"" class=""submit"" value=""Post Comment"" /></p> }@*</razor>*@</div> <!-- #respond --> <p></p>" }); } if (!context.WikiPages.Any(x => x.ViewPath == "Wiki/LeftMenu.cshtml")) { context.WikiPages.AddOrUpdate(x => x.ViewPath, new WikiPage() { IsSystemPage = true, ViewPath = "Wiki/LeftMenu.cshtml", PageTitle = "Left Menu", Content = "<aside class=\"l-sidebar col-md-2 l-sidebar--totop\">\r\n<div class=\"l-sidebar__fixed\"><a class=\"btn\" href=\"/wiki/editPage\"><span style=\"font-size: 18px; display: inline-block; margin-right: 5px;\">+</span> Add new post</a>\r\n<ul class=\"b-category\">\r\n<ul class=\"b-category\">\r\n<li class=\"cat-item cat-item-10\"><a href=\"https://edu.rubius.com/category/1/\">Education</a>\r\n<ul class=\"children\">\r\n<li class=\"cat-item cat-item-11\"><a href=\"https://edu.rubius.com/category/1/developer/\">Developer</a>\r\n<ul class=\"children\">\r\n<li class=\"cat-item cat-item-25\"><a href=\"https://edu.rubius.com/category/1/developer/c_plusplus/\">C++</a></li>\r\n<li class=\"cat-item cat-item-26\"><a href=\"https://edu.rubius.com/category/1/developer/js/\">JS</a></li>\r\n<li class=\"cat-item cat-item-24\"><a href=\"https://edu.rubius.com/category/1/developer/net/\">.Net</a></li>\r\n<li class=\"cat-item cat-item-27\"><a href=\"https://edu.rubius.com/category/1/developer/sql/\">SQL</a></li>\r\n</ul>\r\n</li>\r\n<li class=\"cat-item cat-item-14\"><a href=\"https://edu.rubius.com/category/1/devops/\">DevOps</a></li>\r\n<li class=\"cat-item cat-item-5\"><a href=\"https://edu.rubius.com/category/1/qualityassurance/\">QAs</a></li>\r\n</ul>\r\n</li>\r\n<li class=\"cat-item cat-item-2\"><a href=\"https://edu.rubius.com/category/2/\">Videos</a></li>\r\n<li class=\"cat-item cat-item-19\"><a href=\"https://edu.rubius.com/category/4/\">How To</a></li>\r\n<li class=\"cat-item cat-item-19\"><a href=\"https://pm.rubius.com/Account/GetRubiusGuide/\" target=\"_blank\" rel=\"noopener\">Rubius Guide</a></li>\r\n<li class=\"cat-item cat-item-19\"><a href=\"https://docs.google.com/spreadsheets/d/1-UgUY2Tyshs6WvU1VqopaJ-NToUvIfsErA1NDkRkcZU/edit?usp=sharing\" target=\"_blank\" rel=\"noopener\">Books</a></li>\r\n</ul>\r\n</ul>\r\n<div class=\"l-sidebar__footer\">\r\n<div class=\"b-copy\">© Rubius</div>\r\n<ul class=\"b-social\">\r\n<li class=\"b-social--vk\"><a href=\"https://vk.com/rubiuscompany\" target=\"_blank\" rel=\"noopener\"><i class=\"fa fa-vk\" aria-hidden=\"true\"></i></a></li>\r\n<li class=\"b-social--fb\"><a href=\"https://www.facebook.com/RubiusCompany\" target=\"_blank\" rel=\"noopener\"><i class=\"fa fa-facebook\" aria-hidden=\"true\"></i></a></li>\r\n<li class=\"b-social--yt\"><a href=\"https://www.youtube.com/c/RubiusCompany\" target=\"_blank\" rel=\"noopener\"><i class=\"fa fa-youtube-play\" aria-hidden=\"true\"></i></a></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</aside>" }); } if (!context.WikiPages.Any(x => x.ViewPath == "Wiki/General_Layout.cshtml")) { context.WikiPages.AddOrUpdate(x => x.ViewPath, new WikiPage() { IsSystemPage = true, ViewPath = "Wiki/General_Layout.cshtml", PageTitle = "General Layout", Content = "@*<razor>*@@{ Layout = \"~/Views/Shared/_Layout.cshtml\"; }@*</razor>*@@*<razor>*@@Html.Partial(\"ScriptsAndStylesAdmin\")@*</razor>*@\r\n<div class=\"container\">\r\n<div class=\"row\">@*<razor>*@@Html.Partial(\"LeftMenu\") @* Left Menu *@@*</razor>*@\r\n<section class=\"l-content col-md-10\">@*<razor>*@@RenderBody()@*</razor>*@</section>\r\n</div>\r\n</div>" }); } context.SaveChanges(); if (!context.WikiPages.Any(x => x.ViewPath == "Wiki/Pages.cshtml")) { context.WikiPages.AddOrUpdate(x => x.ViewPath, new WikiPage() { ViewPath = "Wiki/Pages.cshtml", PageTitle = "Wiki Pages List", ViewUrl = "/Wiki/Pages", IsSystemPage = true, LayoutPage = context.WikiPages.FirstOrDefault(x => x.ViewPath == "Wiki/General_Layout.cshtml"), Content = @"@*<razor>*@@{ var actionName = ""GetPage""; }@*</razor>*@@*<razor>*@ <div class=""b-last-activity""> <ul class=""b-last-activity__list"">@foreach (var wikiPage in Model.Pages) { <li class=""post type-post status-publish format-standard sticky hentry""> <div class=""b-last-activity__left""><a href=""@Url.Action(actionName, new{pageId=wikiPage.Page.Id})""> @wikiPage.Page.PageTitle </a> <div class=""b-last-activity__tags"">@foreach (var tag in wikiPage.Tags) { <a href=""tag/@tag.TagForLink/"" rel=""tag"">@tag.TagForLink</a> }</div> </div> <div class=""right""><span class=""b-last-activity__subinfo"">@wikiPage.Page.CreatedDate.ToString(""dd/MM/yyyy"")</span> <span class=""b-last-activity__subinfo""><i class=""fa fa-comment-o"" aria-hidden=""true""></i> @wikiPage.CommentsCount</span></div> </li> }</ul> </div> @*</razor>*@", }); } if (!context.WikiPages.Any(x => x.ViewPath == "Wiki/Blog_Post_Layout.cshtml")) { context.WikiPages.AddOrUpdate(x => x.ViewPath, new WikiPage() { IsLayout = true, IsSystemPage = true, LayoutPage = context.WikiPages.FirstOrDefault(x => x.ViewPath == "Wiki/General_Layout.cshtml"), ViewPath = "Wiki/Blog_Post_Layout.cshtml", PageTitle = "Blog Post Layout", Content = @"<div class=""l-content__title"">@*<razor>*@@Model.Page.PageTitle<a class=""post-edit-link"" href=""[email protected]"">Edit This</a>@*</razor>*@</div> <article class=""l-content__text"">@*<razor>*@@RenderBody()@*</razor>*@<footer class=""l-content__footer""> <div class=""l-content__autor""><i class=""fa fa-user-o"" aria-hidden=""true""></i> Автор:@*<razor>*@admin@*</razor>*@</div> <div class=""l-content__updated""><i class=""fa fa-calendar-o"" aria-hidden=""true""></i> Изменён @*<razor>*@@Model.Page.ChangedDate.ToString(""dd/MM/yyyy"")@*</razor>*@</div> </footer>@*<razor>*@@{ Html.RenderAction(""Comments"", ""Wiki"", new {wikiPageId = Model.Page.Id}); }@*</razor>*@ <p> </p> </article>", }); } if (!context.WikiPages.Any(x => x.ViewPath == "Wiki/ScriptsAndStylesAdmin.cshtml")) { context.WikiPages.AddOrUpdate(x => x.ViewPath, new WikiPage() { IsLayout = true, IsSystemPage = true, ViewPath = "Wiki/ScriptsAndStylesAdmin.cshtml", Content = @"<link rel=""stylesheet"" href=""/Content/Wiki/style.css""> <link rel=""stylesheet"" href=""/Content/Wiki/font-awesome.min.css""> <link rel=""stylesheet"" href=""/Content/Wiki/wp-syntax.css"">", PageTitle = "Scripts And Styles Admin", }); } context.SaveChanges(); }
public ControllerBase() { _db = new MainModelContainer(); }