public ActionResult Index(S_Post spost) { string msg = ""; if (ModelState.IsValid) { if (Session["ID"] != null) { var id = Session["ID"]; try { List <object> obj = new List <Object>(); obj.Add(spost.PostTime); obj.Add(spost.PostContent); obj.Add(spost.Post_like); obj.Add(spost.S_userID); obj.Add(spost.Postimgid); object[] dataarray = obj.ToArray(); int output = db.Database.ExecuteSqlCommand("insert into S_Post(PostTime,PostContent,Post_like,S_userID,Postimgid)values(@p0,@p1,@p2,@p3,@p4)", dataarray); if (output > 0) { ViewBag.Message = "Added"; } //return RedirectToAction("EmartInWall"); //return Convert.ToString(output); msg = "Successfully Saved"; } catch (Exception e) { msg = e.Message; } } else { msg = "Please Provide the content"; } } if (Request.IsAjaxRequest()) { return(new JsonResult { Data = msg, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } else { ViewBag.Message = msg; return(View(spost)); } }
public JsonResult UploadPostImage(S_Post post) { int ImageID = 0; var file = post.PostImage; byte[] imagbyte = null; if (file != null) { file.SaveAs(Server.MapPath("/uploadpostimage/" + file.FileName)); BinaryReader reader = new BinaryReader(file.InputStream); imagbyte = reader.ReadBytes(file.ContentLength); UserPostImages img = new UserPostImages(); img.ImageName = file.FileName; img.ImageByte = imagbyte; img.ImagePath = "/uploadpostimage/" + file.FileName; img.ImageisDeleted = false; db.UserPostImages.Add(img); db.SaveChanges(); List <S_frns> frnsList = db.S_frnss.SqlQuery("select * from S_frns where s_frnID=@p0", post.S_userID).ToList(); for (var i = 0; i < frnsList.Count; i++) { int err = db.Database.ExecuteSqlCommand("insert into Notifications (userid,postid,status) values(@p0,@p1,@p2)", frnsList[i].S_userID, post.postID, 1); } ImageID = img.ImageID; post.Postimgid = ImageID; S_Post p = new S_Post(); List <object> obj = new List <Object>(); obj.Add(post.PostTime); obj.Add(post.PostContent); obj.Add(post.Post_like); obj.Add(post.S_userID); obj.Add(post.Postimgid); object[] dataarray = obj.ToArray(); int output = db.Database.ExecuteSqlCommand("insert into S_Post(PostTime,PostContent,Post_like,S_userID,Postimgid)values(@p0,@p1,@p2,@p3,@p4)", dataarray); if (output > 0) { ViewBag.Message = "Added"; } } return(Json(ImageID, JsonRequestBehavior.AllowGet)); }
public ActionResult ListPossts() { if (Session["ID"] != null) { S_Post post = new S_Post(); SocialViewModel a = new SocialViewModel(); var id = Session["ID"]; var Posttlist = db.S_Posts.SqlQuery("Select * from S_Post").ToList(); //c = new SocialViewModel(); return(View(Posttlist)); // } } return(View()); }