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);
}
