public static JobLog MakeLogEntryForCategory(Job jobNew, Job jobOld) { string note = "Job Category was changed from " + jobOld.Category.ToString() + " to " + jobNew.Category.ToString() + "."; JobLog jobLog = new JobLog() { JobNum = jobOld.JobNum, UserNumChanged = Security.CurUser.UserNum, UserNumExpert = jobOld.UserNumExpert, UserNumEngineer = jobOld.UserNumEngineer, Title = jobOld.Title, Description = note, TimeEstimate = TimeSpan.FromHours(jobNew.HoursEstimate) }; JobLogs.Insert(jobLog); JobNotifications.UpsertAllNotifications(jobNew, Security.CurUser.UserNum, JobNotificationChanges.CategoryChange); return(JobLogs.GetOne(jobLog.JobLogNum)); //to get new timestamp. }
public static JobLog MakeLogEntryForProject(Job jobNew, Job jobOld) { string note = $@"Job Project was manually changed from {jobOld.PatternReviewProject.ToString()} to {jobNew.PatternReviewProject.ToString()}."; JobLog jobLog = new JobLog() { JobNum = jobOld.JobNum, UserNumChanged = Security.CurUser.UserNum, UserNumExpert = jobOld.UserNumExpert, UserNumEngineer = jobOld.UserNumEngineer, Title = jobOld.Title, Description = note, TimeEstimate = TimeSpan.FromHours(jobNew.HoursEstimate) }; JobLogs.Insert(jobLog); JobNotifications.UpsertAllNotifications(jobNew, Security.CurUser.UserNum, JobNotificationChanges.PhaseChange); return(JobLogs.GetOne(jobLog.JobLogNum)); //to get new timestamp. }
/// <summary>Inserts log entry to DB and returns the resulting JobLog. Returns null if no log was needed.</summary> public static JobLog MakeLogEntry(Job jobNew, Job jobOld, bool isManualLog = false) { if (jobNew == null) { return(null); } JobNotificationChanges changes = new JobNotificationChanges(); JobLog jobLog = new JobLog() { JobNum = jobNew.JobNum, UserNumChanged = Security.CurUser.UserNum, UserNumExpert = jobNew.UserNumExpert, UserNumEngineer = jobNew.UserNumEngineer, Description = "", TimeEstimate = TimeSpan.FromHours(jobNew.HoursEstimate) }; if (isManualLog) { jobLog.Description = "Manual \"last worked on\" update"; JobLogs.Insert(jobLog); return(JobLogs.GetOne(jobLog.JobLogNum)); //to get new timestamp. } List <string> logDescriptions = new List <string>(); if (jobOld.IsApprovalNeeded && !jobNew.IsApprovalNeeded) { if (jobOld.PhaseCur == JobPhase.Concept && (jobNew.PhaseCur == JobPhase.Definition || jobNew.PhaseCur == JobPhase.Development)) { logDescriptions.Add("Concept approved."); jobLog.MainRTF = jobNew.Implementation; jobLog.RequirementsRTF += jobNew.Requirements; changes = changes | JobNotificationChanges.ApprovalChange; } if ((jobOld.PhaseCur == JobPhase.Concept || jobOld.PhaseCur == JobPhase.Definition) && jobNew.PhaseCur == JobPhase.Development) { logDescriptions.Add("Job approved."); jobLog.MainRTF = jobNew.Implementation; jobLog.RequirementsRTF += jobNew.Requirements; changes = changes | JobNotificationChanges.ApprovalChange; } if (jobOld.PhaseCur == JobPhase.Development && jobNew.PhaseCur == JobPhase.Development) { logDescriptions.Add("Changes approved."); jobLog.MainRTF = jobNew.Implementation; jobLog.RequirementsRTF += jobNew.Requirements; changes = changes | JobNotificationChanges.ApprovalChange; } } else if (jobNew.PhaseCur.In(JobPhase.Documentation, JobPhase.Complete) && !jobOld.PhaseCur.In(JobPhase.Documentation, JobPhase.Complete)) { logDescriptions.Add("Job implemented."); jobLog.MainRTF += jobNew.Implementation; jobLog.RequirementsRTF += jobNew.Requirements; } if (jobOld.PhaseCur > jobNew.PhaseCur && jobOld.PhaseCur != JobPhase.Cancelled) { logDescriptions.Add("Job Unapproved."); //may be a chance for a false positive when using override permission. } if (jobOld.PhaseCur != JobPhase.Cancelled && jobNew.PhaseCur == JobPhase.Cancelled) { logDescriptions.Add("Job Cancelled."); //may be a chance for a false positive when using override permission. } if (jobNew.UserNumExpert != jobOld.UserNumExpert) { logDescriptions.Add("Expert changed."); changes = changes | JobNotificationChanges.ExpertChange; } if (jobNew.UserNumEngineer != jobOld.UserNumEngineer) { logDescriptions.Add("Engineer changed."); changes = changes | JobNotificationChanges.EngineerChange; } if (jobOld.Requirements != jobNew.Requirements) { logDescriptions.Add("Job Requirements Changed."); jobLog.RequirementsRTF += jobNew.Requirements; changes = changes | JobNotificationChanges.ConceptChange; } if (jobOld.Implementation != jobNew.Implementation) { logDescriptions.Add("Job Implementation Changed."); jobLog.MainRTF += jobNew.Implementation; changes = changes | JobNotificationChanges.WriteupChange; } //Do not log RequirementsJSON changes here. //if(jobOld.RequirementsJSON!=jobNew.RequirementsJSON) { // logDescriptions.Add("Job Requirements List Changed."); // changes=changes|JobNotificationChanges.ConceptChange; //} if (jobOld.Title != jobNew.Title) { logDescriptions.Add("Job Title Changed."); } if (jobOld.HoursEstimate != jobNew.HoursEstimate) { logDescriptions.Add("Job Estimate Changed from " + jobOld.HoursEstimate.ToString() + " hour(s) to " + jobNew.HoursEstimate.ToString() + " hour(s)."); } jobLog.Title = jobNew.Title; jobLog.Description = string.Join("\r\n", logDescriptions); if (string.IsNullOrEmpty(jobLog.Description)) { return(null); } JobLogs.Insert(jobLog); JobNotifications.UpsertAllNotifications(jobNew, Security.CurUser.UserNum, changes); return(JobLogs.GetOne(jobLog.JobLogNum)); //to get new timestamp. }
///<summary>Removes invalid jobs from the list of jobs passed in and then queries the DB to fill corresponding in-memory lists for remaining jobs. ///Set isForSearch true in order to only fill in-memory lists that are required for the Job Search window.</summary> public static void FillInMemoryLists(List <Job> listJobsAll, bool isForSearch = false) { //No need for remoting call here. listJobsAll.RemoveAll(x => x == null || x.JobNum == 0); List <long> jobNums = listJobsAll.Select(x => x.JobNum).ToList(); Dictionary <long, List <JobLink> > dictJobLinksAll = new Dictionary <long, List <JobLink> >(); Dictionary <long, List <JobNote> > dictJobNotesAll = new Dictionary <long, List <JobNote> >(); Dictionary <long, List <JobReview> > dictJobReviewsAll = new Dictionary <long, List <JobReview> >(); Dictionary <long, List <JobReview> > dictJobTimeLogsAll = new Dictionary <long, List <JobReview> >(); Dictionary <long, List <JobQuote> > dictJobQuotesAll = new Dictionary <long, List <JobQuote> >(); Dictionary <long, List <JobLog> > dictJobLogsAll = new Dictionary <long, List <JobLog> >(); Dictionary <long, List <JobNotification> > dictJobNotificationsAll = new Dictionary <long, List <JobNotification> >(); Dictionary <long, List <JobActiveLink> > dictJobActiveLinksAll = new Dictionary <long, List <JobActiveLink> >(); //The job search only needs ListJobLinks and ListJobReviews to be filled. dictJobLinksAll = JobLinks.GetJobLinksForJobs(jobNums).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); dictJobReviewsAll = JobReviews.GetReviewsForJobs(jobNums.ToArray()).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); //Fill all other dictionaries when not filling in-memory lists for job search results (saves db calls and memory usage). if (!isForSearch) { dictJobNotesAll = JobNotes.GetJobNotesForJobs(jobNums).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); dictJobTimeLogsAll = JobReviews.GetTimeLogsForJobs(jobNums.ToArray()).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); dictJobQuotesAll = JobQuotes.GetJobQuotesForJobs(jobNums).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); dictJobLogsAll = JobLogs.GetJobLogsForJobs(jobNums).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); dictJobNotificationsAll = JobNotifications.GetNotificationsForJobs(jobNums).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); dictJobActiveLinksAll = JobActiveLinks.GetJobActiveLinksForJobNums(jobNums).GroupBy(x => x.JobNum).ToDictionary(x => x.Key, x => x.ToList()); } foreach (Job job in listJobsAll) { if (!dictJobLinksAll.TryGetValue(job.JobNum, out job.ListJobLinks)) { job.ListJobLinks = new List <JobLink>(); //empty list if not found } if (!dictJobNotesAll.TryGetValue(job.JobNum, out job.ListJobNotes)) { job.ListJobNotes = new List <JobNote>(); //empty list if not found } if (!dictJobReviewsAll.TryGetValue(job.JobNum, out job.ListJobReviews)) { job.ListJobReviews = new List <JobReview>(); //empty list if not found } if (!dictJobTimeLogsAll.TryGetValue(job.JobNum, out job.ListJobTimeLogs)) { job.ListJobTimeLogs = new List <JobReview>(); //empty list if not found } if (!dictJobQuotesAll.TryGetValue(job.JobNum, out job.ListJobQuotes)) { job.ListJobQuotes = new List <JobQuote>(); //empty list if not found } if (!dictJobLogsAll.TryGetValue(job.JobNum, out job.ListJobLogs)) { job.ListJobLogs = new List <JobLog>(); //empty list if not found } if (!dictJobNotificationsAll.TryGetValue(job.JobNum, out job.ListJobNotifications)) { job.ListJobNotifications = new List <JobNotification>(); //empty list if not found } if (!dictJobActiveLinksAll.TryGetValue(job.JobNum, out job.ListJobActiveLinks)) { job.ListJobActiveLinks = new List <JobActiveLink>(); //empty list if not found } } }