コード例 #1
0
        public int InsertVideo(Video_Post video_Post, Group group, Member member)
        {
            using (SqlConnection dbcon = new SqlConnection(ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("uspInsertVideo", dbcon);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add(new SqlParameter("@GroupID", group.GroupId));
                cmd.Parameters.Add(new SqlParameter("@MemberID", member.MemberId));
                cmd.Parameters.Add(new SqlParameter("@Video", video_Post.Video));
                cmd.Parameters.Add(new SqlParameter("@VideoName", video_Post.VideoName));
                cmd.Parameters.Add(new SqlParameter("@VideoCaption", video_Post.VideoCaption));
                cmd.Parameters.Add(new SqlParameter("@VideoSize", video_Post.VideoSize));

                SqlParameter returnValue = new SqlParameter("@Return_Value", DbType.Int32);
                returnValue.Direction = ParameterDirection.ReturnValue;

                cmd.Parameters.Add(returnValue);
                int postId = 0;
                try
                {
                    dbcon.Open();
                    cmd.ExecuteNonQuery();
                    postId = Int32.Parse(cmd.Parameters["@Return_Value"].Value.ToString());
                }
                catch (SqlException e)
                {
                    MessageBox.Show(e.ToString());
                }
                return(postId);
            }
        }
コード例 #2
0
ファイル: Group.aspx.cs プロジェクト: Ndiya999/Bulabula
        protected void SaveVideo(AjaxFileUploadEventArgs file)
        {
            byte[] videoBytes = file.GetContents();
            string fileName   = file.FileName.Split('\\').Last();

            Video_Post videoPost = new Video_Post();
            Group      g         = new Group();
            PostDAL    postDAl   = new PostDAL();

            aMember.MemberId = (string)Session["memberID"];
            g.GroupId        = int.Parse(ThisGroupsID.Value);

            videoPost.Video        = videoBytes;
            videoPost.VideoName    = fileName;
            videoPost.VideoSize    = file.FileSize;
            videoPost.VideoCaption = captionP;

            postDAl.InsertVideo(videoPost, g, aMember);
        }
コード例 #3
0
ファイル: NewsfeedDAL.cs プロジェクト: Ndiya999/Bulabula
        public ArrayList GetPost(Post post)
        {
            ArrayList custArray;
            using (SqlConnection dbConnection = new SqlConnection(ConnectionString))
            {
                SqlCommand dbCommand = new SqlCommand("uspGetPost", dbConnection);
                dbCommand.CommandType = CommandType.StoredProcedure;
                dbCommand.Parameters.Add(new SqlParameter("@PostID", post.PostId));
                dbCommand.Parameters.Add(new SqlParameter("@PostType", post.PostType));

                dbConnection.Open();
                SqlDataReader dbReader = dbCommand.ExecuteReader();
                custArray = new ArrayList();

                if (post.PostType == "Event")
                {
                    while (dbReader.Read())
                    {
                        Event_Post aCountry = new Event_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["EventName"].ToString(), dbReader["EventDetails"].ToString(), dbReader["EventVenue"].ToString(), DateTime.Parse(dbReader["StartDate"].ToString()), DateTime.Parse(dbReader["EndDate"].ToString()), dbReader["Host"].ToString(), dbReader["EventType"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Text")
                {
                    while (dbReader.Read())
                    {
                        Text_Post aCountry = new Text_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["PostText"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Photo")
                {
                    while (dbReader.Read())
                    {

                        Photo_Post aCountry = new Photo_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["PhotoCaption"].ToString(), dbReader["PhotoName"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                //else if (post.PostType == "Article")
                //{
                //    while (dbReader.Read())
                //    {
                //        Article_Post aCountry = new Article_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["Title"].ToString(), dbReader["ArticleText"].ToString());
                //        custArray.Add(aCountry);
                //    }
                //}
                else if (post.PostType == "Video")
                {
                    while (dbReader.Read())
                    {
                        Video_Post aCountry = new Video_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["VideoCaption"].ToString(), long.Parse(dbReader["VideoSize"].ToString()), dbReader["VideoName"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "File")
                {
                    while (dbReader.Read())
                    {
                        File_Post aCountry = new File_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["FileCaption"].ToString(), long.Parse(dbReader["FileSize"].ToString()), dbReader["FileName"].ToString());
                        custArray.Add(aCountry);
                    }
                }

                dbConnection.Close();
            }
            return custArray;
        }
コード例 #4
0
        public ArrayList GetPost(Post post)
        {
            ArrayList custArray;

            using (SqlConnection dbConnection = new SqlConnection(ConnectionString))
            {
                SqlCommand dbCommand = new SqlCommand("uspGetPost", dbConnection);
                dbCommand.CommandType = CommandType.StoredProcedure;
                dbCommand.Parameters.Add(new SqlParameter("@PostID", post.PostId));
                dbCommand.Parameters.Add(new SqlParameter("@PostType", post.PostType));

                dbConnection.Open();
                SqlDataReader dbReader = dbCommand.ExecuteReader();
                custArray = new ArrayList();

                if (post.PostType == "Event")
                {
                    while (dbReader.Read())
                    {
                        Event_Post aCountry = new Event_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["EventName"].ToString(), dbReader["EventDetails"].ToString(), dbReader["EventVenue"].ToString(), DateTime.Parse(dbReader["StartDate"].ToString()), DateTime.Parse(dbReader["EndDate"].ToString()), dbReader["Host"].ToString(), dbReader["EventType"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Text")
                {
                    while (dbReader.Read())
                    {
                        Text_Post aCountry = new Text_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["PostText"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Photo")
                {
                    while (dbReader.Read())
                    {
                        Photo_Post aCountry = new Photo_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["PhotoCaption"].ToString(), dbReader["PhotoName"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                //else if (post.PostType == "Article")
                //{
                //    while (dbReader.Read())
                //    {
                //        Article_Post aCountry = new Article_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["Title"].ToString(), dbReader["ArticleText"].ToString());
                //        custArray.Add(aCountry);
                //    }
                //}
                else if (post.PostType == "Video")
                {
                    while (dbReader.Read())
                    {
                        Video_Post aCountry = new Video_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["VideoCaption"].ToString(), long.Parse(dbReader["VideoSize"].ToString()), dbReader["VideoName"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "File")
                {
                    while (dbReader.Read())
                    {
                        File_Post aCountry = new File_Post(int.Parse(dbReader["PostID"].ToString()), dbReader["FileCaption"].ToString(), long.Parse(dbReader["FileSize"].ToString()), dbReader["FileName"].ToString());
                        custArray.Add(aCountry);
                    }
                }

                dbConnection.Close();
            }
            return(custArray);
        }
コード例 #5
0
ファイル: PostDAL.cs プロジェクト: Ndiya999/Bulabula
        public int InsertVideo(Video_Post video_Post, Group group, Member member)
        {
            using (SqlConnection dbcon = new SqlConnection(ConnectionString))
            {

                SqlCommand cmd = new SqlCommand("uspInsertVideo", dbcon);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add(new SqlParameter("@GroupID", group.GroupId));
                cmd.Parameters.Add(new SqlParameter("@MemberID", member.MemberId));
                cmd.Parameters.Add(new SqlParameter("@Video", video_Post.Video));
                cmd.Parameters.Add(new SqlParameter("@VideoName", video_Post.VideoName));
                cmd.Parameters.Add(new SqlParameter("@VideoCaption", video_Post.VideoCaption));
                cmd.Parameters.Add(new SqlParameter("@VideoSize", video_Post.VideoSize));

                SqlParameter returnValue = new SqlParameter("@Return_Value", DbType.Int32);
                returnValue.Direction = ParameterDirection.ReturnValue;

                cmd.Parameters.Add(returnValue);
                int postId = 0;
                try
                {
                    dbcon.Open();
                    cmd.ExecuteNonQuery();
                    postId = Int32.Parse(cmd.Parameters["@Return_Value"].Value.ToString());
                }
                catch (SqlException e)
                {
                    MessageBox.Show(e.ToString());
                }
                return postId;

            }
        }
コード例 #6
0
ファイル: Group.aspx.cs プロジェクト: Ndiya999/Bulabula
        protected void Page_Load(object sender, EventArgs e)
        {
            Literal title = (Literal)Master.FindControl("pageTitle");

            caption = (HiddenField)Master.FindControl("caption");

            #region NEWSFEED
            MessagesDAL member = new MessagesDAL();
            if (!IsPostBack)
            {
                if (Session["memberID"] == null)
                {
                    Response.Redirect("~/Login.aspx");
                }
                else if (loginDAL.GetMemberStatus(member_Status = new Member_Status(Session["memberID"].ToString())))
                {
                    if (Request.Cookies["login"] != null)
                    {
                        var c = new HttpCookie("login");
                        c.Expires = DateTime.Now.AddDays(-1);
                        Response.Cookies.Add(c);
                        Session.Abandon();
                    }

                    Response.Redirect("~/Login.aspx");
                }
                else if (Session["GroupInfo"] != null)
                {
                    string m = Session["GroupInfo"].ToString();

                    string[] data = m.Split('&');

                    groupID            = int.Parse(data[0]);
                    ThisGroupsID.Value = "" + groupID;
                    title.Text         = data[1];

                    #region RIGHT COLUMN GET 5 JOINEDGROUPS
                    //JOINED GROUPS==============================================================================


                    string memberId = Context.Session["memberID"].ToString();
                    aMember.MemberId = memberId;

                    Reusable_Methods reusable_Methods = new Reusable_Methods(aMember);
                    allgroups = reusable_Methods.RightColumnGet5JoinedGroups();
                    //===========================================================================================
                    #endregion

                    #region NEWS FEED

                    string TabName = "Posts";

                    BulabulaApp.WebServices.postsWebservice posts = new WebServices.postsWebservice();

                    newsfeed = posts.GetTabContents(TabName, groupID, -1);
                    #endregion

                    #region RIGHT COLUMN FRIENDS ONLINE
                    //FRIENDS ONLINE==============================================================================

                    memberId         = Context.Session["memberID"].ToString();
                    aMember.MemberId = memberId;

                    reusable_Methods    = new Reusable_Methods(aMember);
                    FriendsOnlineString = reusable_Methods.RightColumnGetFriendsOnline();

                    //===========================================================================================
                    #endregion
                }
            }//END MAIN if loading for first time
            #endregion

            #region Picture Upload
            if (Request.QueryString["preview"] == "1" && !string.IsNullOrEmpty(Request.QueryString["fileId"]) && uploadType == "Picture")
            {
                var    fileId          = Request.QueryString["fileId"];
                var    fileContentType = (string)Session["fileContentType_" + fileId];
                var    fileName        = (string)Session["fileName_" + fileId];
                byte[] imageBytes      = File.ReadAllBytes(System.Web.HttpContext.Current.Server.MapPath("~") + "file.png");
                var    fileContents    = imageBytes;

                string ct = (string)Session["fileContentType_" + fileId];
                if (ct.Contains("jpg") || ct.Contains("gif") || ct.Contains("png") || ct.Contains("jpeg"))
                {
                    fileContents = (byte[])Session["fileContents_" + fileId];
                }



                MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length);
                // Convert byte[] to Image
                ms.Write(imageBytes, 0, imageBytes.Length);
                System.Drawing.Image image = System.Drawing.Image.FromStream(ms, true);

                Photo_Post photoPost = new Photo_Post();
                Group      g         = new Group();
                PostDAL    postDAl   = new PostDAL();

                aMember.MemberId = "5ZMjMHEwVN7GyJ2miPDjeQ==";
                g.GroupId        = 1;

                photoPost.Photo        = image;
                photoPost.PhotoName    = fileName;
                photoPost.PhotoCaption = "STeVO";

                postDAl.InsertPhoto(photoPost, g, aMember);
                Response.Clear();
                Response.ContentType = fileContentType;
                Response.BinaryWrite(fileContents);
                Response.End();
            }

            #endregion

            #region Video Upload

            if (Request.QueryString["preview"] == "1" && !string.IsNullOrEmpty(Request.QueryString["fileId"]) && uploadType == "Video")
            {
                var    videoFileId          = Request.QueryString["fileId"];
                var    videofileContentType = (string)Session["fileContentType_" + videoFileId];
                var    videofileName        = (string)Session["fileName_" + videoFileId];
                byte[] videoBytes           = File.ReadAllBytes(System.Web.HttpContext.Current.Server.MapPath("~") + "file.png");
                var    videofileContents    = videoBytes;

                string ct = (string)Session["fileContentType_" + videoFileId];
                if (ct.Contains("mp4") || ct.Contains("mov") || ct.Contains("vlc") || ct.Contains("avi") || ct.Contains("jpeg"))
                {
                    videofileContents = (byte[])Session["fileContents_" + videoFileId];
                }



                //  MemoryStream vs = new MemoryStream(videoBytes, 0, videoBytes.Length);
                // Convert byte[] to Image
                //vs.Write(videoBytes, 0, videoBytes.Length);
                //System.Drawing.Image image = System.Drawing.Image.FromStream(vs, true);

                Video_Post videoPost = new Video_Post();
                Group      g         = new Group();
                PostDAL    postDAl   = new PostDAL();

                aMember.MemberId = "5ZMjMHEwVN7GyJ2miPDjeQ==";
                g.GroupId        = 1;

                videoPost.Video        = videoBytes;
                videoPost.VideoName    = videofileName;
                videoPost.VideoCaption = "STeVO";
                //videoPost.VideoSize =


                //postDAl.InsertPhoto1(photoPost, g, aMember);
                postDAl.InsertVideo(videoPost, g, aMember);



                //Response.Clear();
                //Response.ContentType = fileContentType;
                //Response.BinaryWrite(fileContents);
                //Response.End();
            }


            #endregion
        }
コード例 #7
0
ファイル: NotificationDAL.cs プロジェクト: Ndiya999/Bulabula
        public ArrayList GetPostCaption(Post post)
        {
            ArrayList custArray;
            using (SqlConnection dbConnection = new SqlConnection(ConnectionString))
            {
                SqlCommand dbCommand = new SqlCommand("uspGetPostCaption", dbConnection);
                dbCommand.CommandType = CommandType.StoredProcedure;
                dbCommand.Parameters.Add(new SqlParameter("@PostID", post.PostId));
                dbCommand.Parameters.Add(new SqlParameter("@PostType", post.PostType));

                dbConnection.Open();
                SqlDataReader dbReader = dbCommand.ExecuteReader();
                custArray = new ArrayList();

                if (post.PostType == "Event")
                {
                    while (dbReader.Read())
                    {
                        Event_Post aCountry = new Event_Post(dbReader["EventName"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Text")
                {
                    while (dbReader.Read())
                    {
                        Text_Post aCountry = new Text_Post(dbReader["PostText"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Photo")
                {
                    while (dbReader.Read())
                    {
                        Photo_Post aCountry = new Photo_Post(dbReader["PhotoCaption"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Article")
                {
                    while (dbReader.Read())
                    {
                        Article_Post aCountry = new Article_Post(dbReader["Title"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Video")
                {
                    while (dbReader.Read())
                    {
                        Video_Post aCountry = new Video_Post(dbReader["VideoCaption"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "File")
                {
                    while (dbReader.Read())
                    {
                        File_Post aCountry = new File_Post(dbReader["FileCaption"].ToString());
                        custArray.Add(aCountry);
                    }
                }

                dbConnection.Close();
            }
            return custArray;
        }
コード例 #8
0
        public ArrayList GetPostCaption(Post post)
        {
            ArrayList custArray;

            using (SqlConnection dbConnection = new SqlConnection(ConnectionString))
            {
                SqlCommand dbCommand = new SqlCommand("uspGetPostCaption", dbConnection);
                dbCommand.CommandType = CommandType.StoredProcedure;
                dbCommand.Parameters.Add(new SqlParameter("@PostID", post.PostId));
                dbCommand.Parameters.Add(new SqlParameter("@PostType", post.PostType));

                dbConnection.Open();
                SqlDataReader dbReader = dbCommand.ExecuteReader();
                custArray = new ArrayList();

                if (post.PostType == "Event")
                {
                    while (dbReader.Read())
                    {
                        Event_Post aCountry = new Event_Post(dbReader["EventName"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Text")
                {
                    while (dbReader.Read())
                    {
                        Text_Post aCountry = new Text_Post(dbReader["PostText"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Photo")
                {
                    while (dbReader.Read())
                    {
                        Photo_Post aCountry = new Photo_Post(dbReader["PhotoCaption"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Article")
                {
                    while (dbReader.Read())
                    {
                        Article_Post aCountry = new Article_Post(dbReader["Title"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "Video")
                {
                    while (dbReader.Read())
                    {
                        Video_Post aCountry = new Video_Post(dbReader["VideoCaption"].ToString());
                        custArray.Add(aCountry);
                    }
                }
                else if (post.PostType == "File")
                {
                    while (dbReader.Read())
                    {
                        File_Post aCountry = new File_Post(dbReader["FileCaption"].ToString());
                        custArray.Add(aCountry);
                    }
                }

                dbConnection.Close();
            }
            return(custArray);
        }