public async Task <IActionResult> PutRecord(int id, Record record)
        {
            if (id != record.Id)
            {
                return(BadRequest());
            }

            _context.Entry(record).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!RecordExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Beispiel #2
0
        public async Task <IActionResult> Create([Bind("UserId,FirstName,Surname,RentedRecords")] User user)
        {
            if (ModelState.IsValid)
            {
                _context.Add(user);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(user));
        }
        public async Task <IActionResult> Create([Bind("Id,RecordName,Artist,ReleaseDate,IsRented,RentDate")] Record @record)
        {
            if (ModelState.IsValid)
            {
                _context.Add(@record);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(@record));
        }
Beispiel #4
0
        public async Task <IActionResult> Create([Bind("ArtistId,ArtistName")] Artist artist)
        {
            if (ModelState.IsValid)
            {
                _context.Add(artist);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(artist));
        }
Beispiel #5
0
        public async Task <IActionResult> Create([Bind("CdId,CdName,ArtistId,ArtistName")] Record @record)
        {
            if (ModelState.IsValid)
            {
                _context.Add(@record);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            ViewData["ArtistId"] = new SelectList(_context.Artist, "ArtistId", "ArtistId", @record.ArtistId);
            return(View(@record));
        }
        public async Task <Record> UpsertRecord(Record record)
        {
            var result = await FindRecord(record.ApplicationName, record.DataType, record.Version);

            if (result != null)
            {
                result.DateModified = DateTime.UtcNow;
                result.Value        = record.Value;
            }
            else
            {
                result             = record;
                record.DateCreated = DateTime.UtcNow;
                _db.Records.Add(record);
            }

            await _db.SaveChangesAsync();

            return(result);
        }
Beispiel #7
0
        public async Task <ActionResult <ResponseDTO> > PutRecord(long id, RecordDTO recordDTO)
        {
            var record = await _context.Records.FindAsync(id);

            record.Type                  = recordDTO.Type == null ? record.Type : recordDTO.Type;
            record.Description           = recordDTO.Description == null ? record.Description : recordDTO.Description;
            record.ProblemType           = recordDTO.ProblemType == null ? record.ProblemType : recordDTO.ProblemType;
            record.IsTraining            = recordDTO.IsTraining == null ? record.IsTraining : recordDTO.IsTraining;
            record.Title                 = recordDTO.Title == null ? record.Title : recordDTO.Title;
            record.IdSupervisedArea      = recordDTO.IdSupervisedArea == null ? record.IdSupervisedArea : recordDTO.IdSupervisedArea;
            record.IdDrone               = recordDTO.IdDrone == null ? record.IdDrone : recordDTO.IdDrone;
            record.IdCampaign            = recordDTO.IdCampaign == null ? record.IdCampaign : recordDTO.IdCampaign;
            record.IdFlightPath          = recordDTO.IdFlightPath == null ? record.IdFlightPath : recordDTO.IdFlightPath;
            record.Longitude             = recordDTO.Longitude == null ? record.Longitude : recordDTO.Longitude;
            record.Latitude              = recordDTO.Latitude == null ? record.Latitude : recordDTO.Latitude;
            record.MonitoredObjectId     = recordDTO.MonitoredObjectId == null ? record.MonitoredObjectId : recordDTO.MonitoredObjectId;
            record.MetaData              = recordDTO.MetaData == null ? record.MetaData : recordDTO.MetaData;
            _context.Entry(record).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!RecordExists(id))
                {
                    return(new ResponseDTO("Không tồn tại ", 404));
                }
                else
                {
                    throw;
                }
            }

            return(new ResponseDTO("Update thành công", 200, record));
        }
Beispiel #8
0
        public async Task <Mute> AddMuteAsync(Mute mute)
        {
            if (_db == null)
            {
                _db = new RecordContext();
            }
            await _db.Database.EnsureCreatedAsync();

            var entry = await _db.Mutes.AddAsync(mute);

            await _db.SaveChangesAsync();

            return(entry.Entity);
        }
Beispiel #9
0
 public async Task <string> SaveRecord(Record record)
 {
     if (await _context.Records.AnyAsync(r => r.Contact == record.Contact && r.ServiceType == record.ServiceType))
     {
         return("Already exists");
     }
     if (record.StateId > 0)
     {
         record.StateName = _stateCityService.GetStates().FirstOrDefault(s => s.Id == record.StateId)?.Name;
     }
     if (record.CityId > 0)
     {
         record.CityName = _stateCityService.GetCities().FirstOrDefault(s => s.Id == record.CityId)?.Name;
     }
     _context.Records.Add(record);
     if (await _context.SaveChangesAsync() > 0)
     {
         return("");
     }
     return("Record could not be saved");
 }