public CustomerData getCustomerDetails(String customerID) { CustomerData customerData = new CustomerData(); try { String query = "SELECT * from customer where ID = '" + customerID + "'"; conn = new SqlConnection(connectionString); SqlCommand comm = new SqlCommand(query, conn); conn.Open(); reader = comm.ExecuteReader(); while (reader.Read()) { customerData.setFirstName(reader.GetString(1)); customerData.setLastName(reader.GetString(2)); customerData.setAddress(reader.GetString(3)); customerData.setEmail(reader.GetString(4)); customerData.setMobileNumer(reader.GetInt32(5)); customerData.setFixedNumber(reader.GetInt32(6)); } } catch (SqlException ex) { throw ex; } finally { if (conn != null) { conn.Close(); } } return(customerData); }
public UpdateCustomer(String customerID) { InitializeComponent(); DataContext = this; this.customerID = customerID; handleDatabase = new HandleDatabase(); customer = handleDatabase.getCustomerDetails(customerID); }
private async void saveButton_Click(object sender, RoutedEventArgs e) { val = new Validation(); if (val.isEmpty(firstName) || val.isEmpty(lastName) || val.isEmpty(addressLine1) || val.isEmpty(addressLine2) || val.isEmpty(addressLine3) || val.isEmpty(email) || val.isEmpty(mobileNumber.ToString()) || val.isEmpty(FixedLine.ToString())) { await this.ShowMessageAsync("Error", "Input Data Cannot Be Empty", MessageDialogStyle.Affirmative); } else if (val.isNumeric(mobileNumber.ToString()) || val.isNumeric(FixedLine.ToString())) { await this.ShowMessageAsync("Error", "Contact Numbers Should Be Numeric", MessageDialogStyle.Affirmative); } else { int affectedLines = 0; customerData = new CustomerData(); customerData.setFirstName(firstName); customerData.setLastName(lastName); customerData.setAddress(addressLine1, addressLine2, addressLine3); customerData.setEmail(email); customerData.setMobileNumer(mobileNumber); customerData.setFixedNumber(fixedNumber); try { handleDatabase = new HandleDatabase(); affectedLines = handleDatabase.executeCustomerEntry(customerData); if (affectedLines > 0) { await this.ShowMessageAsync("Successfull", "Customer have been Successfully Entered", MessageDialogStyle.Affirmative); FirstName.Text = ""; LastName.Text = ""; Address1.Text = ""; Address2.Text = ""; Address3.Text = ""; Email.Text = ""; FixedLine.Text = ""; Mobile.Text = ""; } else { await this.ShowMessageAsync("Error", "Sorry Can not Create the Profile, Please Try again", MessageDialogStyle.Affirmative); } } catch (SqlException sqlException) { Console.WriteLine(sqlException); } } }
private async void saveButton_Click(object sender, RoutedEventArgs e) { val = new Validation(); if (val.isEmpty(firstName) || val.isEmpty(lastName) || val.isEmpty(addressLine1) || val.isEmpty(addressLine2) || val.isEmpty(addressLine3) || val.isEmpty(email) || val.isEmpty(mobileContact.ToString()) || val.isEmpty(homeContact.ToString())) { await this.ShowMessageAsync("Error", "Input Data Cannot Be Empty", MessageDialogStyle.Affirmative); } else { int affectedLines = 0; customer = new CustomerData(); customer.setFirstName(FirstName.Text); customer.setLastName(LastName.Text); customer.setAddress(Address1.Text + ' ' + Address2.Text + ' ' + Address3.Text); customer.setEmail(Email.Text); customer.setMobileNumer(Convert.ToInt32(MobileContact.Text)); customer.setFixedNumber(Convert.ToInt32(HomeContact.Text)); try { handleDatabase = new HandleDatabase(); affectedLines = handleDatabase.executeCustomerUpdate(customer, customerID); if (affectedLines > 0) { await this.ShowMessageAsync("Successfull", "Customer have been Successfully Updates", MessageDialogStyle.Affirmative); ViewCustomers view = new ViewCustomers(); view.Show(); this.Close(); } else { await this.ShowMessageAsync("Error", "Sorry Can not Update, Please Try again", MessageDialogStyle.Affirmative); ViewCustomers view = new ViewCustomers(); view.Show(); this.Close(); } } catch (SqlException sqlException) { Console.WriteLine(sqlException); } } }
public int executeCustomerUpdate(CustomerData customer, String CustomerID) { String firstName = customer.getFirstName(); String lastName = customer.getLastName(); String address = customer.getAddress(); int mobile = customer.getMobileNumber(); int fixedNumber = customer.getFixedNumber(); String email = customer.getEmail(); String query = "UPDATE customer SET firstName = @firstName, lastName = @lastName, address = @Address, email = @email, mobile = @Mobile, fixedNumber = @fixedNumber WHERE ID = @CustomerID"; int affectedLines = 0; try { conn = new SqlConnection(connectionString); SqlCommand comm = new SqlCommand(query, conn); comm.Parameters.AddWithValue("@CustomerID", Convert.ToInt32(CustomerID)); comm.Parameters.AddWithValue("@firstName", firstName); comm.Parameters.AddWithValue("@lastName", lastName); comm.Parameters.AddWithValue("@Address", address); comm.Parameters.AddWithValue("@Mobile", mobile); comm.Parameters.AddWithValue("@fixedNumber", fixedNumber); comm.Parameters.AddWithValue("@email", email); conn.Open(); affectedLines = comm.ExecuteNonQuery(); } catch (SqlException ex) { throw ex; } finally { if (conn != null) { conn.Close(); } } return(affectedLines); }
public int executeCustomerEntry(CustomerData customer) { String firstName = customer.getFirstName(); String lastName = customer.getLastName(); String address = customer.getAddress(); int mobile = customer.getMobileNumber(); int fixedNumber = customer.getFixedNumber(); String email = customer.getEmail(); String query = "INSERT INTO customer(firstName, lastName, address, email, mobile, fixedNumber) VALUES (@firstName, @lastName, @Address, @email, @Mobile, @fixedNumber)"; int affectedLines = 0; try { conn = new SqlConnection(connectionString); SqlCommand comm = new SqlCommand(query, conn); comm.Parameters.AddWithValue("@firstName", firstName); comm.Parameters.AddWithValue("@lastName", lastName); comm.Parameters.AddWithValue("@Address", address); comm.Parameters.AddWithValue("@Mobile", mobile); comm.Parameters.AddWithValue("@fixedNumber", fixedNumber); comm.Parameters.AddWithValue("@email", email); conn.Open(); affectedLines = comm.ExecuteNonQuery(); } catch (SqlException ex) { throw ex; } finally { if (conn != null) { conn.Close(); } } return(affectedLines); }