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); }
}
