public async Task <IHttpActionResult> GetTrainingTest3() { // var data=HelperTraining.GetTrainingTest(); var data = HelperTraining.GetIdeaAll3(); return(Ok(data)); }
internal async Task <CustomActionResult> UpdateByIdea() { var serviceRecords = HelperTraining.GetIdeaAll(); var people = await this.context.People.ToListAsync(); this.context.Database.CommandTimeout = 160; var ideaRecords = await this.context.ViewIdeaLasts.ToListAsync(); foreach (var rec in ideaRecords) { if (rec.MappedTitle == "CRM") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.UpsetRecoveryTrainingIssueDate = rec.DateIssue; person.UpsetRecoveryTrainingExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "CCRM") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.CCRMIssueDate = rec.DateIssue; person.CCRMExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "SMS") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.SMSIssueDate = rec.DateIssue; person.SMSExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "FIRSTAID") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.FirstAidIssueDate = rec.DateIssue; person.FirstAidExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "DG") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.DangerousGoodsIssueDate = rec.DateIssue; person.DangerousGoodsExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "SEPT") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.SEPTIssueDate = rec.DateIssue; person.SEPTExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "AVSEC") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.AviationSecurityIssueDate = rec.DateIssue; person.AviationSecurityExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "HOT-WX") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.HotWeatherOperationIssueDate = rec.DateIssue; person.HotWeatherOperationExpireDate = rec.DateExpire; } } if (rec.MappedTitle == "COLD-WX") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.ColdWeatherOperationIssueDate = rec.DateIssue; person.ColdWeatherOperationExpireDate = rec.DateExpire; } } //Re/Annual-Re/Cabin if (rec.MappedTitle == "Re/Annual-Re/Cabin") { var person = people.FirstOrDefault(q => q.NID == rec.NID); if (person != null) { person.RecurrentIssueDate = rec.DateIssue; person.RecurrentExpireDate = rec.DateExpire; } } } var history = new ThirdPartySyncHistory() { App = "IDEA", DateSync = DateTime.Now, Remark = serviceRecords.Count + " Records Proccessed.", }; this.context.ThirdPartySyncHistories.Add(history); await this.context.SaveChangesAsync(); return(new CustomActionResult(HttpStatusCode.OK, history)); }