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