public static DataTable GetPersonelsWithFullName()
{
string sql = "SELECT id ,name +' ' + surname FullName From personnel";
return(NativeSqlDb.ExecuteReader(sql));
}
public static DataTable GetDepartments()
{
string sql = "SELECT DepID,Department FROM DEPARTMENTS Order by Department";
return(NativeSqlDb.ExecuteReader(sql));
}
public static DataTable GetSemesters()
{
string sql = "SELECT id ,semester FROM semster";
return(NativeSqlDb.ExecuteReader(sql));
}