public ErrorDto SubmitReservaton(int reservationId) { using (var db = new MusicBandAppEntities()) { db.Rezervacija.Where(x => x.id_rezervacija == reservationId).FirstOrDefault().status_rezervacije = 2; db.SaveChanges(); return(new ErrorDto()); } }
public ErrorDto AddMember(int bandId, int memberId) { using (var db = new MusicBandAppEntities()) { db.Osoba.Where(x => x.id_osoba == memberId).FirstOrDefault().id_bend = bandId; db.SaveChanges(); return(new ErrorDto()); } }
public ErrorDto DeleteInventory(int inventoryId) { using (var db = new MusicBandAppEntities()) { db.PopisOpreme.Remove(db.PopisOpreme.FirstOrDefault(x => x.id_oprema == inventoryId)); db.SaveChanges(); return(new ErrorDto()); } }
public ErrorDto DeleteSong(int bandId, int songId) { using (var db = new MusicBandAppEntities()) { var band = db.Bend.Where(x => x.id_bend == bandId).FirstOrDefault(); band.Pjesma1.Remove(band.Pjesma1.FirstOrDefault(x => x.id_pjesma == songId)); db.SaveChanges(); return(new ErrorDto()); } }
public ErrorDto AddBandSong(int bandId, int songId) { using (var db = new MusicBandAppEntities()) { var song = db.Pjesma.FirstOrDefault(x => x.id_pjesma == songId); db.Bend.FirstOrDefault(x => x.id_bend == bandId).Pjesma1.Add(song); db.SaveChanges(); return(new ErrorDto()); } }
public List <BandDto> GetAllBands() { using (var db = new MusicBandAppEntities()) { var response = new List <BandDto>(); foreach (var band in db.Bend) { response.Add(MapBand(band)); } return(response); } }
public ErrorDto AddInventory(InventoryDto inventory) { using (var db = new MusicBandAppEntities()) { db.PopisOpreme.Add(new PopisOpreme() { naziv = inventory.Name, cijena = inventory.Price, id_bend = inventory.BandId }); db.SaveChanges(); return(new ErrorDto()); } }
public AccountDto Login(string mail, string password) { using (var db = new MusicBandAppEntities()) { var user = db.Osoba.Where(x => x.mail == mail && x.tip_korisnika != 3); var responseDto = new AccountDto(); if (user.Count() > 1) { responseDto.Errors.Add(new ErrorDto() { ErrorCode = (int)ValidationStatusCode.ResultsetHasMoreItems }); } else if (user.Any()) { var loggedUser = user.First(); var pswd = loggedUser.lozinka.Decrypt(); if (string.Compare(pswd, password) != 0) { responseDto.Errors.Add(new ErrorDto() { ErrorCode = (int)ValidationStatusCode.ResultsetHasMoreItems }); } else { responseDto.Address = loggedUser.adresa; responseDto.AccountType = loggedUser.tip_korisnika; responseDto.City = loggedUser.mjesto; responseDto.Gender = loggedUser.spol; responseDto.Mail = loggedUser.mail; responseDto.Name = loggedUser.ime; responseDto.Surname = loggedUser.prezime; responseDto.AccountFounded = true; responseDto.Id = loggedUser.id_osoba; } } else { responseDto.Errors.Add(new ErrorDto() { ErrorCode = (int)ValidationStatusCode.UserDoesNotExists }); } return(responseDto); } }
public ErrorDto AddCharge(FinanceDto finance) { using (var db = new MusicBandAppEntities()) { db.Financije.Add(new Financije() { id_bend = finance.BandId, iznos = finance.Price, naziv = finance.Name, opis = finance.Note }); db.SaveChanges(); return(new ErrorDto()); } }
public ErrorDto AddSong(SongDto song) { using (var db = new MusicBandAppEntities()) { db.Pjesma.Add(new Pjesma() { godina_izdanja = song.Year, id_zanr = song.Genre.Id, izvodac = song.Performer, naziv = song.Name, trajanje = song.Duration }); db.SaveChanges(); return(new ErrorDto()); } }
public ErrorDto CreateReservation(ReservationDto reservation) { using (var db = new MusicBandAppEntities()) { db.Rezervacija.Add(new Rezervacija() { status_rezervacije = 1, id_osoba = reservation.UserId, id_bend = reservation.BandId, napomena = reservation.Note, datum_od = reservation.DateFrom, datum_do = reservation.DateTo }); db.SaveChanges(); return(new ErrorDto()); } }
public List <GenreDto> GetGenres() { using (var db = new MusicBandAppEntities()) { var responseDto = new List <GenreDto>(); foreach (var genre in db.Zanr) { responseDto.Add(new GenreDto() { Id = genre.id_zanr, Description = genre.opis, Name = genre.naziv }); } return(responseDto); } }
public List <AccountDto> GetBandMembers(int bandId) { using (var db = new MusicBandAppEntities()) { var responseDto = new List <AccountDto>(); foreach (var account in db.Osoba.Where(x => x.id_bend == bandId)) { responseDto.Add(new AccountDto() { Id = account.id_osoba, Name = account.ime, Surname = account.prezime, Gender = account.spol, Mail = account.mail }); } return(responseDto); } }
public ErrorDto DeleteBand(int bandId) { using (var db = new MusicBandAppEntities()) { var responseDto = new ErrorDto(); var band = db.Bend.Where(x => x.id_bend == bandId); if (band.Count() > 1) { responseDto.ErrorCode = (int)ValidationStatusCode.ResultsetHasMoreItems; } else { band.FirstOrDefault().tip_korisnika = 3; db.SaveChanges(); } return(responseDto); } }
public List <InventoryDto> GetInventory(int bandId) { using (var db = new MusicBandAppEntities()) { var responseDto = new List <InventoryDto>(); foreach (var inventory in db.PopisOpreme.Where(x => x.id_bend == bandId)) { responseDto.Add(new InventoryDto() { BandId = inventory.id_bend, Id = inventory.id_oprema, Name = inventory.naziv, Price = inventory.cijena }); } return(responseDto); } }
public List <FinanceDto> GetBandFinanceStatus(int bandId) { using (var db = new MusicBandAppEntities()) { var responseDto = new List <FinanceDto>(); foreach (var item in db.Financije.Where(x => x.id_bend == bandId)) { responseDto.Add(new FinanceDto() { BandId = item.id_bend, Id = item.id_trosak, Name = item.naziv, Note = item.opis, Price = item.iznos }); } return(responseDto); } }
public BandDto GetBand(string mail, string password) { using (var db = new MusicBandAppEntities()) { var account = db.Bend.Where(x => x.e_mail == mail && x.tip_korisnika != 3); var responseDto = new BandDto(); if (account.Count() > 1) { responseDto.Errors.Add(new ErrorDto() { ErrorCode = (int)ValidationStatusCode.ResultsetHasMoreItems }); } else if (account.Any()) { var str = account.First().lozinka.Decrypt(); if (string.Compare(str, password) != 0) { responseDto.Errors.Add(new ErrorDto() { ErrorCode = (int)ValidationStatusCode.UserDoesNotExists }); } else { responseDto = MapBand(account.First()); } } else { responseDto.Errors.Add(new ErrorDto() { ErrorCode = (int)ValidationStatusCode.UserDoesNotExists }); } return(responseDto); } }
public List <RepertoireDto> GetBandRepertoire(int bandId) { using (var db = new MusicBandAppEntities()) { var response = new List <RepertoireDto>(); var band = db.Bend.Where(x => x.id_bend == bandId).FirstOrDefault(); var songs = band.Pjesma1; foreach (var song in songs) { response.Add(new RepertoireDto() { Duration = song.trajanje.ToString(), Gender = song.Zanr.naziv, Name = song.naziv, Performer = song.izvodac, Year = song.godina_izdanja }); } return(response); } }
public List <ReservationDto> GetReservatedDates(int bandId) { using (var db = new MusicBandAppEntities()) { var responseDto = new List <ReservationDto>(); var reservations = db.Rezervacija.Where(x => x.id_bend == bandId && x.status_rezervacije == 2); foreach (var reservation in reservations) { responseDto.Add(new ReservationDto() { DateFrom = reservation.datum_od, DateTo = reservation.datum_do, Status = reservation.StatusRezervacije.opis, Charge = reservation.cijena, Note = reservation.napomena }); } return(responseDto); } }
public ErrorDto CancelReservation(int reservationId) { using (var db = new MusicBandAppEntities()) { var responseDto = new ErrorDto(); var resultSet = db.Rezervacija.Where(x => x.id_rezervacija == reservationId); if (resultSet.Count() > 1) { responseDto.ErrorCode = (int)ValidationStatusCode.ResultsetHasMoreItems; } else if (resultSet.Any()) { resultSet.FirstOrDefault().status_rezervacije = 4; db.SaveChanges(); } else { responseDto.ErrorCode = (int)ValidationStatusCode.UserDoesNotExists; } return(responseDto); } }