public void UpdatePerformance(Performance performance) { var request = new RestRequest("api/Performance/UpdatePerformance", Method.POST); request.RequestFormat = DataFormat.Json; request.AddBody(performance); client.Execute(request); }
public Performance CreatePerformance(DateTime date, Artist artist, Venue venue) { Performance param = new Performance(0, date, artist.Id, venue.Id); var request = new RestRequest("api/Performance/CreatePerformance", Method.POST); request.RequestFormat = DataFormat.Json; request.AddBody(param); return client.Execute<Performance>(request).Data; }
private String GenerateTableRow(Venue venue, Performance[] performances) { String tableRow = "<tr class='h4 tableCellCenter small'>"; tableRow += "<td class='warning '><strong>" + HttpUtility.HtmlEncode(venue.Shortcut) + " <br>" + HttpUtility.HtmlEncode(venue.Name) + "</strong></td>"; for (var i = 0; i < performances.Length; i++) { if (performances[i] == null) { tableRow += "<td></td>"; } else { Artist a = aS.GetArtistById(performances[i].ArtistId); tableRow += "<td><strong>" + HttpUtility.HtmlEncode(a.Name) + " / "+ HttpUtility.HtmlEncode(catS.GetCategoryById(a.CategoryId).Shortcut)+ "</strong></br> (" + HttpUtility.HtmlEncode(couS.GetCountryById(a.CountryId).Name)+")</td>"; } } tableRow += "</tr>"; return tableRow; }
private String GenerateTableBody(List<Performance> performances, int beginHour, int endHour) { String tableContent = "<tbody>"; performances.Sort((perf1, perf2) => { Venue v1 = vS.GetVenueById(perf1.VenueId); Venue v2 = vS.GetVenueById(perf2.VenueId); int result = v1.Shortcut.CompareTo(v2.Shortcut); if (result != 0) { return result; } return perf1.Date.CompareTo(perf2.Date); }); uint curVId = performances[0].VenueId; Performance[] curVenuePerf = new Performance[endHour - beginHour + 1]; var last = performances[performances.Count - 1]; foreach (var p in performances) { if (p.VenueId == curVId) { curVenuePerf[p.Date.Hour - beginHour] = p; } else { tableContent += GenerateTableRow(vS.GetVenueById(curVId), curVenuePerf); for (int i = 0; i < curVenuePerf.Length; i++) { curVenuePerf[i] = null; } curVId = p.VenueId; curVenuePerf[p.Date.Hour - beginHour] = p; } if(last == p) { tableContent += GenerateTableRow(vS.GetVenueById(curVId), curVenuePerf); } } tableContent += "</tbody>"; return tableContent; }
public bool UpdatePerformance(Performance performance) { DbCommand cmd = db.CreateCommand(UPDATE_CMD); db.DefineParameter(cmd, "@id", System.Data.DbType.UInt32, performance.Id); db.DefineParameter(cmd, "@date", System.Data.DbType.DateTime, db.ConvertDateTimeToDbFormat(performance.Date)); db.DefineParameter(cmd, "@artistId", System.Data.DbType.UInt32, performance.ArtistId); db.DefineParameter(cmd, "@venueId", System.Data.DbType.UInt32, performance.VenueId); return db.ExecuteNonQuery(cmd) >= 1; }
public bool DeletePerformance(Performance performance) { DbCommand cmd = db.CreateCommand(DELETE_CMD); db.DefineParameter(cmd, "@id", System.Data.DbType.UInt32, performance.Id); return cmd.ExecuteNonQuery() >= 1; }