/// <summary>
/// Get user using user id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Ws_User GetUserById(int id)
{
Ws_User currentUser = new Ws_User();
try
{
using (var db = new Ws_DataContext())
{
currentUser = db.Ws_User.FirstOrDefault(x => x.UserID == id);
}
}
catch (Exception)
{
//throw;
}
return(currentUser);
}
public int CountDonatedUserOfEvent(int eventId)
{
var numUser = 0;
try
{
using (var db = new Ws_DataContext())
{
numUser = db.Donations.Where(x => x.EventId == eventId).Select(x => x.UserId).Distinct().Count();
}
}
catch (Exception)
{
//throw;
}
return(numUser);
}
/// <summary>
/// get user infomation using user id
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public User_Information GetUserInformation(int userId)
{
User_Information currentUserInfo = new User_Information();
try
{
using (var db = new Ws_DataContext())
{
currentUserInfo = db.User_Information.FirstOrDefault(x => x.UserID == userId);
}
}
catch (Exception)
{
//throw;
}
return(currentUserInfo);
}
public EventType GetEventTypeById(int id)
{
EventType type = new EventType();
try
{
using (var db = new Ws_DataContext())
{
type = db.EventTypes.FirstOrDefault(x => x.EventTypeID == id);
}
}
catch (Exception)
{
//throw;
}
return(type);
}
public decimal GetTotalRaisedMoneyOfEvent(int eventId)
{
decimal raisedMoney = 0;
try
{
using (var db = new Ws_DataContext())
{
raisedMoney = db.Donations.Where(x => x.EventId == eventId).Select(x => x.DonatedMoney).Sum();
}
}
catch (Exception)
{
raisedMoney = 0;
}
return(raisedMoney);
}
/// <summary>
/// Count number of event that using *similarly* event Type
/// </summary>
/// <param name="eventTypeId"></param>
/// <returns></returns>
public int CountNumberEventRelateAnEventType(int eventTypeId)
{
int numberEventRelated = 0;
try
{
using (var db = new Ws_DataContext())
{
numberEventRelated = db.Events.Where(x => x.EventType == eventTypeId).Select(x => x.EventID).Count();
}
}
catch (Exception)
{
//throw;
}
return(numberEventRelated);
}
public List <EventTypeDTO> GetEventsType()
{
List <EventTypeDTO> eventType = new List <EventTypeDTO>();
using (var db = new Ws_DataContext())
{
var list = (from p in db.EventTypes
select new { p.EventTypeID, p.EventTypeName }
).ToList();
foreach (var item in list)
{
EventTypeDTO type = new EventTypeDTO();
type.EventTypeID = item.EventTypeID;
type.EventTypeName = item.EventTypeName;
eventType.Add(type);
}
}
return(eventType);
}
/// <summary>
/// Get total money which user has donated.
/// </summary>
/// <param name="userId"></param>
/// <returns>decimal</returns>
public decimal GetTotalMoneyDonatedInByUsingUserId(int userId)
{
decimal totalMoney = 0;
try
{
using (var db = new Ws_DataContext())
{
totalMoney = db.Donations.Where(x => x.UserId == userId).Select(x => x.DonatedMoney).Sum();
}
}
catch (Exception)
{
return(0);
//throw;
}
return(totalMoney);
}
public bool DeleteSubComment(int SubCommentId, string UserName)
{
using (var db = new Ws_DataContext())
{
var currentComment = (from p in db.SubCommentThread
where p.SubCommentThreadId == SubCommentId && p.Ws_User.UserName.Equals(UserName)
select p).FirstOrDefault();
if (currentComment != null)
{
db.SubCommentThread.Remove(currentComment);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Get all image of an Thread
/// </summary>
/// <param name="threadId"></param>
/// <returns></returns>
public List <String> GetAllImageThreadById(int threadId)
{
List <ThreadAlbumImage> threadImagesList;
List <String> threadImagesUrlList = new List <string>();
using (var db = new Ws_DataContext())
{
var imageList = db.ThreadAlbum.Where(x => x.ThreadId == threadId);
threadImagesList = imageList.ToList();
}
foreach (ThreadAlbumImage threadImage in threadImagesList)
{
String url = threadImage.ImageUrl;
threadImagesUrlList.Add(url);
}
return(threadImagesUrlList);
}
public int CountNewReportedTime(int isReportedId, string reportType)
{
var times = 0;
try
{
using (var db = new Ws_DataContext())
{
times = db.Reports.Count(x => x.ReportTo == isReportedId && x.Type == reportType && x.Status == true);
}
}
catch (Exception)
{
return(0);
//throw;
}
return(times);
}
public bool ChangelikeState(int ThreadId, 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.
LikeThreads current = (
from p in db.LikeThreads
where p.ThreadId == ThreadId && p.UserId == CurrenUser
select p
).SingleOrDefault();
if (current != null)
{
if (current.Status == true)
{
current.Status = false;
}
else
{
current.Status = true;
}
db.SaveChanges();
}
else
{
db.LikeThreads.Add(new LikeThreads()
{
ThreadId = ThreadId, UserId = CurrenUser, Status = true
});
db.SaveChanges();
}
return(true);
}
}
catch (Exception) { return(false); }
}
public List <BasicCommentThread> GetAllSubCommentInThread()
{
List <BasicCommentThread> list = new List <BasicCommentThread>();
using (var db = new Ws_DataContext())
{
try
{
var listComment = db.SubCommentThread
.Where(x => x.Status == true)
.Select(x => new { x.UserId, x.Ws_User.UserName, x.Ws_User.User_Information.ProfileImage, x.CommentThreadId, 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.CommentThreadId;
bs.Content = item.Content;
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).Hours > 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);
}
/// <summary>
/// Get Number event which user donate in
/// </summary>
/// <param name="userId"></param>
/// <returns>int</returns>
public int GetNumberEventDonatedInByUsingUserId(int userId)
{
int numberEvent = 0;
try
{
using (var db = new Ws_DataContext())
{
numberEvent = db.Donations.Where(x => x.UserId == userId).Select(x => x.EventId).Distinct().Count();
}
}
catch (Exception)
{
return(0);
//throw;
}
return(numberEvent);
}
public bool DeleteComment(int CommentId, string UserName)
{
using (var db = new Ws_DataContext())
{
var currentComment = (from p in db.CommentThreads
where p.CommentThreadId == CommentId && p.Ws_User.UserName.Equals(UserName)
select p).FirstOrDefault();
if (currentComment != null)
{
var subCommentInComment = (from p in db.SubCommentThread
where p.CommentThreadId == currentComment.CommentThreadId
select p).ToList();
if (subCommentInComment != null)
{
foreach (var item in subCommentInComment)
{
//Delete All SubComment First
db.SubCommentThread.Remove(item);
}
}
var LikeInComment = (from p in db.LikeCommentThreads
where p.CommentId == CommentId
select p).ToList();
if (LikeInComment != null)
{
foreach (var item in LikeInComment)
{
//Delete All SubComment First
db.LikeCommentThreads.Remove(item);
}
}
db.CommentThreads.Remove(currentComment);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public Organization CreatEmptyOrganization()
{
using (var db = new Ws_DataContext())
{
var org = db.Organizations.Create();
org.OrganizationName = "";
org.EOrganizationName = "";
org.Introduction = "";
org.LogoUrl = "";
org.Phone = "";
org.Email = "";
org.Address = "";
org.IsActive = false;
org.IsVerify = false;
org.Point = 0;
return(org);
}
}
public List <int> GetAllCommentIdAndSubCommentId()
{
List <int> list = new List <int>();
using (var db = new Ws_DataContext())
{
try
{
var listComment = db.SubCommentThread
.Where(x => x.Status == true)
.Select(x => new { x.CommentThreadId });
foreach (var item in listComment)
{
list.Add(item.CommentThreadId);
}
}
catch (Exception) { return(null); }
}
return(list);
}
public Event CreateEmptyEvent()
{
using (var db = new Ws_DataContext())
{
var eventInfo = db.Events.Create();
eventInfo.CreatorID = 0;
eventInfo.EventType = 0;
eventInfo.EventName = "";
eventInfo.Location = "";
eventInfo.Contact = "";
eventInfo.Description = "";
eventInfo.TotalPoint = 0;
eventInfo.VideoUrl = "";
eventInfo.Created_Date = DateTime.Now;
eventInfo.Updated_Date = DateTime.Now;
eventInfo.Status = true;
eventInfo.IsOpen = true;
return(eventInfo);
}
}
//Get user information (Profile page)
public UserBasicInfoDTO GetUserInfoUsingUserNameOrEmail(string userNameOrEmail)
{
UserBasicInfoDTO userBasic = new UserBasicInfoDTO();
try
{
Ws_User user;
using (var db = new Ws_DataContext())
{
user = db.Ws_User.FirstOrDefault(x => x.UserName == userNameOrEmail || x.Email == userNameOrEmail);
}
userBasic = GetFullInforOfUserAsBasicUser(user.UserID);
}
catch (Exception)
{
//throw;
}
return(userBasic);
}
/// <summary>
/// get all organization wait for accept
/// </summary>
/// <returns></returns>
public List <OrganizationBasicInfo> GetAllOrganizationWaitForAcception()
{
List <OrganizationBasicInfo> orgList = new List <OrganizationBasicInfo>();
try
{
List <int> orgIdList;
using (var db = new Ws_DataContext())
{
orgIdList = db.Organizations.Where(x => x.IsVerify == false).Select(x => x.OrganizationId).ToList();
}
orgList.AddRange(orgIdList.Select(GetFullOrganizationBasicInformation));
}
catch (Exception)
{
//throw;
}
return(orgList);
}
/// <summary>
/// Get top user who create most thread
/// </summary>
/// <param name="top"></param>
/// <returns></returns>
public List <UserBasicInfoDTO> GetTopNumberThreadCreator(int top)
{
List <UserBasicInfoDTO> topThreadCreator = new List <UserBasicInfoDTO>();
try
{
List <UserBasicInfoDTO> listUser = new List <UserBasicInfoDTO>();
// lay ra nhung userid co trong bang Thread
List <int> listUserIdInDonation;
using (var db = new Ws_DataContext())
{
var listUserId = db.Threads.Select(x => x.UserId).Distinct();
listUserIdInDonation = listUserId.ToList();
}
// Lay thong tin cua nhung user ma co id trong Donation
foreach (int userId in listUserIdInDonation)
{
UserBasicInfoDTO userBasic;
using (var db = new UserDAL())
{
userBasic = db.GetFullInforOfUserAsBasicUser(userId);
}
listUser.Add(userBasic);
}
// Lay top 10 user donate nhieu nhat
topThreadCreator = listUser.OrderByDescending(x => x.NumberOfPost).Take(top).ToList();
}
catch (Exception)
{
//throw;
}
return(topThreadCreator);
}
public List <ListDonatorDTO> GetDonatorInEvent(int eventId)
{
List <ListDonatorDTO> newList = new List <ListDonatorDTO>();
using (var db = new Ws_DataContext())
{
var donatorList = (from p in db.Donations
where p.EventId == eventId && p.IsPublic == true
select new { p.UserId, p.Ws_User.User_Information.FullName, p.DonatedDate, p.DonatedMoney, p.Content }).ToList();
foreach (var item in donatorList)
{
ListDonatorDTO getDonator = new ListDonatorDTO();
getDonator.UserId = item.UserId;
getDonator.FullName = item.FullName;
getDonator.DonatedMoney = item.DonatedMoney;
getDonator.DonatedDate = item.DonatedDate.ToString("H:mm:ss dd/MM/yy");
getDonator.Content = item.Content;
newList.Add(getDonator);
}
return(newList);
}
}
public EventTypeDropList GetEventType()
{
EventTypeDropList eventType = new EventTypeDropList();
using (var db = new Ws_DataContext())
{
var eventtypeList = db.EventTypes.ToList();
foreach (var eventtype in eventtypeList)
{
eventType.EventTypeList.Add(new SelectListItem
{
Text = eventtype.EventTypeName,
Value = eventtype.EventTypeID.ToString()
});
}
if (eventType.EventTypeList.Count > 0)
{
eventType.Selected = 1;
}
return(eventType);
}
}
public void AddNewEventTimeLine(CreateEventSchedule eventInfo, int eventId)
{
var newEventSchedule = CreateEmptyEventTimeLine();
newEventSchedule.EventId = eventId;
newEventSchedule.Content = eventInfo.Description;
//newEventSchedule.FromDate = DateTime.ParseExact(eventInfo.FromDate, "yyyy-MM-dd HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
//newEventSchedule.ToDate = DateTime.ParseExact(eventInfo.ToDate, "yyyy-MM-dd HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
if (eventInfo.FromDate != "")
{
newEventSchedule.FromDate = DateTime.Parse(eventInfo.FromDate);
}
if (eventInfo.ToDate != "")
{
newEventSchedule.ToDate = DateTime.Parse(eventInfo.ToDate);
}
using (var db = new Ws_DataContext())
{
db.ETimeLine.Add(newEventSchedule);
db.SaveChanges();
}
}
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);
}
}
}
/// <summary>
/// Get information of thread as a thread basic
/// </summary>
/// <param name="threadId"></param>
/// <returns></returns>
public ThreadBasicInfo GetFullThreadBasicInformation(int threadId)
{
ThreadBasicInfo currentThread = new ThreadBasicInfo();
try
{
Thread thread;
Ws_User user;
using (var db = new Ws_DataContext())
{
thread = db.Threads.FirstOrDefault(x => x.ThreadId == threadId);
}
using (var db = new Ws_DataContext())
{
user = db.Ws_User.FirstOrDefault(x => x.UserID == thread.UserId);
}
currentThread.ThreadID = thread.ThreadId;
currentThread.UserID = thread.UserId;
currentThread.Creator = user.UserName;
currentThread.ThreadName = thread.Title;
currentThread.ImageUrl = GetAllImageThreadById(thread.ThreadId);
currentThread.ShortDescription = thread.ShortDescription;
currentThread.Content = thread.Content;
currentThread.Likes = CountLikeInThread(thread.ThreadId);
currentThread.Comments = CountCommentInThread(thread.ThreadId);
currentThread.Status = thread.Status;
currentThread.CreatedDate = thread.CreatedDate.ToString("H:mm:ss dd/MM/yy");
}
catch (Exception)
{
//throw;
}
return(currentThread);
}
/// <summary>
/// Delete orgaization with id
/// </summary>
/// <param name="orgId"></param>
/// <returns></returns>
public bool DeleteOrganization(int orgId)
{
try
{
using (var db = new Ws_DataContext())
{
Organization organization = db.Organizations.FirstOrDefault(x => x.OrganizationId == orgId);
if (organization != null)
{
db.Organizations.Remove(organization);
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
//throw;
}
}
/// <summary>
/// Get top recently donted user
/// </summary>
/// <param name="top"></param>
/// <returns></returns>
public List <DonationDTO> GetTopRecentlyDonator(int top)
{
List <DonationDTO> recentDonation = new List <DonationDTO>();
try
{
List <int> donationIdList;
using (var db = new Ws_DataContext())
{
donationIdList = db.Donations.OrderByDescending(x => x.DonatedDate).Select(x => x.DonationId).Take(top).ToList();
}
foreach (var donationId in donationIdList)
{
DonationDTO donation = GetFullInformationOfDonation(donationId);
recentDonation.Add(donation);
}
}
catch (Exception)
{
//throw;
}
return(recentDonation);
}
/// <summary>
/// Get organization have been create less than 30 day
/// </summary>
/// <returns></returns>
public List <OrganizationBasicInfo> GetNewestCreatedOrgzation()
{
List <OrganizationBasicInfo> newestOrg = new List <OrganizationBasicInfo>();
try
{
List <int> orgIdList;
using (var db = new Ws_DataContext())
{
DateTime dateBeforeThrityDay = DateTime.UtcNow.AddDays(-30);
orgIdList = db.Organizations.OrderByDescending(x => x.CreatedDate).Where(x => x.CreatedDate >= dateBeforeThrityDay).Select(x => x.OrganizationId).ToList();
foreach (int orgId in orgIdList)
{
OrganizationBasicInfo organization = GetFullOrganizationBasicInformation(orgId);
newestOrg.Add(organization);
}
}
}
catch (Exception)
{
//throw;
}
return(newestOrg);
}
