public List <Message> GetAllMessagesForUser(DataAccessLayer.User user, DateTime?syncTime)
{
DateTime now = DateTime.UtcNow;
DateTime nonNullSyncTime = syncTime ?? DateTime.UtcNow - new TimeSpan(7, 0, 0, 0);
List <SortCriteria> sorts = new List <SortCriteria>();
sorts.Add(new SortCriteria()
{
Column = MessageTable.LastUpdateTimeUtcTicksColumn, SortOrder = SortOrder.Descending
});
// Create a filter to say Select * from MessageTable where (Sender = @userId OR Recipient = @userId OR Recipient = @groupThatUserIsAMemberOf) AND LastUpdateTime > @syncTime
QueryFilter filter = new SelectFilter(
MessageTable.Instance,
new AndFilter(
MessageStore.CreateUserFilter(user),
new ComparisonFilter(MessageTable.LastUpdateTimeUtcTicksColumn, nonNullSyncTime.Ticks, ComparisonOperator.Greater)),
sorts);
List <ITableRow> rows = MessageTable.Instance.QueryRows(filter);
List <Message> messages = new List <Message>();
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
messages.Add(DataContractToTableRowConverter.ConvertToMessage(MessageTable.Instance, rows[i]));
}
}
DataAccessLayer.UserService.UpdateUserLastSyncTime(user.Id, now);
return(messages);
}
/// <summary>
/// Save a message in the database
/// </summary>
/// <param name="message"></param>
public void SaveMessage(DataAccessLayer.User sender, Message message)
{
message.Validate(sender);
ITableRow tableRow = message.ConvertToTableRow();
MessageTable.Instance.InsertRow(tableRow);
}
public void DeleteUser(CommonLibrary.Users user)
{
DataAccessLayer.User usr = new DataAccessLayer.User
{
UserID = user.UserID
};
_projectManager.Entry(usr).State = EntityState.Deleted;
_projectManager.SaveChanges();
}
public User(DataAccessLayer.User u)
{
this.Password = u.password;
this.Email = u.email;
this.Nickname = u.nickname;
this.Board = u.board;
dal = u;
logged_in = false;
}
public User(string email, string password, string nickname, string board)
{
this.Email = email;
this.Nickname = nickname;
this.Password = password;
this.Board = board;
dal = new DataAccessLayer.User(email, password, nickname, board);
logged_in = false;
}
public void AddUser(CommonLibrary.Users user)
{
DataAccessLayer.User usr = new DataAccessLayer.User
{
UserID = user.UserID,
FirstName = user.FirstName,
LastName = user.LastName,
EmployeeID = user.EmployeeID
};
_projectManager.Users.Add(usr);
_projectManager.SaveChanges();
}
public int GetUnseenMessageCount(DataAccessLayer.User user, DateTime lastSeenTime)
{
// Create a filter to say Select * from MessageTable where (Sender = @userId OR Recipient = @userId OR Recipient = @groupThatUserIsAMemberOf) AND LastUpdateTime > @syncTime
QueryFilter filter = new SelectFilter(
MessageTable.Instance,
new AndFilter(
MessageStore.CreateUserFilterForCount(user),
new ComparisonFilter(MessageTable.LastUpdateTimeUtcTicksColumn, lastSeenTime.Ticks, ComparisonOperator.Greater)),
null,
true /*count*/);
return(MessageTable.Instance.GetRowCount(filter));
}
public DataAccessLayer.User MapToDatabaseType(User userModel)
{
if (userModel == null)
{
return(null);
}
var user = new DataAccessLayer.User
{
id = userModel.Id ?? 0,
username = userModel.Username,
email = userModel.Email,
password = userModel.Password,
firstname = userModel.FirstName,
lastname = userModel.LastName,
avatar = userModel.Avatar
};
return(user);
}
public User MapToUserModel(DataAccessLayer.User userFromDatabase)
{
if (userFromDatabase == null)
{
return(null);
}
var user = new User
{
Id = userFromDatabase.id,
Username = userFromDatabase.username,
Email = userFromDatabase.email,
Password = userFromDatabase.password,
FirstName = userFromDatabase.firstname,
LastName = userFromDatabase.lastname,
Avatar = userFromDatabase.avatar
};
return(user);
}
internal static QueryFilter CreateUserFilterForCount(DataAccessLayer.User user)
{
QueryFilter recipientFilter = new ComparisonFilter(MessageTable.RecipientIdColumn, user.Id, ComparisonOperator.Equal);
if (user.GroupIds == null || user.GroupIds.Count == 0)
{
return(recipientFilter);
}
List <QueryFilter> filters = new List <QueryFilter>();
filters.Add(recipientFilter);
for (int i = 0; i < user.GroupIds.Count; i++)
{
filters.Add(new ComparisonFilter(MessageTable.RecipientIdColumn, user.GroupIds[i], ComparisonOperator.Equal));
}
return(new OrFilter(filters));
}
private void AuthenticateUser(string token)
{
try
{
user = DataAccessLayer.DAL.GetUserObject(token);
if (user.Uid != -1)
{
var identity = new CustomIdentity(user);
SetPrincipal(new GenericPrincipal(identity, null));
//
}
else
{
// Invalid User
HttpContext.Current.Response.StatusCode = 401;
}
}
catch (Exception)
{
HttpContext.Current.Response.StatusCode = 401;
}
}
public bool RegisterUserUsingAPI(Common.Models.User user)
{
bool status;
try
{
DataAccessLayer.User userObj = new DataAccessLayer.User();
userObj.EmailId = user.EmailId;
userObj.UserPassword = user.UserPassword;
userObj.Gender = user.Gender;
userObj.DateOfBirth = user.DateOfBirth;
userObj.Address = user.Address;
var dal = new QuickKartRepository();
status = dal.RegisterUserUsingLinq(userObj);
}
catch (Exception)
{
status = false;
}
return(status);
}
/*public DataAccessLayer.User ToDalObject()
* {
* DataAccessLayer.User u = new DataAccessLayer.User(this.Email,this.Password,this.Nickname);
* return u;
* }*/
public void AddToDatabase()
{
DataAccessLayer.User u = new DataAccessLayer.User(this.Email, this.Password, this.Nickname, this.Board);
u.Add();
}
public User()
{
accessUser = new DataAccessLayer.User();
}
private static Guid GetConversationId(DataAccessLayer.User sender, DataAccessLayer.User recipient)
{
int senderId = recipient.UserType == DataAccessLayer.UserType.Group ? 0 : sender.Id;
return(MessageValidator.GetConversationGuid(senderId, recipient.Id));
}
public static void Validate(this Message message, DataAccessLayer.User sender)
{
message.MessageId = Guid.NewGuid();
message.LastUpdateTimeUtcTicks = DateTime.UtcNow.Ticks;
message.PostDateTimeUtcTicks = DateTime.UtcNow.Ticks;
if (message.Sender == null || message.Sender.Id != sender.Id)
{
throw new InvalidMessageException(InvalidMessageError.InvalidSenderError);
}
if (message.Recipient == null || message.Recipient.Id == message.Sender.Id)
{
throw new InvalidMessageException(InvalidMessageError.InvalidRecipientError);
}
if (message.ConversationId != GetConversationId(message.Sender, message.Recipient) &&
message.ConversationId != Guid.Empty)
{
throw new InvalidMessageException(InvalidMessageError.InvalidSenderError);
}
if (message.ConversationId == Guid.Empty)
{
int senderId = message.Recipient.UserType == DataAccessLayer.UserType.Group ? 0 : message.SenderId;
message.ConversationId = MessageValidator.GetConversationGuid(senderId, message.RecipientId);
}
if (((message.MessageFlags & MessageFlags.Image) == MessageFlags.Image) &&
message.Image == null)
{
throw new InvalidMessageException(InvalidMessageError.ImageMissingError);
}
if (((message.MessageFlags & (MessageFlags.PollMessage | MessageFlags.Calendar)) == MessageFlags.PollMessage) &&
(message.PollOptions == null || message.PollOptions.Count == 0))
{
throw new InvalidMessageException(InvalidMessageError.InvalidPollOptionsError);
}
if (((message.MessageFlags & MessageFlags.PollResponseMessage) == MessageFlags.PollResponseMessage) &&
(message.PollMessageId == Guid.Empty))
{
throw new InvalidMessageException(InvalidMessageError.InvalidPollResponseError);
}
if ((message.MessageFlags & MessageFlags.PollResponseMessage) == MessageFlags.PollResponseMessage)
{
if (message.PollMessageId == null)
{
throw new InvalidMessageException(InvalidMessageError.InvalidPollResponseError);
}
Message pollMessage = MessageStore.Instance.GetMessage(message.ConversationId, message.PollMessageId.Value);
if (pollMessage == null)
{
throw new InvalidMessageException(InvalidMessageError.InvalidPollResponseError);
}
if ((pollMessage.MessageFlags & MessageFlags.PollMessage) != MessageFlags.PollMessage)
{
throw new InvalidMessageException(InvalidMessageError.InvalidPollResponseError);
}
if (((pollMessage.MessageFlags & MessageFlags.Calendar) == 0) &&
!pollMessage.PollOptions.Contains(message.PollResponse))
{
throw new InvalidMessageException(InvalidMessageError.InvalidPollResponseError);
}
}
if (message.ClientMessageId == Guid.Empty)
{
message.ClientMessageId = Guid.NewGuid();
}
}
