//Insert the pieceWriter into the db, and generate a new Id for it.
public int Insert()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
//Create a new Id
this.Id = Guid.NewGuid();
//Set the properties
tblPieceWriter pieceWriter = new tblPieceWriter
{
Id = this.Id,
ComposerTypeId = this.ComposerTypeId,
ComposerId = this.ComposerId,
PieceId = this.PieceId,
};
//Add it to the table and save changes
dc.tblPieceWriters.Add(pieceWriter);
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
//Retrieve the pieceWriter from the database with this Id
public void LoadById()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
//Retrieve from the db
tblPieceWriter pieceWriter = dc.tblPieceWriters.FirstOrDefault(p => p.Id == this.Id);
//Set this pieceWriter's properties
this.ComposerId = pieceWriter.ComposerId;
this.ComposerTypeId = pieceWriter.ComposerTypeId;
this.PieceId = pieceWriter.PieceId;
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
//Retrieve it from the DB
tblPieceWriter pieceWriter = dc.tblPieceWriters.FirstOrDefault(p => p.Id == this.Id);
//Remove the pieceWriter
dc.tblPieceWriters.Remove(pieceWriter);
//Save the changes
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Update()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
//Retrieve the record from the DB
tblPieceWriter pieceWriter = dc.tblPieceWriters.FirstOrDefault(p => p.Id == this.Id);
//Update the properties
pieceWriter.Id = this.Id;
pieceWriter.PieceId = this.PieceId;
pieceWriter.ComposerId = this.ComposerId;
pieceWriter.ComposerTypeId = this.ComposerTypeId;
//Save the changes
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
