public AttendanceActual GetAttendanceActualByID(int intAttendanceActualID)
{
AttendanceActual retval = null;
// define a query
string query = "SELECT * FROM \"attendanceActual\" WHERE \"intAttendanceActualID\" = " + intAttendanceActualID;
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
// execute query
NpgsqlDataReader dr = cmd.ExecuteReader();
// read all rows and output the first column in each row
while (dr.Read())
{
retval = GetAttendanceActualFromDR(dr);
}
return(retval);
}
public bool InsertAttendanceActual(AttendanceActual attendanceActual)
{
// define a query
string query = "INSERT INTO public.\"attendanceActual\"(" +
" \"ysnDidShow\", \"intAttendancePlannedID\", \"dtmInTime\", \"dtmOutTime\")" +
" VALUES(@ysnDidShow, @intAttendancePlannedID, @dtmInTime, @dtmOutTime); ";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.AddWithValue("ysnDidShow", attendanceActual.YsnDidShow);
cmd.Parameters.AddWithValue("intAttendancePlannedID", attendanceActual.AttendancePlanned.IntAttendancePlannedID);
cmd.Parameters.AddWithValue("dtmInTime", LocalDateTime.FromDateTime(attendanceActual.DtmInTime));
cmd.Parameters.AddWithValue("dtmOutTime", DBNull.Value);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool InsertAttendanceActual(AttendanceActual attendanceActual)
{
//TODO
}
