public Artist CreateArtist(string name, string email, Category category, Country country, string picturePath, string videoPath)
{
Artist param = new Artist(0, name, email, category.Id, country.Id, picturePath, videoPath);
var request = new RestRequest("api/Artist/CreateArtist", Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(param);
Artist artist = client.Execute<Artist>(request).Data;
if (artist != null)
{
foreach (var listener in listeners)
{
listener.OnArtistCreation(artist);
}
}
return artist;
}
public Artist CreateArtist(string name, string email, Category category, Country country, string picturePath, string videoPath)
{
if (!IsValidName(name)) {
throw new DataValidationException("Can't create artist with invalid name '" + name + "'");
} else if (!IsValidEmail(email)) {
throw new DataValidationException("Can't create artist with invalid email address '" + email + "'");
} else if(category == null) {
throw new DataValidationException("Can't create artist without category");
} else if(country == null) {
throw new DataValidationException("Can't create artist without country");
} else if (!IsValidPicturePath(picturePath)) {
throw new DataValidationException("Can`t create artist with invalid picturePath '" + picturePath + "'");
} else if (!IsValidVideoPath(videoPath)) {
throw new DataValidationException("Can`t create artist with invalid videoPath '" + videoPath + "'");
}
picturePath = picturePath == null ? "" : picturePath;
videoPath = videoPath == null ? "" : videoPath;
Artist artist = aDao.CreateArtist(name, email, category.Id, country.Id, picturePath, videoPath);
foreach (var listener in listeners) {
listener.OnArtistCreation(artist);
}
return artist;
}
public void Startup()
{
catdao = new CategoryDao(db);
coudao = new CountryDao(db);
adao = new ArtistDao(db);
vdao = new VenueDao(db);
pdao = new PerformanceDao(db);
aS = ServiceFactory.CreateArtistService(db);
category = RepresentativeData.GetDefaultCategories()[0];
country = RepresentativeData.GetDefaultCountries()[0];
category = catdao.CreateCategory(category.Shortcut, category.Name);
country = coudao.CreateCountry(country.Name, country.FlagPath);
}
public bool UpdateCategory(Category category)
{
if (category != null) {
DbCommand cmd = database.CreateCommand(SQL_UPDATE);
database.DefineParameter(cmd, "@shortcut", DbType.String, category.Shortcut);
database.DefineParameter(cmd, "@name", DbType.String, category.Name);
database.DefineParameter(cmd, "@categoryId", DbType.String, category.Id);
return database.ExecuteNonQuery(cmd) >= 1;
}
return false;
}
public Category GetCategoryById(uint categoryId)
{
DbCommand cmd = database.CreateCommand(SQL_FIND_BY_ID);
database.DefineParameter(cmd, "@categoryId", DbType.UInt32 , categoryId);
Category cat = null;
database.doSynchronized(() => {
using (IDataReader reader = database.ExecuteReader(cmd)) {
if (reader.Read()) {
cat = new Category((uint)reader["categoryId"], (string)reader["shortcut"],
(string)reader["name"]);
}
}
});
return cat;
}
public List<Category> GetAllCategories()
{
DbCommand cmd = database.CreateCommand(SQL_FIND_ALL);
List <Category> categories = new List<Category>();
database.doSynchronized(() => {
using (IDataReader reader = database.ExecuteReader(cmd)) {
while (reader.Read()) {
Category newCat = new Category((uint)reader["categoryId"], (string)reader["shortcut"], (string)reader["name"]);
categories.Add(newCat);
}
}
});
return categories;
}
public bool DeleteCategory(Category category)
{
if (category != null) {
DbCommand cmd = database.CreateCommand(SQL_DELETE);
database.DefineParameter(cmd, "@categoryId", DbType.UInt32,category.Id);
return database.ExecuteNonQuery(cmd) == 1;
}
return false;
}
public uint CountArtistsOfCategory(Category category)
{
DbCommand cmd = database.CreateCommand(SQL_COUNTCATEGORIES);
database.DefineParameter(cmd, "@categoryId", System.Data.DbType.UInt32, category.Id);
using (DbDataReader reader = cmd.ExecuteReader()) {
reader.Read();
return (uint)((long)reader["count"]);
}
}
