public PerformerInEntertainment(Performer performer, Entertainment entertainment, PerformerInEntertainment.Role performerRole) : base()
{
PerformerId = performer.Id;
EntertainmentId = entertainment.Id;
PerformerRole = performerRole;
Logger.Info("PerformerInEntertainment.PerformerInEntertainment", "Створено екземпляр PerformerInEntertainment.");
}
private string GetPerformersStringByRole(PerformerInEntertainment.Role role)
{
Performer[] performers = Performer.GetPerformerByEntertainmentAndRole(_entertainment.EntertainmentDL, role);
if (performers == null)
{
return(null);
}
string result = "";
foreach (var performer in performers)
{
PerformerVM performerVM = new PerformerVM(performer);
result += performerVM.ToString();
result += ", ";
}
return(result.Remove(result.Length - 2, 2));
}
public PerformerMiniViewModel(PerformerVM performer, PerformerInEntertainment.Role role)
{
_performer = performer;
Role = role;
Entertainment[] entertainmentByPerformer = Entertainment.GetEntertainmentByPerformer(performer.PerformerDL);
if (entertainmentByPerformer != null)
{
AvaragePerformerPoint = Entertainment.AverageCriticPointForEntertainments(entertainmentByPerformer);
}
if (role == PerformerInEntertainment.Role.MovieCast)
{
Entertainment[] lastThreeActorsEntertainments = Entertainment.GetLastThreeEntertainmentByActor(performer.PerformerDL);
if (lastThreeActorsEntertainments != null)
{
List <EntertainmentVM> result = new List <EntertainmentVM>();
foreach (var entertainment in lastThreeActorsEntertainments)
{
result.Add(new EntertainmentVM(entertainment));
}
LastThreePerformersEntertainments = result.ToArray();
}
}
if (role == PerformerInEntertainment.Role.AlbumSinger)
{
Entertainment[] lastThreeActorsEntertainments = Entertainment.GetLastThreeEntertainmentBySinger(performer.PerformerDL);
if (lastThreeActorsEntertainments != null)
{
List <EntertainmentVM> result = new List <EntertainmentVM>();
foreach (var entertainment in lastThreeActorsEntertainments)
{
result.Add(new EntertainmentVM(entertainment));
}
LastThreePerformersEntertainments = result.ToArray();
}
}
}
public EditOrAddPerformerInEntertainmentUserControlVM(EntertainmentVM entertainment, PerformerInEntertainment.Role role)
{
_entertainment = entertainment;
_role = role;
Performer.Type type;
switch (role)
{
case PerformerInEntertainment.Role.AlbumBand:
type = Performer.Type.Band;
break;
case PerformerInEntertainment.Role.AlbumRecordLabel:
type = Performer.Type.RecordLabel;
break;
case PerformerInEntertainment.Role.AlbumSinger:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.GameCast:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.GameDeveloperCompany:
type = Performer.Type.GameDeveloperCompany;
break;
case PerformerInEntertainment.Role.GamePlatform:
type = Performer.Type.GamePlatform;
break;
case PerformerInEntertainment.Role.MovieCast:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.MovieDirector:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.MoviePlotWriter:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.MoviePrincipalCast:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.MovieProducer:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.MovieProduction:
type = Performer.Type.MovieProduction;
break;
case PerformerInEntertainment.Role.TVCast:
type = Performer.Type.Person;
break;
case PerformerInEntertainment.Role.TVNetwork:
type = Performer.Type.TVNetwork;
break;
default:
type = Performer.Type.Person;
break;
}
_performerViewModel = new PerformerUserControlVM(type);
_performerViewModel.PerformerTypesComboBoxVisibility = Visibility.Collapsed;
_performerViewModel.AddButtonVisibility = Visibility.Collapsed;
_performerViewModel.EditButtonVisibility = Visibility.Collapsed;
_performerViewModel.DeleteButtonVisibility = Visibility.Collapsed;
PerformerInEntertainment[] performerInEntertainments = PerformerInEntertainment.GetPerformerInEntertainmentByEntertainmentAndRole(_entertainment.EntertainmentDL, role);
if (performerInEntertainments != null)
{
List <Guid> performerIds = new List <Guid>();
foreach (var performerInEntertainment in performerInEntertainments)
{
_performerInEntertainmentCollection.Add(new PerformerInEntertainmentVM(performerInEntertainment));
performerIds.Add(performerInEntertainment.PerformerId);
}
Performer[] performers = Performer.GetByIds(performerIds.ToArray());
foreach (var performer in performers)
{
_addedPerformerCollection.Add(new PerformerVM(performer));
}
}
Logger.Info("EditOrAddPerformerInEntertainmentUserControlVM.EditOrAddPerformerInEntertainmentUserControlVM", "Екземпляр EditOrAddPerformerInEntertainmentUserControlVM створений.");
}
public PerformerInEntertainmentVM(PerformerVM performer, EntertainmentVM entertainment, PerformerInEntertainment.Role performerRole)
{
_performerInEntertainment = new PerformerInEntertainment(performer.PerformerDL, entertainment.EntertainmentDL, performerRole);
}
public static PerformerInEntertainment[] GetPerformerInEntertainmentByEntertainmentAndRole(Entertainment entertainment, PerformerInEntertainment.Role role)
{
lock (_locker)
{
List <PerformerInEntertainment> result = new List <PerformerInEntertainment>();
_dataAdapter.SelectCommand.CommandText = "SELECT * FROM " + _tableName + " WHERE EntertainmentId=@id AND PerformerRole=@role";
if (!_dataAdapter.SelectCommand.Parameters.Contains("@id"))
{
_dataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@id", entertainment.Id));
}
else
{
_dataAdapter.SelectCommand.Parameters["@id"].Value = entertainment.Id;
}
if (!_dataAdapter.SelectCommand.Parameters.Contains("@role"))
{
_dataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@role", role.ToString()));
}
else
{
_dataAdapter.SelectCommand.Parameters["@role"].Value = role.ToString();
}
_dataAdapter.Fill(_dataTable);
var selectedRows = from row in _dataTable.AsEnumerable().AsParallel()
where ((Guid)row["EntertainmentId"] == entertainment.Id) &&
((PerformerInEntertainment.Role)Enum.Parse(typeof(PerformerInEntertainment.Role), row["PerformerRole"].ToString()) == role)
select row;
foreach (DataRow dr in selectedRows)
{
result.Add(new PerformerInEntertainment(dr));
}
if (result.Count != 0)
{
return(result.ToArray());
}
return(null);
}
}
public PerformerInEntertainment(Performer performer, Entertainment entertainment, PerformerInEntertainment.Role performerRole) : base()
{
PerformerId = performer.Id;
EntertainmentId = entertainment.Id;
PerformerRole = performerRole;
}
public static Performer[] GetPerformerByEntertainmentAndRole(Entertainment entertainment, PerformerInEntertainment.Role role)
{
PerformerInEntertainment[] performerInEntertainments = PerformerInEntertainment.GetPerformerInEntertainmentByEntertainmentAndRole(entertainment, role);
if (performerInEntertainments == null)
{
return(null);
}
List <Guid> ids = new List <Guid>();
foreach (var performerInEntertainment in performerInEntertainments)
{
ids.Add(performerInEntertainment.PerformerId);
}
return(Performer.GetByIds(ids.ToArray()));
}
private PerformerVM[] GetPerformerVMByEntertainmentVMAndRole(EntertainmentVM entertainment, PerformerInEntertainment.Role role)
{
Performer[] performers = Performer.GetPerformerByEntertainmentAndRole(entertainment.EntertainmentDL, role);
if (performers == null)
{
return(null);
}
List <PerformerVM> result = new List <PerformerVM>();
foreach (var performer in performers)
{
result.Add(new PerformerVM(performer));
}
return(result.ToArray());
}
public PerformerInEntertainmentVM(PerformerVM performer, EntertainmentVM entertainment, PerformerInEntertainment.Role performerRole)
{
_performerInEntertainment = new PerformerInEntertainment(performer.PerformerDL, entertainment.EntertainmentDL, performerRole);
Logger.Info("PerformerInEntertainmentVM.PerformerInEntertainmentVM", "Екземпляр PerformerInEntertainmentVM створений.");
}