//public static PersonelAylikSaat LoadPersonelAylikSaatWithId(int id)
//{
// string sql = @"select * FROM AYLIKSAAT WHERE PERSONEL_ID = :ID";
// return SqlDataAccess.LoadDatawithId<PersonelAylikSaat>(sql, id);
//}
public static dynamic LoadPersonelAylikSaatWithId(int id)
{
string sql = @"SELECT p.*, a.*, f.* FROM AYLIKSAAT a FULL OUTER JOIN PLANLANANAYLIKSAAT p ON a.PERSONEL_ID = p.PERSONEL_ID FULL OUTER JOIN FATURALANANAYLIKSAAT f ON p.PERSONEL_ID = f.PERSONEL_ID WHERE p.PERSONEL_ID = :ID";
return(SqlDataAccess.LoadDatawithId <dynamic>(sql, id));
}