package com.login.android;

import java.util.ArrayList;




import android.app.Activity;
import android.app.AlertDialog;

import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;

import android.os.Bundle;

import android.util.Log;

import android.view.View;
import android.view.Window;

import android.view.View.OnClickListener;

import android.widget.AdapterView;

import android.widget.AdapterView.OnItemLongClickListener;
import android.widget.ArrayAdapter;

import android.widget.ImageButton;

import android.widget.ListView;

import android.widget.Toast;

public class Books extends Activity{
	
private DataHelper dH;
	long id;
	String Isbn,Name,Author,Edition,Category,Availibility;
    String Price;
    ImageButton AddBook,Back;
    ListView lv;
   
	ArrayList<String> results ;
	
/** Called when the activity is first created. */
    @Override
    
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.books);
        try
        {
        	
        	this.dH = new DataHelper(this);
        	
        	
        }
        catch(Exception e1)
        {
        	e1.printStackTrace();
        	String err1 = e1.toString();
        	System.out.println(err1);
        }
             
        
AddBook= (ImageButton)findViewById(R.id.btnAdd);
 lv=(ListView)findViewById(R.id.list);
 Back= (ImageButton)findViewById(R.id.back21);


	fetchAllBooks();
	
	 System.out.println("fetching");
AddBook.setOnClickListener(new View.OnClickListener() {
			
			public void onClick(View v) {
				// TODO Auto-generated method stub
			AddBook.setBackgroundResource(R.drawable.buttonaddbook1);
				Intent ia=new Intent(Books.this,AddBook.class);
				startActivity(ia);
				
			}
			
		});
  Back.setOnClickListener(new OnClickListener() {
	
	public void onClick(View v) {
		// TODO Auto-generated method stub
		Back.setBackgroundResource(R.drawable.buttonback1);
		Intent ia=new Intent(Books.this,Menu.class);
		startActivity(ia);
		finish();
	}
});
  lv.setOnItemLongClickListener(new OnItemLongClickListener() {

	public boolean onItemLongClick(AdapterView<?> arg0, View arg1, int arg2,
			long arg3) {
		// TODO Auto-generated method stub
		dH.open();
		Cursor c=dH.getAllBooks();
		 if (c != null ) {
		     if  (c.moveToPosition(arg2)) {
		    
		       id = c.getLong(c.getColumnIndexOrThrow(DataHelper.KEY_ROWID));
		              
		                Log.d("Hello",""+id);
		                
		                String str=lv.getItemAtPosition(arg2).toString();
		                
		                for(long i=0;i<400;i++){
		                	if(i==id){
		                		
		                		AlertDialog.Builder  alertDialog = new AlertDialog.Builder(Books.this);
		                		alertDialog.setTitle("Confirm Delete...");
		                		alertDialog.setMessage("Are you sure you want delete " +str);
		                		
		                		alertDialog.setIcon(R.drawable.delete);

		        				// Setting Positive "Yes" Button
		        				alertDialog.setPositiveButton("YES",
		        						new DialogInterface.OnClickListener() {
		        							public void onClick(DialogInterface dialog,int which) {
		        								// Write your code here to execute after dialog
		        								dH.delete_Books(id);
		        								fetchAllBooks();
		        								dH.close();
		        							}
		        						});
		        				// Setting Negative "NO" Button
		        				alertDialog.setNegativeButton("NO",
		        						new DialogInterface.OnClickListener() {
		        							public void onClick(DialogInterface dialog,	int which) {
		        								
		        								
		        								dialog.cancel();
		        							}
		        						});

		        				// Showing Alert Message
		        				alertDialog.show();
		                		
		       
		                		
		                	}
		                	else{
		                		
		                		System.out.println("not"+i);
		                	}
		                        Log.d("long clicked","pos"+" "+str);
		                      
		                	
		          
		          }
		        
		}                                                   
		   
		 }
		 if(c!=null && !c.isClosed()){
		      	c.close();
		      }
		return true;
		
	}
});
  
  
   AddBook.setBackgroundResource(R.drawable.buttonaddbook);
   Back.setBackgroundResource(R.drawable.buttonback);
   dH.close();
    }
   
public Cursor fetchAllBooks() {
	// TODO Auto-generated method stub
	 AddBook.setBackgroundResource(R.drawable.buttonaddbook);
	 dH.open();
	Cursor c=dH.getAllBooks();
	
	 Log.d("Hello",""+c);
	 results = new ArrayList<String>();
	 System.out.println("fetching");
	 
	 if (c != null ) {
     if  (c.moveToFirst()) {
    
       
          do {
                Name = c.getString(2);
                Log.d("Hello",""+Name);
                
            results.add(Name);
            
            AddBook.setBackgroundResource(R.drawable.buttonaddbook);
           }while (c.moveToNext());
          Toast.makeText(getApplicationContext(), " long click on Book to delete",Toast.LENGTH_SHORT).show();
        } 
     
     dH.close();
    if(c!=null && !c.isClosed()){
    	c.close();
    }
   ArrayAdapter<String> aa=new ArrayAdapter<String>(Books.this,android.R.layout.simple_list_item_1,results);
lv.setAdapter(aa);
aa.notifyDataSetChanged();
}
	 c.close();
	return c;
}

}