public void Delete(int id)
{
try
{
var post = context.Posts.Find(id);
if (post == null)
{
return;
}
var postLikes = context.Likes.Where(l => l.PostId == id);
foreach (var like in postLikes)
{
like.IsLiked = false;
context.Entry(like).State = EntityState.Modified;
}
var postComments = context.Comments.Where(c => c.PostId == id);
foreach (var comment in postComments)
{
comment.IsDeleted = true;
context.Entry(comment).State = EntityState.Modified;
}
post.IsDeleted = true;
context.Entry(post).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
public IHttpActionResult PutComment(int id, Comment comment)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != comment.comment_id)
{
return(BadRequest());
}
db.Entry(comment).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CommentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutUser([FromUri] int id, User user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != user.user_id)
{
return(BadRequest());
}
db.Entry(user).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok(user));
}
public IHttpActionResult PutGroup_Posts(int id, Group_Posts group_Posts)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != group_Posts.post_id)
{
return(BadRequest());
}
db.Entry(group_Posts).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Group_PostsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutBlocked_Users(int id, Blocked_Users blocked_Users)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != blocked_Users.user_id)
{
return(BadRequest());
}
db.Entry(blocked_Users).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Blocked_UsersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Create(DtoConnection conn)
{
Connection Econn = new Connection();
Econn.CreatedDate = conn.CreatedDate;
Econn.IsActive = conn.IsActive;
Econn.IsDeleted = conn.IsDeleted;
Econn.UserIdOne = conn.UserIdOne;
Econn.UserIdTwo = conn.UserIdTwo;
context.connections.Add(Econn);
context.SaveChanges();
}
public void Insert(Like t)
{
try
{
context.Likes.Add(t);
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
public void Delete(string id)
{
try
{
var user = context.Users.Find(id);
if (user == null)
{
return;
}
user.IsDeleted = true;
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
public void Delete(string id)
{
try
{
var friendRequest = context.FriendRequests.Find(id);
if (friendRequest == null)
{
return;
}
context.Remove(friendRequest);
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
public void DeleteById(int id)
{
try
{
var comment = context.Comments.FirstOrDefault(c => c.CommentId == id);
if (comment == null)
{
return;
}
comment.IsDeleted = true;
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
public IActionResult CreateAccount(string firstname, string lastname, string tel_email, string pswrd, string gender, string day, string month, string year)
{
User user = new User();
user.FirstName = firstname;
user.LastName = lastname;
user.Password = pswrd;
user.Gender = gender;
if (day != null && month != null && year != null)
{
DateTime date = new DateTime();
date.AddYears(Convert.ToInt32(year));
date.AddMonths(Convert.ToInt32(month));
date.AddDays(Convert.ToInt32(day));
user.BirthDate = date;
}
if (tel_email.Contains("@"))
{
user.Email = tel_email;
}
else
{
user.PhoneNumber = tel_email;
}
Image image = new Image();
if (gender == "erkek" || gender == "özel")
{
image.ImageLink = "iconfinder_user_male2_172626.png";
}
else if (gender == "kadın")
{
image.ImageLink = "iconfinder_user_female2_172622.png";
}
context.Users.Add(user);
context.SaveChanges();
user.ProfilePhoto = image;
user.Images.Add(image);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Likeoperation(Like entity)
{
var sorgu = context.Likes.Where(x => x.PostId == entity.PostId && x.UserId == entity.UserId).FirstOrDefault();
if (sorgu == null)
{
entity.IsActive = true;
context.Likes.Add(entity);
context.SaveChanges();
}
else
{
sorgu.IsActive = true;
context.Likes.Update(sorgu);
context.SaveChanges();
}
return(Json(true));
}
public void AddComment(DtoComment commentDto)
{
Comment comment = new Comment();
comment.UserId = commentDto.UserId;
comment.PostId = commentDto.PostId;
comment.Description = commentDto.Description;
comment.CommentCount = commentDto.CommentCount;
comment.IsDeleted = commentDto.IsDeleted;
db.comments.Add(comment);
db.SaveChanges();
}
public async Task SendMessage(string user, string friend, string message)
{
Message msg = new Message();
msg.Content = message;
msg.SendDate = DateTime.Now;
msg.FriendId = Convert.ToInt32(friend);
msg.FriendUser = context.Users.Find(Convert.ToInt32(friend));
context.Users.Find(Convert.ToInt32(user)).Messages.Add(msg);
context.SaveChanges();
await Clients.All.SendAsync("ReceiveMessage", user, message);
}
public void CreatePost(DtoPost post)
{
Post postentity = new Post();
postentity.CommentCount = post.CommentCount;
postentity.Description = post.Description;
postentity.LikeCount = post.LikeCount;
postentity.Photo = post.Photo;
postentity.Replyto = post.Replyto;
postentity.UserID = post.UserID;
postentity.CreatedDate = DateTime.Now;
postentity.isactive = true;
postentity.isdelete = false;
fbcontext.Post.Add(postentity);
fbcontext.SaveChanges();
}
public IActionResult SharePost(string content, int userid)
{
Post post = new Post();
post.Content = content;
post.CreateDate = DateTime.Now;
var user = context.Users.Find(userid);
post.User = user;
post.UserId = user.UserId;
user.Posts.Add(post);
context.SaveChanges();
int id = userid;
return(RedirectToAction("Index", "Main", new { id }));
}
public void Create(DtoUser dtouser)
{
_user.FullName = dtouser.FullName;
_user.Username = dtouser.Username;
_user.Password = dtouser.Password;
_user.LiveCity = dtouser.LiveCity;
_user.Homeland = dtouser.Homeland;
_user.ProfilPhoto = dtouser.ProfilPhoto;
_user.BackgorundImage = dtouser.BackgroundImage;
_user.PhoneNumber = dtouser.PhoneNumber;
_user.CreatedDate = DateTime.Now;
_user.IsActive = true;
_user.IsDeleted = false;
_user.Private = true;
context.Users.Add(_user);
context.SaveChanges();
}
public ActionResult Create(Post p)
{
db.Posts.Add(p);
db.SaveChanges();
return(Json(p.PostId));
}