internal static void MakeBasicContractUserForCache(contract.User user, model.User eUser) { user.Email = eUser.Email; user.Name = eUser.Name; user.UserID = eUser.UserID; user.MobileNumber = utility.Security.Decrypt(eUser.MobileNumber); }
internal static void DiscardAuthDetails(model.User userEntity) { //throw new NotImplementedException(); userEntity.FBAuthID = string.Empty; userEntity.FBID = string.Empty; userEntity.LiveID = string.Empty; }
internal static void FillEntityUser(model.User ReUser, contract.User userInst) { ReUser.Name = userInst.Name; ReUser.Email = userInst.Email; ReUser.MobileNumber = utility.Security.Encrypt(userInst.MobileNumber); ReUser.FBAuthID = userInst.FBAuthID; ReUser.FBID = userInst.FBID; if (userInst.LiveDetails != null) { ReUser.LiveID = userInst.LiveDetails.LiveID; } }
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); }
public async Task <ResultInfo> AssignBuddyToMarshal(string AdminID, string groupID, string marshalProfileID, string marshalUserID, string targetUserProfileID) { int GroupID = Convert.ToInt32(groupID); long MarshalProfileID = Convert.ToInt64(marshalProfileID); long MarshalUserID = Convert.ToInt64(marshalUserID); long TargetUserProfileID = Convert.ToInt64(targetUserProfileID); var result = new ResultInfo(); try { if (string.IsNullOrEmpty(AdminID) || GroupID == 0 || MarshalProfileID == 0 || MarshalUserID == 0 || TargetUserProfileID == 0) { result.ResultType = ResultTypeEnum.Error; result.Message = "Marshal Not assigned Buddy List.Invalid IDs !"; } else if (MarshalValidationsForBuddy(AdminID, GroupID, MarshalProfileID, TargetUserProfileID, true)) { //right people fall under right places. model.User marshalUser = await _MemberRepository.GetUserByUserIDAsync(MarshalUserID); if (marshalUser != null) { var buddy = new model.Buddy { ProfileID = TargetUserProfileID, UserID = marshalUser.UserID, BuddyName = marshalUser.Name, MobileNumber = marshalUser.MobileNumber, Email = marshalUser.Email, State = model.BuddyState.Marshal, SubscribtionId = Guid.NewGuid() }; bool isBuddyAdded = await _MemberRepository.AddBuddyAsync(buddy); if (isBuddyAdded) { result.ResultType = ResultTypeEnum.Success; result.Message = "Marshal added as a Buddy !"; } } else { result.ResultType = ResultTypeEnum.Error; result.Message = "Marshal Not Added as a Buddy.Invalid MarshalUserIDs !"; } } else { result.ResultType = ResultTypeEnum.Error; result.Message = "Marshal Not Added as a Buddy.Invalid IDs !"; } } catch (Exception e) { result.ResultType = ResultTypeEnum.Exception; result.Message = "Failed-" + e.Message; } return(result); }
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(); } }