Exemple #1
0
        public async Task <ApiResponse> UpdateYard(TblYard tblYard)
        {
            _context.Entry(tblYard).State = EntityState.Modified;
            try
            {
                await _context.SaveChangesAsync();

                var tblYardlocation = await _context.TblYardLocation.Where(i => i.YardId == tblYard.Id).ToListAsync();

                _context.TblYardLocation.RemoveRange(tblYardlocation);
                await _context.SaveChangesAsync();

                TblYardLocation objYardLocation = new TblYardLocation();
                objYardLocation.YardId              = tblYard.Id;
                objYardLocation.CountryId           = tblYard.CountryId;
                objYardLocation.LocationDiscription = tblYard.LocationDescription;
                _context.TblYardLocation.Add(objYardLocation);
                await _context.SaveChangesAsync();

                var ApiResponse = await response.ApiResult("OK", tblYard, "Data Found");

                return(ApiResponse);
            }
            catch (DbUpdateConcurrencyException ex)
            {
                var ApiResponse = await response.ApiResult("FAILED", ex, "Error in update");

                return(ApiResponse);
            }
        }
Exemple #2
0
        public async Task <ApiResponse> AddYard(TblYard tblYard)
        {
            _context.TblYard.Add(tblYard);
            await _context.SaveChangesAsync();

            TblYardLocation objYardLocation = new TblYardLocation();

            objYardLocation.YardId              = tblYard.Id;
            objYardLocation.CountryId           = tblYard.CountryId;
            objYardLocation.LocationDiscription = tblYard.LocationDescription;
            _context.TblYardLocation.Add(objYardLocation);
            await _context.SaveChangesAsync();

            var ApiResponse = await response.ApiResult("OK", new { id = tblYard.Id }, "Add Yard");

            return(ApiResponse);
        }