Contents tagged with Linq - Entities
-
ChangePassword Method for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the ChangePassword method. I welcome any suggestions for improvement.
public override bool ChangePassword(string username, string oldPassword, string newPassword) { try { byte[] hashedNewPassword = HashPassword(newPassword.Trim()); byte[] hashedOldPassword = HashPassword(oldPassword.Trim()); using (var context = new SSSEntities()) { UserProfile u = context.UserProfiles .SingleOrDefault(up => up.UserName == username && up.UserPassword == hashedOldPassword); if (u != null) { u.UserPassword = hashedNewPassword; context.SaveChanges(); return true; } else return false; } } catch (InvalidOperationException ex) { throw ex; } catch (ArgumentException) { throw; } }
[SIGNATURE] -
GetUser Methods for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the GetUser methods. I welcome any suggestions for improvement.
public override MembershipUser GetUser(object providerUserKey, bool userIsOnline) { using (var context = new SSSEntities()) { UserProfile u = context.UserProfiles .SingleOrDefault(up => up.UserId == Convert.ToInt32(providerUserKey)); MembershipUser membershipUser = GetMembershipUser(u); return membershipUser; } } public override MembershipUser GetUser(string username, bool userIsOnline) { using (var context = new SSSEntities()) { UserProfile u = context.UserProfiles .SingleOrDefault(up => up.UserName == username); MembershipUser membershipUser = GetMembershipUser(u); return membershipUser; } } // custom method to return a UserProfile public UserProfile GetUser(string username) { using (var context = new SSSEntities()) { UserProfile u = context.UserProfiles .SingleOrDefault(up => up.UserName == username); return u; } } // custom method to return a UserProfile public UserProfile GetUser(object providerUserKey) { using (var context = new SSSEntities()) { UserProfile u = context.UserProfiles .SingleOrDefault(up => up.UserId == Convert.ToInt32(providerUserKey)); return u; } }
[SIGNATURE] -
CreateUser Method for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the CreateUser method. I welcome any suggestions for improvement.
public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status) { // only first 3 fields are passed in from the AccountModels.cs try { status = UsernameExists(username); if (status == MembershipCreateStatus.DuplicateUserName) { return null; } status = DuplicateEmail(email); if (status == MembershipCreateStatus.DuplicateEmail) { return null; } byte[] hashedPassword = HashPassword(password.Trim()); GetValues gv = new GetValues(); string ipAddress = gv.getIPAddress(); int userStatus = Convert.ToInt32(SSS.GlobalListValues.Enums.UserStatusCode.Active); using (var context = new SSSEntities()) { UserProfile newUser = new UserProfile() { Email = email, UserPassword = hashedPassword, UserName = username, DateCreated = DateTime.Now, DateUpdated = DateTime.Now, DatePasswordLastChanged = DateTime.Now, DateLastLogin = DateTime.Now, UserStatusCode = userStatus, IpAddress = ipAddress, }; // insert the User Role int userRole = Convert.ToInt32(SSS.GlobalListValues.Enums.UserRoleCode.User_Public); // look up the desired user role : // uses a UserRole join table with a many to many relation // between the UserProfile table and the ListValue table ListValue ur = context.ListValues .SingleOrDefault(lv => lv.ListValueId == userRole); newUser.UserProfileUserRoles.Add(ur); context.UserProfiles.AddObject(newUser); context.SaveChanges(); // NKT: after creation, go back and retrieve the auto-generated identity key and // update the userId's for the created and updated userId int userId = newUser.UserId; newUser.CreatedUserId = userId; newUser.UpdatedUserId = userId; context.SaveChanges(); status = MembershipCreateStatus.Success; return GetMembershipUser(newUser); } } catch (ArgumentException) { status = MembershipCreateStatus.ProviderError; return null; } }
[SIGNATURE] -
DeleteUser Method for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the DeleteUser method. I welcome any suggestions for improvement.
public override bool DeleteUser(string username, bool deleteAllRelatedData) { // deleteAllRelatedData not implemented try { using (var context = new SSSEntities()) { UserProfile u = context.UserProfiles .SingleOrDefault(up => up.UserName == username); context.UserProfiles.DeleteObject(u); context.SaveChanges(); return true; } } catch { return false; }
[SIGNATURE] -
UsernameExists & DuplicateEmail Helper Methods for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the UsernameExists & DuplicateEmail Helper methods. I welcome any suggestions for improvement.
// helper method public MembershipCreateStatus UsernameExists(string username) { using (var context = new SSSEntities()) { if (context.UserProfiles.Any( u => u.UserName == username)) { return MembershipCreateStatus.DuplicateUserName; } return MembershipCreateStatus.Success; } } // helper method public MembershipCreateStatus DuplicateEmail(string email) { using (var context = new SSSEntities()) { if (context.UserProfiles.Any( u => u.Email == email)) { return MembershipCreateStatus.DuplicateEmail; } return MembershipCreateStatus.Success; } }
[SIGNATURE] -
GetMembershipUser Helper Method for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the GetMembershipUser Helper method. I welcome any suggestions for improvement. Since we are working with a UserProfile Entity and the Membership Provider overridable methods require we return a MembershipUser type, below we create our MembershipUser type using values from our UserProfile type so we can return the required type in our methods.
// helper method public MembershipUser GetMembershipUser(UserProfile u) { // copy pertinent UserProfile data to the MembershipUser
// data to be returned as a MembershipUser type object userIDObj = u.UserId; MembershipUser membershipUser = new MembershipUser( this.Name, u.UserName, userIDObj, u.Email, string.Empty, string.Empty, true, false, (DateTime)u.DateCreated, (DateTime)u.DateLastLogin, (DateTime)u.DateUpdated, (DateTime)u.DateLastLogin, (DateTime)u.DateLastLogin); return membershipUser; }
[SIGNATURE] -
HashPassword Method for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the HashPassword method. I welcome any suggestions for improvement.
// helper method private byte[] HashPassword(string password) { // NKT: This will only work with a new database,
// otherwise existing passwords will be broken. // If you use this, be sure to set the saltvalue to your own
// customization in the web.config file in your web app // <add key="SaltValue" value="*!ShiningStar!*" /> // This won't work with an existing database, as they won't have the salt value // so make sure you alter the password hash or encryption as needed for an existing database... CryptoProvider crypto = new CryptoProvider(); byte[] hashedPassword = crypto.EncryptData(password.Trim()); return hashedPassword; } public static string GetSaltValue() { string saltValue = ConfigurationManager.AppSettings["SaltValue"]; return saltValue; } public byte[] EncryptData(string dataString) { // NKT: custom method using functionality from this article // http://www.4guysfromrolla.com/articles/103002-1.2.aspx // salting has value //http://www.4guysfromrolla.com/articles/112002-1.aspx // this isn't as secure as a unique salt per user, but if you use a unique salt per site,
//at least they won't know that salt value if they steal the
// database and not the web.config file // store the saltvalue in the web.config file. make unique per website. string saltedString = dataString + GetSaltValue(); MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider(); byte[] hashedDataBytes = null; UTF8Encoding encoder = new UTF8Encoding(); hashedDataBytes = md5Hasher.ComputeHash(encoder.GetBytes(saltedString)); return hashedDataBytes; }
[SIGNATURE] -
ValidateUser Method for Entity Framework MVC3 Razor Custom Member Provider C# Using LINQ
From my C# MVC3 Razor Custom Membership Provider article and source code, here is the code for the ValidateUser method. I welcome any suggestions for improvement.
public override bool ValidateUser(string username, string password) { // PasswordFormat = Hashed byte[] hashedPassword = HashPassword(password.Trim()); // NKT: LINQ to Entities does not recognize // the method 'Int32 ToInt32(System.Object)' method, // and this method cannot be translated into a store expression. int userStatus = Convert.ToInt32(SSS.GlobalListValues.Enums.UserStatusCode.Active); using (var context = new SSSEntities()) { var query = from u in context.UserProfiles where u.UserName == username && u.UserPassword == hashedPassword && u.UserStatusCode == userStatus select u; bool isUserFound = false; foreach (var user in query.Take(1)) { isUserFound = true; } return isUserFound; } }
[SIGNATURE] -
C# MVC3 Razor Entity Framework & LINQ Custom Membership Provider with Custom Role Provider
This C# project demonstrates how to create an MVC3 Razor Entity Framework & LINQ Custom Membership Provider with Custom Role Provider. Perhaps you are working with a legacy database or you prefer working with a database that uses numeric identity keys instead of Guids. The example UserProfile table in this project uses an integer UserId as the primary key and various other fields that aren't in the default ASP.NET User table. Use the Log On Link in the project and the Register link to create your own account.
-
101 Linq Samples - Entity Framework
MSDN has provided an invaluable resource to 101 Linq Samples in C# or 101 Linq Samples in VB.NET.