public static object GetIdeaAll3() { ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true; IdeaServiceRef.TrainingWSSoapClient client = new IdeaServiceRef.TrainingWSSoapClient(); try { var obj = client.GetPersonnelDataByDate("passcourse", "20210401", "20210501", ""); var records = new List <IdeaRecord2>(); var list = obj.Tables[0].Rows[0]; return(list.Table.Rows); } catch (Exception ex) { return(ex.Message + " Inner: " + (ex.InnerException != null ? ex.InnerException.Message : "-")); } }
public static object GetIdeaAll2() { ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true; IdeaServiceRef.TrainingWSSoapClient client = new IdeaServiceRef.TrainingWSSoapClient(); try { var obj = client.GetPersonnelDataByDate("passcourse", "20210401", "20210501", ""); var records = new List <IdeaRecord2>(); var list = obj.Tables[0].Rows[0]; for (int i = 0; i < list.Table.Rows.Count - 1; i++) { var row = list.Table.Rows[i]; var dt = row[13]; var ir = new IdeaRecord2() { row0 = DBNull.Value.Equals(row[0]) ? "null" : row[0].ToString(), row1 = DBNull.Value.Equals(row[1]) ? "null" : row[1].ToString(), row2 = DBNull.Value.Equals(row[2]) ? "null" : row[2].ToString(), row3 = DBNull.Value.Equals(row[3]) ? "null" : row[3].ToString(), row4 = DBNull.Value.Equals(row[4]) ? "null" : row[4].ToString(), row5 = DBNull.Value.Equals(row[5]) ? "null" : row[5].ToString(), row6 = DBNull.Value.Equals(row[6]) ? "null" : row[6].ToString(), row7 = DBNull.Value.Equals(row[7]) ? "null" : row[7].ToString(), row8 = DBNull.Value.Equals(row[8]) ? "null" : row[8].ToString(), row9 = DBNull.Value.Equals(row[9]) ? "null" : row[9].ToString(), row10 = DBNull.Value.Equals(row[10]) ? "null" : row[10].ToString(), row11 = DBNull.Value.Equals(row[11]) ? "null" : row[11].ToString(), row12 = DBNull.Value.Equals(row[12]) ? "null" : row[12].ToString(), row13 = DBNull.Value.Equals(row[13]) ? "null" : row[13].ToString(), row14 = DBNull.Value.Equals(row[14]) ? "null" : row[14].ToString(), }; records.Add(ir); } return(records); } catch (Exception ex) { return(ex.Message + " Inner: " + (ex.InnerException != null ? ex.InnerException.Message:"-")); } //using (var context = new EPAGRIFFINEntities()) //{ // context.Configuration.AutoDetectChangesEnabled = false; // context.Configuration.ValidateOnSaveEnabled = false; // var current = context.Ideas.ToList(); // context.Ideas.RemoveRange(current); // context.SaveChanges(); // foreach (var row in records) // { // var dbrec = new Idea() // { // DateStart = row.Start, // DateEnd = row.End, // BeginDate = row.Start.ToString(), // EndDate = row.End.ToString(), // NID = row.NID, // PID = row.PID, // CourseCode = row.CourseCode, // CourseTitle = row.CourseTitle, // FirstName = row.FirstName, // LastName = row.LastName, // DateIssue = row.Issue, // DateExpire = row.Expire, // Id = Guid.NewGuid(), // }; // context.Ideas.Add(dbrec); // } // context.SaveChanges(); //} // return records; }
public static List <IdeaRecord> GetIdeaAll() { ServicePointManager .ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true; IdeaServiceRef.TrainingWSSoapClient client = new IdeaServiceRef.TrainingWSSoapClient(); var obj = client.GetPersonnelDataByDate("passcourse", "20150101", "20220616", ""); // var obj2 = client.GetPersonnelDataByDate("passcourse", "20180101", "20210616", ""); // var obj3 = client.GetPersonnelDataByDate("", "20180101", "20200616", ""); // var empList = ds.Tables[0].AsEnumerable() //.Select(dataRow => new Employee //{ // Name = dataRow.Field<string>("Name") //}).ToList(); var records = new List <IdeaRecord>(); var list = obj.Tables[0].Rows[0]; for (int i = 0; i < list.Table.Rows.Count - 1; i++) { var row = list.Table.Rows[i]; var dt = row[13]; var ir = new IdeaRecord() { PID = row[0].ToString(), NID = row[1].ToString(), FirstName = row[2].ToString(), LastName = row[3].ToString(), CourseTitle = row[5].ToString(), CourseCode = row[4].ToString(), Issue = DBNull.Value.Equals(row[13]) ? null : (Nullable <DateTime>)Convert.ToDateTime(row[13]), Expire = DBNull.Value.Equals(row[14]) ? null : (Nullable <DateTime>)Convert.ToDateTime(row[14]), Start = DBNull.Value.Equals(row[8]) ? null : (Nullable <DateTime>)Convert.ToDateTime(row[8]), End = DBNull.Value.Equals(row[9]) ? null : (Nullable <DateTime>)Convert.ToDateTime(row[9]), }; records.Add(ir); } using (var context = new EPAGRIFFINEntities()) { context.Configuration.AutoDetectChangesEnabled = false; context.Configuration.ValidateOnSaveEnabled = false; var current = context.Ideas.ToList(); context.Ideas.RemoveRange(current); context.SaveChanges(); foreach (var row in records) { var dbrec = new Idea() { DateStart = row.Start, DateEnd = row.End, BeginDate = row.Start.ToString(), EndDate = row.End.ToString(), NID = row.NID, PID = row.PID, CourseCode = row.CourseCode, CourseTitle = row.CourseTitle, FirstName = row.FirstName, LastName = row.LastName, DateIssue = row.Issue, DateExpire = row.Expire, Id = Guid.NewGuid(), }; if (dbrec.CourseCode == "Re/Annual-Re/Cabin") { dbrec.DateIssue = dbrec.DateStart; } context.Ideas.Add(dbrec); } context.SaveChanges(); } return(records); }