public void ReturnMaintenanceClientType() { using (var db = new CrudContext()) { Assert.IsInstanceOf < ClientPatientManagement.Core.Model.Client > (db.Clients.FirstOrDefault()); } }
public void GetClientList() { using (var db = new CrudContext()) { Assert.IsNotEmpty(db.Clients.ToList()); } }
public void ReturnMaintenanceClientType() { using (var db = new CrudContext()) { Assert.IsInstanceOf <ClientPatientManagement.Core.Model.Client> (db.Clients.FirstOrDefault()); } }
public ActionResult AddPerson(PersonModel personModel) { try { using (CrudContext db = new CrudContext()) { var teacher = new Teacher() { Address = new Address() { Street = personModel.Street, City = new City() { Id = personModel.CityId, // CountryId = 1 } }, Name = personModel.Name, Email = personModel.Email }; db.Entry(teacher.Address.City).State = EntityState.Unchanged; db.Persons.Add(teacher); db.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public HomeController(CrudContext context, INewsService newsService, IGameService gameService, IReviewService reviewService) { _newsService = newsService; _gameService = gameService; _reviewService = reviewService; _context = context; }
// Controller constructor public AdhocController(CrudContext context, IHttpContextAccessor httpContextAccessor) { _contextAdhoc = context; this.ipAddr = httpContextAccessor.HttpContext?.Connection?.RemoteIpAddress.ToString(); if (ipAddr == "::1") // when using localhost, IP is ::1. { this.ipAddr = "142.134.88.171"; // default IP Address for HRM in place for localhost } else { this.ipAddr = httpContextAccessor.HttpContext?.Connection?.RemoteIpAddress.ToString(); } // use ipstack web service to translate ip address to location string url = "http://api.ipstack.com/" + ipAddr + "?access_key=<your key>"; var request = WebRequest.Create(url); using (WebResponse wrs = request.GetResponse()) using (Stream stream = wrs.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { string json = reader.ReadToEnd(); var obj = JObject.Parse(json); city = (string)obj["city"]; latitude = (double)obj["latitude"]; longtitude = (double)obj["longitude"]; ipAddr = city + " " + latitude + " " + longtitude; } }
public Repository(CrudContext context, IExceptionLogger logger) { _context = context; _dbSet = context.Set <TEntity>(); _logger = logger; }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, CrudContext entityManager) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseHsts(); } app.UseHttpsRedirection(); app.UseWebSockets(); app.UseMiddleware <RequestFilter> (); app.UseMvc(); String root = Path.Combine(Directory.GetCurrentDirectory(), "src/main/webapp"); if (Directory.Exists(root)) { app.UseFileServer(new FileServerOptions { FileProvider = new PhysicalFileProvider(root) }); } else { Console.WriteLine("Directory fail : " + root); } // app.UseResponseCompression(); // app.UseMvcWithDefaultRoute(); RequestFilter.UpdateCrudServices(entityManager); }
public TestDbContextFixture() { Db = new TestDbContext(); CrudContext = new CrudContext <TestDbContext>(Db, () => new System.Security.Claims.ClaimsPrincipal()) { ReflectionRepository = ReflectionRepositoryFactory.Reflection }; }
public AppCrud(CrudContext context, IProduto produtoDB, ICategoria categoriaDB) { _context = context; _produtoDB = produtoDB; _categoriaDB = categoriaDB; }
public ActionResult Retrive(UserModel user) { using (CrudContext db = new CrudContext()) { var output = db.user.ToList(); return(View(output)); } }
public void StartUp() { var optionsBuilder = new DbContextOptionsBuilder <CrudContext>(); optionsBuilder.UseSqlite("Filename = Crud.db"); _db = new CrudContext(optionsBuilder.Options); }
// Method implements logic data table public static List <object> TableChartData(CrudContext myContext, string pYear, string location, string service, string status, string overdue) { List <object> chartData = new List <object>(); // 5. Filter by request category - Service tickets, Incidents, Adhoc chartData.Add(new object[] { "Request Category", "ID", "Submitted On", "Requestor", "Service/Priority", "Due Date", "Status", "Support Analyst", "Completed On" }); switch (service) { case "Service requests": foreach (var item in myTicketsList) { chartData.Add(new object[] { "Service request", item.ID, item.SubmittedDate, item.RequestorID, item.RequiredService, item.RequiredByDate, item.Status, item.SupportAnalyst, item.CompletedDate }); } break; case "Adhoc": foreach (var item in myAdhocsList) { chartData.Add(new object[] { "Adhoc", item.ID, item.SubmittedDate, item.RequestorID, item.Type, item.SubmittedDate, item.Status, item.SupportAnalyst, item.CompletedDate }); } break; case "Incidents": foreach (var item in myIncidentsList) { chartData.Add(new object[] { "Incident", item.ID, item.SubmittedDate, item.RequestorID, item.Severity, item.SubmittedDate, item.Status, item.SupportAnalyst, item.CompletedDate }); } break; default: foreach (var item in myTicketsList) { chartData.Add(new object[] { "Service request", item.ID, item.SubmittedDate, item.RequestorID, item.RequiredService, item.RequiredByDate, item.Status, item.SupportAnalyst, item.CompletedDate }); } foreach (var item in myIncidentsList) { chartData.Add(new object[] { "Incident", item.ID, item.SubmittedDate, item.RequestorID, item.Severity, item.SubmittedDate, item.Status, item.SupportAnalyst, item.CompletedDate }); } foreach (var item in myAdhocsList) { chartData.Add(new object[] { "Adhoc", item.ID, item.SubmittedDate, item.RequestorID, item.Type, item.SubmittedDate, item.Status, item.SupportAnalyst, item.CompletedDate }); } break; } return(chartData); }
void Application_Start(object sender, EventArgs e) { // Code that runs on application startup AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); RouteConfig.RegisterRoutes(RouteTable.Routes); using (var ctx = new CrudContext()) { new DatabaseInitializer().InitializeDatabase(ctx); } }
public ActionResult Updateuser(string id) { if (id == null) { return(HttpNotFound()); } CrudContext db = new CrudContext(); var output = db.user.Single(x => x.id == id); return(View(output)); }
private static void ExplicitLoading() { using (var context = new CrudContext()) { var projectCategory = context.ProjectCategories.First(); context.Entry(projectCategory).Collection(pc => pc.Projects).Load(); Console.WriteLine("project count for {0},{1}", projectCategory.Name, projectCategory.Projects.Count()); } }
public ActionResult Updateusers(UserModel user) { if (ModelState.IsValid) { CrudContext db = new CrudContext(); db.Entry(user).State = EntityState.Modified; db.SaveChanges(); ViewBag.Message = user.UserName + " successfully edited."; return(RedirectToAction("Retrive")); } return(View("Retrive")); }
public void Create() { try { var db = new CrudContext(); var employees = db.Set <Employee>().ToList(); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private static void DeleteProjectCategory() { int Id; using (var context = new CrudContext()) { var projectCategoies = context.ProjectCategories.Where(c => c.Name == "Internal").ToList(); foreach (var projectCategory in projectCategoies) { context.ProjectCategories.Remove(projectCategory); } context.SaveChanges(); } }
private static void CreateDataBase() { try { var context = new CrudContext(); context.Database.Initialize(true); } catch (Exception w) { throw; } }
public async Task <string> Inserir(CrudContext context, Categorium obj) { try { var result = context.Categoria.Add(obj); context.SaveChanges(); } catch (Exception ex) { Console.Write(ex); } return(""); }
public async Task <string> Inserir(CrudContext context, Entities.Produto obj) { try { var result = context.Produtos.Add(obj); context.SaveChanges(); return(""); } catch (Exception ex) { return("Erro ao inserir o registro"); } return(""); }
public async Task <string> Atualizar(CrudContext context, Entities.Produto obj) { try { var result = context.Produtos.Update(obj); context.SaveChanges(); return(""); } catch (Exception ex) { return("Erro ao atualizar o registro"); } return(""); }
public async Task <string> Apagar(CrudContext context, int id) { try { var cat = await Listar(context, id); context.Categoria.Remove(cat.First()); context.SaveChanges(); } catch (Exception ex) { Console.Write(ex); } return(""); }
public async Task <string> Apagar(CrudContext context, int id) { try { var prod = await Listar(context, id, null); context.Produtos.Remove(prod.First()); context.SaveChanges(); return("ok"); } catch (Exception ex) { return("Erro ao apagar registro"); } }
public async Task <List <Entities.Produto> > Listar(CrudContext context, int id, string nome) { try { var result = context.Produtos.FromSqlInterpolated($"exec sp_produtoSel @int_idProduto = {id}, @str_nome = {nome}").ToList(); if (result.Count() > 0) { return(result); } } catch (Exception ex) { Console.Write(ex); } return(new List <Entities.Produto>()); }
private static void EagerLoading() { using (var context = new CrudContext()) { var project1 = context.Projects.Include(p => p.Issues).ToList(); var project2 = context.Projects.Include("Issues").ToList(); var projectCategory3 = context.ProjectCategories.Include("Projects.Issues").ToList(); var projectCategory4 = context.ProjectCategories .Where(pc=>pc.Projects.Any()) //.Include(pc => pc.Projects.Select(p => p.Issues.Select(w => w.UserProfile))) .ToList() ; var projectCategory = projectCategory4[0]; } }
public ActionResult Create(UserModel account) { if (ModelState.IsValid) { using (CrudContext db = new CrudContext()) { db.user.Add(account); db.SaveChanges(); } ModelState.Clear(); ViewBag.Message = account.UserName + " successfully created."; } return(View()); }
public ActionResult RemoveUser(string id, int y = 0) { if (id == null) { return(HttpNotFound()); } CrudContext db = new CrudContext(); var output = db.user.Single(x => x.id == id); if (output == null) { return(HttpNotFound()); } return(View()); }
public async Task <List <Categorium> > Listar(CrudContext context, int id) { try { var param = new SqlParameter("@int_idCategoria", id); var result = await context.Categoria.FromSqlRaw("exec sp_CategoriaSel @int_idCategoria", param).ToListAsync(); if (result.Count() > 0) { return(result); } } catch (Exception ex) { Console.Write(ex); } return(new List <Entities.Categorium>()); }
/* * Method sets 4 filter variables - Year Submitted, Location, Service Category, Request Status, Overdue Status * This prevents from writing repetitive code for all methods responsible for visiuals in the Analytics Area as * all visuals are affected by the same set of filters. */ public static void setFilterParameters(CrudContext myContext, string pYear, string location, string service, string status, string overdue) { myTicketsList = myContext.Tickets.ToList(); myIncidentsList = myContext.Incidents.ToList(); myAdhocsList = myContext.Adhocs.ToList(); success = Int32.TryParse(pYear, out year); // 1.Filter by Year Submitted if (pYear != "All") { if (success) { myTicketsList = myTicketsList.FindAll(x => x.SubmittedDate.Year == year); myIncidentsList = myIncidentsList.FindAll(x => x.SubmittedDate.Year == year); myAdhocsList = myAdhocsList.FindAll(x => x.SubmittedDate.Year == year); } } // 2. Filter by Location if (location != "All") { myTicketsList = myTicketsList.FindAll(x => x.requestLocation == location); myIncidentsList = myIncidentsList.FindAll(x => x.requestLocation == location); myAdhocsList = myAdhocsList.FindAll(x => x.requestLocation == location); } // 3. Filter by Status if (status != "All") { myTicketsList = myTicketsList.FindAll(x => x.Status == status); myIncidentsList = myIncidentsList.FindAll(x => x.Status == status); myAdhocsList = myAdhocsList.FindAll(x => x.Status == status); } DateTime todayDate = System.DateTime.Today; // 4. Filter by overdue status if (overdue != "All") { myTicketsList = myTicketsList.FindAll(x => (x.CompletedDate > x.RequiredByDate) || (x.Status != "Closed" && x.Status != "Cancelled" && todayDate > x.RequiredByDate)); myIncidentsList = myIncidentsList.FindAll(x => x.CompletedDate > x.SubmittedDate.AddHours(4)); myAdhocsList = myAdhocsList.FindAll(x => (x.CompletedDate > x.RequiredByDate) || (x.Status != "Closed" && x.Status != "Cancelled" && todayDate > x.RequiredByDate)); } }
public void TestPraseHolder() { DatabaseTestClass databaseTestClass = new DatabaseTestClass(); var tryEntity = new ServiceUser() { UserName = "******", Password = "******" }; var tryEntity2 = new ServiceUser() { UserName = "******", Password = "******" }; var config = new CrudContext().GetProperty(CrudEnum.GetLogin); bool answer = databaseTestClass.ShowExeculteLog(config, tryEntity); bool answer2 = databaseTestClass.ShowExeculteLog(config, tryEntity2); Assert.True(answer && !answer2); }
public ActionResult RemoveUser(string id) { if (id == null) { return(HttpNotFound()); } CrudContext db = new CrudContext(); var output = db.user.Single(x => x.id == id); if (output == null) { return(HttpNotFound()); } db.user.Remove(output); db.SaveChanges(); return(RedirectToAction("Retrive")); }
private void SetAutofacContainer() { var builder = new ContainerBuilder(); builder.RegisterControllers(Assembly.GetExecutingAssembly()); var data = Assembly.Load("Data"); builder.RegisterAssemblyTypes(data); var domain = Assembly.Load("Domain"); builder.RegisterAssemblyTypes(domain); var application = Assembly.Load("Application"); builder.RegisterAssemblyTypes(application); var x = new CrudContext(); builder.Register <CrudContext>(c => x); builder.Register <CustomUserStore>(c => new CustomUserStore(x)).AsImplementedInterfaces(); builder.Register <IdentityFactoryOptions <ApplicationUserManager> >(c => new IdentityFactoryOptions <ApplicationUserManager>() { DataProtectionProvider = new Microsoft.Owin.Security.DataProtection.DpapiDataProtectionProvider("ApplicationName") }); builder.RegisterType <ApplicationUserManager>(); builder.RegisterType <CrudContext>().InstancePerLifetimeScope(); builder.RegisterType <CommentService>().AsImplementedInterfaces().InstancePerLifetimeScope(); builder.RegisterType <NewsService>().AsImplementedInterfaces().InstancePerLifetimeScope(); builder.RegisterType <ReviewService>().AsImplementedInterfaces().InstancePerLifetimeScope(); builder.RegisterType <RateService>().AsImplementedInterfaces().InstancePerLifetimeScope(); builder.RegisterType <UserService>().AsImplementedInterfaces().InstancePerLifetimeScope(); builder.RegisterType <GameService>().AsImplementedInterfaces().InstancePerLifetimeScope(); builder.RegisterFilterProvider(); var container = builder.Build(); DependencyResolver.SetResolver(new AutofacDependencyResolver(container)); }
private static void GetProject1() { using (var context = new CrudContext()) { var project = context.Projects.Where(p => p.Issues.Any()) .Select(p => new { Project=p.Name, ProjectCategory = p.ProjectCategoryId }); } }
private static void InsertProjectCategory_Project() { try { var status = GetStatus(); var projectCategory = new ProjectCategory { Name = "Internal", }; var project = new Project { Name = "Jira1", CompanyId = 1, //ProjectId = Guid.NewGuid(), //Works = {new Work(Guid.NewGuid()) {StatusId=status[0].StatusId, TimeRange_Start=DateTime.Now.AddDays(-5),TimeRange_End=DateTime.Now.AddDays(-4) }, // new Work(Guid.NewGuid()) {StatusId=status[0].StatusId, TimeRange_Start=DateTime.Now.AddDays(-3),TimeRange_End=DateTime.Now.AddDays(-2) }} }; //project.ProjectCategory = projectCategory; projectCategory.Projects.Add(project); using (var context = new CrudContext()) { context.ProjectCategories.Add(projectCategory); context.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e); } }
private static void UpdateProjectCategory() { int Id; using (var context = new CrudContext()) { var projectCategory = context.ProjectCategories.FirstOrDefault(c => c.Name == "Internal"); Id = projectCategory.Id; projectCategory.Description = "Internal projects"; context.SaveChanges(); } GetProjectCategory(Id); }
private static List<Status> GetStatus() { using (var context = new CrudContext()) { return context.Status.ToList(); } }
private static void InsertProjectCategory() { var projectCategory = new ProjectCategory { Name = "Internal" }; using (var context = new CrudContext()) { context.ProjectCategories.Add(projectCategory); context.SaveChanges(); } GetProjectCategory(projectCategory.Id); }
public MyBehaviors(CrudContext <TContext> context) : base(context) { }
private static void GetProject2() { using (var context = new CrudContext()) { var project = from p in context.Projects where p.Issues.Any() select new { Project = p.Name, ProjectCategory = p.ProjectCategoryId }; } }