// Default contructor that set entity to field
public aspnet_MembershipModel(aspnet_Membership aspnet_membership)
{
this._aspnet___membership = aspnet_membership;
this._application_id = aspnet_membership.ApplicationId;
this._user_id = aspnet_membership.UserId;
this._password = aspnet_membership.Password;
this._password_format = aspnet_membership.PasswordFormat;
this._password_salt = aspnet_membership.PasswordSalt;
this._mobile_pin = aspnet_membership.MobilePIN;
this._email = aspnet_membership.Email;
this._lowered_email = aspnet_membership.LoweredEmail;
this._password_question = aspnet_membership.PasswordQuestion;
this._password_answer = aspnet_membership.PasswordAnswer;
this._is_approved = aspnet_membership.IsApproved;
this._is_locked_out = aspnet_membership.IsLockedOut;
this._create_date = aspnet_membership.CreateDate;
this._last_login_date = aspnet_membership.LastLoginDate;
this._last_password_changed_date = aspnet_membership.LastPasswordChangedDate;
this._last_lockout_date = aspnet_membership.LastLockoutDate;
this._failed_password_attempt_count = aspnet_membership.FailedPasswordAttemptCount;
this._failed_password_attempt_window_start = aspnet_membership.FailedPasswordAttemptWindowStart;
this._failed_password_answer_attempt_count = aspnet_membership.FailedPasswordAnswerAttemptCount;
this._failed_password_answer_attempt_window_start = aspnet_membership.FailedPasswordAnswerAttemptWindowStart;
this._comment = aspnet_membership.Comment;
this._originalaspnet_Membership = aspnet_membership.DeepClone();
}
public bool DeleteUser(string userName)
{
try
{
var en = new Models.Entities();
aspnet_Users u = null;
aspnet_Membership member = null;
try
{
u = en.aspnet_Users.First(m => m.UserName == userName);
member = en.aspnet_Membership.First(m => m.UserId == u.UserId);
en.DeleteObject(member);
en.DeleteObject(u);
en.SaveChanges();
return(true);
}
catch
{
throw new ArgumentException("注销失败");
}
}
catch
{
throw;
}
}
public void Sil(string id)
{
aspnet_Membership k = ctx.aspnet_Membership.FirstOrDefault(x => x.UserId.ToString().Equals(id));
ctx.aspnet_Membership.Remove(k);
ctx.SaveChanges();
}
public ActionResult KullaniciGuncelle(Guid id)
{
aspnet_Membership us = db.aspnet_Memberships.FirstOrDefault(x => x.UserId == id);
ViewBag.kid = us.UserId;
return(View(us));
}
public ActionResult Create([Bind(Include = "UserName,Password,IsLockedOut,Comment,RoleId,ApplicationId")] aspnet_Membership aspnet_Membership)
{
if (ModelState.IsValid)
{
MembershipUser user = Membership.CreateUser
(
aspnet_Membership.UserName,
aspnet_Membership.Password
);
db.SaveChanges();
user.Comment = aspnet_Membership.Comment.ToString();
aspnet_UsersInRoles addRoleToUser = new aspnet_UsersInRoles
{
UserId = (Guid)user.ProviderUserKey,
RoleId = aspnet_Membership.RoleId
};
db.aspnet_UsersInRoles.Add(addRoleToUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var roles = db.aspnet_Roles.ToList();
aspnet_Membership.UserRoles = roles.Select(role => new SelectListItem()
{
Selected = false, Text = role.RoleName, Value = role.RoleId.ToString()
}).ToList();
aspnet_Membership.ApplicationId = db.aspnet_Applications.Where(a => a.ApplicationName == "Hubbard House Survey Analysis System").SingleOrDefault().ApplicationId;
return(View(aspnet_Membership));
}
public ActionResult EditUser()
{
string username = Request.Form["user"];
if (Request.Form["edit"] != null)
{
Users user = UsersDAL.GetUserByUsername(username);
aspnet_Membership membershipUser = UsersDAL.GetMembershipUserByUsername(username);
ViewBag.User = user;
ViewBag.Membership = membershipUser;
ViewBag.Operation = "Edit";
}
else if (Request.Form["delete"] != null)
{
if (username != null)
{
UsersDAL.DeleteUser(username);
}
}
else if (Request.Form["save"] != null)
{
UsersDAL.EditUser(Request.Form["username"], Request.Form["firstname"], Request.Form["lastname"], Request.Form["email"], Request.Form["password"]);
}
return(View("../Admin/Employee"));
}
public ActionResult DeleteConfirmed(Guid id)
{
aspnet_Membership aspnet_membership = db.aspnet_Membership.Find(id);
db.aspnet_Membership.Remove(aspnet_membership);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(aspnet_Membership aspnet_membership)
{
if (ModelState.IsValid)
{
db.Entry(aspnet_membership).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspnet_membership));
}
//
// GET: /aspnet_MembershipAdmin/Details/5
public ActionResult Details(Guid?id)
{
aspnet_Membership aspnet_membership = db.aspnet_Membership.Find(id);
if (aspnet_membership == null)
{
return(HttpNotFound());
}
return(View(aspnet_membership));
}
//public aspnet_Membership GetEmail(Guid id)
//{
// return ent.aspnet_Membership.SingleOrDefault(u => u.UserId == id);
//}
public void UpdateEmail(B2CUserManagementModel model)
{
aspnet_Membership tu = ent.aspnet_Membership.Where(u => u.UserId == model.UserId).FirstOrDefault();
tu.UserId = model.UserId;
tu.Email = model.GetEmail.Email;
tu.LoweredEmail = model.GetEmail.Email;
ent.ApplyCurrentValues(tu.EntityKey.EntitySetName, tu);
ent.SaveChanges();
}
public void UpdateEmail(AdminUserManagementModel.CreateAdminAspUser model)
{
aspnet_Membership tu = db.aspnet_Membership.Where(u => u.UserId == model.UserId).FirstOrDefault();
tu.UserId = model.UserId;
tu.Email = model.GetEmail.Email;
tu.LoweredEmail = model.GetEmail.Email;
db.ApplyCurrentValues(tu.EntityKey.EntitySetName, tu);
db.SaveChanges();
/////
}
public ActionResult KullaniciGuncelle(Kullanici u)
{
aspnet_Membership ap = db.aspnet_Memberships.FirstOrDefault(x => x.UserId == u.id);
ap.Name = u.Name;
ap.Surname = u.Surname;
ap.Email = u.Mail;
ap.aspnet_User.UserName = u.KulaniciAdi;
ap.aspnet_User.LoweredUserName = u.KulaniciAdi;
db.SubmitChanges();
return(RedirectToAction("KullaniciListesi"));
}
public ActionResult Create(aspnet_Membership aspnet_membership)
{
if (ModelState.IsValid)
{
aspnet_membership.UserId = Guid.NewGuid();
db.aspnet_Membership.Add(aspnet_membership);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspnet_membership));
}
// GET: aspnet_Membership/Delete/5
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
aspnet_Membership aspnet_Membership = db.aspnet_Membership.Find(id);
if (aspnet_Membership == null)
{
return(HttpNotFound());
}
return(View(aspnet_Membership));
}
public static bool ChangeUserActive(string userName, bool isLock = false)
{
bool isSuccess = false;
MembershipUser user = Membership.GetUser(userName);
if (user != null)
{
xRPDataContext dataContext = new xRPDataContext();
aspnet_Membership membershipItem = dataContext.aspnet_Memberships.FirstOrDefault(x => x.UserId == Guid.Parse(user.ProviderUserKey.ToString()));
if (membershipItem != null)
{
membershipItem.IsLockedOut = isLock;
}
dataContext.SubmitChanges();
isSuccess = true;
}
return(isSuccess);
}
public ActionResult KullaniciSil(Guid id)
{
aspnet_Membership us = db.aspnet_Memberships.FirstOrDefault(x => x.UserId == id);
db.aspnet_Users.DeleteOnSubmit(us.aspnet_User);
db.aspnet_Memberships.DeleteOnSubmit(us);
try
{
db.SubmitChanges();
}
catch (Exception)
{
TempData["f"] = "Silmek istediğiniz kullanıcı bir profile dahildir. Bu kullanıcıyı silmek için veritabanı yöneticinize başvurunuz.";
}
return(RedirectToAction("KullaniciListesi"));
}
// GET: aspnet_Membership/Edit/5
public ActionResult Edit(Guid?id)
{
var currentUser = Membership.GetUser();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Edit only accessible if user is SiteAdmin Role or User is trying to edit current account
if (!User.IsInRole("Administrator") && (Guid)currentUser.ProviderUserKey != id)
{
return(RedirectToAction("Index"));
}
aspnet_Membership aspnet_Membership = db.aspnet_Membership.Find(id);
if (aspnet_Membership == null)
{
return(HttpNotFound());
}
var user = db.aspnet_Users.Where(a => a.UserId == aspnet_Membership.UserId).FirstOrDefault();
aspnet_Membership.UserName = user.UserName;
var roles = db.aspnet_Roles.ToList();
aspnet_Membership.UserRoles = roles.Select(role => new SelectListItem()
{
Selected = false, Text = role.RoleName, Value = role.RoleId.ToString()
}).ToList();
aspnet_Membership.ApplicationId = db.aspnet_Applications.Where(a => a.ApplicationName == "Hubbard House Survey Analysis System").SingleOrDefault().ApplicationId;
//Users will only have one role
var userCurrentRoles = db.aspnet_UsersInRoles.Where(e => e.UserId == user.UserId).FirstOrDefault();
if (userCurrentRoles != null)
{
aspnet_Membership.RoleId = userCurrentRoles.RoleId;
}
return(View(aspnet_Membership));
}
protected void updatesData(ArtShopEntities db)
{
UserExtension ux = db.UserExtensions.Find(loginUser);
aspnet_Membership am = db.aspnet_Membership.Find(loginUser);
ux.first_name = this.firstName.Text;
ux.last_name = this.lastName.Text;
if (this.radioMale.Checked)
{
ux.gender = "Male";
}
else
{
ux.gender = "Female";
}
db.aspnet_Membership.AddOrUpdate(am);
db.UserExtensions.AddOrUpdate(ux);
}
private ActionResult CreateView(int memberId, aspnet_Membership viewModel = null)
{
if (viewModel == null)
{
viewModel = new aspnet_Membership
{
IsApproved = true
};
}
var roles = db.aspnet_Roles.ToList();
viewModel.UserRoles = roles.Select(role => new SelectListItem()
{
Selected = false, Text = role.RoleName, Value = role.RoleId.ToString()
}).ToList();
viewModel.ApplicationId = db.aspnet_Applications.Where(a => a.ApplicationName == "Hubbard House Survey Analysis System").SingleOrDefault().ApplicationId;
return(View(viewModel));
}
public static void UpdateUserDetailsOnRegistration(string userName)
{
aspnet_Membership userMembership = new aspnet_Membership();
aspnet_Users aspUser = new aspnet_Users();
WSR_UserInfo newUser = new WSR_UserInfo();
using (WholesaleRajaEntities db = new WholesaleRajaEntities())
{
aspUser = db.aspnet_Users.Where(x => x.LoweredUserName == userName.ToLower()).FirstOrDefault();
userMembership = db.aspnet_Membership.Where(x => x.UserId == aspUser.UserId).FirstOrDefault();
if (aspUser != null && userMembership != null && aspUser.UserName.ToLower() == userName.ToLower() && aspUser.UserId == userMembership.UserId)
{
newUser.UserId = aspUser.UserId;
newUser.UserName = aspUser.UserName;
newUser.Email = userMembership.Email;
db.WSR_UserInfo.Add(newUser);
db.SaveChanges();
}
}
}
protected void gvUser_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string username = gvUser.Rows[e.RowIndex].Cells[1].Text;
string query = "SELECT DISTINCT UserId FROM aspnet_Users WHERE UserName = '******'";
con = new SqlConnection(conStr);
SqlDataAdapter adapter = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
adapter.Fill(dt);
//DataSet dataset = new DataSet();
//adapter.Fill(dataset);
Guid userId = Guid.Parse(dt.Rows[0][0].ToString());
using (QuizEntities context = new QuizEntities())
{
QHSEQuiz.Model.Hub hub = context.Hubs.Where(x => x.UserName == username).First();
context.Hubs.Remove(hub);
//aspnet_Profile profile = context.aspnet_Profile.Where(x => x.PropertyValuesString == username).First();
//context.aspnet_Profile.Remove(profile);
aspnet_Users user = context.aspnet_Users.Where(x => x.UserName == username).First();
context.aspnet_Users.Remove(user);
aspnet_Membership mem = context.aspnet_Membership.Where(x => x.UserId == userId).First();
context.aspnet_Membership.Remove(mem);
aspnet_UsersInRoles userInRole = context.aspnet_UsersInRoles.Where(x => x.UserId == userId).First();
context.aspnet_UsersInRoles.Remove(userInRole);
context.SaveChanges();
Response.Redirect("~/Admin/ManageUsers.aspx");
}
}
public void SetEmail(string userName, string newEmail)
{
if (string.IsNullOrEmpty(newEmail))
{
throw new ArgumentException("新的Email为空");
}
if (GetUserNameByEmail(newEmail) != null)
{
throw new ArgumentException("Email已经被注册");
}
try
{
var en = new Models.Entities();
aspnet_Users u = null;
aspnet_Membership member = null;
try
{
u = en.aspnet_Users.First(m => m.UserName == userName);
member = en.aspnet_Membership.First(m => m.UserId == u.UserId);
}
catch
{
throw new ArgumentException("用户名不存在");
}
u.Email = newEmail;
member.Email = newEmail;
member.LoweredEmail = newEmail.ToLower();
en.ApplyCurrentValues("aspnet_Users", u);
en.ApplyCurrentValues("aspnet_Membership", member);
en.SaveChanges();
}
catch
{
throw;
}
}
public ActionResult RememberMe(string email)
{
var mail = db.aspnet_Membership.Where(x => x.Email == email).SingleOrDefault();
if (mail != null)
{
Random rnd = new Random();
int yenisifre = rnd.Next();
aspnet_Membership user = new aspnet_Membership();
user.Password = Crypto.Hash(Convert.ToString(yenisifre), "MD5");
db.SaveChanges();
WebMail.SmtpServer = "smtp.gmail.com";
WebMail.EnableSsl = true;
WebMail.UserName = "******";
WebMail.Password = "******";
WebMail.SmtpPort = 587;
WebMail.Send(email, "Sonsuzbilgi.az İstifadəçi şifrəniz", "Şifrəniz:" + yenisifre);
TempData["Remember"] = "Mailinizə şifrə göndərildi ...";
}
return(RedirectToAction("Index", "Home"));
}
public string GetEmail(string userName)
{
try
{
var en = new Models.Entities();
aspnet_Users u = null;
aspnet_Membership member = null;
try
{
u = en.aspnet_Users.First(m => m.UserName == userName);
member = en.aspnet_Membership.First(m => m.UserId == u.UserId);
return(member.Email);
}
catch
{
throw new ArgumentException("用户名不存在");
}
}
catch
{
throw;
}
}
/**
* Edit user information, username cannot be edited
*/
public static void EditUser(string username, string FirstName, string LastName, string email, string password)
{
TimeTrackerEntities entity = new TimeTrackerEntities();
Users user = entity.Users.First(el => el.Username == username);
aspnet_Membership membershipUser = entity.aspnet_Membership.First(el => el.UserId == user.UserID);
if (FirstName != "")
{
user.FirstName = FirstName;
}
if (LastName != "")
{
user.LastName = LastName;
}
if (email != "")
{
membershipUser.Email = email;
}
if (password != "")
{
membershipUser.Password = password;
}
entity.SaveChanges();
}
partial void Insertaspnet_Membership(aspnet_Membership instance);
/// <summary>
/// Create a new aspnet_Membership object.
/// </summary>
/// <param name="userId">Initial value of UserId.</param>
/// <param name="password">Initial value of Password.</param>
/// <param name="passwordFormat">Initial value of PasswordFormat.</param>
/// <param name="passwordSalt">Initial value of PasswordSalt.</param>
/// <param name="isApproved">Initial value of IsApproved.</param>
/// <param name="isLockedOut">Initial value of IsLockedOut.</param>
/// <param name="createDate">Initial value of CreateDate.</param>
/// <param name="lastLoginDate">Initial value of LastLoginDate.</param>
/// <param name="lastPasswordChangedDate">Initial value of LastPasswordChangedDate.</param>
/// <param name="lastLockoutDate">Initial value of LastLockoutDate.</param>
/// <param name="failedPasswordAttemptCount">Initial value of FailedPasswordAttemptCount.</param>
/// <param name="failedPasswordAttemptWindowStart">Initial value of FailedPasswordAttemptWindowStart.</param>
/// <param name="failedPasswordAnswerAttemptCount">Initial value of FailedPasswordAnswerAttemptCount.</param>
/// <param name="failedPasswordAnswerAttemptWindowStart">Initial value of FailedPasswordAnswerAttemptWindowStart.</param>
public static aspnet_Membership Createaspnet_Membership(global::System.Guid userId, string password, int passwordFormat, string passwordSalt, bool isApproved, bool isLockedOut, global::System.DateTime createDate, global::System.DateTime lastLoginDate, global::System.DateTime lastPasswordChangedDate, global::System.DateTime lastLockoutDate, int failedPasswordAttemptCount, global::System.DateTime failedPasswordAttemptWindowStart, int failedPasswordAnswerAttemptCount, global::System.DateTime failedPasswordAnswerAttemptWindowStart)
{
aspnet_Membership aspnet_Membership = new aspnet_Membership();
aspnet_Membership.UserId = userId;
aspnet_Membership.Password = password;
aspnet_Membership.PasswordFormat = passwordFormat;
aspnet_Membership.PasswordSalt = passwordSalt;
aspnet_Membership.IsApproved = isApproved;
aspnet_Membership.IsLockedOut = isLockedOut;
aspnet_Membership.CreateDate = createDate;
aspnet_Membership.LastLoginDate = lastLoginDate;
aspnet_Membership.LastPasswordChangedDate = lastPasswordChangedDate;
aspnet_Membership.LastLockoutDate = lastLockoutDate;
aspnet_Membership.FailedPasswordAttemptCount = failedPasswordAttemptCount;
aspnet_Membership.FailedPasswordAttemptWindowStart = failedPasswordAttemptWindowStart;
aspnet_Membership.FailedPasswordAnswerAttemptCount = failedPasswordAnswerAttemptCount;
aspnet_Membership.FailedPasswordAnswerAttemptWindowStart = failedPasswordAnswerAttemptWindowStart;
return aspnet_Membership;
}
/// <summary>
/// There are no comments for aspnet_Membership in the schema.
/// </summary>
public void AddToaspnet_Membership(aspnet_Membership aspnet_Membership)
{
base.AddObject("aspnet_Membership", aspnet_Membership);
}
public ActionResult KullaniciEkle(Kullanici k)
{
MembershipCreateStatus durum; //yeni bir kullanıcı oluşturma girişiminin durumunu gösterir. CreateUser işleminin durumuna göre değer döndürür.
Membership.CreateUser(k.KulaniciAdi, k.Sifre, k.Mail, "kimsin", "benim", true, out durum);
string mesaj = "";
switch (durum)
{
case MembershipCreateStatus.Success:
break;
case MembershipCreateStatus.InvalidUserName:
mesaj += "Gecersiz kullanıcı adı girildi.";
break;
case MembershipCreateStatus.InvalidPassword:
mesaj += "Gecersiz parola girildi.";
break;
case MembershipCreateStatus.InvalidQuestion:
mesaj += "Gecersiz gizli soru girildi.";
break;
case MembershipCreateStatus.InvalidAnswer:
mesaj += "Gecersiz gizli cevap girildi.";
break;
case MembershipCreateStatus.InvalidEmail:
mesaj += "Gecersiz mail girildi.";
break;
case MembershipCreateStatus.DuplicateUserName:
mesaj += "Kullanılmış kullanıcı girildi.";
break;
case MembershipCreateStatus.DuplicateEmail:
mesaj += "Kullanılmış Mail Adresi girildi.";
break;
case MembershipCreateStatus.UserRejected:
mesaj += "Bu kullanıcı engellenmiştir.";
break;
case MembershipCreateStatus.InvalidProviderUserKey:
mesaj += "Gecersiz kullanıcı key hatası girildi.";
break;
case MembershipCreateStatus.DuplicateProviderUserKey:
mesaj += "Kullanılmış kullanıcı key girildi.";
break;
case MembershipCreateStatus.ProviderError:
mesaj += "Üye yöneticisi hatası";
break;
default:
break;
}
if (durum == MembershipCreateStatus.Success)
{
aspnet_Membership ms = db.aspnet_Memberships.FirstOrDefault(x => x.aspnet_User.UserName == k.KulaniciAdi);
ms.Name = k.Name;
ms.Surname = k.Surname;
db.SubmitChanges();
return(RedirectToAction("KullaniciListesi"));
}
else
{
ViewBag.mesaj = mesaj;
}
return(View());
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
try
{
var userManager = context.OwinContext.GetUserManager <IdemMigrationUserManager>();
aspnet_Membership user = null;
user = await userManager.FindByNameAsync(context.UserName);
//verifico l'esistenza dell'utente
if (user == null)
{
context.SetError("Credenziali non valide", "Username inesistente.");
return;
}
//abilta CORS aggiungendo le origini abilitate per le richieste (javascript da un altor dominio)
var allowedOrigin = context.OwinContext.Get <string>("as:clientAllowedOrigin");
if (allowedOrigin == null)
{
allowedOrigin = "*";
}
context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { allowedOrigin });
//var userManager = context.OwinContext.GetUserManager<ApplicationUserManager>();
////abilta CORS TODO da verificare
//context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" });
user = await userManager.FindAsync(context.UserName, context.Password);
if (user == null)
{
context.SetError("invalid_grant", "Username o password non corretta.");
return;
}
ClaimsIdentity oAuthIdentity = null;
try
{
//Generazione
oAuthIdentity = await user.GenerateUserIdentityAsync(userManager, OAuthDefaults.AuthenticationType, context.UserName);
}
catch (Exception ex)
{
throw ex;
}
//Recupero la lista dei ruoli
//List<Claim> roles = oAuthIdentity.Claims.Where(c => c.Type == ClaimTypes.Role).ToList();
//creazione delle proprietà con aggiunta della lista dei ruoli
IdemClaims idemClaims = new IdemClaims();
idemClaims.UserName = user.UserName;
idemClaims.Roles = JsonConvert.SerializeObject(await userManager.GetRolesAsync(user.Id));
var info = userManager.GetUserIdemInfo(user.UserName);
if (info != null)
{
idemClaims.Id = info.IDPersonale;
idemClaims.Cognome = info.Cognome;
idemClaims.Nome = info.Nome;
}
AuthenticationProperties properties = CreateCustomProperties(idemClaims);
AuthenticationTicket ticket = new AuthenticationTicket(oAuthIdentity, properties);
context.Validated(ticket);
}
catch (Exception ex)
{
throw ex;
}
}
protected override void Seed(PluralSightBookContext context)
{
try
{
//var tables = new List<string>()
//{
// "aspnet_Application",
// "aspnet_Membership",
// "aspnet_User",
// "Friend"
//};
//foreach (var tableName in tables)
//{
// context.Database.ExecuteSqlCommand(string.Format("DELETE {0}", tableName));
// context.SaveChanges();
//}
aspnet_Applications app = context.aspnet_Applications.FirstOrDefault(a => a.ApplicationName == "Test");
if (app == null)
{
app = new aspnet_Applications()
{
ApplicationId = Guid.NewGuid(),
ApplicationName = "Test",
Description = "Test App",
LoweredApplicationName = "test"
};
context.aspnet_Applications.Add(app);
}
aspnet_Users user = context.aspnet_Users.FirstOrDefault(u => u.UserName == TEST_USERNAME);
if (user == null)
{
user = new aspnet_Users()
{
ApplicationId = app.ApplicationId,
UserId = Guid.NewGuid(),
UserName = TEST_USERNAME,
LastActivityDate = DateTime.Now,
LoweredUserName = TEST_USERNAME
};
context.aspnet_Users.Add(user);
}
aspnet_Membership member = context.aspnet_Membership.FirstOrDefault(m => m.UserId == user.UserId);
if (member == null)
{
member = new aspnet_Membership()
{
ApplicationId = app.ApplicationId,
CreateDate = DateTime.Now,
Email = TEST_EMAIL,
LoweredEmail = TEST_EMAIL,
Password = String.Empty,
PasswordSalt = String.Empty,
UserId = user.UserId,
LastPasswordChangedDate = DateTime.Now,
LastLockoutDate = DateTime.Now,
LastLoginDate = DateTime.Now,
Comment = String.Empty,
FailedPasswordAnswerAttemptCount = 0,
FailedPasswordAnswerAttemptWindowStart = DateTime.Now,
FailedPasswordAttemptCount = 0,
FailedPasswordAttemptWindowStart = DateTime.Now
};
context.aspnet_Membership.Add(member);
}
context.SaveChanges();
// remove test user's friends
foreach (var friend in context.Friends.Where(f => f.UserId == user.UserId))
{
context.Friends.Remove(friend);
}
context.SaveChanges();
}
//catch (DbEntityValidationException ex)
//{
// Console.Error.WriteLine(ex.ToString());
// foreach (var errors in ex.EntityValidationErrors)
// {
// foreach (var error in errors.ValidationErrors)
// {
// Console.Error.WriteLine("Property: {0} Error: {1}", error.PropertyName, error.ErrorMessage);
// }
// }
//}
catch (Exception ex)
{
Console.Error.WriteLine(ex.ToString());
}
base.Seed(context);
}
partial void Updateaspnet_Membership(aspnet_Membership instance);
/// <summary>
/// Update profile to DB
/// </summary>
/// <param name="p">aspnet_Membership</param>
public void updateProfile(aspnet_Membership p, string user)
{
aspnet_Membership oldProfile = getProfileByUserName(user);
if (oldProfile != null)
{
oldProfile.Email = p.Email;
oldProfile.LoweredEmail = p.Email;
oldProfile.phone_number = p.phone_number;
oldProfile.title = p.title;
oldProfile.fullName = p.fullName;
db.SubmitChanges();
}
}
public void ResetPassword(string validationCode, string newPassword)
{
if (string.IsNullOrEmpty(validationCode))
{
throw new ArgumentNullException("验证码为空");
}
if (string.IsNullOrEmpty(newPassword))
{
throw new ArgumentNullException("新密码不能为空");
}
if (newPassword.Length < 6)
{
throw new ArgumentNullException("新密码不能少于6个字符");
}
try
{
var en = new Models.Entities();
aspnet_Users u = null;
try
{
u = en.aspnet_Users.First(m => m.ValidationCode == validationCode);
}
catch
{
throw new ArgumentException("用户名不存在");
}
if (((DateTime)u.validUntil).CompareTo(DateTime.Now) < 0)
{
throw new ArgumentException("验证码过期");
}
aspnet_Membership member = en.aspnet_Membership.First(m => m.UserId == u.UserId);
var userName = u.UserName;
var email = member.Email;
var cd = member.CreateDate;
var lld = member.LastLoginDate;
var unc = u.UserNameChanged;
// delete old user
en.DeleteObject(member);
en.DeleteObject(u);
en.SaveChanges();
// recreate the user
CreateUser(userName, newPassword, email);
// copy the old user's attrs to the new one
try
{
var newU = en.aspnet_Users.First(m => m.UserName == userName);
var newMember = en.aspnet_Membership.First(m => m.UserId == newU.UserId);
newU.UserNameChanged = unc;
newMember.CreateDate = cd;
newMember.LastLoginDate = lld;
en.ApplyCurrentValues("aspnet_Users", newU);
en.ApplyCurrentValues("aspnet_Membership", newMember);
en.SaveChanges();
}
catch
{
throw new ArgumentException("用户名不存在");
}
return;
}
catch
{
throw;
}
}
public ActionResult Edit([Bind(Include = "UserName,Password,PasswordFormat,PasswordSalt,CreateDate,ApplicationId,UserId,LastLoginDate,LoweredEmail,passwordChange,IsApproved,IsLockedOut,Comment,LastLockoutDate,FailedPasswordAttemptCount,FailedPasswordAttemptWindowStart,FailedPasswordAnswerAttemptCount,FailedPasswordAnswerAttemptWindowStart,RoleId, LastPasswordChangedDate")] aspnet_Membership aspnet_Membership)
{
if (ModelState.IsValid)
{
if (!String.IsNullOrWhiteSpace(aspnet_Membership.passwordChange))
{
var member = Membership.GetUser(aspnet_Membership.UserName.ToString());
if (member != null)
{
var passwordReset = Membership.EnablePasswordReset;
var result = member.ChangePassword(member.ResetPassword(), aspnet_Membership.passwordChange);
aspnet_Membership.LastPasswordChangedDate = DateTime.Now;
}
else
{
ModelState.AddModelError(string.Empty, "Error occured updating user password.");
}
}
//If Role selected in dropdown, Add or Change Users
var user = db.aspnet_Users.Where(a => a.UserId == aspnet_Membership.UserId).FirstOrDefault();
if (aspnet_Membership.RoleId != Guid.Empty)
{
var userCurrentRole = db.aspnet_UsersInRoles.Where(e => e.UserId == user.UserId).FirstOrDefault();
var addRole = db.aspnet_Roles.Where(e => e.RoleId == aspnet_Membership.RoleId).FirstOrDefault();
var application = db.aspnet_Applications.Where(p => p.ApplicationId == user.ApplicationId).FirstOrDefault();
if (addRole != null)
{
aspnet_UsersInRoles addRoleToUser = new aspnet_UsersInRoles
{
UserId = user.UserId,
RoleId = addRole.RoleId
};
//If the User already had a role and they do not already have the role selected
if (userCurrentRole == null)
{
db.aspnet_UsersInRoles.Add(addRoleToUser);
}
else
{
if (!db.aspnet_UsersInRoles.Any(r => r.RoleId == addRoleToUser.RoleId && r.UserId == addRoleToUser.UserId))
{
var userCurrentRoleName = (db.aspnet_Roles.Where(e => e.RoleId == userCurrentRole.RoleId).FirstOrDefault()).RoleName;
if (userCurrentRole.RoleId != aspnet_Membership.RoleId)
{
db.aspnet_UsersInRoles.Remove(userCurrentRole);
db.aspnet_UsersInRoles.Add(addRoleToUser);
}
}
}
}
}
db.Entry(aspnet_Membership).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var roles = db.aspnet_Roles.ToList();
aspnet_Membership.UserRoles = roles.Select(role => new SelectListItem()
{
Selected = false, Text = role.RoleName, Value = role.RoleId.ToString()
}).ToList();
aspnet_Membership.ApplicationId = db.aspnet_Applications.Where(a => a.ApplicationName == "Hubbard House Survey Analysis System").SingleOrDefault().ApplicationId;
return(View(aspnet_Membership));
}
public void updateProfile(aspnet_Membership p, string user)
{
}
partial void Deleteaspnet_Membership(aspnet_Membership instance);
private void detach_aspnet_Memberships(aspnet_Membership entity)
{
this.SendPropertyChanging();
entity.aspnet_Application = null;
}
