public static StandUpMeetingDetails GetStandUpMeeting(int standUpMeetingId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
StandUpMeetingDetails standUpMeetingDetails = (from standUpMeetings in db.StandUpMeetings
join userProfiles in db.UserProfiles on standUpMeetings.UserId equals userProfiles.UserId
where (
standUpMeetings.Id == standUpMeetingId
)
select new StandUpMeetingDetails
{
Date = standUpMeetings.Date,
Id = standUpMeetings.Id,
Name = userProfiles.UserName,
Reading = standUpMeetings.Reading,
Suggestion = standUpMeetings.Suggestion,
TodayJob = standUpMeetings.TodayJob,
UserId = standUpMeetings.UserId,
YesterdayJob = standUpMeetings.YesterdayJob,
YesterdayObstruction = standUpMeetings.YesterdayObstruction,
Image = userProfiles.ProfilePictureUrl,
TotalDegree = standUpMeetings.TotalDegree,
YasterdayJobDegree = standUpMeetings.YesterdayJobDegree,
TodayJobDegree = standUpMeetings.TodayJobDegree,
ReadingDegree = standUpMeetings.ReadingDegree,
SuggestionDegree = standUpMeetings.SuggestionDegree,
StandUpEmployeePointId = standUpMeetings.StandUpEmployeePointId,
SuggestionEmployeePointId = standUpMeetings.SuggestionEmployeePointId
}).FirstOrDefault();
return(standUpMeetingDetails);
}
}
public static List <StandUpMeetingData> GetStandUpMeetingDataList(DateTime myDate)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var Meetings = (from standUpMeetings in db.StandUpMeetings
join userProfiles in db.UserProfiles on standUpMeetings.UserId equals userProfiles.UserId
where (
standUpMeetings.Date.Value == myDate
)
select new StandUpMeetingData
{
Date = standUpMeetings.Date,
Id = standUpMeetings.Id,
Name = userProfiles.UserName,
Reading = standUpMeetings.Reading,
Suggestion = standUpMeetings.Suggestion,
TodayJob = standUpMeetings.TodayJob,
UserId = standUpMeetings.UserId,
YesterdayJob = standUpMeetings.YesterdayJob,
YesterdayObstruction = standUpMeetings.YesterdayObstruction,
Image = userProfiles.ProfilePictureUrl,
TotalDegree = standUpMeetings.TotalDegree
}).ToList();
return(Meetings);
}
}
public static List <StandUpMeetingDetails> GetMissedStandUpMeetingList(DateTime myDate)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var Meetings = (from standUpMeetings in db.StandUpMeetings
join userProfiles in db.UserProfiles on standUpMeetings.UserId equals userProfiles.UserId
where (
standUpMeetings.Date.Value <= myDate && standUpMeetings.TotalDegree == -1
)
select new StandUpMeetingDetails
{
Date = standUpMeetings.Date,
Id = standUpMeetings.Id,
Name = userProfiles.UserName,
Reading = standUpMeetings.Reading,
Suggestion = standUpMeetings.Suggestion,
TodayJob = standUpMeetings.TodayJob,
UserId = standUpMeetings.UserId,
YesterdayJob = standUpMeetings.YesterdayJob,
YesterdayObstruction = standUpMeetings.YesterdayObstruction,
Image = userProfiles.ProfilePictureUrl,
TotalDegree = standUpMeetings.TotalDegree,
YasterdayJobDegree = standUpMeetings.YesterdayJobDegree,
TodayJobDegree = standUpMeetings.TodayJobDegree,
ReadingDegree = standUpMeetings.ReadingDegree,
SuggestionDegree = standUpMeetings.SuggestionDegree,
StandUpEmployeePointId = standUpMeetings.StandUpEmployeePointId,
SuggestionEmployeePointId = standUpMeetings.SuggestionEmployeePointId
}).ToList();
return(Meetings);
}
}
public static List <StandUpMeetingDetails> GetStandUpMeetingForLastDaysByUserId(int userId, DateTime myDate)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var Meetings = (from standUpMeetings in db.StandUpMeetings
join userProfiles in db.UserProfiles on standUpMeetings.UserId equals userProfiles.UserId
where (
standUpMeetings.Date.Value.Month == myDate.Month &&
userProfiles.UserId == userId
)
select new StandUpMeetingDetails
{
Date = standUpMeetings.Date,
Id = standUpMeetings.Id,
Name = userProfiles.UserName,
Reading = standUpMeetings.Reading,
Suggestion = standUpMeetings.Suggestion,
TodayJob = standUpMeetings.TodayJob,
UserId = standUpMeetings.UserId,
YesterdayJob = standUpMeetings.YesterdayJob,
YesterdayObstruction = standUpMeetings.YesterdayObstruction,
Image = userProfiles.ProfilePictureUrl,
TotalDegree = standUpMeetings.TotalDegree
}).ToList();
return(Meetings.OrderByDescending(m => m.Date).ToList());
}
}
internal static bool IsUserSentStandUpMeeting(int userId, DateTime serverTime)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
StandUpMeeting standUpMeeting = db.StandUpMeetings.Where(x => x.UserId == userId && x.Date.Value.Date == serverTime.Date).FirstOrDefault();
return(standUpMeeting != null);
}
}
public static void InsertNewStory(StandUpMeeting standUpMeeting)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.StandUpMeetings.Add(standUpMeeting);
db.SaveChanges();
}
}
public static void InsertSprintItem(SprintItem sprintItem)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.SprintItems.Add(sprintItem);
db.SaveChanges();
}
}
public static void InsertNewSuggestion(Suggestion suggestion)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.Suggestions.Add(suggestion);
db.SaveChanges();
}
}
public static void InsertNewVacationYear(VacationYear vacationYear)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.VacationYears.Add(vacationYear);
db.SaveChanges();
}
}
public static Story GetStoryById(int id)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var story = db.Stories.SingleOrDefault(x => x.Id == id && x.IsDeleted == false);
return(story);
}
}
public static List <Story> GetAllStoriesList(int projectId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
return(db.Stories.Where(story => story.ProjectId == projectId &&
story.IsDeleted == false).ToList());
}
}
public static void InsertVacationType(VacationType VacationType)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.VacationTypes.Add(VacationType);
db.SaveChanges();
}
}
public static void InsertNewEmployeeWorkFromHome(WorkFromHomeDay workFromHomeDay)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.WorkFromHomeDays.Add(workFromHomeDay);
db.SaveChanges();
}
}
public static void InsertNewProject(Project project)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.Projects.Add(project);
db.SaveChanges();
}
}
public static void InsertNewEmployeePoint(EmployeePoint employeePoint)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.EmployeePoints.Add(employeePoint);
db.SaveChanges();
}
}
public static void InsertNewEmployeeVacation(EmployeeVacation employeeVacation)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.EmployeeVacations.Add(employeeVacation);
db.SaveChanges();
}
}
public static void InsertNewSprint(Sprint sprint)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.Sprints.Add(sprint);
db.SaveChanges();
}
}
public static void DeleteLogsByStoryName(string storyName)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.Logs.RemoveRange(db.Logs.Where(a => a.StoryName == storyName));
db.SaveChanges();
}
}
public static Log GetFirstOrDefaultLog()
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
Log logData = db.Logs.OrderBy(x => x.StoryName).FirstOrDefault();
return(logData);
}
}
public static void DeleteItem(int id)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var q = db.Items.FirstOrDefault(x => x.Id == id);
q.IsDeleted = true;
db.SaveChanges();
}
}
public static int GetUserRole(int userId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var user = db.UserProfiles.FirstOrDefault(x => x.UserId == userId);
int userRoleId = user.webpages_Roles.FirstOrDefault().RoleId;
return(userRoleId);
}
}
public static UserProfile GetUserByUserName(string userName)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
return(db.UserProfiles.FirstOrDefault(
x => x.UserName == userName &&
x.LockedUser == false));
}
}
public static Item InsertNewItem(Item item)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.Items.Add(item);
db.SaveChanges();
return(item);
}
}
public static List <string> AutocompleteStoriesForAdd(int projectId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var Stories = from s in db.Stories
where (s.ProjectId == projectId && s.IsDeleted != true)
select s.Name;
return(Stories.ToList());
}
}
public static void DeleteUserFromProject(int userId, int projectId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var user_in_role = db.ProjectUsers
.FirstOrDefault(x => x.UserId == userId && x.ProjectId == projectId);
db.ProjectUsers.Remove(user_in_role);
db.SaveChanges();
}
}
public static void InsertLog(Log log, DateTime myDate)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
log.DateTime = DateTime.Now;
db.Logs.Add(log);
db.SaveChanges();
}
}
public static List <EmployeeVacation> GetAllEmployeeVacationsByVacationTypeId(int?vacationTypeId, int?employeeUserId, DateTime toDay)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
return(db.EmployeeVacations.Where(
v => v.EmployeeUserId == employeeUserId &&
v.VacationTypeId == vacationTypeId &&
v.StartDate.Year == toDay.Year).ToList());
}
}
public static Attendance GetTodayAttendance(int userId, DateTime today)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
return(db.Attendances
.FirstOrDefault(a => a.EmpUserId == userId &&
a.SignInDate.Value == today &&
a.IsDeleted == false));
}
}
public static void FinishCodeReview(int id)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var q = db.Stories.SingleOrDefault(a => a.Id == id);
if (q != null)
{
db.SaveChanges();
}
}
}
public static List <string> GetAllUsersNamesStartingWithTerm(string term)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
return(db.UserProfiles
.Where(x => x.UserName.StartsWith(term) &&
x.LockedUser == false)
.Select(x => x.UserName)
.ToList());
}
}
