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