// public IEnumerable<WorkParticipation> WorkParticipationsUM => _context.WorkParticipations.Where().Where(t => t.WTId.WTType.Contains(ta)).Where(t => t.WTId.WTType.Contains(pa));
public void SaveWorkParticipation(WorkParticipation workParticipation)
{
if (workParticipation.WPId == 0)
{
_context.WorkParticipations.Add(workParticipation);
}
else
{
WorkParticipation dbEntry = _context.WorkParticipations
.FirstOrDefault(p => p.WPId == workParticipation.WPId);
if (dbEntry != null)
{
dbEntry.WPId = workParticipation.WPId;
dbEntry.DateTimeIn = workParticipation.DateTimeIn;
dbEntry.DateTimeOut = workParticipation.DateTimeOut;
dbEntry.Hours = workParticipation.Hours;
dbEntry.WPBreak = workParticipation.WPBreak;
dbEntry.Comment = workParticipation.Comment;
dbEntry.ActiveSession = workParticipation.ActiveSession;
dbEntry.ContracterId = workParticipation.ContracterId;
dbEntry.ProjectId = workParticipation.ProjectId;
dbEntry.UserId = workParticipation.UserId;
dbEntry.WorkCategoryId = workParticipation.WorkCategoryId;
dbEntry.WorkTypeId = workParticipation.WorkTypeId;
//dbEntry.Verified = workParticipation.Verified;
}
}
//_context.Update(workParticipation);
_context.SaveChanges();
}
public IActionResult Edit(int id)
{
WorkParticipation absence = _repository.FindWorkParticipation(id);
if (absence == null)
{
return(NotFound());
}
return(View(absence));
}
public WorkParticipation DeleteWorkParticipation(int id)
{
WorkParticipation dbEntry = _context.WorkParticipations.SingleOrDefault(m => m.WPId == id);
if (dbEntry != null)
{
_context.WorkParticipations.Remove(dbEntry);
_context.SaveChanges();
}
return(dbEntry);
}
public IActionResult Delete(int id)
{
try
{
WorkParticipation deleteAbsnece = _repository.DeleteWorkParticipation(id);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public IActionResult Index(WorkParticipation workParticipation)
{
//Starts a new work session
if (Request.Form["BtnStart"] != String.IsNullOrEmpty(Request.Form["BtnStart"]))
{
workParticipation.Session = true;
workParticipation.DateTimeStart = DateTime.Now;
_genericWorkRepository.Add(workParticipation);
return(RedirectToAction("CheckIn"));
}
else
{
return(View());
}
}
public IActionResult Index(WorkParticipation workParticipation)
{
//Insert new data to database
if (Request.Form["BtnStart"] != String.IsNullOrEmpty(Request.Form["BtnStart"]))
{
workParticipation.ActiveSession = true;
workParticipation.DateTimeIn = DateTime.Now;
_repository.CreateWorkParticipation(workParticipation);
return(RedirectToAction("CheckIn"));
}
else
{
return(View());
}
}
public IActionResult Edit(WorkParticipation absence)
{
try
{
if (ModelState.IsValid)
{
_repository.SaveWorkParticipation(absence);
return(RedirectToAction("Index"));
}
return(View(absence));
}
catch
{
return(View(absence));
}
}
public async Task <IActionResult> MonthlyWorkLog(int id, WorkParticipation workParticipation)
{
var user = await GetCurrentUserAsync();
var userId = user?.Id;
//Insert new data to database
if (Request.Form["BtnVerify"] != String.IsNullOrEmpty(Request.Form["BtnVerify"]))
{
var work = _repository.WorkParticipations.Where(u => u.UserId == userId).Where(d => d.DateTimeIn.Value.Month == id);
//foreach (var item in work)
//{
// if (item.Verified == false)
// {
// item.Verified = true;
// _repository.SaveWorkParticipation(item);
// }
//}
//for (int i = work.Count() - 1; i >= 0; i--)
//{
// workParticipation.WPId = work.WPId;
// workParticipation.DateTimeIn = workParticipation.DateTimeIn;
// workParticipation.DateTimeOut = workParticipation.DateTimeOut;
// workParticipation.Hours = workParticipation.Hours;
// workParticipation.WPBreak = workParticipation.WPBreak;
// workParticipation.Comment = workParticipation.Comment;
// workParticipation.ActiveSession = workParticipation.ActiveSession;
// workParticipation.ContracterId = workParticipation.ContracterId;
// workParticipation.ProjectId = workParticipation.ProjectId;
// workParticipation.UserId = workParticipation.UserId;
// workParticipation.WorkCategoryId = workParticipation.WorkCategoryId;
// workParticipation.WorkTypeId = workParticipation.WorkTypeId;
// workParticipation.Verified = true;
// //work.Verified = true;
// //workParticipation.Verified = true;
// _repository.WorkParticipationValidationUpdate(workParticipation);
//}
//_repository.SaveWorkParticipation(work);
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public IActionResult SendAbsence(WorkParticipation absence)
{
try
{
if (ModelState.IsValid)
{
absence.DateTimeOut = DateTime.Now;
_repository.CreateWorkParticipation(absence);
return(RedirectToAction("index", "Work"));
}
return(View(absence));
}
catch
{
return(View());
}
}
public async Task <IActionResult> ProjectVerification()
{
ApplicationUser user = await GetCurrentUserAsync();
var userId = user?.Id;
wId = _context.WorkParticipations.Where(u => u.UserId == userId).Max(w => w.WPId);
if (wId == 0)
{
return(NotFound());
}
WorkParticipation workParticipation = _repository.FindWorkParticipation(wId);
if (workParticipation == null)
{
return(NotFound());
}
return(View(workParticipation));
}
public async Task <IActionResult> ProjectWorkVarification()
{
ApplicationUser user = await GetCurrentUserAsync();
var userId = user?.Id;
var workId = _genericWorkRepository.GetAll.Where(u => u.UserId == userId).Max(w => w.Id);
if (workId == 0)
{
return(NotFound());
}
WorkParticipation workParticipation = _genericWorkRepository.Get(workId);
if (workParticipation == null)
{
return(NotFound());
}
return(View(workParticipation));
}
public IActionResult Edit(WorkParticipation workParticipation)
{
ViewBag.ContracterId = new SelectList(_context.Contractors, "CId", "CName", workParticipation.ContracterId);
ViewBag.ProjectId = new SelectList(_context.Projects, "PId", "Detail", workParticipation.ProjectId);
ViewBag.WorkCategoryId = new SelectList(_context.WorkCategories, "WCId", "WCDetail", workParticipation.WorkCategoryId);
try
{
// Checks if the model requirements is valid.
if (ModelState.IsValid)
{
_repository.SaveWorkParticipation(workParticipation);
return(RedirectToAction("Index"));
}
return(View(workParticipation));
}
catch
{
return(View(workParticipation));
}
}
public IActionResult ProjectWork(WorkParticipation workParticipation)
{
ViewBag.ProjectId = new SelectList(_context.Projects, "PId", "Detail", workParticipation.ProjectId);
ViewBag.WorkCategoryId = new SelectList(_context.WorkCategories, "WCId", "WCDetail", workParticipation.WorkCategoryId);
try
{
if (ModelState.IsValid)
{
workParticipation.ActiveSession = false;
_repository.SaveWorkParticipation(workParticipation);
return(RedirectToAction("ProjectVerification"));
}
else
{
return(View(workParticipation));
}
}
catch
{
return(View(workParticipation));
}
}
public IActionResult HourWork(WorkParticipation workParticipation)
{
ViewBag.ProjectId = new SelectList(_genericProjectRepository.GetAll, "ProjectId", "ProjectIdAndName", workParticipation.ProjectId);
ViewBag.ClientId = new SelectList(_genericContractorRepository.GetAll, "Id", "Name", workParticipation.ClientId);
try
{
if (ModelState.IsValid)
{
workParticipation.Session = false;
_genericWorkRepository.Update(workParticipation);
return(RedirectToAction("HourWorkVerification"));
}
else
{
return(View(workParticipation));
}
}
catch
{
return(View(workParticipation));
}
}
public IActionResult HourWork(WorkParticipation workParticipation)
{
ViewBag.ProjectId = new SelectList(_context.Projects, "PId", "Detail", workParticipation.ProjectId);
ViewBag.ContracterId = new SelectList(_context.Contractors, "CId", "CName", workParticipation.ContracterId);
try
{
if (ModelState.IsValid)
{
workParticipation.ActiveSession = false;
_repository.SaveWorkParticipation(workParticipation);
return(RedirectToAction("HourWorkVerification"));
}
else
{
return(View(workParticipation));
}
}
catch
{
return(View(workParticipation));
}
}
public IActionResult HourWork(WorkParticipation workParticipation)
{
ViewBag.ProjectId = new SelectList(_context.Projects, "PId", "PName", workParticipation.ProjectId);
ViewBag.ContracterId = new SelectList(_context.Contractors, "CId", "CName", workParticipation.ContracterId);
try
{
// valtidates if requirements is met
if (ModelState.IsValid)
{
// Insert new data to database, returns to index
workParticipation.DateTimeOut = DateTime.Now;
_reposetory.CreateWorkParticipation(workParticipation);
return(RedirectToAction("Index", "Work"));
}
// Returns the value of the fields back to the view
return(View(workParticipation));
}
catch
{
// Returns the value of the fields back to the view
return(View(workParticipation));
}
}
public IActionResult ProjectWork(int id)
{
// list project by id and name and puts it in a ViewBag
ViewBag.ProjectId = new SelectList(_genericProjectRepository.GetAll, "ProjectId", "ProjectIdAndName");
// list workcategories by ide and name and puts it in a ViewBag
ViewBag.WorkCategoryId = new SelectList(_genericWorkCategoryRepository.GetAll, "Id", "WorkCategoryIdAndWorkPreformed");
// makes list of values an put them in a ViewBag
ViewBag.Break = new SelectList(
new List <SelectListItem> {
new SelectListItem {
Text = "Ingen pause", Value = "0"
},
new SelectListItem {
Text = "15 minutt -> 0,25", Value = "0,25"
},
new SelectListItem {
Text = "30 minutt -> 0,5", Value = "0,5"
},
new SelectListItem {
Text = "45 minutt -> 0,75", Value = "0,75"
},
new SelectListItem {
Text = "60 minutt -> 1,0", Value = "1,0"
}
}, "Value", "Text");
WorkParticipation workParticipation = _genericWorkRepository.Get(id);
if (workParticipation == null)
{
// returns error if not found
return(NotFound());
}
// returns data to view
return(View(workParticipation));
}
public IActionResult HourWork(int id)
{
// gets list of project and represent it with PId and PName
ViewBag.ProjectId = new SelectList(_genericProjectRepository.GetAll, "ProjectId", "ProjectIdAndName");
// Gets list of contractor and represnt it with CId and CName
ViewBag.ClientId = new SelectList(_genericContractorRepository.GetAll, "Id", "Name");
// makes list of values and put them in a ViewBag
ViewBag.Break = new SelectList(
new List <SelectListItem> {
new SelectListItem {
Text = "Ingen pause", Value = "0"
},
new SelectListItem {
Text = "15 minutt", Value = "0,25"
},
new SelectListItem {
Text = "30 minutt", Value = "0,5"
},
new SelectListItem {
Text = "45 minutt", Value = "0,75"
},
new SelectListItem {
Text = "60 minutt", Value = "1,0"
}
}, "Value", "Text");
WorkParticipation workParticipation = _genericWorkRepository.Get(id);
if (workParticipation == null)
{
// returns error when not found
return(NotFound());
}
// returns data to view
return(View(workParticipation));
}
public IActionResult HourWork(int id)
{
// gets list of project and represent it with PId and PName
ViewBag.ProjectId = new SelectList(_context.Projects, "PId", "Detail");
// Gets list of contractor and represnt it with CId and CName
ViewBag.ContracterId = new SelectList(_context.Contractors, "CId", "CName");
// makes list of values and put them in a ViewBag
ViewBag.WPBreak = new SelectList(
new List <SelectListItem> {
new SelectListItem {
Text = "Ingen pause", Value = "0"
},
new SelectListItem {
Text = "15 minutt", Value = "0,25"
},
new SelectListItem {
Text = "30 minutt", Value = "0,5"
},
new SelectListItem {
Text = "45 minutt", Value = "0,75"
},
new SelectListItem {
Text = "60 minutt", Value = "1,0"
}
}, "Value", "Text");
WorkParticipation workParticipation = _repository.FindWorkParticipation(id);
if (workParticipation == null)
{
// returns error when not found
return(NotFound());
}
// returns data to view
return(View(workParticipation));
}
public IActionResult ProjectWork(int id)
{
// list project by id andname and puts it in a ViewBag
ViewBag.ProjectId = new SelectList(_context.Projects, "PId", "Detail");
// list workcategories by ide and name and puts it in a ViewBag
ViewBag.WorkCategoryId = new SelectList(_context.WorkCategories, "WCId", "WCDetail");
// makes list of values an put them in a ViewBag
ViewBag.WPBreak = new SelectList(
new List <SelectListItem> {
new SelectListItem {
Text = "Ingen pause", Value = "0"
},
new SelectListItem {
Text = "15 minutt -> 0,25", Value = "0,25"
},
new SelectListItem {
Text = "30 minutt -> 0,5", Value = "0,5"
},
new SelectListItem {
Text = "45 minutt -> 0,75", Value = "0,75"
},
new SelectListItem {
Text = "60 minutt -> 1,0", Value = "1,0"
}
}, "Value", "Text");
WorkParticipation workParticipation = _repository.FindWorkParticipation(id);
if (workParticipation == null)
{
// returns error if not found
return(NotFound());
}
// returns data to view
return(View(workParticipation));
}
public IActionResult ProjectWork(WorkParticipation workParticipation)
{
ViewBag.ProjectId = new SelectList(_genericProjectRepository.GetAll, "ProjectId", "ProjectIdAndName", workParticipation.ProjectId);
ViewBag.WorkCategoryId = new SelectList(_genericWorkCategoryRepository.GetAll, "Id", "WorkCategoryIdAndWorkPreformed", workParticipation.WorkCategoryId);
try
{
if (ModelState.IsValid)
{
// Ends the work session
workParticipation.Session = false;
_genericWorkRepository.Update(workParticipation);
return(RedirectToAction("ProjectWorkVarification"));
}
else
{
return(View(workParticipation));
}
}
catch
{
return(View(workParticipation));
}
}
public WorkParticipation FindWorkParticipation(int?id)
{
WorkParticipation dbEntry = _context.WorkParticipations.Include(c => c.CId).Include(t => t.WTId).Include(wc => wc.WCId).SingleOrDefault(wp => wp.WPId == id);
return(dbEntry);
}
public void CreateWorkParticipation(WorkParticipation workParticipation)
{
_context.WorkParticipations.Add(workParticipation);
_context.SaveChanges();
}