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);
}
}
