public ActionResult DeleteWallItem(int wallItemID)
{
var wallItem = new WallMessage {WallMessageID = wallItemID};
wallItem.Delete();
return RedirectToAction("Visitors", "Account");
}
private void GivenAWallMessageFromHoursAgo()
{
var message = new Message();
message.Contents = "Contents of the Message";
message.PostTime = new DateTime(1000);
WallMessageToBeTranslated = new WallMessage("Bob", message);
CurrentTime = message.PostTime.AddHours(10);
ExpectedTranslation = "Bob - Contents of the Message (10 hours ago)";
}
private string broadcastWallMessageNotification(Dictionary <string, string> keyValuePairs)
{
string userId = keyValuePairs[Constants.CHECKIN_NOTIFIVATION_PARAM_USER_ID];
string locationId = keyValuePairs[Constants.CHECKIN_NOTIFIVATION_PARAM_LOCATION_ID];
// Verify if the current user is involved in the notification
if (userId != null && locationId != null)
{
// Send broadcast notification for registered listeners
var message = new WallMessage();
message.locationId = locationId;
message.userId = userId;
Device.BeginInvokeOnMainThread(() => MessagingCenter.Send(message, WallMessage.TAG));
}
return("");
}
public DataTable GetDataTable(DO_WallMessage ObjScrl_UserHonorsTbl, WallMessage Flag)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter("Scrl_AddEditDelWallMessage", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag;
da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intInvitedUserId;
da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intRegistrationId;
da.SelectCommand.Parameters.Add("@intMessageId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intMessageId;
da.SelectCommand.Parameters.Add("@StrRecommendation", SqlDbType.VarChar, 1000).Value = ObjScrl_UserHonorsTbl.StrRecommendation;
da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intAddedBy;
da.SelectCommand.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 50).Value = ObjScrl_UserHonorsTbl.strIpAddress;
da.SelectCommand.Parameters.Add("@intSkillId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intSkillId;
da.SelectCommand.Parameters.Add("@intGroupId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intGroupId;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
/// <summary>
/// Message SEND
/// </summary>
/// <param name="ObjScrl_UserHonorsTbl"></param>
/// <param name="Flag"></param>
public void Scrl_AddEditDelWallMessage(DO_WallMessage ObjScrl_UserHonorsTbl, WallMessage Flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditDelWallMessage", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag;
cmd.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intInvitedUserId;
cmd.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intRegistrationId;
cmd.Parameters.Add("@intMessageId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intMessageId;
cmd.Parameters.Add("@StrRecommendation", SqlDbType.VarChar, 20000).Value = ObjScrl_UserHonorsTbl.StrRecommendation;
cmd.Parameters.Add("@intGroupId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intGroupId;
cmd.Parameters.Add("@strSubject", SqlDbType.VarChar, 500).Value = ObjScrl_UserHonorsTbl.strSubject;
cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intAddedBy;
cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 50).Value = ObjScrl_UserHonorsTbl.strIpAddress;
cmd.Parameters.Add("@intSkillId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intSkillId;
cmd.Parameters.Add("@strTotalGrpMemberID", SqlDbType.VarChar, 5000).Value = ObjScrl_UserHonorsTbl.strTotalGrpMemberID;
cmd.Parameters.Add("@striInvitedUserId", SqlDbType.VarChar, 100).Value = ObjScrl_UserHonorsTbl.striInvitedUserId;
ObjScrl_UserHonorsTbl.intOutWallMessageId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
}
public void CanNotGetMessagesForRecipientWhenNotInRole()
{
List<WallMessage<AuthorizationUser>> messages;
RavenQueryStatistics stats;
var requester = new AuthorizationUser
{
Name = "requester",
Id = "AuthorizationUsers-2"
};
var sender = new AuthorizationUser
{
Name = "sender",
Id = "AuthorizationUsers-3"
};
var recipient = new AuthorizationUser
{
Name = "recipient",
Id = "AuthorizationUsers-1"
};
var wallMessage = new WallMessage<AuthorizationUser>
{
Id = "WallMessageOfAuthorizationUsers-1",
Creator = sender,
Recipient = recipient,
MessageBody = "blah"
};
new MessagesForAccountByCreatorId().Execute(store);
using (var session = store.OpenSession())
{
session.Store(recipient);
session.Store(requester);
session.Store(sender);
session.Store(wallMessage);
session.SaveChanges();
//set view permissions only for recipient and sender
session.SetAuthorizationFor(wallMessage, new DocumentAuthorization
{
Permissions = {
new DocumentPermission
{
Role = "Authorization/Roles/FriendsOf/" + wallMessage.Recipient.Id,
Allow = true,
Operation = "WallMessage/View"
},
new DocumentPermission
{
Allow = true,
Operation = "WallMessage/View",
User = wallMessage.Recipient.Id
}
}
});
session.SaveChanges();
}
using (var session = store.OpenSession())
{
session.SecureFor(requester.Id, "WallMessage/View");
messages = session.Query<WallMessage<AuthorizationUser>>().TransformWith<MessagesForAccountByCreatorId, WallMessage<AuthorizationUser>>()
.Statistics(out stats)
.Customize(x => x.WaitForNonStaleResultsAsOfNow())
.Where(x => x.Recipient.Id == recipient.Id)
.ToList();
}
Assert.True(messages.Count == 0);
}
public ActionResult WriteWallMessage(string message, int toUserAccountID)
{
_ua = new UserAccount(toUserAccountID);
if (_ua.UserAccountID != 0 && !string.IsNullOrWhiteSpace(message))
{
if (_mu != null)
{
var comment = new WallMessage
{
Message = Server.HtmlEncode(message),
ToUserAccountID = toUserAccountID,
FromUserAccountID = Convert.ToInt32(_mu.ProviderUserKey),
CreatedByUserID = Convert.ToInt32(_mu.ProviderUserKey)
};
comment.Create();
var uad = new UserAccountDetail();
uad.GetUserAccountDeailForUser(_ua.UserAccountID);
if (uad.EmailMessages)
{
_mail.SendMail(AmazonCloudConfigs.SendFromEmail, _ua.EMail, "Wall Post From: " + _mu.UserName,
_ua.UrlTo.ToString());
}
}
}
return RedirectToAction("ProfileDetail", new {@userName = _ua.UserName});
}
public ActionResult WriteWallMessage(string message, int toUserAccountID)
{
ua = new UserAccount(toUserAccountID);
if (ua.UserAccountID != 0 && !string.IsNullOrWhiteSpace(message))
{
MembershipUser mu = Membership.GetUser();
WallMessage comment = new WallMessage();
comment.Message = Server.HtmlEncode(message);
comment.ToUserAccountID = toUserAccountID;
comment.FromUserAccountID = Convert.ToInt32(mu.ProviderUserKey);
comment.CreatedByUserID = Convert.ToInt32(mu.ProviderUserKey);
comment.Create();
}
return RedirectToAction("ProfileDetail", new { @userName = ua.UserName });
}
public string ToWallString(WallMessage message, DateTime currentDateTime)
{
var timeDifferenceString = GetTimeDifferenceString(message, currentDateTime);
return($"{message.User} - {message.Contents} {timeDifferenceString}");
}
