public IEnumerable<ResponseHelper> GetFeedsForUser(string userId)
{
Guid userIdAsGuid = Guid.Empty;
Guid.TryParse(userId, out userIdAsGuid);
var dbContext = new Care4allDatabaseContext();
var responses = from r in dbContext.Responses where r.RespondingUserId == userIdAsGuid select r;
var responseList = new List<ResponseHelper>();
foreach( Response response in responses )
{
var messge = from m in dbContext.Messages where m.Id == response.MessageId select m;
var user = from u in dbContext.Users where u.Id == response.AskingUserId select u;
var responseHelper = new ResponseHelper();
responseHelper.RespondingUserPic = user.ToList()[0].HelperPhoto;
responseHelper.Question = messge.ToList()[0].Content;
responseHelper.Content = response.Content;
responseList.Add( responseHelper );
}
return responseList;
}
public string GetProgressForUser(string userId)
{
Guid userIdAsGuid = Guid.Empty;
Guid.TryParse(userId, out userIdAsGuid);
var dbContext = new Care4allDatabaseContext();
var responses = from r in dbContext.Responses where r.RespondingUserId == userIdAsGuid select r;
int dayCount = 1;
var dayCountAsString = new StringBuilder();
var dataProgress = new StringBuilder();
foreach (Response response in responses)
{
dayCount++;
dayCountAsString.AppendFormat("{0},", dayCount);
var message = from m in dbContext.Messages where m.Id == response.MessageId select m;
var answer = message.ToList()[0].Content;
// null, null, 30, 45, 69, 70
if ( answer.Contains("Yes") )
{
dataProgress.AppendFormat( "{0},", 1 );
}
else if (answer.Contains("No"))
{
dataProgress.AppendFormat("{0},", -1);
}
else
{
dataProgress.AppendFormat("{0},", 0);
}
}
if (dayCountAsString.Length > 0)
dayCountAsString.Remove(dayCountAsString.Length - 1, 1);
if (dataProgress.Length > 0)
dataProgress.Remove(dataProgress.Length - 1, 1);
var progress = new StringBuilder();
progress.Append( "{\"data\":[" );
progress.Append("{ \"data\": [ ");
progress.Append( dataProgress.ToString() );
progress.Append( " ], \"title\": \"\" }" ); // { "data": [ null, null, 30, 45, 69, 70 ], "title": "Smith" }
progress.Append( "],\"x_labels\": [ " );
progress.Append( dayCountAsString.ToString() );
progress.Append( " ] }" );
return progress.ToString();
}
public IEnumerable<MessageHelper> GetMessagesForUser(string parentUserIdWithUserId)
{
var parentUserIdWithUserIdAsArray = parentUserIdWithUserId.Split(new char[] { ';' });
var parentUserIdAsString = parentUserIdWithUserIdAsArray[0];
var userIdAsString = parentUserIdWithUserIdAsArray[1];
Guid parentUserId;
Guid userId;
Guid.TryParse( parentUserIdAsString, out parentUserId );
Guid.TryParse( userIdAsString, out userId );
var dbContext = new Care4allDatabaseContext();
var messagesToAsk = from ma in dbContext.MessageActivations
where ma.DestinationUserId == userId select ma; // ma.SourceUserId == parentUserId &&
var messageList = new List<MessageHelper>();
foreach (MessageActivation messageToAsk in messagesToAsk )
{
var message = from m in dbContext.Messages where m.Id == messageToAsk.MessageId select m;
var jokeMessage = from m in dbContext.Messages where m.Id == messageToAsk.JokeMessageId select m;
var user = from u in dbContext.Users where u.Id == messageToAsk.SourceUserId select u;
var messageHelper = new MessageHelper();
messageHelper.AskingUserId = user.ToList()[0].Id;
messageHelper.AskingUserPic = user.ToList()[0].HelperPhoto;
messageHelper.Message = message.ToList()[0];
if (message.ToList()[0].Type == 1)
messageHelper.JokeMessage = jokeMessage.ToList()[0].Content;
messageList.Add(messageHelper);
}
return messageList;
}
/// <summary>
/// Input 123123123123123;Jane;ASDQWPOKDOIJUIUu86234b23j423423k42=
/// 0 1 2
/// facebookID;Name;Photo
/// </summary>
/// <param name="RegisterWithFacebook"></param>
public User RegisterWithFacebook(string facebook)
{
var facebookAsArray = facebook.Split(new char[] { ';' });
var facebookIdAsString = facebookAsArray[0];
var name = facebookAsArray[1];
var photoAsBase64 = facebookAsArray[2];
var dbContext = new Care4allDatabaseContext();
var existingUser = from u in dbContext.Users where facebookIdAsString.Equals( u.ThirdPartyId ) select u;
User user = null;
if ( existingUser != null && existingUser.ToList().Count > 0 )
{
user = existingUser.ToList()[0];
}
else
{
user = new User() { Id = Guid.NewGuid(), ParentId = Guid.Empty, ThirdPartyId = facebookIdAsString, PinCode = string.Empty, HelperName = name, HelperPhoto = photoAsBase64 };
dbContext.Users.Add(user);
dbContext.SaveChanges();
}
return user;
}
/// <summary>
/// Input {xxxx-xxxx-xxxx-xxxx};1401;Jane;ASDQWPOKDOIJUIUu86234b23j423423k42=
/// 0 1 2 3
/// parentID;pin;GrandmaName;Photo
/// </summary>
/// <param name="parentIdWithPinAndDetails"></param>
public void PreparePin(string parentIdWithPinAndDetails)
{
var parentIdWithPinAndDetailsAsArray = parentIdWithPinAndDetails.Split(new char[] { ';' });
#region Get Parent Id
var parentIdAsString = parentIdWithPinAndDetailsAsArray[0];
Guid parentId = Guid.Empty;
Guid.TryParse( parentIdAsString, out parentId );
#endregion
#region Get Grand Ma-s details
var pin = parentIdWithPinAndDetailsAsArray[1];
var grandmaName = parentIdWithPinAndDetailsAsArray[2];
var photoAsBase64 = parentIdWithPinAndDetailsAsArray[3];
var user = new User() { Id = Guid.NewGuid(), ParentId = parentId, PinCode = pin, HelperName=grandmaName, HelperPhoto=photoAsBase64 };
var dbContext = new Care4allDatabaseContext();
dbContext.Users.Add(user);
dbContext.SaveChanges();
#endregion
#region Generate Default Settings
var dictionary = new Dictionary<string,string>();
dictionary.Add( "c1d80f1c-3c08-4b10-8df1-2ad0b05f8cc4", "77227f63-76c9-498c-82ac-5f71e88c9eb0" );
dictionary.Add( "fbe2807a-de4e-4cb2-8bec-7c875d97aff0", "00000000-0000-0000-0000-000000000000" );
dictionary.Add( "e99a2ab8-b239-4920-a074-f33aa0da4967", "fd7a4513-e93c-41db-b54f-86cdda3bffbc" );
dictionary.Add( "ff9c94b2-c28c-444a-bb4c-10eb8b3c6731", "00000000-0000-0000-0000-000000000000" );
dictionary.Add( "a3ebd50c-35ec-4f2c-a00f-9151d2fff8a3", "fc1109a3-e73d-47b5-8bda-ddcdcbee154b" );
dictionary.Add( "a92d978c-4a9a-4c5b-a128-08b8ff02d86e", "992b7cd3-83be-47c5-8abd-a9d3b8424d8b" );
dictionary.Add( "9ecd3f15-d0e3-4329-be35-9b0992d622a9", "a15f8ae7-92c4-4b27-bf88-582d829cc5a9" );
dictionary.Add( "76e2b960-4f9a-4b0b-9e33-4c49b24113e9", "00000000-0000-0000-0000-000000000000" );
foreach( string key in dictionary.Keys )
{
var value = dictionary[ key ];
dbContext.MessageActivations.Add
(
new MessageActivation()
{
Id = Guid.NewGuid(),
SourceUserId = parentId,
DestinationUserId = user.Id,
MessageId = Guid.Parse( key ),
JokeMessageId = Guid.Parse( value ),
IsActive = true
}
);
}
dbContext.SaveChanges();
//82594a4e-dcd1-4d53-84a7-0bc8791ea244 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 c1d80f1c-3c08-4b10-8df1-2ad0b05f8cc4 77227f63-76c9-498c-82ac-5f71e88c9eb0 True
//90769f17-6b45-436f-9e73-3509a8621251 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 fbe2807a-de4e-4cb2-8bec-7c875d97aff0 00000000-0000-0000-0000-000000000000 True
//b5357955-592f-400b-bf8a-3a0e5a910c90 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 e99a2ab8-b239-4920-a074-f33aa0da4967 fd7a4513-e93c-41db-b54f-86cdda3bffbc True
//77227f63-76c9-498c-82ac-5f71e88c9eb0 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 ff9c94b2-c28c-444a-bb4c-10eb8b3c6731 00000000-0000-0000-0000-000000000000 True
//fd7a4513-e93c-41db-b54f-86cdda3bffbc 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 a3ebd50c-35ec-4f2c-a00f-9151d2fff8a3 fc1109a3-e73d-47b5-8bda-ddcdcbee154b True
//a20f5b8d-9b26-40b6-bfc6-a7e3bf860a05 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 a92d978c-4a9a-4c5b-a128-08b8ff02d86e 992b7cd3-83be-47c5-8abd-a9d3b8424d8b True
//2fab1b19-2e3b-4e83-905c-b97ab311af89 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 9ecd3f15-d0e3-4329-be35-9b0992d622a9 a15f8ae7-92c4-4b27-bf88-582d829cc5a9 True
//e99a2ab8-b239-4920-a074-f33aa0da4967 45ca8921-a116-4a99-817d-36c6a64c2f52 86207dc0-b3c8-4d96-8546-49c258d5b638 76e2b960-4f9a-4b0b-9e33-4c49b24113e9 00000000-0000-0000-0000-000000000000 True
#endregion
}
public User RegisterWithPin(string pin)
{
var dbContext = new Care4allDatabaseContext();
var arrayOfValues = from u in dbContext.Users where u.PinCode == pin select u;
var user = arrayOfValues.ToArray()[0];
dbContext.Users.Remove( user );
dbContext.SaveChanges();
user.PinCode = string.Empty;
dbContext.Users.Add(user);
dbContext.SaveChanges();
return user;
}
/// <summary>
/// userId;messageId;answer
/// </summary>
/// <param name="userIdWithAnswer"></param>
public void RegisterAnswerForUser(string userIdWithAnswer)
{
var userIdWithAnswerAsArray = userIdWithAnswer.Split(new char[] { ';' });
var userIdAsString = userIdWithAnswerAsArray[0];
var messageIdAsString = userIdWithAnswerAsArray[1];
var answer = userIdWithAnswerAsArray[2];
Guid userId;
Guid.TryParse( userIdAsString, out userId );
Guid messageId;
Guid.TryParse(messageIdAsString, out messageId);
var dbContext = new Care4allDatabaseContext();
var messageActivation = from ma in dbContext.MessageActivations where ma.MessageId == messageId select ma;
var response = new Response() { Id = Guid.NewGuid(),
AskingUserId = messageActivation.ToList()[0].SourceUserId,
RespondingUserId = userId,
MessageId = messageId,
Content = answer
};
dbContext.Responses.Add( response );
dbContext.SaveChanges();
}
public IEnumerable<User> GetUsers(string parentUserId)
{
Guid parentId = Guid.Empty;
Guid.TryParse(parentUserId, out parentId);
var dbContext = new Care4allDatabaseContext();
var users = from u in dbContext.Users where u.ParentId == parentId select u;
return users.ToList();
}
