Package com.nykredit.kundeservice.data.sql

Examples of com.nykredit.kundeservice.data.sql.SqlQuery

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    String sql = "SELECT " +
               "* " +
           "FROM " +
               "KS_DRIFT.WEBDESK_DEPARTMENT";

    SqlQuery query = new SqlQuery(conn, sql);

    try {
      query.execute();
     
      while(query.next())
        departments.add(new WebdeskDepartment(query.getInteger("ID"), query.getString("DEPARTMENT")));
    } catch (DopeException e) {
      throw new OperationAbortedException(e, "Error during load of webdesk departments.", "Der skete en fejl ved indl�sning af webdesk departments.");
    }

    return departments;
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
              "DATETIME BETWEEN " + OracleFormats.convertDateTime(dateFrom) + " AND " + OracleFormats.convertDateTime(dateTo) + " " +
           "GROUP BY " +
              "TO_CHAR(DATETIME, 'YYYY'), " +
              "TO_CHAR(DATETIME, '" + period.format + "')";
   
    SqlQuery query = new SqlQuery(conn, sql);
   
    try {
      query.execute();
     
      while(query.next()){       
        webdeskCalls.add(new WebdeskCallSumary(query.getDateTime("PERIOD_MIN_DATE"),
                             query.getInteger("CALLS"),
                             query.getInteger("ANSWERED"),
                             query.getInteger("ANSWERED_WITHIN_30_SEC"),
                             query.getInteger("FORWARDED_TO_DIREKTE")));       
      }
    } catch (DopeException e) {
      throw new OperationAbortedException(e, "Error during load of webdesk calls.", "Der skete en fejl ved indl�sning af webdesk kald.");
    }
   
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
    String sql = "SELECT " +
               "* " +
           "FROM " +
               "KS_DRIFT.WEBDESK_CAMPAIGN";
   
    SqlQuery query = new SqlQuery(conn, sql);
   
    try {
      query.execute();
     
      while(query.next())
        campaigns.add(new WebdeskCampaign(query.getInteger("ID"), query.getString("CAMPAIGN")));
    } catch (DopeException e) {
      throw new OperationAbortedException(e, "Error during load of webdesk campaigns.", "Der skete en fejl ved indl�sning af webdesk campaigns.");
    }
 
    return campaigns;
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
  }
 
  public void LoadKundeserviceBusinessDates(KSDriftConnection conn) throws OperationAbortedException {
    this.kundeserviceOpenDates = new ArrayList<LocalDate>();
       
    SqlQuery query = new SqlQuery(conn,
                      "SELECT " +
                          "THIS_DATE " +
                      "FROM " +
                          "SYS_DATE_KS " +
                      "WHERE " +
                          "THIS_DATE >= " + OracleFormats.convertDate(this.startOfCalendar.toDate()) + " AND " +
                          "THIS_DATE <=" + OracleFormats.convertDate(this.endOfCalendar.toDate()));
   
    try{
      query.execute();
     
      while (query.next()){
        this.kundeserviceOpenDates.add(new LocalDate(query.getDate("THIS_DATE").toString()));
      }
    } catch (DopeException e) {
      throw new OperationAbortedException(e, "Error occured while loading data from SYS_DATE", "Der skete en fejl ved indl�sning af �bningsdage i kundeservice.");
    }
   
View Full Code Here
TOP

Related Classes of com.nykredit.kundeservice.data.sql.SqlQuery

  • com.nykredit.kundeservice.swing.components.CalendarPanel
  • com.nykredit.kundeservice.util.TimeOfDay
  • dataTypes.WebdeskCallSumary
  • dataTypes.WebdeskCampaign
  • dataTypes.WebdeskDepartment
  • org.joda.time.DateTime
  • java.util.Calendar
  • java.util.Date
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.