Example #1
0
        public Group_HeaderEvent Get_HeaderEvents(string UserId)
        {
            SqlConnection connection = null;

            SqlParameter[]      aParms = new SqlParameter[] { new SqlParameter(PARAM_Event_Creator_Id, UserId) };
            List <HeaderEvents> olist  = new List <HeaderEvents>();
            List <HeaderEvents> olist2 = new List <HeaderEvents>();
            Group_HeaderEvent   oevent = new Group_HeaderEvent();

            try
            {
                try
                {
                    connection = General.GetConnection();
                }
                catch (System.Exception e)
                {
                    Console.Write(e);
                    return(null);
                }
                SqlDataReader reader = SqlHelper.ExecuteReader(connection, CommandType.Text, SQL_SELECT_HEADER_EVENTS, aParms);

                while (reader.Read())
                {
                    olist.Add(new HeaderEvents(
                                  reader.GetString(0),
                                  reader.GetString(1),
                                  reader.GetString(2)));
                }
                if (reader.NextResult())
                {
                    while (reader.Read())
                    {
                        olist2.Add(new HeaderEvents(
                                       reader.GetString(0),
                                       reader.GetString(1),
                                       reader.GetString(2)));
                    }
                }
                reader.Close();
                oevent.MyEvent      = olist.ToArray();
                oevent.EventInvites = olist2.ToArray();
                return(oevent);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Trace.WriteLine(ex.Message);
                return(null);
            }
            finally
            {
                if (connection != null)
                {
                    connection.Dispose();
                }
            }
        }
Example #2
0
        public Group_HeaderEvent GetHeaderEvents(string UserId)
        {
            try
            {
                StreamReader   readStream;
                HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(@"http://" + GeneralBLL.Service_Link + "/Services/EventService.svc/GETHeaderEvent/" + UserId);
                httpWebRequest.Method      = "GET";
                httpWebRequest.ContentType = @"application/json; charset=utf-8";

                HttpWebResponse httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
                readStream = new StreamReader(httpResponse.GetResponseStream());

                var serializer = new DataContractJsonSerializer(typeof(Group_HeaderEvent));

                Group_HeaderEvent obj = serializer.ReadObject(readStream.BaseStream) as Group_HeaderEvent;

                return(obj);
            }
            catch (Exception ex)
            {
                return(null);
            }
        }