//for adding external user accounts
public static void PostExternalAccounts(UserExternalAccounts model, string userId)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.UserExternalLinks_Upsert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@UserId", userId);
paramCollection.AddWithValue("@Source", model.source);
paramCollection.AddWithValue("@Url", model.url);
}, returnParameters : delegate(SqlParameterCollection param)
{
}
);
}
public static User GetFullUserById(string id)
{
User p = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.UserProfile_AvatarMediaById_v2"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}, map : delegate(IDataReader reader, short set)
{
int startingIndex = 0; //startingOrdinal
if (set == 0)
{
p = new User();
p.ProfileName = reader.GetSafeString(startingIndex++);
p.ProfileEmail = reader.GetSafeString(startingIndex++);
p.ProfilePhone = reader.GetSafeString(startingIndex++);
p.ProfileMobile = reader.GetSafeString(startingIndex++);
p.ProfileWebsite = reader.GetSafeString(startingIndex++);
p.ProfileAddress = reader.GetSafeString(startingIndex++);
p.ProfileCompany = reader.GetSafeString(startingIndex++);
p.UserId = reader.GetSafeString(startingIndex++);
p.MediaId = reader.GetSafeInt32(startingIndex++);
p.ThemeMediaId = reader.GetSafeInt32(startingIndex++);
p.ProfileLastName = reader.GetSafeString(startingIndex++);
p.ProfileViewCount = reader.GetSafeInt32(startingIndex++);
p.ConnectionsCount = reader.GetSafeInt32(startingIndex++);
p.GroupsCount = reader.GetSafeInt32(startingIndex++);
p.Tagline = reader.GetSafeString(startingIndex++);
p.CardTemplate = reader.GetSafeString(startingIndex++);
p.Id = reader.GetSafeString(startingIndex++);
p.Email = reader.GetSafeString(startingIndex++);
p.EmailConfirmed = reader.GetSafeBool(startingIndex++);
p.SecurityStamp = reader.GetSafeString(startingIndex++);
p.PhoneNumber = reader.GetSafeString(startingIndex++);
p.PhoneNumberConfirmed = reader.GetSafeBool(startingIndex++);
p.TwoFactorEnabled = reader.GetSafeBool(startingIndex++);
p.LockoutEndDateUtc = reader.GetSafeDateTime(startingIndex++);
p.LockoutEnabled = reader.GetSafeBool(startingIndex++);
p.AccessFailedCount = reader.GetSafeInt32(startingIndex++);
p.UserName = reader.GetSafeString(startingIndex++);
Medias m = new Medias();
m.MediasTableId = reader.GetSafeInt32(startingIndex++);
m.CreatedDate = reader.GetSafeDateTime(startingIndex++);
m.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
m.MediaType = reader.GetSafeEnum <MediaType>(startingIndex++);
m.ContentType = reader.GetSafeString(startingIndex++);
m.UserId = reader.GetSafeString(startingIndex++);
m.FilePath = reader.GetSafeString(startingIndex++);
if (m.MediasTableId > 0)
{
p.Avatar = m;
}
Medias t = new Medias();
t.MediasTableId = reader.GetSafeInt32(startingIndex++);
t.CreatedDate = reader.GetSafeDateTime(startingIndex++);
t.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
t.MediaType = reader.GetSafeEnum <MediaType>(startingIndex++);
t.ContentType = reader.GetSafeString(startingIndex++);
t.UserId = reader.GetSafeString(startingIndex++);
t.FilePath = reader.GetSafeString(startingIndex++);
if (t.MediasTableId > 0)
{
p.Theme = t;
}
Location l = new Location();
l.Id = reader.GetSafeInt32(startingIndex++);
l.Latitude = reader.GetSafeDecimal(startingIndex++);
l.Longitude = reader.GetSafeDecimal(startingIndex++);
l.Address = reader.GetSafeString(startingIndex++);
l.City = reader.GetSafeString(startingIndex++);
l.State = reader.GetSafeString(startingIndex++);
l.ZipCode = reader.GetSafeString(startingIndex++);
if (l.Id > 0)
{
p.Location = l;
}
p.Tags = new List <Tags>();
p.ExternalAccounts = new List <UserExternalAccounts>();
}
else if (set == 1)
{
Tags myTags = new Tags();
myTags.Id = reader.GetSafeInt32(startingIndex++);
myTags.CreatedDate = reader.GetDateTime(startingIndex++);
myTags.ModifiedDate = reader.GetDateTime(startingIndex++);
myTags.TagName = reader.GetSafeString(startingIndex++);
myTags.TagSlug = reader.GetSafeString(startingIndex++);
myTags.ParentTagId = reader.GetSafeInt32(startingIndex++);
p.Tags.Add(myTags);
}
else if (set == 2)
{
UserExternalAccounts myAccounts = new UserExternalAccounts();
myAccounts.source = reader.GetSafeString(startingIndex++);
myAccounts.url = reader.GetSafeString(startingIndex++);
p.ExternalAccounts.Add(myAccounts);
}
}
);
return(p);
}
