observerusersignoff.java

provide a room booking system

package Wearnes;

/**
 *
 * @author dongliang.guo
 */
public class ObserverUserSignOff implements ObserverOfRequest{
    
    /** Creates a new instance of ITReceivedObserver */
    ITRequest request;
    ObserverProfile observerProfile;
    public ObserverUserSignOff(ITRequest r,ObserverProfile profile) {
        request=r;
        request.attachObserver(this);
        observerProfile=profile;
        persistObserver(profile);
    }

    public void updateOnRequestStatusChange(String status)
    {
        String content="User:"+request.user_name()+"\r\n";
        content=content+"Request Date:"+request.req_date()+"\r\n";
        content=content+"Expected Completion Date:"+request.expected_completion_date()+"\r\n";
        content=content+"Category:"+request.category()+"\r\n";
        content=content+"Item:"+request.item()+"\r\n";
        content=content+"Description:"+request.description()+"\r\n\n";
        content=content+"Business Impact:"+request.impact()+"\r\n\n";
        java.util.Vector observersProfile=request.observersProfile();
        String req_status=(String)(new RequestStatus()).get(request.process_status());
        
        content=content+"Request Status:"+req_status+"\r\n\n";
        for(int i=0;i<observersProfile.size();i++)
        {
            ObserverProfile observerProfile=(ObserverProfile)observersProfile.get(i);
          content=content+"Name:"+observerProfile.observerName+"\r\n\n Approve Date:"+observerProfile.observerDate+"\r\n\n Approve Status:"+observerProfile.observerApprove+"\r\n\n";
        }
       String engineer=RequestCategory.getDefaultEngineer(request.category()); 
       String engineerEmail=ActiveDirectoryFacility.getEmployeeProfile(engineer,(new CommonUtility()).getActiveDirectoryHost()).email;
           
        if(status.equals(RequestStatus.USER_SIGN_OFF))
        {            
             SendMailBean.send(ITRequest.itServiceEmail, ITRequest.itServiceEmail, engineerEmail, "",
                                    "IT Request",content,  (new CommonUtility()).getEmailHost());
        }
    }
     public  void updateRequestDetail(String sql)
     {
         try
         {
         WearnesDB db=new WearnesDB();
         db.update(sql);
         }catch(Exception e)
         {
         
         }
     }
      public void persistObserver(ObserverProfile profile)
     {
       try{
         String sql="insert into ObserverOfRequest(requestID,process_Status,observerName,observerDate,observerApprovement,observerComment) values("+profile.requestID+",'"+profile.process_status+"','"+profile.observerName+"','"+profile.observerDate+"','"+profile.observerApprove+"','"+profile.observerComment+"')"; 
         String updatesql="update request set process_status='"+profile.process_status+"' where req_id="+profile.requestID;
         WearnesDB db=WearnesDB.getInstance((new CommonUtility()).getConnectionURL());
         db.insert(sql);
         db.update(updatesql);
         }catch(Exception e)
         {
         }
     
     }
}