public async Task <int> DeleteImageAsync(string imageid)
{
var cmd = MySqlDbHelper.DeleteImageCommand(imageid);
OpenDbConnection();
var x = await _db.ExecuteNonQueryAsync(cmd);
return(x);
}
public async Task <string> AddImageAsync(Image img)
{
var cmd = MySqlDbHelper.AddImageCommand(img);
OpenDbConnection();
var rdr = await _db.ExecCommandAsync(cmd);
rdr.Close();
return(img.ImageId);
}
public async Task <ImageContent> AddImageContentAsync(ImageContent ic)
{
var cmd = MySqlDbHelper.AddImageContentCommand(ic);
OpenDbConnection();
DbDataReader r = await _db.ExecCommandAsync(cmd);
r.Close();
return(ic);
}
public string AddImage(Image img)
{
var cmd = new MySqlCommand
{
CommandType = CommandType.Text,
CommandText = MySqlDbHelper.AddImageQuery(img)
};
OpenDbConnection();
_db.ExecCommand(cmd);
//_db.Close();
return(img.ImageId);
}
