//Retrieve the performance from the database with this Id
public void LoadByName()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
//Retrieve from the db
tblPerformance performance = dc.tblPerformances.FirstOrDefault(p => p.Name == this.Name);
//Set this performance's properties
this.Id = performance.Id;
this.Description = performance.Description;
this.Location = performance.Location;
this.PerformanceDate = performance.PerformanceDate;
this.PDFPath = performance.pdfPath;
this.Name = performance.Name;
LoadPerformancePieces();
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Update()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
//Retrieve the record from the DB
tblPerformance performance = dc.tblPerformances.FirstOrDefault(c => c.Id == this.Id);
//Update the properties
performance.Name = this.Name;
performance.Description = this.Description;
performance.PerformanceDate = this.PerformanceDate;
performance.pdfPath = this.PDFPath;
performance.Location = this.Location;
//Save the changes
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteTest()
{
using (MusicEntities dc = new MusicEntities())
{
tblPerformance performance = dc.tblPerformances.FirstOrDefault(a => a.Name == "PL Test");
dc.tblPerformances.Remove(performance);
dc.SaveChanges();
tblPerformance retrievedPerformance = dc.tblPerformances.FirstOrDefault(a => a.Name == "PL Test");
Assert.IsNull(retrievedPerformance);
}
}
public void UpdateTest()
{
using (MusicEntities dc = new MusicEntities())
{
tblPerformance performance = dc.tblPerformances.FirstOrDefault(a => a.Name == "PL Test");
performance.Location = "PL Updated Test";;
dc.SaveChanges();
tblPerformance retrievedPerformance = dc.tblPerformances.FirstOrDefault(a => a.Name == "PL Test");
Assert.IsNotNull(retrievedPerformance);
}
}
//Insert the performance 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
tblPerformance performance = new tblPerformance
{
Id = this.Id,
Name = this.Name,
Description = this.Description,
PerformanceDate = this.PerformanceDate,
pdfPath = this.PDFPath,
Location = this.Location
};
//Add it to the table and save changes
dc.tblPerformances.Add(performance);
// Send an email to inform that a new performance was added
// Shapiro password: $haphir0MT
// Test password: MusicTrackerT3st
MailMessage mail = new MailMessage();
SmtpClient smtpClient = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress("*****@*****.**");
mail.To.Add("*****@*****.**");
mail.Subject = "New Performance Added!";
mail.Body = "A new performance was added! Check it out here: http://shapiro.azurewebsites.net/Performance/Details/" + this.Id;
smtpClient.Port = 587;
smtpClient.Credentials = new System.Net.NetworkCredential("*****@*****.**", "$haphir0MT");
smtpClient.EnableSsl = true;
smtpClient.Send(mail);
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
//Retrieve it from the DB
tblPerformance performance = dc.tblPerformances.FirstOrDefault(p => p.Id == this.Id);
//Remove the performance
dc.tblPerformances.Remove(performance);
//Save the changes
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertTest()
{
using (MusicEntities dc = new MusicEntities())
{
tblPerformance performance = new tblPerformance();
performance.Id = Guid.NewGuid();
performance.Name = "PL Test";
performance.PerformanceDate = DateTime.Now;
performance.Location = "PL Test";
performance.pdfPath = "PL Test";
performance.Description = "PL Test";
dc.tblPerformances.Add(performance);
dc.SaveChanges();
tblPerformance retrievedPerformance = dc.tblPerformances.FirstOrDefault(a => a.Name == "PL Test");
Assert.AreEqual(performance.Id, retrievedPerformance.Id);
}
}
