private void CreateNewInvoice()
{
using (var context = new ChinookEntities())
{
var newInvoice = new Invoice()
{
BillingCountry = Customer.Country,
BillingCity = Customer.City,
CustomerId = Customer.CustomerId,
BillingAddress = Customer.Address,
BillingPostalCode = Customer.PostalCode,
BillingState = Customer.State,
InvoiceDate = DateTime.Now,
};
context.Invoices.Add(newInvoice);
context.SaveChanges();
foreach (var line in InvoiceLines)
{
line.Invoice = newInvoice;
context.InvoiceLines.Add(line);
}
newInvoice.Total = newInvoice.InvoiceLines.Sum(i => i.UnitPrice * i.Quantity);
context.SaveChanges();
}
}
public void TestUpdateCustomer()
{
Customer customer = _CustomerRepo.GetCustomerByFirstAndLastName("Jean", "Bon");
customer.Address = "Beaulieu";
_ChinookEntities.SaveChanges();
}
public ActionResult Delete(int id)
{
Album album = ctx.Albums.Single(t => t.AlbumId == id);
ctx.Albums.Remove(album);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "GenreId,Name")] Genre genre)
{
if (ModelState.IsValid)
{
db.Genre.Add(genre);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(genre));
}
public ActionResult Create([Bind(Include = "MediaTypeId,Name")] MediaType mediaType)
{
if (ModelState.IsValid)
{
db.MediaTypes.Add(mediaType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mediaType));
}
public ActionResult Create([Bind(Include = "PlaylistId,Name")] Playlist playlist)
{
if (ModelState.IsValid)
{
db.Playlists.Add(playlist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(playlist));
}
public ActionResult Create([Bind(Include = "GenreId,TrackId,TotalTrackCharge,TimeCreated")] InvoiceStatistic invoiceStatistic)
{
if (ModelState.IsValid)
{
db.InvoiceStatistics.Add(invoiceStatistic);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(invoiceStatistic));
}
public ActionResult Create([Bind(Include = "ArtistId,Name")] Artist artist)
{
if (ModelState.IsValid)
{
db.Artist.Add(artist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(artist));
}
public ActionResult Create([Bind(Include = "EmployeeId,LastName,FirstName,Title,ReportsTo,BirthDate,HireDate,Address,City,State,Country,PostalCode,Phone,Fax,Email")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReportsTo = new SelectList(db.Employees, "EmployeeId", "LastName", employee.ReportsTo);
return(View(employee));
}
public ActionResult Create([Bind(Include = "InvoiceId,CustomerId,InvoiceDate,BillingAddress,BillingCity,BillingState,BillingCountry,BillingPostalCode,Total")] Invoice invoice)
{
if (ModelState.IsValid)
{
db.Invoice.Add(invoice);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customer, "CustomerId", "FirstName", invoice.CustomerId);
return(View(invoice));
}
public ActionResult Create([Bind(Include = "AlbumId,Title,ArtistId")] Album album)
{
if (ModelState.IsValid)
{
db.Albums.Add(album);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistId = new SelectList(db.Artists, "ArtistId", "Name", album.ArtistId);
return(View(album));
}
public ActionResult Create([Bind(Include = "CustomerId,FirstName,LastName,Company,Address,City,State,Country,PostalCode,Phone,Fax,Email,SupportRepId")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customer.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SupportRepId = new SelectList(db.Employee, "EmployeeId", "LastName", customer.SupportRepId);
return(View(customer));
}
public ActionResult Create([Bind(Include = "InvoiceLineId,InvoiceId,TrackId,UnitPrice,Quantity")] InvoiceLine invoiceLine)
{
if (ModelState.IsValid)
{
db.InvoiceLine.Add(invoiceLine);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InvoiceId = new SelectList(db.Invoice, "InvoiceId", "BillingAddress", invoiceLine.InvoiceId);
ViewBag.TrackId = new SelectList(db.Track, "TrackId", "Name", invoiceLine.TrackId);
return(View(invoiceLine));
}
public ActionResult Create([Bind(Include = "TrackId,Name,AlbumId,MediaTypeId,GenreId,Composer,Milliseconds,Bytes,UnitPrice")] Track track)
{
if (ModelState.IsValid)
{
db.Track.Add(track);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumId = new SelectList(db.Album, "AlbumId", "Title", track.AlbumId);
ViewBag.GenreId = new SelectList(db.Genre, "GenreId", "Name", track.GenreId);
ViewBag.MediaTypeId = new SelectList(db.MediaType, "MediaTypeId", "Name", track.MediaTypeId);
return(View(track));
}
public ActionResult Create(Track track)
{
if (ModelState.IsValid)
{
db.Tracks.Add(track);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumId = new SelectList(db.Albums, "AlbumId", "Title", track.AlbumId);
ViewBag.GenreId = new SelectList(db.Genres, "GenreId", "Name", track.GenreId);
ViewBag.MediaTypeId = new SelectList(db.MediaTypes, "MediaTypeId", "Name", track.MediaTypeId);
return(View(track));
}
private void btn_Add_Click(object sender, EventArgs e)
{
errorProvider.Clear();
if (String.IsNullOrEmpty(txt_AuthorName.Text))
{
errorProvider.SetError(txt_AuthorName, "Enter author name");
}
else
{
using (var context = new ChinookEntities())
{
var newArtist = new Artist()
{
Name = txt_AuthorName.Text
};
if (!context.Artists.Any(a => a.Name == newArtist.Name))
{
context.Artists.Add(newArtist);
}
context.SaveChanges();
}
this.Hide();
var form = new AddItemForm();
form.ShowDialog();
this.Close();
}
}
private void btn_Add_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txt_Type.Text))
{
errorProvider.SetError(txt_Type, "Enter type");
}
else
{
using (var context = new ChinookEntities())
{
var newType = new MediaType()
{
Name = txt_Type.Text
};
if (!context.MediaTypes.Any(t => t.Name == newType.Name))
{
context.MediaTypes.Add(newType);
}
context.SaveChanges();
}
this.Hide();
var form = new AddItemForm();
form.ShowDialog();
this.Close();
}
}
// PUT api/<controller>/5
public HttpResponseMessage Put(int id, TrackDTO track)
{
HttpResponseMessage responseMessage;
using (var context = new ChinookEntities())
{
var oldTrack = context.Tracks.Find(id);
if (oldTrack != null)
{
int newGenreId = context.Genres.Where(g => g.Name == track.Genre).SingleOrDefault().GenreId;
oldTrack.Name = track.Name;
oldTrack.GenreId = newGenreId;
oldTrack.Milliseconds = track.Milliseconds;
oldTrack.UnitPrice = track.UnitPrice;
try
{
context.SaveChanges();
responseMessage = Request.CreateResponse <TrackDTO>(HttpStatusCode.OK, track);
}
catch (Exception ex)
{
responseMessage = Request.CreateErrorResponse(HttpStatusCode.BadRequest,
new HttpError("Track wasn't updated!"));
}
}
else
{
responseMessage = Request.CreateErrorResponse(HttpStatusCode.BadRequest,
new HttpError("Track wasn't found!"));
}
}
return(responseMessage);
}
public ActionResult Delete(int id)
{
using (var ctx = new ChinookEntities())
{
var artist = ctx.Artists.Single(t => t.ArtistId == id);
ctx.Artists.Remove(artist);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(Artist artist)
{
using (var ctx = new ChinookEntities())
{
var a = ctx.Artists.Single(t => t.ArtistId == artist.ArtistId);
a.Name = artist.Name;
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
}
public void TestDeleteInvoicesLineAndRollBackJeanBon()
{
using (var trans = _ChinookEntities.Database.BeginTransaction())
{
var customer = _CustomerRepo.GetCustomerByFirstAndLastName("Jean", "Bon");
var invoice = _InvoiceRepo.GetListInvoicesByIdCustomer(customer.CustomerId).FirstOrDefault();
var listInvoicelines = invoice.InvoiceLine.Where(x => x.Track.Composer == "AC/DC").ToList();
_InvoiceRepo.RemoveListInvoicesLine(listInvoicelines);
invoice.Total = invoice.InvoiceLine.Sum(x => x.Quantity * x.UnitPrice);
_ChinookEntities.SaveChanges();
trans.Rollback();
}
}
public ActionResult DeleteArtist(int id)
{
var findArtist = db.Artists.Find(id);
db.Artists.Remove(findArtist);
db.SaveChanges();
var getArtist = db.Artists.Select(x => new { x.ArtistId, x.Name }).ToList();
return(Json(getArtist, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Artist artist)
{
using (var ctx = new ChinookEntities())
{
var id = ctx.Artists.OrderByDescending(t => t.ArtistId).First().ArtistId;
artist.ArtistId = ++id;
ctx.Artists.Add(artist);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
}
public void TestAjoutSupprEmployeeAvecRepository()
{
Employee empl = new Employee()
{
FirstName = "Miriam",
LastName = "LEFEVRE",
Country = "France",
Title = "Gestionnaire"
};
_EmployeeRepo.Add(empl);
_ChinookEntities.SaveChanges();
//On mémorise l'ID
int id = empl.EmployeeId;
// Pour s'assurer que l'employé a bien été ajouté en BDD, on réinstancie le contexte pour faire une lecture en BDD
_ChinookEntities = new ChinookEntities();
_EmployeeRepo = new EmployeeRepository(_ChinookEntities);
Employee employee = _EmployeeRepo.GetEmployee(id);
//On test pour savoir si on récupère bien un employé et si son nom est bien LEFEVRE
// On utilise la méthode Assert, le TU n'est pas validé si la condition n'est pas remplie
Assert.IsTrue(employee?.LastName == "LEFEVRE");
_ChinookEntities = new ChinookEntities();
_EmployeeRepo = new EmployeeRepository(_ChinookEntities);
//On supprime l'entité en BDD pour revenir dans l'état initial
_EmployeeRepo.Delete(empl);
_ChinookEntities.SaveChanges();
_ChinookEntities = new ChinookEntities();
_EmployeeRepo = new EmployeeRepository(_ChinookEntities);
Employee employeeDeleted = _EmployeeRepo.GetEmployee(id);
Assert.IsTrue(employeeDeleted == null);
}
public void AddAlbumWithTracks()
{
Artist newArtist = new Artist();
newArtist.Name = "Rammstein";
Album newAlbum = new Album();
newAlbum.Title = "RAMMSTEIN";
newAlbum.Artist = newArtist;
Track t1 = new Track();
t1.Album = newAlbum;
t1.Name = "DEUTSCHLAND";
t1.MediaTypeId = 1;
t1.Milliseconds = 42;
t1.UnitPrice = new decimal(5.5);
var persisted = _context.Track.Add(t1);
_context.SaveChanges();
Console.WriteLine(persisted);
}
// PUT: odata/Tracks(5)
public IHttpActionResult Put([FromODataUri] int key, Delta <Track> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Track track = db.Tracks.Find(key);
if (track == null)
{
return(NotFound());
}
patch.Put(track);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TrackExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(track));
}
// PUT: odata/Albums(5)
public IHttpActionResult Put([FromODataUri] int key, Delta <Album> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Album album = db.Albums.Find(key);
if (album == null)
{
return(NotFound());
}
patch.Put(album);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AlbumExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(album));
}
private Customer AddNewCustomer()
{
using (var context = new ChinookEntities())
{
if (IsInDatabase(Customer))
{
context.Customers.Add(Customer);
context.SaveChanges();
return(Customer);
}
else
{
return(context.Customers
.Where(c => c.FirstName == Customer.FirstName &&
c.LastName == Customer.LastName &&
c.Address == Customer.Address &&
c.Country == Customer.Country &&
c.City == Customer.City)
.FirstOrDefault());
}
}
}
private void btn_Add_Click(object sender, EventArgs e)
{
errorProvider.Clear();
if (comboBox_Author.SelectedIndex < 0)
{
errorProvider.SetError(comboBox_Author, "Choose author");
}
else if (String.IsNullOrEmpty(txt_Title.Text))
{
errorProvider.SetError(txt_Title, "Enter album title");
}
else
{
using (var context = new ChinookEntities())
{
string selectedArtist = comboBox_Author.SelectedItem.ToString();
var artist = context.Artists
.Where(a => a.Name == selectedArtist)
.FirstOrDefault();
var newAlbum = new Album()
{
Artist = artist,
ArtistId = artist.ArtistId,
Title = txt_Title.Text
};
context.Albums.Add(newAlbum);
context.SaveChanges();
}
this.Hide();
var form = new AddItemForm();
form.ShowDialog();
this.Close();
}
}
public void Commit()
{
ctx.SaveChanges();
}
