Open Dental Forum

Code: Select all

public static List<AppointmentDeleted> GetChangedSince(DateTime changedSince)
{
    if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
    {
        return Meth.GetObject<List<AppointmentDeleted>>(MethodBase.GetCurrentMethod(), changedSince);
    }
    string command = "SELECT * FROM appointmentdeleted WHERE DateTStamp > " + POut.DateT(changedSince);
    return Crud.AppointmentDeletedCrud.SelectMany(command);
}

Code: Select all

public static List<long> GetChangedSinceAptNums(DateTime changedSince) {
    if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) {
        return Meth.GetObject<List<long>>(MethodBase.GetCurrentMethod(), changedSince);
    }
    string command = "SELECT AptNum FROM appointmentdeleted WHERE DateTStamp > " + POut.DateT(changedSince);
    DataTable dt = Db.GetTable(command);
    List<long> aptnums = new List<long>(dt.Rows.Count);
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        aptnums.Add(PIn.Long(dt.Rows[i]["AptNum"].ToString()));
    }
    return aptnums;
}