public void LoadTest()
{
PerformanceList performances = new PerformanceList();
performances.Load();
Assert.AreEqual(6, performances.Count);
}
// GET: api/Performance
public IEnumerable <Performance> Get()
{
PerformanceList performances = new PerformanceList();
performances.Load();
return(performances);
}
public MainPagePerf(FormMain formMain) : base(formMain, (TabPage)formMain.tabPagePerfCtl)
{
splitContainerPerfCtls = formMain.splitContainerPerfCtls;
performanceLeftList = formMain.performanceLeftList;
pl_perfGridHost = formMain.pl_perfGridHost;
spBottom = formMain.spBottom;
tabControlMain = formMain.tabControlMain;
}
public ManagePerformance()
{
InitializeComponent();
performances = new PerformanceList();
Load();
Rebind();
}
public ActionResult PerformanceAction(int?id)
{
ViewBag.drpNote = CommonController.drpNote();
ViewBag.drpProgram = CommonController.drpProgram();
if (id != 0)
{
PerformanceList dataset = entities.PerformanceLists.Find(id);
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
// GET: Performance
public ActionResult Index()
{
performances = new PerformanceList();
//Initialize Cient
HttpClient client = InitializeClient();
//Call the API
HttpResponseMessage response = client.GetAsync("Performance").Result;
//Deserialize the json
string result = response.Content.ReadAsStringAsync().Result;
dynamic items = (JArray)JsonConvert.DeserializeObject(result);
performances = items.ToObject <PerformanceList>();
return(View(performances));
}
public void LoadById()
{
//Load up Guids
PieceList pieces = new PieceList();
Piece piece = new Piece();
pieces.Load();
piece = pieces.FirstOrDefault(p => p.Name == "Rock Music");
GroupList groups = new GroupList();
Group group = new Group();
groups.Load();
group = groups.FirstOrDefault(c => c.Name == "Jazz Ensemble");
PerformanceList performances = new PerformanceList();
Performance performance = new Performance();
performances.Load();
performance = performances.FirstOrDefault(c => c.Name == "Dream Concert");
DirectorList directors = new DirectorList();
Director director = new Director();
directors.Load();
director = directors.FirstOrDefault(c => c.FirstName == "Eric");
PerformancePiece performancePiece = new PerformancePiece();
PerformancePieceList performancePieces = new PerformancePieceList();
performancePieces.Load();
performancePiece = performancePieces.FirstOrDefault(p => p.GroupId == group.Id && p.PieceId == piece.Id && p.PerformanceId == performance.Id);
performancePiece.Notes = "BL Test";
performancePiece.MP3Path = "BL Test";
PerformancePiece newperformancePiece = new PerformancePiece {
Id = performancePiece.Id
};
newperformancePiece.LoadById();
Assert.AreEqual(performancePiece.DirectorId, newperformancePiece.DirectorId);
}
public void UpdateTest()
{
//Load up Guids
PieceList pieces = new PieceList();
Piece piece = new Piece();
pieces.Load();
piece = pieces.FirstOrDefault(p => p.Name == "Rock Music");
GroupList groups = new GroupList();
Group group = new Group();
groups.Load();
group = groups.FirstOrDefault(c => c.Name == "Jazz Ensemble");
PerformanceList performances = new PerformanceList();
Performance performance = new Performance();
performances.Load();
performance = performances.FirstOrDefault(c => c.Name == "Dream Concert");
DirectorList directors = new DirectorList();
Director director = new Director();
directors.Load();
director = directors.FirstOrDefault(c => c.FirstName == "Eric");
PerformancePiece performancePiece = new PerformancePiece();
PerformancePieceList performancePieces = new PerformancePieceList();
performancePieces.Load();
performancePiece = performancePieces.FirstOrDefault(p => p.GroupId == group.Id && p.PieceId == piece.Id && p.PerformanceId == performance.Id);
performancePiece.Notes = "BL Test";
performancePiece.MP3Path = "BL Test";
performancePiece.DirectorId = director.Id;
int results = performancePiece.Update();
Assert.IsTrue(results == 1);
}
public ActionResult PerformanceAction(PerformanceList performance)
{
ModelState.Remove("PerformanceListID");
if (ModelState.IsValid)
{
string msg = "";
if (performance.PerformanceListID > 0)
{
var dataset = entities.PerformanceLists.Where(f => f.PerformanceListID == performance.PerformanceListID).FirstOrDefault();
if (dataset != null)
{
dataset.PerformanceTime = performance.PerformanceTime;
dataset.MusicSheetID = performance.MusicSheetID;
dataset.PerformanceID = performance.PerformanceID;
msg = "performance Updated Successfully";
}
}
else
{
entities.PerformanceLists.Add(performance);
msg = "New performance Added successfully";
}
entities.SaveChanges();
return(new JsonResult
{
Data = new
{
success = true,
action = "Program",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(PartialView(performance));
}
private void Load()
{
try
{
HttpClient client = InitializeClient();
string result;
dynamic items;
HttpResponseMessage performanceResponse;
//Call the API
performanceResponse = client.GetAsync("Performance").Result;
if (performanceResponse.StatusCode == System.Net.HttpStatusCode.OK)
{
//Process response
result = performanceResponse.Content.ReadAsStringAsync().Result;
//Put json into a performance list
items = (JArray)JsonConvert.DeserializeObject(result);
performances = items.ToObject <PerformanceList>();
}
else
{
throw new Exception("Error: " + performanceResponse.ReasonPhrase);
}
btnAddPiece.IsEnabled = false;
btnRemovePiece.IsEnabled = false;
btnEditPiece.IsEnabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error!");
}
}
public SearchResult()
{
PerformanceList = new PerformanceList();
PieceList = new PieceList();
ComposerList = new ComposerList();
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public CommandStatus GetPerformance(uint lba, PerformanceList.DataType rwtype, PerformanceList.ExceptType extype, out PerformanceList list)
{
list = null;
if (m_logger != null)
{
string args = rwtype.ToString() + ", " + extype.ToString() + ", list";
m_logger.LogMessage(new UserMessage(UserMessage.Category.Debug, 8, "Bwg.Scsi.Device.GetPerformance(" + args + ")"));
}
uint len = 0;
using (Command cmd = new Command(ScsiCommandCode.GetPerformance, 12, 24, Command.CmdDirection.In, 10))
{
byte b = 0x10;
if (rwtype == PerformanceList.DataType.WriteData)
b |= 0x04 ;
b |= (byte)extype;
cmd.SetCDB8(1, b);
cmd.SetCDB16(8, 1);
if (extype == PerformanceList.ExceptType.Entire)
cmd.SetCDB32(2, lba);
CommandStatus st = SendCommand(cmd);
if (st != CommandStatus.Success)
return st;
len = cmd.GetBuffer32(0);
len += 4; // For the length field
}
using (Command cmd = new Command(ScsiCommandCode.GetPerformance, 12, (ushort)len, Command.CmdDirection.In, 10))
{
byte b = 0x10;
if (rwtype == PerformanceList.DataType.WriteData)
b |= 0x04;
b |= (byte)extype;
cmd.SetCDB8(1, b);
if (extype == PerformanceList.ExceptType.Entire)
cmd.SetCDB32(2, lba);
cmd.SetCDB16(8, (ushort)((len - 8) / 16));
CommandStatus st = SendCommand(cmd);
if (st != CommandStatus.Success)
return st;
list = new PerformanceList(cmd.GetBuffer(), cmd.BufferSize);
}
return CommandStatus.Success;
}
// GET: Search
public ActionResult Index(string sortOrder, string searchQuery, string currentFilter, string ddlSearchTable)
{
//Store the previous search
if (string.IsNullOrEmpty(searchQuery) && !string.IsNullOrEmpty(currentFilter))
{
searchQuery = currentFilter;
}
ViewBag.CurrentFilter = searchQuery;
if (ddlSearchTable == "Performance" || ddlSearchTable == null)
{
performances = new PerformanceList();
//Initialize Cient
HttpClient client = InitializeClient();
//Call the API
HttpResponseMessage response = client.GetAsync("Performance").Result;
//Deserialize the json
string result = response.Content.ReadAsStringAsync().Result;
dynamic items = (JArray)JsonConvert.DeserializeObject(result);
performances = items.ToObject <PerformanceList>();
IEnumerable <Performance> filteredPerformances;
//Filter by search box
if (!string.IsNullOrEmpty(searchQuery))
{
log4net.LogicalThreadContext.Properties["tableName"] = "Performances";
log4net.LogicalThreadContext.Properties["searchId"] = Guid.NewGuid();
filteredPerformances = performances.Where(p => p.Name.ToLower().Contains(searchQuery.ToLower()));
if (filteredPerformances.Count() <= 0)
{
if (log.IsWarnEnabled)
{
log.Warn(searchQuery);
}
}
else
{
if (log.IsInfoEnabled)
{
log.Info(searchQuery);
}
}
}
else
{
filteredPerformances = performances;
}
//Set the sorting options
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
System.Collections.Generic.List <Performance> sortedPerformances;
switch (sortOrder)
{
case "name_desc":
sortedPerformances = filteredPerformances.OrderByDescending(p => p.Name).ToList();
break;
case "Date":
sortedPerformances = filteredPerformances.OrderBy(p => p.PerformanceDate).ToList();
break;
case "date_desc":
sortedPerformances = filteredPerformances.OrderByDescending(p => p.PerformanceDate).ToList();
break;
default:
sortedPerformances = filteredPerformances.OrderBy(p => p.Name).ToList();
break;
}
SearchResult searchResult = new SearchResult();
searchResult.PerformanceList.AddRange(sortedPerformances);
searchResult.SearchMode = SearchType.Performance;
return(View(searchResult));
}
else if (ddlSearchTable == "Piece")
{
pieces = new PieceList();
//Initialize Cient
HttpClient client = InitializeClient();
//Call the API
HttpResponseMessage response = client.GetAsync("Piece").Result;
//Deserialize the json
string result = response.Content.ReadAsStringAsync().Result;
dynamic items = (JArray)JsonConvert.DeserializeObject(result);
pieces = items.ToObject <PieceList>();
IEnumerable <Piece> filteredPieces;
//Filter by search box
if (!string.IsNullOrEmpty(searchQuery))
{
log4net.LogicalThreadContext.Properties["tableName"] = "Pieces";
log4net.LogicalThreadContext.Properties["searchId"] = Guid.NewGuid();
filteredPieces = pieces.Where(p => p.Name.ToLower().Contains(searchQuery.ToLower()));
if (filteredPieces.Count() <= 0)
{
if (log.IsWarnEnabled)
{
log.Warn(searchQuery);
}
}
else
{
if (log.IsInfoEnabled)
{
log.Info(searchQuery);
}
}
}
else
{
filteredPieces = pieces;
}
//Set the sorting options
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.YearSortParm = sortOrder == "Year" ? "year_desc" : "Year";
System.Collections.Generic.List <Piece> sortedPieces;
switch (sortOrder)
{
case "name_desc":
sortedPieces = filteredPieces.OrderByDescending(p => p.Name).ToList();
break;
case "Year":
sortedPieces = filteredPieces.OrderBy(p => p.YearWritten).ToList();
break;
case "year_desc":
sortedPieces = filteredPieces.OrderByDescending(p => p.YearWritten).ToList();
break;
default:
sortedPieces = filteredPieces.OrderBy(p => p.Name).ToList();
break;
}
SearchResult searchResult = new SearchResult();
searchResult.PieceList.AddRange(sortedPieces);
searchResult.SearchMode = SearchType.Piece;
return(View(searchResult));
}
else if (ddlSearchTable == "Composer")
{
composers = new ComposerList();
//Initialize Cient
HttpClient client = InitializeClient();
//Call the API
HttpResponseMessage response = client.GetAsync("Composer").Result;
//Deserialize the json
string result = response.Content.ReadAsStringAsync().Result;
dynamic items = (JArray)JsonConvert.DeserializeObject(result);
composers = items.ToObject <ComposerList>();
IEnumerable <Composer> filteredComposers;
//Filter by search box
if (!string.IsNullOrEmpty(searchQuery))
{
log4net.LogicalThreadContext.Properties["tableName"] = "Composers";
log4net.LogicalThreadContext.Properties["searchId"] = Guid.NewGuid();
filteredComposers = composers.Where(p => p.FullName.ToLower().Contains(searchQuery.ToLower()));
if (filteredComposers.Count() <= 0)
{
if (log.IsWarnEnabled)
{
log.Warn(searchQuery);
}
}
else
{
if (log.IsInfoEnabled)
{
log.Info(searchQuery);
}
}
}
else
{
filteredComposers = composers;
}
//Set the sorting options
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.GenderSortParm = sortOrder == "Gender" ? "gender_desc" : "Gender";
ViewBag.RaceSortParm = sortOrder == "Race" ? "race_desc" : "Race";
ViewBag.LocationSortParm = sortOrder == "Location" ? "location_desc" : "Location";
System.Collections.Generic.List <Composer> sortedComposers;
switch (sortOrder)
{
case "name_desc":
sortedComposers = filteredComposers.OrderByDescending(c => c.FullName).ToList();
break;
case "Gender":
sortedComposers = filteredComposers.OrderBy(c => c.Gender).ToList();
break;
case "gender_desc":
sortedComposers = filteredComposers.OrderByDescending(c => c.Gender).ToList();
break;
case "Race":
sortedComposers = filteredComposers.OrderBy(c => c.Race).ToList();
break;
case "race_desc":
sortedComposers = filteredComposers.OrderByDescending(c => c.Race).ToList();
break;
case "Location":
sortedComposers = filteredComposers.OrderBy(c => c.Location).ToList();
break;
case "location_desc":
sortedComposers = filteredComposers.OrderByDescending(c => c.Location).ToList();
break;
default:
sortedComposers = filteredComposers.OrderBy(c => c.FullName).ToList();
break;
}
SearchResult searchResult = new SearchResult();
searchResult.ComposerList.AddRange(sortedComposers);
searchResult.SearchMode = SearchType.Composer;
return(View(searchResult));
}
else
{
SearchResult searchResult = new SearchResult();
return(View(searchResult));
}
}
