Пример #1
0
        private void btn_aanmaken_Click(object sender, EventArgs e)
        {
            bool actief = false;
            bool goedgekeurd = false;
            Location location = new Location(Convert.ToInt32(nud_X.Value), Convert.ToInt32(nud_Y.Value));
            if (cb_typemissie.SelectedText == "SIN")
            {
                goedgekeurd = true;
                actief = true;
            }
            Missie newMissie = new Missie(tb_MissieNaam.Text, actief, tb_datumvertrek.Text, tb_datumvertrek.Text, goedgekeurd, location, cb_typemissie.SelectedText);

            if (administrator.AddMissie(newMissie))
            {
                MessageBox.Show("Missie aangemaakt");
            }
            else
            {
                MessageBox.Show("Er is iets Misgegaan");
            }
        }
Пример #2
0
        public static bool AddMissie(Missie m)
        {
            using (OracleConnection o = new OracleConnection(connstring))
            {
                using (OracleCommand c = new OracleCommand())
                {
                    try
                    {
                        c.Connection = o;
                        o.Open();

                        if (m as SIN_Missie != null)
                        {
                            c.CommandText = "INSERT INTO TMissie (Beschrijving, Locatie) VALUES ('" + m.Beschrijving + "', '" + m.Locatie + "')";
                            c.ExecuteNonQuery();

                            c.CommandText = "SELECT MAX(ID) FROM TMissie";
                            OracleDataReader dr = c.ExecuteReader();

                            if (dr.Read())
                            {
                                c.CommandText = "INSERT INTO TMissie_SIN (ID, Datum, AantalPolitie) VALUES ('" + GetInt(dr[0]) + "', to_date('" + (m as SIN_Missie).Datum + "','DD-MM-RR HH24:MI:SS'), '" + (m as SIN_Missie).AantalPolitie + "')";
                                c.ExecuteNonQuery();
                            }
                        }

                        if (m as HOPE_Missie != null)
                        {
                            c.CommandText = "INSERT INTO TMissie (Beschrijving, Locatie) VALUES ('" + m.Beschrijving + "', '" + m.Locatie + "')";
                            c.ExecuteNonQuery();

                            c.CommandText = "SELECT MAX(ID) FROM TMissie";
                            OracleDataReader dr = c.ExecuteReader();

                            if (dr.Read())
                            {
                                c.CommandText = "INSERT INTO TMissie_HOPE (ID, GoedkeuringUID, DatumVertrek, DatumTerug) VALUES ('" + GetInt(dr[0]) + "', '" + (m as HOPE_Missie).GoedkeuringUID + "', to_date('" + (m as HOPE_Missie).DatumVertrek + "','DD-MM-RR HH24:MI:SS'), to_date('" + (m as HOPE_Missie).DatumTerug + "','DD-MM-RR HH24:MI:SS'))";
                                c.ExecuteNonQuery();
                            }
                        }

                        return true;
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(e.Message);
                        return false;
                    }
                    finally
                    {
                        o.Close();
                    }
                }
            }
        }
Пример #3
0
        public static bool UpdateMissie(Missie m)
        {
            using (OracleConnection o = new OracleConnection(connstring))
            {
                using (OracleCommand c = new OracleCommand())
                {
                    try
                    {
                        c.Connection = o;
                        o.Open();

                        c.CommandText = "UPDATE TMissie SET Beschrijving = '" + m.Beschrijving + "', Locatie = '" + m.Locatie + "' WHERE ID = '" + m.UID + "'";
                        c.ExecuteNonQuery();

                        if (m as SIN_Missie != null)
                        {
                            c.CommandText = "UPDATE TMissie_SIN SET Datum = to_date('" + (m as SIN_Missie).Datum + "','DD-MM-RR HH24:MI:SS'), AantalPolitie = '" + (m as SIN_Missie).AantalPolitie + "' WHERE ID = '" + m.UID + "'";
                            c.ExecuteNonQuery();
                        }

                        if (m as HOPE_Missie != null)
                        {
                            c.CommandText = "UPDATE TMissie_HOPE SET GoedkeuringUID = '" + (m as HOPE_Missie).GoedkeuringUID + "', DatumVertrek = to_date('" + (m as HOPE_Missie).DatumVertrek + "','DD-MM-RR HH24:MI:SS'), DatumTerug = to_date('" + (m as HOPE_Missie).DatumTerug + "','DD-MM-RR HH24:MI:SS') WHERE ID = '" + m.UID + "'";
                            c.ExecuteNonQuery();
                        }

                        return true;
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(e.Message);
                        return false;
                    }
                    finally
                    {
                        o.Close();
                    }
                }
            }
        }
Пример #4
0
        public static bool DeleteMissie(Missie m)
        {
            using (OracleConnection o = new OracleConnection(connstring))
            {
                using (OracleCommand c = new OracleCommand())
                {
                    try
                    {
                        c.Connection = o;
                        o.Open();

                        if (m as SIN_Missie != null)
                        {
                            c.CommandText = "DELETE FROM TMissie_SIN WHERE ID = '" + m.UID + "'";
                            c.ExecuteNonQuery();
                        }

                        if (m as HOPE_Missie != null)
                        {
                            c.CommandText = "DELETE FROM TMissie_HOPE WHERE ID = '" + m.UID + "'";
                            c.ExecuteNonQuery();
                        }

                        c.CommandText = "DELETE FROM TMissie WHERE ID = '" + m.UID + "'";
                        c.ExecuteNonQuery();

                        return true;
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(e.Message);
                        return false;
                    }
                    finally
                    {
                        o.Close();
                    }
                }
            }
        }
Пример #5
0
 public bool DeleteMissie(Missie m)
 {
     return DBConnect.DeleteMissie(m);
 }
Пример #6
0
 public bool AddMissie(Missie m)
 {
     return DBConnect.AddMissie(m);
 }
Пример #7
0
 public bool UpdateMissie(Missie m)
 {
     return DBConnect.UpdateMissie(m);
 }