Importing from oracle database validation check

Question

I am trying to check if I have already imported data inside my database but I am finding difficulties to do this. Below is my code which I am using in backend, middle layer and front end. Can anyone please check to see what I am doing wrong. Thanks alot for your help.

Mike

This is the backend code

public static Boolean isImported(string date)
    {
        DatabaseAdapter dba = DatabaseAdapter.GetInstance();
        string sqlQuery = "SELECT * FROM FCR.LOAD_CONTROL " +
                          "WHERE LOAD_DATE = to_date('" + date + "', 'dd/mm/yyyy') ";

        DataTable dt = new DataTable();
        dt.Load(dba.QueryDatabase(sqlQuery));

        if (dt.Rows.Count > 0)

        {
            return true;
        }
        else
        {
            return false;
        }
    }

This is the business logic code

public static Boolean isImported(string date)

    {
        return DatabaseHandler.isImported(date);
    }

This is the front end code

if(BusinessLayerHandler.isImported(dateField.Text) == false)

            {
                try

                {
                    BusinessLayerHandler.ImportFromOrion(dateField.Text);
                    Alert("Imported");
                }
                catch (Exception ex)
                {
                    Alert("Not Imported");
                }
            }

i was able to import before adding the code: if (dt.Rows.Count > 0) to check if data is already imported. — mikespiteri
– mikespiteri, Commented Aug 12, 2011 at 6:55

Kevin Burton · Accepted Answer · 2011-08-12 08:19:37Z

3

Does your load date contain time ?....if it does you need to truncate your load date to remove it: TRUNC(LOAD_DATE)

answered Aug 12, 2011 at 8:19

Kevin Burton

12k2 gold badges26 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing from oracle database validation check

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related