public Organization AddNewOrganization(CreateOrganization organizationBasic, string UserName)
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID;
}
var newOrg = CreatEmptyOrganization();
newOrg.OrganizationId = CurrenUser;
newOrg.OrganizationName = organizationBasic.OrganizationName;
newOrg.EOrganizationName = ConvertToUnSign.Convert(organizationBasic.OrganizationName);
newOrg.Introduction = organizationBasic.Introduction;
newOrg.LogoUrl = organizationBasic.LogoUrl;
newOrg.Phone = organizationBasic.Phone;
newOrg.Email = organizationBasic.Email;
newOrg.Address = organizationBasic.Address;
newOrg.IsVerify = false;
newOrg.IsActive = true;
newOrg.Point = 0;
newOrg.CreatedDate = DateTime.Now;
using (var db = new Ws_DataContext())
{
db.Organizations.Add(newOrg);
db.SaveChanges();
return(GetOrganizationById(newOrg.OrganizationId));
}
}
public Organization EditOrganization(CreateOrganization organizationBasic, string UserName)
{
try
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID;
}
using (var db = new Ws_DataContext())
{
var currentOrg = db.Organizations.Find(CurrenUser);
currentOrg.OrganizationName = organizationBasic.OrganizationName;
currentOrg.OrganizationName = organizationBasic.OrganizationName;
currentOrg.Introduction = organizationBasic.Introduction;
if (organizationBasic.LogoUrl != "" && organizationBasic.LogoUrl != null)
{
currentOrg.LogoUrl = organizationBasic.LogoUrl;
}
currentOrg.Phone = organizationBasic.Phone;
currentOrg.Address = organizationBasic.Address;
db.SaveChanges();
return(GetOrganizationById(currentOrg.OrganizationId));
}
}
catch (Exception)
{
return(null);
//throw;
}
}
public Thread UpdateThread(CreateThreadInfo thread, string UserName)
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID;
}
using (var db = new Ws_DataContext())
{
//Get current Thread To Edit
var currentThread = db.Threads.Where(x => x.ThreadId == thread.ThreadId).SingleOrDefault();
currentThread.Title = thread.Title;
currentThread.Content = thread.Content;
currentThread.ShortDescription = thread.ShortDescription;
currentThread.UpdatedDate = DateTime.Now;
if (CurrenUser != currentThread.UserId)
{
return(null);
}
else
{
db.Threads.AddOrUpdate(currentThread);
db.SaveChanges();
}
return(currentThread);
}
}
public bool ChangelikeStateForComment(int commentId, string UserName)
{
try
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID;
}
using (var db = new Ws_DataContext())
{
//Check current like status.
LikeCommentThread current = (
from p in db.LikeCommentThreads
where p.CommentId == commentId && p.UserId == CurrenUser
select p
).SingleOrDefault();
if (current != null)
{
current.Status = !current.Status;
db.SaveChanges();
}
else
{
db.LikeCommentThreads.Add(new LikeCommentThread()
{
CommentId = commentId, UserId = CurrenUser, Status = true
});
db.SaveChanges();
}
return(true);
}
}
catch (Exception) { return(false); }
}
public List <BasicCommentThread> GetSubCommentInThreadById(int CommentId, string currentUserName)
{
int CurrenUser = 0;
if (currentUserName != "")
{
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(currentUserName).UserID;
}
}
List <BasicCommentThread> list = new List <BasicCommentThread>();
using (var db = new Ws_DataContext())
{
try
{
var listComment = db.SubCommentThread
.Where(x => x.Status == true && x.CommentThreadId == CommentId)
.Select(x => new { x.UserId, x.Ws_User.UserName, x.Ws_User.User_Information.ProfileImage, x.SubCommentThreadId, x.Content, x.CommentDate })
.OrderByDescending(x => x.CommentDate).ToList();
foreach (var item in listComment)
{
BasicCommentThread bs = new BasicCommentThread();
bs.UserCommentedId = item.UserId;
bs.UserCommentedName = item.UserName;
bs.UserImageProfile = item.ProfileImage;
bs.CommentId = item.SubCommentThreadId;
bs.Content = item.Content;
if (CurrenUser == item.UserId)
{
bs.isDeleted = true;
}
else
{
bs.isDeleted = false;
}
if (DateTime.Now.Subtract(item.CommentDate).TotalHours <= 24 && DateTime.Now.Subtract(item.CommentDate).TotalHours >= 1)
{
bs.CommentedTime = Math.Round(DateTime.Now.Subtract(item.CommentDate).TotalHours, 0) + " Tiếng cách đây";
}
else if (DateTime.Now.Subtract(item.CommentDate).TotalHours > 24)
{
bs.CommentedTime = item.CommentDate.ToString("H:mm:ss dd/MM/yy");
}
else if (DateTime.Now.Subtract(item.CommentDate).Minutes == 0)
{
bs.CommentedTime = "Vừa xong";
}
else
{
bs.CommentedTime = DateTime.Now.Subtract(item.CommentDate).Minutes + " Phút cách đây";
}
list.Add(bs);
}
}
catch (Exception) { return(null); }
}
return(list);
}
public int CountUnreadConversation(string name)
{
int CurrentUser = 0;
int NumberOfUnreadMessage = 0;
using (var db = new UserDAL())
{
CurrentUser = db.GetUserByUserNameOrEmail(name).UserID;
}
using (var db = new Ws_DataContext())
{
var list = (from p in db.Conversation
where p.CreatorId == CurrentUser || p.ReceiverId == CurrentUser
select new { p.CreatorId, p.ReceiverId, p.IsCreatorRead, p.IsReceiverRead }).ToList();
foreach (var item in list)
{
if (CurrentUser == item.CreatorId && item.IsCreatorRead == false)
{
NumberOfUnreadMessage++;
}
if (CurrentUser == item.ReceiverId && item.IsReceiverRead == false)
{
NumberOfUnreadMessage++;
}
}
}
return(NumberOfUnreadMessage);
}
public Event AddNewEvent(CreateEventInfo eventInfo, string UserName)
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID;
}
var newEvent = CreateEmptyEvent();
newEvent.CreatorID = GetOrganizationById(CurrenUser).OrganizationId;
newEvent.EventType = eventInfo.EventType;
newEvent.EventName = eventInfo.EventName;
newEvent.EEventName = ConvertToUnSign.Convert(newEvent.EventName);
if (eventInfo.StartDate != "")
{
newEvent.Start_Date = DateTime.Parse(eventInfo.StartDate);
}
if (eventInfo.FinishDate != "")
{
newEvent.Finish_Date = DateTime.Parse(eventInfo.FinishDate);
}
newEvent.ShortDescription = eventInfo.ShortDescription;
newEvent.Location = eventInfo.Location;
newEvent.ExpectedMoney = eventInfo.ExpectedMoney;
newEvent.Description = eventInfo.Content;
newEvent.Contact = eventInfo.Contact;
newEvent.VideoUrl = eventInfo.VideoUrl;
using (var db = new Ws_DataContext())
{
db.Events.Add(newEvent);
db.SaveChanges();
return(GetEventById(newEvent.EventID));
}
}
public List <MessageBasicInfoDTO> GetAllMessageByConservationId(int id, string userName)
{
List <MessageBasicInfoDTO> messageList = new List <MessageBasicInfoDTO>();
int UserId = 0;
using (var db = new UserDAL())
{
UserId = db.GetUserByUserNameOrEmail(userName).UserID;
}
using (var db = new Ws_DataContext())
{
var list = db.Message.Where(x => x.ConservationId == id).ToList();
foreach (var item in list)
{
MessageBasicInfoDTO current = new MessageBasicInfoDTO();
//Set time
if (DateTime.Now.Subtract(item.CreatedDate).TotalHours <= 24 && DateTime.Now.Subtract(item.CreatedDate).TotalHours >= 1)
{
current.CreatedDate = Math.Round(DateTime.Now.Subtract(item.CreatedDate).TotalHours, 0) + " Tiếng cách đây";
}
else if (DateTime.Now.Subtract(item.CreatedDate).TotalHours > 24)
{
current.CreatedDate = item.CreatedDate.ToString("H:mm:ss dd/MM/yy");
}
else if (DateTime.Now.Subtract(item.CreatedDate).Minutes == 0)
{
current.CreatedDate = "Vừa xong";
}
else
{
current.CreatedDate = DateTime.Now.Subtract(item.CreatedDate).Minutes + " Phút cách đây";
}
//Set other atributes
current.CreatorImage = item.User.User_Information.ProfileImage;
current.CreatorName = item.User.UserName;
current.Content = item.Content;
messageList.Add(current);
}
//Update Is Read for message.
var currentConversation = db.Conversation.Where(x => x.ConservationId == id).SingleOrDefault();
if (UserId == currentConversation.CreatorId)
{
currentConversation.IsCreatorRead = true;
}
if (UserId == currentConversation.ReceiverId)
{
currentConversation.IsReceiverRead = true;
}
db.Conversation.AddOrUpdate(currentConversation);
db.SaveChanges();
}
return(messageList);
}
public Thread AddNewThread(CreateThreadInfo thread, string UserName)
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID;
}
var newThread = CreateEmptyThread();
newThread.UserId = CurrenUser;
newThread.Title = thread.Title;
newThread.Etitle = ConvertToUnSign.Convert(thread.Title);
newThread.Content = thread.Content;
newThread.ShortDescription = thread.ShortDescription;
using (var db = new Ws_DataContext())
{
db.Threads.Add(newThread);
db.SaveChanges();
return(GetThreadById(newThread.ThreadId));
}
}
public bool CheckUserIsLikedOrNot(int ThreadId, string UserName)
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID;
}
using (var db = new Ws_DataContext())
{
var isLike = (from p in db.LikeThreads
where p.ThreadId == ThreadId && p.UserId == CurrenUser && p.Status == true
select p).SingleOrDefault();
if (isLike != null)
{
return(true);
}
else
{
return(false);
}
}
}
public List <ConservationBasicInfoDTO> GetAllConservationByUserIdAndStatus(string name, bool isRead)
{
int CurrenUser = 0;
using (var db = new UserDAL())
{
CurrenUser = db.GetUserByUserNameOrEmail(name).UserID;
}
List <ConservationBasicInfoDTO> ConservationList = new List <ConservationBasicInfoDTO>();
using (var db = new Ws_DataContext())
{
var list = (from p in db.Conversation
where (p.CreatorId == CurrenUser || p.ReceiverId == CurrenUser)
select p).OrderByDescending(x => x.UpdatedTime).ToList();
foreach (var item in list)
{
if (CurrenUser == item.CreatorId && item.IsCreatorRead == isRead)
{
ConservationBasicInfoDTO current = new ConservationBasicInfoDTO();
//Set Image
if (item.ReceiverId == CurrenUser)
{
current.AvatarUrl = item.Creator.User_Information.ProfileImage;
current.CreatorName = item.Creator.UserName;
}
else
{
current.AvatarUrl = item.Receiver.User_Information.ProfileImage;
current.CreatorName = item.Receiver.UserName;
}
//Set Time
if (DateTime.Now.Subtract(item.UpdatedTime).TotalHours <= 24 && DateTime.Now.Subtract(item.UpdatedTime).TotalHours >= 1)
{
current.CreatedDate = Math.Round(DateTime.Now.Subtract(item.CreatedDate).TotalHours, 0) + " Tiếng cách đây";
}
else if (DateTime.Now.Subtract(item.UpdatedTime).TotalHours > 24)
{
current.CreatedDate = item.UpdatedTime.ToString("H:mm:ss dd/MM/yy");
}
else if (DateTime.Now.Subtract(item.CreatedDate).Minutes == 0)
{
current.CreatedDate = "Vừa xong";
}
else
{
current.CreatedDate = DateTime.Now.Subtract(item.UpdatedTime).Minutes + " Phút cách đây";
}
//Set other attributes
current.Title = item.Title;
current.ConservationId = item.ConservationId;
ConservationList.Add(current);
}
if (CurrenUser == item.ReceiverId && item.IsReceiverRead == isRead)
{
ConservationBasicInfoDTO current = new ConservationBasicInfoDTO();
//Set Image
if (item.ReceiverId == CurrenUser)
{
current.AvatarUrl = item.Creator.User_Information.ProfileImage;
current.CreatorName = item.Creator.UserName;
}
else
{
current.AvatarUrl = item.Receiver.User_Information.ProfileImage;
current.CreatorName = item.Receiver.UserName;
}
//Set Time
if (DateTime.Now.Subtract(item.UpdatedTime).TotalHours <= 24 && DateTime.Now.Subtract(item.UpdatedTime).TotalHours >= 1)
{
current.CreatedDate = Math.Round(DateTime.Now.Subtract(item.CreatedDate).TotalHours, 0) + " Tiếng cách đây";
}
else if (DateTime.Now.Subtract(item.UpdatedTime).TotalHours > 24)
{
current.CreatedDate = item.UpdatedTime.ToString("H:mm:ss dd/MM/yy");
}
else if (DateTime.Now.Subtract(item.CreatedDate).Minutes == 0)
{
current.CreatedDate = "Vừa xong";
}
else
{
current.CreatedDate = DateTime.Now.Subtract(item.UpdatedTime).Minutes + " Phút cách đây";
}
//Set other attributes
current.Title = item.Title;
current.ConservationId = item.ConservationId;
ConservationList.Add(current);
}
}
return(ConservationList);
}
}