private void btnUpdateCustomer_Click(object sender, EventArgs e) { Customer currentCustomer = new Customer(); String updateName = txtName.Text.Trim(); String updatePhoneNumber = txtPhoneNumber.Text.Trim(); String updateAddress = txtAddress.Text.Trim(); bool updateIsActive = ckcActiveCustomer.Checked; if (!String.IsNullOrEmpty(selectedCustomer)) { MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection; currentCustomer = currentCustomer.findCustomerByID(mongoDBConnection.getMongoData(), selectedCustomer); Customer updateCustomer = new Customer(); if (String.IsNullOrEmpty(txtName.Text) && String.IsNullOrEmpty(txtPhoneNumber.Text)) { MessageBox.Show("Please enter name and phone number.", "Message"); } else if (String.IsNullOrEmpty(txtName.Text)) { MessageBox.Show("Please enter name field.", "Message"); } else if (String.IsNullOrEmpty(txtPhoneNumber.Text)) { MessageBox.Show("Please enter phone number field.", "Message"); } else { updateCustomer.name = updateName; updateCustomer.phoneNumber = updatePhoneNumber; updateCustomer.address = updateAddress; updateCustomer.isActive = updateIsActive; updateCustomer.modifyDate = DateTime.Now.ToUniversalTime(); currentCustomer.updateCustomer(mongoDBConnection.getMongoData(), currentCustomer, updateCustomer); MessageBox.Show("The customer is updated successfully.", "Message"); selectedCustomer = String.Empty; txtName.Clear(); txtPhoneNumber.Clear(); txtAddress.Clear(); if (ckcActiveCustomer.Checked) { ckcActiveCustomer.Checked = false; } this.displayDataTableCustomer(dataGridViewCustomer); this.loadValueCustomerCombobox(cbbCustomer); OrderTruck orderTruck = new OrderTruck(); updateCustomer = updateCustomer.findCustomerByID(mongoDBConnection.getMongoData(), currentCustomer._id.ToString()); // Update all order truck with update customer's info. orderTruck.updateOrderTruckByCustomer(mongoDBConnection.getMongoData(), updateCustomer); this.displayDataTableOrderTruck(dataGridViewOrderTruck); } } else { MessageBox.Show("Please select the customer to delete.", "Message"); } }
public void displayDataTableOrderTruck(DataGridView dataGridView) { OrderTruck orderTruckData = new OrderTruck(); MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection; List <OrderTruck> listOrderTrucks = orderTruckData.getAllOrderTrucks(mongoDBConnection.getMongoData()); listOrderTrucksFilter = listOrderTrucks; this.viewDataTableOrdertruck(dataGridViewOrderTruck, listOrderTrucks); }
private void btnAddOrderTruck_Click(object sender, EventArgs e) { String customerName = ""; String materialType = ""; String note = txtNote.Text.Trim(); if (cbbCustomer.SelectedIndex < 0) { MessageBox.Show("Please select the customer's name.", "Message"); } else if (cbbMaterialType.SelectedIndex < 0) { MessageBox.Show("Please select the material type.", "Message"); } else if (String.IsNullOrEmpty(txtSubTotal.Text.Trim())) { MessageBox.Show("Please input the subtotal.", "Message"); } else if (dateTPCompletedDay.CustomFormat == " ") { MessageBox.Show("Please select the completed day.", "Message"); } else { customerName = cbbCustomer.SelectedItem.ToString().Trim(); materialType = cbbMaterialType.SelectedItem.ToString().Trim(); MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection; Customer selectedCustomer = new Customer(); selectedCustomer = selectedCustomer.findCustomerByName(customerName, mongoDBConnection.getMongoData()); DateTime completedDay = dateTPCompletedDay.Value.ToUniversalTime(); OrderTruck newOrderTruck = new OrderTruck(); newOrderTruck.customer = selectedCustomer; newOrderTruck.materialType = materialType; newOrderTruck.subtotal = int.Parse(txtSubTotal.Text.Trim()); newOrderTruck.note = txtNote.Text.Trim(); newOrderTruck.completedDate = completedDay; newOrderTruck.createDate = DateTime.Now.ToUniversalTime(); newOrderTruck.modifyDate = DateTime.Now.ToUniversalTime(); newOrderTruck.isPaid = ckcIsPaid.Checked; this.clearOrderTruckTab(); try { newOrderTruck.addOrderTruck(mongoDBConnection.getMongoData(), newOrderTruck); MessageBox.Show("New order truck is add successfully.", "Message"); this.clearOrderTruckTab(); this.displayDataTableOrderTruck(dataGridViewOrderTruck); this.loadValueCustomeFilterCombobox(cbbSearchCustomer); this.loadValueFilterMaterialTypeCombobox(cbbSearchMaterialType); this.resetFilterValue(); } catch (Exception) { MessageBox.Show("Failed to add new order truck. Please try again.", "Message"); } } }
private void btnUpdateOrderTruck_Click(object sender, EventArgs e) { String customerName = ""; String materialType = ""; String note = txtNote.Text.Trim(); if (cbbCustomer.SelectedIndex < 0) { MessageBox.Show("Please select the customer's name to update order truck.", "Message"); } else if (cbbMaterialType.SelectedIndex < 0) { MessageBox.Show("Please select the material type to update order truck.", "Message"); } else if (String.IsNullOrEmpty(txtSubTotal.Text.Trim())) { MessageBox.Show("Please input the subtotal to update order truck.", "Message"); } //else if (dateTPCompletedDay.CustomFormat == " ") //{ // MessageBox.Show("Please select the completed day to update order truck.", "Message"); //} else { if (!String.IsNullOrEmpty(selectedOrderTruck)) { try { MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection; OrderTruck currentOrderTruck = new OrderTruck(); OrderTruck updatedOrderTruck = new OrderTruck(); Customer updatedCustomer = new Customer(); currentOrderTruck = currentOrderTruck.getOrderTruckByID(mongoDBConnection.getMongoData(), selectedOrderTruck); updatedOrderTruck.customer = updatedCustomer.findCustomerByName(cbbCustomer.SelectedItem.ToString(), mongoDBConnection.getMongoData()); updatedOrderTruck.materialType = cbbMaterialType.SelectedItem.ToString().Trim(); updatedOrderTruck.note = txtNote.Text.Trim(); updatedOrderTruck.subtotal = int.Parse(txtSubTotal.Text.Trim()); if (dateTPCompletedDay.CustomFormat == " ") { updatedOrderTruck.completedDate = currentOrderTruck.completedDate; } else { updatedOrderTruck.completedDate = dateTPCompletedDay.Value.ToUniversalTime(); } updatedOrderTruck.modifyDate = DateTime.Now.ToUniversalTime(); updatedOrderTruck.isPaid = ckcIsPaid.Checked; updatedOrderTruck.updateOrderTruck(mongoDBConnection.getMongoData(), currentOrderTruck, updatedOrderTruck); MessageBox.Show("The order truck is updated successfully.", "Message"); selectedOrderTruck = String.Empty; this.clearOrderTruckTab(); this.displayDataTableOrderTruck(dataGridViewOrderTruck); this.loadValueCustomeFilterCombobox(cbbSearchCustomer); this.loadValueFilterMaterialTypeCombobox(cbbSearchMaterialType); this.resetFilterValue(); } catch (Exception) { MessageBox.Show("Failed to update the selected order truck. Please try again.", "Message"); } } else { MessageBox.Show("Please select the order truck to update.", "Message"); } } }