/// <summary>
/// Loads in defaults from recourses to the dataset upon startup.
/// </summary>
public void loadDefaultData()
{
traitsDict = new DataSet1.traitDataTable();
ancestories = new DataSet1.ancestryDataTable();
equipment = new DataSet1.equipmentDataTable();
experiences = new DataSet1.experienceDataTable();
types = new DataSet1.typeDataTable();
sizes = new DataSet1.sizeDataTable();
StringReader stream;
stream = new StringReader(Properties.Resources.traits_saf);
traitsDict.ReadXml(stream);
stream = new StringReader(Properties.Resources.ancestories_saf);
ancestories.ReadXml(stream);
stream = new StringReader(Properties.Resources.equipment_saf);
equipment.ReadXml(stream);
stream = new StringReader(Properties.Resources.experiences_saf);
experiences.ReadXml(stream);
stream = new StringReader(Properties.Resources.types_saf);
types.ReadXml(stream);
stream = new StringReader(Properties.Resources.sizes_saf);
sizes.ReadXml(stream);
stream.Close();
}
private void FillFormCombo()
{
try
{
//TYPE MATERIEL //
DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
typeAdaptater.Fill(tab1);
List <ListItem> listitem = new List <ListItem>();
foreach (DataSet1.typeRow Row in tab1.Rows)
{
listitem.Add(new ListItem(Row.nom, Row.id_type));
}
formFieldTypeMateriel.DataSource = listitem;
//CLIENT //
DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable();
clientAdaptater.Fill(tab2);
List <ListItem> listitem2 = new List <ListItem>();
foreach (DataSet1.clientRow Row in tab2.Rows)
{
listitem2.Add(new ListItem(Row.name, Row.id_client));
}
formFieldClient.DataSource = listitem2;
//SITE//
DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter();
DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable();
siteAdaptater.Fill(tab3);
List <ListItem> listitem3 = new List <ListItem>();
foreach (DataSet1.siteRow Row in tab3.Rows)
{
listitem3.Add(new ListItem(Row.nom, Row.id_site));
}
formFieldSite.DataSource = listitem3;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// dbConnection.Close();
}
private void FillCombo()
{
try
{
DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
typeAdaptater.Fill(tab1);
List <ListItem> listitem = new List <ListItem>();
listitem.Add(new ListItem("Indifferent", 0));
foreach (DataSet1.typeRow Row in tab1.Rows)
{
listitem.Add(new ListItem(Row.nom, Row.id_type));
}
comboBox1.DataSource = listitem;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// dbConnection.Close();
}
/// <summary>
/// Loads binary from path, extracts dictionary with xml strings, loads xml strings into fresh databases.
/// </summary>
/// <param path="import file location"></param>
/// TODO:
/// Find a way to reuse stream here it must be possible
public void importTables(String path)
{
traitsDict = new DataSet1.traitDataTable();
ancestories = new DataSet1.ancestryDataTable();
equipment = new DataSet1.equipmentDataTable();
experiences = new DataSet1.experienceDataTable();
types = new DataSet1.typeDataTable();
sizes = new DataSet1.sizeDataTable();
units = new DataSet1.unitDataTable();
Dictionary <string, string> xmlStringDict;
FileStream s = new FileStream(path, FileMode.Open);
BinaryFormatter b = new BinaryFormatter();
xmlStringDict = (Dictionary <string, string>)b.Deserialize(s);
StringReader stream;
stream = new StringReader(xmlStringDict["ancestories"]);
ancestories.ReadXml(stream);
stream = new StringReader(xmlStringDict["traitsDict"]);
traitsDict.ReadXml(stream);
stream = new StringReader(xmlStringDict["equipment"]);
equipment.ReadXml(stream);
stream = new StringReader(xmlStringDict["experiences"]);
experiences.ReadXml(stream);
stream = new StringReader(xmlStringDict["types"]);
types.ReadXml(stream);
stream = new StringReader(xmlStringDict["sizes"]);
sizes.ReadXml(stream);
stream.Close();
s.Close();
}
private void FillFormCombo()
{
try
{
//TYPE MATERIEL //
DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
typeAdaptater.Fill(tab1);
List<ListItem> listitem = new List<ListItem>();
foreach (DataSet1.typeRow Row in tab1.Rows)
{
listitem.Add(new ListItem(Row.nom, Row.id_type));
}
formFieldTypeMateriel.DataSource = listitem;
//CLIENT //
DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable();
clientAdaptater.Fill(tab2);
List<ListItem> listitem2 = new List<ListItem>();
foreach (DataSet1.clientRow Row in tab2.Rows)
{
listitem2.Add(new ListItem(Row.name, Row.id_client));
}
formFieldClient.DataSource = listitem2;
//SITE//
DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter();
DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable();
siteAdaptater.Fill(tab3);
List<ListItem> listitem3 = new List<ListItem>();
foreach (DataSet1.siteRow Row in tab3.Rows)
{
listitem3.Add(new ListItem(Row.nom, Row.id_site));
}
formFieldSite.DataSource = listitem3;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// dbConnection.Close();
}
private void FillCombo()
{
try
{
DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
typeAdaptater.Fill(tab1);
List<ListItem> listitem = new List<ListItem>();
listitem.Add(new ListItem("Indifferent", 0));
foreach (DataSet1.typeRow Row in tab1.Rows)
{
listitem.Add(new ListItem(Row.nom, Row.id_type));
}
comboBox1.DataSource = listitem;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// dbConnection.Close();
}
