/// <summary>
/// Function to change password
/// </summary>
/// <param></param>
/// <returns>bool</returns>
/// <devdoc>
/// Developer Name - Arvind Kumar
/// Date - 07/24/2015
/// </devdoc>
public static bool ChangePassword(EditPasswordVM model)
{
StringBuilder traceLog = null;
using (LinksMediaContext _dbContext = new LinksMediaContext())
{
EncryptDecrypt objEncrypt = null;
Credentials cred = null;
try
{
traceLog = new StringBuilder();
traceLog.AppendLine("Start: ChangePassword");
bool flag = false;
cred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
if (cred != null)
{
if (IsOldPasswordCorrect(model.OldPassword, cred.Id))
{
objEncrypt = new EncryptDecrypt();
tblCredentials objCredential = _dbContext.Credentials.Where(crd => crd.Id == cred.Id).FirstOrDefault();
model.NewPassword = objEncrypt.EncryptString(model.NewPassword);
if (objCredential != null)
{
objCredential.Password = model.NewPassword;
}
_dbContext.SaveChanges();
flag = true;
}
}
return(flag);
}
finally
{
if (objEncrypt != null)
{
objEncrypt.Dispose();
objEncrypt = null;
}
traceLog.AppendLine("End: ChangePassword --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Select UserPersonalTrainer
/// </summary>
/// <param name="usertrainerdetails"></param>
/// <returns></returns>
public static bool SelectUserPersonalTrainer(UserPersonalTrainerVM usertrainerdetails)
{
StringBuilder traceLog = new StringBuilder();
using (LinksMediaContext dataContext = new LinksMediaContext())
{
try
{
traceLog.AppendLine("Start: SelectUserPersonalTrainer---- " + DateTime.Now.ToLongDateString());
if (usertrainerdetails.TrainerCredID > 0)
{
Credentials cred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
if (cred.UserType.Equals(Message.UserTypeUser, StringComparison.OrdinalIgnoreCase))
{
tblUser user = dataContext.User.FirstOrDefault(usr => usr.UserId == cred.UserId);
if (user != null)
{
user.PersonalTrainerCredId = usertrainerdetails.TrainerCredID;
dataContext.SaveChanges();
if (usertrainerdetails.TrainerCredID > 0)
{
string selectedUserName = string.Empty;
selectedUserName = user.FirstName + " " + user.LastName;
NotificationApiBL.SendSelectPrimaryTrainerNotificationToTrainer(usertrainerdetails.TrainerCredID, selectedUserName, cred.UserId, cred.UserType);
}
return(true);
}
}
}
return(false);
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End GetTrainerLibraryChallengeList : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Function to post boom on challenge completed(Comment Section)
/// </summary>
/// <returns>int</returns>
/// <devdoc>
/// Developer Name - Arvind Kumar
/// Date - 05/06/2015
/// </devdoc>
public static int PostBoom(ViewPostVM model)
{
StringBuilder traceLog = null;
using (LinksMediaContext _dbContext = new LinksMediaContext())
{
try
{
traceLog = new StringBuilder();
traceLog.AppendLine("Start: ChallengeMessageFeedBL PostBoom");
Credentials objCred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
if (!_dbContext.Booms.Any(b => b.MessageStraemId == model.PostId && b.BoomedBy == objCred.Id))
{
tblBoom objBoom = new tblBoom();
objBoom.BoomedBy = objCred.Id;
objBoom.BoomedDate = DateTime.Now;
objBoom.MessageStraemId = model.PostId;
_dbContext.Booms.Add(objBoom);
_dbContext.SaveChanges();
// Send the User Notification to user on result boomed
if (model.UserId > 0 && !string.IsNullOrEmpty(model.UserType) && !(objCred.UserType == model.UserType && objCred.UserId == model.UserId))
{
NotificationApiBL.SendNotificationToALLNType(model.UserId, model.UserType, NotificationType.NewsFeedBoomed.ToString(), objCred, model.PostId);
}
}
return(_dbContext.Booms.Count(b => b.MessageStraemId == model.PostId));
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End : ChallengeMessageFeedBL PostBoom : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Save Chat History
/// </summary>
/// <param name="chatHistory"></param>
/// <returns></returns>
public static void SaveChatHistory(ChatHistoryVM chatHistory)
{
StringBuilder traceLog = null;
using (LinksMediaContext dataContext = new LinksMediaContext())
{
traceLog = new StringBuilder();
try
{
traceLog.AppendLine("Start: SaveChatHistory() for receiver Id");
Credentials cred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
if (chatHistory != null && chatHistory.ReceiverCredId > 0 && chatHistory.SenderCredId > 0 && !string.IsNullOrEmpty(chatHistory.Message))
{
tblChatHistory objChatHistory = new tblChatHistory()
{
ReceiverCredId = chatHistory.ReceiverCredId,
SenderCredId = cred.Id,
Message = chatHistory.Message,
IsRead = false,
TrasactionDateTime = DateTime.UtcNow,
};
dataContext.ChatHistory.Add(objChatHistory);
dataContext.SaveChanges();
}
return;
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("SaveChatHistory end() : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Get trainer challenge list with free from for trainer
/// </summary>
/// <returns></returns>
/// <devdoc>
/// Developer Name - Irshad Ansari
/// Date - 04/26/2016
/// </devdoc>
public static List <MainChallengeVM> GetTrainerLibraryChallengeListWithFreeForm(ref bool isTeamJoined)
{
StringBuilder traceLog = new StringBuilder();
using (LinksMediaContext dataContext = new LinksMediaContext())
{
try
{
traceLog.AppendLine("Start: GetTrainerLibraryChallengeListWithFreeForm---- " + DateTime.Now.ToLongDateString());
int teamId = -1;
List <int> trainerCrediId = new List <int>();
Credentials cred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
if (cred.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase))
{
var objtrainer = dataContext.Trainer.FirstOrDefault(u => u.TrainerId == cred.UserId);
if (objtrainer != null)
{
teamId = objtrainer.TeamId;
}
trainerCrediId.Add(cred.Id);
}
else if (cred.UserType.Equals(Message.UserTypeUser, StringComparison.OrdinalIgnoreCase))
{
var objuser = dataContext.User.FirstOrDefault(u => u.UserId == cred.UserId);
if (objuser != null)
{
teamId = objuser.TeamId;
}
trainerCrediId = (from tr in dataContext.Trainer
join crd in dataContext.Credentials
on tr.TrainerId equals crd.UserId
where crd.UserType == Message.UserTypeTrainer && tr.TeamId == teamId
select crd.Id
).ToList();
}
isTeamJoined = teamId > 0 ? true : false;
List <MainChallengeVM> listMainVM = (from c in dataContext.Challenge
join ct in dataContext.ChallengeType on c.ChallengeSubTypeId equals ct.ChallengeSubTypeId
where c.IsActive && trainerCrediId.Contains(c.TrainerId)
orderby c.CreatedDate descending
select new MainChallengeVM
{
ChallengeId = c.ChallengeId,
ChallengeName = c.ChallengeName,
DifficultyLevel = c.DifficultyLevel,
ChallengeType = ct.ChallengeType,
Description = c.Description,
IsSubscription = c.IsSubscription,
TempEquipments = (from trzone in dataContext.ChallengeEquipmentAssociations
join bp in dataContext.Equipments
on trzone.EquipmentId equals bp.EquipmentId
where trzone.ChallengeId == c.ChallengeId
select bp.Equipment).Distinct().ToList <string>(),
TempTargetZone = (from trzone in dataContext.TrainingZoneCAssociations
join bp in dataContext.BodyPart
on trzone.PartId equals bp.PartId
where trzone.ChallengeId == c.ChallengeId
select bp.PartName).Distinct().ToList <string>(),
Strenght = dataContext.UserChallenge.Where(uc => uc.ChallengeId == c.ChallengeId).Select(y => y.UserId).Distinct().Count(),
ResultUnit = ct.ResultUnit,
IsWellness = (ct.ChallengeSubTypeId == ConstantHelper.constWellnessChallengeSubType) ? true : false,
}).ToList();
if (listMainVM != null && listMainVM.Count > 0)
{
listMainVM.ForEach(r =>
{
r.ChallengeType = r.ChallengeType.Split(' ')[0];
if (r.TempTargetZone != null && r.TempTargetZone.Count > 0)
{
r.TargetZone = string.Join(", ", r.TempTargetZone);
}
r.TempTargetZone = null;
if (r.TempEquipments != null && r.TempEquipments.Count > 0)
{
r.Equipment = string.Join(", ", r.TempEquipments);
}
r.TempEquipments = null;
});
//Challenge feed sorted by acceptors
listMainVM = listMainVM.OrderByDescending(chlng => chlng.Strenght).ToList();
}
return(listMainVM);
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End GetTrainerLibraryChallengeListWithFreeForm : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Get FreePremium ChallengeList basd on team Id
/// </summary>
/// <param name="isTeamJoined"></param>
/// <returns></returns>
/// <devdoc>
/// Developer Name - Irshad Ansari
/// Date - 04/26/2016
/// </devdoc>
public static PremimumChallengeVM GetFreePremiumChallengeList(ref bool isTeamJoined)
{
StringBuilder traceLog = new StringBuilder();
using (LinksMediaContext dataContext = new LinksMediaContext())
{
try
{
traceLog.AppendLine("Start: GetFreePremiumChallengeList---- " + DateTime.Now.ToLongDateString());
PremimumChallengeVM objPremimumChallengeVM = new PremimumChallengeVM();
List <int> trainerCrediId = new List <int>();
Credentials cred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
List <int> teamIds = new List <int>();
switch (cred.UserType)
{
case ConstantHelper.constuser:
teamIds = (from usr in dataContext.User
join crd in dataContext.Credentials
on usr.UserId equals crd.UserId
where crd.Id == cred.Id && crd.UserType.Equals(Message.UserTypeUser, StringComparison.OrdinalIgnoreCase)
select usr.TeamId).ToList();
break;
case ConstantHelper.consttrainer:
teamIds = (from crd in dataContext.Credentials
join tms in dataContext.TrainerTeamMembers
on crd.Id equals tms.UserId
orderby tms.RecordId ascending
where crd.Id == cred.Id && crd.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase)
select tms.TeamId).ToList();
break;
}
if (teamIds.Count > 0)
{
trainerCrediId = (from crd in dataContext.Credentials
join tms in dataContext.TrainerTeamMembers
on crd.Id equals tms.UserId
where teamIds.Contains(tms.TeamId) && crd.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase)
select tms.UserId).ToList();
}
if (teamIds != null && teamIds.Count > 0)
{
isTeamJoined = true;
}
List <MainChallengeVM> listMainVM = (from c in dataContext.Challenge
join ct in dataContext.ChallengeType on c.ChallengeSubTypeId equals ct.ChallengeSubTypeId
where c.IsActive &&
(trainerCrediId.Contains(c.TrainerId) || (c.IsPremium && c.TrainerId == 0))
orderby c.ChallengeName ascending
select new MainChallengeVM
{
ChallengeId = c.ChallengeId,
ChallengeName = c.ChallengeName,
DifficultyLevel = c.DifficultyLevel,
ChallengeType = ct.ChallengeType,
Description = c.Description,
IsSubscription = c.IsSubscription,
TempEquipments = (from trzone in dataContext.ChallengeEquipmentAssociations
join bp in dataContext.Equipments
on trzone.EquipmentId equals bp.EquipmentId
where trzone.ChallengeId == c.ChallengeId
select bp.Equipment).Distinct().ToList <string>(),
TempTargetZone = (from trzone in dataContext.TrainingZoneCAssociations
join bp in dataContext.BodyPart
on trzone.PartId equals bp.PartId
where trzone.ChallengeId == c.ChallengeId
select bp.PartName).Distinct().ToList <string>(),
Strenght = dataContext.UserChallenge.Where(uc => uc.ChallengeId == c.ChallengeId).Select(y => y.UserId).Distinct().Count(),
ResultUnit = ct.ResultUnit
}).ToList();
if (listMainVM != null && listMainVM.Count > 0)
{
listMainVM.ForEach(r =>
{
r.ChallengeType = r.ChallengeType.Split(' ')[0];
if (r.TempTargetZone != null && r.TempTargetZone.Count > 0)
{
r.TargetZone = string.Join(", ", r.TempTargetZone);
}
r.TempTargetZone = null;
if (r.TempEquipments != null && r.TempEquipments.Count > 0)
{
r.Equipment = string.Join(", ", r.TempEquipments);
}
r.TempEquipments = null;
});
//Challenge feed sorted by acceptors
listMainVM = listMainVM.OrderBy(chlng => chlng.ChallengeName).ToList();
}
objPremimumChallengeVM.PremimumChallegeList = listMainVM;
objPremimumChallengeVM.PremimumTypeList = ChallengesCommonBL.GetPremiumChallengeCategoryList();
var challengeCategoryList = ChallengesCommonBL.GetapiPreminumChallengeCategoryList(ConstantHelper.constWorkoutChallengeSubType, trainerCrediId);
if (challengeCategoryList != null)
{
objPremimumChallengeVM.PremimumWorksoutList = challengeCategoryList.ChallengeCategoryList;
objPremimumChallengeVM.FeaturedList = challengeCategoryList.FeaturedList;
objPremimumChallengeVM.TrendingList = challengeCategoryList.TrendingCategoryList;
}
return(objPremimumChallengeVM);
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End GetFreePremiumChallengeList : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Function to post comment on challenge completed(Comment Section)
/// </summary>
/// <returns>CommentVM</returns>
/// <devdoc>
/// Developer Name - Arvind Kumar
/// Date - 05/06/2015
/// </devdoc>
public static CommentVM PostComment(CommentVM model)
{
StringBuilder traceLog = null;
using (LinksMediaContext _dbContext = new LinksMediaContext())
{
try
{
traceLog = new StringBuilder();
traceLog.AppendLine("Start: ChallengeMessageFeedBL PostComment");
Credentials cred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
tblComment objComment = new tblComment();
objComment.CommentedBy = cred.Id;
objComment.CommentedDate = DateTime.Now;
objComment.Message = model.Message;
objComment.MessageStraemId = model.PostId;
_dbContext.Comments.Add(objComment);
_dbContext.SaveChanges();
// User Notification when user post message on other user or trainer post data their team member
if (!string.IsNullOrEmpty(model.UserType) && model.UserId == cred.UserId && cred.UserType == model.UserType)
{
NotificationApiBL.SendALLSenderNotificationByUser(model.PostId, NotificationType.NewsFeedCommented.ToString(), NotificationType.PostCommentedReplyMsg.ToString(), cred);
}
else if (model.UserId > 0 && !string.IsNullOrEmpty(model.UserType))
{
NotificationApiBL.SendNotificationToALLNType(model.UserId, model.UserType, NotificationType.NewsFeedCommented.ToString(), cred, model.PostId);
NotificationApiBL.SendALLSenderNotificationByUser(model.PostId, NotificationType.NewsFeedCommented.ToString(), NotificationType.PostCommentedReplyMsg.ToString(), cred);
}
CommentVM objCommentVM = new CommentVM()
{
CommentId = objComment.CommentId,
PostId = model.PostId,
CommentBy = objComment.CommentedBy,
Message = model.Message,
CommentDate = CommonWebApiBL.GetDateTimeFormat(objComment.CommentedDate),
PostedCommentDate = objComment.CommentedDate.ToUniversalTime()
};
if (cred.UserType.Equals(Message.UserTypeUser, StringComparison.OrdinalIgnoreCase))
{
var user = _dbContext.User.FirstOrDefault(u => u.UserId == cred.UserId);
if (user != null)
{
objCommentVM.ImageUrl = string.IsNullOrEmpty(user.UserImageUrl) ? string.Empty : CommonUtility.VirtualPath + Message.ProfilePicDirectory + user.UserImageUrl;
objCommentVM.UserName = user.FirstName + " " + user.LastName;
objCommentVM.UserId = user.UserId;
objCommentVM.UserType = Message.UserTypeUser;
}
}
else if (cred.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase))
{
var trainer = _dbContext.Trainer.FirstOrDefault(t => t.TrainerId == cred.UserId);
if (trainer != null)
{
objCommentVM.ImageUrl = string.IsNullOrEmpty(trainer.TrainerImageUrl) ? string.Empty : CommonUtility.VirtualPath + Message.ProfilePicDirectory + trainer.TrainerImageUrl;
objCommentVM.UserName = trainer.FirstName + " " + trainer.LastName;
objCommentVM.UserId = trainer.TrainerId;
objCommentVM.UserType = Message.UserTypeTrainer;
}
}
return(objCommentVM);
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End : ChallengeMessageFeedBL PostComment : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Function to post Share message text on challenge completed(Comment Section)
/// </summary>
/// <returns>ViewPostVM</returns>
/// <devdoc>
/// Developer Name - Arvind Kumar
/// Date - 05/06/2015
/// </devdoc>
public static ViewPostVM PostShare(PostVM <TextMessageStream> message)
{
StringBuilder traceLog = null;
using (LinksMediaContext _dbContext = new LinksMediaContext())
{
try
{
traceLog = new StringBuilder();
traceLog.AppendLine("Start: ChallengeMessageFeedBL PostShare");
Credentials objCred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
tblMessageStream objMessageStream = new tblMessageStream();
objMessageStream.Content = message.Stream.TextMessage;
objMessageStream.MessageType = Message.TextMessageType;
objMessageStream.PostedDate = DateTime.Now;
objMessageStream.TargetType = Message.ChallengeTargetType;
objMessageStream.SubjectId = objCred.Id;
objMessageStream.TargetId = message.TargetId; //ChallengeId is assigned.
objMessageStream.IsTextImageVideo = true;
objMessageStream.IsImageVideo = message.IsImageVideo;
_dbContext.MessageStraems.Add(objMessageStream);
_dbContext.SaveChanges();
if (objCred.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase))
{
// User Notification when user post message on other user or trainer post data their team member
NotificationApiBL.SendALLTeamNotificationByTrainer(objCred.UserId, objMessageStream.MessageStraemId, objCred.UserId, objCred.UserType);
}
ViewPostVM objViewPostVM = new ViewPostVM()
{
PostId = objMessageStream.MessageStraemId,
Message = objMessageStream.Content,
PostedDate = CommonWebApiBL.GetDateTimeFormat(objMessageStream.PostedDate),
BoomsCount = _dbContext.Booms.Count(b => b.MessageStraemId == objMessageStream.MessageStraemId),
CommentsCount = _dbContext.Comments.Count(cmnt => cmnt.MessageStraemId == objMessageStream.MessageStraemId)
};
if (objCred.UserType.Equals(Message.UserTypeUser, StringComparison.OrdinalIgnoreCase))
{
var user = (from usr in _dbContext.User
join crd in _dbContext.Credentials on usr.UserId equals crd.UserId
where crd.UserType == Message.UserTypeUser && crd.Id == objMessageStream.SubjectId
select new
{
usr.FirstName,
usr.LastName,
usr.UserImageUrl,
crd.UserId,
crd.UserType
}).FirstOrDefault();
if (user != null)
{
objViewPostVM.PostedByImageUrl = string.IsNullOrEmpty(user.UserImageUrl) ? string.Empty : CommonUtility.VirtualPath + Message.ProfilePicDirectory + user.UserImageUrl;
objViewPostVM.UserName = user.FirstName + " " + user.LastName;
objViewPostVM.UserId = user.UserId;
objViewPostVM.UserType = user.UserType;
}
}
else if (objCred.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase))
{
var trainer = (from t in _dbContext.Trainer
join crd in _dbContext.Credentials on t.TrainerId equals crd.UserId
where crd.UserType == Message.UserTypeTrainer && crd.Id == objMessageStream.SubjectId
select new
{
t.FirstName,
t.LastName,
t.TrainerImageUrl,
crd.UserId,
crd.UserType
}).FirstOrDefault();
if (trainer != null)
{
objViewPostVM.PostedByImageUrl = string.IsNullOrEmpty(trainer.TrainerImageUrl) ? string.Empty :
CommonUtility.VirtualPath + Message.ProfilePicDirectory + trainer.TrainerImageUrl;
objViewPostVM.UserName = trainer.FirstName + " " + trainer.LastName;
objViewPostVM.UserId = trainer.UserId;
objViewPostVM.UserType = trainer.UserType;
}
}
return(objViewPostVM);
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End:ChallengeMessageFeedBL PostShare --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Function to get post list on challenge completed(Comment Section)
/// </summary>
/// <returns>Total<List<ChallengeViewPostVM>></returns>
/// <devdoc>
/// Developer Name - Arvind Kumar
/// Date - 05/13/2015
/// </devdoc>
public static Total <List <ChallengeViewPostVM> > GetPostListForChallenge(int challengeId, int startIndex, int endIndex)
{
StringBuilder traceLog = null;
using (LinksMediaContext _dbContext = new LinksMediaContext())
{
try
{
traceLog = new StringBuilder();
traceLog.AppendLine("Start: ChallengeMessageFeedBL GetPostList");
Credentials userCredential = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
List <ChallengeViewPostVM> objList = (from m in _dbContext.MessageStraems
join c in _dbContext.Credentials on m.SubjectId equals c.Id
where m.TargetId == challengeId && m.IsImageVideo &&
(!(string.IsNullOrEmpty(m.Content)) || m.IsImageVideo) &&
m.TargetType == Message.ChallengeTargetType &&
m.IsTextImageVideo == true
orderby m.PostedDate descending
select new ChallengeViewPostVM
{
PostId = m.MessageStraemId,
DbPostedDate = m.PostedDate,
Message = m.Content,
BoomsCount = _dbContext.Booms.Count(b => b.MessageStraemId == m.MessageStraemId),
CommentsCount = _dbContext.Comments.Count(cmnt => cmnt.MessageStraemId == m.MessageStraemId),
PostedBy = m.SubjectId,
UserId = _dbContext.Credentials.FirstOrDefault(crede => crede.Id == m.SubjectId).UserId,
UserType = _dbContext.Credentials.FirstOrDefault(crede => crede.Id == m.SubjectId).UserType,
IsLoginUserBoom = _dbContext.Booms.Where(bm => bm.MessageStraemId == m.MessageStraemId).Any(b => b.BoomedBy == userCredential.Id),
IsLoginUserComment = _dbContext.Comments.Where(cm => cm.MessageStraemId == m.MessageStraemId).Any(b => b.CommentedBy == userCredential.Id),
VideoList = (from vl in _dbContext.MessageStreamVideo
where vl.MessageStraemId == m.MessageStraemId && !string.IsNullOrEmpty(vl.VideoUrl)
select new VideoInfo
{
RecordId = vl.RecordId,
VideoUrl = vl.VideoUrl
}).ToList(),
PicList = (from pl in _dbContext.MessageStreamPic
where pl.MessageStraemId == m.MessageStraemId && !string.IsNullOrEmpty(pl.PicUrl)
select new PicsInfo
{
PicId = pl.RecordId,
PicsUrl = pl.PicUrl,
ImageMode = pl.ImageMode,
Width = pl.Width,
Height = pl.Height
}).ToList()
}).ToList();
foreach (var item in objList)
{
tblCredentials objCred = _dbContext.Credentials.FirstOrDefault(cr => cr.Id == item.PostedBy);
string imageUrl = string.Empty;
if (objCred != null && objCred.UserType.Equals(Message.UserTypeUser, StringComparison.OrdinalIgnoreCase))
{
tblUser userTemp = _dbContext.User.FirstOrDefault(usr => usr.UserId == objCred.UserId);
if (userTemp != null)
{
imageUrl = string.IsNullOrEmpty(userTemp.UserImageUrl) ? string.Empty : CommonUtility.VirtualPath + Message.ProfilePicDirectory + userTemp.UserImageUrl;
}
}
else if (objCred != null && objCred.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase))
{
tblTrainer trainerTemp = _dbContext.Trainer.FirstOrDefault(usr => usr.TrainerId == objCred.UserId);
if (trainerTemp != null)
{
imageUrl = string.IsNullOrEmpty(trainerTemp.TrainerImageUrl) ? string.Empty : CommonUtility.VirtualPath +
Message.ProfilePicDirectory + trainerTemp.TrainerImageUrl;
}
}
item.PostedByImageUrl = imageUrl;
item.UserName = (objCred.UserType.Equals(Message.UserTypeUser, StringComparison.OrdinalIgnoreCase)
? _dbContext.User.FirstOrDefault(usr => usr.UserId == objCred.UserId).FirstName + " "
+ _dbContext.User.FirstOrDefault(usr => usr.UserId == objCred.UserId).LastName
: _dbContext.Trainer.FirstOrDefault(tnr => tnr.TrainerId == objCred.UserId).FirstName + " "
+ _dbContext.Trainer.FirstOrDefault(tnr => tnr.TrainerId == objCred.UserId).LastName);
item.PostedDate = CommonWebApiBL.GetDateTimeFormat(item.DbPostedDate);
//Code For Getting Posted Pics
item.PicList.ForEach(pic =>
{
pic.PicsUrl = (!string.IsNullOrEmpty(pic.PicsUrl) && System.IO.File.Exists(HttpContext.Current.Server.MapPath("~/" + Message.ResultPicDirectory + pic.PicsUrl))) ?
CommonUtility.VirtualPath + Message.ResultPicDirectory + pic.PicsUrl : string.Empty;
}
);
string thumnailHeight, thumnailWidth;
//Code For Getting Posted Videos
item.VideoList.ForEach(vid =>
{
string thumnailFileName = vid.VideoUrl.Split('.')[0] + Message.JpgImageExtension;
vid.ThumbNailUrl = string.IsNullOrEmpty(vid.VideoUrl) ? string.Empty : CommonUtility.VirtualPath +
Message.ResultVideoDirectory + vid.VideoUrl.Split('.')[0] + Message.JpgImageExtension;
vid.VideoUrl = !string.IsNullOrEmpty(vid.VideoUrl) ? CommonUtility.VirtualPath + Message.ResultVideoDirectory + vid.VideoUrl : string.Empty;
thumnailHeight = string.Empty;
thumnailWidth = string.Empty;
CommonWebApiBL.GetThumNailDemension(thumnailFileName, out thumnailHeight, out thumnailWidth);
vid.ThumbNailHeight = thumnailHeight;
vid.ThumbNailWidth = thumnailWidth;
}
);
}
Total <List <ChallengeViewPostVM> > objresult = new Total <List <ChallengeViewPostVM> >();
objresult.TotalList = (from l in objList
orderby l.DbPostedDate descending
select l).Skip(startIndex).Take(endIndex - startIndex).ToList();
objresult.TotalCount = objList.Count();
if ((objresult.TotalCount) > endIndex)
{
objresult.IsMoreAvailable = true;
}
return(objresult);
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End :ChallengeMessageFeedBL GetPostList : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Get ChatHistory based on Sender and Receiver Id
/// </summary>
/// <param name="chatRequest"></param>
/// <returns></returns>
public static Total <List <SocketSentChatVM> > GetChatHistory(ChatHistoryRequest chatRequest, int startIndex, int endIndex)
{
StringBuilder traceLog = null;
Total <List <SocketSentChatVM> > chatHistoryList = new Total <List <SocketSentChatVM> >();
using (LinksMediaContext dataContext = new LinksMediaContext())
{
traceLog = new StringBuilder();
try
{
traceLog.AppendLine("Start: GetChatHistory() for receiver Id");
if (chatRequest != null && chatRequest.SenderCredId > 0)
{
Credentials cred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
int currentUserCrdId = cred.Id;
int senderCredId = chatRequest.SenderCredId;
List <SocketSentChatResponse> chatlist = (from ch in dataContext.ChatHistory
where (ch.ReceiverCredId == currentUserCrdId && ch.SenderCredId == senderCredId) || (ch.ReceiverCredId == senderCredId && ch.SenderCredId == currentUserCrdId)
orderby ch.ChatHistoryId descending
select new SocketSentChatResponse
{
ChatHistoryId = ch.ChatHistoryId,
Message = ch.Message,
ReceiverEmailId = dataContext.Credentials.Where(crd => crd.Id == ch.ReceiverCredId).Select(s => s.EmailId).FirstOrDefault(),
SenderEmailId = dataContext.Credentials.Where(crd => crd.Id == ch.SenderCredId).Select(s => s.EmailId).FirstOrDefault(),
TrasactionDateTime = ch.TrasactionDateTime
}).ToList();
if (chatlist != null)
{
var chathistorylist = chatlist.Skip(startIndex).Take(endIndex - startIndex).ToList().OrderBy(ch => ch.ChatHistoryId).ToList();
chatHistoryList.TotalList = (from m in chathistorylist
orderby m.ChatHistoryId
select new SocketSentChatVM
{
ChatHistoryId = m.ChatHistoryId,
Message = m.Message,
ReceiverEmailId = m.ReceiverEmailId,
SenderEmailId = m.SenderEmailId,
TrasactionDateTime = m.TrasactionDateTime.ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fff")
}).ToList();
chatHistoryList.TotalCount = chatlist.Count();
if ((chatHistoryList.TotalCount) > endIndex)
{
chatHistoryList.IsMoreAvailable = true;
}
}
// Update IsRead when user
if (chatRequest.IsRead || currentUserCrdId > 0)
{
UpdateChatHistory(currentUserCrdId, senderCredId);
UpdateChatNotification(currentUserCrdId, senderCredId);
}
}
return(chatHistoryList);
}
finally
{
traceLog.AppendLine("GetChatHistory end() : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}
/// <summary>
/// Get FreeForm TrainerLibrary Challenges By SubCategory
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static ChallengeTabVM GetFreeFormTrainerLibraryChallengesBySubCategory(TrainerLibraryWorkoutListByCategory model)
{
StringBuilder traceLog = new StringBuilder();
using (LinksMediaContext dataContext = new LinksMediaContext())
{
try
{
traceLog.AppendLine("Start: GetFreeFormTrainerLibraryChallengesBySubCategory---- " + DateTime.Now.ToLongDateString());
int trainerCredId = -1;
ChallengeTabVM objChallengeTabVM = new ChallengeTabVM();
Credentials objCred = CommonWebApiBL.GetUserId(Thread.CurrentPrincipal.Identity.Name);
int usercredId = objCred.Id;
if (!string.IsNullOrEmpty(model.UserType) && model.UserType.Equals(Message.UserTypeTrainer, StringComparison.OrdinalIgnoreCase))
{
trainerCredId = (from tr in dataContext.Trainer
join crd in dataContext.Credentials
on tr.TrainerId equals crd.UserId
where crd.UserType == Message.UserTypeTrainer && tr.TrainerId == model.UserId
select crd.Id).FirstOrDefault();
}
if (trainerCredId > 0)
{
List <MainChallengeVM> listMainVM = (from c in dataContext.Challenge
join ct in dataContext.ChallengeType on c.ChallengeSubTypeId equals ct.ChallengeSubTypeId
where c.IsActive && c.TrainerId == trainerCredId &&
ct.ChallengeSubTypeId == model.WorkoutCategoryID
// && c.IsPremium == true
orderby c.CreatedDate descending
select new MainChallengeVM
{
ChallengeId = c.ChallengeId,
ChallengeName = c.ChallengeName,
DifficultyLevel = c.DifficultyLevel,
ChallengeType = ct.ChallengeType,
Description = c.Description,
IsSubscription = c.IsSubscription,
TempEquipments = (from trzone in dataContext.ChallengeEquipmentAssociations
join bp in dataContext.Equipments
on trzone.EquipmentId equals bp.EquipmentId
where trzone.ChallengeId == c.ChallengeId
select bp.Equipment).Distinct().ToList <string>(),
TempTargetZone = (from trzone in dataContext.TrainingZoneCAssociations
join bp in dataContext.BodyPart
on trzone.PartId equals bp.PartId
where trzone.ChallengeId == c.ChallengeId
select bp.PartName).Distinct().ToList <string>(),
IsActive = dataContext.UserActivePrograms.Where(uc => uc.ProgramId == c.ChallengeId && uc.IsCompleted == false &&
uc.UserCredId == usercredId).Select(y => y.ProgramId).Distinct().Count() > 0,
Strenght = dataContext.UserChallenge.Where(uc => uc.ChallengeId == c.ChallengeId).Select(y => y.UserId).Distinct().Count(),
ResultUnit = ct.ResultUnit,
IsWellness = (ct.ChallengeSubTypeId == ConstantHelper.constWellnessChallengeSubType) ? true : false,
ProgramImageUrl = c.ProgramImageUrl,
ChallengeCategoryList = dataContext.ChallengeCategoryAssociations.
Where(cc => cc.ChallengeId == c.ChallengeId && cc.IsProgram == (ConstantHelper.constProgramChallengeSubType == c.ChallengeSubTypeId)).Select(ch => ch.ChallengeCategoryId).ToList()
}).ToList();
if (listMainVM != null && listMainVM.Count > 0)
{
listMainVM = listMainVM.Where(ch => ch.ChallengeCategoryList != null && ch.ChallengeCategoryList.Contains(model.WorkoutSubCategoryID)).ToList();
listMainVM.ForEach(r =>
{
string filePath = HttpContext.Current.Server.MapPath("~") + "\\images\\profilepic\\" + r.ProgramImageUrl;
if (System.IO.File.Exists(filePath))
{
using (Bitmap objBitmap = new Bitmap(filePath))
{
double sourceWidth = Convert.ToDouble(objBitmap.Size.Width, CultureInfo.CurrentCulture);
double sourceHeight = Convert.ToDouble(objBitmap.Size.Height, CultureInfo.CurrentCulture);
r.Height = (sourceWidth > 0) ? Convert.ToString(sourceHeight, CultureInfo.CurrentCulture) : string.Empty;
r.Width = (sourceWidth > 0) ? Convert.ToString(sourceWidth, CultureInfo.CurrentCulture) : string.Empty;
}
}
else
{
r.Height = string.Empty;
r.Width = string.Empty;
}
r.ChallengeType = r.ChallengeType.Split(' ')[0];
r.ProgramImageUrl = (string.IsNullOrEmpty(r.ProgramImageUrl)) ? string.Empty :
File.Exists(HttpContext.Current.Server.MapPath("~/" + Message.ProfilePicDirectory + r.ProgramImageUrl)) ?
CommonUtility.VirtualPath + Message.ProfilePicDirectory + r.ProgramImageUrl : string.Empty;
if (r.TempTargetZone != null && r.TempTargetZone.Count > 0)
{
r.TargetZone = string.Join(", ", r.TempTargetZone);
}
r.TempTargetZone = null;
if (r.TempEquipments != null && r.TempEquipments.Count > 0)
{
r.Equipment = string.Join(", ", r.TempEquipments);
}
r.TempEquipments = null;
});
int totalcount = listMainVM.Count();
listMainVM = (from l in listMainVM
select l).Skip(model.StartIndex).Take(model.EndIndex - model.StartIndex).ToList();
if ((totalcount) > model.StartIndex)
{
objChallengeTabVM.IsMoreAvailable = true;
}
//Challenge feed sorted by acceptors
if (listMainVM != null)
{
listMainVM = listMainVM.OrderByDescending(chlng => chlng.Strenght).ToList();
}
objChallengeTabVM.ChallengeList = new List <MainChallengeVM>();
objChallengeTabVM.ChallengeList = listMainVM;
}
}
return(objChallengeTabVM);
}
catch
{
throw;
}
finally
{
traceLog.AppendLine("End GetFreeFormTrainerLibraryChallengesBySubCategory : --- " + DateTime.Now.ToLongDateString());
LogManager.LogManagerInstance.WriteTraceLog(traceLog);
}
}
}