Exemple #1
0
        private void LoadDefaultsFromDatabase()
        {
            string        sql   = "select * from Defaults";
            DefaultsModel model = SqliteDataAccess.LoadData <DefaultsModel>(sql, new Dictionary <string, object>()).FirstOrDefault();

            if (model != null)
            {
                hourlyRateTextbox.Text          = model.HourlyRate.ToString();
                preBillCheckbox.IsChecked       = (model.HourlyRate > 0);
                hasCutOffCheckbox.IsChecked     = (model.HasCutOff > 0);
                cutoffTextbox.Text              = model.CutOff.ToString();
                minimumHoursTextbox.Text        = model.MinimumHours.ToString();
                billingIncrementTextbox.Text    = model.BillingIncrement.ToString();
                roundUpAfterXMinuteTextbox.Text = model.RoundUpAfterXMinutes.ToString();
            }
            else
            {
                hourlyRateTextbox.Text          = "0";
                preBillCheckbox.IsChecked       = true;
                hasCutOffCheckbox.IsChecked     = false;
                cutoffTextbox.Text              = "0";
                minimumHoursTextbox.Text        = "0.25";
                billingIncrementTextbox.Text    = "0.25";
                roundUpAfterXMinuteTextbox.Text = "0";
            }
        }
Exemple #2
0
        public void InsertDefaultsData(DefaultsModel parameters)
        {
            var sqlString = "insert into Defaults (HourlyRate, PreBill, HasCutOff, CutOff, MinimumHours, BillingIncrement, RoundUpAfterXMinutes) " +
                            "values (@HourlyRate, @PreBill, @HasCutOff, @CutOff, @MinimumHours, @BillingIncrement, @RoundUpAfterXMinutes)";

            var sql = new SqlDataAccess();

            sql.SaveData(sqlString, parameters, _connectionString);
        }
Exemple #3
0
        public static void SaveDefaults(int stackSize, int graphMin, int graphMax)
        {
            DefaultsModel defaults = new DefaultsModel(stackSize, graphMin, graphMax);

            using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
            {
                cnn.Execute("insert or replace into Defaults (Id, StackSize, GraphMin, GraphMax) values (@Id, @StackSize, @GraphMin, @GraphMax)", defaults);
            }
        }
Exemple #4
0
        public async Task <IActionResult> SaveDefaults([FromBody] DefaultsModel model)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            await WorkerServices.SaveSettingsDefaults(model);

            return(Ok());
        }
Exemple #5
0
        public AdminSettings()
        {
            InitializeComponent();

            txtCompany.Text = SqliteDataAccess.LoadCompanyName();

            defaults = SqliteDataAccess.LoadDefaults();

            numGraphMin.Value  = defaults.GraphMin;
            numGraphMax.Value  = defaults.GraphMax;
            numStackSize.Value = defaults.StackSize;
        }
Exemple #6
0
        public async Task SaveSettingsDefaults(DefaultsModel model)
        {
            var subscriptionId = Guid.Empty;

            await Commands.SaveSettingsDefaults(
                subscriptionId,
                model.MinimumTaxpayerRegime,
                model.ElectronicInvoiceEnabled,
                model.SplitPayment,
                model.VatRate?.Id,
                model.ProvidenceFund?.Id,
                model.WithholdingTax?.Id);
        }
        private DefaultsModel PopulateDefaultsModel()
        {
            var output = new DefaultsModel
            {
                PreBill              = PreBill ? 1 : 0,
                HasCutOff            = HasCutOff ? 1 : 0,
                HourlyRate           = double.Parse(HourlyRate),
                CutOff               = int.Parse(CutOff),
                MinimumHours         = double.Parse(MinimumHours),
                BillingIncrement     = double.Parse(BillingIncrement),
                RoundUpAfterXMinutes = int.Parse(RoundUpAfterXMinutes)
            };

            return(output);
        }
Exemple #8
0
        public void DisplayData()
        {
            devices  = SqliteDataAccess.LoadDevices();
            probes   = SqliteDataAccess.LoadProbes();
            defaults = SqliteDataAccess.LoadDefaults();

            lblCompany.Text = SqliteDataAccess.LoadCompanyName();

            ArrangeTempDisplays();

            // Device Settings
            for (int i = 0; i < devices.Count; i++)
            {
                tabTemperature.TabPages[i].Text = devices[i].Name;
                lblGraphs[i].Text          = devices[i].Name;
                btnShowGraphics[i].Enabled = devices[i].Active; // If device is active, enable graphic button; else disable it.
            }

            // Probe Settings
            for (int i = 0; i < probes.Count; i++)
            {
                groupBoxes[i].Text  = probes[i].Name;
                numMins[i].Value    = probes[i].Min;
                numMaxs[i].Value    = probes[i].Max;
                numMarkers[i].Value = probes[i].Marker;

                //tempDisplays[i].Font = font;

                if (probes[i].Active)
                {
                    if (measurementStacks[i] == null)
                    {
                        measurementStacks[i] = new Stack <MeasurementModel>(30);
                    }
                    groupBoxes[i].Enabled = true;
                }
                else
                {
                    groupBoxes[i].Enabled = false;
                }
            }

            // Graph Defaults
            numMinGraph.Value = defaults.GraphMin;
            numMaxGraph.Value = defaults.GraphMax;
            stackSize         = defaults.StackSize;
            timer2.Interval   = stackSize * 1000;
        }
Exemple #9
0
        public DefaultsModel GetSettingsDefaults()
        {
            var subscriptionId = Guid.Empty;
            var model          = new DefaultsModel();

            var defaults = Database.SettingsDefaults
                           .BySubscriptionId(subscriptionId)
                           .Include(s => s.Vat)
                           .Include(s => s.WithholdingTax)
                           .Include(s => s.ProvidenceFund)
                           .SingleOrDefault();

            if (defaults != null)
            {
                var vat            = defaults.Vat;
                var providenceFund = defaults.ProvidenceFund;
                var withholdingTax = defaults.WithholdingTax;

                model.ElectronicInvoiceEnabled = defaults.ElectronicInvoiceEnabled;
                model.MinimumTaxpayerRegime    = defaults.MinimumTaxPayerRegime;
                model.SplitPayment             = defaults.SplitPaymentApplied;
                model.VatRate = vat == null ? null : new DefaultsModel.VatRateDescriptor
                {
                    Id   = vat.Id,
                    Rate = vat.Rate
                };

                model.ProvidenceFund = providenceFund == null ? null : new DefaultsModel.ProvidenceFundDescriptor
                {
                    Id                      = providenceFund.Id,
                    Description             = providenceFund.Description,
                    Rate                    = providenceFund.Rate,
                    AppliedInWithholdingTax = providenceFund.AppliedInWithholdingTax
                };

                model.WithholdingTax = withholdingTax == null ? null : new DefaultsModel.WithholdingTaxDescriptor
                {
                    Id                = withholdingTax.Id,
                    Description       = withholdingTax.Description,
                    Rate              = withholdingTax.Rate,
                    TaxableAmountRate = withholdingTax.TaxableAmountRate
                };
            }

            return(model);
        }
Exemple #10
0
        private void SaveToDatabase(DefaultsModel model)
        {
            string sql = "delete from Defaults";

            SqliteDataAccess.SaveData(sql, new Dictionary <string, object>());

            sql = "insert into Defaults (HourlyRate, PreBill, HasCutOff, CutOff, MinimumHours, BillingIncrement, RoundUpAfterXMinutes) " +
                  "values (@HourlyRate, @PreBill, @HasCutOff, @CutOff, @MinimumHours, @BillingIncrement, @RoundUpAfterXMinutes)";

            Dictionary <string, object> parameters = new Dictionary <string, object>
            {
                { "@HourlyRate", model.HourlyRate },
                { "@PreBill", model.PreBill },
                { "@HasCutOff", model.HasCutOff },
                { "@CutOff", model.CutOff },
                { "@MinimumHours", model.MinimumHours },
                { "@BillingIncrement", model.BillingIncrement },
                { "@RoundUpAfterXMinutes", model.RoundUpAfterXMinutes },
            };

            SqliteDataAccess.SaveData(sql, parameters);
        }
Exemple #11
0
        private (bool isValid, DefaultsModel model) ValidateForm()
        {
            bool          isValid = true;
            DefaultsModel model   = new DefaultsModel();

            try
            {
                model.PreBill              = (bool)preBillCheckbox.IsChecked ? 1 : 0;
                model.HasCutOff            = (bool)hasCutOffCheckbox.IsChecked ? 1: 0;
                model.HourlyRate           = double.Parse(hourlyRateTextbox.Text);
                model.CutOff               = int.Parse(cutoffTextbox.Text);
                model.MinimumHours         = double.Parse(minimumHoursTextbox.Text);
                model.BillingIncrement     = double.Parse(billingIncrementTextbox.Text);
                model.RoundUpAfterXMinutes = int.Parse(roundUpAfterXMinuteTextbox.Text);
            }
            catch
            {
                isValid = false;
            }

            return(isValid, model);
        }
 private void UpdateDatabase(DefaultsModel model)
 {
     _data.DeleteDefaultsData();
     _data.InsertDefaultsData(model);
 }