1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:

    public class Customer
    {
        public Customer()
        {
            ListCostumerContact = new List<CustomerContact>();
            ListCostumerTP = new List<CustomerTP>();
            ListCostumerUnit = new List<CustomerUnit>();
        }
        
        public long Id { get; set; }
        public long CustomerId { get; set; }
        public string CompanyName { get; set; }
        public string InvoiceName { get; set; }
        public string Charge { get; set; }
        public string Street { get; set; }
        public string Postale { get; set; }
        public string City { get; set; }
        public int ChargeBegin { get; set; }
        public int ChargeEnd { get; set; }
        public int HasTp { get; set; }
        public int HastUnit { get; set; }
        public int Active { get; set; }
        public long? DocumentPath { get; set; }
        public List<CustomerContact> ListCostumerContact { get; set; }
        public List<CustomerTP> ListCostumerTP { get; set; }
        public List<CustomerUnit> ListCostumerUnit { get; set; }

        public bool IsValid
        {
            get
            {
                return !string.IsNullOrWhiteSpace(CompanyName) &&
                        !string.IsNullOrWhiteSpace(InvoiceName) &&
                        !string.IsNullOrWhiteSpace(Charge) &&
                        !string.IsNullOrWhiteSpace(Street) &&
                        !string.IsNullOrWhiteSpace(Postale) &&
                        !string.IsNullOrWhiteSpace(City) &&
                        DocumentPath.HasValue;
            }
        }

    }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:

    public class CustomerContact
    {
        private static long _costumerContactId = 1;

        public CustomerContact()
        {
            CostumerContactId = _costumerContactId;
            _costumerContactId++;
        }

        public long CostumerContactId { get; set; }
        public string Authority { get; set; }
        public string Name { get; set; }
        public string Email { get; set; }
        public string Number { get; set; }
        public string Mobil { get; set; }
        public string Fax { get; set; }
    }

    public class CustomerTP
    {
        private static long _customerTpId = 1;

        public CustomerTP()
        {
            CostumerTpId = _customerTpId;
            _customerTpId++;
        }

        public long CostumerTpId { get; set; }
        public string TP { get; set; }
    }

    public class CustomerUnit
    {
        private static long _customerUnitId = 1;

        public CustomerUnit()
        {
            CostumerUnitId = _customerUnitId;
            _customerUnitId++;
        }

        public long CostumerUnitId { get; set; }
        public string Unit { get; set; }
    }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

        long employee = 0;
        Customer newCustomer = new Customer();

        public KundeNeuUserControl(long uebergabe)
        {
            InitializeComponent();
            employee = uebergabe;
        }

        private void KundeNeuUserControl_Load(object sender, EventArgs e)
        {
            bsCustomer.DataSource = newCustomer;
            bsListCustomerContact.DataSource = new CustomerContact();
            txtAnsprech.Select();

            try
            {
                cmbDocument.DataSource = CustomerMethods.GetAllForms();
                cmbDocument.DisplayMember = "name";
                cmbDocument.ValueMember = "vorlagengrundid";
                cmbDocument.SelectedIndex = -1;
            }
            catch (Exception ex)
            {
                MySqlError.SetError(ex.Message, this.ToString(), Global.GetCurrentFunctionName());
                MsgAusgabe.ShowError(ex.Message);
            }
        }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

        private void btnContactErfassen_Click(object sender, EventArgs e)
        {
            CustomerContact contact = bsListCustomerContact.Current as CustomerContact;
            
            //ZUm Test wollte ich mir die Namen mal ausgeben lassen
            foreach (CustomerContact customerContact in newCustomer.ListCostumerContact)
            {
                MsgAusgabe.ShowInformation(customerContact.Name.ToString());
            }
        }					

1:
2:

bsCustomer.DataSource = newCustomer;
bsListCustomerContact.DataSource = new CustomerContact();					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

    public class Customer
    {
        public Customer()
        {
            ListCostumerContact = new List<CustomerContact>();
        }
        
        public long Id { get; set; }
        public long CustomerId { get; set; }
        public string CompanyName { get; set; }
        public string InvoiceName { get; set; }
        public string Charge { get; set; }
        public string Street { get; set; }
        public string Postale { get; set; }
        public string City { get; set; }
        public int ChargeBegin { get; set; }
        public int ChargeEnd { get; set; }
        public int HasTp { get; set; }
        public int HastUnit { get; set; }
        public int Active { get; set; }
        public long? DocumentPath { get; set; }
        public List<CustomerContact> ListCostumerContact { get; set; }
    }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

    public class CustomerContact
    {
        private static long _costumerContactId = 1;

        public CustomerContact(string authority, string name, string email, string number, string mobil, string fax)
        {
            CostumerContactId = _costumerContactId;
            _costumerContactId++;

            Authority = authority;
            Name = name;
            Email = email;
            Number = number;
            Mobil = mobil;
            Fax = fax;
        }

        public long CostumerContactId { get; set; }
        public string Authority { get; set; }
        public string Name { get; set; }
        public string Email { get; set; }
        public string Number { get; set; }
        public string Mobil { get; set; }
        public string Fax { get; set; }
    }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:

    public partial class KundeUserControl : UserControl
    {
        long employee = 0;
        Customer newCustomer = new Customer();

        public KundeUserControl(long uebergabe)
        {
            InitializeComponent();
            employee = uebergabe;
        }

        private void KundeNeuUserControl_Load(object sender, EventArgs e)
        {
            bsCustomer.DataSource = newCustomer;
            txtAnsprech.Select();
        }					

1:
2:
3:
4:

        private void btnContactErfassen_Click(object sender, EventArgs e)
        {
            newCustomer.ListCostumerContact.Add(new CustomerContact(txtZustaendig.Text, txtAnsprech.Text, txtEmail.Text, txtFestNetz.Text, txtMobil.Text, txtFestNetz.Text));
        }					

1:
2:
3:
4:

            foreach (CustomerContact customerContact in newCustomer.ListCostumerContact)
            {
                MsgBox.MsgAusgabe.ShowInformation(customerContact.Authority.ToString());
            }					

1:
2:

            
newCustomer.ListCostumerContact.Add(new CustomerContact(txtZustaendig.Text, txtAnsprech.Text, txtEmail.Text, txtFestNetz.Text, txtMobil.Text, txtFestNetz.Text));					

1:

            bsCustomerContact.Add(new CustomerContact(txtZustaendig.Text, txtAnsprech.Text, txtEmail.Text, txtFestNetz.Text, txtMobil.Text, txtFestNetz.Text));					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:

    public class CustomerContact
    {
        private static long _costumerContactId = 1;

        public CustomerContact()
        {
            CostumerContactId = _costumerContactId;
            _costumerContactId++;
        }

        public long CostumerContactId { get; set; }
        public string Authority { get; set; }
        public string Name { get; set; }
        public string Email { get; set; }
        public string Number { get; set; }
        public string Mobil { get; set; }
        public string Fax { get; set; }

        public bool IsValid
        {
            get
            {
                return !string.IsNullOrWhiteSpace(Name);
            }
        }
    }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:

        public static List<CustomerContact> GetListCustomerContact(long uebergabe)
        {
            List<CustomerContact> myList = new List<CustomerContact>();
            strSQL = "Select * from kundekontakt where kundeid=?kundeid";

            using (MySqlConnection conn = new MySqlConnection(connStr))
            {
                using (MySqlCommand cmd = new MySqlCommand(strSQL, conn))
                {
                    conn.Open();

                    cmd.Parameters.AddWithValue("?kundeid", uebergabe);

                    MySqlDataReader dr = cmd.ExecuteReader();

                    while (dr.Read())
                    {
                        myList.Add(new CustomerContact());
                    }

                    conn.Close();
                }
            }

            return myList;
        }					

1:
2:
3:
4:
5:
6:
7:

while (dr.Read())
{
   var contact = new CustomerContact();
   contact.Ansprechpartner = dr.getstring("Ansprechpartner");
   // u.s.w.
   myList.Add(contact);
}					

1:

                        myList.Add(new CustomerContact() { CostumerContactId = dr.GetInt64("kundekontaktid"), Authority = dr.GetString("zustaendig")  });