private bool StudentCodeIsExists(String studentCode)
{
try
{
return(SqlRequestFunction.StudentIsExist(studentCode));
}
catch (Exception ex)
{
Debug.Fail(ex.Message);
return(false);
}
}
private void Dgv_Students_RowValidating(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
bool isFirst = true;
int index = 0;
foreach (DataGridViewCell drv in dgv_Students.Rows[e.RowIndex].Cells)
{
if (String.IsNullOrEmpty(drv.Value.ToString()))
{
e.Cancel = true;
dgv_Students.Rows[e.RowIndex].ErrorText = "Had error";
dgv_Students.Rows[e.RowIndex].Cells[index].ErrorText = "Dose not empty.";
dgv_Students.CurrentCell = drv;
}
else
{
dgv_Students.Rows[e.RowIndex].Cells[index].ErrorText = null;
}
if (isFirst)
{
string valCurrent = drv.FormattedValue.ToString();
if (SqlRequestFunction.StudentIsExist(valCurrent))
{
dgv_Students.Rows[e.RowIndex].ErrorText = "Had error";
dgv_Students.Rows[e.RowIndex].Cells[index].ErrorText = "Student Code Is Exists.";
dgv_Students.CurrentCell = drv;
}
else
{
dgv_Students.Rows[e.RowIndex].Cells[index].ErrorText = null;
}
isFirst = false;
}
index++;
}
}
catch { }
}
