//Muda de página para insert
public ActionResult Insert()
{
var album = new AlbumVO();
var albumView = Mapper.Map <AlbumVO, AlbumModel>(album);
return(View(albumView));
}
public AlbumModel(AlbumVO album)
{
MaxChars = album.maxCharsProjecName;
TransparentImage = album.Transparent_Image;
ShowProductDescription = album.Show_Product_Description;
ProductType = "Album";
Object = new AlbumInfo(album);
}
public static object GetAlbum(AlbumVO album)
{
return(new
{
max_car = @ABookClient.maxCharsProjecName,
trans_img = @ABookClient.Transparent_Image,
show_description = @ABookClient.Show_Product_Description,
product_type = "Album",
obj = CreateObjAlbumVO(album),
});
}
public static ActionResult GetAlbumJSON(AlbumVO album)
{
return(Controller.Content(
JsonConvert.SerializeObject(new
{
max_car = @ABookClient.maxCharsProjecName,
trans_img = @ABookClient.Transparent_Image,
show_description = @ABookClient.Show_Product_Description,
product_type = "Album",
obj = CreateObjAlbumVO(album),
})
));
}
//Método de Alteração
public void Update(AlbumVO album)
{
List <SqlParameter> parameters = new List <SqlParameter>();
var strQuery = @"UPDATE TBALBUM SET Title=@Title,Id_Image=@Id_Image WHERE Id_Album=@Id_Album";
var title = new SqlParameter("Title", album.Title);
var id_Image = new SqlParameter("Id_Image", album.IdImage);
var id_Album = new SqlParameter("Id_Album", album.Id);
parameters.Add(title);
parameters.Add(id_Image);
parameters.Add(id_Album);
using (connection = new Connection())
{
connection.ExecuteQry(strQuery, parameters);
}
}
//Método de Inserção
public void Insert(AlbumVO album)
{
//lista de parametros para criar o SqlCommand para proteger os valores de sqlinjection
List <SqlParameter> parameters = new List <SqlParameter>();
var strQuery = @"INSERT INTO TBALBUM(Title,Id_Image) VALUES (@Title,@Id_Image)";
var title = new SqlParameter("Title", album.Title);
var id_Image = new SqlParameter("Id_Image", album.IdImage);
parameters.Add(title);
parameters.Add(id_Image);
//Using para encerrar a conexão assim que executar a query
using (connection = new Connection())
{
connection.ExecuteQry(strQuery, parameters);
}
}
//Selecionar os registros apenas por id
public AlbumVO GetForId(int id)
{
using (connection = new Connection())
{
var album = new AlbumVO();
List <SqlParameter> parameters = new List <SqlParameter>();
var strQuery = @"SELECT * FROM TBALBUM WHERE Id_Album=@Id_Album";
var idAlbum = new SqlParameter("Id_Album", id);
parameters.Add(idAlbum);
SqlDataReader reader = connection.ExecuteSelect(strQuery, parameters);
while (reader.Read())
{
album.Id = int.Parse(reader["Id_Album"].ToString());
album.Title = reader["Title"].ToString();
album.IdImage = reader["Id_Image"].ToString();
}
return(album);
}
}
//Selecionar todos os registros
public List <AlbumVO> GetAllAlbum()
{
var listAlbum = new List <AlbumVO>();
using (connection = new Connection())
{
List <SqlParameter> parameters = new List <SqlParameter>();
var strQuery = @"SELECT * FROM TBALBUM";
SqlDataReader reader = connection.ExecuteSelect(strQuery, parameters);
while (reader.Read())
{
var album = new AlbumVO
{
Id = int.Parse(reader["Id_Album"].ToString()),
Title = reader["Title"].ToString(),
IdImage = reader["Id_Image"].ToString()
};
listAlbum.Add(album);
}
reader.Close();
}
return(listAlbum);
}
// ... define properties here
public AlbumInfo(AlbumVO album)
{
// ... map properties here
}
public void Update(AlbumVO album)
{
_albumRepository.Update(album);
}
public void Insert(AlbumVO album)
{
_albumRepository.Insert(album);
}
