private void BtnNewCustomer_Click(object sender, RoutedEventArgs e)
{
AddCustomer(); // anropar metoden
TxtFirstname.Clear(); //ska rensa kundinfon
TxtLastname.Clear();
TxtPhone.Clear();
UpdateCustomer(); //anropa metod för att uppdatera så att comboboxen känner av att ny kund skapats
}
/// <summary>
/// Skapa ny kund
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnNewCustomer_Click(object sender, RoutedEventArgs e)
{
newCustomer = new Customer() // Skapar en ny kund
{
Firstnamne = TxtFirstname.Text,
Lastnamne = TxtLastname.Text,
Cellphone = TxtPhone.Text,
};
listOfCustomers.Add(newCustomer); // lägger till kunden i min lista av kunder
TxtFirstname.Clear(); // rensar alla textboxar
TxtLastname.Clear();
TxtPhone.Clear();
CboCustomer.ItemsSource = null; // lägger in kunden i listan av valbara kunder
CboCustomer.ItemsSource = listOfCustomers;
CboCustomer.SelectedIndex = 0;
}
//button register
private void BtnLogin_Click(object sender, EventArgs e)
{
//MessageBox.Show(rezult);
if (TxtFirstname.Text == "")
{
MessageBox.Show("Please enter confirm password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtFirstname.Focus();
return;
}
if (TxtFamilyname.Text == "")
{
MessageBox.Show("Please enter username", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtFamilyname.Focus();
return;
}
if (TxtData.Text == "")
{
MessageBox.Show("Please enter username", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtData.Focus();
return;
}
if (TxtNumber.Text == "")
{
MessageBox.Show("Please enter username", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtNumber.Focus();
return;
}
try
{
SqlConnection myConnection = default(SqlConnection);
myConnection = new SqlConnection(@"Data Source=DESKTOP-NP1RDM2\BAZALUIMARIAN;Initial Catalog=task;Persist Security Info=True;User ID=sa; Password = 0299");
String query = "INSERT INTO dbo.Clientapp (family_name,first_name,clientappdate,number) VALUES (@family_name,@first_name,@clientappdate,@number)";
using (SqlCommand command = new SqlCommand(query, con))
{
command.Parameters.AddWithValue("@family_name", TxtFamilyname.Text);
command.Parameters.AddWithValue("@first_name", TxtFirstname.Text);
command.Parameters.AddWithValue("@clientappdate", TxtData.Text);
command.Parameters.AddWithValue("@number", TxtNumber.Text);
MessageBox.Show("Register successfully !We will call you back today !", "Register Successfully", MessageBoxButtons.OK, MessageBoxIcon.Error);
con.Open();
int result = command.ExecuteNonQuery();
Hide();
// Check Error
if (result < 0)
{
MessageBox.Show("Register Denied", "Register Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtNumber.Clear();
TxtFirstname.Clear();
TxtFamilyname.Clear();
TxtData.Clear();
TxtFamilyname.Focus();
Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void CmdDelete_Click(object sender, EventArgs e)
{
LblOutput.Text = "...";
TxtFirstname.Clear();
TxtLastname.Clear();
}
