private void InsertStudent()
{
PhysicalAssessmentDetail entity = new PhysicalAssessmentDetail();
PhysicalAssessmentDetailDAO m_PhysicalDetailDAO = new PhysicalAssessmentDetailDAO();
if (iFunction == 1)
{
int a1 = gridView1.SelectedRowsCount;
int[] a = gridView1.GetSelectedRows();
for (int i = 0; i < a1; i++)
{
entity.StudentID = (int)gridView1.GetRowCellValue(a[i], gridView1.Columns["StudentID"]);
entity.PhysicalAssessmentID = physicalAssessment.PhysicalAssessmentID;
entity.Height = 0;
entity.Weight = 0;
entity.HeightRating = "Chưa đánh giá";
entity.WeightRating = "Chưa đánh giá";
entity.Note = "Chưa đánh giá";
entity.Status = true;
if (m_PhysicalDetailDAO.PhysicalDetailInsert(entity) == true)
{
}
else
{
XtraMessageBox.Show("Bản ghi " + i + "bị lỗi");
}
}
XtraMessageBox.Show("Thêm danh sách học sinh thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
this.Close();
}
}
public bool PhysicalDetailInsert(PhysicalAssessmentDetail entity)
{
try
{
PhysicalDetailTable = db.GetTable <PhysicalAssessmentDetail>();
PhysicalDetailTable.InsertOnSubmit(entity);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool PhysicalDetailDelete(int PhysicalAssessmentDetailID)
{
try
{
PhysicalDetailTable = db.GetTable <PhysicalAssessmentDetail>();
PhysicalAssessmentDetail model = PhysicalDetailTable.SingleOrDefault(x => x.PhysicalAssessmentDeailID.Equals(PhysicalAssessmentDetailID));
db.PhysicalAssessmentDetails.DeleteOnSubmit(model);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool PhysicalDetailInsert(PhysicalAssessmentDetail entity)
{
PhysicalAssessmentDetail a = new PhysicalAssessmentDetail();
a.PhysicalAssessmentID = entity.PhysicalAssessmentID;
a.StudentID = entity.StudentID;
a.Status = false;
a.Height = entity.Height;
a.Weight = entity.Weight;
a.HeightRating = entity.HeightRating;
a.WeightRating = entity.WeightRating;
a.Note = entity.Note;
db.PhysicalAssessmentDetails.InsertOnSubmit(a);
db.SubmitChanges();
return(true);
}
public bool PhysicalDetailUpdate(PhysicalAssessmentDetail entity)
{
try
{
PhysicalDetailTable = db.GetTable <PhysicalAssessmentDetail>();
PhysicalAssessmentDetail model = PhysicalDetailTable.SingleOrDefault(x => x.PhysicalAssessmentID == entity.PhysicalAssessmentID && x.PhysicalAssessmentDeailID == entity.PhysicalAssessmentDeailID);
//model.PhysicalAssessmentID = entity.PhysicalAssessmentID;
//model.StudentID = entity.StudentID;
model.Height = entity.Height;
model.Weight = entity.Weight;
model.HeightRating = entity.HeightRating;
model.WeightRating = entity.WeightRating;
//model.OtherRating = entity.OtherRating;
model.Note = entity.Note;
model.Status = entity.Status;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
