// the following method returns the name and id of the campaign
public List <CampaignNames> GetAllCampaignNamesAndID()
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
List <CampaignNames> list = new List <CampaignNames>();
using (sqlconn)
{
using (SqlCommand cmd = new SqlCommand("SelectAllCampaigns", sqlconn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlconn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
CampaignNames campaignDTO = new CampaignNames
{
CampaignID = reader["CampaignID"].ToString(),
Description = reader["Description"].ToString()
};
list.Add(campaignDTO);
}
}
}
}
return(list);
}
public PathfinderTraitForm()
{
InitializeComponent();
this.loadedModifierList = CharacterCreator.Helpers.FileIO.Load <BindingList <ModifierData> >(this.modifierLoadPath);
this.traitList = CharacterCreator.Helpers.FileIO.Load <BindingList <TraitData> >(this.savePath);
this.traitBox.DataSource = this.traitList;
this.traitBox.DisplayMember = "TraitName";
this.traitBox.ValueMember = "TraitName";
this.traitTypeBox.DataSource = TraitType.GetValues(typeof(TraitType));
this.traitRegionBox.DataSource = RegionNames.GetValues(typeof(RegionNames));
this.traitCampaignBox.DataSource = CampaignNames.GetValues(typeof(CampaignNames));
this.traitRaceBox.DataSource = RaceNames.GetValues(typeof(RaceNames));
this.traitReligionBox.DataSource = ReligionNames.GetValues(typeof(ReligionNames));
this.traitConditionBox.DataSource = ConditionalStates.GetValues(typeof(ConditionalStates));
}
