public async Task <IActionResult> InsereUsuario([FromBody] InsereUsuarioRequest insereUsuarioRequest) { try { if (insereUsuarioRequest?.Nome?.Length > 0) { var usuario = new Usuario(insereUsuarioRequest.Nome); await _context.AddAsync(usuario); await _context.SaveChangesAsync(); return(Ok(ok)); } return(BadRequest(usuarioNaoExiste)); } catch { return(BadRequest(badRequest)); } }
public async Task <T> AddAsync <T>(T entity) where T : class { try { await _context.AddAsync(entity); } catch (Exception error) { throw error; } return(entity); }
public async Task <ActionResult <SensorLog> > Log(string input) { // The post-request simulates a sensor-trigger and the paramater "input" consists of which section was entered and which section was exited, separated by ".". // Example: "Electronics.Kitchen" says a visitor entered the section "Electronics" and exited the section "Kitchen". // This was my way to handle the fact that if a visitor enters a section, they had to exit another. var enterName = input.Split(".")[0]; var exitName = input.Split(".")[1]; var enterSection = await _context.StoreSections .FirstOrDefaultAsync(ss => ss.Name == enterName); if (enterSection == default) { return(BadRequest(new { Error = $"Section '{enterSection}' does not exists" })); } var exitSection = await _context.StoreSections .FirstOrDefaultAsync(ss => ss.Name == exitName); if (exitSection == default) { return(BadRequest(new { Error = $"Section '{exitSection}' does not exists" })); } // TODO: The visitor count can be less than zero. enterSection.VisitorCount++; exitSection.VisitorCount--; var log = new SensorLog() { TimeStamp = DateTime.Now, EnterStoreSection = enterSection, ExitStoreSection = exitSection, Direction = Direction.Enter }; await _context.AddAsync(log); await _context.SaveChangesAsync(); string warning = ""; if (exitSection.VisitorCount < 0) { warning = $"Warning, section '{exitSection.Name}' has less then 0 visitors. Something is wrong with the sensors, not the code ;)"; } return(Created(Request.HttpContext.Request.Path, new { Log = $"Enter : {enterSection.Name}, Exit : {exitSection.Name}, Time Stamp : {DateTime.Now}", Warning = String.IsNullOrEmpty(warning) ? "No warnings, all good" : warning })); }
private async Task <Person> GetPerson(Command request) { if (!request.Id.HasValue) { var person = new Person(); await _apiContext.AddAsync(person); return(person); } return(await _apiContext .Set <Person>() .FirstOrDefaultAsync(e => e.Id == request.Id)); }
public async Task <Customer> Insert(Customer customer) { try { await _context.AddAsync(customer); await _context.SaveChangesAsync(); return(customer); } catch (Exception) { return(null); } }
public async Task <IActionResult> Register([FromBody] UserModel user) { if (user == null || user.Password == null || user.Email == null) { return(BadRequest("Некоректні дані")); } User u = await _context.Users.FirstOrDefaultAsync(u => u.Email == user.Email); if (u == null) { await _context.AddAsync(new User { Email = user.Email, Username = user.Username, Password = user.Password, Folders = new List <Folder> { new Folder() { Name = "Today", Color = "white", Required = true }, new Folder() { Name = "Tasks", Color = "white", Required = true } } }); await _context.SaveChangesAsync(); var userAuth = await _loginService.AuthenticateUserAsync(user); var tokenString = _loginService.GenerateJSONWebToken(user); return(Ok(new { token = tokenString, expires = Convert.ToInt32(_config["Jwt:ExpiresMinutes"]) })); } else { return(BadRequest("Даний користувач уже існує")); } }
public async Task <int?> StoreDonations(string name, string postcode, int donationAmount) { var donation = new Donations { Name = name, Postcode = postcode, DonationAmount = donationAmount }; var resultAdd = await _apiContext.AddAsync(donation); if (resultAdd.State == Microsoft.EntityFrameworkCore.EntityState.Added) { var resultSave = await _apiContext.SaveChangesAsync(); return(resultSave == 1 ? resultAdd.Entity.Id : (int?)null); } return(null); }
public async Task AddAsync(T item) { await ApiContext.AddAsync(item); }
public async Task <IActionResult> SaveWeatherAsync([FromBody] WeatherForecast model) { await apiContext.AddAsync(model); return(new JsonResult(new { ResponseMessage = "success" })); }
public static async Task Initialize(UserManager <User> userManager, ApiContext context, RoleManager <IdentityRole> roleManager) { string adminEmail = "*****@*****.**"; string password = "******"; if (await userManager.FindByNameAsync(adminEmail) == null) { await roleManager.CreateAsync(new IdentityRole("admin")); await roleManager.CreateAsync(new IdentityRole("lead")); await roleManager.CreateAsync(new IdentityRole("client")); User admin = new User { Email = adminEmail, UserName = adminEmail }; await userManager.CreateAsync(admin, password); await userManager.AddToRoleAsync(admin, "admin"); User lead = new User { Email = "*****@*****.**", UserName = "******", FirstName = "Dustin", LastName = "Carroll" }; await userManager.CreateAsync(lead, password); await userManager.AddToRoleAsync(lead, "lead"); User client = new User { Email = "*****@*****.**", UserName = "******", FirstName = "John", LastName = "Hale" }; await userManager.CreateAsync(client, password); await userManager.AddToRoleAsync(client, "client"); User admin1 = new User { Email = "*****@*****.**", UserName = "******", FirstName = "Douglas", LastName = "Henry" }; await userManager.CreateAsync(admin1, password); await userManager.AddToRoleAsync(admin1, "admin"); User client1 = new User { Email = "*****@*****.**", UserName = "******", FirstName = "Dale", LastName = "Hopkins" }; await userManager.CreateAsync(client1, password); await userManager.AddToRoleAsync(client1, "client"); Region Africa = new Region { Name = "Africa" }; Region Antarctica = new Region { Name = "Antarctica" }; Region AsiaPacific = new Region { Name = "Asia/Pacifig" }; Region Europe = new Region { Name = "Europe" }; Region NorthAmerica = new Region { Name = "North America" }; Region SouthAmerica = new Region { Name = "South America" }; await context.Regions.AddRangeAsync(Africa, Antarctica, AsiaPacific, Europe, NorthAmerica, SouthAmerica); Country Australia = new Country { Capital = "Canberra", Name = "Australia", Region = AsiaPacific }; Country Germany = new Country { Capital = "Berlin", Name = "Germany", Region = Europe }; Country Slovakia = new Country { Capital = "Bratislava", Name = "Slovakia", Region = Europe }; Country USA = new Country { Capital = "Washington", Name = "Unated States", Region = NorthAmerica }; Country TM = new Country { Capital = "Ashgabat", Name = "Turkmenistan", Region = AsiaPacific }; await context.Countries.AddRangeAsync(Australia, Germany, Slovakia, USA); CompanyQualification Qualified = new CompanyQualification { QualificationName = "Qualified" }; CompanyQualification NotQualified = new CompanyQualification { QualificationName = "NotQualified" }; CompanyQualification NewCompany = new CompanyQualification { QualificationName = "NewCompany" }; await context.CompanyQualifications.AddRangeAsync(Qualified, NotQualified, NewCompany); Linkedin SlastininLinkedin = new Linkedin { FullLink = "linkedin.com/in/aleksandr-slastinin-379654183/" }; Linkedin TTRLinkedin = new Linkedin { FullLink = "linkedin.com/company/turkmen-tranzit/" }; Linkedin TTWLinkedin = new Linkedin { FullLink = "linkedin.com/company/ttweb/" }; await context.Linkedins.AddRangeAsync(SlastininLinkedin, TTRLinkedin, TTWLinkedin); await context.SaveChangesAsync(); Contact contact1 = new Contact { Email = "*****@*****.**" }; Contact contact2 = new Contact { Email = "*****@*****.**" }; Contact contact3 = new Contact { Email = "*****@*****.**" }; Contact contact4 = new Contact { Email = "*****@*****.**" }; Contact contact5 = new Contact { Email = "*****@*****.**" }; Contact contact6 = new Contact { Email = "*****@*****.**" }; Contact contact7 = new Contact { Email = "*****@*****.**" }; Contact contact8 = new Contact { Email = "*****@*****.**" }; Contact contact9 = new Contact { Email = "*****@*****.**" }; Contact contact10 = new Contact { Email = "*****@*****.**" }; Contact contact11 = new Contact { Email = "*****@*****.**" }; Contact contact12 = new Contact { Email = "*****@*****.**" }; Contact TtrContact1 = new Contact { Email = "*****@*****.**", FirstName = "Aleksandr", Position = "department head", Surname = "Slastinin", Linkedin = SlastininLinkedin }; Contact TtrContact2 = new Contact { Email = "*****@*****.**" }; Contact TtrContact3 = new Contact { Email = "*****@*****.**" }; Contact TtwebContact1 = new Contact { Email = "*****@*****.**", FirstName = "Irada", Position = "Project Manager", Surname = "davletowa", }; Contact TtwebContact2 = new Contact { Email = "*****@*****.**" }; Contact TtwebContact3 = new Contact { Email = "*****@*****.**" }; await context.Contacts.AddRangeAsync(contact1, contact2, contact3, contact4, contact5, contact6, contact7, contact8, contact9, contact10, contact11, contact12, TtrContact1, TtrContact2, TtrContact3, TtwebContact1, TtwebContact2, TtwebContact3); await context.SaveChangesAsync(); Company ACN = new Company { CompanyLegalName = "ATM ATM Pty Ltd", HGBasedInCountry = Australia, Qualification = Qualified, TradingName = "A.C.N.", Website = "b24.turkmen-tranzit.com" }; await context.Companies.AddAsync(ACN); CompanyContactLink ContactACN1 = new CompanyContactLink { Company = ACN, Contact = contact1 }; CompanyContactLink ContactACN2 = new CompanyContactLink { Company = ACN, Contact = contact2 }; CompanyContactLink ContactACN3 = new CompanyContactLink { Company = ACN, Contact = contact3 }; await context.CompanyContactLinks.AddRangeAsync(ContactACN1, ContactACN2, ContactACN3); Company ATM = new Company { CompanyLegalName = "A.C.N. 605 479 678 Pty Ltd", HGBasedInCountry = Australia, Qualification = Qualified, TradingName = "ATM", LeadOwner = lead, QualifiedDate = DateTime.Now, Website = "ttweb.org/blog" }; await context.Companies.AddAsync(ATM); CompanyContactLink ContactATM1 = new CompanyContactLink { Company = ATM, Contact = contact4 }; CompanyContactLink ContactATM2 = new CompanyContactLink { Company = ATM, Contact = contact5 }; CompanyContactLink ContactATM3 = new CompanyContactLink { Company = ATM, Contact = contact6 }; await context.CompanyContactLinks.AddRangeAsync(ContactATM1, ContactATM2, ContactATM3); Company Pay = new Company { CompanyLegalName = "24-pay s.r.o", HGBasedInCountry = Australia, Qualification = NotQualified, TradingName = "24 Pay SRO", LeadOwner = lead, Website = "24-pay.sk" }; await context.Companies.AddAsync(Pay); CompanyContactLink ContactPay1 = new CompanyContactLink { Company = Pay, Contact = contact7 }; CompanyContactLink ContactPay2 = new CompanyContactLink { Company = Pay, Contact = contact8 }; CompanyContactLink ContactPay3 = new CompanyContactLink { Company = Pay, Contact = contact9 }; await context.CompanyContactLinks.AddRangeAsync(ContactPay1, ContactPay2, ContactPay3); Company Ttz = new Company { CompanyLegalName = "HO ''Turkmen-Tranzit''", HGBasedInCountry = TM, Qualification = NewCompany, TradingName = "Turkmen-Tranzit", Website = "Turkmen-Tranzit.com", CompanyLinkedin = TTRLinkedin }; await context.Companies.AddAsync(Ttz); CompanyContactLink ContactTtz1 = new CompanyContactLink { Company = Ttz, Contact = TtrContact1 }; CompanyContactLink ContactTtz2 = new CompanyContactLink { Company = Ttz, Contact = TtrContact2 }; CompanyContactLink ContactTtz3 = new CompanyContactLink { Company = Ttz, Contact = TtrContact3 }; await context.CompanyContactLinks.AddRangeAsync(ContactTtz1, ContactTtz2, ContactTtz3); await context.SaveChangesAsync(); Company Ttw = new Company { CompanyLegalName = "HO ''Turkmen-Tranzit'' -> TTWeb", HGBasedInCountry = TM, Qualification = Qualified, TradingName = "TtWeb", Website = "Ttweb.org", CompanyLinkedin = TTWLinkedin }; await context.Companies.AddAsync(Ttw); CompanyContactLink ContactTtw1 = new CompanyContactLink { Company = Ttw, Contact = TtwebContact1 }; CompanyContactLink ContactTtw2 = new CompanyContactLink { Company = Ttw, Contact = TtwebContact2 }; CompanyContactLink ContactTtw3 = new CompanyContactLink { Company = Ttw, Contact = TtwebContact3 }; await context.CompanyContactLinks.AddRangeAsync(ContactTtw1, ContactTtw2, ContactTtw3); await context.SaveChangesAsync(); Company google = new Company { CompanyLegalName = "google", HGBasedInCountry = USA, Qualification = Qualified, TradingName = "google", Website = "google.com" }; await context.Companies.AddAsync(google); CompanyContactLink ContactGoogle1 = new CompanyContactLink { Company = google, Contact = contact10 }; CompanyContactLink ContactGoogle2 = new CompanyContactLink { Company = google, Contact = contact11 }; CompanyContactLink ContactGoogle3 = new CompanyContactLink { Company = google, Contact = contact12 }; await context.CompanyContactLinks.AddRangeAsync(ContactGoogle1, ContactGoogle2, ContactGoogle3); Company microsoft = new Company { CompanyLegalName = "microsoft", HGBasedInCountry = USA, Qualification = Qualified, TradingName = "microsoft", Website = "microsoft.com" }; await context.Companies.AddAsync(microsoft); AdvertisingCompany advertisingCompany = new AdvertisingCompany { Id = "cam_r7jfwbKo46XiS9okW", Name = "ttweb" }; await context.AddAsync(advertisingCompany); await context.SaveChangesAsync(); } }