private async void B_Customers_Click(object sender, RoutedEventArgs e) { // Getting CrudAPI var crudAPI = UnicontaAPIManager.GetCrudAPI(); crudAPI.RunInTransaction = false; // Parsing CSV var customers = CSVUtils.ParseCustomers(@"C:\src\Uniconta\Technical-Training-Cases-master\TrainingData\CompanyData\Finace-Customers.csv"); // Creating Insert List var newDebtorClients = new List <DebtorClient>(); foreach (var customer in customers) { // Parsing Account Number var accountNumber = (int.Parse(customer.AccountNumber) + 20000).ToString(); // TODO: Add the customer to the newDebtorClients List } ; // Calling insert API // TODO: Call the insert API to insert newDebtorClients }
private async void LoadDebtors() { var crudAPI = UnicontaAPIManager.GetCrudAPI(); var debtors = await crudAPI.Query <Debtor>(); this.CB_Customers.ItemsSource = debtors; this.CB_Customers.SelectedItem = debtors.FirstOrDefault(); }
private async void LoadCustomers() { var crudAPI = UnicontaAPIManager.GetCrudAPI(); // TODO: Query for debtors in the current Company this.CB_Customer.ItemsSource = debtors; this.CB_Customer.SelectedItem = debtors.FirstOrDefault(); }
private async Task RefreshCustomers() { var crudAPI = UnicontaAPIManager.GetCrudAPI(); var customers = await crudAPI.Query <Debtor>(); this.selectedCustomer = customers.FirstOrDefault(); CustomerPicker.ItemsSource = customers; CustomerPicker.SelectedItem = this.selectedCustomer; }
// MenuPosition // 0 = General Ledger // 1 = Customer // 2 = Vendor // 3 = Inventory // 4 = Project // 5 = Company // 6 = Tools // 7 = None // 8 = CRM private async void Button_TrackGenres(object sender, RoutedEventArgs e) { //TODO: Change to test Company var company = UnicontaAPIManager.GetCompanyByName("TT-WEEK3"); var crudAPI = UnicontaAPIManager.GetCrudAPI(company); // TrackGenres // TODO: Create a TableHeader with the TrackGenre // TODO: Call Insert API to insert the TrackGenere Table }
private async void B_Customers_Click(object sender, RoutedEventArgs e) { // Getting CrudAPI var crudAPI = UnicontaAPIManager.GetCrudAPI(); crudAPI.RunInTransaction = false; // Parsing CSV var customers = CSVUtils.ParseCustomers(@"C:\src\Uniconta\Technical-Training-Cases-master\TrainingData\CompanyData\Finace-Customers.csv"); // Creating Insert List var newDebtorClients = new List <DebtorClient>(); foreach (var customer in customers) { // Parsing Account Number var accountNumber = (int.Parse(customer.AccountNumber) + 20000).ToString(); newDebtorClients.Add(new DebtorClient { _Account = accountNumber.ToString(), _Name = customer.AccountName, _Address1 = customer.Address1, _Address2 = customer.Address2, _ZipCode = customer.ZIP, _Phone = customer.Telephone }); } ; // Calling insert API var errorCode = await crudAPI.Insert(newDebtorClients); if (errorCode != ErrorCodes.Succes) { MessageBox.Show($"ERROR: Failed to import customers {errorCode.ToString()}"); } else { MessageBox.Show("Import Completed"); } }
private async void B_Items_Click(object sender, RoutedEventArgs e) { // Getting CrudAPI var crudAPI = UnicontaAPIManager.GetCrudAPI(); crudAPI.RunInTransaction = false; // Parsing CSV var items = CSVUtils.ParseItems(@"C:\src\Uniconta\Technical-Training-Cases-master\TrainingData\CompanyData\Finace-Items.csv"); // Creating Insert List var newInvItemClients = new List <InvItemClient>(); foreach (var item in items) { // TODO: Add the item to the newInvItemClients List } ; // Calling insert API // TODO: Call the insert API to insert newInvItemClients }
private async void B_Items_Click(object sender, RoutedEventArgs e) { // Getting CrudAPI var crudAPI = UnicontaAPIManager.GetCrudAPI(); crudAPI.RunInTransaction = false; // Parsing CSV var items = CSVUtils.ParseItems(@"C:\src\Uniconta\Technical-Training-Cases-master\TrainingData\CompanyData\Finace-Items.csv"); // Creating Insert List var newInvItemClients = new List <InvItemClient>(); foreach (var item in items) { newInvItemClients.Add(new InvItemClient { _Item = item.Item, _Name = item.ItemName, _SalesPrice1 = item.SalesPrice, _Group = "Grp1" }); } ; // Calling insert API var errorCode = await crudAPI.Insert(newInvItemClients); if (errorCode != ErrorCodes.Succes) { MessageBox.Show($"ERROR: Failed to import items {errorCode.ToString()}"); } else { MessageBox.Show("Import Completed"); } }
// MenuPosition // 0 = General Ledger // 1 = Customer // 2 = Vendor // 3 = Inventory // 4 = Project // 5 = Company // 6 = Tools // 7 = None // 8 = CRM private async void Button_TrackGenres(object sender, RoutedEventArgs e) { //TODO: Change to test Company var company = UnicontaAPIManager.GetCompanyByName("TT-WEEK3"); var crudAPI = UnicontaAPIManager.GetCrudAPI(company); // TrackGenres var trackGenres = new TableHeader { // Key _HasPrimaryKey = true, _PKprompt = "TrackGenreId", _AutoKey = true, // Description _Name = "TrackGenres", _Prompt = "Track Genres", _MenuPosition = 3, _UserDefinedId = 2050, // Settings _EditLines = true }; var errorCode = await crudAPI.Insert(trackGenres); if (errorCode != ErrorCodes.Succes) { MessageBox.Show($"Failed to insert Track Genres {errorCode.ToString()}"); return; } else { MessageBox.Show("Track Genres table has been created"); } }
private async void Button_Tracks(object sender, RoutedEventArgs e) { //TODO: Change to test Company var company = UnicontaAPIManager.GetCompanyByName("TT-WEEK3"); var crudAPI = UnicontaAPIManager.GetCrudAPI(company); // Tracks // TODO: Create a TableHeader with the Track // Inserting Table // TODO: Call Insert API to insert the Track Table // Creating Fields var tracksFields = new List <TableField>(); // Title // TODO: Create a TableField for the Title // Artist // TODO: Create a TableField for the Artist // Genre // TODO: Create a TableField for the Genre // Vibe // TODO: Create a TableField for the Vibe // Length // TODO: Create a TableField for the Length // LicensePaid // TODO: Create a TableField for the LicensePaid // Inserting Fields // TODO: Call Insert API to insert the Track Fields }
private async void B_Orders_Click(object sender, RoutedEventArgs e) { // Getting CrudAPI var crudAPI = UnicontaAPIManager.GetCrudAPI(); crudAPI.RunInTransaction = false; // Parsing CSV var orders = CSVUtils.ParseOrders(@"C:\src\Uniconta\Technical-Training-Cases-master\TrainingData\CompanyData\Finace-Orders.csv"); // Creating SQLCache's // TODO: Create a customer (DebtorClient) SQLCache // TODO: Create a inventory (InvItemClient) SQLCache // Creating Insert List var newDebtorOrderClients = new List <DebtorOrderClient>(); foreach (var order in orders) { // Parsing Account Number var accountNumber = (int.Parse(order.AccountNumber) + 20000).ToString(); // Finding customer in cache // TODO: Use the customerCache to get the customer by accountNumber // TODO: Add the order to the newDebtorOrderClients List + SetMaster } ; // Calling insert API var errorCode = await crudAPI.Insert(newDebtorOrderClients); if (errorCode != ErrorCodes.Succes) { MessageBox.Show($"ERROR: Failed to import orders {errorCode.ToString()}"); } // Creating order lines var newDebtorOrderLineClients = new List <DebtorOrderLineClient>(); var inventoryList = inventoryCache.GetRecords as InvItemClient[]; var index = 0; foreach (var debtorOrder in newDebtorOrderClients) { var orderItems = orders[index].Items; foreach (var item in orderItems) { var inventoryItem = inventoryList.FirstOrDefault(i => i.Name == item.ItemName); // TODO: Add the item to the newDebtorOrderLineClients List + SetMaster } ; index++; } ; // Calling insert API // TODO: Call the insert API to insert newDebtorOrderLineClients }
private async void B_Orders_Click(object sender, RoutedEventArgs e) { // Getting CrudAPI var crudAPI = UnicontaAPIManager.GetCrudAPI(); crudAPI.RunInTransaction = false; // Parsing CSV var orders = CSVUtils.ParseOrders(@"C:\src\Uniconta\Technical-Training-Cases-master\TrainingData\CompanyData\Finace-Orders.csv"); // Creating SQLCache's SQLCache customerCache = crudAPI.CompanyEntity.GetCache(typeof(DebtorClient)); if (customerCache == null) { customerCache = await crudAPI.CompanyEntity.LoadCache(typeof(DebtorClient), crudAPI); } SQLCache inventoryCache = crudAPI.CompanyEntity.GetCache(typeof(InvItemClient)); if (inventoryCache == null) { inventoryCache = await crudAPI.CompanyEntity.LoadCache(typeof(InvItemClient), crudAPI); } // Creating Insert List var newDebtorOrderClients = new List <DebtorOrderClient>(); foreach (var order in orders) { // Parsing Account Number var accountNumber = (int.Parse(order.AccountNumber) + 20000).ToString(); // Finding customer in cache var customer = customerCache.Get(accountNumber) as DebtorClient; var newDebtorOrderClient = new DebtorOrderClient { _Created = order.CreatedDate }; newDebtorOrderClient.SetMaster(customer); newDebtorOrderClients.Add(newDebtorOrderClient); } ; // Calling insert API var errorCode = await crudAPI.Insert(newDebtorOrderClients); if (errorCode != ErrorCodes.Succes) { MessageBox.Show($"ERROR: Failed to import orders {errorCode.ToString()}"); } // Creating order lines var newDebtorOrderLineClients = new List <DebtorOrderLineClient>(); var inventoryList = inventoryCache.GetRecords as InvItemClient[]; var index = 0; foreach (var debtorOrder in newDebtorOrderClients) { var orderItems = orders[index].Items; foreach (var item in orderItems) { var inventoryItem = inventoryList.FirstOrDefault(i => i.Name == item.ItemName); var orderLine = new DebtorOrderLineClient { _Item = inventoryItem.Item, _Qty = 1, _Price = inventoryItem.SalesPrice1 }; orderLine.SetMaster(debtorOrder); newDebtorOrderLineClients.Add(orderLine); } ; index++; } ; // Calling insert API var errorCode2 = await crudAPI.Insert(newDebtorOrderLineClients); if (errorCode2 != ErrorCodes.Succes) { MessageBox.Show($"ERROR: Failed to import order lines {errorCode2.ToString()}"); } else { MessageBox.Show("Import Completed"); } }
private async void Button_Tracks(object sender, RoutedEventArgs e) { //TODO: Change to test Company var company = UnicontaAPIManager.GetCompanyByName("TT-WEEK3"); var crudAPI = UnicontaAPIManager.GetCrudAPI(company); // Tracks var tracks = new TableHeader { // Key _HasPrimaryKey = true, _PKprompt = "TrackId", _AutoKey = true, // Description _Name = "Tracks", _Prompt = "Tracks", _MenuPosition = 3, _UserDefinedId = 2051, // Settings _EditLines = true }; // Inserting Table var errorCode = await crudAPI.Insert(tracks); if (errorCode != ErrorCodes.Succes) { MessageBox.Show($"Failed to insert Tracks {errorCode.ToString()}"); return; } else { MessageBox.Show("Tracks table has been created"); } // Creating Fields var tracksFields = new List <TableField>(); // Title var trackTitle = new TableField { _Name = "Title", _Prompt = "Title", _FieldType = CustomTypeCode.String }; trackTitle.SetMaster(tracks); tracksFields.Add(trackTitle); // Artist var trackArtist = new TableField { _Name = "Artist", _Prompt = "Artist", _FieldType = CustomTypeCode.String }; trackArtist.SetMaster(tracks); tracksFields.Add(trackArtist); // Genre var trackGenre = new TableField { _Name = "Genre", _Prompt = "Genre", _FieldType = CustomTypeCode.String, _RefTable = "TrackGenres" }; trackGenre.SetMaster(tracks); tracksFields.Add(trackGenre); // Vibe var trackVibe = new TableField { _Name = "Vibe", _Prompt = "Vibe", _FieldType = CustomTypeCode.Enum, _Format = "Dance;Up-beat;Soft;Slow;" }; trackVibe.SetMaster(tracks); tracksFields.Add(trackVibe); // Length var trackLength = new TableField { _Name = "Length", _Prompt = "Length", _FieldType = CustomTypeCode.Integer, }; trackLength.SetMaster(tracks); tracksFields.Add(trackLength); // LicensePaid var trackLicensePaid = new TableField { _Name = "LicensePaid", _Prompt = "License Paid", _FieldType = CustomTypeCode.Boolean, }; trackLicensePaid.SetMaster(tracks); tracksFields.Add(trackLicensePaid); // Inserting Fields var fieldsErrorCode = await crudAPI.Insert(tracksFields); if (fieldsErrorCode != ErrorCodes.Succes) { MessageBox.Show($"Failed to insert Tracks {errorCode.ToString()}"); return; } else { MessageBox.Show("Tracks table has been created"); } }