private List <string> ConvertToColumnValues(LecturerCourseSubjectModel lcs) { List <string> colValues = new List <string>(); try { string CourseStartDate = "", CourseEndDate = ""; CourseStartDate = CourseStartDate + lcs.StartDate.Year; if (lcs.StartDate.Month < 10) { CourseStartDate = CourseStartDate + "0" + lcs.StartDate.Month; } else { CourseStartDate = CourseStartDate + lcs.StartDate.Month; } if (lcs.StartDate.Day < 10) { CourseStartDate = CourseStartDate + "0" + lcs.StartDate.Day; } else { CourseStartDate = CourseStartDate + lcs.StartDate.Day; } CourseEndDate = CourseEndDate + lcs.EndDate.Year; if (lcs.EndDate.Month < 10) { CourseEndDate = CourseEndDate + "0" + lcs.EndDate.Month; } else { CourseEndDate = CourseEndDate + lcs.EndDate.Month; } if (lcs.EndDate.Day < 10) { CourseEndDate = CourseEndDate + "0" + lcs.EndDate.Day; } else { CourseEndDate = CourseEndDate + lcs.EndDate.Day; } colValues.Add(lcs.CourseSubjectId.ToString()); colValues.Add(lcs.LecturerId.ToString()); colValues.Add("'" + CourseStartDate + "'"); colValues.Add("'" + CourseEndDate + "'"); colValues.Add(lcs.IsFlagged.ToString()); } catch (Exception) { throw; } return(colValues); }
private static LecturerCourseSubjectModel ConvertToLecturerCourseSubject(Dictionary <string, string> fieldValues) { LecturerCourseSubjectModel lcs = new LecturerCourseSubjectModel(); foreach (KeyValuePair <string, string> row in fieldValues) { switch (row.Key) { case "id": try { lcs.LCSId = int.Parse(row.Value); } catch (Exception) { throw; } break; case "CourseSubjectID": try { lcs.CourseSubjectId = int.Parse(row.Value); } catch (Exception) { throw; } break; case "LecturerID": try { lcs.LecturerId = int.Parse(row.Value); } catch (Exception) { throw; } break; case "startDate": string[] dateParts = row.Value.Split('/'); lcs.StartDate = new DateTime(int.Parse(dateParts[0]), int.Parse(dateParts[1]), int.Parse(dateParts[2].Substring(0, 2))); break; case "endDate": dateParts = row.Value.Split('/'); lcs.EndDate = new DateTime(int.Parse(dateParts[0]), int.Parse(dateParts[1]), int.Parse(dateParts[2].Substring(0, 2))); break; case "isFlagged": try { lcs.IsFlagged = int.Parse(row.Value); } catch (Exception) { throw; } break; default: break; } } return(lcs); }