public static bool InsertStorySprint(int projectId, int sprintId, string storyName, int userId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
if (db.Stories.Where(x => x.Name == storyName).Count() == 0)
{
Story story = new Story()
{
CreateDate = DateTime.Now,
CreatorId = userId,
Name = storyName,
ProjectId = projectId
};
db.Stories.Add(story);
db.SaveChanges();
SprintStory sprintStory = new SprintStory()
{
SprintId = sprintId,
StoryId = story.Id
};
db.SprintStories.Add(sprintStory);
db.SaveChanges();
return(true);
}
return(false);
}
}
public ActionResult Create(CustomerViewModel customerViewModel)
{
Customer customer = new Customer();
customer = Mapper.Map <Customer>(customerViewModel);
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "StudentId,FirstName,LastName,StudentCode,PhoneNumber,Address,CourseId")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public static void DeleteSprint(int sprintId, int projectId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
List <SprintStory> storiesSprints =
(from s in db.Stories
where (s.ProjectId == projectId && s.IsDeleted == false)
join sprint_story in db.SprintStories
on s.Id equals sprint_story.StoryId
join sprint in db.Sprints
on sprint_story.SprintId equals sprint.Id
where sprint.Id == sprintId && sprint.IsDeleted == false
select sprint_story
)
.ToList();
foreach (var item in storiesSprints)
{
db.SprintStories.Remove(item);
}
var sprints = db.Sprints
.FirstOrDefault(x => x.Id == sprintId);
if (sprints != null)
{
sprints.IsDeleted = true;
}
db.SaveChanges();
}
}
public static List <UserProfile> SignOutToAllUsers(DateTime today)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var attendancesNotSignedOut = db.Attendances
.Where(a => a.SignInDate.Value < today &&
a.SignOutDate == null && a.IsDeleted == false)
.ToList();
for (int i = 0; i < attendancesNotSignedOut.Count(); i++)
{
attendancesNotSignedOut[i].SignOutDate = attendancesNotSignedOut[i].SignInDate.Value.AddHours(8);
}
db.SaveChanges();
List <UserProfile> users = new List <UserProfile>();
foreach (var item in attendancesNotSignedOut)
{
var user = db.UserProfiles.FirstOrDefault(x => x.UserId == item.EmpUserId);
if (!(users.Contains(user)))
{
users.Add(user);
}
}
return(users);
}
}
public static void AddItemsToSprint(List <Item> sprintItems, int sprintId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
foreach (Item item in sprintItems)
{
var oldItem = db.SprintItems.FirstOrDefault(x => x.ItemId == item.Id && x.SprintId == sprintId);
if (oldItem != null)
{
oldItem.IsDeleted = item.IsDeleted;
}
else
{
if (!item.IsDeleted)
{
db.SprintItems.Add(new SprintItem
{
ItemId = item.Id,
SprintId = sprintId
});
}
}
}
db.SaveChanges();
}
}
public static void InsertNewAttendance(Attendance item, DateTime myDate)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var q = (from user in db.UserProfiles
join attendance in db.Attendances
on user.UserId equals attendance.EmpUserId
where (attendance.SignOutDate == null &&
attendance.SignInDate.Value == myDate &&
user.LockedUser == false &&
attendance.IsDeleted == false &&
attendance.EmpUserId == item.EmpUserId)
select new UserSign
{
UserId = attendance.EmpUserId
})
.ToList();
if (q.Count == 0)
{
db.Attendances.Add(item);
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 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 void InsertVacationType(VacationType VacationType)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.VacationTypes.Add(VacationType);
db.SaveChanges();
}
}
public static void InsertSprintItem(SprintItem sprintItem)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.SprintItems.Add(sprintItem);
db.SaveChanges();
}
}
public static void InsertNewEmployeePoint(EmployeePoint employeePoint)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.EmployeePoints.Add(employeePoint);
db.SaveChanges();
}
}
public static void InsertNewEmployeeWorkFromHome(WorkFromHomeDay workFromHomeDay)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.WorkFromHomeDays.Add(workFromHomeDay);
db.SaveChanges();
}
}
public static void InsertNewStory(StandUpMeeting standUpMeeting)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.StandUpMeetings.Add(standUpMeeting);
db.SaveChanges();
}
}
public static void InsertNewProject(Project project)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.Projects.Add(project);
db.SaveChanges();
}
}
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 Item InsertNewItem(Item item)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
db.Items.Add(item);
db.SaveChanges();
return(item);
}
}
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 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 bool InsertSprintProject(int sprintId, Project project)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
if (!db.Stories.Any(x => x.Name == project.Name))
{
db.Projects.Add(project);
db.SaveChanges();
SprintProject sprintProjecty = new SprintProject()
{
SprintId = sprintId,
ProjectId = project.Id
};
db.SprintProjects.Add(sprintProjecty);
db.SaveChanges();
return(true);
}
return(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 void DeleteSuggestion(int id)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var q = db.Suggestions.SingleOrDefault(a => a.Id == id);
if (q != null)
{
q.IsDeleted = true;
db.SaveChanges();
}
}
}
public static void DeleteVacationYear(int id)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
VacationYear vacationYearItem = db.VacationYears.FirstOrDefault(a => a.Id == id);
if (vacationYearItem != null)
{
vacationYearItem.IsDeleted = true;
db.SaveChanges();
}
}
}
public static void UpdateStory(Story story, DateTime today)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var updatedSyory = db.Stories.SingleOrDefault(a => a.Id == story.Id);
if (updatedSyory != null)
{
updatedSyory.Name = story.Name;
db.SaveChanges();
}
}
}
public static void InsertSprintToStory(int storyId, int sprintId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
SprintStory sprintStory = new SprintStory()
{
SprintId = sprintId, StoryId = storyId
};
db.SprintStories.Add(sprintStory);
db.SaveChanges();
}
}
public static void ChangeStatus(int Id, EVacationStatus status)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var q = db.WorkFromHomeDays.FirstOrDefault(e => e.Id == Id);
if (q != null)
{
q.StatusId = (int)status;
}
db.SaveChanges();
}
}
public static void DeleteProject(int id)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
var temp = db.Projects.SingleOrDefault(a => a.Id == id);
if (temp != null)
{
temp.IsDeleted = true;
db.SaveChanges();
}
}
}
