Example #1
0
        private void BtN_Opdate_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(Box_CPR.Text))
            {
                MessageBox.Show("Du skal vælge Dato og Cpr for at opdatere betalt");
            }
            else
            {
                cpr = int.Parse(Box_CPR.Text);
                int    betal = BtN_Betalt.Checked ? 1 : 0;
                var    dato  = Convert.ToString(Box_Dato.Text);
                DbConn db1   = new DbConn();

                try
                {
                    db1.DBObO();

                    db1.DbSql("UPDATE Behandling SET Betalt = 1 WHERE CPR = " + cpr + " AND Dato = '" + dato + "';");
                    MessageBox.Show("Betaling opdateret");
                }
                catch
                {
                    MessageBox.Show("Ingen forbindelse til datanbasen !");
                }
                db1.DbObC();
            }
        }
Example #2
0
        private void BtN_Book_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(Box_CPR.Text))
            {
                MessageBox.Show("Der skal udfyldes oplysninger");
            }
            else
            {
                cpr = int.Parse(Box_CPR.Text);
                DataRowView drv = (DataRowView)Box_Tandlaege.SelectedItem;
                tandlaege = Convert.ToInt16(drv["Tandlaege_ID"]);
                var dato = Convert.ToString(Box_Dato.Text);

                DbConn db1 = new DbConn();

                try
                {
                    db1.DBObO();
                    db1.DbSql("INSERT INTO Booking(CPR, Tandlaege_ID,  Dato) VALUES (" + cpr + ", " + tandlaege + ",'" + dato + "')");
                    MessageBox.Show("Booking oprettet");
                }
                catch
                {
                    MessageBox.Show("Ingen forbindelse til databasen !");
                }
                db1.DbObC();
            }
        }
Example #3
0
        private void BtN_Beh_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(Box_Behandling.Text))
            {
                MessageBox.Show("Du skal udfylde oplysningerne");
            }
            else
            {
                string beBehand = Box_Behandling.Text;
                cpr = int.Parse(Box_CPR.Text);
                var dato   = Convert.ToString(Box_Dato.Text);
                int beloeb = int.Parse(Box_Beloeb.Text);
                int betal  = BtN_Betalt.Checked ? 1 : 0;

                DbConn db1 = new DbConn();

                int kID = Box_Klinik.SelectedIndex;
                int lID = Box_Tandlaege.SelectedIndex;

                try
                {
                    db1.DBObO();
                    string dSqlInd = "INSERT INTO Behandling(Behandling, CPR, Tabdlaege_ID, Klinik_ID, Dato, Regnings_Beloeb, Betalt) VALUES ('" + beBehand + "', " + cpr + ", " + lID + ", " + kID + ", '" + dato + "', " + beloeb + ", " + betal + ")";
                    db1.DbSqlInd(dSqlInd);
                    MessageBox.Show("behandling oprettet");

                    db1.DbObC();
                }
                catch
                {
                    MessageBox.Show("Fejl i datanbase forbindelse");
                }
            }
        }
Example #4
0
        public Form1()
        {
            InitializeComponent();

            Box_Dato.Format       = DateTimePickerFormat.Custom;
            Box_Dato.CustomFormat = "dd-MM-yyyy HH:mm";

            #region
            DbConn db1 = new DbConn();
            db1.DBObO();

            Box_Klinik.ValueMember   = "Klinik_ID";
            Box_Klinik.DisplayMember = "Klinik";
            Box_Klinik.DataSource    = db1.DbSdIgView("SELECT Klinik FROM Klinik ");

            db1.DbObC();
            #endregion
            #region

            db1 = new DbConn();
            db1.DBObO();

            Box_Tandlaege.ValueMember   = "Tandlaege_ID";
            Box_Tandlaege.DisplayMember = "Navn";
            Box_Tandlaege.DataSource    = db1.DbSdIgView("SELECT Tandlaege_ID, Navn FROM Tandlaege ");

            db1.DbObC();
            #endregion

            #region
            db1.DBObO();
            SqlDataReader DbRd;
            DbRd = db1.DbReader("SELECT Postnr, Bynavn FROM Bynavn ");

            while (DbRd.Read())
            {
                string Post_By = Convert.ToString(DbRd["Postnr"]) + " " + Convert.ToString(DbRd["Bynavn"]);
                Box_Postnr.Items.Add(Post_By);
            }
            Box_Postnr.SelectedIndex = 484;
            db1.DbObC();
            #endregion
        }
Example #5
0
        private void BtN_Ind_Click(object sender, EventArgs e)
        {
            string fNavn, mNavn, eNavn, adr, email;
            int    tlf, post;

            if (string.IsNullOrWhiteSpace(Box_CPR.Text))
            {
                MessageBox.Show("Patient oplysninger skal udfyldes");
            }
            else
            {
                cpr = int.Parse(Box_CPR.Text);
                tlf = string.IsNullOrWhiteSpace(Box_Tlf.Text) ? 0 : int.Parse(Box_Tlf.Text);

                fNavn = Convert.ToString(Box_Fornavn.Text);
                eNavn = Convert.ToString(Box_Efternavn.Text);
                mNavn = Box_Mellemnavn.Text != null?Convert.ToString(Box_Mellemnavn.Text) : null;

                adr   = Convert.ToString(Box_Adresse.Text);
                email = Box_Email.Text != null?Convert.ToString(Box_Email.Text) : null;

                string poste = Convert.ToString(Box_Postnr.SelectedItem);
                post = int.Parse(poste.Substring(0, 4));

                DbConn db1 = new DbConn();

                try
                {
                    db1.DBObO();

                    db1.DbSql("INSERT INTO Patient(CPR, Fornavn, Mellemnavn, Efternavn, Adresse, Postnr, Tlfnr, Email) VALUES (" + cpr + ",'" + fNavn + "','" + mNavn + "','" + eNavn + "','" + adr + "'," + post + "," + tlf + ",'" + email + "')");
                    MessageBox.Show("Patient oprettet");
                }
                catch
                {
                    MessageBox.Show("Ingen forbindelse til datanbasen !");
                }
                db1.DbObC();
            }
        }