public void AddUserAccount(UserSignUpView user) { using (DemoDBEntities db = new DemoDBEntities()) { SYSUser SU = new SYSUser(); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SU.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;; SU.RowCreatedDateTime = DateTime.Now; SU.RowMOdifiedDateTime = DateTime.Now; db.SYSUsers.Add(SU); db.SaveChanges(); SYSUserProfile SUP = new SYSUserProfile(); SUP.SYSUserID = SU.SYSUserID; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SYSUserProfiles.Add(SUP); db.SaveChanges(); if (user.LOOKUPRoleID > 0) { SYSUserRole SUR = new SYSUserRole(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID :1; SUR.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID :1; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SYSUserRoles.Add(SUR); db.SaveChanges(); } } }
protected override bool AuthorizeCore(HttpContextBase httpContext) { bool authorize = false; using (DemoDBEntities db = new DemoDBEntities()) { UserManager UM = new UserManager(); foreach (var roles in userAssignedRoles) { authorize = UM.IsUserInRole(httpContext.User.Identity.Name, roles); if (authorize) { return(authorize); } } } return(authorize); }
public List <BukuView> GetBukuData() { using (DemoDBEntities db = new DemoDBEntities()) { var Buku = db.Bukus.Select(o => new BukuView { id_buku = o.id_buku, ISBN = o.ISBN, judul = o.judul, penulis = o.penulis, penerbit = o.penerbit, tahun = o.tahun, stok = o.stok, harga_beli = o.harga_beli, harga_jual = o.harga_jual, }).ToList(); return(Buku); } }
public string GetUserPassword(string loginName) { using (DemoDBEntities db = new DemoDBEntities()) { var user = db.SYSUsers.Where(o => o.LoginName.ToLower().Equals(loginName)); if (user.Any()) { return(user.FirstOrDefault().PasswordEncryptedText); } else { return(string.Empty); } } }
public List <UserMessage> GetAllMessages() { using (var db = new DemoDBEntities()) { var m = (from q in db.SYSUsers join q2 in db.Messages on q.SYSUserID equals q2.SYSUserID join q3 in db.SYSUserProfiles on q.SYSUserID equals q3.SYSUserID select new UserMessage { MessageID = q2.MessageID, SYSUserID = q.SYSUserID, FirstName = q3.FirstName, LastName = q3.LastName, MessageText = q2.MessageText, LogDate = q2.DatePosted }).OrderBy(o => o.LogDate); return(m.ToList()); } }
public bool IsUserInRole(string loginName, string roleName) { using (DemoDBEntities db = new DemoDBEntities()) { SYSUser SU = db.SYSUser.Where(o => o.LoginName.ToLower().Equals(loginName)).FirstOrDefault(); if (SU != null) { var role = from q in db.SYSUserRole join r in db.LOOKUPRole on q.LOOKUPRoleID equals r.LOOKUPRoleID where r.RoleName.Equals(roleName) && q.SYSUserID.Equals(SU.SYSUserID) select r.RoleName; if (role != null) { return(role.Any()); } } return(false); } }
public UserDataView GetUserDataView(string loginName) { UserDataView UDV = new UserDataView(); List <UserProfileView> profiles = GetAllUserProfiles(); List <LOOKUPAvailableRole> roles = GetAllRoles(); int? userAssignedRoleID = 0, userID = 0; string userGender = string.Empty; userID = GetUserID(loginName); using (DemoDBEntities db = new DemoDBEntities()) { userAssignedRoleID = db.SYSUserRoles.Where(o = > o.SYSUserID == userID)?.FirstOrDefault().LOOKUPRoleID; userGender = db.SYSUserProfiles.Where(o = > o.SYSUserID == userID)?.FirstOrDefault().Gender; } List <Gender> genders = new List <Gender>(); genders.Add(new Gender { Text = "Male", Value = "M" }); genders.Add(new Gender { Text = "Female", Value = "F" }); UDV.UserProfile = profiles; UDV.UserRoles = new UserRoles { SelectedRoleID = userAssignedRoleID, UserRoleList = roles }; UDV.UserGender = new UserGender { SelectedGender = userGender, Gender = genders }; return(UDV); }
public UserProfileView GetUserProfile(int userID) { UserProfileView UPV = new UserProfileView(); using (DemoDBEntities db = new DemoDBEntities()) { var user = db.SYSUsers.Find(userID); if (user != null) { UPV.SYSUserID = user.SYSUserID; UPV.LoginName = user.LoginName; UPV.Password = user.PasswordEncryptedText; var SUP = db.SYSUserProfiles.Find(userID); if (SUP != null) { UPV.FirstName = SUP.FirstName; UPV.LastName = SUP.LastName; UPV.Gender = SUP.Gender; } var SUR = db.SYSUserRoles.Find(userID); if (SUR != null) { UPV.LOOKUPRoleID = SUR.LOOKUPRoleID; UPV.RoleName = SUR.LOOKUPRole.RoleName; UPV.IsRoleActive = SUR.IsActive; } } } return(UPV); }
public bool Update(RegistrationEntity entity) { bool isupated = false; using (var db = new DemoDBEntities()) { RegistartionMaster record = db.RegistartionMasters.Find(entity.Id); record.Address = entity.Address; record.Emailid = entity.Emailid; record.FullName = entity.FullName; record.Gender = entity.Gender; record.IsActive = true; record.Mobno = entity.Mobno; db.SaveChanges(); isupated = true; } return(isupated); }
public List <UserProfileView> GetAllUserProfiles() { List <UserProfileView> profiles = new List <UserProfileView>(); using (DemoDBEntities db = new DemoDBEntities()) { UserProfileView UPV; var users = db.SYSUsers.ToList(); foreach (SYSUser u in db.SYSUsers) { UPV = new UserProfileView(); UPV.SYSUserID = u.SYSUserID; UPV.LoginName = u.LoginName; UPV.Password = u.PasswordEncryptedText; var SUP = db.SYSUserProfiles.Find(u.SYSUserID); if (SUP != null) { UPV.FirstName = SUP.FirstName; UPV.LastName = SUP.LastName; UPV.Gender = SUP.Gender; } var SUR = db.SYSUserRoles.Where(o => o.SYSUserID.Equals(u.SYSUserID)); if (SUR.Any()) { var userRole = SUR.FirstOrDefault(); UPV.LOOKUPRoleID = userRole.LOOKUPRoleID; UPV.RoleName = userRole.LOOKUPRole.RoleName; UPV.IsRoleActive = userRole.IsActive; } profiles.Add(UPV); } } return(profiles); }
public void DeleteUser(int userID) { using (DemoDBEntities db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var SUR = db.SYSUserRoles.Where(o => o.SYSUserID == userID); if (SUR.Any()) { db.SYSUserRoles.Remove(SUR.FirstOrDefault()); db.SaveChanges(); } var SUP = db.SYSUserProfiles.Where(o => o.SYSUserID == userID); if (SUP.Any()) { db.SYSUserProfiles.Remove(SUP.FirstOrDefault()); db.SaveChanges(); } var SU = db.SYSUsers.Where(o => o.SYSUserID == userID); if (SU.Any()) { db.SYSUsers.Remove(SU.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void DeleteUser(int userId) { using (var db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var sur = db.SYSUserRoles.Where(o => o.SYSUserID == userId); if (sur.Any()) { db.SYSUserRoles.Remove(sur.FirstOrDefault()); db.SaveChanges(); } var sup = db.SYSUserProfiles.Where(o => o.SYSUserID == userId); if (sup.Any()) { db.SYSUserProfiles.Remove(sup.FirstOrDefault()); db.SaveChanges(); } var su = db.SYSUsers.Where(o => o.SYSUserID == userId); if (su.Any()) { db.SYSUsers.Remove(su.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } } }
public void DeleteBuku(int bukuID) { using (DemoDBEntities db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var Bk = db.Bukus.Where(o => o.id_buku == bukuID); if (Bk.Any()) { db.Bukus.Remove(Bk.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public List <UserProfileView> GetAllUserProfiles() { List <UserProfileView> profiles = new List <UserProfileView>(); using (DemoDBEntities db = new DemoDBEntities()) { var users = db.SYSUsers.ToList(); foreach (var u in db.SYSUsers) { var upv = new UserProfileView { SYSUserID = u.SYSUserID, LoginName = u.LoginName, Password = u.PasswordEncryptedText }; var sup = db.SYSUserProfiles.Find(u.SYSUserID); if (sup != null) { upv.FirstName = sup.FirstName; upv.LastName = sup.LastName; upv.Gender = sup.Gender; } var sur = db.SYSUserRoles.Where(o => o.SYSUserID.Equals(u.SYSUserID)); if (sur.Any()) { var userRole = sur.FirstOrDefault(); upv.LOOKUPRoleID = userRole.LOOKUPRoleID; upv.RoleName = userRole.LOOKUPRole.RoleName; upv.IsRoleActive = userRole.IsActive; } profiles.Add(upv); } } return(profiles); }
public List <RegistrationEntity> Get() { List <RegistrationEntity> list = new List <RegistrationEntity>(); using (var db = new DemoDBEntities()) { var records = db.RegistartionMasters.Where(x => x.IsActive == true).ToList(); foreach (var item in records) { RegistrationEntity entity = new RegistrationEntity(); entity.Id = item.Id; entity.FullName = item.FullName; entity.Gender = item.Gender; entity.Emailid = item.Emailid; entity.Address = item.Address; entity.Mobno = item.Mobno; list.Add(entity); } } return(list); }
public void UpdateUserAccount(UserProfileView user) { using (DemoDBEntities db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { SYSUser SU = db.SYSUsers.Find(user.SYSUserID); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSYSUserID = user.SYSUserID; SU.RowModifiedSYSUserID = user.SYSUserID; SU.RowCreatedDateTime = DateTime.Now; SU.RowMOdifiedDateTime = DateTime.Now; db.SaveChanges(); var userProfile = db.SYSUserProfiles.Where(o => o.SYSUserID == user.SYSUserID); if (userProfile.Any()) { SYSUserProfile SUP = userProfile.FirstOrDefault(); SUP.SYSUserID = SU.SYSUserID; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSYSUserID = user.SYSUserID; SUP.RowModifiedSYSUserID = user.SYSUserID; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); } if (user.LOOKUPRoleID > 0) { var userRole = db.SYSUserRoles.Where(o => o.SYSUserID == user.SYSUserID); SYSUserRole SUR = null; if (userRole.Any()) { SUR = userRole.FirstOrDefault(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID; SUR.RowModifiedSYSUserID = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; } else { SUR = new SYSUserRole(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID; SUR.RowModifiedSYSUserID = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SYSUserRoles.Add(SUR); } db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void UpdateUserAccount(UserProfileView user) { using (var db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var su = db.SYSUsers.Find(user.SYSUserID); su.LoginName = user.LoginName; su.PasswordEncryptedText = user.Password; su.RowCreatedSYSUserID = user.SYSUserID; su.RowModifiedSYSUserID = user.SYSUserID; su.RowCreatedDateTime = DateTime.Now; su.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); var userProfile = db.SYSUserProfiles.Where(o => o.SYSUserID == user.SYSUserID); if (userProfile.Any()) { var sup = userProfile.FirstOrDefault(); sup.SYSUserID = su.SYSUserID; sup.FirstName = user.FirstName; sup.LastName = user.LastName; sup.Gender = user.Gender; sup.RowCreatedSYSUserID = user.SYSUserID; sup.RowModifiedSYSUserID = user.SYSUserID; sup.RowCreatedDateTime = DateTime.Now; sup.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); } if (user.LOOKUPRoleID > 0) { var userRole = db.SYSUserRoles.Where(o => o.SYSUserID == user.SYSUserID); SYSUserRole sur = null; if (userRole.Any()) { sur = userRole.FirstOrDefault(); sur.LOOKUPRoleID = user.LOOKUPRoleID; sur.SYSUserID = user.SYSUserID; sur.IsActive = true; sur.RowCreatedSYSUserID = user.SYSUserID; sur.RowModifiedSYSUserID = user.SYSUserID; sur.RowCreatedDateTime = DateTime.Now; sur.RowModifiedDateTime = DateTime.Now; } else { sur = new SYSUserRole { LOOKUPRoleID = user.LOOKUPRoleID, SYSUserID = user.SYSUserID, IsActive = true, RowCreatedSYSUserID = user.SYSUserID, RowModifiedSYSUserID = user.SYSUserID, RowCreatedDateTime = DateTime.Now, RowModifiedDateTime = DateTime.Now }; db.SYSUserRoles.Add(sur); } db.SaveChanges(); } dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } } }
public bool IsLoginNameExist(string loginName) { using (DemoDBEntities db = new DemoDBEntities()) { return(db.SYSUsers.Where(o => o.LoginName.Equals(loginName)).Any()); } }
//This method takes a UserProfileView object as the parameter. //This parameter is coming from a stringly-typed View. //It first issies a query to the database using the LINQ syntax //to get the specific user data by passing the SYSUserID //It then updates the SYSUser object with the corresponding data from the UserProfileView object. public void UpdateUserAccount(UserProfileView user) { using (DemoDBEntities db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { SYSUser SU = db.SYSUsers.Find(user.SYSUserID); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSYSUserID = user.SYSUserID; SU.RowModifiedSYSUserID = user.SYSUserID; SU.RowCreatedDateTime = DateTime.Now; SU.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); //This query gets the associated SYSUserProfiles data and then updates the corresponding //values. After that, it then looks for the associated LOOKUPRoleID for a certain user. //If the user does not have role assigned to it, then it adds a //new record to the database, otherwise just update the table. var userProfile = db.SYSUserProfiles.Where(o => o.SYSUserID == user.SYSUserID); if (userProfile.Any()) { SYSUserProfile SUP = userProfile.FirstOrDefault(); SUP.SYSUserID = SU.SYSUserID; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSYSUserID = user.SYSUserID; SUP.RowModifiedSYSUserID = user.SYSUserID; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); } if (user.LOOKUPRoleID > 0) { var userRole = db.SYSUserRoles.Where(o => o.SYSUserID == user.SYSUserID); SYSUserRole SUR = null; if (userRole.Any()) { SUR = userRole.FirstOrDefault(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID; SUR.RowModifiedSYSUserID = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; } else { SUR = new SYSUserRole(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID; SUR.RowModifiedSYSUserID = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SYSUserRoles.Add(SUR); } db.SaveChanges(); } //We used a simple transaction within this method. //This is because the tables SYSUser, SYSUserProfile and SYSUserRole have //dependencies to each other, and we need to make sure that we only //commit changes to the database if the operation for each table //is successful. //The Database.BeginTransaction() is only available in EF 6 onwards dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
//Constructpr public user_informationRepository() { Context = new DemoDBEntities(); }
public List <LOOKUPAvailableRole> GetAllRoles() { using (DemoDBEntities db = new DemoDBEntities()) { var roles = db.LOOKUPRoles.Select(o => new LOOKUPAvailableRole { LOOKUPRoleID = o.LOOKUPRoleID, RoleName = o.RoleName, RoleDescription = o.RoleDescription }).ToList(); return(roles); } }