public LeavesController(IUserRepository userRepository,
ILeaveRepository leaveRepository,
ILeaveEntitlementRepository leaveEntitlementRepository,
IEmployeeRepository employeeRepository,
ILeaveEntitlementUpdateRepository leaveEntitlementUpdateRepository,
ILeaveService leaveService,
EmailComposerService emailComposerService,
ILeaveTimePeriodRepository leaveTimePeriodRepository,
ITimeSheetRepository timeSheetRepository,
ITimeSheetLineItemRepository timeSheetLineItemRepository,
ITimeSheetActivityRepository timeSheetActivityRepository,
IProjectRepository projectRepository,
GridDataContext dataContext,
IUnitOfWork unitOfWork)
{
_userRepository = userRepository;
_leaveRepository = leaveRepository;
_leaveEntitlementRepository = leaveEntitlementRepository;
_leaveService = leaveService;
_employeeRepository = employeeRepository;
_emailComposerService = emailComposerService;
_leaveTimePeriodRepository = leaveTimePeriodRepository;
_timeSheetRepository = timeSheetRepository;
_timeSheetLineItemRepository = timeSheetLineItemRepository;
_timeSheetActivityRepository = timeSheetActivityRepository;
_projectRepository = projectRepository;
_dataContext = dataContext;
_unitOfWork = unitOfWork;
}
public HistoryController(ILogger <HistoryController> logger,
GridDataContext peiuGridDataContext, IClaimServiceFactory claimsManager,
AccountEF accountContext)
{
_accountContext = accountContext;
_peiuGridDataContext = peiuGridDataContext;
this.claimsManager = claimsManager;
this.logger = logger;
}
public AccountController(GridDataContext dataContext,
IUserRepository userRepository,
IRoleMemberRepository roleMemberRepository,
IRolePermissionRepository rolePermissionRepository,
IUnitOfWork unitOfWork)
{
_dataContext = dataContext;
_userRepository = userRepository;
_rolePermissionRepository = rolePermissionRepository;
_roleMemberRepository = roleMemberRepository;
_unitOfWork = unitOfWork;
}
public JsonResult ListarDepenAsig()
{
if (Session["DatosUsuario"] != null)
{
listUsuario = (List <GRL_USUARIOS>)Session["DatosUsuario"];
var Lista = GridDataContext.ObtenerDepenAsig(listUsuario[0].USUARIO);
return(Json(Lista, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SeedEmailTemplates(Tenant tenant)
{
var selectedTenant = db.Tenants.Find(tenant.Id);
if (selectedTenant != null)
{
var connectionString = selectedTenant.ConnectionString;
if (!string.IsNullOrEmpty(connectionString))
{
using (var tenantContext = new TenantDataContext())
{
var emailTemplates = tenantContext.EmailTemplates.ToList();
using (var context = new GridDataContext(connectionString))
{
// Select Admin as the Creator
var selectedUser = context.Users.FirstOrDefault(u => u.Username == selectedTenant.Email);
if (selectedUser != null)
{
foreach (var emailTemplate in emailTemplates)
{
context.EmailTemplates.Add(new Entities.Company.EmailTemplate
{
Name = emailTemplate.Name,
Content = emailTemplate.Content,
CreatedOn = DateTime.UtcNow,
CreatedByUserId = selectedUser.Id
});
}
}
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
}
return(View(tenant));
}
public JsonResult ListarMenuUsuario()
{
List <GRL_SISTEMAS> lstSistemas = new List <GRL_SISTEMAS>();
if (Session["DatosUsuario"] != null)
{
listUsuario = (List <GRL_USUARIOS>)Session["DatosUsuario"];
var Lista = GridDataContext.ObtenerMnuUsuario(listUsuario[0].USUARIO);
var lstAsignados = (from lst in Lista
where lst.ASIGNADO == "1"
select lst).ToArray();
lstSistemas = lstAsignados.ToList <GRL_SISTEMAS>();
Session["opcAsignadas"] = lstSistemas;
return(Json(Lista, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public JsonResult ListarUsuariosAdmin()
{
var Lista = GridDataContext.ObtenerUsuariosAdmin();
return(Json(Lista, JsonRequestBehavior.AllowGet));
}
public DeleteController(GridDataContext dataContext)
{
_dataContext = dataContext;
}
public JsonResult ObtenerDatos(string Usuario)
{
var Lista = GridDataContext.ObtenerDepenAsig(Usuario);
return(Json(Lista, JsonRequestBehavior.AllowGet));
}
public FormController(GridDataContext gridDataContext, IEmployeeRepository employeeRepository, ILeaveRepository leaveRepository)
{
_gridDataContext = gridDataContext;
_employeeRepository = employeeRepository;
_leaveRepository = leaveRepository;
}
public FormController(GridDataContext gridDataContext)
{
_gridDataContext = gridDataContext;
}
public ActionResult Seed(Tenant tenant)
{
var selectedTenant = db.Tenants.Find(tenant.Id);
if (selectedTenant != null)
{
var connectionString = selectedTenant.ConnectionString;
if (!string.IsNullOrEmpty(connectionString))
{
using (var context = new GridDataContext(connectionString))
{
var accessRule = AccessRule.CreateNewUserAccessRule(true);
context.AccessRules.Add(accessRule);
context.SaveChanges();
var person = new Person();
context.Persons.Add(person);
context.SaveChanges();
var manageCompany = new Permission {
Title = "Manage Company", PermissionCode = 200
};
context.Permissions.Add(manageCompany);
var manageHRMS = new Permission {
Title = "Manage HRMS", PermissionCode = 210
};
context.Permissions.Add(manageHRMS);
var manageSales = new Permission {
Title = "Manage Sales", PermissionCode = 220
};
context.Permissions.Add(manageSales);
var manageIT = new Permission {
Title = "Manage IT", PermissionCode = 230
};
context.Permissions.Add(manageIT);
var managePMS = new Permission {
Title = "Manage PMS", PermissionCode = 240
};
context.Permissions.Add(managePMS);
var manageInventory = new Permission {
Title = "Manage Inventory", PermissionCode = 250
};
context.Permissions.Add(manageInventory);
var manageLMS = new Permission {
Title = "Manage LMS", PermissionCode = 215
};
context.Permissions.Add(manageLMS);
var manageTimeSheet = new Permission {
Title = "Manage TimeSheet", PermissionCode = 300
};
context.Permissions.Add(manageTimeSheet);
var manageRecruit = new Permission {
Title = "Manage Recruit", PermissionCode = 500
};
context.Permissions.Add(manageRecruit);
var superPermission = new Permission {
Title = "Super Permission", PermissionCode = 9999
};
context.Permissions.Add(superPermission);
var manageTMS = new Permission {
Title = "Manage TMS", PermissionCode = 550
};
context.Permissions.Add(manageTMS);
var manageKBS = new Permission {
Title = "Manage KBS", PermissionCode = 700
};
context.Permissions.Add(manageKBS);
var viewSettings = new Permission {
Title = "View Settings", PermissionCode = 909
};
context.Permissions.Add(viewSettings);
var manageCRM = new Permission {
Title = "Manage CRM", PermissionCode = 222
};
context.Permissions.Add(manageCRM);
var manageTicketDesk = new Permission {
Title = "Manage Ticket Desk", PermissionCode = 1100
};
context.Permissions.Add(manageTicketDesk);
context.SaveChanges();
var adminRole = new Role {
Name = "Admin"
};
context.Roles.Add(adminRole);
context.SaveChanges();
// Role Permission Mapping
var permissions = context.Permissions.ToList();
foreach (var permission in permissions)
{
var newMap = new RolePermission
{
RoleId = adminRole.Id,
PermissionId = permission.Id
};
context.RolePermissions.Add(newMap);
}
context.SaveChanges();
// Create User
var user = new User
{
EmployeeCode = "Code",
Username = selectedTenant.Email,
Password = HashHelper.Hash("123456"),
AccessRuleId = accessRule.Id,
PersonId = person.Id
};
context.Users.Add(user);
context.SaveChanges();
// Role Member Mapping
var newMember = new RoleMember
{
RoleId = adminRole.Id,
UserId = user.Id
};
context.RoleMembers.Add(newMember);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
return(View(tenant));
}
public GenericListController(GridDataContext dataContext)
{
_dataContext = dataContext;
}
public ScheduledJobsController(GridDataContext db)
{
_db = db;
}
public DeviceController(GridDataContext context, AccountEF _accountContext, IRedisConnectionFactory redisConnectionFactory)
{
peiuGridDataContext = context;
peiuDataContext = _accountContext;
database = redisConnectionFactory.Connection().GetDatabase(1);
}
public BulkController(GridDataContext peiuGridDataContext, ILogger <BulkController> logger)
{
this.peiuGridDataContext = peiuGridDataContext;
this.logger = logger;
}
public SelectListController(GridDataContext dataContext)
{
_dataContext = dataContext;
}
public MigrateController(GridDataContext context)
{
_context = context;
}
