public void Import(DataSet oDataSet, AcademicYear academicYear)
{
var emails = new List<string>();
if(oDataSet.Tables.Count == 0)
return;
if(oDataSet.Tables[0].Rows.Count <= 15)
return;
var dtDatos = oDataSet.Tables[0];
var listStudents = new List<Student>();
var listParents = new List<Parent>();
for (var indice = 15; indice < dtDatos.Rows.Count; indice++)
{
if(dtDatos.Rows[indice][2].ToString().Trim().Length == 0)
continue;
var newStudents = new Student
{
IdNumber = dtDatos.Rows[indice][2].ToString()
,LastName = (dtDatos.Rows[indice][3] + " " + dtDatos.Rows[indice][4]).Trim()
,FirstName = dtDatos.Rows[indice][6].ToString()
,MyGender = Utilities.DefineGender(dtDatos.Rows[indice][8].ToString())
,BirthDate = DateTime.FromOADate(Double.Parse(dtDatos.Rows[indice][9].ToString())).ToShortDateString()
,Nationality = dtDatos.Rows[indice][13].ToString()
,State = dtDatos.Rows[indice][15].ToString()
};
newStudents.FullName = (newStudents.FirstName + " " + newStudents.LastName).Trim();
var newParent = new Parent
{
Nationality = dtDatos.Rows[indice][16].ToString()
,IdNumber = dtDatos.Rows[indice][18].ToString()
,LastName = (dtDatos.Rows[indice][19] + " " + dtDatos.Rows[indice][20]).Trim()
,FirstName = dtDatos.Rows[indice][21].ToString()
,MyGender = Utilities.DefineGender(dtDatos.Rows[indice][22].ToString())
,BirthDate = DateTime.FromOADate(Double.Parse(dtDatos.Rows[indice][24].ToString())).ToShortDateString()
,State = dtDatos.Rows[indice][25].ToString()
,City = dtDatos.Rows[indice][26].ToString()
};
newParent.FullName = (newParent.FirstName + " " + newParent.LastName).Trim();
var newContactInformation = new ContactInformation
{
Type = "Telefono"
,Value = dtDatos.Rows[indice][27].ToString()
,People = newParent
};
emails.Add(dtDatos.Rows[indice][28].ToString());
var listContacts = new List<ContactInformation> {newContactInformation};
newParent.Contacts = listContacts;
//newParent.MyUser.Email
newStudents.Tutor1 = newParent;
listStudents.Add(newStudents);
listParents.Add(newParent);
}
SaveData(listStudents, listParents, academicYear, emails);
}
public Student GenerateStudentFromRegisterModel(Student studentRegisterModel)
{
return new Student
{
FirstName = studentRegisterModel.FirstName,
LastName = studentRegisterModel.LastName,
FullName = (studentRegisterModel.FirstName + " " + studentRegisterModel.LastName).Trim(),
IdNumber = studentRegisterModel.IdNumber,
BirthDate = studentRegisterModel.BirthDate,
MyGender = studentRegisterModel.MyGender,
Nationality = studentRegisterModel.Nationality,
State = studentRegisterModel.State,
Country = studentRegisterModel.Country,
City = studentRegisterModel.City,
Address = studentRegisterModel.Address,
Biography = studentRegisterModel.Biography,
StartDate = studentRegisterModel.StartDate,
BloodType = studentRegisterModel.BloodType,
AccountNumber = studentRegisterModel.AccountNumber,
Tutor1 = studentRegisterModel.Tutor1,
Tutor2 = studentRegisterModel.Tutor2,
MyUser = studentRegisterModel.MyUser
};
}
public Student UpdateStudentFromStudentEditModel(Student studentEditModel, Student student)
{
student.FirstName = studentEditModel.FirstName;
student.LastName = studentEditModel.LastName;
student.FullName = (studentEditModel.FirstName + " " + studentEditModel.LastName).Trim();
student.Country = studentEditModel.Country;
student.IdNumber = studentEditModel.IdNumber;
student.BirthDate = studentEditModel.BirthDate;
student.MyGender = studentEditModel.MyGender;
student.Nationality = studentEditModel.Nationality;
student.State = studentEditModel.State;
student.City = studentEditModel.City;
student.Address = studentEditModel.Address;
student.Biography = studentEditModel.Biography;
student.StartDate = studentEditModel.StartDate;
student.BloodType = studentEditModel.BloodType;
student.AccountNumber = studentEditModel.AccountNumber;
student.Tutor1 = studentEditModel.Tutor1;
student.Tutor2 = studentEditModel.Tutor2;
student.MyUser = studentEditModel.MyUser;
student.Photo = studentEditModel.Photo;
return Update(student);
}
public Student Create(Student itemToCreate)
{
var student = _context.Students.Add(itemToCreate);
_context.SaveChanges();
return student;
}
public Student Update(Student itemToUpdate)
{
_context.SaveChanges();
return itemToUpdate;
}
