public async Task <bool> AcceptOrDeclinePositionAssign([FromBody] AcceptOrDeclinePositionAssignModel model) { var res = await _positionAssignRepo.AcceptOrDeclinePositionAssign(model); if (res) { string accept = model.Accept ? "Accepted" : "Declined"; var directUpdate = new DirectUpdateModel(); // Add to Application the Status directly from MyTUIProfile modal { directUpdate.StaffId = model.StaffId; directUpdate.DeclineReason = model.DeclineReason; directUpdate.Season = model.Season; directUpdate.Status = accept; }; _applicationRepo.SetDeclineReason(directUpdate); var History = new WorkHistoryModel(); // Add to History all actions of relevancy { History.StaffID = model.StaffId; //History.MPLID = application.MPLID; History.HistoryDate = DateTime.UtcNow; History.HistoryAction = accept; History.HistoryContent = model.DeclineComment; History.HistoryContent2 = model.DeclineReason; History.HistoryLocation = model.JobTitle; History.Season = model.Season; History.ApplicationType = "AcceptDecline"; History.DateModified = DateTime.UtcNow; History.Status = "Received"; History.JobTitle = model.JobTitle; // History.Season = model.Season; // History.Accepted = application.Accept; //History.EndDate = application.EndDate; //History.HistoryWho = UserName.UserName; // History.HistoryWho = System.Security.Principal.WindowsIdentity.GetCurrent().Name; }; // _historyRepo.UpdateHistory(History); _historyRepo.UpdateWorkHistory(History); } return(res); }
public void UpdateWorkHistory(WorkHistoryModel model) { using (var connection = new SqlConnection(connectionString)) { ; var sql = @"INSERT INTO WorkHistory(StaffID, HistoryDate, HistoryAction, HistoryContent,HistoryContent2,ApplicationType, DateModified, Status, HistoryWho,Season,JobTitle) VALUES(@StaffID, @HistoryDate, @HistoryAction,@HistoryContent,@HistoryContent2, @ApplicationType, @DateModified, @Status, @HistoryWho,@Season,@JobTitle)"; try { { connection.Execute(sql, new { model.StaffID, model.HistoryDate, model.HistoryAction, model.HistoryContent, model.ApplicationType, model.DateModified, model.Status, model.HistoryContent2, model.Season, model.JobTitle, model.HistoryWho //model.MPLID, //model.JobTitleWhenResigned, }); } } catch (Exception e) { Console.Write(e); throw; } } }