public string Authenticate(string email, string password)
{
User user = dataBaseRepository.Get(email);
if (user == null || user.Password != Hashing.GetHashString(password + user.Salt))
{
return("");
}
user.ComputedProps = new ComputedProps();
user.ComputedProps.AddPermission(dataBaseRepository.GetPermission(user.Id));
return(GenerateAccessToken(email, user.Id.ToString(), user.ComputedProps.Permissions));
}
public Querys(IHttpContextAccessor httpContext, DataBaseRepository dataBaseRepository)
{
Name = "Query";
Field <UserType>(
"GetCurrentUser",
arguments: new QueryArguments(
new QueryArgument <DateGraphType> {
Name = "CalendarDay", Description = "Selected day"
}
),
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
user.ComputedProps = new ComputedProps();
user.ComputedProps.AddPermission(dataBaseRepository.GetPermission(user.Id));
user.ComputedProps.AddTeams(dataBaseRepository.GetUserTeams(user.Id));
System.DateTime?selectedDay = context.GetArgument <System.DateTime?>("CalendarDay");
if (selectedDay.HasValue)
{
var a = dataBaseRepository.GetTimerHistory(user.Id)
.Where(r => r.StartTime.Value.ToShortDateString() == selectedDay.Value.Date.ToShortDateString());
user.ComputedProps.AddTimerHistory(new List <TimerHistory>(a.OfType <TimerHistory>()));
}
else
{
user.ComputedProps.AddTimerHistory(dataBaseRepository.GetTimerHistory(user.Id));
}
return(user);
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <UserType> >(
"GetAllUsers",
arguments: null,
resolve: context =>
{
return(dataBaseRepository.Get());
}
).AuthorizeWith("Manager");
Field <ListGraphType <TeamType> >(
"GetTeams",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return(dataBaseRepository.GetListOfAvailableTeams(user.Id));
},
description: "Get list of available teams."
).AuthorizeWith("Manager");
Field <ListGraphType <TeamType> >(
"GetUserTeams",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return(dataBaseRepository.GetUserTeams(user.Id));
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <UserType> >(
"GetTeamUsers",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <IntGraphType> > {
Name = "TeamId", Description = "Team id."
}
),
resolve: context =>
{
int teamId = context.GetArgument <int>("TeamId");
return(dataBaseRepository.GetTeamUsers(teamId));
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <StringGraphType> >(
"GetAllPermissions",
arguments: null,
resolve: context =>
{
return(dataBaseRepository.GetAllPermissions());
}
).AuthorizeWith("Manager");
Field <ListGraphType <VacationRequestType> >(
"GetCurrentUserRequests",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
int id = user.Id;
return(dataBaseRepository.GetUserVacationRequests(user.Id));
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <VacationResponseType> >(
"GetVacationRequestInfo",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <IntGraphType> > {
Name = "RequestID"
}
),
resolve: context =>
{
int requestId = context.GetArgument <int>("RequestID");
return(dataBaseRepository.GetVacationRequestResponses(requestId));
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <VacationRequestType> >(
"GetRequestsForConsideration",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
int id = user.Id;
return(dataBaseRepository.GetRequestsForConsideration(id));
}
).AuthorizeWith("Manager");
Field <ListGraphType <VacationRequestType> >(
"GetConsideredRequests",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
int id = user.Id;
return(dataBaseRepository.GetConsideredRequests(id));
}
).AuthorizeWith("Manager");
FieldAsync <ListGraphType <TimerHistoryType>, IReadOnlyCollection <TimerHistory> >(
"GetTimerHistories",
resolve: ctx =>
{
return(dataBaseRepository.GetTimerHistory());
}).AuthorizeWith("Authenticated");
Field <UserType>(
"GetCurrentUserId",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return(user);
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <UserType> >(
"GetUsersOnVacation",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <DateTimeGraphType> > {
Name = "Date"
}
),
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
user.ComputedProps = new ComputedProps();
user.ComputedProps.AddTeams(dataBaseRepository.GetUserTeams(user.Id));
DateTime DateToCheck = context.GetArgument <DateTime>("Date");
List <User> teammatesOnVacation = new List <User>();
user.ComputedProps.Teams.ForEach((team) => {
dataBaseRepository.GetTeamUsers(team.Id).ForEach((user) => {
dataBaseRepository.GetUserVacationRequests(user.Id).ToList().ForEach((request) => {
if (request.FinishDate >= DateToCheck && request.StartDate <= DateToCheck)
{
if (teammatesOnVacation.Contains(user))
{
return;
}
teammatesOnVacation.Add(user);
}
});
});
});
return(teammatesOnVacation);
}
).AuthorizeWith("Authenticated");
Field <DecimalGraphType>(
"GetAvailableVacationDays",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
user.ComputedProps = new ComputedProps();
user.ComputedProps.AddVacationRequests(dataBaseRepository.GetUserVacationRequests(user.Id).ToList());
DateTime currentDate = DateTime.Now;
int vacationDaysSum = user.ComputedProps.VacationRequests
.Select(request => (Start: request.StartDate, Finish: request.FinishDate)) //returns only the date pair
.Where(date => //selects request the has the same month
(date.Finish.Year == currentDate.Year && date.Finish.Month == currentDate.Month) ||
(date.Start.Year == currentDate.Year && date.Start.Month == currentDate.Month))
.Select(dates => //crops dates to be within the month
{
var newDates = (Start: dates.Start, Finish: dates.Finish); // makes a copy
if (newDates.Start.Month < currentDate.Month)
{
newDates.Start = new DateTime(currentDate.Year, currentDate.Month, 1);
}
if (newDates.Finish.Month > currentDate.Month)
{
newDates.Finish = new DateTime(currentDate.Year, currentDate.Month, DateTime.DaysInMonth(currentDate.Year, currentDate.Month));
}
return(newDates);
})
.Sum(dates => dates.Finish.DayOfYear - dates.Start.DayOfYear + 1);
int availableVacationDaysPerMonth = 2;
if (availableVacationDaysPerMonth - vacationDaysSum < 0)
{
return(0);
}
return(availableVacationDaysPerMonth - vacationDaysSum);
}
//конструктор
static CompanyCollection()
{
companies = DataBaseRepository.Get();
}
public Querys(IHttpContextAccessor httpContext, DataBaseRepository dataBaseRepository)
{
Name = "Query";
Field <UserType>(
"GetCurrentUser",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
user.ComputedProps = new ComputedProps();
user.ComputedProps.AddPermission(dataBaseRepository.GetPermission(user.Id));
user.ComputedProps.Teams = dataBaseRepository.GetUserTeams(user.Id);
return(user);
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <TeamType> >(
"GetTeams",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return(dataBaseRepository.GetListOfAvailableTeams(user.Id));
},
description: "Get list of available teams."
).AuthorizeWith("Manager");
Field <ListGraphType <TeamType> >(
"GetUserTeams",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return(dataBaseRepository.GetUserTeams(user.Id));
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <UserType> >(
"GetTeamUsers",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <IntGraphType> > {
Name = "TeamId", Description = "Team id."
}
),
resolve: context =>
{
int teamId = context.GetArgument <int>("TeamId");
return(dataBaseRepository.GetTeamUsers(teamId));
}
).AuthorizeWith("Authenticated");
Field <ListGraphType <StringGraphType> >(
"GetAllPermissions",
arguments: null,
resolve: context =>
{
return(dataBaseRepository.GetAllPermissions());
}
).AuthorizeWith("Manager");
Field <ListGraphType <VacationRequestType> >(
"GetCurrentUserRequests",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
int id = user.Id;
return(dataBaseRepository.GetUserRequests(user.Id));
}
).AuthorizeWith("Authenticated");
}
public Mutations(IdentityService identityService, DataBaseRepository dataBaseRepository, EmailService emailService, IHttpContextAccessor httpContext)
{
Name = "Mutation";
Field <StringGraphType>(
"authentication",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Email", Description = "User email."
},
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Password", Description = "User password."
}
),
resolve: context =>
{
string email = context.GetArgument <string>("Email");
string password = context.GetArgument <string>("Password");
return(identityService.Authenticate(email, password));
},
description: "Returns JWT."
);
Field <BooleanGraphType>(
"createUser",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Name", Description = "User name"
},
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Surname", Description = "User surname"
},
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Email", Description = "User email"
},
new QueryArgument <NonNullGraphType <ListGraphType <StringGraphType> > > {
Name = "Permissions", Description = "User permisions"
},
new QueryArgument <ListGraphType <IntGraphType> > {
Name = "Teams", Description = "User teams id"
}
),
resolve: context =>
{
string email = context.GetArgument <string>("Email");
string name = context.GetArgument <string>("Name");
string surname = context.GetArgument <string>("Surname");
List <string> permissions = context.GetArgument <List <string> >("Permissions");
List <int> teamsId = context.GetArgument <List <int> >("Teams");
string password = Guid.NewGuid().ToString();
User user = dataBaseRepository.CreateUser(name, surname, email, password, permissions, teamsId);
if (user.Email != null)
{
try
{
emailService.SendEmail(email, password);
}catch
{
return(false);
}
}
return(true);
}
).AuthorizeWith("Manager");
Field <BooleanGraphType>(
"RemoveUser",
arguments: new QueryArguments(new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Email", Description = "User email"
}),
resolve: context =>
{
return(dataBaseRepository.RemoveUser(context.GetArgument <string>("Email")));
}
);
Field <ListGraphType <VacationRequestType> >(
"addVacationRequest",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <IntGraphType> > {
Name = "UserId", Description = "User id"
},
new QueryArgument <NonNullGraphType <DateGraphType> > {
Name = "StartDate", Description = "Vacation start date"
},
new QueryArgument <NonNullGraphType <DateGraphType> > {
Name = "FinishDate", Description = "Vacation finish date"
},
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Status", Description = "Status of the vacation"
},
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Comment", Description = "Comment of the vacation"
}
),
resolve: context =>
{
int userId = context.GetArgument <int>("UserId");
DateTime startDate = context.GetArgument <DateTime>("StartDate");
DateTime finishDate = context.GetArgument <DateTime>("FinishDate");
string status = context.GetArgument <string>("Status");
string comment = context.GetArgument <string>("Comment");
return(dataBaseRepository.AddRequest(userId, startDate, finishDate, status, comment));
},
description: "Returns user requests."
).AuthorizeWith("Authenticated");
Field <ListGraphType <VacationRequestType> >(
"removeVacationRequest",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <IntGraphType> > {
Name = "Id", Description = "Vacation request id"
}
),
resolve: context =>
{
int id = context.GetArgument <int>("Id");
return(dataBaseRepository.RemoveRequest(id));
},
description: "Returns user requests."
).AuthorizeWith("Authenticated");
Field <BooleanGraphType>(
"sendResetPasswordLink",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Email", Description = "User email"
}
),
resolve: context =>
{
string email = context.GetArgument <string>("Email");
User user = dataBaseRepository.Get(email);
if (user == null)
{
return(false);
}
string token = identityService.GenerateResetPasswordAccessToken(email);
try
{
emailService.SendRestorePasswordEmail(email, token);
}
catch
{
return(false);
}
return(true);
}
);
Field <StringGraphType>(
"resetPassword",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <StringGraphType> > {
Name = "Password", Description = "New password to acccount."
}
),
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
string token = httpContext.HttpContext.Request.Headers.First(header => header.Key == "Authorization").Value.ToString().Replace("Bearer ", "");
Token jwt = dataBaseRepository.GetJWT(token);
string password = context.GetArgument <string>("Password");
string salt = Guid.NewGuid().ToString();
User user = dataBaseRepository.Get(email);
if (user.Password == Hashing.GetHashString(password + user.Salt))
{
return("The new password cannot match the current password.");
}
if (jwt == null)
{
return("");
}
dataBaseRepository.RemoveJWT(token);
user.Password = Hashing.GetHashString(password + user.Salt);
dataBaseRepository.EditUser(user);
return("Success");
}
).AuthorizeWith("canResetPassword");
Field <BooleanGraphType>(
"checkAccessToResetPasswordPage",
resolve: context =>
{
string token = httpContext.HttpContext.Request.Headers.First(header => header.Key == "Authorization").Value.ToString().Replace("Bearer ", "");
Token jwt = dataBaseRepository.GetJWT(token);
if (jwt == null)
{
return(false);
}
return(true);
}
).AuthorizeWith("canResetPassword");
Field <TimerHistoryType>(
"addTimerStartValue",
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
DateTime startTime = DateTime.UtcNow;
return(dataBaseRepository.AddTimerStartValue(startTime, user.Id));
},
description: "Add start time"
).AuthorizeWith("Authenticated");
Field <TimerHistoryType>(
"addTimerValue",
arguments: new QueryArguments(
new QueryArgument <DateTimeGraphType> {
Name = "StartTime", Description = "Timer started"
},
new QueryArgument <DateTimeGraphType> {
Name = "FinishTime", Description = "Timer finished"
}
),
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
Nullable <DateTime> startTime = context.GetArgument <Nullable <DateTime> >("StartTime", defaultValue: null);
Nullable <DateTime> finishTime = context.GetArgument <Nullable <DateTime> >("FinishTime", defaultValue: null);
return(dataBaseRepository.AddTimerValue(startTime, finishTime, user.Id));
},
description: "Add start time"
).AuthorizeWith("Authenticated");
Field <TimerHistoryType>(
"editTimerFinishValue",
arguments: new QueryArguments(
new QueryArgument <DateTimeGraphType> {
Name = "StartTime", Description = "Timer started"
},
new QueryArgument <DateTimeGraphType> {
Name = "FinishTime", Description = "Timer finished"
},
new QueryArgument <IntGraphType> {
Name = "id", Description = "Edit Timer finished"
}
),
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
Nullable <DateTime> startTime = context.GetArgument <Nullable <DateTime> >("StartTime", defaultValue: null);
Nullable <DateTime> finishTime = context.GetArgument <Nullable <DateTime> >("FinishTime", defaultValue: null);
finishTime = (finishTime == null) ? DateTime.UtcNow : finishTime;
Nullable <int> id = context.GetArgument <Nullable <int> >("id", defaultValue: null);
return(dataBaseRepository.EditTimerValue(startTime, finishTime, user.Id, id));
},
description: "Update value: added finish time"
).AuthorizeWith("Authenticated");
Field <TimerHistoryType>(
"deleteTimerFinishValue",
arguments: new QueryArguments(
new QueryArgument <NonNullGraphType <IntGraphType> > {
Name = "id", Description = "Edit Timer finished"
}
),
resolve: context =>
{
int id = context.GetArgument <int>("id");
return(dataBaseRepository.DeteleTimerValue(id));
},
description: "Update value: added finish time"
);
}
public Querys(IHttpContextAccessor httpContext, DataBaseRepository dataBaseRepository)
{
Name = "Query";
Field<UserType>(
"GetCurrentUser",
arguments: new QueryArguments(
new QueryArgument<DateGraphType> { Name = "CalendarDay", Description = "Selected day" }
),
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
user.ComputedProps = new ComputedProps();
user.ComputedProps.AddPermission(dataBaseRepository.GetPermission(user.Id));
user.ComputedProps.AddTeams(dataBaseRepository.GetUserTeams(user.Id));
System.DateTime? selectedDay = context.GetArgument<System.DateTime?>("CalendarDay");
if (selectedDay.HasValue)
{
var a = dataBaseRepository.GetTimerHistory(user.Id)
.Where(r => r.StartTime.Value.ToShortDateString() == selectedDay.Value.Date.ToShortDateString());
user.ComputedProps.AddTimerHistory(new List<TimerHistory>(a.OfType<TimerHistory>()));
}
else
user.ComputedProps.AddTimerHistory(dataBaseRepository.GetTimerHistory(user.Id));
return user;
}
).AuthorizeWith("Authenticated");
Field<ListGraphType<TeamType>>(
"GetTeams",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return dataBaseRepository.GetListOfAvailableTeams(user.Id);
},
description: "Get list of available teams."
).AuthorizeWith("Manager");
Field<ListGraphType<TeamType>>(
"GetUserTeams",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return dataBaseRepository.GetUserTeams(user.Id);
}
).AuthorizeWith("Authenticated");
Field<ListGraphType<UserType>>(
"GetTeamUsers",
arguments: new QueryArguments(
new QueryArgument<NonNullGraphType<IntGraphType>> { Name = "TeamId", Description = "Team id."}
),
resolve: context =>
{
int teamId = context.GetArgument<int>("TeamId");
return dataBaseRepository.GetTeamUsers(teamId);
}
).AuthorizeWith("Authenticated");
Field<ListGraphType<StringGraphType>>(
"GetAllPermissions",
arguments: null,
resolve: context =>
{
return dataBaseRepository.GetAllPermissions();
}
).AuthorizeWith("Manager");
Field<ListGraphType<VacationRequestType>>(
"GetCurrentUserRequests",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
int id = user.Id;
return dataBaseRepository.GetUserRequests(user.Id);
}
).AuthorizeWith("Authenticated");
FieldAsync<ListGraphType<TimerHistoryType>, IReadOnlyCollection<TimerHistory>>(
"GetTimerHistories",
resolve: ctx =>
{
return dataBaseRepository.GetTimerHistory();
}).AuthorizeWith("Authenticated");
Field<UserType>(
"GetCurrentUserId",
arguments: null,
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
return user;
}
).AuthorizeWith("Authenticated");
Field<ListGraphType<UserType>>(
"GetUsersOnVacation",
arguments: new QueryArguments(
new QueryArgument<NonNullGraphType<DateTimeGraphType>> { Name="Date" }
),
resolve: context =>
{
string email = httpContext.HttpContext.User.Claims.First(claim => claim.Type == "Email").Value.ToString();
User user = dataBaseRepository.Get(email);
user.ComputedProps = new ComputedProps();
user.ComputedProps.AddTeams(dataBaseRepository.GetUserTeams(user.Id));
DateTime DateToCheck = context.GetArgument<DateTime>("Date");
List<User> teammatesOnVacation = new List<User>();
user.ComputedProps.Teams.ForEach((team) => {
dataBaseRepository.GetTeamUsers(team.Id).ForEach((user) => {
dataBaseRepository.GetUserRequests(user.Id).ForEach((request) => {
if(request.FinishDate >= DateToCheck && request.StartDate <= DateToCheck)
{
if (teammatesOnVacation.Contains(user))
return;
teammatesOnVacation.Add(user);
}
});
});
});
return teammatesOnVacation;
}
).AuthorizeWith("Authenticated");
}
