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(); } }