public void Model_GenerateCreateTableSql_permanent_table() { var _ = new SampleDb().SampleModel._; var sqlBuilder = new IndentedStringBuilder(); _.GenerateCreateTableSql(sqlBuilder, MySqlVersion.LowestSupported, false); var expectedSql = @"CREATE TABLE `SampleModel` ( `Id` INT NOT NULL AUTO_INCREMENT COMMENT 'Id Description', `Name` VARCHAR(500) NULL DEFAULT('DEFAULT NAME') COMMENT 'Name Description', `Unique1` INT NULL COMMENT 'Unique1 Description', `Unique2` INT NULL COMMENT 'Unique2 Description', CONSTRAINT `PK_SampleModel` PRIMARY KEY (`Id`), CONSTRAINT `UQ_Temp` UNIQUE (`Unique1`, `Unique2` DESC), CONSTRAINT `CK_Temp` CHECK (`Name` IS NOT NULL), CONSTRAINT `FK_SampleModel_SampleModel_FkRef` FOREIGN KEY (`Unique1`) REFERENCES `SampleModel` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, INDEX `IX_SampleModel_Name` (`Name`) ) COMMENT 'Sample Model Description.'; "; Assert.AreEqual(expectedSql, sqlBuilder.ToString()); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, IApplicationLifetime lifetime) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseDatabaseErrorPage(); } else { app.UseExceptionHandler("/Home/Error"); } app.UseStaticFiles(); app.UseAuthentication(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); app.UseAiplugsFunctions <JObject>(); lifetime.ApplicationStopped.Register(() => SampleDb.CloseAndDispose()); }
public ActionResult Delete(int id) { SampleDb sampleDb = new SampleDb(); DemotblEmployee selectedEmployee = sampleDb.DemotblEmployees.FirstOrDefault(x => x.Id == id); return(View(selectedEmployee)); }
public ActionResult Create(DemotblEmployee emp) { SampleDb sampleDb = new SampleDb(); sampleDb.DemotblEmployees.Add(emp); sampleDb.SaveChanges(); return(RedirectToAction("Index")); }
public async Task Export() { byte[] response = await SampleDb.ExportProductsToExcel(new Query() { Filter = $@"{grid0.Query.Filter}", OrderBy = $"{grid0.Query.OrderBy}", Expand = "", Select = "Id,ProductName,ProductPrice,ProductPicture" }, $"Products"); await JSRuntime.InvokeAsync <object>("saveAsFile", $"MyFile.xlsx", Convert.ToBase64String(response)); }
public ActionResult Delete(DemotblEmployee demoemp) { SampleDb sampleDb = new SampleDb(); DemotblEmployee selectedEmployee = sampleDb.DemotblEmployees.FirstOrDefault(x => x.Id == demoemp.Id); sampleDb.DemotblEmployees.Remove(selectedEmployee); sampleDb.SaveChanges(); return(RedirectToAction("Index")); }
public ToggleController(SampleDb context) : base("toggle", "Toggle test controller") { _context = context; if (controller == null) { controller = new TestController(_context); } }
protected async System.Threading.Tasks.Task Load() { if (string.IsNullOrEmpty(search)) { search = ""; } var sampleDbGetProductsResult = await SampleDb.GetProducts(new Query() { Filter = $@"i => i.ProductName.Contains(@0)", FilterParameters = new object[] { search } }); getProductsResult = sampleDbGetProductsResult; }
protected async System.Threading.Tasks.Task Form0Submit(ExportOperations.Models.SampleDb.Product args) { try { var sampleDbCreateProductResult = await SampleDb.CreateProduct(product); DialogService.Close(product); } catch (System.Exception sampleDbCreateProductException) { NotificationService.Notify(new NotificationMessage() { Severity = NotificationSeverity.Error, Summary = $"Error", Detail = $"Unable to create new Product!" }); } }
private static void Main(string[] args) { var console = new ClientConsole(); Effort.Provider.EffortProviderConfiguration.RegisterProvider(); var connection = DbConnectionFactory.CreateTransient(); using (var context = new SampleDb(connection, "geo")) { console.WriteLine("Welcome to EF Test Console, type help to check available commands", OutputLevel.Information, null); context.Products.AddRange(new[] { new Product { Name = "CocaCola" }, new Product { Name = "Pepsi" }, new Product { Name = "Starbucks" }, new Product { Name = "Donut" } }); context.SaveChanges(); var ct = new System.Threading.CancellationToken(); Task.Run(() => { SingletonSampleJob.Instance.RunBackgroundWork(ct); }, ct); var command = new RootCommand(console); command.RegisterCommand(new FillOrderCommand(context)); command.RegisterCommand(new EditOrder(context)); command.RegisterCommand(new QueryAuditTrail(context)); command.RegisterCommand(new QueryOrder(context)); command.RegisterCommand(new ToggleController(context)); command.RegisterCommand(new JobController(context)); var commandEngine = new CommandEngine(command); commandEngine.Run(args); } }
public ActionResult Edit(DemotblEmployee demoemp) { SampleDb sampleDb = new SampleDb(); //DemotblEmployee selectedEmployee = sampleDb.DemotblEmployees.FirstOrDefault(x => x.Id == demoemp.Id); //selectedEmployee.FullName = demoemp.FullName; //selectedEmployee.Gender = demoemp.Gender; //selectedEmployee.Age = demoemp.Age; //selectedEmployee.EmailAddress = demoemp.EmailAddress; //selectedEmployee.HireDate = demoemp.HireDate; //selectedEmployee.Salary= demoemp.Salary; //selectedEmployee.PersonalWebSite = demoemp.PersonalWebSite; sampleDb.Entry(demoemp).State = System.Data.Entity.EntityState.Modified; sampleDb.SaveChanges(); return(RedirectToAction("Index")); }
protected async System.Threading.Tasks.Task GridDeleteButtonClick(MouseEventArgs args, dynamic data) { try { if (await DialogService.Confirm("Are you sure you want to delete this record?") == true) { var sampleDbDeleteProductResult = await SampleDb.DeleteProduct(data.Id); if (sampleDbDeleteProductResult != null) { await grid0.Reload(); } } } catch (System.Exception sampleDbDeleteProductException) { NotificationService.Notify(new NotificationMessage() { Severity = NotificationSeverity.Error, Summary = $"Error", Detail = $"Unable to delete Product" }); } }
public SampleRepository(SampleDb db) { _db = db; }
public JobController(SampleDb context) : base("job", "Check Job") { _context = context; }
public FillOrderCommand(SampleDb context) : base("fillorder", "Add some orders to database") { _context = context; }
public EditOrder(SampleDb context) : base("edit", "Edit last Order entry") { _context = context; }
public QueryAuditTrail(SampleDb context) : base("audit", "Check last AuditTrail entry") { _context = context; }
public QueryOrder(SampleDb context) : base("order", "Check last Order") { _context = context; }
// GET: Home public ActionResult Index() { SampleDb sampleDb = new SampleDb(); return(View(sampleDb.DemotblEmployees.ToList())); }
protected async System.Threading.Tasks.Task Load() { var sampleDbGetProductByIdResult = await SampleDb.GetProductById(Id); product = sampleDbGetProductByIdResult; }