public objRegisterResponseModel UpdateUserProfile()
{
IAuthentication _repository = new DataAccess.Authentication.Authentication();
objRegisterResponseModel response = new objRegisterResponseModel();
AppResponseView appResponse = new AppResponseView();
////////////////////////////////////////////
var httpRequest = HttpContext.Current.Request;
HttpPostedFile postedFile = null;
if (httpRequest.Files.Count > 0)
{
postedFile = httpRequest.Files[0];
}
//convert the posted file stream a to memory stream
//System.IO.MemoryStream target = new System.IO.MemoryStream();
//postedFile.InputStream.CopyTo(target);
//the following static function is a function I built which accepts the amazon file key and also the object that will be uploaded to S3, in this case, a MemoryStream object
UserModel request = new UserModel();
request.Id = int.Parse(httpRequest.Form["UserId"]);
request.FullName = httpRequest.Form["FullName"] == ""?null: httpRequest.Form["FullName"];
request.PhoneNo = httpRequest.Form["PhoneNo"] == "" ? null : httpRequest.Form["PhoneNo"];
request.EmailId = httpRequest.Form["EmailId"] == "" ? null : httpRequest.Form["EmailId"];
request.Password = httpRequest.Form["Password"] == "" ? null : httpRequest.Form["Password"];
if (postedFile != null)
{
AmazonS3Uploader service = new AmazonS3Uploader();
request.ProfilePic = service.UploadFile("FarmPeProfilePics/" + request.Id + postedFile.FileName, new HttpPostedFileWrapper(postedFile));
}
//////////////////////////////////////////////
appResponse.Status = _repository.UpdateUserProfile(request);
response.Response = appResponse;
return(response);
}
public List <GroupModel> GetListGroup(long Id)
{
var result = (from c in context.GroupMembers
where c.Status == StatusMember.ACCEPT && c.UserId == Id
join p1 in context.Groups on c.GroupID equals p1.ID into ps1
from p1 in ps1.DefaultIfEmpty()
orderby c.CreatedTime descending
select new GroupModel
{
CreatedTime = c.CreatedTime,
Avatar = p1.Avatar,
GroupName = p1.GroupName,
Banner = p1.Banner,
ID = p1.ID,
InfoId = p1.InfoId,
CreatedUser = p1.CreatedUser,
Status = p1.Status,
TypeMember = c.Type
}).ToList();
foreach (var item in result)
{
var respone = AmazonS3Uploader.GetUrl(item.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
item.Avatar = respone;
}
respone = AmazonS3Uploader.GetUrl(item.Banner, 0);
if (!string.IsNullOrEmpty(respone))
{
item.Banner = respone;
}
}
return(result);
}
public List <MemberModel> GetMemberSending(long UserId, string date)
{
DateTime createDate = DateTime.UtcNow;
if (!string.IsNullOrEmpty(date))
{
createDate = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc);
createDate = createDate.AddMilliseconds(double.Parse(date)).ToLocalTime();
}
var result = (from c in context.GroupMembers
join p1 in context.Users on c.UserId equals p1.ID into ps1
from p1 in ps1.DefaultIfEmpty()
where c.CreatedTime < createDate && c.Status == StatusMember.SENDING && c.GroupID == UserId
orderby c.CreatedTime descending
select new MemberModel
{
CreatedTime = c.CreatedTime,
Avatar = p1.Avatar,
NickName = p1.NickName,
Type = c.Type,
Id = p1.ID
}).Take(10).ToList();
foreach (var item in result)
{
var respone = AmazonS3Uploader.GetUrl(item.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
item.Avatar = respone;
}
}
return(result);
}
public ActionResult Index()
{
AmazonS3Uploader amazonS3 = new AmazonS3Uploader();
amazonS3.UploadFile();
return View();
}
public List <FriendModel> SearchFriend(long UserId, string query)
{
var ListFriend = new List <FriendModel>();
var result = (from c in context.Users
where c.NickName.Contains(query) || c.SubName.Contains(query)
orderby c.NickName descending
select new { c }).Take(200).ToList();
foreach (var item in result)
{
var Friend = new FriendModel();
Friend.Avatar = item.c.Avatar;
Friend.NickName = item.c.NickName;
Friend.Id = item.c.ID;
Friend.Type = TypeRequestFriend.USER;
Friend.CreatedTime = item.c.CreatedTime;
var respone = AmazonS3Uploader.GetUrl(item.c.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
Friend.Avatar = respone;
}
ListFriend.Add(Friend);
}
return(ListFriend);
}
public List <RequestFriendModel> GetRequestFriend(long UserId)
{
var ListRequestFriend = new List <RequestFriendModel>();
var result = (from c in context.Relationships
join p1 in context.Users on c.UserSentID equals p1.ID into ps1
from p1 in ps1.DefaultIfEmpty()
join p2 in context.Groups on c.UserSentID equals p2.ID into ps2
from p2 in ps2.DefaultIfEmpty()
where c.UserReceiveID == UserId && c.Status == StatusRequestFriend.SENDING
orderby c.CreatedTime descending
select new RequestFriendModel
{
TargetId = p1 != null ? p1.ID : p2.ID,
Avatar = p1 != null ? p1.Avatar : p2.Avatar,
NickName = p1 != null ? p1.NickName : p2.GroupName,
Type = p1 != null ? TypeRequestFriend.USER : TypeRequestFriend.GROUP,
Id = c.ID
}).ToList();
foreach (var item in result)
{
var respone = AmazonS3Uploader.GetUrl(item.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
item.Avatar = respone;
}
}
return(result);
}
public MemberModel GetMemberGroupByID(long id, long groupId)
{
var result = (from c in context.GroupMembers
join p1 in context.Users on c.UserId equals p1.ID into ps1
from p1 in ps1.DefaultIfEmpty()
where c.Status == StatusMember.ACCEPT && c.GroupID == groupId && c.UserId == id
orderby c.CreatedTime descending
select new MemberModel
{
CreatedTime = c.CreatedTime,
Avatar = p1.Avatar,
NickName = p1.NickName,
Type = c.Type,
Id = p1.ID
}).FirstOrDefault();
if (!string.IsNullOrEmpty(result?.Avatar))
{
var respone = AmazonS3Uploader.GetUrl(result.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
result.Avatar = respone;
}
}
return(result);
}
public List <PostViewModel> GetListImage(long Id)
{
var result = (from c in context.Posts
where (c.TargetId != null && c.TargetId == Id) && c.TargetType == TypePost.USER && !string.IsNullOrEmpty(c.Images)
orderby c.CreatedTime descending
select new{ c }).Take(6).ToList();
var PostView = new List <PostViewModel>();
foreach (var item in result)
{
var Post = new PostViewModel();
Post.Id = item.c.ID;
Post.Images = item.c.Images;
if (!string.IsNullOrEmpty(item.c.Images))
{
var data = item.c.Images.Split(',');
Post.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
Post.ListImages.Add(respone);
}
}
}
PostView.Add(Post);
}
return(PostView);
}
public ActionResult CreatedPost(PostModel model)
{
if (ModelState.IsValid)
{
try
{
Post post = new Post();
post = Mapper.Map <Post>(model);
if (model.ListImages != null)
{
foreach (var item in model.ListImages)
{
if (string.IsNullOrEmpty(post.Images))
{
//Task<string> task = Task.Run<string>(async () => await UploadImageTifiny.TinifyModulAsync(item,TypeUpload.IMAGE));
var result = AmazonS3Uploader.UploadFile(item, TypeUpload.IMAGE);
if (result == "")
{
continue;
}
post.Images += result;
}
else
{
//Task<string> task = Task.Run<string>(async () => await UploadImageTifiny.TinifyModulAsync(item,TypeUpload.IMAGE));
var result = AmazonS3Uploader.UploadFile(item, TypeUpload.IMAGE);
if (result == "")
{
continue;
}
post.Images += "," + result;
}
}
}
if (model.ListVideos != null)
{
foreach (var item in model.ListVideos)
{
if (string.IsNullOrEmpty(post.Videos))
{
post.Videos += AmazonS3Uploader.UploadFile(item, TypeUpload.VIDEO);
}
else
{
post.Videos += "," + AmazonS3Uploader.UploadFile(item, TypeUpload.VIDEO);
}
}
}
postRepository.InsertPost(post);
}
catch (Exception ex)
{
return(Json(new { result = Constant.ERROR }));
}
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(new { result = Constant.SUCCESS }));
}
public ActionResult CreatedAudio(HttpPostedFileBase file)
{
var url = string.Empty;
var respons = AmazonS3Uploader.UploadFileStream(file.InputStream, TypeUpload.AUDIO);
if (!string.IsNullOrEmpty(respons))
{
url = AmazonS3Uploader.GetUrl(respons);
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(new { result = Constant.SUCCESS, data = url, key = respons }));
}
public User GetUserByID(long id)
{
var result = context.Users.Find(id);
var respone = AmazonS3Uploader.GetUrl(result.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
result.Avatar = respone;
}
respone = AmazonS3Uploader.GetUrl(result.BackGround, 0);
if (!string.IsNullOrEmpty(respone))
{
result.BackGround = respone;
}
return(result);
}
public Group GetLastGroups()
{
var result = context.Groups.OrderByDescending(x => x.CreatedTime).FirstOrDefault();
var respone = AmazonS3Uploader.GetUrl(result.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
result.Avatar = respone;
}
respone = AmazonS3Uploader.GetUrl(result.Banner, 0);
if (!string.IsNullOrEmpty(respone))
{
result.Banner = respone;
}
return(result);
}
public Group GetGroupByID(long id)
{
var result = context.Groups.Find(id);
var respone = AmazonS3Uploader.GetUrl(result.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
result.Avatar = respone;
}
respone = AmazonS3Uploader.GetUrl(result.Banner, 0);
if (!string.IsNullOrEmpty(respone))
{
result.Banner = respone;
}
return(result);
}
public User GetUserByName(string UserName)
{
var result = context.Users.Where(x => x.UserName == UserName).FirstOrDefault();
var respone = AmazonS3Uploader.GetUrl(result.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
result.Avatar = respone;
}
respone = AmazonS3Uploader.GetUrl(result.BackGround, 0);
if (!string.IsNullOrEmpty(respone))
{
result.BackGround = respone;
}
return(result);
}
public ResponseModel AddUpdateFarms()//FarmsModel request, HttpPostedFile farmimage, HttpPostedFile coverimage)
{
IAuthentication _authrepository = new DataAccess.Authentication.Authentication();
IMasterTablesDataAccess _repository = new MasterTablesDataAccess();
int response = 0;
var httpRequest = HttpContext.Current.Request;
FarmsModel objFarmsModel = new FarmsModel();
FarmsModel request = new FarmsModel();
request = JsonConvert.DeserializeObject <FarmsModel>(httpRequest.Form["farmsdetail"]);
HttpPostedFile farmimage = httpRequest.Files["farmimage"];
if (farmimage != null)
{
AmazonS3Uploader service = new AmazonS3Uploader();
request.FarmImages = service.UploadFile("FarmImages/" + request.MobileNumber + farmimage.FileName, new HttpPostedFileWrapper(farmimage));
}
HttpPostedFile coverimage = httpRequest.Files["coverimage"];
if (coverimage != null)
{
AmazonS3Uploader service = new AmazonS3Uploader();
request.CoverPhoto = service.UploadFile("FarmCoverPhotos/" + request.MobileNumber + coverimage.FileName, new HttpPostedFileWrapper(coverimage));
}
response = _repository.AddUpdateFarms(request);
string Status = "0";
ResponseModel model = new ResponseModel();
if (response > 0)
{
model.Status = response.ToString();
model.Message = "Farm has been added/updated successfully.";
UserModel user = new UserModel();
user = _authrepository.GetUserDetails(request.CreatedBy);
//var lfd = _repository.GetLookingForDetailsById(request.LookingForDetailsId).LookingForDetails;
//var models = _repository.GetModelById(request.ModelId).Model;
//string msg = user.FullName + " is Looking for " + lfd + " of " + models;
//Notification.SendNotification(request.UserId, WebConfigurationManager.AppSettings["LKF"], msg);
}
else
{
model.Status = "0";
}
return(model);
}
public List <FriendModel> GetFriend(long UserId)
{
var ListFriend = new List <FriendModel>();
var result = (from c in context.Relationships
join p1 in context.Users on c.UserReceiveID equals p1.ID into ps1
from p1 in ps1.DefaultIfEmpty()
join p2 in context.Users on c.UserSentID equals p2.ID into ps2
from p2 in ps2.DefaultIfEmpty()
where (c.UserReceiveID == UserId || c.UserSentID == UserId) && c.Status == StatusRequestFriend.ACCEPT
orderby c.CreatedTime descending
select new { c, p1, p2 }).ToList();
foreach (var item in result)
{
var Friend = new FriendModel();
if (item.p1.ID == UserId)
{
Friend.Avatar = item.p2.Avatar;
Friend.NickName = item.p2.NickName;
Friend.Id = item.p2.ID;
Friend.CreatedTime = item.c.CreatedTime;
var respone = AmazonS3Uploader.GetUrl(item.p2.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
Friend.Avatar = respone;
}
}
else
{
Friend.Avatar = item.p1.Avatar;
Friend.NickName = item.p1.NickName;
Friend.Id = item.p1.ID;
Friend.CreatedTime = item.c.CreatedTime;
var respone = AmazonS3Uploader.GetUrl(item.p1.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
Friend.Avatar = respone;
}
}
ListFriend.Add(Friend);
}
return(ListFriend);
}
public ActionResult CreatedComment(CommentViewModel model)
{
var data = new CommentViewModel();
if (ModelState.IsValid)
{
try
{
Comment comment = new Comment();
comment = Mapper.Map <Comment>(model);
if (model.ListImages != null)
{
foreach (var item in model.ListImages)
{
if (string.IsNullOrEmpty(comment.Images))
{
//Task<string> task = Task.Run<string>(async () => await UploadImageTifiny.TinifyModulAsync(item, TypeUpload.IMAGE));
//if (task.Result == "")
// continue;
//comment.Images += task.Result;
comment.Images += AmazonS3Uploader.UploadFile(item, TypeUpload.IMAGE);
}
else
{
//Task<string> task = Task.Run<string>(async () => await UploadImageTifiny.TinifyModulAsync(item, TypeUpload.IMAGE));
//if (task.Result == "")
// continue;
//comment.Images += "," + task.Result;
comment.Images += "," + AmazonS3Uploader.UploadFile(item, TypeUpload.IMAGE);
}
}
}
var idCommnet = commentRepository.InsertComment(comment);
data = commentRepository.GetCommentByID(idCommnet, userLogin.ID);
}
catch (Exception ex)
{
return(Json(new { result = Constant.ERROR }));
}
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(new { result = Constant.SUCCESS, data }));
}
public ActionResult UploadBackGround(string BackGround)
{
try
{
var user = userRepository.GetUserByIDForUpdate(userLogin.ID);
var result = AmazonS3Uploader.UploadFile(BackGround, TypeUpload.IMAGE);
//Task<string> task = Task.Run<string>(async () => await UploadImageTifiny.TinifyModulAsync(BackGround,TypeUpload.IMAGE));
//if(result == "" )
// return Json(new { result = Constant.ERROR,message = "Error!" });
user.BackGround = result;
userRepository.UpdateUser(user);
userLogin = userRepository.GetUserByID(userLogin.ID);
}
catch (Exception ex)
{
return(Json(new { result = Constant.ERROR, message = "Error!" }));
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(new { result = Constant.SUCCESS }));
}
public ActionResult UploadBackGround(string BackGround, long id)
{
try
{
var group = groupRepository.GetGroupByIDForUpdate(id);
//Task<string> task = Task.Run<string>(async () => await UploadImageTifiny.TinifyModulAsync(BackGround,TypeUpload.IMAGE));
var result = AmazonS3Uploader.UploadFile(BackGround, TypeUpload.IMAGE);
if (result == "")
{
return(Json(new { result = Constant.ERROR, message = "Error!" }));
}
group.Banner = result;
groupRepository.UpdateGroup(group);
}
catch (Exception ex)
{
return(Json(new { result = Constant.ERROR, message = "Error!" }));
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(new { result = Constant.SUCCESS }));
}
public List <CommentViewModel> LoadCommentsPost(string PostIds, string date, int quantity, long LoginUser)
{
DateTime createDate = DateTime.UtcNow;
if (!string.IsNullOrEmpty(date))
{
createDate = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc);
createDate = createDate.AddMilliseconds(double.Parse(date)).ToLocalTime();
}
var CommentView = new List <CommentViewModel>();
if (String.IsNullOrEmpty(PostIds))
{
return(CommentView);
}
List <string> LPostsId = PostIds.Split(',').ToList();
for (var i = 0; i < LPostsId.Count; i++)
{
var resultMost = new List <CommentViewModel>();
var result = new List <CommentViewModel>();
var PostId = Int64.Parse(LPostsId[i]);
if (string.IsNullOrEmpty(date))
{
resultMost = (from c in context.Comments
join p4 in context.Users on c.UserId equals p4.ID into ps4
from p4 in ps4.DefaultIfEmpty()
join p5 in context.Comments on new { a1 = c.ID, a2 = TypeComment.COMMENT } equals new { a1 = p5.TargetId, a2 = p5.TargetType.Value } into ps5
join p6 in context.Emotions on new { t1 = LoginUser, t2 = c.ID } equals new { t1 = p6.UserId.Value, t2 = p6.TargetId.Value } into ps6
from p6 in ps6.DefaultIfEmpty()
let countEmotions = (from E in context.Emotions where E.TargetId == c.ID select E).Count()
where PostId == c.TargetId && c.CreatedTime < createDate && c.TargetType == TypeComment.POST && countEmotions > 100
orderby countEmotions ascending
select new CommentViewModel
{
Id = c.ID,
Audios = c.Audios,
TargetId = c.TargetId,
CreatedTime = c.CreatedTime,
Images = c.Images,
Tags = c.Tags,
TagsUser = c.TagsUser,
Content = c.Content,
UserId = c.UserId,
Avatar = p4.Avatar,
NickName = p4.NickName,
CountReply = ps5.Count(),
CountEmotions = countEmotions,
StatusEmotion = p6 == null ? (byte)0 : p6.Status
}).Take(quantity + 1).ToList();
}
if (resultMost.Count == 0)
{
result = (from c in context.Comments
join p4 in context.Users on c.UserId equals p4.ID into ps4
from p4 in ps4.DefaultIfEmpty()
join p5 in context.Comments on new { a1 = c.ID, a2 = TypeComment.COMMENT } equals new { a1 = p5.TargetId, a2 = p5.TargetType.Value } into ps5
join p6 in context.Emotions on new { t1 = LoginUser, t2 = c.ID } equals new { t1 = p6.UserId.Value, t2 = p6.TargetId.Value } into ps6
from p6 in ps6.DefaultIfEmpty()
let countEmotions = (from E in context.Emotions where E.TargetId == c.ID select E).Count()
where PostId == c.TargetId && c.CreatedTime < createDate && c.TargetType == TypeComment.POST
orderby c.CreatedTime descending
select new CommentViewModel
{
Id = c.ID,
Audios = c.Audios,
TargetId = c.TargetId,
CreatedTime = c.CreatedTime,
Images = c.Images,
Tags = c.Tags,
TagsUser = c.TagsUser,
Content = c.Content,
UserId = c.UserId,
Avatar = p4.Avatar,
NickName = p4.NickName,
CountReply = ps5.Count(),
CountEmotions = countEmotions,
StatusEmotion = p6 == null ? (byte)0 : p6.Status
}).Take(quantity + 1).ToList();
if (result.Count > quantity)
{
result[result.Count - 2].MoreComment = true;
result.RemoveAt(result.Count - 1);
}
}
else
{
if (result.Count > quantity)
{
result[result.Count - 2].MoreComment = true;
result.RemoveAt(result.Count - 1);
}
else
{
result[result.Count - 1].MoreComment = true;
}
}
CommentView = CommentView.Union(result).ToList();
}
foreach (var item in CommentView)
{
var responeImage = AmazonS3Uploader.GetUrl(item.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
item.Avatar = responeImage;
}
if (!string.IsNullOrEmpty(item.Images))
{
var data = item.Images.Split(',');
item.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
item.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.Audios))
{
var data = item.Audios.Split(',');
item.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
item.ListAudios.Add(respone);
}
}
}
}
return(CommentView);
}
public List <FriendModel> GetSuggestFriend(long UserId, string query, bool?location, string category)
{
var List = new List <string>();
if (!string.IsNullOrEmpty(category))
{
List = category.Split(',').ToList();
}
var User = (from c in context.Users where c.ID == UserId select c).FirstOrDefault();
var ListFriend = new List <FriendModel>();
var result1 = (from c in context.Users
from t2 in context.Relationships.Where(tt2 => (c.ID == tt2.UserReceiveID && UserId == tt2.UserSentID) || (UserId == tt2.UserReceiveID && c.ID == tt2.UserSentID)).DefaultIfEmpty()
where (string.IsNullOrEmpty(query) || (c.NickName.Contains(query) || c.SubName.Contains(query))) &&
(c.Lat != null && c.Lng != null) &&
c.ID != UserId &&
(t2.ID == 0 || t2.Status != StatusRequestFriend.ACCEPT || t2.Type != TypeRequestFriend.USER)
orderby c.NickName descending
select new { c, distance = (c.Lat.Value - User.Lat.Value) * (c.Lat.Value - User.Lat.Value) + (c.Lng - User.Lng.Value) * (c.Lng.Value - User.Lng.Value) }).OrderBy(x => x.distance).Take(10000).OrderBy(x => Guid.NewGuid()).Take(50).ToList();
foreach (var item in result1)
{
var Friend = new FriendModel();
Friend.Avatar = item.c.Avatar;
Friend.NickName = item.c.NickName;
Friend.Id = item.c.ID;
Friend.Type = TypeRequestFriend.USER;
Friend.CreatedTime = item.c.CreatedTime;
Friend.Suggest = TypeSuggest.LOCATION;
var respone = AmazonS3Uploader.GetUrl(item.c.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
Friend.Avatar = respone;
}
ListFriend.Add(Friend);
}
var result2 = (from c in context.Users
from t2 in context.Relationships.Where(tt2 => (c.ID == tt2.UserReceiveID && UserId == tt2.UserSentID) || (UserId == tt2.UserReceiveID && c.ID == tt2.UserSentID)).DefaultIfEmpty()
where (string.IsNullOrEmpty(query) || (c.NickName.Contains(query) || c.SubName.Contains(query))) &&
c.ID != UserId &&
List.Any(x => c.Category.Contains(x)) &&
(t2.ID == 0 || t2.Status != StatusRequestFriend.ACCEPT || t2.Type != TypeRequestFriend.USER)
orderby c.NickName descending
select new { c }).OrderBy(x => Guid.NewGuid()).Take(50).ToList();
foreach (var item in result2)
{
var Friend = new FriendModel();
Friend.Avatar = item.c.Avatar;
Friend.NickName = item.c.NickName;
Friend.Id = item.c.ID;
Friend.Type = TypeRequestFriend.USER;
Friend.CreatedTime = item.c.CreatedTime;
Friend.Suggest = TypeSuggest.CATEGORY;
var respone = AmazonS3Uploader.GetUrl(item.c.Avatar, 0);
if (!string.IsNullOrEmpty(respone))
{
Friend.Avatar = respone;
}
var same = ListFriend.Where(x => x.Id == Friend.Id).ToList();
if (same.Count == 0)
{
ListFriend.Add(Friend);
}
else
{
ListFriend.Where(x => x.Id == Friend.Id).FirstOrDefault().Suggest = TypeSuggest.BOTH;
}
}
ListFriend.OrderBy(a => Guid.NewGuid()).ToList();
return(ListFriend);
}
public List <CommentViewModel> LoadCommentsReply(string CommentId, string date, int quantity, string createdUser)
{
long UserId = 0;
if (!string.IsNullOrEmpty(createdUser))
{
UserId = long.Parse(createdUser);
}
DateTime createDate = DateTime.UtcNow;
if (!string.IsNullOrEmpty(date))
{
createDate = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc);
createDate = createDate.AddMilliseconds(double.Parse(date)).ToLocalTime();
}
var CommentView = new List <CommentViewModel>();
if (String.IsNullOrEmpty(CommentId))
{
return(CommentView);
}
var CommentIdI = Int64.Parse(CommentId);
var result = (from c in context.Comments
join p4 in context.Users on c.UserId equals p4.ID into ps4
from p4 in ps4.DefaultIfEmpty()
join p5 in context.Comments on new { a1 = c.ID, a2 = TypeComment.COMMENT } equals new { a1 = p5.TargetId, a2 = p5.TargetType.Value } into ps5
let countEmotions = (from E in context.Emotions where E.TargetId == c.ID select E).Count()
where CommentIdI == c.TargetId && c.CreatedTime < createDate && (UserId == 0 || UserId == c.UserId) && c.TargetType == TypeComment.COMMENT
orderby c.CreatedTime descending
select new CommentViewModel
{
Id = c.ID,
Audios = c.Audios,
TargetId = c.TargetId,
CreatedTime = c.CreatedTime,
Images = c.Images,
Tags = c.Tags,
TagsUser = c.TagsUser,
Content = c.Content,
UserId = c.UserId,
Avatar = p4.Avatar,
NickName = p4.NickName,
CountReply = ps5.Count(),
CountEmotions = countEmotions,
}).Take(quantity + 1).ToList();
if (result.Count > quantity)
{
result[result.Count - 2].MoreComment = true;
result.RemoveAt(result.Count - 1);
}
CommentView = CommentView.Union(result).ToList();
foreach (var item in CommentView)
{
var responeImage = AmazonS3Uploader.GetUrl(item.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
item.Avatar = responeImage;
}
if (!string.IsNullOrEmpty(item.Images))
{
var data = item.Images.Split(',');
item.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
item.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.Audios))
{
var data = item.Audios.Split(',');
item.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
item.ListAudios.Add(respone);
}
}
}
}
return(CommentView);
}
public CommentViewModel GetCommentByID(long id, long LoginUser)
{
var CommentView = new CommentViewModel();
var result = (from c in context.Comments
join p4 in context.Users on c.UserId equals p4.ID into ps4
from p4 in ps4.DefaultIfEmpty()
join p5 in context.Comments on new { a1 = c.ID, a2 = TypeComment.COMMENT } equals new { a1 = p5.TargetId, a2 = p5.TargetType.Value } into ps5
join p6 in context.Emotions on new { t1 = LoginUser, t2 = c.ID } equals new { t1 = p6.UserId.Value, t2 = p6.TargetId.Value } into ps6
from p6 in ps6.DefaultIfEmpty()
let countEmotions = (from E in context.Emotions where E.TargetId == c.ID select E).Count()
where id == c.ID
orderby c.CreatedTime descending
select new CommentViewModel
{
Id = c.ID,
Audios = c.Audios,
TargetId = c.TargetId,
CreatedTime = c.CreatedTime,
Images = c.Images,
Tags = c.Tags,
TagsUser = c.TagsUser,
Content = c.Content,
UserId = c.UserId,
Avatar = p4.Avatar,
NickName = p4.NickName,
CountReply = ps5.Count(),
CountEmotions = countEmotions,
StatusEmotion = p6 == null ? (byte)0 : p6.Status
}).FirstOrDefault();
CommentView = result;
var responeImage = AmazonS3Uploader.GetUrl(CommentView.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
CommentView.Avatar = responeImage;
}
if (!string.IsNullOrEmpty(CommentView.Images))
{
var data = CommentView.Images.Split(',');
CommentView.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
CommentView.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(CommentView.Audios))
{
var data = CommentView.Audios.Split(',');
CommentView.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
CommentView.ListAudios.Add(respone);
}
}
}
return(CommentView);
}
public List <MessageViewModel> LoadMessagesNotifi(long UserId)
{
var result = (from c in context.Messages
join p2 in context.Users on c.UserID equals p2.ID into ps2
from p2 in ps2.DefaultIfEmpty()
where (c.TargetUser == UserId) && c.Seen != true
orderby c.CreatedTime descending
select new { c, p2 })
.GroupBy(x => x.c.UserID).Select(r => new
{
c = r.FirstOrDefault().c,
p2 = r.FirstOrDefault().p2
}).Take(10).ToList();
var MessageView = new List <MessageViewModel>();
foreach (var item in result)
{
var Message = new MessageViewModel();
Message.Id = item.c.ID;
Message.Audios = item.c.Audios;
Message.Content = item.c.Content;
Message.Image = item.c.Image;
if (!string.IsNullOrEmpty(item.c.Image))
{
var data = item.c.Image.Split(',');
Message.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
Message.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.c.Audios))
{
var data = item.c.Audios.Split(',');
Message.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
Message.ListAudios.Add(respone);
}
}
}
Message.Other = item.c.Other;
Message.Seen = item.c.Seen;
Message.TargetUser = item.c.TargetUser;
Message.UserId = item.c.UserID;
Message.CreatedTime = item.c.CreatedTime;
var responeImage = AmazonS3Uploader.GetUrl(item.p2?.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Message.AvataTarget = responeImage;
}
Message.NickNameTarget = item.p2?.NickName;
MessageView.Add(Message);
}
return(MessageView);
}
public List <PostViewModel> LoadPostsHome(string date, long UserId)
{
DateTime createDate = DateTime.UtcNow;
if (!string.IsNullOrEmpty(date))
{
createDate = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc);
createDate = createDate.AddMilliseconds(double.Parse(date)).ToLocalTime();
}
var result = (from c in context.Posts
join p1 in context.Relationships on new { t1 = UserId, t2 = c.TargetId.Value } equals new { t1 = p1.UserSentID, t2 = p1.UserReceiveID } into ps1
from p1 in ps1.DefaultIfEmpty()
join p2 in context.Relationships on new { t1 = UserId, t2 = c.TargetId.Value } equals new { t1 = p2.UserReceiveID, t2 = p2.UserSentID } into ps2
from p2 in ps2.DefaultIfEmpty()
join p3 in context.GroupMembers on new { t1 = UserId, t2 = c.TargetId.Value } equals new { t1 = p3.UserId, t2 = p3.GroupID } into ps3
from p3 in ps3.DefaultIfEmpty()
join p4 in context.Users on c.UserId equals p4.ID into ps4
from p4 in ps4.DefaultIfEmpty()
join p5 in context.Emotions on new { t1 = UserId, t2 = c.ID } equals new { t1 = p5.UserId.Value, t2 = p5.TargetId.Value } into ps5
from p5 in ps5.DefaultIfEmpty()
join p6 in context.Groups on new { t1 = c.TargetType.Value, t2 = c.TargetId.Value } equals new { t1 = TypePost.GROUP, t2 = p6.ID } into ps6
from p6 in ps6.DefaultIfEmpty()
join p7 in context.Users on new { t1 = c.TargetType.Value, t2 = c.TargetId.Value } equals new { t1 = TypePost.USER, t2 = p7.ID } into ps7
from p7 in ps7.DefaultIfEmpty()
let countEmotions = (from E in context.Emotions where E.TargetId == c.ID select E).Count()
let countComments = (from C in context.Comments where C.TargetId == c.ID select C).Count()
where c.CreatedTime < createDate && (((c.TargetId == p1.UserReceiveID || c.TargetId == UserId || c.TargetId == p2.UserSentID) && c.TargetType == TypePost.USER) || (c.TargetId == p3.GroupID && c.TargetType == TypePost.GROUP) || (c.UserId == c.TargetId && c.UserId == 21 && c.TargetType == TypePost.USER))
orderby c.CreatedTime descending
select new{ c, p1, p2, p3, p4, countEmotions, p5, countComments, p6, p7 }).Take(10).ToList();
var PostView = new List <PostViewModel>();
foreach (var item in result)
{
if (createDate == item.c.CreatedTime)
{
continue;
}
var Post = new PostViewModel();
Post.Id = item.c.ID;
Post.Audios = item.c.Audios;
Post.Content = item.c.Content;
Post.Images = item.c.Images;
if (!string.IsNullOrEmpty(item.c.Images))
{
var data = item.c.Images.Split(',');
Post.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
Post.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.c.Videos))
{
var data = item.c.Videos.Split(',');
Post.ListVideos = new List <string>();
foreach (string video in data)
{
var respone = AmazonS3Uploader.GetUrl(video);
if (!string.IsNullOrEmpty(respone))
{
Post.ListVideos.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.c.Audios))
{
var data = item.c.Audios.Split(',');
Post.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
Post.ListAudios.Add(respone);
}
}
}
Post.Tags = item.c.Tags;
Post.TagsUser = item.c.TagsUser;
Post.TargetId = item.c.TargetId;
Post.TargetType = item.c.TargetType;
Post.Type = item.c.Type;
Post.CreatedTime = item.c.CreatedTime;
Post.UpdateTime = item.c.UpdateTime;
Post.UserId = item.c.UserId;
var responeImage = AmazonS3Uploader.GetUrl(item.p4?.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Post.Avatar = responeImage;
}
responeImage = AmazonS3Uploader.GetUrl(item.p6 == null ? item.p7.Avatar : item.p6.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Post.TargetAvatar = responeImage;
}
Post.NickName = item.p4?.NickName;
Post.TargetNickName = item.p6 == null ? item.p7.NickName : item.p6.GroupName;
Post.TargetUrl = item.p6 == null ? "profile" : "group";
Post.CountEmotions = item.countEmotions;
Post.CountComments = item.countComments;
Post.StatusEmotion = item.p5 == null ? (byte)0: item.p5.Status;
Post.ShowTarget = Post.UserId != Post.TargetId || item.c.TargetType != TypePost.USER ? "" : "hidden";
PostView.Add(Post);
}
return(PostView);
}
public PostViewModel LoadPostById(long?id, long?CommentId)
{
var Post = new PostViewModel();
if (id == null && CommentId != null)
{
var checkLoad = false;
var index = 0;
while (!checkLoad && index < 100)
{
var comment = context.Comments.Find(CommentId.Value);
if (comment.TargetType == TypeComment.COMMENT)
{
CommentId = comment.TargetId;
}
else
{
checkLoad = true;
id = comment.TargetId;
}
index++;
}
}
if (id != null)
{
var result = (from c in context.Posts
join p4 in context.Users on c.UserId equals p4.ID into ps4
from p4 in ps4.DefaultIfEmpty()
join p6 in context.Groups on new { t1 = c.TargetType.Value, t2 = c.TargetId.Value } equals new { t1 = TypePost.GROUP, t2 = p6.ID } into ps6
from p6 in ps6.DefaultIfEmpty()
join p7 in context.Users on new { t1 = c.TargetType.Value, t2 = c.TargetId.Value } equals new { t1 = TypePost.USER, t2 = p7.ID } into ps7
from p7 in ps7.DefaultIfEmpty()
let countEmotions = (from E in context.Emotions where E.TargetId == c.ID select E).Count()
let countComments = (from C in context.Comments where C.TargetId == c.ID select C).Count()
where c.ID == id.Value
select new{ c, p4, countEmotions, countComments, p6, p7 }).FirstOrDefault();
Post.Id = result.c.ID;
Post.Audios = result.c.Audios;
Post.Content = result.c.Content;
Post.Images = result.c.Images;
if (!string.IsNullOrEmpty(result.c.Images))
{
var data = result.c.Images.Split(',');
Post.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
Post.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(result.c.Videos))
{
var data = result.c.Videos.Split(',');
Post.ListVideos = new List <string>();
foreach (string video in data)
{
var respone = AmazonS3Uploader.GetUrl(video);
if (!string.IsNullOrEmpty(respone))
{
Post.ListVideos.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(result.c.Audios))
{
var data = result.c.Audios.Split(',');
Post.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
Post.ListAudios.Add(respone);
}
}
}
Post.Tags = result.c.Tags;
Post.TagsUser = result.c.TagsUser;
Post.TargetId = result.c.TargetId;
Post.TargetType = result.c.TargetType;
Post.Type = result.c.Type;
Post.CreatedTime = result.c.CreatedTime;
Post.UpdateTime = result.c.UpdateTime;
Post.UserId = result.c.UserId;
var responeImage = AmazonS3Uploader.GetUrl(result.p4?.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Post.Avatar = responeImage;
}
responeImage = AmazonS3Uploader.GetUrl(result.p6 == null ? result.p7.Avatar : result.p6.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Post.TargetAvatar = responeImage;
}
Post.NickName = result.p4?.NickName;
Post.TargetNickName = result.p6 == null ? result.p7.NickName : result.p6.GroupName;
Post.TargetUrl = result.p6 == null ? "profile" : "group";
Post.CountEmotions = result.countEmotions;
Post.CountComments = result.countComments;
Post.ShowTarget = Post.UserId != Post.TargetId && result.c.TargetType == TypePost.USER ? "" : "hidden";
}
return(Post);
}
public List <PostViewModel> LoadPostsGroup(string date, long UserId, long UserLogin)
{
DateTime createDate = DateTime.UtcNow;
if (!string.IsNullOrEmpty(date))
{
createDate = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc);
createDate = createDate.AddMilliseconds(double.Parse(date)).ToLocalTime();
}
var result = (from c in context.Posts
join p4 in context.Users on c.UserId equals p4.ID into ps4
from p4 in ps4.DefaultIfEmpty()
join p5 in context.Emotions on new { t1 = UserLogin, t2 = c.ID } equals new { t1 = p5.UserId.Value, t2 = p5.TargetId.Value } into ps5
from p5 in ps5.DefaultIfEmpty()
let countEmotions = (from E in context.Emotions where E.TargetId == c.ID select E).Count()
let countComments = (from C in context.Comments where C.TargetId == c.ID select C).Count()
where c.CreatedTime < createDate && (c.TargetId != null && c.TargetId == UserId) && c.TargetType == TypePost.GROUP
orderby c.CreatedTime descending
select new{ c, p4, countEmotions, p5, countComments }).Take(10).ToList();
var PostView = new List <PostViewModel>();
foreach (var item in result)
{
if (createDate == item.c.CreatedTime)
{
continue;
}
var Post = new PostViewModel();
Post.Id = item.c.ID;
Post.Audios = item.c.Audios;
Post.Content = item.c.Content;
Post.Images = item.c.Images;
if (!string.IsNullOrEmpty(item.c.Images))
{
var data = item.c.Images.Split(',');
Post.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
Post.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.c.Videos))
{
var data = item.c.Videos.Split(',');
Post.ListVideos = new List <string>();
foreach (string video in data)
{
var respone = AmazonS3Uploader.GetUrl(video);
if (!string.IsNullOrEmpty(respone))
{
Post.ListVideos.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.c.Audios))
{
var data = item.c.Audios.Split(',');
Post.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
Post.ListAudios.Add(respone);
}
}
}
Post.Tags = item.c.Tags;
Post.TagsUser = item.c.TagsUser;
Post.TargetId = item.c.TargetId;
Post.TargetType = item.c.TargetType;
Post.Type = item.c.Type;
Post.CreatedTime = item.c.CreatedTime;
Post.UpdateTime = item.c.UpdateTime;
Post.UserId = item.c.UserId;
Post.NickName = item.p4?.NickName;
var responeImage = AmazonS3Uploader.GetUrl(item.p4?.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Post.Avatar = responeImage;
}
Post.CountEmotions = item.countEmotions;
Post.CountComments = item.countComments;
Post.StatusEmotion = item.p5 == null ? (byte)0: item.p5.Status;
Post.ShowTarget = "hidden";
PostView.Add(Post);
}
return(PostView);
}
public List <MessageViewModel> LoadMessages(string date, long UserId, long TargetId)
{
DateTime createDate = DateTime.UtcNow;
if (!string.IsNullOrEmpty(date))
{
createDate = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc);
createDate = createDate.AddMilliseconds(double.Parse(date)).ToLocalTime();
}
var result = (from c in context.Messages
join p1 in context.Users on UserId equals p1.ID into ps1
from p1 in ps1.DefaultIfEmpty()
join p2 in context.Users on TargetId equals p2.ID into ps2
from p2 in ps2.DefaultIfEmpty()
where c.CreatedTime < createDate && ((c.TargetUser == TargetId && c.UserID == UserId) || (c.TargetUser == UserId && c.UserID == TargetId))
orderby c.CreatedTime descending
select new { c, p1, p2 }).Take(10).ToList();
var MessageView = new List <MessageViewModel>();
foreach (var item in result)
{
var Message = new MessageViewModel();
Message.Id = item.c.ID;
Message.Audios = item.c.Audios;
Message.Content = item.c.Content;
Message.Image = item.c.Image;
if (!string.IsNullOrEmpty(item.c.Image))
{
var data = item.c.Image.Split(',');
Message.ListImages = new List <string>();
foreach (string image in data)
{
var respone = AmazonS3Uploader.GetUrl(image);
if (!string.IsNullOrEmpty(respone))
{
Message.ListImages.Add(respone);
}
}
}
if (!string.IsNullOrEmpty(item.c.Audios))
{
var data = item.c.Audios.Split(',');
Message.ListAudios = new List <string>();
foreach (string audio in data)
{
var respone = AmazonS3Uploader.GetUrl(audio);
if (!string.IsNullOrEmpty(respone))
{
Message.ListAudios.Add(respone);
}
}
}
Message.Other = item.c.Other;
Message.Seen = item.c.Seen;
Message.TargetUser = item.c.TargetUser;
Message.UserId = item.c.UserID;
Message.CreatedTime = item.c.CreatedTime;
var responeImage = AmazonS3Uploader.GetUrl(item.p2?.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Message.AvataTarget = responeImage;
}
responeImage = AmazonS3Uploader.GetUrl(item.p1?.Avatar, 0);
if (!string.IsNullOrEmpty(responeImage))
{
Message.AvataUser = responeImage;
}
Message.NickNameTarget = item.p2?.NickName;
Message.NickNameUser = item.p1?.NickName;
MessageView.Add(Message);
}
return(MessageView);
}
