protected void BtnSalvar_Click(object sender, EventArgs e)
{
Album album = getData();
var db = new AlbumDB();
if ((IdH.Value == "0") || (IdH.Value == ""))
{
if (db.Insert(album))
{
LblMsg.Text = "Registro inserido!";
LoadGrid();
}
else
{
LblMsg.Text = "Erro ao inserir registro";
}
}
else
{
if (db.Update(album, int.Parse(IdH.Value)))
{
LblMsg.Text = "Registro atualizado!";
}
else
{
LblMsg.Text = "Erro ao atualizar registro";
}
}
LoadGrid();
}
/// <summary>
/// Inserts Album into the Albums Table
/// </summary>
/// <param name="album">A new populated album.</param>
/// <returns>Insert Count</returns>
public int Insert(Album album)
{
return(albumDb.Insert(album, "Album_Insert"));
}
/// <summary>
/// Inserts Album into the Albums Table
/// </summary>
/// <param name="album">A new populated album.</param>
/// <returns>Insert Count</returns>
public int Insert(Album album)
{
const string sql = "INSERT INTO Album (Name, Description, UserId) VALUES (@Name, @Description, @UserId)";
return(albumDb.Insert(album, sql));
}