public ActionResult AddCommentToTheTask(CommentModel comment)
{
using (DbContextModel db = new DbContextModel())
{
int userIdInt = Convert.ToInt32(Session["UserId"]);
comment.DateWhenCommentWasAdded = DateTime.Now;
comment.ProjectWhereCommentBelong = db.Projects.Where(x => x.ProjectId == comment.ProjectWhereCommentBelong.ProjectId).FirstOrDefault();
comment.TaskWhereCommentBelong = db.Tasks.Include("CurrentWorkerAtTask").Include("UserWhoAddTask").Where(x => x.TaskId == comment.TaskWhereCommentBelong.TaskId).FirstOrDefault();
comment.UserWhoAddComment = db.UserAccounts.Where(x => x.UserId == userIdInt).FirstOrDefault();
db.Notifications.Add(new NotificationModel {
Project = comment.ProjectWhereCommentBelong, NotificationType = NotificationTypes.NowyKomentarzDoZadania, IsSeen = false, DateSend = DateTime.Now, NotificationReceiver = comment.TaskWhereCommentBelong.UserWhoAddTask, Title = "Nowy komentarz do twojego zadania", Content = string.Format("Użytkownik ({0}) skomentował twoje zadanie {1} w projekcie {2}. ", comment.UserWhoAddComment.Username, comment.TaskWhereCommentBelong.TaskName, comment.ProjectWhereCommentBelong.ProjectTitle)
});
if (comment.TaskWhereCommentBelong.UserWhoAddTask != comment.TaskWhereCommentBelong.CurrentWorkerAtTask)
{
db.Notifications.Add(new NotificationModel {
Project = comment.ProjectWhereCommentBelong, NotificationType = NotificationTypes.NowyKomentarzDoZadania, IsSeen = false, DateSend = DateTime.Now, NotificationReceiver = comment.TaskWhereCommentBelong.CurrentWorkerAtTask, Title = "Nowy komentarz do twojego zadania", Content = string.Format("Użytkownik ({0}) skomentował twoje zadanie {1} w projekcie {2}. ", comment.UserWhoAddComment.Username, comment.TaskWhereCommentBelong.TaskName, comment.ProjectWhereCommentBelong.ProjectTitle)
});
}
db.Comments.Add(comment);
db.SaveChanges();
if (comment.ProjectWhereCommentBelong.ProjectManagementMethodology == ManageOnline.Models.ProjectManagementMethodology.Scrum)
{
return(RedirectToAction("ScrumBoard", "ProjectPanel", new { projectId = comment.TaskWhereCommentBelong.Project.ProjectId }));
}
return(RedirectToAction("KanbanBoard", "ProjectPanel", new { projectId = comment.TaskWhereCommentBelong.Project.ProjectId }));
}
}
public ActionResult AddScrumSprint(int projectId, int scrumSprintLengthInDays)
{
using (DbContextModel db = new DbContextModel())
{
ScrumSprintModel scrumSprint = new ScrumSprintModel();
scrumSprint.Project = db.Projects.Where(x => x.ProjectId == projectId).FirstOrDefault();
scrumSprint.StartScrumSprintDate = DateTime.Now;
scrumSprint.FinishScrumSprintDate = DateTime.Now.AddDays(scrumSprintLengthInDays);
scrumSprint.ScrumSprintLengthInDays = scrumSprintLengthInDays;
var lastSprint = db.ScrumSprints.Where(x => x.Project.ProjectId == projectId).OrderByDescending(x => x.ScrumSprintNumber).FirstOrDefault();
int sprintNumber;
if (lastSprint != null)
{
sprintNumber = lastSprint.ScrumSprintNumber + 1;
}
else
{
sprintNumber = 1;
}
scrumSprint.ScrumSprintNumber = sprintNumber;
db.ScrumSprints.Add(scrumSprint);
db.SaveChanges();
}
return(RedirectToAction("ScrumBoard", new { projectId = projectId }));
}
// GET: ProjectPanel
public ActionResult ProjectPanel(int projectId)
{
using (DbContextModel db = new DbContextModel())
{
var project = db.Projects
.Include("ProjectOwner")
.Include("SkillsRequiredToProjectCollection")
.Include("ProjectCategory")
.Include("Tasks.CurrentWorkerAtTask")
.Include("Tasks.UserWhoAddTask")
.Include("UsersBelongsToProjectCollection")
.Where(x => x.ProjectId.Equals(projectId))
.FirstOrDefault();
var categoriesList = db.Categories.ToList();
var skills = db.Skills.ToList();
project.ProjectCategory = categoriesList.Where(x => x.CategoryId.Equals(project.ProjectCategory.CategoryId)).FirstOrDefault();
if (project.SkillsRequiredToProject != null)
{
project.SkillsRequiredToProjectArray = project.SkillsRequiredToProject.Split(',').ToArray();
project.SkillsRequiredToProjectCollection = new Collection <SkillsModel>();
foreach (var skillId in project.SkillsRequiredToProjectArray)
{
var skillIdInt = Convert.ToInt32(skillId);
var skill = skills.Where(x => x.SkillId.Equals(skillIdInt)).FirstOrDefault();
project.SkillsRequiredToProjectCollection.Add(skill);
}
}
ViewBag.ProjectManagementMethodology = project.ProjectManagementMethodology;
return(View(project));
}
}
public ActionResult KanbanBoard(int projectId)
{
using (DbContextModel db = new DbContextModel())
{
var project = db.Projects
.Include("ProjectOwner")
.Include("SkillsRequiredToProjectCollection")
.Include("ProjectCategory")
.Include("Tasks.CurrentWorkerAtTask")
.Include("Tasks.UserWhoAddTask")
.Include("UsersBelongsToProjectCollection")
.Where(x => x.ProjectId.Equals(projectId))
.FirstOrDefault();
ViewBag.CountAllTasks = project.Tasks.Count();
ViewBag.CountNotStartedTasks = project.Tasks.Where(x => x.TaskStatus == TaskStatus.NotStarted).Count();
ViewBag.CountInProgressTasks = project.Tasks.Where(x => x.TaskStatus == TaskStatus.InProgress).Count();
ViewBag.CountFinishedTasks = project.Tasks.Where(x => x.TaskStatus == TaskStatus.Finished).Count();
var progressBarNotStartedTasksWidth = (((double)ViewBag.CountNotStartedTasks / (double)ViewBag.CountAllTasks) * 100).ToString();
ViewBag.progressBarNotStartedTasksWidth = progressBarNotStartedTasksWidth.Replace(",", ".");
var progressBarInProgressTasksWidth = (((double)ViewBag.CountInProgressTasks / (double)ViewBag.CountAllTasks) * 100).ToString();
ViewBag.progressBarInProgressTasksWidth = progressBarInProgressTasksWidth.Replace(",", ".");
var progressBarFinishedTasksWidth = (((double)ViewBag.CountFinishedTasks / (double)ViewBag.CountAllTasks) * 100).ToString();
ViewBag.progressBarFinishedTasksWidth = progressBarFinishedTasksWidth.Replace(",", ".");
return(View(project));
}
}
public ActionResult AddProject(ProjectModel project)
{
using (DbContextModel db = new DbContextModel())
{
int UserId = Convert.ToInt32(Session["UserId"]);
project.ProjectCreationDate = DateTime.Now;
project.ProjectOwner = db.UserAccounts.FirstOrDefault(u => u.UserId.Equals(UserId));
project.ProjectStatus = ProjectStatus.WaitingForOffers;
project.ProjectCategory = db.Categories.Where(x => x.CategoryId == project.ProjectCategory.CategoryId).FirstOrDefault();
if (project.SkillsRequiredToProjectArray != null)
{
project.SkillsRequiredToProject = string.Join(",", project.SkillsRequiredToProjectArray);
}
db.Projects.Add(project);
db.SaveChanges();
if (project.IsRequiredManager)
{
var managers = db.UserAccounts.Where(x => x.Role == Roles.Manager).ToList();
foreach (var manager in managers)
{
db.Notifications.Add(new NotificationModel {
Project = project, NotificationType = NotificationTypes.NowyProjektZMenadzerem, IsSeen = false, DateSend = DateTime.Now, NotificationReceiver = manager, Title = "Nowy projekt wymagający menadżera", Content = string.Format("Pojawił się nowy projekt ({0}) wymagający nadzoru menadżerskiego. ", project.ProjectTitle)
});
db.SaveChanges();
}
}
}
return(View("SuccessfullAddProject"));
}
public ActionResult Login(UserBasicModel user)
{
using (DbContextModel db = new DbContextModel())
{
var currentUser = db.UserAccounts.Where(u => u.Username == user.Username).FirstOrDefault();
if (currentUser != null)
{
if ((string.Compare(Crypto.Hash(user.Password), currentUser.Password) == 0))
{
System.Web.HttpContext.Current.Session["UserId"] = currentUser.UserId.ToString();
System.Web.HttpContext.Current.Session["Username"] = currentUser.Username.ToString().ToLower();
System.Web.HttpContext.Current.Session["Role"] = currentUser.Role.ToString();
if (currentUser.Role == Roles.Admin)
{
return(RedirectToAction("AdminDashboard", "Admin"));
}
return(RedirectToAction("DashboardIndex", "Dashboard"));
}
else
{
ViewBag.Message = "Podane hasło jest nieprawidłowe";
}
}
else
{
ViewBag.Message = "Podany użytkownik nie istnieje";
}
}
return(View());
}
public IEnumerable <TranslationModel> GetTranslations(string filteredResults)
{
using (DbContextModel DbContext = new DbContextModel())
{
var translationsList = DbContext.Translations
.Include("contents")
.Include("error")
.Include("success")
.OrderByDescending(x => x.Date)
.ToList();
if (filteredResults == "properlyTranslations")
{
var filteredTranslationsList = translationsList.Where(x => x.IsSuccessStatusCode == true).ToList();
return(filteredTranslationsList);
}
else if (filteredResults == "errors")
{
var filteredTranslationsList = translationsList.Where(x => x.IsSuccessStatusCode == false).ToList();
return(filteredTranslationsList);
}
return(translationsList);
}
}
public ActionResult SearchProjects()
{
using (DbContextModel db = new DbContextModel())
{
var dataContext = db.Projects
.Include("ProjectOwner")
.Include("SkillsRequiredToProjectCollection")
.Include("ProjectCategory")
.OrderByDescending(x => x.ProjectCreationDate)
.ToList();
foreach (var project in dataContext)
{
if (project.SkillsRequiredToProject != null)
{
var skills = db.Skills.ToList();
project.SkillsRequiredToProjectArray = project.SkillsRequiredToProject.Split(',').ToArray();
project.SkillsRequiredToProjectCollection = new Collection <SkillsModel>();
foreach (var skillId in project.SkillsRequiredToProjectArray)
{
var skillIdInt = Convert.ToInt32(skillId);
var skill = skills.Where(x => x.SkillId.Equals(skillIdInt)).FirstOrDefault();
project.SkillsRequiredToProjectCollection.Add(skill);
}
}
}
return(View(dataContext));
}
}
public ActionResult ShowManagers()
{
using (DbContextModel db = new DbContextModel())
{
db.Configuration.LazyLoadingEnabled = false;
var managers = db.UserAccounts.Where(x => x.Role == Roles.Manager).ToList();
var skills = db.Skills.ToList();
MultiSelectList skillsList = new MultiSelectList(skills, "SkillId", "SkillName");
if ((TempData["Skills"] as MultiSelectList) != null)
{
var selectedSkillsSelectList = TempData["Skills"] as MultiSelectList;
var selectedSkills = selectedSkillsSelectList.Items;
}
TempData["Skills"] = skillsList;
foreach (var manager in managers)
{
if (manager.Skills != null)
{
manager.SkillsArray = manager.Skills.Split(',').ToArray();
foreach (var skillId in manager.SkillsArray)
{
var skillIdInt = Convert.ToInt32(skillId);
var skill = db.Skills.Where(x => x.SkillId.Equals(skillIdInt)).FirstOrDefault();
manager.SkillsCollection.Add(skill);
}
}
}
return(View(managers));
}
}
public ActionResult AddTask(TaskModel task)
{
int userIdInt = Convert.ToInt32(Session["UserId"]);
using (DbContextModel db = new DbContextModel())
{
task.TaskCreationDate = DateTime.Now;
task.Project = db.Projects.Where(x => x.ProjectId.Equals(task.ProjectId)).FirstOrDefault();
task.UserWhoAddTask = db.UserAccounts.Where(x => x.UserId.Equals(userIdInt)).FirstOrDefault();
task.CurrentWorkerAtTask = db.UserAccounts.Where(x => x.UserId.Equals(task.CurrentWorkerAtTask.UserId)).FirstOrDefault();
var currentSprint = db.ScrumSprints.Where(x => x.ScrumSprintId == task.ScrumSprintWhereTaskBelong.ScrumSprintId).FirstOrDefault();
if (task.ScrumSprintWhereTaskBelong != null)
{
task.ScrumSprintWhereTaskBelong = currentSprint;
}
if (task.Project.ProjectManagementMethodology == ProjectManagementMethodology.Kanban)
{
task.ScrumSprintWhereTaskBelong = null;
}
db.Tasks.Add(task);
db.Notifications.Add(new NotificationModel {
Project = task.Project, NotificationType = NotificationTypes.NoweZadanie, IsSeen = false, DateSend = DateTime.Now, NotificationReceiver = task.CurrentWorkerAtTask, Title = "Nowe zadanie", Content = string.Format("Użytkownik {0} przypisał Ci zadanie: {1}", task.UserWhoAddTask.Username, task.TaskName)
});
db.SaveChanges();
}
if (task.ScrumSprintWhereTaskBelong != null)
{
return(RedirectToAction("ScrumBoard", "ProjectPanel", new { projectId = task.ProjectId }));
}
return(RedirectToAction("KanbanBoard", "ProjectPanel", new { projectId = task.ProjectId }));
}
public ActionResult EditCustomer(int id)
{
using (DbContextModel db = new DbContextModel())
{
try
{
var customer = db.Customers.Include("Address").Where(x => x.Id == id).FirstOrDefault();
var countries = CountriesManager.LoadAllCountriesFromFile();
SelectList countriesList = new SelectList(countries, "Country");
if ((TempData["Countries"] as SelectList) != null)
{
var countriesSelectList = TempData["Countries"] as SelectList;
var selectedCountries = countriesSelectList.Items;
}
TempData["Countries"] = countriesList;
return(View("EditCustomer", customer));
}
catch (Exception)
{
return(RedirectToAction("Customers"));
}
}
}
public ActionResult SendInvitationToProject(NotificationModel notificationInvitationToProject)
{
int userWhoSendInvitationId = Convert.ToInt32(Session["UserId"]);
using (DbContextModel db = new DbContextModel())
{
var projectsFromUser = db.Projects
.Include("ProjectOwner")
.Include("OffersToProject")
.Include("OffersToProject.UserWhoAddOffer")
.Include("OffersToProject.WorkerProposedToProject")
.Where(x => x.ProjectStatus == ProjectStatus.WaitingForOffers && x.ProjectOwner.UserId == userWhoSendInvitationId && x.OffersToProject.Any(item => item.UserWhoAddOffer.UserId.ToString() == notificationInvitationToProject.NotificationReceiver.UserId.ToString()) == false)
.ToList();
ViewBag.projectsFromUser = projectsFromUser;
var userWhoSendInvitation = db.UserAccounts.Where(x => x.UserId.Equals(userWhoSendInvitationId)).FirstOrDefault();
notificationInvitationToProject.NotificationReceiver = db.UserAccounts.Where(x => x.UserId.Equals(notificationInvitationToProject.NotificationReceiver.UserId)).FirstOrDefault();
notificationInvitationToProject.Project = db.Projects.Where(x => x.ProjectId.Equals(notificationInvitationToProject.Project.ProjectId)).FirstOrDefault();
notificationInvitationToProject.IsSeen = false;
notificationInvitationToProject.DateSend = DateTime.Now;
notificationInvitationToProject.NotificationType = NotificationTypes.ZaproszenieDoProjektu;
notificationInvitationToProject.Title = "Zaproszenie do projektu";
notificationInvitationToProject.Content = string.Format("Użytkownik {0} przesłał Ci zaproszenie do złożenia oferty w projekcie {1}.", userWhoSendInvitation.Username, notificationInvitationToProject.Project.ProjectTitle);
db.Notifications.Add(notificationInvitationToProject);
db.SaveChanges();
TempData["SuccessfulSendInvitation"] = "Zaproszenie do projektu zostało przesłane.";
return(RedirectToAction("ProfileDetails", "Account", new { id = notificationInvitationToProject.NotificationReceiver.UserId }));
}
}
public static bool EditCustomer(CustomerModel customer)
{
try
{
using (DbContextModel db = new DbContextModel())
{
CustomerModel customerToEdit = db.Customers.Include("Address").FirstOrDefault(x => x.Id == customer.Id);
customerToEdit.Name = customer.Name;
customerToEdit.Surname = customer.Surname;
customerToEdit.TelephoneNumber = customer.TelephoneNumber;
customerToEdit.Address.Country = customer.Address.Country;
customerToEdit.Address.City = customer.Address.City;
customerToEdit.Address.PostalCode = customer.Address.PostalCode;
customerToEdit.Address.Street = customer.Address.Street;
customerToEdit.Address.HouseNumber = customer.Address.HouseNumber;
customerToEdit.Address.FlatNumber = customer.Address.FlatNumber;
db.Entry(customerToEdit).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public static IServiceCollection AddDbConnection([NotNull] this IServiceCollection service, [NotNull] DbOption dbOption)
{
service.AddTransient(c => dbOption.dbConnection as DbConnection);
if (dbOption.dbType == DbType.DbEnum.Mysql)
{
service.AddTransient <IDbExtend, MySqlDbExtend>();
}
else if (dbOption.dbType == DbType.DbEnum.SqlServer)
{
service.AddTransient <IDbExtend, SqlServerDbExtend>();
//sqlserve 在第二次获取上下文对象时,连接字符串为空(原因未知),需要重新为对象赋值
DbContextModel dbContext = new DbContextModel()
{
connStr = dbOption.dbConnStr
};
service.AddTransient(c => dbContext);
}
else if (dbOption.dbType == DbType.DbEnum.Oracle)
{
service.AddTransient <IDbExtend, OracleDbExtend>();
}
else
{
throw new AttrSqlException("无法识别的数据库类型.");
}
return(service);
}
public ActionResult AddProjectToPortfolio(PortfolioProjectModel portfolioProject, HttpPostedFileBase file)
{
int userIdInt = Convert.ToInt32(Session["UserId"]);
using (DbContextModel db = new DbContextModel())
{
portfolioProject.EmployeeId = db.UserAccounts.Where(x => x.UserId.Equals(userIdInt)).FirstOrDefault();
if (file != null)
{
byte[] data = FileHandler.GetBytesFromFile(file);
portfolioProject.ProjectImage = data;
}
db.PortfolioProjects.Add(portfolioProject);
try
{
db.SaveChanges();
ViewBag.MessageAfterEditProfileDetails = "Edycja danych przebiegła pomyślnie.";
}
catch (Exception ex)
{
ViewBag.MessageAfterEditProfileDetails = "Edycja danych się nie udała." + ex.Message;
return(View());
}
}
return(RedirectToAction("EditAccount", "Account"));
}
public ActionResult EditTask(TaskModel task)
{
using (DbContextModel db = new DbContextModel())
{
var taskToEdit = db.Tasks.Include("UserWhoAddTask")
.Include("CurrentWorkerAtTask")
.Include("Project")
.Include("Comments")
.Include("Comments.UserWhoAddComment")
.Include("Comments.ProjectWhereCommentBelong")
.Where(x => x.TaskId.Equals(task.TaskId)).FirstOrDefault();
taskToEdit.TaskName = task.TaskName;
taskToEdit.TaskDescription = task.TaskDescription;
taskToEdit.CurrentWorkerAtTask = db.UserAccounts.Where(x => x.UserId == task.CurrentWorkerAtTask.UserId).FirstOrDefault();
taskToEdit.TaskStatus = task.TaskStatus;
if (task.TaskStatus == ManageOnline.Models.TaskStatus.InProgress)
{
taskToEdit.TaskStartDate = DateTime.Now;
}
else if (task.TaskStatus == ManageOnline.Models.TaskStatus.Finished)
{
taskToEdit.TaskFinishDate = DateTime.Now;
}
db.Entry(taskToEdit).State = EntityState.Modified;
db.SaveChanges();
if (taskToEdit.Project.ProjectManagementMethodology == ManageOnline.Models.ProjectManagementMethodology.Scrum)
{
return(RedirectToAction("ScrumBoard", "ProjectPanel", new { projectId = taskToEdit.Project.ProjectId }));
}
return(RedirectToAction("KanbanBoard", "ProjectPanel", new { projectId = taskToEdit.Project.ProjectId }));
}
}
public ActionResult AddManagerAccount(UserBasicModel manager)
{
using (DbContextModel db = new DbContextModel())
{
var user = db.UserAccounts.SingleOrDefault(u => u.Username == manager.Username);
if (user != null)
{
ViewBag.Message = "Użytkownik o podanym loginie już istnieje.";
}
else
{
var password = Convert.ToBase64String(System.Security.Cryptography.SHA256.Create()
.ComputeHash(Encoding.UTF8.GetBytes(manager.Password)));
var confirmPassword = Convert.ToBase64String(System.Security.Cryptography.SHA256.Create()
.ComputeHash(Encoding.UTF8.GetBytes(manager.ConfirmPassword)));
manager.Username = manager.Username.ToLower();
manager.Password = password;
manager.ConfirmPassword = confirmPassword;
manager.Role = Roles.Manager;
byte[] data = System.Text.Encoding.ASCII.GetBytes("0");
db.UserAccounts.Add(manager);
db.SaveChanges();
}
}
return(View("AdminDashboard"));
}
public ActionResult AddTaskToSprint(int projectId, int scrumSprintId)
{
TaskModel task = new TaskModel();
task.CurrentWorkerAtTask = new UserBasicModel();
task.ProjectId = projectId;
using (DbContextModel db = new DbContextModel())
{
ICollection <UserBasicModel> usersBelongsToProject = new Collection <UserBasicModel>();
var project = db.Projects.Include("ScrumSprints").Where(x => x.ProjectId.Equals(projectId)).FirstOrDefault();
project.UsersBelongsToProjectArray = project.UsersBelongsToProject.Split(',').ToArray();
foreach (var userId in project.UsersBelongsToProjectArray)
{
int userIdInt = Convert.ToInt32(userId);
var user = db.UserAccounts.Where(x => x.UserId.Equals(userIdInt)).FirstOrDefault();
usersBelongsToProject.Add(user);
}
task.ScrumSprintWhereTaskBelong = db.ScrumSprints.Where(x => x.ScrumSprintId == scrumSprintId).FirstOrDefault();
ViewBag.SprintNumber = task.ScrumSprintWhereTaskBelong.ScrumSprintNumber;
ViewBag.Users = usersBelongsToProject;
return(PartialView("_addTask", task));
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
using (DbContextModel db = new DbContextModel())
{
var adminAccount = db.UserAccounts.Where(x => x.Role == Roles.Admin).FirstOrDefault();
if (adminAccount == null)
{
var password = Convert.ToBase64String(System.Security.Cryptography.SHA256.Create()
.ComputeHash(Encoding.UTF8.GetBytes("filip123")));
var confirmPassword = Convert.ToBase64String(System.Security.Cryptography.SHA256.Create()
.ComputeHash(Encoding.UTF8.GetBytes("filip123")));
adminAccount = new UserBasicModel()
{
Username = "******", Email = "*****@*****.**", MobileNumber = "511 114 421", Role = Roles.Admin
};
adminAccount.Password = password;
adminAccount.ConfirmPassword = confirmPassword;
byte[] image = System.IO.File.ReadAllBytes(Server.MapPath("~/Content/Images/icons8-administrator-mężczyzna-480.png"));
adminAccount.UserPhoto = image;
db.UserAccounts.Add(adminAccount);
db.SaveChanges();
}
}
}
// GET: Employees
public ActionResult EmployeesList()
{
using (DbContextModel db = new DbContextModel())
{
var workersList = db.UserAccounts.Where(u => u.Role == Roles.Pracownik).ToList();
var skills = db.Skills.ToList();
MultiSelectList skillsList = new MultiSelectList(skills, "SkillId", "SkillName");
if ((TempData["Skills"] as MultiSelectList) != null)
{
var selectedSkillsSelectList = TempData["Skills"] as MultiSelectList;
var selectedSkills = selectedSkillsSelectList.Items;
}
TempData["Skills"] = skillsList;
foreach (var employee in workersList)
{
if (employee.Skills != null)
{
employee.SkillsArray = employee.Skills.Split(',').ToArray();
foreach (var skillId in employee.SkillsArray)
{
var skillIdInt = Convert.ToInt32(skillId);
var skill = db.Skills.Where(x => x.SkillId.Equals(skillIdInt)).FirstOrDefault();
employee.SkillsCollection.Add(skill);
}
}
}
return(View(workersList));
}
}
public ActionResult ChangePasswordAdmin(string confirmOldPassword, string newPassword, string confirmNewPassword)
{
using (DbContextModel db = new DbContextModel())
{
int UserId = Convert.ToInt32(Session["UserId"]);
UserBasicModel userToEdit = db.UserAccounts.FirstOrDefault(u => u.UserId.Equals(UserId));
var oldPasswordHashed = Crypto.Hash(confirmOldPassword);
if ((string.Compare(userToEdit.Password, oldPasswordHashed) == 0))
{
if (newPassword == confirmNewPassword)
{
userToEdit.Password = Crypto.Hash(newPassword);
userToEdit.ConfirmPassword = Crypto.Hash(confirmNewPassword);
db.Entry(userToEdit).State = EntityState.Modified;
db.SaveChanges();
ViewBag.MessageInfoRight = "Hasło zostało zmienione.";
return(View());
}
else
{
ViewBag.MessageInfoWrong = "Potwierdź poprawnie nowe hasło.";
return(View());
}
}
else
{
ViewBag.MessageInfoWrong = "Podałeś nieprawidłowe aktualne hasło.";
return(View());
}
}
}
public ActionResult ProjectDetails(int id)
{
using (DbContextModel db = new DbContextModel())
{
db.Configuration.LazyLoadingEnabled = false;
var projectDetailsInfo = db.Projects
.Include("ProjectOwner")
.Include("OffersToProject")
.Include("OffersToProject.UserWhoAddOffer")
.Include("Manager")
.Include("OffersToProject.WorkerProposedToProject")
.Include("ProjectCategory")
.FirstOrDefault(p => p.ProjectId.Equals(id));
var categoriesList = db.Categories.ToList();
var skills = db.Skills.ToList();
if (projectDetailsInfo.SkillsRequiredToProject != null)
{
projectDetailsInfo.SkillsRequiredToProjectArray = projectDetailsInfo.SkillsRequiredToProject.Split(',').ToArray();
projectDetailsInfo.SkillsRequiredToProjectCollection = new Collection <SkillsModel>();
foreach (var skillId in projectDetailsInfo.SkillsRequiredToProjectArray)
{
var skillIdInt = Convert.ToInt32(skillId);
var skill = skills.Where(x => x.SkillId.Equals(skillIdInt)).FirstOrDefault();
projectDetailsInfo.SkillsRequiredToProjectCollection.Add(skill);
}
}
return(View(projectDetailsInfo));
}
}
public ActionResult Register(UserBasicModel userAccount)
{
var rolesList = new List <Roles>();
rolesList.Add(Roles.Pracownik);
rolesList.Add(Roles.Klient);
ViewBag.Roles = new SelectList(rolesList);
if (ModelState.IsValid)
{
using (DbContextModel db = new DbContextModel())
{
var user = db.UserAccounts.SingleOrDefault(u => u.Username == userAccount.Username);
if (user != null)
{
ViewBag.Message = "Użytkownik o podanym loginie już istnieje.";
}
else
{
userAccount.Username = userAccount.Username.ToLower();
userAccount.Password = Crypto.Hash(userAccount.Password);
userAccount.ConfirmPassword = Crypto.Hash(userAccount.ConfirmPassword);
byte[] data = System.Text.Encoding.ASCII.GetBytes("0");
db.UserAccounts.Add(userAccount);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Poprawnie się zarejestrowałeś " + userAccount.Username;
}
}
}
return(View());
}
public ActionResult AdmitSelectedProject(int projectId, int offerId)
{
using (DbContextModel db = new DbContextModel())
{
db.Configuration.LazyLoadingEnabled = false;
ProjectModel project = db.Projects.Where(x => x.ProjectId.Equals(projectId)).FirstOrDefault();
OfferToProjectModel offer = db.OfferToProjectModels.Where(x => x.OfferToProjectId.Equals(offerId)).Include("WorkerProposedToProject").FirstOrDefault();
if (project.UsersBelongsToProject == null)
{
project.UsersBelongsToProject = offer.WorkerProposedToProject.UserId.ToString();
}
else
{
project.UsersBelongsToProject += "," + offer.WorkerProposedToProject.UserId.ToString();
}
db.Notifications.Add(new NotificationModel {
Project = project, NotificationType = NotificationTypes.WybranieOfertyRealizacjiProjektu, IsSeen = false, DateSend = DateTime.Now, NotificationReceiver = offer.WorkerProposedToProject, Title = "Zaakceptowanie oferty realizacji projektu", Content = string.Format("Twoja oferta realizacji projektu została wybrana w projekcie {0}.", project.ProjectTitle)
});
db.Entry(project).State = EntityState.Modified;
db.SaveChanges();
return(View("SuccessfulAdmitProject"));
}
}
public ActionResult EditTask(int taskId)
{
using (DbContextModel db = new DbContextModel())
{
var task = db.Tasks.Include("UserWhoAddTask")
.Include("CurrentWorkerAtTask")
.Include("Project")
.Include("Comments")
.Include("Comments.UserWhoAddComment")
.Include("Comments.ProjectWhereCommentBelong")
.Include("ScrumSprintWhereTaskBelong")
.Where(x => x.TaskId.Equals(taskId)).FirstOrDefault();
ICollection <UserBasicModel> usersBelongsToProject = new Collection <UserBasicModel>();
var project = db.Projects.Where(x => x.ProjectId.Equals(task.Project.ProjectId)).FirstOrDefault();
project.UsersBelongsToProjectArray = project.UsersBelongsToProject.Split(',').ToArray();
foreach (var userId in project.UsersBelongsToProjectArray)
{
int userIdInt = Convert.ToInt32(userId);
var user = db.UserAccounts.Where(x => x.UserId.Equals(userIdInt)).FirstOrDefault();
usersBelongsToProject.Add(user);
}
ViewBag.Users = usersBelongsToProject;
return(PartialView("_editTask", task));
}
}
public ActionResult UpdateTaskPosition(string column1, string column2, string column3, int projectId)
{
var column1Tasks = column1.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(int.Parse).ToList();
var column2Tasks = column2.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(int.Parse).ToList();
var column3Tasks = column3.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(int.Parse).ToList();
using (DbContextModel db = new DbContextModel())
{
var tasks = db.Projects
.Include("Tasks.CurrentWorkerAtTask")
.Include("Tasks.UserWhoAddTask")
.Include("UsersBelongsToProjectCollection")
.Where(x => x.ProjectId.Equals(projectId))
.ToList();
int counter1 = 1;
foreach (var itemId in column1Tasks)
{
TaskModel task = db.Tasks.Where(x => x.TaskId.Equals(itemId)).FirstOrDefault();
task.RowNumber = counter1;
task.ColumnNumber = 1;
db.Entry(task).State = EntityState.Modified;
task.TaskStatus = TaskStatus.NotStarted;
db.SaveChanges();
counter1++;
}
int counter2 = 1;
foreach (var itemId in column2Tasks)
{
TaskModel task = db.Tasks.Where(x => x.TaskId.Equals(itemId)).FirstOrDefault();
task.RowNumber = counter2;
task.ColumnNumber = 2;
task.TaskStatus = TaskStatus.InProgress;
if (task.TaskStartDate == null)
{
task.TaskStartDate = DateTime.Now;
}
db.Entry(task).State = EntityState.Modified;
db.SaveChanges();
counter2++;
}
int counter3 = 1;
foreach (var itemId in column3Tasks)
{
TaskModel task = db.Tasks.Where(x => x.TaskId.Equals(itemId)).FirstOrDefault();
task.RowNumber = counter3;
task.ColumnNumber = 3;
task.TaskStatus = TaskStatus.Finished;
if (task.TaskFinishDate == null)
{
task.TaskFinishDate = DateTime.Now;
}
db.Entry(task).State = EntityState.Modified;
db.SaveChanges();
counter3++;
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public FileResult DownloadFile(int fileId)
{
using (DbContextModel db = new DbContextModel())
{
var file = db.Files.Where(x => x.FileId.Equals(fileId)).First();
return(File(file.FilePath, "application/force-download", Path.GetFileName(file.FilePath)));
}
}
// GET: Admin
public ActionResult AdminDashboard()
{
using (DbContextModel db = new DbContextModel())
{
int UserId = Convert.ToInt32(Session["UserId"]);
UserBasicModel adminAccount = db.UserAccounts.FirstOrDefault(u => u.UserId.Equals(UserId));
return(View(adminAccount));
}
}
public ActionResult NotificationsInfo()
{
using (DbContextModel db = new DbContextModel())
{
var userId = Convert.ToInt32(System.Web.HttpContext.Current.Session["UserId"]);
ViewBag.NotificationsNotSeenCount = db.Notifications.Include("NotificationReceiver").OrderByDescending(x => x.DateSend).Where(x => x.NotificationReceiver.UserId == userId && !x.IsSeen).Count();
return(PartialView("_notificationsInfo"));
}
}
public ActionResult AddOfferToProject(int projectId)
{
OfferToProjectModel offerToProject = new OfferToProjectModel();
using (DbContextModel db = new DbContextModel())
{
offerToProject.ProjectWhereOfferWasAdded = db.Projects.FirstOrDefault(p => p.ProjectId.Equals(projectId));
return(View(offerToProject));
}
}