public ActionResult UserProfile(UserDetail UsersModel)
{
try
{
if (ModelState.IsValid)
{
var imageUpdate = "";
if (UsersModel.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(UsersModel.ImageUpload.FileName);
string extension = Path.GetExtension(UsersModel.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
UsersModel.ImagePath = "~/AppFiles/Images/" + fileName;
UsersModel.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
else
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
imageUpdate = db.UsersDetails.Where(s => s.UserId == WebSecurity.CurrentUserId).Select(s => s.ImagePath).FirstOrDefault();
}
}
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
if (UsersModel.ImageUpload == null)
{
UsersModel.ImagePath = imageUpdate;
}
UsersModel.UserId = WebSecurity.CurrentUserId;
UsersDetail ud = new UsersDetail();
ud.UserDetailId = UsersModel.UserDetailId;
ud.UserId = UsersModel.UserId;
ud.FirstName = UsersModel.FirstName;
ud.LastName = UsersModel.LastName;
ud.Email = UsersModel.Email;
ud.Mobile = UsersModel.Mobile;
ud.UserAddress = UsersModel.UserAddress;
ud.About = UsersModel.About;
ud.ImagePath = UsersModel.ImagePath;
db.Entry(ud).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ViewBag.Message = "Your profile has been updated!";
}
}
else
{
return(View(UsersModel));
}
return(View(UsersModel));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public void AddUsers(UsersDetail userDetail)
{
var selectUser = (from user in _db.Users
where user.UserName == userDetail.UserName
select user).FirstOrDefault();
if (selectUser == null)
{
var addUsers = new Users
{
UserName = userDetail.UserName,
Password = userDetail.Password,
RoleID = userDetail.RoleID
};
_db.Users.Add(addUsers);
_db.SaveChanges();
var employeeDetail = (from emp in _db.Employees
where emp.EmployeeId == userDetail.EmployeeId
select emp).FirstOrDefault();
if (employeeDetail.EmployeeId != 0 && employeeDetail.IsWorking == false)
{
employeeDetail.UserID = addUsers.UserID;
employeeDetail.IsWorking = true;
_db.Employees.Update(employeeDetail);
_db.SaveChanges();
}
}
}
private async void UserControl_Loaded(object sender, RoutedEventArgs e)
{
if (_userID > 0)
{
await Task.Run(() =>
{
User = UserRepo.FindByID(_userID);
});
await Task.Run(() =>
{
UserDetail = UserDetailRepo.FindByUserID(_userID);
});
await Task.Run(() =>
{
ExperienceList = ExperienceRepo.FindByUserID(_userID);
});
await Task.Run(() =>
{
EducationList = EducationRepo.FindByUserID(_userID);
});
}
}
public ActionResult DirectByMemberId(string memberId)
{
if (memberId == "" || memberId == String.Empty)
{
return(RedirectToAction("Direct"));
}
ViewBag.Title = "Admin: Direct Team";
UserPersonalListModelView userPersonalListModelView = new UserPersonalListModelView();
userPersonalListModelView.PersonalDetail = _valleyDreamsIndiaDBEntities.PersonalDetails.First(x => x.UsersDetailsId == CurrentUser.CurrentUserId && x.Deleted == 0);
GetUserInfo(CurrentUser.CurrentUserId);
try
{
UsersDetail userDetail = _valleyDreamsIndiaDBEntities.UsersDetails.Where(x => x.UserName == memberId).FirstOrDefault();
List <PersonalDetail> personalDetailList = _valleyDreamsIndiaDBEntities.PersonalDetails
.Where(x => x.SponsoredId == CurrentUser.CurrentUserId &&
x.LegId != CurrentUser.CurrentUserId && x.UsersDetailsId == userDetail.Id).ToList();
userPersonalListModelView.PersonalDetails = personalDetailList;
}
catch (Exception e) {
userPersonalListModelView.PersonalDetails = null;
}
return(View("~/Views/Members/Team/Direct.cshtml", userPersonalListModelView));
}
public Response Login(Login Lg)
{
UsersDetail Obj = _context.UsersDetail.FromSql("EXEC Usp_Login @UserName={0}, @Password={1}", Lg.UserName, Lg.Password).FirstOrDefault();
if (Obj.Status == 0)
{
return new Response {
Status = "Invalid", Message = "Invalid User."
}
}
;
if (Obj.Status == -1)
{
return new Response {
Status = "Inactive", Message = "User Inactive."
}
}
;
else
{
return new Response {
Status = "Success", Message = Lg.UserName
}
};
}
public ActionResult Register(UserRegister registerModel)
{
GetRolesForCurrentUsers();
if (ModelState.IsValid)
{
using (WorkFlowDbContext db = new WorkFlowDbContext())
{
bool isUserExist = WebSecurity.UserExists(registerModel.UserName);
if (isUserExist)
{
ModelState.AddModelError("UserName", "UserName already exist");
}
else
{
registerModel.Account = registerModel.Role;
WebSecurity.CreateUserAndAccount(registerModel.UserName, registerModel.Password, new { registerModel.Account, status = 1 });
Roles.AddUserToRole(registerModel.UserName, registerModel.Role);
var userid = (db.Users.OrderByDescending(s => s.UserId).Select(s => s.UserId)).FirstOrDefault();
UsersDetail userModel = new UsersDetail();
userModel.UserId = userid;
db.UsersDetails.Add(userModel);
db.SaveChanges();
ViewBag.Message = "User Added";
}
}
}
return(View());
}
public object createcontact(Registration Lvm)
{
try
{
UsersDetail Ud = new UsersDetail();
if (Ud.UserId == 0)
{
Ud.UserName = Lvm.UserName;
Ud.LoginName = Lvm.LoginName;
Ud.Password = Lvm.Password;
Ud.Email = Lvm.Email;
Ud.ContactNo = Lvm.ContactNo;
Ud.Address = Lvm.Address;
Ud.IsApporved = Lvm.IsApporved;
Ud.Status = Lvm.Status;
_context.UsersDetail.Add(Ud);
_context.SaveChanges();
return(new Response
{
Status = "Success", Message = "SuccessFully Saved."
});
}
}
catch (Exception)
{
throw;
}
return(new Response
{
Status = "Error", Message = "Invalid Data."
});
}
public async Task <IActionResult> Edit(int id, [Bind("UserId,Username,Emailid,Address,Pincode,Password,Gender,Phone,Usertype,Cid,Sid,Cityid")] UsersDetail usersDetail)
{
if (id != usersDetail.UserId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(usersDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UsersDetailExists(usersDetail.UserId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Cid"] = new SelectList(_context.Tblcountries, "Cid", "Cid", usersDetail.Cid);
ViewData["Cityid"] = new SelectList(_context.TblCities, "Cityid", "Cityid", usersDetail.Cityid);
ViewData["Sid"] = new SelectList(_context.Tblstates, "Sid", "Sid", usersDetail.Sid);
return(View(usersDetail));
}
public JsonResult AddUser(UsersDetail user)
{
Common common = new Common();
Studio365Entities Entity = new Studio365Entities();
ResponseData responseData = new ResponseData()
{
ReturnType = common.ReturnTypeMessage
};
try
{
int existing = (from u in Entity.UsersDetails where u.MobileNumber == user.MobileNumber select u).Count();
if (existing == 0)
{
Entity.UsersDetails.Add(user);
Entity.SaveChanges();
responseData.Message = common.SuccessMessage;
}
else
{
responseData.Message = "Mobile Number Already Present";
}
}
catch (Exception ex)
{
responseData.Message = ex.Message.ToString();
}
return(Json(responseData, JsonRequestBehavior.AllowGet));
}
public async Task <bool> CreateAsync(UserDetailMessage request)
{
var copier = new ClassValueCopier();
UsersDetail users = copier.ConvertAndCopy <UsersDetail, UserDetailMessage>(request);
bool result = await _usersCollection.AddAsync(users);
return(result);
}
public ActionResult CreateMember(UsersPersonalModelView usersPersonalModelView)
{
UsersDetail userDetail = new UsersDetail();
userDetail.SponsoredId = CurrentUser.CurrentUserId;
userDetail.Password = Guid.NewGuid().ToString().Substring(0, 6);
userDetail.Deleted = 0;
userDetail.CreatedOn = DateTime.Now;
_valleyDreamsIndiaDBEntities.Entry(userDetail).State = EntityState.Added;
_valleyDreamsIndiaDBEntities.SaveChanges();
int legId = _valleyDreamsIndiaDBEntities.UsersDetails
.Where(x => x.UserName == usersPersonalModelView.UserDetails.UserName).FirstOrDefault().Id;
usersPersonalModelView.PersonalDetails.UsersDetailsId = userDetail.Id;
usersPersonalModelView.PersonalDetails.JoinedOn = DateTime.Now.ToString();
usersPersonalModelView.PersonalDetails.CreatedOn = DateTime.Now;
usersPersonalModelView.PersonalDetails.SponsoredId = CurrentUser.CurrentUserId;
usersPersonalModelView.PersonalDetails.LegId = legId;
usersPersonalModelView.PersonalDetails.Deleted = 0;
usersPersonalModelView.PersonalDetails.ProfilePic = "/UploadedTeamImages/default1_avatar_small.png";
_valleyDreamsIndiaDBEntities.PersonalDetails.Add(usersPersonalModelView.PersonalDetails);
_valleyDreamsIndiaDBEntities.SaveChanges();
usersPersonalModelView.BankDetails.UsersDetailsId = userDetail.Id;
usersPersonalModelView.BankDetails.CreatedOn = DateTime.Now;
usersPersonalModelView.BankDetails.TransactionPassword = Guid.NewGuid().ToString().Substring(0, 6);
usersPersonalModelView.BankDetails.Deleted = 0;
_valleyDreamsIndiaDBEntities.BankDetails.Add(usersPersonalModelView.BankDetails);
_valleyDreamsIndiaDBEntities.SaveChanges();
ContributionDetail contributionDetails = new ContributionDetail();
contributionDetails.ContribNumber = 1;
contributionDetails.ContribDate = DateTime.Now;
contributionDetails.ContribAmount = 1000;
contributionDetails.NextContribNumber = 2;
contributionDetails.NextContribDate = new DateTime(DateTime.Now.AddMonths(1).Year, DateTime.Now.AddMonths(1).Month, 20);
contributionDetails.RemainingContrib = 15 - 1;
contributionDetails.UserDetailsId = userDetail.Id;
contributionDetails.SponsoredId = CurrentUser.CurrentUserId;
contributionDetails.PayedBy = "ADMIN";
contributionDetails.IsCompleted = 0;
_valleyDreamsIndiaDBEntities.ContributionDetails.Add(contributionDetails);
_valleyDreamsIndiaDBEntities.SaveChanges();
password = userDetail.Password;
transactionpassword = usersPersonalModelView.BankDetails.TransactionPassword;
username = userDetail.UserName;
return(RedirectToAction("CreateMember"));
}
public UsersDetail FindByUserID(int id)
{
var users = FindByQuery(" UserID = " + id);
UsersDetail user = null;
foreach (var item in users)
{
user = item;
}
return(user);
}
public ActionResult Register([Bind(Include = "ID,Name,UserName,E_mail,Password")] UsersDetail usersDetail)
{
if (ModelState.IsValid)
{
db.UsersDetails.Add(usersDetail);
db.SaveChanges();
return(RedirectToAction("Success"));
}
return(View(usersDetail));
}
public ActionResult Update(UsersDetail usersDetail)
{
var UserInDb = _context.UsersDetails.SingleOrDefault(u => u.Id == usersDetail.Id);
UserInDb.UserName = usersDetail.UserName;
UserInDb.FullName = usersDetail.FullName;
UserInDb.PhoneNumber = usersDetail.PhoneNumber;
UserInDb.RoleId = Int32.Parse(Request.Form["RoleId"]);
UserInDb.UserPassword = encryptPassword(Request.Form["UserPassword"]);
_context.SaveChanges();
return(Redirect("~/home/UserAll"));
}
public ActionResult EditPassword(string OldPassword, string NewPassword, string ConfirmNewPassword)
{
ViewBag.TransactionErrorMessage = false;
try
{
if (NewPassword == ConfirmNewPassword)
{
UsersDetail usersDetail = _valleyDreamsIndiaDBEntities.UsersDetails.First(x => x.Id == CurrentUser.CurrentUserId && x.Deleted == 0);
if (usersDetail.Password == OldPassword)
{
usersDetail.Password = NewPassword;
usersDetail.UpdatedOn = DateTime.Now;
_valleyDreamsIndiaDBEntities.Entry(usersDetail).State = EntityState.Modified;
_valleyDreamsIndiaDBEntities.SaveChanges();
string phoneNumber = (usersDetail.PersonalDetails.Where(x => x.UsersDetailsId == CurrentUser.CurrentUserId).FirstOrDefault()).PhoneNumber1;
string textMessage = String.Format("Your new password is {0}", NewPassword);
string smsStatus = SmsProvider.SendSms(phoneNumber, textMessage);
if (smsStatus == "Success")
{
ViewBag.SmsStatus = "New Password Sent To Your Registered Mobile Number Successfully";
}
else
{
ViewBag.SmsStatus = "Sended Sms Failed";
}
ViewBag.ErrorMessage = true;
ViewBag.Error = "Password Updated";
return(View("~/Views/Members/User/Edit.cshtml"));
}
else
{
ViewBag.ErrorMessage = true;
ViewBag.Error = "Old Password Mismatched";
return(View("~/Views/Members/User/Edit.cshtml"));
}
}
else
{
ViewBag.ErrorMessage = true;
ViewBag.Error = "New And Confirm New Password Mismatched";
return(View("~/Views/Members/User/Edit.cshtml"));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private ActionResult TransferPinsData()
{
UsersDetail userDetail = _valleyDreamsIndiaDBEntities.UsersDetails.Where(x => x.Id == CurrentUser.CurrentUserId && x.Deleted == 0).FirstOrDefault();
PersonalDetail personalDetail = userDetail.PersonalDetails.First(x => x.UsersDetailsId == CurrentUser.CurrentUserId && x.Deleted == 0);
ViewBag.TotalJoiningPins = userDetail.UsersDetails1.Where(x => x.PinType == "NEW" && x.IsPinUsed == 0).Count();
ViewBag.TotalRenewPins = userDetail.RenewalPinDetails.Where(x => x.IsPinUsed == 0).Count();
if ((Convert.ToInt32(ViewBag.TotalJoiningPins) == 0) && (Convert.ToInt32(ViewBag.TotalRenewPins) == 0))
{
return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString()));
}
return(View("~/Views/Members/Wallet/Transfer.cshtml", new Tuple <UsersDetail, PersonalDetail>(userDetail, personalDetail)));
}
public JsonResult TeamCheckPins()
{
UsersDetail userDetail = _valleyDreamsIndiaDBEntities.UsersDetails.Where(x => x.Id == CurrentUser.CurrentUserId && x.Deleted == 0).FirstOrDefault();
int newPins = userDetail.UsersDetails1.Where(x => x.PinType == "NEW" && x.IsPinUsed == 0).Count();
if (newPins > 0)
{
return(Json("True", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("False", JsonRequestBehavior.AllowGet));
}
}
public async Task <Name> GetUserName(object request)
{
try
{
string request_ = (string)request;
UsersDetail user = await _usersCollection.GetAsync(request_);
return(user.Name);
}
catch
{
return(new Name());
}
}
public async Task <IActionResult> UpdateUsers([FromRoute] int id, [FromBody] UsersDetail employees)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employees.EmployeeId)
{
return(BadRequest());
}
_employee.AddUsers(employees);
return(Ok());
}
public async Task <IActionResult> Create([Bind("UserId,Username,Emailid,Address,Pincode,Password,Gender,Phone,Usertype,Cid,Sid,Cityid")] UsersDetail usersDetail)
{
if (ModelState.IsValid)
{
_context.Add(usersDetail);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["Cid"] = new SelectList(_context.Tblcountries, "Cid", "Cid", usersDetail.Cid);
ViewData["Cityid"] = new SelectList(_context.TblCities, "Cityid", "Cityid", usersDetail.Cityid);
ViewData["Sid"] = new SelectList(_context.Tblstates, "Sid", "Sid", usersDetail.Sid);
return(View(usersDetail));
}
public ActionResult InsertVendor(VendorDetail vendorDetail)
{
vendorDetail.UserName = Request.Form["uname"];
_context.VendorDetails.Add(vendorDetail);
_context.SaveChanges();
var uD = new UsersDetail();
uD.UserName = Request.Form["uname"];
uD.UserPassword = encryptPassword(Request.Form["upass"]);
uD.FullName = vendorDetail.Name;
uD.PhoneNumber = vendorDetail.PhoneNumber;
uD.RoleId = 6;
_context.UsersDetails.Add(uD);
_context.SaveChanges();
return(Redirect("~/Vendor/Index"));
}
public async Task <bool> UpdateDocumentAsync(object request)
{
// recive the request
UserDetailMessage request_ = (UserDetailMessage)request;
var copier = new ClassValueCopier();
UsersDetail oldUserCredentials = await _usersCollection.GetAsync(request_.ReferenceCode);
//update the credentials
UsersDetail updatedUsers = copier.ConvertAndCopy(request_, oldUserCredentials);
updatedUsers.LastUpdatedBy = request_.ReferenceCode;
updatedUsers.LastUpdatedAt = DateTime.Now.ToString();
//push to DB
bool result = await _usersCollection.UpdateAsync(updatedUsers);
return(result);
}
public async Task <bool> AddAsync(UsersDetail document)
{
try
{
Console.WriteLine(document);
document.CreatedAt = DateTime.Now.ToString();
document.LastUpdatedAt = "";
document.IsActive = true;
await _context.UsersDetailCollection.InsertOneAsync(document);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw ex;
}
}
public ActionResult Login(string Username, string Password)
{
UsersDetail userDetail = _valleyDreamsIndiaDBEntities.UsersDetails.Where(x => x.UserName == Username && x.Password == Password && x.Deleted == 0).FirstOrDefault();
if (userDetail != null)
{
FormsAuthentication.SetAuthCookie(userDetail.UserName, false);
var authTicket = new FormsAuthenticationTicket(1, userDetail.UserName, DateTime.Now, DateTime.Now.AddMinutes(20), false, userDetail.Id.ToString());
string encryptedTicket = FormsAuthentication.Encrypt(authTicket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
HttpContext.Response.Cookies.Add(authCookie);
return(RedirectToAction("Index", "Dashboard"));
}
else
{
ViewBag.ErrorMessage = true;
return(View("Index"));
}
}
public bool InsertUpdateUserDetails(UserModel model)
{
try
{
using (var con = new DirectoryEntities())
{
var userId = HttpContext.Current.User.Identity.GetUserId();
var user = con.UsersDetails.Where(x => x.Id == model.Id || x.UserId == userId).FirstOrDefault();
if (user != null)
{
user.FullName = model.FullName;
user.ContactNo = model.PhoneNo;
user.Email = model.Email;
if (model.Image != null)
{
user.Image = model.Image;
}
con.Entry(user).State = System.Data.Entity.EntityState.Modified;
}
else
{
UsersDetail usersDetail = new UsersDetail()
{
Id = Guid.NewGuid(),
FullName = model.FullName,
ContactNo = model.PhoneNo,
UserId = userId,
Email = model.Email,
Image = model.Image,
};
con.UsersDetails.Add(usersDetail);
}
con.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private void OpenStaffDetailWindow(string mode, string title)
{
var win = GetSelectedStaff();
if (win == null && mode != FormModes.New)
{
Message(MessageTypes.Error, "Please Select to " + mode + " Staff Detail");
return;
}
if (mode == FormModes.New)
{
win = new UsersDetail();
}
var view = new ucStaffDetailView(mode, win.UserID);
view.ParentContainer = this;
OpenPopUp(view, title, 650, 550);
}
public ActionResult UserAdd(UsersDetail usersDetail)
{
var user = new UsersDetail();
user.UserName = usersDetail.UserName.ToLower();
user.FullName = usersDetail.FullName;
user.PhoneNumber = usersDetail.PhoneNumber;
user.UserPassword = encryptPassword(usersDetail.UserPassword);
user.RoleId = usersDetail.RoleId;
try
{
_context.UsersDetails.Add(user);
_context.SaveChanges();
}
catch
{
return(View());
}
return(Redirect("~/home/UserAll"));
}
public JsonResult SignIn(string userName, string password)
{
Common common = new Common();
Studio365Entities Entity = new Studio365Entities();
ResponseData responseData = new ResponseData()
{
ReturnType = common.ReturnTypeMessage,
};
try
{
int userExist = (from u in Entity.UsersDetails
where u.MobileNumber == userName && u.Password == password
select u).Count();
if (userExist == 0)
{
responseData.Message = common.loginFailure;
}
else
{
responseData.Message = common.loginSuccess;
UsersDetail user = (from u in Entity.UsersDetails
where u.MobileNumber == userName && u.Password == password
select u).FirstOrDefault();
List <string> lstUser = new List <string>()
{
user.Name,
user.JoinDate.ToString(),
user.MobileNumber,
};
responseData.Content = lstUser;
}
}
catch (Exception ex)
{
}
return(Json(responseData, JsonRequestBehavior.AllowGet));
}
public ActionResult AssignPin(string sponsoredId, int totalPin, string pinType)
{
var getUser = _valleyDreamsIndiaDBEntities.UsersDetails.Where(x => x.UserName == sponsoredId).FirstOrDefault();
if (pinType == "NEW")
{
UsersDetail userDetail = new UsersDetail();
for (int i = 1; i <= totalPin; i++)
{
userDetail.PinCreatedOn = DateTime.Now;
userDetail.Deleted = 0;
userDetail.SponsoredId = getUser.Id;
userDetail.IsPinUsed = 0;
userDetail.PinType = pinType;
_valleyDreamsIndiaDBEntities.UsersDetails.Add(userDetail);
_valleyDreamsIndiaDBEntities.SaveChanges();
}
}
if (pinType == "RENEW")
{
RenewalPinDetail renewalPinDetail = new RenewalPinDetail();
for (int i = 1; i <= totalPin; i++)
{
renewalPinDetail.PinCreatedOn = DateTime.Now;
renewalPinDetail.Deleted = 0;
renewalPinDetail.SponsoredId = getUser.Id;
renewalPinDetail.IsPinUsed = 0;
_valleyDreamsIndiaDBEntities.RenewalPinDetails.Add(renewalPinDetail);
_valleyDreamsIndiaDBEntities.SaveChanges();
}
}
ViewBag.Message = $"{pinType} has been assigned successfully";
return(View());
}
public Task <bool> UpdateAsync(UsersDetail document)
{
throw new NotImplementedException();
}
