internal static void FillProfileEntity(model.Profile pe, contract.Profile profile, bool RestrictPhone)
{
if (profile == null || pe == null)
{
return;
}
pe.UserID = profile.UserID;
pe.ProfileID = profile.ProfileID;
if (profile.PhoneSetting == null)
{
profile.PhoneSetting = new contract.DeviceSetting();
}
if (!RestrictPhone)
{
pe.MobileNumber = utility.Security.Encrypt(profile.MobileNumber);
pe.SecurityToken = profile.SecurityToken;
}
pe.CanEmail = profile.CanMail;
pe.CanPost = profile.CanPost;
pe.IsValid = profile.IsValid;
pe.RegionCode = profile.RegionCode;
pe.CanSMS = profile.CanSMS;
pe.LocationConsent = profile.LocationConsent;
if (profile.PhoneSetting != null)
{
pe.DeviceID = profile.PhoneSetting.DeviceID;
pe.DeviceType = GetDeviceType(profile.PhoneSetting.PlatForm);
}
//Filled in Fill FBDetails
pe.FBGroup = profile.FBGroupName;
pe.FBGroupID = profile.FBGroupID;
pe.EnterpriseSecurityToken = profile.EnterpriseSecurityToken;
pe.EnterpriseEmailID = profile.EnterpriseEmailID;
pe.NotificationUri = profile.NotificationUri;
}
internal static contract.ProfileLite MakeProfileLiteOnCombination(model.Profile profileEntity,
model.User userEntity)
{
if (profileEntity == null || userEntity == null)
{
return(null);
}
var retProfile = new contract.ProfileLite
{
ProfileID = profileEntity.ProfileID,
Email = userEntity.Email,
MobileNumber = utility.Security.Decrypt(profileEntity.MobileNumber ?? profileEntity.User.MobileNumber),
Name = userEntity.Name,
UserID = profileEntity.UserID,
};
return(retProfile);
}
internal static contract.Profile MakeContractProfile(model.Profile profileEntity, model.User userEntity,
List <contract.Group> groupsAsociated, List <model.Buddy> buddies, List <contract.ProfileLite> LocateBuds)
{
if (profileEntity == null)
{
return(null);
}
var retProfile = new contract.Profile();
retProfile.ProfileID = profileEntity.ProfileID;
retProfile.UserID = profileEntity.UserID;
retProfile.Name = userEntity.Name;
retProfile.Email = userEntity.Email;
retProfile.MobileNumber = (string.IsNullOrEmpty(utility.Security.Decrypt(profileEntity.MobileNumber)))
? utility.Security.Decrypt(userEntity.MobileNumber)
: utility.Security.Decrypt(profileEntity.MobileNumber);
retProfile.CanPost = profileEntity.CanPost;
retProfile.CanMail = profileEntity.CanEmail;
retProfile.CanSMS = profileEntity.CanSMS;
retProfile.IsValid = profileEntity.IsValid;
retProfile.LocationConsent = profileEntity.LocationConsent;
retProfile.RegionCode = profileEntity.RegionCode;
retProfile.LiveDetails = new contract.LiveCred
{
LiveID = userEntity.Email
};
retProfile.FBAuthID = userEntity.FBAuthID;
retProfile.FBID = userEntity.FBID;
retProfile.FBGroupName = profileEntity.FBGroup;
retProfile.FBGroupID = profileEntity.FBGroupID;
List <contract.Buddy> buddys = null;
if (buddies != null && buddies.Count > 0)
{
buddys = new List <contract.Buddy>();
foreach (model.Buddy bud in buddies)
{
buddys.Add(new contract.Buddy
{
BuddyID = bud.BuddyID,
//RelProfileID = bud.ProfileID,
Name = bud.BuddyName,
UserID = bud.UserID,
Email = bud.Email,
MobileNumber = utility.Security.Decrypt(bud.MobileNumber),
IsPrimeBuddy = bud.IsPrimeBuddy,
State = (contract.BuddyState)(bud.State),
SubscribtionID = bud.SubscribtionId
});
}
}
else
{
buddys = null;
}
retProfile.AscGroups = groupsAsociated;
retProfile.MyBuddies = buddys;
retProfile.LocateBuddies = LocateBuds;
return(retProfile);
}
private void InsertUsersAndProfilesUsingSQLClient()
{
string cs = Config.AzureSQLConnectionString;
SqlConnection con = null;
SqlCommand cmd = null;
try
{
con = new SqlConnection(cs);
for (int index = 0; index < 500000; index++)
{
model.User user = new model.User()
{
UserID = index + 1,
Name = "Guardian" + index,
Email = string.Format("Guardian{0}@live.com", index),
MobileNumber = SOS.Service.Utility.Security.Encrypt("123456768"),
LastModifiedBy = "User" + index,
LastModifiedDate = DateTime.Now,
};
cmd = new SqlCommand("RadomUserInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = user.Name;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = user.Email;
cmd.Parameters.Add("@MobileNumber", SqlDbType.NVarChar).Value = user.MobileNumber;
cmd.Parameters.Add("@FBAuthID", SqlDbType.NVarChar).Value = user.FBAuthID;
cmd.Parameters.Add("@FBID", SqlDbType.NVarChar).Value = user.FBID;
cmd.Parameters.Add("@LiveID", SqlDbType.NVarChar).Value = user.LiveID;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = user.CreatedBy;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = user.CreatedDate;
cmd.Parameters.Add("@LastModifiedDate", SqlDbType.DateTime).Value = user.LastModifiedDate;
cmd.Parameters.Add("@LastModifiedBy", SqlDbType.NVarChar).Value = user.LastModifiedBy;
con.Open();
cmd.ExecuteNonQuery();
// cmd = new SqlCommand(@"INSERT INTO [dbo].[User] (Name,Email ,MobileNumber,FBAuthID,FBID,LiveID,LiveAuthID,LiveAccessToken,LiveRefreshToken,CreatedBy,CreatedDate,LastModifiedDate,LastModifiedBy)
// VALUES('" + user.Name + "','" + user.Email + "','" + user.MobileNumber + "','" + user.FBAuthID + "','" + user.FBID
// + "','" + user.LiveID + "','" + user.LiveAuthID + "','" + user.LiveAccessToken + "','" + user.LiveRefreshToken
// + "','" + user.CreatedBy + "','" + user.CreatedDate + "','" + user.LastModifiedBy + "','" + user.LastModifiedDate+ "')", con);
con.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex) { }
finally
{
con.Close();
}
try
{
con = new SqlConnection(cs);
for (int index = 0; index < 100000; index++)
{
model.Profile profile = new model.Profile()
{
UserID = 34134132434,
ProfileID = 5,
MobileNumber = "123456788",
CanEmail = false,
CanPost = false,
IsValid = false,
RegionCode = "+91",
CanSMS = false,
LocationConsent = false,
LastModifiedBy = "ramg",
LastModifiedDate = DateTime.Now,
};
cmd = new SqlCommand("RadomProfileInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@UserID", SqlDbType.BigInt).Value = profile.UserID;
cmd.Parameters.Add("@MobileNumber", SqlDbType.NVarChar).Value = profile.MobileNumber;
cmd.Parameters.Add("@RegionCode", SqlDbType.NVarChar).Value = profile.RegionCode;
cmd.Parameters.Add("@DeviceID", SqlDbType.NVarChar).Value = profile.DeviceID;
cmd.Parameters.Add("@DeviceType", SqlDbType.Int).Value = profile.DeviceType;
cmd.Parameters.Add("@FBGroup", SqlDbType.NVarChar).Value = profile.FBGroup;
cmd.Parameters.Add("@FBGroupID", SqlDbType.NVarChar).Value = profile.FBGroupID;
cmd.Parameters.Add("@CanPost", SqlDbType.Bit).Value = profile.CanPost;
cmd.Parameters.Add("@CanSMS", SqlDbType.Bit).Value = profile.CanSMS;
cmd.Parameters.Add("@CanEmail", SqlDbType.Bit).Value = profile.CanEmail;
cmd.Parameters.Add("@SecurityToken", SqlDbType.NVarChar).Value = profile.SecurityToken;
cmd.Parameters.Add("@LocationConsent", SqlDbType.Bit).Value = profile.LocationConsent;
cmd.Parameters.Add("@IsValid", SqlDbType.Bit).Value = profile.IsValid;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = profile.CreatedDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = profile.CreatedBy;
cmd.Parameters.Add("@LastModifiedDate", SqlDbType.DateTime).Value = profile.LastModifiedDate;
cmd.Parameters.Add("@LastModifiedBy", SqlDbType.NVarChar).Value = profile.LastModifiedBy;
con.Open();
cmd.ExecuteNonQuery();
// cmd = new SqlCommand(@"INSERT INTO [dbo].[User] (Name,Email ,MobileNumber,FBAuthID,FBID,LiveID,LiveAuthID,LiveAccessToken,LiveRefreshToken,CreatedBy,CreatedDate,LastModifiedDate,LastModifiedBy)
// VALUES('" + user.Name + "','" + user.Email + "','" + user.MobileNumber + "','" + user.FBAuthID + "','" + user.FBID
// + "','" + user.LiveID + "','" + user.LiveAuthID + "','" + user.LiveAccessToken + "','" + user.LiveRefreshToken
// + "','" + user.CreatedBy + "','" + user.CreatedDate + "','" + user.LastModifiedBy + "','" + user.LastModifiedDate+ "')", con);
con.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex) { }
finally
{
con.Close();
}
}
