OpenDentBusiness AppointmentDeleteds request

This forum is for programmers who have questions about the source code.
Post Reply
User avatar
tim
Posts: 24
Joined: Wed Mar 08, 2017 5:11 am

OpenDentBusiness AppointmentDeleteds request

Post by tim » Mon Apr 24, 2017 10:17 am

Hi,

Could the following method be added to the OpenDentBusiness.AppointmentDeleteds class:

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);
}
Thanks.

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: OpenDentBusiness AppointmentDeleteds request

Post by jsalmon » Mon Apr 24, 2017 11:57 am

We can add that method for you.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
tim
Posts: 24
Joined: Wed Mar 08, 2017 5:11 am

Re: OpenDentBusiness AppointmentDeleteds request

Post by tim » Tue Apr 25, 2017 4:48 am

jsalmon wrote:We can add that method for you.
Great! Could the following method also be added:

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;
}
Thanks again.

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: OpenDentBusiness AppointmentDeleteds request

Post by cmcgehee » Tue Apr 25, 2017 7:52 am

Sure, we'll include that one too.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: OpenDentBusiness AppointmentDeleteds request

Post by cmcgehee » Tue Apr 25, 2017 11:29 am

I added these two methods to the head and to 17.1.8. I did modify them and renamed one so that they matched our patterns a little better.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
tim
Posts: 24
Joined: Wed Mar 08, 2017 5:11 am

Re: OpenDentBusiness AppointmentDeleteds request

Post by tim » Tue Apr 25, 2017 11:36 am

cmcgehee wrote:I added these two methods to the head and to 17.1.8. I did modify them and renamed one so that they matched our patterns a little better.
Thanks for the quick reply, Chris.

Is it possible for this request to be added as well? It looks like it may have been forgotten.

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: OpenDentBusiness AppointmentDeleteds request

Post by cmcgehee » Tue Apr 25, 2017 11:54 am

Oh sure. I should be able to add that, too.
Chris McGehee
Open Dental Software
http://www.opendental.com

Post Reply