public int Post(FoodMarkerImageDataDTO foodMarkerImg)
{
using (SqlConnection conn = new SqlConnection(m_DataAccess.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = m_DataAccess.GetCommand("ADD_IMAGE", CommandType.StoredProcedure, conn))
{
cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@fmid", SqlDbType.Int, foodMarkerImg.FoodMarkerId));
cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@filename", SqlDbType.VarChar, foodMarkerImg.FileName));
cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@clientfilename", SqlDbType.VarChar, foodMarkerImg.ClientFileName));
cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@rankId", SqlDbType.Int, foodMarkerImg.ImageRank));
cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@id"].Value);
}
}
}
public async Task DeleteFile(FoodMarkerImageDataDTO foodMarkerImageDto)
{
string storageFileName = foodMarkerImageDto.Id.ToString() + "_" + foodMarkerImageDto.FileName;
await _azureStorageHandler.DeleteFile(storageFileName);
}
public async Task PostFile(FoodMarkerImageDataDTO foodMarkerImageDto, string contentType, Stream stream)
{
await _azureStorageHandler.UploadFile(foodMarkerImageDto.Id.ToString()
+ "_" + foodMarkerImageDto.FileName,
stream, contentType);
}
public string GetFileUrl(FoodMarkerImageDataDTO foodMarkerImageDto)
{
string storageFileName = foodMarkerImageDto.Id.ToString() + "_" + foodMarkerImageDto.FileName;
return(_azureStorageHandler.GetFileUrl(storageFileName));
}
public void Update(FoodMarkerImageDataDTO foodMarkerImg, int id)
{
throw new NotImplementedException();
}
