/// <summary> /// Get All User in WS_USER /// </summary> /// <returns>list ws_user</returns> public List <UserBasicInfoDTO> GetAllUser() { var listUser = new List <UserBasicInfoDTO>(); try { List <int> userIdList; using (var db = new Ws_DataContext()) { userIdList = db.Ws_User.Select(x => x.UserID).ToList(); } using (var db = new UserDAL()) { foreach (int userId in userIdList) { UserBasicInfoDTO userBasic = db.GetFullInforOfUserAsBasicUser(userId); listUser.Add(userBasic); } } } catch (Exception) { //throw; } return(listUser); }
/// <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 OrganizationBasicInfo GetFullOrganizationBasicInformation(int orgId) { OrganizationBasicInfo organizationBasic = new OrganizationBasicInfo(); try { Organization org = GetOrganizationById(orgId); organizationBasic.OrganizationId = orgId; if (org != null) { organizationBasic.OrganizationName = org.OrganizationName; organizationBasic.Introduction = org.Introduction; organizationBasic.LogoUrl = org.LogoUrl; organizationBasic.Phone = org.Phone; organizationBasic.Email = org.Email; organizationBasic.Address = org.Address; organizationBasic.IsActive = org.IsActive; organizationBasic.IsVerify = org.IsVerify; organizationBasic.CreatedDate = org.CreatedDate.ToString("H:mm:ss dd/MM/yy"); organizationBasic.Point = org.Point; using (var db = new Ws_DataContext()) { organizationBasic.CreatorName = db.Organizations.Where(x => x.OrganizationId == orgId).SingleOrDefault().Ws_User.UserName; organizationBasic.NumberOfEvent = db.Events.Where(x => x.CreatorID == organizationBasic.OrganizationId).Count(); } WsRanking ranking = new WsRanking(); RankingDTO rank = ranking.RankingWithPoint(org.Point); if (rank.CurrentRank == 0) { organizationBasic.CurrentRank = "Mới"; } else if (rank.CurrentRank == 200) { organizationBasic.CurrentRank = "Đồng"; } else if (rank.CurrentRank == 500) { organizationBasic.CurrentRank = "Bạc"; } else if (rank.CurrentRank == 2000) { organizationBasic.CurrentRank = "Vàng"; } else if (rank.CurrentRank == 5000) { organizationBasic.CurrentRank = "Bạch Kim"; } else if (rank.CurrentRank == 10000) { organizationBasic.CurrentRank = "Kim Cương"; } //get creator using (var db = new UserDAL()) { organizationBasic.Creator = db.GetFullInforOfUserAsBasicUser(orgId); } } } catch (Exception) { //throw; } return(organizationBasic); }