public IHttpActionResult MyPublishUpdate([FromBody] PUBLICATION publish, int id) { using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.PUBLICATIONS.FirstOrDefault(x => x.Id == id); if (result == null) { return(BadRequest()); } result.PubContent = publish.PubContent; result.PubTitle = publish.PubTitle; result.PubModifiedDate = DateTime.Now; result.PubSefLink = publish.PubSefLink; int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult CreateCategory(CATEGOR category) { int id = UserInf.GetUser(); try { using (MynoteDBEntities db = new MynoteDBEntities()) { category.UserId = id; db.CATEGORS.Add(category); int result = db.SaveChanges(); if (result != 0) { return(Ok()); } else { return(BadRequest()); } } } catch (Exception e) { return(BadRequest(e.Message)); } }
public IHttpActionResult AddUserFriend(int id) { int userid = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { FRIEND friend = new FRIEND { FromUserId = userid, ToUserId = id, StatusCode = 0 }; db.FRIENDS.Add(friend); int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult UserCategory() { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.CATEGORS.Where(x => x.UserId == id && x.isActive == 1).Select(x => new { x.Id, x.UserId, x.CategoryName, x.Seflink }).ToList(); if (result.Count != 0) { return(Ok(result)); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult DeleteMyFriend(int id) { int userid = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.FRIENDS.FirstOrDefault(x => x.ToUserId == userid && x.FromUserId == id); db.FRIENDS.Remove(result); int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult GetImage(int id) { List <byte[]> img = new List <byte[]>(); byte[] imgb; using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.IMAGES.Where(x => x.NotId == id).Select(x => new { x.Id, x.ImageName, x.ImagePath, x.CreatedDate }).ToList(); if (result.Count != 0) { try { foreach (var item in result) { imgb = File.ReadAllBytes(HttpContext.Current.Server.MapPath("~/UploadedFiles/" + item.ImageName)); img.Add(imgb); } return(Ok(img)); } catch (Exception e) { return(BadRequest(e.Message)); } } else { return(BadRequest()); } } }
public async Task <IHttpActionResult> FilesCreate(int publishid) { int userid = UserInf.GetUser(); List <string> path = new List <string>(); var fileuploadPath = HttpContext.Current.Server.MapPath("~/UploadedFilesPublish"); var multiFormDataStreamProvider = new MultiFileUploadProvider(fileuploadPath); await Request.Content.ReadAsMultipartAsync(multiFormDataStreamProvider); path = multiFormDataStreamProvider.FileData.Select(x => x.LocalFileName).ToList(); foreach (var item in path) { using (MynoteDBEntities db = new MynoteDBEntities()) { FILE file = new FILE { PublishId = publishid, FileName = Path.GetFileName(item), UserId = userid, CreatedTime = DateTime.Now, FilePath = item, IsActive = 1 }; db.FILES.Add(file); db.SaveChanges(); } } return(Ok()); }
public HttpResponseMessage DownloadFile(int id) { //Physical Path of Root Folder var rootPath = HttpContext.Current.Server.MapPath("~/UploadedFilesPublish"); using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.FILES.FirstOrDefault(x => x.Id == id); if (result == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } else { HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK); byte[] file = File.ReadAllBytes(result.FilePath); MemoryStream ms = new MemoryStream(file); response.Content = new ByteArrayContent(file); response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = result.FileName }; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream"); return(response); } } }
public IHttpActionResult MyFriend() { int id = UserInf.GetUser(); HashSet <int> list = new HashSet <int>(); using (MynoteDBEntities db = new MynoteDBEntities()) { if (db.FRIENDS.Any(x => x.ToUserId == id && x.StatusCode == 1)) { var result = db.FRIENDS.Where(x => x.ToUserId == id && x.StatusCode == 1).Select(x => new { x.FromUserId }).ToList(); foreach (var item in result) { list.Add(item.FromUserId); } } if (db.FRIENDS.Any(x => x.FromUserId == id && x.StatusCode == 1)) { var result = db.FRIENDS.Where(x => x.FromUserId == id && x.StatusCode == 1).Select(x => new { x.ToUserId }).ToList(); foreach (var item in result) { list.Add(item.ToUserId); } } list.Remove(id); if (list.Count != 0) { var users = db.USERS.Where(x => list.Contains(x.Id)).Select(x => new { x.Id, x.UserName, x.Name }).ToList(); return(Ok(users)); } else { return(BadRequest()); } } }
public IHttpActionResult AddComment([FromBody] PUBLICATIONSCOMMENT comment) { int userid = UserInf.GetUser(); comment.CommentUserId = userid; comment.CommentDate = DateTime.Now; comment.isActive = 1; try { using (MynoteDBEntities db = new MynoteDBEntities()) { db.PUBLICATIONSCOMMENTS.Add(comment); int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } } catch (Exception e) { return(BadRequest(e.Message)); } }
public IHttpActionResult GetMyPublish() { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.PUBLICATIONS.Where(x => x.PubUserId == id && x.isActive == 1).Select (x => new { x.Id, x.PubTitle, x.PubUserId, x.PubContent, x.PubCreatedDate, x.PubModifiedDate, x.isActive, x.PubSefLink }).ToList(); if (result.Count != 0) { return(Ok(result)); } else { return(NotFound()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult OkRequest(int id) { int userid = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { var friend = db.FRIENDS.FirstOrDefault(x => x.ToUserId == userid && x.FromUserId == id && x.StatusCode == 0); if (friend == null) { return(BadRequest()); } else { friend.StatusCode = 1; int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public async Task <IHttpActionResult> ImageCreate(int notid) { int userid = UserInf.GetUser(); List <string> path = new List <string>(); var fileuploadPath = HttpContext.Current.Server.MapPath("~/UploadedFiles"); var multiFormDataStreamProvider = new MultiFileUploadProvider(fileuploadPath); await Request.Content.ReadAsMultipartAsync(multiFormDataStreamProvider); path = multiFormDataStreamProvider.FileData.Select(x => x.LocalFileName).ToList(); foreach (var item in path) { using (MynoteDBEntities db = new MynoteDBEntities()) { IMAGE img = new IMAGE { ImagePath = item, ImageName = Path.GetFileName(item), NotId = notid, UserId = userid, CreatedDate = DateTime.Now }; db.IMAGES.Add(img); db.SaveChanges(); } } return(Ok()); }
public IHttpActionResult GetMyFrienReq() { HashSet <int> list = new HashSet <int>(); int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.FRIENDS.Where(x => x.ToUserId == id && x.StatusCode == 0).Select(x => new { x.FromUserId }).ToList(); foreach (var item in result) { list.Add(item.FromUserId); } if (list.Count != 0) { var request = db.USERS.Where(x => list.Contains(x.Id)).Select(x => new { x.Id, x.Name, x.UserName }).ToList(); return(Ok(request)); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult AddMyPublish([FromBody] PUBLICATION publish) { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { publish.PubUserId = id; db.PUBLICATIONS.Add(publish); int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult UpdateUserMailCheck(string mail) { int id = UserInf.GetUser(); string checkmail = mail.Replace(",com", ".com"); using (MynoteDBEntities db = new MynoteDBEntities()) { if (db.USERS.Any(x => x.Mail == checkmail)) { var result = db.USERS.FirstOrDefault(x => x.Mail == checkmail); if (result.Id == id) { return(Ok()); } else { return(BadRequest()); } } else { return(Ok()); } } }
public IHttpActionResult Update(string sef, [FromBody] CATEGOR category) { try { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.CATEGORS.FirstOrDefault(x => x.UserId == id && x.Seflink == sef); if (result != null) { result.CategoryName = category.CategoryName; int feed = db.SaveChanges(); if (feed != 0) { return(Ok()); } else { return(BadRequest()); } } else { return(BadRequest()); } } } catch (Exception e) { return(BadRequest(e.Message)); } }
public IHttpActionResult DeleteNote(int id) { using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.NOTES.FirstOrDefault(x => x.Id == id); if (result == null) { return(NotFound()); } else { result.isActive = 0; int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult UpdateNote(string seflink, [FromBody] NOTE note) { try { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { var gnote = db.NOTES.FirstOrDefault(x => x.NoteSefLink == seflink); if (gnote != null) { if (note.NoteCategoryId != null) { gnote.NoteTitle = note.NoteTitle; gnote.NoteDescription = note.NoteDescription; gnote.NoteContent = note.NoteContent; gnote.NoteCategoryId = note.NoteCategoryId; gnote.NoteModifiedDate = note.NoteModifiedDate; gnote.NoteModifiedId = id; int result = db.SaveChanges(); if (result != 0) { return(Ok()); } else { return(BadRequest()); } } else { gnote.NoteTitle = note.NoteTitle; gnote.NoteDescription = note.NoteDescription; gnote.NoteContent = note.NoteContent; gnote.privateNoteCategoryId = note.privateNoteCategoryId; gnote.NoteModifiedDate = note.NoteModifiedDate; gnote.NoteModifiedId = id; int result = db.SaveChanges(); if (result != 0) { return(Ok()); } else { return(BadRequest()); } } } else { return(NotFound()); } } } catch (Exception e) { return(BadRequest(e.Message)); } }
public IHttpActionResult GetFriendPublish() { HashSet <int> liste = new HashSet <int>(); int id = UserInf.GetUser(); try { using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.FRIENDS.Where(x => x.FromUserId == id || x.ToUserId == id).Select(x => new { x.Id, x.FromUserId, x.ToUserId, x.StatusCode }).ToList(); foreach (var item in result) { if (item.StatusCode == 1) { liste.Add(item.ToUserId); liste.Add(item.FromUserId); } } liste.Remove(id); var pubresult = db.PUBLICATIONS.Where(x => liste.Contains(x.PubUserId) && x.isActive == 1) .Select(x => new Models.DbModel.Publish { PublishId = x.Id, PublisherId = x.PubUserId, PublisherName = x.USER.Name, PublisherUserName = x.USER.UserName, PublishContent = x.PubContent, PublishTitle = x.PubTitle, PublishModifiedTime = x.PubModifiedDate, PublishTime = x.PubCreatedDate, PublishIsActive = x.isActive, PublishSef = x.PubSefLink, }).OrderByDescending(x => x.PublishTime).ToList(); if (pubresult.Count != 0) { return(Ok(pubresult)); } else { return(NotFound()); } } } catch (Exception e) { return(BadRequest(e.Message)); } }
public IHttpActionResult GetUserShareh() { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { if (db.SHARES.Any(x => x.FromUserıd == id || x.ToUserId == id)) { var result = db.SHARES.Where(x => x.FromUserıd == id && x.IsActive == 1 && x.NOTE.isActive == 1). Select(x => new Models.DbModel.Share { Id = x.NotId, NoteTitle = x.NOTE.NoteTitle, NoteContent = x.NOTE.NoteContent, NoteDescription = x.NOTE.NoteDescription, NoteCreatedDate = x.NOTE.NoteCreatedDate, NoteSefLink = x.NOTE.NoteSefLink, privateNoteCategoryId = x.NOTE.privateNoteCategoryId, NoteCategoryId = x.NOTE.NoteCategoryId, NoteUserId = x.NOTE.NoteUserId, isActive = x.NOTE.isActive, NoteModifiedDate = x.NOTE.NoteModifiedDate, NoteModifiedId = x.NOTE.NoteModifiedId, CategoryName = x.NOTE.SYSTEMCATEGOR.Name, PCategoryName = x.NOTE.CATEGOR.CategoryName, ModifiedName = x.NOTE.USER1.Name, FromUserName = x.USER1.Name }).OrderByDescending(x => x.NoteCreatedDate).GroupBy(x => x.Id).ToList(); var gidecek = result.Select(q => q.First()); if (gidecek.ToList().Count == 0) { return(BadRequest()); } else { return(Ok(gidecek)); } } else { return(NotFound()); } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult GetFiles(int id) { using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.FILES.Where(x => x.PublishId == id).Select(x => new { x.Id, x.FileName, x.FilePath, x.IsActive, x.UserId, x.PublishId }).ToList(); if (result.Count != 0) { return(Ok(result)); } else { return(BadRequest()); } } }
public IHttpActionResult GetAddFriend(string username) { string tusername = username.Trim(); int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { try { var result = db.USERS.FirstOrDefault(x => x.UserName == tusername); if (result == null) { return(Content(HttpStatusCode.NotFound, "Böyle bir kullanıcı bulunamadı")); } else { if (id != result.Id) { var sonuc = db.FRIENDS.FirstOrDefault(x => (x.ToUserId == id && x.FromUserId == result.Id) || (x.ToUserId == result.Id && x.FromUserId == id)); if (sonuc == null) { var user = db.USERS.Where(x => x.Id == result.Id).Select(x => new { x.Id, x.Name, x.UserName }).ToList(); return(Content(HttpStatusCode.Accepted, user.FirstOrDefault())); } else { if (sonuc.StatusCode == 0) { var user = db.USERS.Where(x => x.Id == result.Id).Select(x => new { x.Id, x.Name, x.UserName }).ToList(); return(Content(HttpStatusCode.Created, user.FirstOrDefault())); } else { var user = db.USERS.Where(x => x.Id == result.Id).Select(x => new { x.Id, x.Name, x.UserName }).ToList(); return(Content(HttpStatusCode.OK, user.FirstOrDefault())); } } } else { return(Content(HttpStatusCode.NoContent, "Kendini ekleyemezsin")); } } } catch (Exception e) { return(BadRequest(e.Message)); } } }
public IHttpActionResult UserMailCheck(string mail) { string checkmail = mail.Replace(",com", ".com"); using (MynoteDBEntities db = new MynoteDBEntities()) { if (db.USERS.Any(x => x.Mail == checkmail)) { return(BadRequest("Bu mail kullanımda")); } else { return(Ok()); } } }
public IHttpActionResult DeleteMyPublish(int id) { using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.PUBLICATIONS.FirstOrDefault(x => x.Id == id); result.isActive = 0; int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } }
public IHttpActionResult DeleteShare(int userid, int notid) { using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.SHARES.FirstOrDefault(x => x.ToUserId == userid && x.NotId == notid); result.IsActive = 0; int save = db.SaveChanges(); if (save != 0) { return(Ok()); } else { return(BadRequest()); } } }
public IHttpActionResult GetNote() { int id = UserInf.GetUser(); try { using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.NOTES.Where(x => x.NoteUserId == id && x.isActive == 1). Select(x => new Models.DbModel.Note { Id = x.Id, NoteTitle = x.NoteTitle, NoteContent = x.NoteContent, NoteDescription = x.NoteDescription, NoteCreatedDate = x.NoteCreatedDate, NoteSefLink = x.NoteSefLink, privateNoteCategoryId = x.privateNoteCategoryId, NoteCategoryId = x.NoteCategoryId, Name = x.USER.Name, NoteUserId = x.NoteUserId, isActive = x.isActive, NoteModifiedDate = x.NoteModifiedDate, NoteModifiedId = x.NoteModifiedId, CategoryName = x.SYSTEMCATEGOR.Name, PCategoryName = x.CATEGOR.CategoryName }).OrderByDescending(x => x.NoteCreatedDate).ToList(); if (result.Count != 0) { return(Ok(result)); } else { return(BadRequest("Bu id'ye ait not bulunmamaktadır")); } } } catch (Exception e) { return(BadRequest(e.Message)); } }
public IHttpActionResult GetUpdateNote(string seflink) { int id = UserInf.GetUser(); using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.NOTES.Where(x => x.NoteSefLink == seflink) .Select(x => new { x.Id, x.NoteContent, x.NoteTitle, x.NoteUserId, x.NoteDescription, x.NoteCreatedDate, x.NoteModifiedId, x.NoteModifiedDate, x.NoteSefLink, x.NoteCategoryId, x.privateNoteCategoryId }).ToList(); if (result.Count == 0) { return(BadRequest()); } else { return(Ok(result.FirstOrDefault())); } } }
public IHttpActionResult Pdf(int id) { using (MynoteDBEntities db = new MynoteDBEntities()) { var result = db.NOTES.Where(x => x.Id == id).Select(x => new Models.DbModel.Pdf { Title = x.NoteTitle, Description = x.NoteDescription, Content = x.NoteContent }).ToList(); if (result != null) { return(Ok(result.FirstOrDefault())); } else { return(BadRequest()); } } }
public IHttpActionResult GetComment(int pubid) { try { using (MynoteDBEntities db = new MynoteDBEntities()) { var presult = db.PUBLICATIONS.Where(x => x.Id == pubid).Select(x => new Models.DbModel.Publish { PublishContent = x.PubContent, PublishTitle = x.PubTitle, PublishId = x.Id }).ToList(); var cresult = db.PUBLICATIONSCOMMENTS.Where(x => x.CommnetPubId == pubid && x.isActive == 1).Select(x => new Models.DbModel.Comment { CommentContent = x.CommentContent, CommenterName = x.USER.Name, CommenterUserName = x.USER.UserName, CommentId = x.Id, CommenterId = x.CommentUserId, CommentTime = x.CommentDate }).OrderByDescending(x => x.CommentTime).ToList(); Models.DbModel.CommentViewModel view = new Models.DbModel.CommentViewModel { Publish = presult.FirstOrDefault(), Comments = cresult }; if (cresult.Count != 0) { return(Ok(view)); } else { return(BadRequest()); } } } catch { return(BadRequest()); } }