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