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());
}
