package com.examples.android.calendar;


import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;


public class DatabaseConnector {

	private static final String DB_NAME = "watchaday";
	private SQLiteDatabase database;
	private DatabaseOpenHelper dbOpenHelper;

	public DatabaseConnector(Context context) {
		dbOpenHelper = new DatabaseOpenHelper(context, DB_NAME, null, 1);
	}

	   public void open() throws SQLException
	   {
	      //open database in reading/writing mode
	      database = dbOpenHelper.getWritableDatabase();
	   }

	   public void close()
	   {
	      if (database != null)
	         database.close();
	   }

	   public void insertContact(String date, String hour_from, String hour_to, String event, String colour)
			   {
			      ContentValues newCon = new ContentValues();
			      newCon.put("date", date);
			      newCon.put("hour_from", hour_from);
			      newCon.put("hour_to", hour_to);
			      newCon.put("event", event);
			      newCon.put("colour", colour);



			      open();
			      database.insert("calendar_events", null, newCon);
			      close();
			   }


			   public void updateContact(long id, String date, String hour_from, String hour_to, String event, String colour)
			   {
			      ContentValues editCon = new ContentValues();
;
			      editCon.put("date", date);
			      editCon.put("hour_from", hour_from);
			      editCon.put("hour_to", hour_to);
			      editCon.put("event", event);
			      editCon.put("colour", colour);


			      open();
			      database.update("calendar_events", editCon, "_id=" + id, null);
			      close();
			   }


			   public Cursor getAllContacts()
			   {
			      return database.query("calendar_events", new String[] {"_id", "event"},
			         null, null, null, null, "date");
			   }

			   public Cursor getOneContact(long id)
			   {
			      return database.query("calendar_events", null, "_id=" + id, null, null, null, null);
			   }

			   public void deleteContact(long id)
			   {
			      open();
			      database.delete("calendar_events", "_id=" + id, null);
			      close();
			   }

			   public Cursor getdate(String data){

				    return database.rawQuery("SELECT event FROM calendar_events WHERE date = '" + data + "'", new String[] { "event"});

				}

}