public static void CreateStudent() { using (var context = new EFContext()) { User user = new User(); user.UserType = UserTypeEnum.Student; Student toAdd = new Student(); toAdd.FirstName = "Dennis"; toAdd.LastName = "Nyberg"; toAdd.Birthdate = new DateTime(1995, 2, 16); toAdd.User = user; context.Add(toAdd); User user1 = new User(); user1.UserType = UserTypeEnum.Student; Student toAdd1 = new Student(); toAdd1.FirstName = "Erik"; toAdd1.LastName = "Häregård"; toAdd1.Birthdate = new DateTime(1997, 2, 9); toAdd1.User = user1; context.Add(toAdd1); context.SaveChanges(); } }
public async Task GetApproverName_IPM() { //Arrange var costId = Guid.NewGuid(); var cost = new Cost { Id = costId }; var approverUserId = Guid.NewGuid(); var expectedApproverName = "John Connor"; var approverUser = new CostUser { Id = approverUserId, FullName = expectedApproverName }; var approvalType = "IPM"; _efContext.Add(approverUser); _efContext.Add(cost); _efContext.SaveChanges(); //Act var result = await _costUserService.GetApprover(costId, approverUserId, approvalType); //Assert result.Should().NotBeNull(); result.Should().Be(expectedApproverName); }
private static void InsertProduct() { // Create a new instance of the DbContext class. using (var db = new EFContext()) { // Create a new instance of the domain class product and assign values to its properties. Product product = new Product { Name = "Pen Drive" }; // add it to the DbContext class so that Context becomes aware of the entity. db.Add(product); product = new Product { Name = "Memory Card" }; // add it to the DbContext class so that Context becomes aware of the entity. db.Add(product); // call the saveChanges method of the DBContext to persist the changes to the database. db.SaveChanges(); } return; }
public async Task <IActionResult> CreateChannel([Bind("ID,Name,Color")] ChannelModel channelModel) { if (ModelState.IsValid) { _context.Add(channelModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(channelModel)); }
public async Task <IActionResult> Create([Bind("ID,Nome,Duracao,Caminho,IdGeneros")] Series series) { if (ModelState.IsValid) { _context.Add(series); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["IdGeneros"] = new SelectList(_context.generos, "Id", "Id", series.IdGeneros); return(View(series)); }
public List <int> CreateInvoices(int idUser, List <int> idAllocatedTimes) { using (IDbContextTransaction transaction = _context.Database.BeginTransaction()) { try { IEnumerable <AllocatedTime> allocatedTimes = _projectService.GetAllocatedTimes().Where(at => at.Project.User.Id == idUser && idAllocatedTimes.Any(idt => idt == at.Id)); if (allocatedTimes == null) { throw new NotFoundException(); } if (allocatedTimes.Any(at => at.Invoice != null) || allocatedTimes.Any(at => at.EndDate == null)) { throw new Exception("In the allocated times set to be invoiced there are invalid items"); } var allocatedTimesGroupedByCustomerList = allocatedTimes.GroupBy(at => at.Project.CustomerId).Select(atg => new { customerId = atg.Key, amount = atg.Sum(s => (decimal)s.EndDate.Value.Subtract(s.StartDate).TotalHours) }); List <Invoice> newInvoiceList = new List <Invoice>(); foreach (var allocatedTimesGroupedByCustomer in allocatedTimesGroupedByCustomerList) { Invoice invoice = new Invoice(); invoice.CustomerId = allocatedTimesGroupedByCustomer.customerId; invoice.Status = INVOICESTATUS.CREATED; _context.Add(invoice); newInvoiceList.Add(invoice); InvoiceLine invoiceLine = new InvoiceLine { Invoice = invoice, Amount = allocatedTimesGroupedByCustomer.amount }; //invoiceLine.InvoiceId = invoice.Id; _context.Add(invoiceLine); } _context.SaveChanges(); transaction.Commit(); return(newInvoiceList.Select(i => i.Id).ToList()); } catch (Exception ex) { transaction.Rollback(); throw ex; } } }
public async Task <IActionResult> Create(int?id, [Bind("DescripcionAtencion")] Evolucion evolucion) { if (ModelState.IsValid) { evolucion.Medico = User.Identity.Name; evolucion.FechaYHora = DateTime.Now; evolucion.EstadoAbierto = true; evolucion.EpisodioId = (int)id; Episodio e = _context.Episodios.Where(e => e.Id == id).FirstOrDefault(); evolucion.Episodio = e; evolucion.Notas = new List <Nota>(); if (e.Evoluciones == null) { e.Evoluciones = new List <Evolucion>(); } e.Evoluciones.Add(evolucion); _context.Add(evolucion); await _context.SaveChangesAsync(); return(RedirectToAction("Index", new { id })); } return(View(evolucion)); }
private void Button_Click_1(object sender, RoutedEventArgs e) { cat.EnableValidation = true; if (string.IsNullOrEmpty(cat.Error)) { if (!string.IsNullOrEmpty(file_selected)) { string ext = Path.GetExtension(file_selected); string fileName = Path.GetRandomFileName() + ext; string fileSavePath = Path.Combine(Directory.GetCurrentDirectory(), "images", fileName); var bmp = ResizeImage.ResizeOrigImg( new Bitmap(System.Drawing.Image.FromFile(file_selected)), 75, 75); bmp.Save(fileSavePath, ImageFormat.Jpeg); file_name = fileSavePath; } var cat_info = new AppCat { Name = tbname.Text, Birth = (DateTime)bdcat.SelectedDate, Description = tbdesc.Text, Gender = cbitem.Text.ToString(), Image = file_name }; cat_info.AppCatPrices = new List <AppCatPrice> { new AppCatPrice { CatId = cat_info.Id, DateCreate = DateTime.Now, Price = decimal.Parse(tbprice.Text) } }; _cats.Add(new CatVM { Id = cat_info.Id.ToString(), Name = cat_info.Name, Birthday = cat_info.Birth, Description = cat_info.Description, Image = cat_info.Image }); _context.Add(cat_info); _context.SaveChanges(); Close(); } else { MessageBox.Show(cat.Error); } }
/// <summary> /// Create data - the C in CRUD /// </summary> public static void CreateItem() { using (var context = new EFContext()) { string[] lines = File.ReadAllLines(filePath); foreach (var filePosts in lines) { rowsAffected++; string[] fields = filePosts.Split(','); //Seperates date and timespan + each post. var databaseInput = new Temperature(); DateTime date = DateTime.Parse(fields[0]); string place = fields[1]; double? temp = double.Parse(fields[2], CultureInfo.InvariantCulture); int? humidity = int.Parse(fields[3]); databaseInput.Date = date; databaseInput.Place = place; databaseInput.Temp = temp; databaseInput.Humidity = humidity; context.Add(databaseInput); } context.SaveChanges(); Console.WriteLine($"Seeding complete. {rowsAffected} rows affected"); } }
public async Task IsValidForSubmission_When_Invalid_Should_SendNotificationToSupportTeam() { // Arrange var costId = Guid.NewGuid(); const string message = "Any message"; const string costNumber = "PO12312313"; EFContext.Add(new Cost { Id = costId, CostNumber = costNumber }); EFContext.SaveChanges(); CostBuilderMock.Setup(cb => cb.IsValidForSubmittion(costId)).ReturnsAsync(new OperationResponse(false, message)); // Act var result = await CostService.IsValidForSubmission(User, costId); // Assert result.Should().NotBeNull(); result.Success.Should().Be(false); SupportNotificationServiceMock.Verify(sn => sn.SendSupportSubmissionFailedNotification(costNumber, null), Times.Once); }
public async Task <IActionResult> Create(int?id, [Bind("Mensaje")] Nota nota) { if (ModelState.IsValid) { nota.NombreAutor = User.Identity.Name; nota.FechaYHora = DateTime.Now; nota.EvolucionId = (int)id; var evolucion = await _context.Evoluciones.FindAsync(id); nota.Evolucion = evolucion; if (evolucion.Notas == null) { evolucion.Notas = new List <Nota>(); } evolucion.Notas.Add(nota); _context.Add(nota); await _context.SaveChangesAsync(); return(RedirectToAction("Index", new { id })); } ViewData["EvolucionId"] = new SelectList(_context.Evoluciones, "Id", "Id", nota.EvolucionId); return(View(nota)); }
static void insertProduct() { using (var db = new EFContext()) { Product product = new Product(); product.Name = "Pen Drive"; db.Add(product); product = new Product(); product.Name = "Memory Card"; db.Add(product); db.SaveChanges(); } return; }
private async Task <Guid> GetDictionaryEntryId(string dictionaryName, string value) { var root = await GetRootModule(); var dictionary = await EFContext.Dictionary.FirstOrDefaultAsync(d => d.Name == dictionaryName); if (dictionary == null) { dictionary = new Dictionary { Name = dictionaryName, AbstractTypeId = root.Id }; EFContext.Add(dictionary); await EFContext.SaveChangesAsync(); } var entry = await EFContext.DictionaryEntry.FirstOrDefaultAsync(de => de.DictionaryId == dictionary.Id && de.Key == value); if (entry == null) { entry = new DictionaryEntry { DictionaryId = dictionary.Id, Key = value }; EFContext.DictionaryEntry.Add(entry); await EFContext.SaveChangesAsync(); } return(entry.Id); }
public async Task <IActionResult> Create([Bind("Descripcion,Recomendacion,EpicrisisId")] Diagnostico diagnostico) { if (ModelState.IsValid) { var epicrisis = await _context.Epicrisis .FirstOrDefaultAsync(m => m.Id == diagnostico.EpicrisisId); diagnostico.Epicrisis = epicrisis; if (User.IsInRole("Empleado")) { diagnostico.Recomendacion = "CIERRE ADMINISTRATIVO"; } var episodio = await _context.Episodios .FirstOrDefaultAsync(m => m.Id == epicrisis.EpisodioId); episodio.FechaYHoraCierre = DateTime.Now; _context.Update(episodio); _context.Add(diagnostico); await _context.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } return(View()); }
private Agency CreateAgency(string name, bool prime) { var agency = new Agency { Name = name, CountryId = _country.Id, GdamAgencyId = name, Labels = prime ? new [] { PgOwnerLabel } : new string[0], PrimaryCurrency = _defaultCurrecy.Id }; if (prime) { agency.AbstractTypes = new List <AbstractType> { new AbstractType { ObjectId = agency.Id, Parent = _module, Type = AbstractObjectType.Agency.ToString() } }; } EFContext.Add(agency); return(agency); }
public IActionResult Create([FromBody] CreateUserDTO createUser) { var user = new User(); user.Id = createUser.UserId; user.Username = createUser.User; user.Password = Guid.NewGuid().ToString(); _context.Add(user); _context.SaveChanges(); return(new ObjectResult(createUser.User) { StatusCode = (int)HttpStatusCode.Created }); /* * if (_users.TryAdd(createUser.UserId, createUser.User)) * { * return new ObjectResult(createUser.User) * { * StatusCode = (int) HttpStatusCode.Created * }; * } * return BadRequest("Usuário já existe."); */ }
static void insertProduct() { using (var db = new EFContext()) { Product product = new Product(); product.Name = "Good Drive"; db.Add(product); product = new Product(); product.Name = "Memory Card"; db.Add(product); db.SaveChanges(); Console.WriteLine("Inserted 2 new products"); } return; }
public async Task <int> CreateAsync(FieldDTO dto) { var entity = dto.ConvertToEntity(); _context.Add(entity); await _context.SaveChangesAsync(); return(entity.Id); }
public async Task <int> CreateAsync(ClassificationCriterionDTO dto) { var entity = dto.ConvertToEntity(); _context.Add(entity); await _context.SaveChangesAsync(); return(entity.Id); }
protected void SetupDataSharedAcrossTests(Agency agency, Country country, Cost cost, CostStageRevision latestRevision, Project project, CostUser costOwner, Guid costOwnerId, CostStage costStage, Brand brand, Guid costId, Guid costStageRevisionId, Guid projectId, string budgetRegion = Constants.BudgetRegion.AsiaPacific) { agency.Country = country; cost.CostNumber = CostNumber; cost.LatestCostStageRevision = latestRevision; cost.Project = project; costOwner.Agency = agency; costOwner.Id = costOwnerId; latestRevision.CostStage = costStage; project.Brand = brand; agency.Name = AgencyName; brand.Name = BrandName; cost.Id = costId; costStage.Name = CostStageName.ToString(); costOwner.FullName = CostOwnerFullName; costOwner.GdamUserId = CostOwnerGdamUserId; latestRevision.Id = costStageRevisionId; project.Id = projectId; project.Name = ProjectName; project.GdamProjectId = ProjectGdamId; project.AdCostNumber = ProjectNumber; country.Name = AgencyLocation; var stageDetails = new PgStageDetailsForm { ContentType = new core.Builders.DictionaryValue { Id = Guid.NewGuid(), Key = ContentType }, CostType = cost.CostType.ToString(), ProductionType = new core.Builders.DictionaryValue { Id = Guid.NewGuid(), Key = CostProductionType }, Title = CostTitle, AgencyTrackingNumber = AgencyTrackingNumber, BudgetRegion = new AbstractTypeValue { Key = budgetRegion, Name = budgetRegion } }; var existingUser = EFContext.CostUser.FirstOrDefault(a => a.GdamUserId == CostOwnerGdamUserId); if (existingUser == null) { EFContext.Add(costOwner); EFContext.SaveChanges(); } CostStageRevisionServiceMock.Setup(csr => csr.GetStageDetails <PgStageDetailsForm>(costStageRevisionId)).ReturnsAsync(stageDetails); }
public IActionResult Signup([FromBody] UserModel model) { _context.Add(new User { Gmail = model.Gmail, Name = model.Name, Password = model.Password }); _context.SaveChanges(); return(Ok()); }
public IActionResult Create(Pessoa pessoa) { if (ModelState.IsValid) { _context.Add(pessoa); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(pessoa)); }
public IActionResult NovoCarro(Carro carro) { if (ModelState.IsValid) { contexto.Add(carro); contexto.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View()); }
public async Task <int> SaveLightInfo(TNL_TunnelLight tunnelLight) { try { using (var context = new EFContext()) { //var light = (from d in context.TNL_TunnelLights // where d.TunnelLight_ID == 1000044L && d.DeviceId != null // select d).FirstOrDefault(); TNL_TunnelLight light = null; if (light == null) { light = new TNL_TunnelLight(); light.TunnelLight_ID = await DataBaseHelper.GetKey("TNL_TunnelLight", "TunnelLight_ID"); } light.TunnelLight_ID = -1; light.TunnelSection_ID = -1; light.TunnelGateway_ID = -1; light.Tunnel_ID = -1; light.LightPhysicalAddress_TX = string.Empty; light.LightLocationNumber_NR = -1; light.LightUsage_NR = -1; light.GroupNumber_TX = string.Empty; light.LightFunction_NR = -1; light.LightSource_NR = -1; light.LampType_NR = -1; light.DimmingFactor_NR = 1; light.DefaultDimmingValue_NR = 1; light.PowerOnDimmingValue_NR = 1; light.MaximumDimmingValue_NR = 1; light.MinimumDimmingValue_NR = 1; light.Active_YN = '0'; light.EnablePIRFunction_YN = '0'; light.PIRLastTimeMinutesOfDimming_NR = -1; light.PIRRestoreTime_NR = -1; light.PIRGroupNumber_NR = -1; light.PIRIdleDimmingValue_NR = -1; light.PIRDimmingValue_NR = -1; light.PIRTTL_NR = -1; light.LightConfig_ID = -1; light.LightTimeControl_ID = -1; light.PIRSensorPlan_ID = -1; context.Add(light); return(await context.SaveChangesAsync()); } } catch (Exception) { throw; } }
public async Task <IActionResult> Create([Bind("Code,Model,Manufacturer,WTC,ID,IsDeleted,CreationDate,ModifiedDate,DeletedDate")] AircraftType aircraftType) { if (ModelState.IsValid) { _context.Add(aircraftType); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(aircraftType)); }
public async Task <IActionResult> Create([Bind("ReceitaId,Valor,Descricao,Pago,ReceitaFixa,ReceitaParcelada,QtdParcelas,Observacao,DhReceita")] Receita receita) { if (ModelState.IsValid) { _context.Add(receita); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(receita)); }
public async Task <IActionResult> Create([Bind("TarefasId,Nome,Descricao,Inicio,Fim,Importancia")] Tarefas tarefas) { if (ModelState.IsValid) { _context.Add(tarefas); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tarefas)); }
public async Task <IActionResult> Create([Bind("id,FirstName,LastName,Company,Email,PhoneNumber")] Contact contact) { if (ModelState.IsValid) { _context.Add(contact); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(contact)); }
public async Task <IActionResult> Create([Bind("Id,Nome")] Generos generos) { if (ModelState.IsValid) { _context.Add(generos); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(generos)); }
public async Task <IActionResult> Create([Bind("BlogId,Url")] Blog blog) { if (ModelState.IsValid) { _context.Add(blog); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(blog)); }