Escali License control 1
SegmentService.cs
Gå til dokumentasjonen til denne filen.
3using Microsoft.EntityFrameworkCore;
4
6{
7
11public class SegmentService
12{
13
14 private readonly DataContext _db;
15
17 {
18 _db = db;
19 }
20
25 public async Task<List<Segment>> GetAllSegments()
26 {
27 var res = await _db.Segments.ToListAsync();
28 return res;
29 }
30
37 public async Task<Segment> GetSegmentById(int id)
38 {
39 var res = await _db.Segments.FindAsync(id);
40 return res;
41 }
42
50 public async Task<Segment> AddSegment(Segment segment)
51 {
52 if (_db.Segments.Any(s => s.SegmentName == segment.SegmentName))
53 throw new InvalidOperationException($"Segmnet name already exist");
54
55 var res = _db.Segments.Add(segment);
56 await _db.SaveChangesAsync();
57 return res.Entity;
58 }
59
67 public async Task<Segment> UpdateSegment(Segment segment)
68 {
69 if (_db.Segments.Any(s => s.SegmentName == segment.SegmentName && s.MainSegmentSeq == segment.MainSegmentSeq))
70 throw new InvalidOperationException("Could not update segment");
71
72 var res = _db.Segments.Update(segment);
73 await _db.SaveChangesAsync();
74 return res.Entity;
75 }
76
77}
78
79}
SegmentService class inserts and updates Segment in the Database
async Task< Segment > UpdateSegment(Segment segment)
Updates changes on a Segment in the database
async Task< Segment > AddSegment(Segment segment)
Adds a Segment to the database
async Task< Segment > GetSegmentById(int id)
Read one Segment with id from database
async Task< List< Segment > > GetAllSegments()
Read all Segments from database