public void SetSelectedMember( Member member )
{
var ix = members.FindIndex( delegate( Member r )
{
return member != null && r.Id == member.Id;
} );
MembersListView.SelectIndex( ix );
MembersListView.EnsureVisible( ix );
}
public static MemberDog Load( Dog dog, Member member )
{
using( var db = Database.Get() )
{
try
{
return db.Single<MemberDog>( "WHERE Memberid=@0 AND DogId=@1", member.Id, dog.Id );
}
catch { return null; }
}
}
public EditMemberForm( Member member, List<Member> members )
{
Member = member;
Members = members;
InitializeComponent();
UI();
Bind();
}
public EditDogEventResultsForm( Member member, Dog dog, DogEvent dogEvent, DogEventResults results )
{
Member = member;
Dog = dog;
DogEvent = dogEvent;
DogEventResults = results;
InitializeComponent();
UI();
Bind();
}
public static void InsertDummy()
{
var member = new Member()
{
Name = "Piet",
Surname = "Pietersen",
Address = "Pietersenlaan 99",
PostalCode = "9999 AB",
Location = "Lutjebroek",
PhoneNumber = "+319999999999"
};
if( Load( member.Name, member.Surname ) == null )
member.Insert();
}
public static List<Dog> List( Member member )
{
using( var db = Database.Get() )
{
return db.Fetch<Dog>(
@"INNER JOIN
MemberDog
ON
MemberDog.DogId = Dog.Id
WHERE
MemberDog.MemberId=@0
ORDER BY Name ASC",
member.Id );
}
}
public static void Insert( this Dog dog, Member member )
{
using( var db = Database.Get() )
{
try
{
db.BeginTransaction();
db.Insert( dog );
db.Insert( new MemberDog() { DogId = dog.Id, MemberId = member.Id } );
db.EndTransaction();
}
catch( SQLiteException exc )
{
db.AbortTransaction();
throw new ApplicationException( "Cannot delete dog " + dog.Name, exc );
}
}
}
public DogChartsForm( Dog dog, Member member, List<DogEventResults> dogEventResults )
{
Dog = dog;
Member = member;
InitializeComponent();
Text = string.Format( "Resultaten voor " + GetTitleTemplate() );
PrepareData( dogEventResults );
AddHighJumpChart();
AddFarJumpChart();
AddWallClimbChart();
AddTugOfWarChart();
AddSprintRaceChart();
AddWeightPullChart();
ChartSelectionComboBox.SelectedIndex = 0;
}
public DogsForm( Member member, bool selectMode )
{
Member = member;
SelectMode = selectMode;
InitializeComponent();
UI();
LoadDogs();
LoadPhotos();
Bind();
DogPhotoControl.Bind( "Data" );
UpdateView();
DogsListView.SelectIndex( 0 );
}
private ListViewItem CreateListItem( Member member )
{
var item = new ListViewItem( member.Name );
item.SubItems.Add( member.Surname );
item.SubItems.Add( member.Address );
item.SubItems.Add( member.PostalCode );
item.SubItems.Add( member.Location );
item.SubItems.Add( member.PhoneNumber );
return item;
}
private void Push( Member member )
{
popped = member;
}
private ListViewItem CreateListItem( Member member, Dog dog )
{
var item = new ListViewItem( dog.Name );
item.SubItems.Add( member.FullName );
item.SubItems.Add( dog.Race );
return item;
}
private ListViewItem CreateListItem( Dog dog, Member member, DogEvent dogEvent, DogEventResults results )
{
var item = new ListViewItem( dog.Name );
item.SubItems.Add( dogEvent.Date.ToShortDateString() );
item.SubItems.Add( member.FullName );
item.SubItems.Add( results.HighJump.ToString() );
item.SubItems.Add( results.FarJump.ToString() );
item.SubItems.Add( results.WallClimb.ToString() );
item.SubItems.Add( results.TugOfWar.ToString() );
item.SubItems.Add( results.SprintRace.ToString() );
item.SubItems.Add( results.WeightPull.ToString() );
return item;
}
