public void UpdateJobHistoy(JobHistory j) { _jobHistoyRepository.Update(j); }
public void RemoveJobHistory(JobHistory jobHistory) { context.Remove(context.JobHistories.Single(d => d.Id == jobHistory.Id)); context.SaveChanges(); }
public void AddJobHistoy(JobHistory j) { _jobHistoyRepository.Insert(j); }
public static void saveJobHistory(DataTable dt, ref JobHistory mo) { foreach (DataRow dr in dt.Rows) { saveJobHistory(dr, ref mo); } }
public _HSAdminServer_119(TestHSAdminServer _enclosing, AggregatedLogDeletionService baseArg1, JobHistory baseArg2) : base(baseArg1, baseArg2) { this._enclosing = _enclosing; }
public static void deleteJobHistory(JobHistory JobHistoryObj) { JobHistoryDBMapper dbm = new JobHistoryDBMapper(); dbm.delete(JobHistoryObj); }
/// <summary> /// Reload the JobHistory from the database /// </summary> /// <remarks> /// use this method when you want to relad the JobHistory /// from the database, discarding any changes /// </remarks> public static void reload(ref JobHistory mo) { if (mo == null) { throw new System.ArgumentNullException("null object past to reload function"); } mo = (JobHistory)new JobHistoryDBMapper().findByKey(mo.Id); }
public virtual JobHistory Put(JobHistory jobHistory) { _jobHistorysController.ActiveUser = Models.ApiContext.ActiveUser; return(_jobHistorysController.Put(jobHistory)); }
public override void load(IModelObject mo) { const int DATAREADER_FLD_JOB_HISTORY_ID = 0; const int DATAREADER_FLD_EMPLOYEE_ID = 1; const int DATAREADER_FLD_START_DATE = 2; const int DATAREADER_FLD_END_DATE = 3; const int DATAREADER_FLD_JOB_ID = 4; const int DATAREADER_FLD_DEPARTMENT_ID = 5; const int DATAREADER_FLD_CREATE_DATE = 6; const int DATAREADER_FLD_UPDATE_DATE = 7; const int DATAREADER_FLD_CREATE_USER = 8; const int DATAREADER_FLD_UPDATE_USER = 9; JobHistory obj = (JobHistory)mo; obj.IsObjectLoading = true; if (!this.reader.IsDBNull(DATAREADER_FLD_JOB_HISTORY_ID)) { obj.PrJobHistoryId = Convert.ToInt64(this.reader.GetDecimal(DATAREADER_FLD_JOB_HISTORY_ID)); } if (!this.reader.IsDBNull(DATAREADER_FLD_EMPLOYEE_ID)) { obj.PrEmployeeId = Convert.ToInt64(this.reader.GetDecimal(DATAREADER_FLD_EMPLOYEE_ID)); } if (!this.reader.IsDBNull(DATAREADER_FLD_START_DATE)) { obj.PrStartDate = this.reader.GetDateTime(DATAREADER_FLD_START_DATE); } if (!this.reader.IsDBNull(DATAREADER_FLD_END_DATE)) { obj.PrEndDate = this.reader.GetDateTime(DATAREADER_FLD_END_DATE); } if (!this.reader.IsDBNull(DATAREADER_FLD_JOB_ID)) { obj.PrJobId = this.reader.GetString(DATAREADER_FLD_JOB_ID); } if (!this.reader.IsDBNull(DATAREADER_FLD_DEPARTMENT_ID)) { obj.PrDepartmentId = Convert.ToInt64(this.reader.GetDecimal(DATAREADER_FLD_DEPARTMENT_ID)); } if (!this.reader.IsDBNull(DATAREADER_FLD_CREATE_DATE)) { obj.CreateDate = this.reader.GetDateTime(DATAREADER_FLD_CREATE_DATE); } if (!this.reader.IsDBNull(DATAREADER_FLD_UPDATE_DATE)) { obj.UpdateDate = this.reader.GetDateTime(DATAREADER_FLD_UPDATE_DATE); } if (!this.reader.IsDBNull(DATAREADER_FLD_CREATE_USER)) { obj.CreateUser = this.reader.GetString(DATAREADER_FLD_CREATE_USER); } if (!this.reader.IsDBNull(DATAREADER_FLD_UPDATE_USER)) { obj.UpdateUser = this.reader.GetString(DATAREADER_FLD_UPDATE_USER); } obj.isNew = false; // since we've just loaded from database, we mark as "old" obj.isDirty = false; obj.IsObjectLoading = false; obj.afterLoad(); return; }
public IActionResult Edit(JobHistory model) { GetHistroy.Update(model); return(RedirectToAction("Index")); }
public void Execute() { var startTime = DateTime.Now; ReturnValue result; var jobHistory = new JobHistory { StartTime = startTime, SensorId = sensor.Id, SensorName = sensor.Name }; try { log.Debug($"Started executing sensor - {sensor.Name} with Id - {sensor.Id}"); result = sensor.Execute(appConfig, log); jobHistory.EndTime = DateTime.Now; if (result == null) { result = ReturnValue.False($"Unexpected error when executing sensor - {sensor.Name} with Id - {sensor.Id}"); } var str = ""; if (result.Result) { str = $"Completed executing sensor - {sensor.Name} with Id - {sensor.Id}"; log.Debug(str); } else { str = $"Completed executing sensor with error - {sensor.Name} with Id - {sensor.Id} - error - {result?.ErrorAndWarningMessageForReporing()}"; log.Error(str); } jobHistory.IsSuccess = result.Result; jobHistory.Message = str; } catch (Exception ex) { var str = $"Error executing sensor - {sensor.Name} with Id - {sensor.Id}, Exception - {ex.RecursivelyGetExceptionMessage()}"; log.Error(ex, $"Error executing sensor - {sensor.Name} with Id - {sensor.Id}"); result = ReturnValue.False(str); jobHistory.Message = str; } finally { sensor.LastExecutedDateTime = startTime; sensor.LastExecutionTimeInSecs = (DateTime.Now - startTime).TotalSeconds; } if (result.Result) { sensor.ContinousErrorOccurenceCount = 0; } else { sensor.ContinousErrorOccurenceCount++; jobHistory.Notified = false; if (sensor.ContinousErrorOccurenceCount >= sensor.NotifyIfHappensAfterTimes) { log.Debug($"{sensor.Name} with Id - {sensor.Id}, Continous error occured."); sensor.ContinousErrorOccurenceCount = 0; if (sensor.NotifyByEmail) { log.Debug($"Sending mail for failed sensor - {sensor.Name} (Id - {sensor.Id}) ."); var param = new TemplateParameters { MachineName = Environment.MachineName, SensorName = sensor.Name, SensorId = sensor.Id.ToString(), SensorType = sensor.SensorType.ToString(), ErrorMessageList = result.ErrorMessages, MessagePrefix = appConfig.EmailTemplateSettings.MessagePrefix, MessageSuffix = appConfig.EmailTemplateSettings.MessageSuffix, SensorAllErrorMessage = result.ErrorMessages.ToString(""), }; var emailResult = emailService.SendMail(ApplyAndGetTemplate(param, appConfig.EmailTemplateSettings.DefaultSubject), ApplyAndGetTemplate(param, appConfig.EmailTemplateSettings.DefaultTextBody), ApplyAndGetTemplate(param, appConfig.EmailTemplateSettings.DefaultHtmlBody)); jobHistory.Notified = !ReturnValue.IsNullOrFalse(emailResult); } } else { log.Debug($"Ignoring the Notification as the Thresold ({sensor.ContinousErrorOccurenceCount} / {sensor.NotifyIfHappensAfterTimes}) did not reach for Sensor - {sensor.Name} - {sensor.SensorType} - {sensor.Id}"); } } try { using (var db = new LiteDatabase(appConfig.GetOrCreateHistoryDbPath())) { var history = db.GetCollection <JobHistory>("jobhistory"); history.Insert(jobHistory); } } catch (Exception ex) { log.Error(ex, "Error writing to the history table"); } }
public IActionResult Create(JobHistory model) { GetHistroy.Insert(model); return(RedirectToAction("Index")); }
public async Task<ActionResult> Index(List<JobHistoryModel> model) { if (ModelState.IsValid) { bool historyStored = false; using (var client = new DataServiceClient()) { client.Open(); var history = new List<JobHistory>(); foreach (var jobHistory in model) { int tempYear; int tempMonth; var jobHist = new JobHistory(); jobHist.street = jobHistory.street; jobHist.city = jobHistory.city; jobHist.stateAbrev = jobHistory.state; jobHist.zip = jobHistory.zip; jobHist.applicantId = Convert.ToInt32(this.Session["ApplicantId"]); jobHist.duties = jobHistory.responsibilities; jobHist.employer = jobHistory.employer; jobHist.endSalary = jobHistory.salary_end; jobHist.startSalary = jobHistory.salary_start; if (jobHistory.from_year != null && jobHistory.from_month != null) { tempYear = Convert.ToInt32(jobHistory.from_year); tempMonth = Convert.ToInt32(jobHistory.from_month); jobHist.fromDate = new DateTime(tempYear, tempMonth, 1); tempYear = Convert.ToInt32(jobHistory.to_year); tempMonth = Convert.ToInt32(jobHistory.to_month); jobHist.toDate = new DateTime(tempYear, tempMonth, 1); } else { jobHist.toDate = null; jobHist.fromDate = null; } jobHist.phone = jobHistory.phone; jobHist.position = jobHistory.position; jobHist.reasonLeave = jobHistory.reason_for_leaving; jobHist.supervisor = jobHistory.supervisor; jobHist.applicantId = jobHistory.applicantId; jobHist.jobHistoryId = jobHistory.historyId; history.Add(jobHist); } historyStored = await client.updateJobHistoryAsync(history.ToArray()); client.Close(); } if (historyStored/**true**/) { this.Session["JobHistory"] = "Done"; return RedirectToAction("Index", "Education"); } else { //error in storing history... add error view or determine action?? } } return View(model); }
public JobHistoryTest() { _jobHistory = new JobHistory(); }
public void DeleteJobHistoy(JobHistory j) { _jobHistoyRepository.Delete(j); }
public void Display(JobHistory jobHistory) { jobHistoryNameTextView.Text = $"{jobHistory}"; resultTextView.Text = $"{jobHistory.GetLastResult()}."; }
public void saveJobHistory(JobHistory mo) { base.save(mo); }
public static JobHistory loadFromDataRow(DataRow r) { DataRowLoader a = new DataRowLoader(); IModelObject mo = new JobHistory(); a.DataSource = r; a.load(mo); return (JobHistory)mo; }
private void InitTest() { _jobHistory = CreateEntity(); }
public static void saveJobHistory(DataRow dr, ref JobHistory mo) { if (mo == null) { mo = new JobHistory(); } foreach (DataColumn dc in dr.Table.Columns) { mo.setAttribute(dc.ColumnName, dr[dc.ColumnName]); } saveJobHistory(mo); }
public JobHistory AddJobHistory(JobHistory jobHistory) { context.JobHistories.Add(jobHistory); context.SaveChanges(); return(jobHistory); }
[TestMethod()] public void TestLoadAndSaveJobHistory() { ModelContext.beginTrans(); try { OracleMappers.JobHistoryDBMapper pdb = new OracleMappers.JobHistoryDBMapper(); long count = pdb.RecordCount(); if (pdb.SelectFromObjectName != pdb.ManagedTableName) { long countFromSelectObject = pdb.dbConn.getLngValue("select count(*) from " + pdb.SelectFromObjectName); Assert.AreEqual(count, countFromSelectObject, "Count of records in managedTableName {0} and SelectFromObjectName {1} should be equal, as there needs to be exactly 1 to 1 match between records in managed table and selectFromObject.", pdb.ManagedTableName, pdb.SelectFromObjectName); } if (count == 0) { Assert.Inconclusive("No JobHistory in database, table is empty"); } else { /** * using (DataContext ctx = DBUtils.Current().dbContext()) { * * var query = ctx.ExecuteQuery<JobHistory>(@"SELECT * FROM " + pdb.SelectFromObjectName ).Skip(1).Take(1); * var lst = query.ToList(); * * Assert.AreEqual(lst.Count, 1, "Expected to receive 1 record, got: " + lst.Count); * * } * todo: fix boolean fields by generating properties of original fields **/ object pid = ModelContext.CurrentDBUtils.getObjectValue("select top 1 " + pdb.pkFieldName + " from " + pdb.ManagedTableName); JobHistory p = pdb.findByKey(pid); JobHistory p2 = (JobHistory)p.copy(); //Test equality and hash codes Assert.AreEqual(p.GetHashCode(), p2.GetHashCode()); Assert.AreEqual(p, p2); p.isDirty = true; // force save pdb.save(p); // now reload object from database p = null; p = pdb.findByKey(pid); //test fields to be equal before and after save Assert.IsTrue(p.PrJobHistoryId == p2.PrJobHistoryId, "Expected Field JobHistoryId to be equal"); Assert.IsTrue(p.PrEmployeeId.GetValueOrDefault() == p2.PrEmployeeId.GetValueOrDefault(), "Expected Field EmployeeId to be equal"); Assert.IsTrue(p.PrStartDate.GetValueOrDefault() == p2.PrStartDate.GetValueOrDefault(), "Expected Field StartDate to be equal"); Assert.IsTrue(p.PrEndDate.GetValueOrDefault() == p2.PrEndDate.GetValueOrDefault(), "Expected Field EndDate to be equal"); Assert.IsTrue(p.PrJobId == p2.PrJobId, "Expected Field JobId to be equal"); Assert.IsTrue(p.PrDepartmentId.GetValueOrDefault() == p2.PrDepartmentId.GetValueOrDefault(), "Expected Field DepartmentId to be equal"); Assert.IsTrue(p.CreateDate.GetValueOrDefault().ToString("MM/dd/yy H:mm:ss zzz") == p2.CreateDate.GetValueOrDefault().ToString("MM/dd/yy H:mm:ss zzz"), "Expected Field CreateDate to be equal"); Assert.IsFalse(p.UpdateDate.GetValueOrDefault() == p2.UpdateDate.GetValueOrDefault(), "Expected Field UpdateDate NOT to be equal"); Assert.IsTrue(p.CreateUser == p2.CreateUser, "Expected Field CreateUser to be equal"); //skip update user! p.isDirty = true; //to force save ModelContext.Current.saveModelObject(p); p = ModelContext.Current.loadModelObject <JobHistory>(p.Id); p.loadObjectHierarchy(); string json = JsonConvert.SerializeObject(p, Formatting.Indented, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); System.IO.FileInfo jf = new System.IO.FileInfo(".\\JobHistory.json"); System.IO.File.WriteAllText(jf.FullName, json); if (pdb.isPrimaryKeyAutogenerated) { p.isNew = true; p.isDirty = true; try { pdb.save(p); } catch (System.Exception e) { Assert.IsTrue(e.Message.ToUpper().Contains("UNIQUE INDEX") || e.Message.Contains("Violation of UNIQUE KEY constraint"), "Insert statement produced error other than violation of unique key:" + e.Message); } } } } finally { ModelContext.rollbackTrans(); // 'Nothing should be saved to the database! } }