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 Register(E_Users user) { if (ModelState.IsValid) { using (EmartDBContexts db = new EmartDBContexts()) { db.E_Userss.Add(user); db.SaveChanges(); } ModelState.Clear(); ViewBag.Message = user.FirstName + " " + user.LastName + " successfully created."; } return(View()); }