I'm making a Visual Studio project for adding and reading customers form a MS SQL server. The values I ad via Visual Studio cannot be seen.
Here is the SQL code:
create Table Person
(
Id int PRIMARY KEY,
FirstName varchar (15),
LastName varchar (15),
TaxNbr int,
BirthDate DATETIME,
AktivStatus varchar (15),
);
And here is the part of C# where I am adding new values for the customer:
private void Button_AddCustomer(object sender, RoutedEventArgs e)
{
Person customer = new Person();
int number;
customer.FirstName = FirstName.Text.Trim();
customer.LastName = LastName.Text.Trim();
if (int.TryParse(TaxNbr.Text, out number) == false) MessageBox.Show("Must add a valid tax number");
if (number < 0 || number > 999) MessageBox.Show("Invalid Tax Number. Must be between 0 and 999");
else customer.TaxNbr = number;
customer.BirthDate = BirthDate.DisplayDate;
if (Aktiven.IsChecked == true) customer.AktivStatus = "Aktiven";
if (Neaktiven.IsChecked == true)
{
customer.AktivStatus = "Neaktiven";
}
CustomerClass.AddCustomer(customer);
DialogResult = true;
}
I have connected it with SQL class:
public static class CustomerClass
{
#region
public static void AddCustomer(Person customer)
{
using (CustomerDataContext conn = new CustomerDataContext())
{
conn.Persons.InsertOnSubmit(customer);
conn.SubmitChanges();
}
}
#endregion
}
Please help, I am a beginner :)
