예제 #1
0
        public EventsModel EventInsert(dynamic jobj)
        {
            EventsModel events = new EventsModel();

            events.name     = jobj.name;
            events.location = jobj.location;
            events.date     = jobj.date;

            SqlConnection conn   = null;
            SqlDataReader reader = null;

            try
            {
                conn = new
                       SqlConnection("Data Source=rsc-harambe.database.windows.net;Initial Catalog=rsc-harambe;Integrated Security=False;User ID=harambe;Password=Ismynigga123!;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
                conn.Open();

                // 1. declare command object with parameter
                SqlCommand cmd = new SqlCommand(
                    "insert into Eventovi(EventName, LocationName, EventTime) values (@name, @location, @time);SELECT CAST(scope_identity() AS int)", conn);

                // 2. define parameters used in command object
                SqlParameter[] param = new SqlParameter[3];
                param[0] = new SqlParameter();
                param[1] = new SqlParameter();
                param[2] = new SqlParameter();

                param[0].ParameterName = "@name";
                param[0].Value         = events.name;
                param[1].ParameterName = "@location";
                param[1].Value         = events.location;
                param[2].ParameterName = "@time";
                param[2].Value         = events.date;

                // 3. add new parameter to command object
                cmd.Parameters.AddRange(param);

                // get data stream
                //cmd.ExecuteNonQuery();
                events.id = (int)cmd.ExecuteScalar();
            }
            finally
            {
                // close reader
                if (reader != null)
                {
                    reader.Close();
                }

                // close connection
                if (conn != null)
                {
                    conn.Close();
                }
            }

            return(events);
        }
예제 #2
0
        public List <EventsModel> EventSelectByID(int eid)
        {
            SqlConnection conn   = null;
            SqlDataReader reader = null;

            List <EventsModel> eventovi = new List <EventsModel>();

            try
            {
                conn = new
                       SqlConnection("Data Source=rsc-harambe.database.windows.net;Initial Catalog=rsc-harambe;Integrated Security=False;User ID=harambe;Password=Ismynigga123!;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
                conn.Open();

                SqlCommand cmd = new SqlCommand(
                    "select * from Eventovi where EventID=@eid", conn);

                cmd.Parameters.AddWithValue("@eid", eid.ToString());

                reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    EventsModel temp = new EventsModel();
                    temp.id       = Int32.Parse(reader["EventID"].ToString());
                    temp.name     = reader["EventName"].ToString();
                    temp.location = reader["LocationName"].ToString();
                    temp.date     = (DateTime)reader["EventTime"];

                    eventovi.Add(temp);
                }
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }

                if (conn != null)
                {
                    conn.Close();
                }
            }

            return(eventovi);
        }