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