public string Edit([FromForm] string json)
{
try {
this.Request = new Request(json);
HttpRequest httpRequest = HttpContext.Request;
int mediaType = int.Parse(this.Request.Get("mediaType"));
Dictionary <String, String> fileData = this.Request.GetValidatedFile(httpRequest, mediaType);
AbstractMedia media = new AbstractMedia {
Id = int.Parse(this.Request.Get("id")),
Name = this.Request.Get("name"),
Album = new AlbumRepository().FindById(int.Parse(this.Request.Get("album"))),
Gender = new GenderRepository().FindById(int.Parse(this.Request.Get("gender"))),
Category = new CategoryRepository().FindById(int.Parse(this.Request.Get("category"))),
Status = new StatusRepository().FindStatusByCode(this.Request.Get("status")),
Size = fileData["fileSize"],
Source = fileData["fileDestination"]
};
new MediaRepository().Edit(media);
return(new Response(true, "Contenido editado exitosamente!").ToJson());
} catch (NullReferenceException) {
return(new Response(false, "No se han enviado todos los parametros necesarios para editar el contenido.").ToJson());
} catch (Exception ex) {
return(new Response(false, ex.Message).ToJson());
}
}
public string Add([FromForm] string json)
{
try {
this.Request = new Request(json);
HttpRequest httpRequest = HttpContext.Request;
int mediaType = int.Parse(this.Request.Get("mediaType"));
Dictionary <String, String> fileData = this.Request.GetValidatedFile(httpRequest, mediaType);
AbstractMedia media = new AbstractMedia {
Name = this.Request.Get("name"),
Album = new AlbumRepository().FindById(int.Parse(this.Request.Get("album"))),
Gender = new GenderRepository().FindById(int.Parse(this.Request.Get("gender"))),
Category = new CategoryRepository().FindById(int.Parse(this.Request.Get("category"))),
Size = fileData["fileSize"],
Source = fileData["fileDestination"]
};
int Id = new MediaRepository().Add(media);
switch (mediaType)
{
case 1: // Musica
new MusicRepository().Add(new Music()
{
Id = Id
});
break;
case 2: // Video
new VideoRepository().Add(new Video()
{
Id = Id
});
break;
case 3: // Libro
new BookRepository().Add(new Book()
{
Id = Id
});
break;
case 4: // Imagen
new ImageRepository().Add(new Image()
{
Id = Id
});
break;
}
return(new Response(true, "Contenido creado exitosamente!").ToJson());
} catch (NullReferenceException) {
return(new Response(false, "No se han enviado todos los parametros necesarios para crear el contenido.").ToJson());
} catch (Exception ex) {
return(new Response(false, ex.Message).ToJson());
}
}
public void Remove(AbstractMedia media)
{
try {
String QueryTemplate = "UPDATE {0} SET Status = 'B' WHERE Id = {1}";
String Query = String.Format(QueryTemplate, this.Table, media.Id);
this.ExecUpdate(Query);
} catch (Exception ex) {
throw ex;
} finally {
this.SqlConnection.Close();
}
}
public void Edit(AbstractMedia media)
{
try {
String QueryTemplate = "UPDATE {0} SET Album = {1}, Name = {2}, Gender = {3}, Category = {4}, Size = '{5}', Source = '{6}', Status = '{7}' WHERE Id = {8}";
String Query = String.Format(QueryTemplate, this.Table, media.Album.Id, media.Name, media.Gender.Id, media.Category.Id, media.Size, media.Source, media.Status.Code, media.Id);
this.ExecUpdate(Query);
} catch (Exception ex) {
throw ex;
} finally {
this.SqlConnection.Close();
}
}
public string Remove([FromForm] string json)
{
try {
this.Request = new Request(json);
AbstractMedia media = new AbstractMedia {
Id = int.Parse(this.Request.Get("id"))
};
new MediaRepository().Remove(media);
return(new Response(true, "Album eliminado exitosamente!").ToJson());
} catch (NullReferenceException) {
return(new Response(false, "No se han enviado todos los parametros necesarios para eliminar al album.").ToJson());
} catch (Exception ex) {
return(new Response(false, ex.Message).ToJson());
}
}
public int Add(AbstractMedia media)
{
try {
String QueryTemplate = "INSERT INTO {0} (Album, Name, Gender, Category, Size, Source) VALUES ({1}, '{2}', {3}, {4}, '{5}', '{6}')";
String Query = String.Format(QueryTemplate, this.Table, media.Album.Id, media.Name, media.Gender.Id, media.Category.Id, media.Size, media.Source);
this.ExecInsert(Query);
this.SqlConnection.Close();
Query = String.Format("SELECT MAX(Id) AS Id FROM {0}", this.Table);
this.ExecSelect(Query);
this.SqlDataReader.Read();
return(DBTransformer.GetOrDefault(this.SqlDataReader["Id"], 0));
} catch (Exception ex) {
throw ex;
} finally {
this.SqlConnection.Close();
}
}