private void btnImport_Click(object sender, EventArgs e)
{
var result = openFileDialog1.ShowDialog();
var file = openFileDialog1.FileName;
if (result != DialogResult.OK)
{
return;
}
var itemList = File.ReadLines(file).ToList();
foreach (var line in itemList)
{
var splitter = line.Split('\t');
var listClassStudents = studentClassRepository.GetAll();
var student = listClassStudents.Last();
var studentClassId = student.Id;
StudentClassDo studentData = new StudentClassDo
{
Id = ++studentClassId,
Name = splitter[0],
StudentId = Int32.Parse(splitter[1]),
Promoted = splitter[2]
};
studentClassRepository.Insert(studentData);
}
}
public void Insert(StudentClassDo studentClass)
{
if (studentClass == null)
{
throw new Exception("An insert with null value can't be made!");
}
var query = InsertQuery.Create("studentClasses", studentClass);
database.Execute(query);
}
private void insertClass_Click(object sender, EventArgs e)
{
List <StudentClassDo> listClassStudents = studentClassRepository.GetAll();
StudentClassDo studentClass = listClassStudents.Last();
int studentClassId = studentClass.Id;
StudentClassDo studentClassData = new StudentClassDo();
studentClassData.Id = ++studentClassId;
studentClassData.Name = txtClassName.Text;
studentClassData.Promoted = combPromoted.Text;
studentClassData.StudentId = Int32.Parse(textStudentId.Text);
studentClassRepository.Insert(studentClassData);
MessageBox.Show("Done !");
}
private List <StudentClassDo> GetData(IQueryResult query)
{
List <StudentClassDo> statuses = new List <StudentClassDo>();
foreach (var row in query.Result.Rows)
{
StudentClassDo status = new StudentClassDo();
new AutoMapper(status, row.Values).Start();
statuses.Add(status);
}
return(statuses);
}
public StudentClassDo Get(int classId)
{
var query = database.Query(string.Format(Queries.GetClassById, classId));
if (query == null)
{
return(null);
}
var studentClass = new StudentClassDo();
new AutoMapper(studentClass, query.Result.Rows.First().Values).Start();
return(studentClass);
}
private void btnImport_Click(object sender, EventArgs e)
{
var result = openFileDialog1.ShowDialog();
var file = openFileDialog1.FileName;
if (result != DialogResult.OK)
{
return;
}
var itemList = File.ReadLines(file).ToList();
foreach (var line in itemList)
{
var splitter = line.Split('\t');
var listStudents = studentRepository.GetAll();
var student = listStudents.Last();
var studentId = student.Id;
StudentDo studentData = new StudentDo
{
Id = ++studentId,
Age = splitter[0],
FirstName = splitter[1],
LastName = splitter[2],
Gender = splitter[3],
EmailAddress = splitter[4]
};
studentRepository.Insert(studentData);
var listClassStudents = studentClassRepository.GetAll();
var studentClass = listClassStudents.Last();
var studentClassId = student.Id;
var studentClassData = new StudentClassDo()
{
Id = ++studentClassId,
StudentId = studentId,
};
MessageBox.Show("Done !");
}
}
private void Insert_Click(object sender, EventArgs e)
{
int nextStudentId = getLastStudentId();
//TODO: not complete
StudentDo studentData = new StudentDo();
studentData.Id = nextStudentId;
studentData.Age = textAge.Text;
studentData.FirstName = textFirstName.Text;
studentData.LastName = textLastName.Text;
studentData.Gender = textGender.Text;
studentData.EmailAddress = textEmail.Text;
insertStudent(studentData);
List <StudentClassDo> listClassStudents = studentClassRepository.GetAll();
StudentClassDo studentClass = listClassStudents.Last();
//studentClassRepository.Insert(studentClassData);
MessageBox.Show("Done !");
}
