private void GvGrade_CellClick(object sender, DataGridViewCellEventArgs e)
{
Entity.Grade grade = new Entity.Grade();
int index = e.RowIndex;
DataGridViewRow row = gvGrade.Rows[index];
TextBox textBox = new TextBox();
grade.MSSV = row.Cells[0].Value.ToString();
grade.DiemGK = float.Parse(row.Cells[2].Value.ToString());
grade.DiemCK = float.Parse(row.Cells[3].Value.ToString());
grade.DiemKhac = float.Parse(row.Cells[4].Value.ToString());
grade.DiemTong = float.Parse(row.Cells[5].Value.ToString());
grade.Semester = cbSemester.SelectedItem.ToString();
grade.ClassID = cbClass.SelectedItem.ToString();
grade.CourseID = cbCourse.SelectedItem.ToString();
EditGrade layoutEdit = new EditGrade(grade);
layoutEdit.Show();
}
void importDataGrade()
{
List <Entity.Grade> gradeList = new List <Entity.Grade>();
string path = tbPath.Text.ToString();
string namefile = path.Substring(path.LastIndexOf("\\") + 1);
var str = namefile.Split('-');
var reader = new StreamReader(@path);
int rows = 0;
try
{
while (!reader.EndOfStream)
{
Entity.Grade grade = new Entity.Grade();
var line = reader.ReadLine();
var value = line.Split(',');
if (rows > 1)
{
grade.MSSV = value[1];
grade.CourseID = str[1];
grade.DiemGK = float.Parse(value[3]);
grade.DiemCK = float.Parse(value[4]);
grade.DiemKhac = float.Parse(value[5]);
grade.DiemTong = float.Parse(value[6]);
grade.Semester = str[0];
grade.ClassID = str[2];
gradeList.Add(grade);
}
rows++;
}
ManagementBLL mBLL = new ManagementBLL();
mBLL.insertGrade(gradeList);
}
catch
{
}
}
