public MainWindow()
 {
     try
     {
         db = new ProjectDatabase();
         InitializeComponent();
         ReloadEmployeeList();
     }
     catch (SqlException ex)
     {
         MessageBox.Show("Database error: " + ex.Message);
     }
 }
Example #2
0
        private void btnSavePayment_Click(object sender, RoutedEventArgs e)
        {
            //collect info from the text boxes:

            int id = Convert.ToInt32(tbEmployeeID.Text);

            double hourlyRate;

            if (!double.TryParse(tbHourlyRatePay.Text, out hourlyRate))
            {
                MessageBox.Show("Please, enter the hourly rate");
                return;
            }
            double hours;

            if (!double.TryParse(tbNoOfHoursPay.Text, out hours))
            {
                MessageBox.Show("Please, enter the amount of hours worked");
                return;
            }

            hourlyRate = Convert.ToDouble(tbHourlyRatePay.Text);
            hours      = Convert.ToDouble(tbNoOfHoursPay.Text);

            double net = Convert.ToDouble(tbTotalNetPay.Text);


            Payment payment = new Payment();

            payment.Id         = id;
            payment.HourlyRate = hourlyRate;
            payment.NetPay     = net;
            payment.Hours      = hours;

            try
            {
                db = new ProjectDatabase();
                db.AddPayment(payment);
                MessageBox.Show("The Payment record was successfully saved.");
                this.Close();
            }
            catch (SqlException ex)
            {
                //MessageBox.Show("Check the Database Connection Please.");
                MessageBox.Show(ex.ToString());
            }
        }