Beispiel #1
0
        public ArrayList searchCruises(CruiseEN cr)
        {
            ArrayList     a = new ArrayList();
            string        s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ToString();
            SqlConnection c = new SqlConnection(s);

            try
            {
                c.Open();
                SqlCommand    com = new SqlCommand("Select * from Cruise where Id = " + cr.Id, c);
                SqlDataReader dr  = com.ExecuteReader();
                while (dr.Read())
                {
                    a.Add(dr["Id"].ToString());
                }
                dr.Close();
            }
            catch (Exception ex)
            {
                ex.ToString();
                Console.WriteLine("ERROR: Search Cruise");
            }
            finally
            {
                c.Close();
            }
            return(a);
        }
Beispiel #2
0
        //Removes a cruise from the DB
        public DataSet deleteCruise(CruiseEN b, int i) // It will delete the index passed in the view
        {
            string s;

            s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); //String where it's stored the instructions for the connecton for the DB
            SqlConnection c      = new SqlConnection(s);                                //The connection is effectuated
            DataSet       virtdb = new DataSet();                                       //Created the DataSet that is going to be returned with the information asked

            try
            {                                                           //The select in SQL language that is processed in the DB which will return all the rows from the table "Cruise"
                SqlDataAdapter da = new SqlDataAdapter("Select * from Cruise", c);
                da.Fill(virtdb, "cruise");                              //It introduces the information returned from the select into this virtual DB
                DataTable t = new DataTable();                          //Creates a table
                t = virtdb.Tables["cruise"];                            //Fills it with the select

                t.Rows[i].Delete();                                     //Removes the cruise from the table

                SqlCommandBuilder cbuilder = new SqlCommandBuilder(da); //Elaborates the SQL command needed to make the changes
                da.Update(virtdb, "cruise");                            //Updates the DB with the new information added
            }
            catch (Exception ex)
            {
                ex.ToString();      //In case of an error it is printed here
                Console.WriteLine("ERROR: Delete cruise");
            }
            finally
            {
                c.Close();      //Closes the connection to the DB
            }
            return(virtdb);     //It returns the virtual DB with all the information asked inside
        }
Beispiel #3
0
        public void delete_Cruise(CruiseEN cr)
        {
            string        s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ToString();
            SqlConnection c = new SqlConnection(s);

            try
            {
                c.Open();
                SqlCommand com = new SqlCommand("Delete from Cruise where ID = " + cr.Id, c);

                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                ex.ToString();
                Console.WriteLine("ERROR: Delete Cruise");
            }
            finally
            {
                c.Close();
            }
        }
Beispiel #4
0
        //Adds a new Cruise to the DB
        public DataSet addCruise(CruiseEN b)
        {
            string s;

            s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); //String where it's stored the instructions for the connecton for the DB
            SqlConnection c      = new SqlConnection(s);                                //The connection is effectuated
            DataSet       virtdb = new DataSet();                                       //Created the DataSet that is going to be returned with the information asked

            try
            {                                   //The select in SQL language that is processed in the DB which will return all the rows from the table "Cruise"
                SqlDataAdapter da = new SqlDataAdapter("Select * from Cruise", c);
                da.Fill(virtdb, "cruise");      //It introduces the information returned from the select into this virtual DB
                DataTable dt = new DataTable(); //Creates a table
                dt = virtdb.Tables["cruise"];   //Fills it with the select information
                DataRow newRow = dt.NewRow();   //Crreates a new row
                newRow[0] = b.id;
                newRow[1] = b.DepartureTime;
                newRow[2] = b.ArrivalTime;      //Fills the row with the information of the new cruise
                newRow[3] = b.city;
                newRow[4] = b.route;
                newRow[5] = b.Price;
                newRow[6] = b.Company;
                newRow[7] = b.Extras;
                dt.Rows.Add(newRow);                                    //Inserts the row to the table
                SqlCommandBuilder cbuilder = new SqlCommandBuilder(da); //Elaborates the SQL command needed to make the changes
                da.Update(virtdb, "cruise");                            //Updates the DB with the new information added
            }
            catch (Exception ex)
            {
                ex.ToString();      //In case of an error it is printed here
                Console.WriteLine("ERROR: Add cruise");
            }
            finally
            {
                c.Close();      //Closes the connection to the DB
            }

            return(virtdb);      //It returns the virtual DB with all the information asked inside
        }
Beispiel #5
0
        public void add_Cruise(CruiseEN cr)
        {
            string        s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ToString();
            SqlConnection c = new SqlConnection(s);

            try
            {
                c.Open();
                SqlCommand com = new SqlCommand("Insert Into Cruise (ID,departureTime,arrivaleTime,City,Route) VALUES ('" + cr.Id + "','" + cr.departureDate + "','" + cr.arrivalDate + "','" +
                                                cr.City + "','" + cr.Route + "')", c);

                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                ex.ToString();
                Console.WriteLine("ERROR: Add Cruise");
            }
            finally
            {
                c.Close();
            }
        }
Beispiel #6
0
        public void update_Cruise(CruiseEN cr)
        {
            string        s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ToString();
            SqlConnection c = new SqlConnection(s);

            try
            {
                c.Open();
                SqlCommand com = new SqlCommand("Update Cruise where ID = '" + cr.Id + "', departureTime = '"
                                                + cr.departureDate + "', arrivalTime = '" + cr.arrivalDate + "' , City ='" + cr.City +
                                                "', Route = '" + cr.Route + "')", c);

                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                ex.ToString();
                Console.WriteLine("ERROR: Update Cruise");
            }
            finally
            {
                c.Close();
            }
        }
Beispiel #7
0
        //Shows all the information about all the cruises of the DB
        public DataSet showCruises(CruiseEN b)
        {
            string s;

            s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); //String where it's stored the instructions for the connecton for the DB
            SqlConnection c      = new SqlConnection(s);                                //The connection is effectuated
            DataSet       virtdb = new DataSet();                                       //Created the DataSet that is going to be returned with the information asked

            try
            {
                SqlDataAdapter da = new SqlDataAdapter("select * from Cruise", c); //The select in SQL language that is processed in the DB which will return all the rows from the table "Cruise"
                da.Fill(virtdb, "cruise");                                         //It introduces the information returned from the select into this virtual DB
            }
            catch (Exception ex)
            {
                ex.ToString();      //In case of an error it is printed here
                Console.WriteLine("ERROR: show cruise");
            }
            finally
            {
                c.Close();      //Closes the connection to the DB
            }
            return(virtdb);     //It returns the virtual DB with all the information asked inside
        }