public string forgotPassword(UserDetailEntity userDetail)
{
var password = "";
password = adminData.forgotPassword(userDetail);
return(password);
}
public async Task <UserDetailEntity> AddUserDetail(UserDetailEntity entityUserDetail)
{
UserDetail _Data = _repositoryUD.Get(x => x.UserId == entityUserDetail.UserId);
if (_Data != null)
{
_Data.UserDeviceToken = entityUserDetail.UserDeviceToken;
_repositoryUD.UpdateAsync(_Data);
var oResultD = _unitOfWork.SaveChanges();
return(_mapperFactory.Get <UserDetail, UserDetailEntity>(_Data));
}
entityUserDetail.WalletAmount = 0;
entityUserDetail.ReferCode = Helper.GetReferralCode();
UserDetail oUser = _mapperFactory.Get <UserDetailEntity, UserDetail>(entityUserDetail);
_repositoryUD.AddAsync(oUser);
var oResult = await _unitOfWork.SaveChangesAsync();
if (oUser.UserId == 0)
{
throw new Exception(_messageService.GetString("AddFailed"));
}
return(_mapperFactory.Get <UserDetail, UserDetailEntity>(oUser));
}
/// <summary>
/// Stores or update user detail in storage.
/// </summary>
/// <param name="entity">Holds user entity data.</param>
/// <returns>A task that represents user entity data is saved or updated.</returns>
private async Task <TableResult> StoreOrUpdateEntityAsync(UserDetailEntity entity)
{
await this.EnsureInitializedAsync();
TableOperation addOrUpdateOperation = TableOperation.InsertOrReplace(entity);
return(await this.CloudTable.ExecuteAsync(addOrUpdateOperation));
}
public async Task <UserDetailEntity> UpdateUserDetail(UserDetailEntity entityUserDetail)
{
UserDetail oUserDetail = new UserDetail();
oUserDetail = _mapperFactory.Get <UserDetailEntity, UserDetail>(entityUserDetail);
_repositoryUD.UpdateAsync(oUserDetail);
var oResult = await _unitOfWork.SaveChangesAsync();
var dd = UpdatePartialDeviceToken(entityUserDetail);
return(_mapperFactory.Get <UserDetail, UserDetailEntity>(oUserDetail));
}
public UserDetailEntity UpdatePartialDeviceToken(UserDetailEntity entityUserDetail)
{
var data = _repositoryUD.Get(x => x.UserDeviceToken.ToLowerInvariant() == entityUserDetail.UserDeviceToken.ToLowerInvariant());
if (data != null)
{
data.UserDeviceToken = string.Empty;
_repositoryUD.UpdateAsync(data);
var oResultD = _unitOfWork.SaveChanges();
return(_mapperFactory.Get <UserDetail, UserDetailEntity>(data));
}
return(null);
}
/// <summary>
/// Adds a user entity in storage.
/// </summary>
/// <param name="userConversationId">User conversation id.</param>
/// <param name="userAadObjectId">Azure Active Directory id of the user.</param>
/// <param name="servicePath">Service URL for a tenant.</param>
/// <returns>A <see cref="Task"/> representing the asynchronous operation.</returns>
public async Task AddUserDetailAsync(
string userConversationId,
string userAadObjectId,
string servicePath)
{
var userDetailEntity = new UserDetailEntity
{
UserAadObjectId = userAadObjectId,
RowKey = userAadObjectId,
UserConversationId = userConversationId,
ServiceUrl = servicePath,
};
await this.UpsertUserDetailAsync(userDetailEntity);
}
public IHttpActionResult AddUser(RegisterRequest request)
{
if (request == null)
{
return(this.Ok(ErrorCodes.ErrorInvalidParameters));
}
else if (this.userService.UserNameAlreadyExists(request.Username))
{
return(this.Ok(ErrorCodes.ErrorUsernameIsTaken));
}
var userEntity = new UserEntity()
{
Username = request.Username,
Password = request.Password,
Email = request.Email
};
var userDetail = new UserDetailEntity()
{
FirstName = request.FirstName,
LastName = request.LastName,
Age = request.Age,
Sex = request.Sex
};
userEntity.UserDetails = userDetail;
var user = this.userService.AddUser(userEntity);
if (user.UserId > 0)
{
var emailResult = this.emailService.SendEmail(EmailTypeEnum.AccountCreationConfirmationEmail, request.Email);
if (emailResult.Equals("OK"))
{
return(this.Ok(user));
}
else
{
return(null);
}
}
else
{
return(this.Ok(ErrorCodes.ErrorUserNotAdded));
}
}
public void insertDetails(UserDetailEntity userDetailEntity)
{
userDetailEntity.UserId = Convert.ToInt32(Session["Id"]);
userDetailEntity.Gender = rbGender.Text;
userDetailEntity.FName = txtFName.Text;
userDetailEntity.MName = txtMName.Text;
userDetailEntity.LName = txtLName.Text;
userDetailEntity.DOB = Convert.ToDateTime(txtBOD.Text);
userDetailEntity.EMail = txtEmailId.Text;
userDetailEntity.UserType = txtUserType.Text;
userDetailEntity.MoblileNo = txtMobileNo.Text;
userDetailEntity.Apartment = txtAppartment.Text;;
userDetailEntity.Street = txtStreet.Text;
userDetailEntity.City = txtCity.Text;
userDetailEntity.PinCode = txtPincode.Text;
pb.insertDetails(userDetailEntity);
}
protected void Page_Load(object sender, EventArgs e)
{
rptRSS.DataSource = adminBusiness.admindata();
rptRSS.DataBind();
int userId;
if (!IsPostBack)
{
if (Session["Mail"] == null)
{
Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetNoStore();
Response.Redirect("Login.aspx");
}
userId = Convert.ToInt32(Session["Id"]);
userDetailEntity = adminBusiness.userName(userId);
if (userDetailEntity != null)
{
lblUserName.Text = userDetailEntity.FName + " " + userDetailEntity.LName;
}
else
{
lblUserName.Text = Session["Mail"].ToString();
}
if (Session["Mail"].ToString() == "*****@*****.**")
{
Analytic.Visible = true;
}
else
{
Analytic.Visible = false;
}
}
//if (Convert.ToBoolean(Session["AccountManager"]) == true)
//{
// Analytic.Visible = true;
// lblUserName.Text = userName;
//}
//else
//{
// Analytic.Visible = false;
//}
}
/// <summary>
/// Method updates user details.
/// </summary>
/// <param name="userDetailEntity">User details</param>
/// <returns>1 or 0</returns>
public int UpdateUserDetails(UserDetailEntity userDetailEntity)
{
int result;
try
{
using (var stockDbEntities = new StockDBEntities())
{
IRepository <user> userRepository = new Repository <user, DbContext>(stockDbEntities);
result = UpdateUserDetails(userDetailEntity, userRepository);
}
}
catch (Exception e)
{
// TODO: Logger to be added
throw;
}
return(result);
}
public void updateData(UserDetailEntity userDetailEntity)
{
var query = (from s in db.UserDetails
where s.UserDetailId == userDetailEntity.UserDetailId
select s).FirstOrDefault();
query.UserId = userDetailEntity.UserId;
query.Gender = userDetailEntity.Gender;
query.FName = userDetailEntity.FName;
query.MName = userDetailEntity.MName;
query.LName = userDetailEntity.LName;
query.MobileNo = userDetailEntity.MoblileNo;
query.DOB = userDetailEntity.DOB;
query.UserType = userDetailEntity.UserType;
query.EMail = userDetailEntity.EMail;
query.Appartment = userDetailEntity.Apartment;
query.City = userDetailEntity.City;
query.Street = userDetailEntity.Street;
query.Pincode = userDetailEntity.PinCode;
db.SubmitChanges();
}
public string forgotPassword(UserDetailEntity userEntity)
{
var password = "";
var forgot = (from s in db.UserDetails
where s.EMail == userEntity.EMail &&
s.MobileNo == userEntity.MoblileNo
select s).FirstOrDefault();
if (forgot != null)
{
var fetchpass = (from s in db.Users
where s.UserId == forgot.UserId
select s).FirstOrDefault();
password = fetchpass.Password;
}
return(password);
}
/// <summary>
/// Method updates user details.
/// </summary>
/// <param name="userDetailEntity">User Detail Entity</param>
/// <param name="userRepository">User repository</param>
/// <returns>1 or -1</returns>
public int UpdateUserDetails(UserDetailEntity userDetailEntity, IRepository <user> userRepository)
{
int result;
IQueryable <user> userList = userRepository.FindBy(UtilityAdapter.BuildUserExistPredicate(userDetailEntity.UserId));
user userDetailData = userList.First();
//No records for given userid
if (userDetailData == null)
{
return(Constants.MinusOne);
}
if (userDetailData.userdetail != null)
{
userDetailData.userdetail.AnnualIncome = userDetailEntity.AnnualIncome;
userDetailData.userdetail.DateModified = DateTime.Now;
userDetailData.userdetail.EducationLevel = userDetailEntity.EducationLevel;
userDetailData.userdetail.EmploymentStatus = userDetailEntity.EmploymentStatus;
userDetailData.userdetail.NetWorth = userDetailEntity.NetWorth;
userDetailData.userdetail.SourceOfFunds = userDetailEntity.SourceOfFunds;
result = userRepository.Update(userDetailData);
}
else
{
// Inserting new record in UserDetails table
userDetailData.userdetail = new userdetail
{
ActiveIndicator = Constants.DbActive,
AnnualIncome = userDetailEntity.AnnualIncome,
DateCreated = DateTime.Now,
EducationLevel = userDetailEntity.EducationLevel,
EmploymentStatus = userDetailEntity.EmploymentStatus,
NetWorth = userDetailEntity.NetWorth,
SourceOfFunds = userDetailEntity.SourceOfFunds,
};
// Updating Users table with recent UserDetailID
result = userRepository.Update(userDetailData);
}
return(result);
}
public void maintainData(UserDetailEntity userDetailEntity)
{
var query = (from s in db.UserDetails
where s.UserId == userDetailEntity.UserId
select s).FirstOrDefault();
if (query != null)
{
userDetailEntity.UserDetailId = query.UserDetailId;
userDetailEntity.Gender = query.Gender;
userDetailEntity.FName = query.FName;
userDetailEntity.MName = query.MName;
userDetailEntity.LName = query.LName;
userDetailEntity.MoblileNo = query.MobileNo;
userDetailEntity.DOB = query.DOB;
userDetailEntity.UserType = query.UserType;
userDetailEntity.EMail = query.EMail;
userDetailEntity.Apartment = query.Appartment;
userDetailEntity.City = query.City;
userDetailEntity.Street = query.Street;
userDetailEntity.PinCode = query.Pincode;
}
}
/// <summary>
/// Method gets user details for given user id.
/// </summary>
/// <param name="userId">User id</param>
/// <param name="userRepository">User repository</param>
/// <returns>User details</returns>
public UserDetailEntity GetUserDetails(int userId, IRepository <user> userRepository)
{
UserDetailEntity userDetailEntity = null;
Expression <Func <user, bool> > predicate =
userData => userData.UserID == userId && userData.ActiveIndicator == Constants.DbActive &&
userData.userdetail != null;
IQueryable <user> userList = userRepository.FindBy(predicate);
if (userList.Any())
{
user userData = userList.First();
userDetailEntity = new UserDetailEntity
{
UserId = userData.UserID,
AnnualIncome = userData.userdetail.AnnualIncome,
EducationLevel = userData.userdetail.EducationLevel,
EmploymentStatus = userData.userdetail.EmploymentStatus,
NetWorth = userData.userdetail.NetWorth,
SourceOfFunds = userData.userdetail.SourceOfFunds,
UserDetailId = userData.userdetail.UserDetailId
};
}
return(userDetailEntity);
}
/// <summary>
/// Stores or update user details data in storage.
/// </summary>
/// <param name="entity">Holds user entity data.</param>
/// <returns>A task that represents user entity data is saved or updated.</returns>
private async Task <bool> UpsertUserDetailAsync(UserDetailEntity entity)
{
var result = await this.StoreOrUpdateEntityAsync(entity);
return(result.HttpStatusCode == (int)HttpStatusCode.NoContent);
}
public void updateData(UserDetailEntity userDetailEntity)
{
pd.updateData(userDetailEntity);
}
public void maintainData(UserDetailEntity userDetailEntity)
{
pd.maintainData(userDetailEntity);
}
public void insertDetail(UserDetailEntity userEntity)
{
user.UserId = userEntity.UserId;
user.Gender = userEntity.Gender;
user.FName = userEntity.FName;
user.MName = userEntity.MName;
user.LName = userEntity.LName;
user.MobileNo = userEntity.MoblileNo;
user.DOB = userEntity.DOB;
user.UserType = userEntity.UserType;
user.EMail = userEntity.EMail;
user.Appartment = userEntity.Apartment;
user.Street = userEntity.Street;
user.City = userEntity.City;
user.Pincode = userEntity.PinCode;
db.UserDetails.InsertOnSubmit(user);
db.SubmitChanges();
//var qurey=(from a in db.Addresses
// join u in db.UserDetails on a.AddressId equals u.AddressId
// select new AddressEntity()
// {
// AddressId=a.AddressId,
// userDetail=new UserDetailEntity()
// {
// Gender=u.Gender,
// FName=u.FName,
// MName=u.MName,
// LName=u.LName,
// DOB=u.DOB,
// UserType=u.UserType,
// MoblileNo=u.MobileNo
// }
// });
//userDetail.Gender = userDetailEntity.Gender;
//userDetail.FName = userDetailEntity.FName;
//userDetail.MName = userDetailEntity.MName;
//userDetail.LName = userDetailEntity.LName;
//userDetail.DOB = userDetailEntity.DOB;
//userDetail.UserType = userDetailEntity.UserType;
//userDetail.MobileNo = userDetailEntity.MoblileNo;
//db.UserDetails.InsertOnSubmit(userDetail);
//db.SubmitChanges();
//var query = (from u in db.Users
// join a in db.Addresses on u.UserId equals a.UserId
// where u.UserId == userDetailEntity.UserId
// select new UserDetailEntity()
// {
// UserId = u.UserId,
// AddressDetails = new AddressEntity()
// {
// UserId = a.UserId,
// Apartment = a.Apartment,
// City = a.City,
// Street = a.Street,
// PinCode = a.PinCode
// }
// });
// address.Apartment = addressEntity.Apartment;
// address.Street = addressEntity.Street;
// address.City = addressEntity.City;
// address.PinCode = addressEntity.PinCode;
// }
}
public ActionResult ManageUser(int page = 1, int PageSize = 5, string searchString = "", string sort = "", string sortdir = "ASC", string message = "")
{
_userServices = new UserDetailServices();
ViewBag.sortdir = "ASC" == sortdir ? "DESC" : "ASC";
sort = String.IsNullOrEmpty(sort) ? "CreatedDate" : sort;
var userDetail = _userServices.GetAllUsers();
if (userDetail != null)
{
switch (sort)
{
case "Name":
if (sortdir == "DESC")
{
userDetail = userDetail.OrderByDescending(tes => tes.Name);
}
else
{
userDetail = userDetail.OrderBy(tes => tes.Name);
}
break;
case "PhoneNumber":
if (sortdir == "DESC")
{
userDetail = userDetail.OrderByDescending(tes => tes.PhoneNumber);
}
else
{
userDetail = userDetail.OrderBy(tes => tes.PhoneNumber);
}
break;
case "Address":
if (sortdir == "DESC")
{
userDetail = userDetail.OrderByDescending(tes => tes.Address);
}
else
{
userDetail = userDetail.OrderBy(tes => tes.Address);
}
break;
case "Email":
if (sortdir == "DESC")
{
userDetail = userDetail.OrderByDescending(tes => tes.Email);
}
else
{
userDetail = userDetail.OrderBy(tes => tes.Email);
}
break;
default:
userDetail = userDetail.OrderByDescending(tes => tes.Name);
break;
}
if (!String.IsNullOrEmpty(searchString))
{
userDetail = userDetail.Where(p => p.Address != null && p.Name != null && p.PhoneNumber != null).ToList();
userDetail = userDetail.Where(s => (s.Name.ToUpper().Contains(searchString.ToUpper()) || s.PhoneNumber.ToUpper().Contains(searchString.ToUpper()) || s.Address.ToUpper().Contains(searchString.ToUpper())));
}
UserDetailEntity model = new UserDetailEntity();
var userlist = userDetail.Skip((page - 1) * PageSize).Take(PageSize).ToList();
if (userlist.Count > 0)
{
model.lstUser = userlist;
}
else
{
model.lstUser = null;
}
ViewBag.Message = message;
ViewBag.CurrentPage = page;
ViewBag.PageSize = PageSize;
ViewBag.TotalPages = Math.Ceiling((double)userDetail.Count() / PageSize);
model.Total = userDetail.Count();
return(View(model));
}
return(View());
}
public void insertDetails(UserDetailEntity userEntity)
{
pd.insertDetail(userEntity);
}
