public List <WorkAssignments> GetAll() { tuntidbContext db = new tuntidbContext(); var workAssignments = from wa in db.WorkAssignments where wa.Active == true select wa; return(workAssignments.ToList()); }
public List <Employees> GetAll() { tuntidbContext db = new tuntidbContext(); var employees = from e in db.Employees where e.Active == true select e; return(employees.ToList()); }
public string[] GetAll() { string[] assignmentNames = null; tuntidbContext context = new tuntidbContext(); assignmentNames = (from wa in context.WorkAssignments where (wa.Active == true && wa.Completed == false) // Muutettu 4.5. select wa.Title).ToArray(); return(assignmentNames); }
public string[] GetAll() { string[] employeeNames = null; tuntidbContext context = new tuntidbContext(); employeeNames = (from e in context.Employees where (e.Active == true) select e.FirstName + " " + e.LastName).ToArray(); return(employeeNames); }
public ActionResult CreateNew([FromBody] WorkAssignments workAssignment) { tuntidbContext db = new tuntidbContext(); try { db.WorkAssignments.Add(workAssignment); db.SaveChanges(); return(Ok(workAssignment.IdWorkAssignment)); } catch { return(BadRequest("Adding work assignment failed")); } finally { db.Dispose(); } }
public ActionResult CreateNew([FromBody] Employees emp) { tuntidbContext db = new tuntidbContext(); try { db.Employees.Add(emp); db.SaveChanges(); return(Ok(emp.IdEmployee)); } catch { return(BadRequest("Adding employee failed")); } finally { db.Dispose(); } }
public bool PostStatus(WorkAssignmentOperationModel input) // Todo: Ota myös customer ja employee tieto { tuntidbContext context = new tuntidbContext(); try { //Ensin haetaan työtehtävä Otsikon (title) perusteella ja nimetään se assignment muuttujaksi WorkAssignments assignment = (from wa in context.WorkAssignments where (wa.Active == true) && (wa.Title == input.AssignmentTitle) select wa).FirstOrDefault(); if (assignment == null) { return(false); } //--------------------------IF--START---------------------------------------------------------------------- else if (input.Operation == "Start") { if (assignment.InProgress == true || assignment.Completed == true) // Lisätty 4.5. { return(false); } else { int assignmentId = assignment.IdWorkAssignment; // Luodaan uusi timesheet työlle Timesheet newEntry = new Timesheet() { IdWorkAssignment = assignmentId, StartTime = DateTime.Now, //WorkComplete = false, ------------ poistettu turha kenttä Active = true, CreatedAt = DateTime.Now }; context.Timesheet.Add(newEntry); // Päivitetään työtehtävän tilaa myös work assignments tauluun WorkAssignments assignments = (from wa in context.WorkAssignments where (wa.IdWorkAssignment == assignmentId) && (wa.Active == true) select wa).FirstOrDefault(); assignment.InProgress = true; assignment.WorkStartedAt = DateTime.Now; assignment.LastModifiedAt = DateTime.Now; context.SaveChanges(); // talletetaan kaikki em muutokset } } //--------------------------------IF--STOP---------------------------------------------------------------------- else if (input.Operation == "Stop") { int assignmentId = assignment.IdWorkAssignment; // Halutaan muuttaa tietoja sekä timesheetiin... Timesheet existing = (from ts in context.Timesheet where (ts.IdWorkAssignment == assignmentId) && (ts.Active == true) select ts).FirstOrDefault(); //............että work assignmentteihin WorkAssignments assignments = (from wa in context.WorkAssignments where (wa.IdWorkAssignment == assignmentId) && (wa.Active == true) select wa).FirstOrDefault(); if (existing != null && assignment != null) { if (assignment.InProgress == false || assignment.Completed == true) // Muutettu 4.5. { return(false); } else { // Timesheetin uudet arvot existing.StopTime = DateTime.Now; existing.WorkComplete = true; existing.LastModifiedAt = DateTime.Now; // Assignmentin uudet arvot assignment.LastModifiedAt = DateTime.Now; assignment.Completed = true; assignment.CompletedAt = DateTime.Now; assignment.InProgress = false; } } else { return(false); // Jos id tieto on null jommassa kummassa. } } context.SaveChanges(); // talletetaan kaikki em muutokset } catch { return(false); // Jos jotain muuta menee pileen. } finally { context.Dispose(); } return(true); // Mobiilisovellukselle palautetaan true }