/// <summary>
/// Create role
/// </summary>
/// <param name="myRole">the role to add</param>
public void CreateRole(string myRole)
{
if (!MyRoleManager.RoleExists(myRole))
{
MyRoleManager.Create(new IdentityRole(myRole));
}
}
/// <summary>
/// Create roles
/// </summary>
/// <param name="roleName">a string represetning the name of the role to be created</param>
public void createRole(string roleName)
{
//check if the role exists
if (!MyRoleManager.RoleExists(roleName))
{
//create role
CreateRole(roleName);
}
}
public ActionResult AdminReport(ReportDto search)
{
if (!MyRoleManager.hasRole(MyRoleManager.RoleType.SYSTEMADMIN) && !MyRoleManager.hasRole(MyRoleManager.RoleType.DCEADMIN))
{
return(RedirectToAction("Index"));
}
search = AdminSearch(search);
ViewBag.CompaniesList = GetCompanyList.GetCompany();
return(View(search));
}
public KontaktController(
UserManager <ApplicationUser> userManager,
SignInManager <ApplicationUser> signInManager,
ILogger <AccountController> logger,
RoleManager <IdentityRole> roleMgr,
UserManager <ApplicationUser> userMrg,
MojDbContext context
)
{
_userManager = userManager;
_signInManager = signInManager;
_logger = logger;
_roleManager = new MyRoleManager(roleMgr, userMrg);
ctx = context;
}
/// <summary>
/// Create roles
/// </summary>
/// <param name="roleName">a string represetning the name of the role to be created</param>
public void removeRole(string roleName)
{
//check if the role exists
if (MyRoleManager.RoleExists(roleName))
{
var role = m_idbctx.Roles.Where(r => r.Name == roleName).FirstOrDefault();
m_idbctx.Roles.Remove(role);
m_idbctx.SaveChanges();
}
else
{
HttpContext.Current.Session["Error"] = roleName + " does not exist";
HttpContext.Current.Response.Redirect("~/UserPages/ErrorPage.aspx");
}
}
protected override void Seed(ExtJS_Store.DAL.ApplicationContext context)
{
var userManager = new MyUserManager(new UserStore <User>(context));
var roleManager = new MyRoleManager(new RoleStore <MyRole>(context));
// создаем две роли
var role1 = new MyRole {
Name = "admin"
};
var role2 = new MyRole {
Name = "user"
};
// добавляем роли в бд
roleManager.Create(role1);
roleManager.Create(role2);
// создаем пользователей
var user = new User {
Email = "*****@*****.**", UserName = "******"
};
string password = "******";
var result = userManager.Create(user, password);
// если создание пользователя прошло успешно
if (result.Succeeded)
{
// добавляем для пользователя роли
userManager.AddToRole(user.Id, role1.Name);
userManager.AddToRole(user.Id, role2.Name);
}
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
}
// GET: System
public ActionResult Role()
{
AccessAuthoritiesDto dto = new AccessAuthoritiesDto();
dto.AccessPaths = db.AccessPaths.ToList();
dto.AccessRoles = db.AccessRoles.ToList();
if (MyRoleManager.hasRole(MyRoleManager.RoleType.DCEADMIN))
{
dto.UserRole = db.UserRoles.OrderBy(ur => ur.username).Where(ur => ur.roletype != MyRoleManager.RoleType.SYSTEMADMIN).ToList();
}
else
{
dto.UserRole = db.UserRoles.OrderBy(ur => ur.username).ThenBy(ur => ur.roletype).ToList();
}
ViewBag.CompaniesList = GetCompanyList.GetCompany();
return(View(dto));
}
public static void InitWebConfig(System.Configuration.Configuration conf, bool useAcessProviders, string connectionStringName)
{
SystemWebSectionGroup websec = conf.GetSectionGroup("system.web") as SystemWebSectionGroup;
websec.Authentication.Mode = AuthenticationMode.Forms;
//if (useAcessProviders)
//{
// AccessMembershipProvider.SetPrividerSettings(websec.Membership, connectionStringName);
// AccessRoleProvider.SetRoleSettings(websec.RoleManager, connectionStringName);
//}
//else
//{
UniMembershipProvider.SetPrividerSettings(websec.Membership, connectionStringName);
MyRoleManager.SetRoleSettings(websec.RoleManager, connectionStringName);
//}
CreateHttpHandler(websec);
InitConfigSections(ref conf);
InitJcoSecuritySection(conf);
conf.Save();
}
protected override void Seed(Infrastructure.DbContext.MyIdentityDbContext context)
{
MyUserManager userManager = new MyUserManager(new UserStore <MyUser>(context));
MyRoleManager roleManager = new MyRoleManager(new RoleStore <MyRole>(context));
string roleName = "Administrator";
string userName = "******";
string password = "******";
string email = "*****@*****.**";
if (!roleManager.RoleExists(roleName))
{
roleManager.Create(new MyRole(roleName));
}
MyUser user = userManager.FindByName(userName);
if (user == null)
{
userManager.Create(new MyUser {
UserName = userName, Email = email
},
password);
user = userManager.FindByName(userName);
}
if (!userManager.IsInRole(user.Id, roleName))
{
userManager.AddToRole(user.Id, roleName);
}
foreach (MyUser dbUser in userManager.Users)
{
if (dbUser.Country == Countries.None)
{
dbUser.SetCountryFromCity(dbUser.City);
}
}
context.SaveChanges();
}
protected override void Seed(ExtStore2.DAL.ApplicationContext context)
{
var userManager = new MyUserManager(new UserStore <User>(context));
var roleManager = new MyRoleManager(new RoleStore <MyRole>(context));
// создаем две роли
var role1 = new MyRole {
Name = "admin"
};
var role2 = new MyRole {
Name = "user"
};
// добавляем роли в бд
roleManager.Create(role1);
roleManager.Create(role2);
// создаем пользователей
var user = new User
{
Email = "*****@*****.**",
UserName = "******",
Name = "Admin",
Address = "My address",
Code = "My code",
Discount = 50
};
string password = "******";
var result = userManager.Create(user, password);
// если создание пользователя прошло успешно
if (result.Succeeded)
{
// добавляем для пользователя роли
userManager.AddToRole(user.Id, role1.Name);
userManager.AddToRole(user.Id, role2.Name);
}
var products = new List <Product>
{
new Product {
Name = "Продукт 1", Price = 100, Category = "Category", Code = "Code 1"
},
new Product {
Name = "Продукт 2", Price = 500, Category = "Category", Code = "Code 2"
},
new Product {
Name = "Новый продукт 3", Price = 8350, Category = "New category", Code = "New code 1"
},
new Product {
Name = "Новый продукт 4", Price = 15613, Category = "New category", Code = "New code 2"
}
};
for (int i = 1; i <= 50; i++)
{
products.Add(new Product {
Name = "Product " + i, Price = i * 1000 + i * 3, Category = "Category " + i, Code = "Code " + i
});
}
;
products.ForEach(s => context.Products.AddOrUpdate(p => p.Name, s));
context.SaveChanges();
}
protected override void Seed(Hotel.Data.HotelDbContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
if (!context.Roles.Any(r => r.Name == "Admin"))
{
var roleManager = new MyRoleManager(new MyRoleStore(context));
var adminRole = new IdentityRole("Admin");
roleManager.Create(adminRole);
}
if (!context.Users.Any(u => u.Email == "*****@*****.**"))
{
var manager = new UserManager <Employee>(new UserStore <Employee>(context));
var user = new Employee()
{
UserName = "******",
Email = "*****@*****.**",
FirstName = "Test",
LastName = "Test"
};
manager.Create(user, "123123");
manager.AddToRole(user.Id, "Admin");
}
RoomType basic = new RoomType {
Id = 1, Title = "Basic", BasicRate = 10, LivingRoomsCount = 1, ImageUrl = "basic.jpg",
Description = "Basic setup for comfortable living with all needed features."
};
RoomType normal = new RoomType {
Id = 2, Title = "Normal", BasicRate = 15, LivingRoomsCount = 2, ImageUrl = "normal.jpg",
Description = "Extend format for comfortable living with one additional room."
};
RoomType business = new RoomType {
Id = 3, Title = "Business", BasicRate = 20, LivingRoomsCount = 3, ImageUrl = "business.jpg",
Description = "Basic setup for comfortable living with all needed features."
};
RoomType luxury = new RoomType {
Id = 4, Title = "Luxury", BasicRate = 35, LivingRoomsCount = 5, ImageUrl = "luxury.jpg",
Description = "The best apartments with perfecrt view of the city for our best guests."
};
context.RoomTypes.AddOrUpdate(basic);
context.RoomTypes.AddOrUpdate(normal);
context.RoomTypes.AddOrUpdate(business);
context.RoomTypes.AddOrUpdate(luxury);
RoomFeature condition = new RoomFeature {
Id = 1, Title = "Air condition", Description = "High quility air condition", AdditionalCost = 2
};
RoomFeature miniBar = new RoomFeature {
Id = 2, Title = "Minibar", Description = "Unlimited minibar", AdditionalCost = 3
};
context.RoomFeatures.AddOrUpdate(condition);
context.RoomFeatures.AddOrUpdate(miniBar);
Room basicRoom = new Room {
Id = 1, Floor = 2, MaxVisitorsCount = 1, Type = basic, Title = "Basic room", ImageUrl = "basic.jpg"
};
Room normalRoom = new Room {
Id = 2, Floor = 2, MaxVisitorsCount = 2, Type = normal, Title = "Normal room", ImageUrl = "normal.jpg",
Features = new System.Collections.Generic.List <RoomFeature> {
condition
}
};
Room businessRoom = new Room {
Id = 3, Floor = 5, MaxVisitorsCount = 2, Type = business, Title = "Business room", ImageUrl = "business.jpg",
Features = new System.Collections.Generic.List <RoomFeature> {
condition, miniBar
}
};
context.Rooms.AddOrUpdate(basicRoom);
context.Rooms.AddOrUpdate(normalRoom);
context.Rooms.AddOrUpdate(businessRoom);
}
public RoleController()
{
_userManager = HttpContext.Current.GetOwinContext().Get <MyUserManager>();
_roleManager = HttpContext.Current.GetOwinContext().Get <MyRoleManager>();
}
// GET: Approvals
public ActionResult History(ApprovalSearch search)
{
string currentuser = !string.IsNullOrEmpty(User?.Identity?.Name) ? User.Identity.Name.ToUpper() : "Anonymous";
currentuser = currentuser.Substring(currentuser.IndexOf('\\') + 1).Replace("\\", "").ToUpper();
ApprovalIndexDto dto = new ApprovalIndexDto();
IEnumerable <Approval> list = db.Approvals.Where(a => 1 == 1);
if (search.sp != null)
{
list = list.Where(p => p.privacy.IND_SP.Contains(search.sp));
}
if (search.hospital != null)
{
list = list.Where(p => p.privacy.WKP_NAME.Contains(search.hospital));
}
if (!MyRoleManager.hasRole(MyRoleManager.RoleType.SYSTEMADMIN) && !MyRoleManager.hasRole(MyRoleManager.RoleType.DCEADMIN))
{
list = list.Where(p => p.creater.Equals(currentuser));
}
else if (search.owner != null)
{
list = list.Where(p => p.creater.Equals(search.owner));
}
if (search.status != null && !search.status.Equals("total"))
{
if (search.status.Equals("approved"))
{
list = list.Where(p => p.status.Equals(ApprovalStatus.Approved));
}
else if (search.status.Equals("rejected"))
{
list = list.Where(p => p.status.Equals(ApprovalStatus.Rejected));
}
else if (search.status.Equals("request"))
{
list = list.Where(p => p.status.Equals(ApprovalStatus.Request));
}
}
else
{
list = list.Where(p => p.status != ApprovalStatus.Request);
}
if (search.requestbegindt != null)
{
list = list.Where(a => a.createdate >= search.requestbegindt);
}
if (search.requestenddt != null)
{
list = list.Where(a => a.createdate <= search.requestenddt);
}
if (search.approvalbegindt != null)
{
list = list.Where(a => a.modifieddate >= search.approvalbegindt);
}
if (search.approvalenddt != null)
{
list = list.Where(a => a.modifieddate <= search.approvalenddt);
}
if (!string.IsNullOrEmpty(search.owner))
{
list = list.Where(a => a.creater.Contains(search.owner));
}
if (!string.IsNullOrEmpty(search.name))
{
list = list.Where(a => a.privacy.IND_FULL_NAME.Contains(search.name));
}
dto.Approvals = list.ToList();
dto.Search = search;
ViewBag.CompaniesList = GetCompanyList.GetCompany();
return(View(dto));
}
public AccountController()
{
_userManager = HttpContext.Current.GetOwinContext().Get <MyUserManager>();
_roleManager = HttpContext.Current.GetOwinContext().Get <MyRoleManager>();
_db = new OwinApiContext();
}
// GET: Dashboard
public ActionResult Dashboard(string pcmsid = null)
{
string currentuser = !string.IsNullOrEmpty(User?.Identity?.Name) ? User.Identity.Name.ToUpper() : "Anonymous";
currentuser = currentuser.Substring(currentuser.IndexOf('\\') + 1).Replace("\\", "").ToUpper();
DashboardDto dto = new DashboardDto();
if (!MyRoleManager.hasRole(MyRoleManager.RoleType.SYSTEMADMIN) && !MyRoleManager.hasRole(MyRoleManager.RoleType.MARKETING) && !MyRoleManager.hasRole(MyRoleManager.RoleType.DCEADMIN) && !MyRoleManager.hasRole(MyRoleManager.RoleType.BUMCM))
{
dto.approvalrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Request && a.creater == currentuser).ToList().Count();
dto.rejectedrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Rejected && a.creater == currentuser).ToList().Count();
if (pcmsid == null)
{
dto.logs = db.Privacylogs.Where(p => p.creater == currentuser).OrderByDescending(p => p.createdate).Take(300).ToList();
}
else
{
dto.logs = db.Privacylogs.Where(p => p.creater == currentuser && p.privacy.PCMSID.Contains(pcmsid)).OrderByDescending(p => p.createdate).Take(300).ToList();
}
}
else if (MyRoleManager.hasRole(MyRoleManager.RoleType.DCEADMIN))
{
var query = from u in db.UserRoles
join c in db.Companies on u.COMP_CODE equals c.COMP_CODE
select c.DCE_TSA;
foreach (var q in query)
{
if (q == "Y")
{
dto.approvedrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Approved).ToList().Count();
dto.rejectedrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Rejected).ToList().Count();
dto.approvalrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Request).ToList().Count();
dto.mmscount = db.Consents.Where(c => c.CONSENT_SOURCE == @"MMS").Count();
//dto.pforcerxcount = db.Privacylogs.Where(pl => pl.creater == @"PFORCERX").Count();
dto.pforcerxcount = db.Consents.Where(c => c.CONSENT_SOURCE == @"PFORCERX").Count();
dto.hardcount = db.Consents.Where(c => c.CONSENT_SOURCE != @"MMS" && c.CONSENT_SOURCE != @"GRV" && c.CONSENT_SOURCE != @"PFORCERX").Select(c => c.privacy).Distinct().Count();
dto.grvcount = db.Consents.Where(c => c.CONSENT_SOURCE == @"GRV").Count();
if (pcmsid == null)
{
dto.logs = db.Privacylogs.OrderByDescending(p => p.createdate).Take(300).ToList();
}
else
{
dto.logs = db.Privacylogs.Where(p => p.privacy.PCMSID.Contains(pcmsid)).OrderByDescending(p => p.createdate).Take(300).ToList();
}
}
}
}
else
{
dto.approvedrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Approved).ToList().Count();
dto.rejectedrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Rejected).ToList().Count();
dto.approvalrequests = db.Approvals.Where(a => a.status == ApprovalStatus.Request).ToList().Count();
// 만료 갯수
/*
* Setting setting = db.Settings.Where(s => s.type == SettingType.ConsentTerm).First();
* DateTime expired = DateTime.UtcNow.AddYears(-1 * Int32.Parse(setting.value));
* IQueryable<Privacy> privacys = db.Consents.Where(cst => cst.CONSENT_DATE < expired).Select(cst => cst.privacy).Distinct();
* privacys = privacys.Where(p => p.status != PrivacyStatus.DELETED || p.status != PrivacyStatus.DELETED);
* var count = privacys.Count();
*
* // String sqlQuery = "select count(*) from Privacies where id in (select privacy_ID from Consents where CONSENT_DATE < DATEADD(year ," + -1 * Int32.Parse(setting.value) + ", CURRENT_TIMESTAMP));";
* // var count = db.Database.SqlQuery(sqlQuery);
*
* dto.expiredconsents = (int)count;
*/
// dto.mmscount = db.Privacylogs.Where(pl => pl.creater == @"MMS").Count();
dto.mmscount = db.Consents.Where(c => c.CONSENT_SOURCE == @"MMS").Count();
//dto.pforcerxcount = db.Privacylogs.Where(pl => pl.creater == @"PFORCERX").Count();
dto.pforcerxcount = db.Consents.Where(c => c.CONSENT_SOURCE == @"PFORCERX").Count();
dto.hardcount = db.Consents.Where(c => c.CONSENT_SOURCE != @"MMS" && c.CONSENT_SOURCE != @"GRV" && c.CONSENT_SOURCE != @"PFORCERX").Select(c => c.privacy).Distinct().Count();
//dto.codemappingcount = db.Privacylogs.Where(pl => pl.creater == @"ODSM").Count();
//dto.codemappingcount += db.Privacylogs.Where(pl => pl.creater == @"TASK" && (pl.changes.Contains(@"NucleusKey") || pl.changes.Contains(@"OneKey"))).Count();
dto.grvcount = db.Consents.Where(c => c.CONSENT_SOURCE == @"GRV").Count();
if (pcmsid == null)
{
dto.logs = db.Privacylogs.OrderByDescending(p => p.createdate).Take(300).ToList();
}
else
{
dto.logs = db.Privacylogs.Where(p => p.privacy.PCMSID.Contains(pcmsid)).OrderByDescending(p => p.createdate).Take(300).ToList();
}
}
ViewBag.pcmsid = pcmsid;
return(View(dto));
}
