public static void UpdateSQLYtGrp(Domain.Socioboard.Models.YoutubeGroupInvite item)
{
Helper.DatabaseRepository dbr = new Helper.DatabaseRepository();
if (item.Owner)
{
Domain.Socioboard.Models.User _SBUser = dbr.Single <Domain.Socioboard.Models.User>(t => t.Id == item.UserId);
if (_SBUser != null)
{
item.OwnerName = _SBUser.FirstName + " " + _SBUser.LastName;
item.OwnerEmailid = _SBUser.EmailId;
item.SBUserName = _SBUser.FirstName + " " + _SBUser.LastName;
item.SBEmailId = _SBUser.EmailId;
if (_SBUser.ProfilePicUrl == "" || _SBUser.ProfilePicUrl == null)
{
item.SBProfilePic = "https://i.imgur.com/zqN47Qp.png";
}
else
{
item.SBProfilePic = _SBUser.ProfilePicUrl;
}
dbr.Update(item);
}
}
else
{
Domain.Socioboard.Models.User _SBUserOwner = dbr.Single <Domain.Socioboard.Models.User>(t => t.Id == item.AccessSBUserId);
Domain.Socioboard.Models.User _SBUserMmbr = dbr.Single <Domain.Socioboard.Models.User>(t => t.Id == item.UserId);
if (_SBUserOwner != null)
{
item.OwnerName = _SBUserOwner.FirstName + " " + _SBUserOwner.LastName;
item.OwnerEmailid = _SBUserOwner.EmailId;
if (_SBUserMmbr != null)
{
item.SBUserName = _SBUserMmbr.FirstName + " " + _SBUserMmbr.LastName;
item.SBEmailId = _SBUserMmbr.EmailId;
if (_SBUserMmbr.ProfilePicUrl == "" || _SBUserMmbr.ProfilePicUrl == null)
{
item.SBProfilePic = "https://i.imgur.com/zqN47Qp.png";
}
else
{
item.SBProfilePic = _SBUserMmbr.ProfilePicUrl;
}
}
dbr.Update(item);
}
}
Console.WriteLine(count++);
}
public IActionResult InviteGroupMember(Int64 userId, string emailId)
{
DatabaseRepository dbr = new DatabaseRepository(_logger, _appEnv);
Domain.Socioboard.Models.YoutubeGroupInvite tempUser = Repositories.YoutubeGroupRepository.InviteGroupMember(userId, emailId, _appSettings, _logger, dbr);
if (tempUser != null)
{
try
{
string path = _appEnv.WebRootPath + "\\views\\mailtemplates\\yt_group_mail.html";
string html = System.IO.File.ReadAllText(path);
html = html.Replace("[NAME]", tempUser.OwnerName).Replace("[LINK]", _appSettings.Domain + "/Home/ActiveYoutubeGroup?Token=" + tempUser.EmailValidationToken);
_emailSender.SendMailSendGrid(_appSettings.frommail, "", tempUser.SBEmailId, "", "", "Socioboard Youtube group invite confirmation link", html, _appSettings.SendgridUserName, _appSettings.SendGridPassword);
}
catch
{
return(Ok());
}
}
return(Ok(""));
}
