//public JsonResult Members()
//{
// SocialViewModel a = new SocialViewModel();
// var idu = Session["ID"];
// var membertlist = db.E_Userss.SqlQuery("select * from E_Users where ID!=@p0", idu).ToList();
// //List<SocialViewModel> c = new Lis<SocialViewModel>();
// // }
// return Json(membertlist, JsonRequestBehavior.AllowGet);
//}
public ActionResult ImageRetriveFromLogedUSer(int ID)
{
var usrimg = db.E_Userss.SqlQuery("Select imgid from E_Users where ID=@p0", ID).FirstOrDefault();
Convert.ToInt32(usrimg);
UserImageStore usr = db.UserImageStore.SqlQuery("Select * from UserImageStores where imgid=@p0", usrimg).FirstOrDefault();
return(File(usr.ImageByte, "image/jpg"));
}
public JsonResult UploadImage(E_Users user)
{
int ImageID = 0;
var file = user.UserImage;
byte[] imagbyte = null;
if (file != null)
{
file.SaveAs(Server.MapPath("/uploadimage/" + file.FileName));
BinaryReader reader = new BinaryReader(file.InputStream);
imagbyte = reader.ReadBytes(file.ContentLength);
UserImageStore img = new UserImageStore();
img.ImageName = file.FileName;
img.ImageByte = imagbyte;
img.ImagePath = "/uploadimage/" + file.FileName;
img.ImageisDeleted = false;
db.UserImageStore.Add(img);
db.SaveChanges();
E_Users b = new E_Users();
E_Users usr = new E_Users();
usr.ID = 5;
usr.PhoneNumber = 100;
usr.imgid = 10;
db.E_Userss.SqlQuery("UPDATE E_Users SET imgid=@p0 where ID=@p1", img.ImageID, user.ID);
db.SaveChanges();
int output = db.Database.ExecuteSqlCommand("update E_Users set imgid=@p0 where ID=@p1 ", img.ImageID, user.ID);
ImageID = img.ImageID;
ImageID = user.ID;
if (output > 0)
{
ViewBag.Messge = "Added";
}
}
return(Json(ImageID, JsonRequestBehavior.AllowGet));
}
