private void InserVaoRaCa(LinqToExcel.Row row, int timeIndex, DateTime time)
{
VaoRaCaController controller = new VaoRaCaController();
DAL.VaoRaCa vao = new VaoRaCa();
vao.MaCa = "";
vao.Order = 1;
vao.MaChamCong = row[maChamCong].ToString().Trim();
vao.Time = row[timeIndex].ToString().Trim();
if (vao.Time.Length <= 5)
{
vao.Time += ":00";
}
string _time = string.Empty;
if (int.Parse(vao.Time.Split(':')[0]) > 23)
{
_time = "23:59:00";
}
else
{
_time = vao.Time;
}
vao.NgayChamCong = DateTime.Parse(time.ToString("yyyy-MM-dd " + _time));
vao.ID = vao.MaChamCong + vao.NgayChamCong.Day + vao.NgayChamCong.Month + vao.NgayChamCong.Year + vao.NgayChamCong.Hour +
vao.NgayChamCong.Minute + vao.NgayChamCong.Second;
vao.DiVao = true;
controller.InsertAndUpdate(vao);
}
private Domain.Student CreateStudentFromRow(Row row)
{
var student = new Domain.Student
{
Name = row["Name"],
MNumber = row["M-Number"],
Email = row["Email_Address"],
Major = row["Program_Desc"],
FbiExpiration = string.Join(",", row["FBI_DESE"], row["FBI_MOVECHS"], row["FBW_MOVECHS"]),
LiabExpiration = row["Liability Insurance Expiration"],
FcsrExpiration = row["FCSR Expiration Date"],
TbExpiration = row["TB Test Exp"]
};
student.Courses.Add(row["Course ID"].ToString().Split(' ')[0]);
return student;
}
