/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package reportbuilder;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author Administrator
 */
public class sendSMSBuilder {
    
    public static ConnectionIndex connIn ;
    public static void postMessageByConnectionIndex(int index){
        
     try{
        connIn = new ConnectionIndex(); 
        Connection conn=connIn.getConnection(index);
        String RefNo=null,SeqNo=null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {}
        
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("select * from SMSCONFIG where enable_flag=1");
        if(rs.next()) {
            String Sender_code = rs.getString("SENDER_CODE");
            String Sender_number = rs.getString("SENDER_NUMBER");
            String Url = rs.getString("URL");
            String User = rs.getString("USER_NAME");
            String Password = rs.getString("USER_PWD");
            rs = stmt.executeQuery("select * from SMSTRANSACTION where post_flag=0 order by REF_NO asc,seq_no asc");
            while(rs.next()) {
              RefNo=rs.getString("Ref_No");
              SeqNo=rs.getString("seq_no");
              String Msn=rs.getString("TELEPHONE_NUMBER");
              String text=rs.getString("MESSAGE_TEXT");
              String response=SendSMS.send(Url, RefNo, User, Password, Sender_code, Msn, text);
              String sqlUpdate="update SMSTRANSACTION set message_status=" + (response.toLowerCase().indexOf("success") >= 0 ? 1 : -1) + ",send_status_msg='"+response+"',post_flag=1,send_date=sysdate where REF_NO='" + RefNo + "' and seq_no='" + SeqNo + "'";
              conn.createStatement().execute(sqlUpdate);
              conn.commit();
            }
        }
        if(connIn!=null)connIn.CloseAll(); 
     }catch(Exception es){
       es.printStackTrace();       
     }
     finally{
        
     }
    }
}