// GET: ListUsers/Delete/5 public ActionResult Delete(string id) { string role = null; ViewData["Role"] = ""; IEnumerable <string> roles = new List <string>(); roles = ((ClaimsIdentity)User.Identity).Claims .Where(ca => ca.Type == ClaimTypes.Role) .Select(ca => ca.Value); foreach (var x in roles) { role = x; } if (role != null) { ViewData["Role"] = role; } aspnetuser u = new aspnetuser(); u = userService.getUser(id); u.cvs = null; cv c = s.Get(x => x.user_idUser.Equals(id)); c.user_idUser = null; c.aspnetuser = null; s.Delete(c); s.Commit(); userService.Delete(u); userService.Commit(); return(RedirectToAction("Index")); }
public async Task <ActionResult> DeleteConfirmed(string id) { poduzeće poduzeće = await db.poduzeće.FindAsync(id); var slike = await(from c in db.slika where c.idPoduzeća.Equals(id) select c).ToListAsync(); if (slike.Count != 0) { foreach (slika slika in slike) { slika s = db.slika.Find(slika.idSlika); string putanjaSlike = Server.MapPath(s.putanjaSlike); if (System.IO.File.Exists(putanjaSlike)) { System.IO.File.Delete(putanjaSlike); } db.slika.Remove(s); await db.SaveChangesAsync(); } } aspnetuser aspnetuser = await db.aspnetusers.FindAsync(id); AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie); db.aspnetusers.Remove(aspnetuser); db.poduzeće.Remove(poduzeće); await db.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); }
public ActionResult Index() { ViewData["Name"] = sAccount.getUser(User.Identity.GetUserId()).Name; ViewData["Picture"] = sAccount.getUser(User.Identity.GetUserId()).ImagePath; string role = null; ViewData["Role"] = ""; IEnumerable <string> roles = new List <string>(); roles = ((ClaimsIdentity)User.Identity).Claims .Where(c => c.Type == ClaimTypes.Role) .Select(c => c.Value); foreach (var x in roles) { role = x; } if (role != null) { ViewData["Role"] = role; } aspnetuser u = new aspnetuser(); ServiceAccount s = new ServiceAccount(); u = s.getUser(User.Identity.GetUserId()); return(View(u)); }
public JObject IsUserVerified(UserDTO model) { JObject data = new JObject(); aspnetuser user = _us.GetUserDataByUsername(model.username); data.Add("email", user.EmailConfirmed == true ? true : false); data.Add("phone", user.PhoneNumberConfirmed == true ? true : false); return(data); }
public int UpdateUser(User editedUser) { aspnetuser editedUserDb = GetUserDataByUsername(editedUser.UserName); editedUserDb.UserName = editedUser.UserName; editedUserDb.FirstName = editedUser.FirstName; editedUserDb.LastName = editedUser.LastName; editedUserDb.City = editedUser.City; editedUserDb.Address = editedUser.Address; editedUserDb.Municipality = editedUser.Municipality; editedUserDb.MobilePhoneNumber = editedUser.MobilePhoneNumber; editedUserDb.Email = editedUser.Email; editedUserDb.DateOfBirth = editedUser.DateOfBirth; editedUserDb.EMBG = editedUser.EMBG; editedUserDb.Gender = editedUser.Gender; editedUserDb.PassportNumber = editedUser.PassportNumber; editedUserDb.PostalCode = editedUser.PostalCode; editedUserDb.PhoneNumber = editedUser.PhoneNumber; var userRole = editedUserDb.aspnetroles.FirstOrDefault(); if (userRole != null && userRole.Name != editedUser.Role) { aspnetrole previousUserRole = _db.aspnetroles.Where(x => x.Name == userRole.Name).FirstOrDefault(); if (previousUserRole != null) { editedUserDb.aspnetroles.Remove(previousUserRole); } AuthRepository _repo = new AuthRepository(); try { _repo.AddUserToRole(editedUserDb.Id, editedUser.Role); } catch (Exception ex) { } } int result = -1; try { result = _db.SaveChanges(); } catch (Exception ex) { } return(result); }
public async Task <ActionResult> Index(aspnetuser ua) { string role = null; ViewData["Role"] = ""; IEnumerable <string> roles = new List <string>(); roles = ((ClaimsIdentity)User.Identity).Claims .Where(c => c.Type == ClaimTypes.Role) .Select(c => c.Value); foreach (var x in roles) { role = x; } if (role != null) { ViewData["Role"] = role; } ServiceAccount s = new ServiceAccount(); ua.Id = User.Identity.GetUserId(); ApplicationUser model = UserManager.FindById(User.Identity.GetUserId()); model.Last_Name = ua.Last_Name; model.Name = ua.Name; var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Images/"), fileName); model.ImagePath = fileName; file.SaveAs(path); } IdentityResult result = await UserManager.UpdateAsync(model); if (result.Succeeded) { return(RedirectToAction("Index")); } return(null); // TODO: Add update logic here }
public bool ChangeStatus(string username) { aspnetuser user = _db.aspnetusers.Where(x => x.UserName == username).FirstOrDefault(); int status = user.Active.Value; switch (status) { case 1: user.Active = 0; break; case 0: user.Active = 1; break; } var result = _db.SaveChanges(); return(result == 1); }
public List <travel_policy> GetEndUserExpiringPolicies(string userId, DateTime dateFrom) { if (userId == "") { return(null); } aspnetuser currentUser = _db.aspnetusers.FirstOrDefault(x => x.Id == userId); if (currentUser == null) { return(null); } return(_db.travel_policy.Where(x => (x.Created_By == userId || x.insured.SSN == currentUser.EMBG || _db.policy_insured.Where(h => h.PolicyID == x.ID).Select(k => k.insured.SSN).ToList().Contains(currentUser.EMBG)) && x.End_Date < dateFrom && x.End_Date > DateTime.Now).ToList()); }
public bool IsUser(string role, string username) { bool authorize = false; aspnetuser aspnetuser = context.aspnetusers.FirstOrDefault(m => m.UserName == username); if (aspnetuser == null) { return(authorize); } if (aspnetuser.aspnetroles.Count == 0) { return(authorize); } authorize = aspnetuser.aspnetroles.FirstOrDefault() != null?aspnetuser.aspnetroles.FirstOrDefault().Name == role : false; return(authorize); }
//mjenjanje lozinke - get public async Task <ActionResult> ChangePassword(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } aspnetuser aspnetusers = await db.aspnetusers.FindAsync(id); if (aspnetusers == null) { return(HttpNotFound()); } PromijeniLozinku promijeniLozinku = new PromijeniLozinku { ID = id }; return(View("~/Views/Korisnik/ChangePassword.cshtml", promijeniLozinku)); }
public bool IsUser(string role) { bool authorize = false; var user = System.Web.HttpContext.Current.User; aspnetuser aspnetuser = context.aspnetusers.Where(m => m.UserName == user.Identity.Name).FirstOrDefault(); if (aspnetuser == null) { return(authorize); } if (aspnetuser.aspnetroles.Count == 0) { authorize = false; return(authorize); } authorize = aspnetuser.aspnetroles.FirstOrDefault() != null?aspnetuser.aspnetroles.FirstOrDefault().Name == role : false; return(authorize); }
public ActionResult Index() { var genderList = Gender(); var roles = _rs.GetAll().ToList(); aspnetuser userEdit = _us.GetUserDataByUsername(System.Web.HttpContext.Current.User.Identity.Name); if (userEdit == null) { return(View()); } User userEditModel = Mapper.Map <aspnetuser, User>(userEdit); foreach (var role in roles) { if (role.Selected) { role.Selected = false; } if (role.Text == userEditModel.Role) { role.Selected = true; } } foreach (var gender in genderList) { if (gender.Text == userEditModel.Gender) { gender.Selected = true; } } ViewBag.Roles = roles; ViewBag.Gender = genderList; return(View(userEditModel)); }
public async Task <ActionResult> DeleteConfirmed(string id) { korisnik korisnik = await db.korisnik.FindAsync(id); if (korisnik.putanjaDoProfilneSlike != null) { string putanjaSlike = Server.MapPath(korisnik.putanjaDoProfilneSlike); if (System.IO.File.Exists(putanjaSlike)) { System.IO.File.Delete(putanjaSlike); } } aspnetuser aspnetuser = await db.aspnetusers.FindAsync(id); AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie); db.aspnetusers.Remove(aspnetuser); db.korisnik.Remove(korisnik); await db.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); }
public JObject RetrieveUserInformation(UserDTO username) { JObject data = new JObject(); aspnetuser user = _us.GetUserDataByUsername(username.username); if (user == null) { throw new HttpResponseException(System.Net.HttpStatusCode.NotFound); } //information about the user var userJson = new JObject(); userJson.Add("User_ID", user.Id); userJson.Add("FirstName", user.FirstName); userJson.Add("LastName", user.LastName); userJson.Add("Municipality", user.Municipality); userJson.Add("MobilePhoneNumber", user.MobilePhoneNumber); userJson.Add("PassportNumber", user.PassportNumber); userJson.Add("PostalCode", user.PostalCode); userJson.Add("PhoneNumber", user.PhoneNumber); userJson.Add("EMBG", user.EMBG); userJson.Add("DateOfBirth", user.DateOfBirth); userJson.Add("Gender", user.Gender); userJson.Add("City", user.City); userJson.Add("Address", user.Address); userJson.Add("Email", user.Email); data.Add("user", userJson); //user's policies JArray userPolicies = new JArray(); travel_policy[] policies = _ps.GetPolicyByUsernameId(user.Id); foreach (travel_policy policy in policies) { var userPolicy = new JObject(); userPolicy.Add("ID", policy.ID); userPolicy.Add("Policy_Number", policy.Policy_Number); userPolicy.Add("Exchange_RateID", policy.Exchange_RateID); userPolicy.Add("CountryID", policy.CountryID); userPolicy.Add("Policy_TypeID", policy.Policy_TypeID); userPolicy.Add("Retaining_RiskID", policy.Retaining_RiskID); userPolicy.Add("Start_Date", policy.Start_Date); userPolicy.Add("End_Date", policy.End_Date); userPolicy.Add("Valid_Days", policy.Valid_Days); userPolicy.Add("Travel_NumberID", policy.Travel_NumberID); userPolicy.Add("Travel_Insurance_TypeID", policy.Travel_Insurance_TypeID); userPolicy.Add("Created_By", policy.Created_By); userPolicy.Add("Date_Created", policy.Date_Created); userPolicy.Add("Date_Modified", policy.Date_Modified); userPolicy.Add("Modified_By", policy.Modified_By); userPolicy.Add("Payment_Status", policy.Modified_By); userPolicy.Add("Date_Cancellation", policy.Modified_By); //information about policy holder if (policy.insured != null) { userPolicy.Add("Policy_HolderID", policy.Policy_HolderID); userPolicy.Add("Name", policy.insured.Name); userPolicy.Add("Lastname", policy.insured.Lastname); userPolicy.Add("SSN", policy.insured.SSN); userPolicy.Add("DateBirth", policy.insured.DateBirth); userPolicy.Add("Age", policy.insured.Age); userPolicy.Add("Email", policy.insured.Email); userPolicy.Add("Phone_Number", policy.insured.Phone_Number); userPolicy.Add("City", policy.insured.City); userPolicy.Add("Postal_Code", policy.insured.Postal_Code); userPolicy.Add("Address", policy.insured.Address); userPolicy.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber); userPolicy.Add("Type_InsuredID", policy.insured.Type_InsuredID); //bank account for the policy holder var ssn = _us.GetUserSsnByUsername(username.username); var holderDetails = _iss.GetInsuredDataBySsn(ssn); if (holderDetails != null) { JArray bankAccounts = new JArray(); var banks = _bas.BankAccountsByInsuredId(holderDetails.ID); foreach (bank_account_info bankAccount in banks) { var bankAccountObject = new JObject(); bankAccountObject.Add("BankAccount", bankAccount.Account_Number); bankAccountObject.Add("BankName", bankAccount.bank.Name); bankAccountObject.Add("BankAccountId", bankAccount.ID); bankAccounts.Add(bankAccountObject); } userPolicy.Add("policyHolderBankAccounts", bankAccounts); } } //information about insureds if (policy.policy_insured != null) { JArray policyInsureds = new JArray(); foreach (var insured in policy.policy_insured) { var policyInsured = new JObject(); policyInsured.Add("Insured_ID", policy.Policy_HolderID); policyInsured.Add("Name", policy.insured.Name); policyInsured.Add("Lastname", policy.insured.Lastname); policyInsured.Add("SSN", policy.insured.SSN); policyInsured.Add("DateBirth", policy.insured.DateBirth); policyInsured.Add("Age", policy.insured.Age); policyInsured.Add("Email", policy.insured.Email); policyInsured.Add("Phone_Number", policy.insured.Phone_Number); policyInsured.Add("City", policy.insured.City); policyInsured.Add("Postal_Code", policy.insured.Postal_Code); policyInsured.Add("Address", policy.insured.Address); policyInsured.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber); policyInsured.Add("Type_InsuredID", policy.insured.Type_InsuredID); JArray bankAccounts = new JArray(); var banks = _bas.BankAccountsByInsuredId(insured.InsuredID); foreach (bank_account_info bankAccount in banks) { var bankAccountObject = new JObject(); bankAccountObject.Add("BankAccount", bankAccount.Account_Number); bankAccountObject.Add("BankName", bankAccount.bank.Name); bankAccountObject.Add("BankAccountId", bankAccount.ID); bankAccounts.Add(bankAccountObject); } policyInsured.Add("insuredBankAccounts", bankAccounts); policyInsureds.Add(policyInsured); } userPolicy.Add("insureds", policyInsureds); } userPolicies.Add(userPolicy); } data.Add("policy", userPolicies); // user's quotes JArray userQuotes = new JArray(); travel_policy[] quotes = _ps.GetPolicyNotPayedByUsernameId(user.Id); foreach (travel_policy policy in quotes) { var userQuote = new JObject(); userQuote.Add("Policy_Number", policy.Policy_Number); userQuote.Add("Exchange_RateID", policy.Exchange_RateID); userQuote.Add("CountryID", policy.CountryID); userQuote.Add("Policy_TypeID", policy.Policy_TypeID); userQuote.Add("Retaining_RiskID", policy.Retaining_RiskID); userQuote.Add("Start_Date", policy.Start_Date); userQuote.Add("End_Date", policy.End_Date); userQuote.Add("Valid_Days", policy.Valid_Days); userQuote.Add("Travel_NumberID", policy.Travel_NumberID); userQuote.Add("Group_Members", policy.Group_Members); userQuote.Add("Group_Total_Premium", policy.Group_Total_Premium); userQuote.Add("Created_By", policy.Created_By); userQuote.Add("Date_Created", policy.Date_Created); userQuote.Add("Date_Modified", policy.Date_Modified); userQuote.Add("Modified_By", policy.Modified_By); userQuote.Add("Payment_Status", policy.Modified_By); userQuote.Add("Date_Cancellation", policy.Modified_By); //information about policy holder if (policy.insured != null) { userQuote.Add("Policy_HolderID", policy.Policy_HolderID); userQuote.Add("Name", policy.insured.Name); userQuote.Add("Lastname", policy.insured.Lastname); userQuote.Add("SSN", policy.insured.SSN); userQuote.Add("DateBirth", policy.insured.DateBirth); userQuote.Add("Age", policy.insured.Age); userQuote.Add("Email", policy.insured.Email); userQuote.Add("Phone_Number", policy.insured.Phone_Number); userQuote.Add("City", policy.insured.City); userQuote.Add("Postal_Code", policy.insured.Postal_Code); userQuote.Add("Address", policy.insured.Address); userQuote.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber); userQuote.Add("Type_InsuredID", policy.insured.Type_InsuredID); //bank account for the policy holder var ssn = _us.GetUserSsnByUsername(username.username); var holderDetails = _iss.GetInsuredDataBySsn(ssn); if (holderDetails != null) { JArray bankAccounts = new JArray(); var banks = _bas.BankAccountsByInsuredId(holderDetails.ID); foreach (bank_account_info bankAccount in banks) { var bankAccountObject = new JObject(); bankAccountObject.Add("BankAccount", bankAccount.Account_Number); bankAccountObject.Add("BankName", bankAccount.bank.Name); bankAccountObject.Add("BankAccountId", bankAccount.ID); bankAccounts.Add(bankAccountObject); } userQuote.Add("policyHolderBankAccounts", bankAccounts); } } //information about insureds if (policy.policy_insured != null) { JArray quoteInsureds = new JArray(); foreach (var insured in policy.policy_insured) { var quoteInsured = new JObject(); quoteInsured.Add("ID", policy.Policy_HolderID); quoteInsured.Add("Name", policy.insured.Name); quoteInsured.Add("Lastname", policy.insured.Lastname); quoteInsured.Add("SSN", policy.insured.SSN); quoteInsured.Add("DateBirth", policy.insured.DateBirth); quoteInsured.Add("Age", policy.insured.Age); quoteInsured.Add("Email", policy.insured.Email); quoteInsured.Add("Phone_Number", policy.insured.Phone_Number); quoteInsured.Add("City", policy.insured.City); quoteInsured.Add("Postal_Code", policy.insured.Postal_Code); quoteInsured.Add("Address", policy.insured.Address); quoteInsured.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber); quoteInsured.Add("Type_InsuredID", policy.insured.Type_InsuredID); JArray bankAccounts = new JArray(); var banks = _bas.BankAccountsByInsuredId(insured.InsuredID); foreach (bank_account_info bankAccount in banks) { var bankAccountObject = new JObject(); bankAccountObject.Add("BankAccount", bankAccount.Account_Number); bankAccountObject.Add("BankName", bankAccount.bank.Name); bankAccountObject.Add("BankAccountId", bankAccount.ID); bankAccounts.Add(bankAccountObject); } quoteInsured.Add("insuredBankAccounts", bankAccounts); quoteInsureds.Add(quoteInsured); } userQuote.Add("insureds", quoteInsureds); } userQuotes.Add(userQuote); } data.Add("quote", userQuotes); //user's reports of loss JArray userFNOL = new JArray(); first_notice_of_loss[] fnols = _fnls.GetByInsuredUserId(user.Id); foreach (first_notice_of_loss fnol in fnols) { var fnolObject = new JObject(); if (fnol.Short_Detailed == true) { fnolObject.Add("ChatId", fnol.ChatId); fnolObject.Add("ID", fnol.ID); fnolObject.Add("Policy_Number", fnol.travel_policy.Policy_Number); fnolObject.Add("Short_Detailed", fnol.Short_Detailed); } else { fnolObject.Add("ID", fnol.ID); fnolObject.Add("PolicyId", fnol.PolicyId); fnolObject.Add("Policy_Number", fnol.travel_policy.Policy_Number); if (fnol.insured != null) { var claimantBankAccount = _bas.BankAccountInfoById(fnol.Claimant_bank_accountID); fnolObject.Add("Claimant_ID", fnol.insured.ID); fnolObject.Add("Name", fnol.insured.Name); fnolObject.Add("Lastname", fnol.insured.Lastname); fnolObject.Add("SSN", fnol.insured.SSN); fnolObject.Add("DateBirth", fnol.insured.DateBirth); fnolObject.Add("Age", fnol.insured.Age); fnolObject.Add("Email", fnol.insured.Email); fnolObject.Add("Phone_Number", fnol.insured.Phone_Number); fnolObject.Add("City", fnol.insured.City); fnolObject.Add("Postal_Code", fnol.insured.Postal_Code); fnolObject.Add("Address", fnol.insured.Address); fnolObject.Add("Passport_Number_IdNumber", fnol.insured.Passport_Number_IdNumber); fnolObject.Add("Type_InsuredID", fnol.insured.Type_InsuredID); fnolObject.Add("Claimant_Account_HolderID", claimantBankAccount.Account_HolderID); fnolObject.Add("Claimant_Account_Number", claimantBankAccount.Account_Number); fnolObject.Add("Claimant_BankID", claimantBankAccount.BankID); } fnolObject.Add("Relation_claimant_policy_holder", fnol.Relation_claimant_policy_holder); fnolObject.Add("Destination", fnol.Destination); fnolObject.Add("Depart_Date_Time", fnol.Depart_Date_Time); fnolObject.Add("Arrival_Date_Time", fnol.Arrival_Date_Time); fnolObject.Add("Transport_means", fnol.Transport_means); fnolObject.Add("Total_cost", fnol.Total_cost); fnolObject.Add("Web_Mobile", fnol.Web_Mobile); fnolObject.Add("CreatedBy", fnol.CreatedBy); if (fnol.Policy_holder_bank_account_info != null) { fnolObject.Add("PolicyHolder_Account_HolderID", fnol.Policy_holder_bank_account_info.Account_HolderID); fnolObject.Add("PolicyHolder_Account_Number", fnol.Policy_holder_bank_account_info.Account_Number); fnolObject.Add("BankID", fnol.Policy_holder_bank_account_info.BankID); } var healthInsurance = _fis.GetHealthAdditionalInfoByLossId(fnol.ID); if (healthInsurance == null) { fnolObject.Add("HealthInsurance_Y_N", "N"); } else { fnolObject.Add("HealthInsurance_Y_N", "Y"); if (fnol.additional_info != null) { fnolObject.Add("Datetime_accident", fnol.additional_info.Datetime_accident); fnolObject.Add("Accident_place", fnol.additional_info.Accident_place); if (fnol.additional_info.health_insurance_info != null) { fnolObject.Add("Datetime_doctor_visit", fnol.additional_info.health_insurance_info.Datetime_doctor_visit); fnolObject.Add("Doctor_info", fnol.additional_info.health_insurance_info.Doctor_info); fnolObject.Add("Medical_case_description ", fnol.additional_info.health_insurance_info.Medical_case_description); fnolObject.Add("Previous_medical_history", fnol.additional_info.health_insurance_info.Previous_medical_history); fnolObject.Add("Responsible_institution", fnol.additional_info.health_insurance_info.Responsible_institution); } } } var luggageInsurance = _fis.GetLuggageAdditionalInfoByLossId(fnol.ID); if (luggageInsurance == null) { fnolObject.Add("LuggageInsurance_Y_N", "N"); } else { fnolObject.Add("LuggageInsurance_Y_N", "Y"); if (fnol.additional_info != null) { fnolObject.Add("Datetime_accident", fnol.additional_info.Datetime_accident); fnolObject.Add("Accident_place", fnol.additional_info.Accident_place); if (fnol.additional_info.luggage_insurance_info != null) { fnolObject.Add("Place_description", fnol.additional_info.luggage_insurance_info.Place_description); fnolObject.Add("Detail_description", fnol.additional_info.luggage_insurance_info.Detail_description); fnolObject.Add("Report_place", fnol.additional_info.luggage_insurance_info.Report_place); fnolObject.Add("Floaters", fnol.additional_info.luggage_insurance_info.Floaters); fnolObject.Add("Floaters_value", fnol.additional_info.luggage_insurance_info.Floaters_value); fnolObject.Add("Luggage_checking_Time", fnol.additional_info.luggage_insurance_info.Luggage_checking_Time); } } } JArray invoices = new JArray(); var allInvoices = _fis.GetInvoiceDocumentName(fnol.ID); foreach (var invoice in allInvoices) { var invoiceObject = new JObject(); invoiceObject.Add("invoicePath", ConfigurationManager.AppSettings["webpage_url"] + "/DocumentsFirstNoticeOfLoss/Invoices/" + invoice); invoices.Add(invoiceObject); } fnolObject.Add("invoices", invoices); JArray documents = new JArray(); var allDoc = _fis.GetHealthLuggageDocumentName(fnol.ID); foreach (var doc in allDoc) { var document = new JObject(); document.Add("documentPath", healthInsurance != null ? ConfigurationManager.AppSettings["webpage_url"] + "/DocumentsFirstNoticeOfLoss/HealthInsurance/" + doc : ConfigurationManager.AppSettings["webpage_url"] + "/DocumentsFirstNoticeOfLoss/LuggageInsurance/" + doc); documents.Add(document); } fnolObject.Add("documents", documents); userFNOL.Add(fnolObject); } } data.Add("loss", userFNOL); return(data); }
public async Task <ActionResult> ProfileEdit(RegisterViewModel model, HttpPostedFileBase picture_selector, String cropImgParam) { String userID = User.Identity.GetUserId(); String Img = cropImgParam; ViewBag.GalleryPics = ""; ViewBag.PrivateGalleryPics = ""; if (userID != null && userID.Length > 0) { //{{Upload Picture String FileName = ""; string PictureDirectory = Server.MapPath("~/Content/UserPicture"); if (!Directory.Exists(PictureDirectory)) { Directory.CreateDirectory(PictureDirectory); } if (picture_selector != null) { FileName = userID + "." + picture_selector.FileName.Substring(picture_selector.FileName.Length - 3, 3); var path = System.IO.Path.Combine(PictureDirectory, FileName); var data = new byte[picture_selector.ContentLength]; picture_selector.InputStream.Read(data, 0, picture_selector.ContentLength); using (var sw = new FileStream(path, FileMode.Create)) { sw.Write(data, 0, data.Length); } } else if (cropImgParam.Length > 0) { FileName = userID + ".png"; var path = System.IO.Path.Combine(PictureDirectory, FileName); ProcessImage(cropImgParam, path); } //}}Upload Picture ApplicationUserManager userManager = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>(); userManager.RemoveFromRoles(userID, new string[] { "member", "client" }); userManager.AddToRole(userID, (model.AccountType == 0 ? "member" : "client")); //validate age with 18+ if (DateTime.Today.AddYears(-18) < model.Birthday) { ModelState.AddModelError("Birthday", "Members or Clients need to be 18 or above to register."); } ModelState.Remove("Password"); if (this.ModelState.IsValid) { aspnetuser aspuser = this.db.aspnetusers.SingleOrDefault(r => r.Id == userID); aspuser.Email = model.Email; aspuser.PhoneNumber = model.PhoneNumber; if (model.Password != null && model.Password.Length > 0) { aspuser.PasswordHash = userManager.PasswordHasher.HashPassword(model.Password); } userinfo ui = this.db.userinfoes.SingleOrDefault(r => r.Id == userID); ViewBag.GalleryPics = ui.Gallery_Pics; ViewBag.PrivateGalleryPics = ui.Private_Gallery_Pics; ui.UserName = model.UserName; ui.Account_Type = model.AccountType; ui.Date_Of_Birth = model.Birthday; ui.Gender = Convert.ToSByte(model.Gender); ui.Gender_Pref = model.GenderPref; ui.Credit_Amount = 0; if (picture_selector != null || cropImgParam.Length > 0) { ui.Profile_Pic = FileName; model.Picture = FileName; } ui.City = model.City; ui.County = model.County; ui.Country = model.Country; ui.Postcode = model.Postcode; this.db.SaveChanges(); } } ViewBag.mode = 0; return(View("ProfileView", model)); }
public aspnetuser GetUserDataByUsername(string username) { aspnetuser a = _db.aspnetusers.Where(x => x.UserName == username).ToArray().FirstOrDefault(); return(a); }
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl) { if (model.Email.IndexOf('@') > -1) { //Validate email format string emailRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" + @"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" + @".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"; Regex re = new Regex(emailRegex); if (!re.IsMatch(model.Email)) { ModelState.AddModelError("Email", "Email is not valid"); } } else { //validate Username format string emailRegex = @"^[a-zA-Z0-9]*$"; Regex re = new Regex(emailRegex); if (!re.IsMatch(model.Email)) { ModelState.AddModelError("Email", "Username is not valid"); } } if (!ModelState.IsValid) { return(View("Login", "_LayoutLogin", model)); } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true String MailVal = model.Email; var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout : false); if (result != SignInStatus.Success) { //retry about username. IQueryable <userinfo> userInfo = db.userinfoes.Where(i => i.UserName == model.Email); if (userInfo != null && userInfo.Count() > 0) { userinfo ui = userInfo.Single(); aspnetuser aspUser = db.aspnetusers.Where(i => i.Id == ui.Id).Single(); MailVal = aspUser.Email; result = await SignInManager.PasswordSignInAsync(aspUser.Email, model.Password, model.RememberMe, shouldLockout : false); } } if (result == SignInStatus.Success) { string uid = UserManager.FindByName(MailVal)?.Id; userinfo user = db.userinfoes.Where(i => i.Id == uid).Single(); if (user.Online_Status == 0 || user.Online_Status == 1) { db.userinfoes.Where(i => i.Id == uid).Single().Online_Status = 1; db.SaveChanges(); } else {//not normal, so must logout. AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie); return(RedirectToAction("Index", "Home")); } } switch (result) { case SignInStatus.Success: return(RedirectToLocal(returnUrl)); case SignInStatus.LockedOut: return(View("Lockout")); case SignInStatus.RequiresVerification: return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe })); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return(View("Login", "_LayoutLogin", model)); } }
public async Task <ActionResult> ProfileView(int?mode) { if (mode == null) { mode = 0; } ViewBag.mode = mode; String userID = User.Identity.GetUserId(); if (userID == null || userID.Length == 0) { return(View()); } aspnetuserclaim aspUserClaim = db.aspnetuserclaims.Where(i => i.UserId == userID).Single(); switch (mode) { case 0: //Profile { string query = "SELECT * FROM userinfo WHERE userinfo.Id = '" + userID + "'"; userinfo UserInfo = await db.userinfoes.SqlQuery(query).SingleOrDefaultAsync(); query = "SELECT * FROM aspnetusers WHERE Id = '" + userID + "'"; aspnetuser aspnetUserInfo = await db.aspnetusers.SqlQuery(query).SingleOrDefaultAsync(); Models.RegisterViewModel model = new Models.RegisterViewModel(); model.Email = User.Identity.Name; //model.Password = ""; //model.ConfirmPassword = ""; model.UserName = UserInfo.UserName; model.Birthday = (DateTime)(UserInfo.Date_Of_Birth == null ? new DateTime() : UserInfo.Date_Of_Birth); model.Picture = UserInfo.Profile_Pic; model.Gender = (int)UserInfo.Gender; model.GenderPref = (int)UserInfo.Gender_Pref; model.PhoneNumber = aspnetUserInfo.PhoneNumber; model.Ethnicity = UserInfo.Ethnicity; model.Interests = UserInfo.Interests; model.City = UserInfo.City; model.County = UserInfo.County; model.Country = UserInfo.Country; model.Postcode = UserInfo.Postcode; model.AccountType = (int)(UserInfo.Account_Type == null ? 0 : UserInfo.Account_Type); ViewBag.GalleryPics = UserInfo.Gallery_Pics; ViewBag.PrivateGalleryPics = UserInfo.Private_Gallery_Pics; return(View("ProfileView", model)); } case 1: //Gallery { String GalleryPics = ""; if (userID != null) { string query = "SELECT * FROM userinfo WHERE userinfo.Id = '" + userID + "'"; System.Data.Entity.Infrastructure.DbSqlQuery <userinfo> userInfos = db.userinfoes.SqlQuery(query); userinfo UserInfo = null; if (userInfos != null) { UserInfo = await userInfos.SingleOrDefaultAsync(); } if (UserInfo != null && UserInfo.Gallery_Pics != null) { GalleryPics = UserInfo.Gallery_Pics; } } return(View("ProfileView", (object)GalleryPics)); } case 2: //Private Gallery { String GalleryPics = ""; if (userID != null) { string query = "SELECT * FROM userinfo WHERE userinfo.Id = '" + userID + "'"; System.Data.Entity.Infrastructure.DbSqlQuery <userinfo> userInfos = db.userinfoes.SqlQuery(query); userinfo UserInfo = null; if (userInfos != null) { UserInfo = await userInfos.SingleOrDefaultAsync(); } if (UserInfo != null && UserInfo.Gallery_Pics != null) { GalleryPics = UserInfo.Private_Gallery_Pics; } } return(View("ProfileView", (object)GalleryPics)); } } return(View()); }