parish_common.c

/*Implements functions which are common to all forms in the application*/
/*  Copyright (C) 2009  Arun S.A.G.

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>. */

#include "parish_common.h"
/*Utility functions*/
/*Checks form is empty or not*/
gboolean is_form_valid(struct baptism_cert *cert)
{
  if(g_strcmp0(cert->kept_at,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->place,"")==0)
    {
      return FALSE;
    }
  else if(cert->dobap_date == NULL)
    {
      return FALSE;
    }
  else if(cert->dobap_month== NULL)
    {
      return FALSE;
    }
  else if(cert->dobap_year == NULL)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->name,"")==0)
    {
      return FALSE;
    }
  else if(cert->dob_date == NULL)
    {
      return FALSE;
    }
  else if(cert->dob_month == NULL)
    {
      return FALSE;
    }
  else if(cert->dob_year == NULL)
    {
      return FALSE;
    }
  else if(cert->sex == NULL)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->mom,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->dad,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->resi,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->caste,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->spon1,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->spon2,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->priest,"")==0)
    {
      return FALSE;
    }
  else if(g_strcmp0(cert->remarks,"")==0)
    {
      return FALSE;
    }
  else
  return TRUE;
  
}

/*Displays a Message box*/
void quick_message (gchar *message) 
{
   	GtkWidget *dialog, *label, *content_area,*parent;
	parent =(GtkWidget *)gtk_builder_get_object(build,"window");
   /* Create the widgets */
	dialog = (GtkWidget *)gtk_dialog_new_with_buttons ("Message",
					 (GtkWindow *)parent,
                                         GTK_DIALOG_MODAL,
                                         GTK_STOCK_OK,
                                         GTK_RESPONSE_OK,
                                         NULL);
   	content_area = gtk_dialog_get_content_area (GTK_DIALOG (dialog));
   	label = gtk_label_new (message);
   	/* Ensure that the dialog box is destroyed when the user responds. */
   	g_signal_connect_swapped (dialog,"response",G_CALLBACK (gtk_widget_destroy),dialog);
   	/* Add the label, and show everything we've added to the dialog. */
   	gtk_container_add (GTK_CONTAINER (content_area), label);
  	gtk_widget_show_all (dialog);
}


/*Adds text from liststores  to combo box's in the application*/
void add_text_combobox()
{
	GtkCellRenderer *cell;
	GtkComboBox *cbox;
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_baptism_sex"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_baptism_dob_date"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_baptism_dob_month"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_baptism_dob_year"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_baptism_dobap_date"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_baptism_dobap_month"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_baptism_dobap_year"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
	cbox = (GtkComboBox *)(gtk_builder_get_object(build,"search_main_searchby_combobox"));
	cell = gtk_cell_renderer_text_new();
	gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
	gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_date"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_month"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_year"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_bride_dob_date"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_bride_dob_month"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_bride_dob_year"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_groom_dob_date"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_groom_dob_month"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);
        cbox = (GtkComboBox *)(gtk_builder_get_object(build,"window_marriage_groom_dob_year"));
        cell = gtk_cell_renderer_text_new();
        gtk_cell_layout_pack_start(GTK_CELL_LAYOUT(cbox),cell,TRUE);
        gtk_cell_layout_add_attribute(GTK_CELL_LAYOUT(cbox),cell,"text",0);

}

/*Prepates date information to store it in db*/
void prepare_date(gchar *date,gchar *month,gchar *year,gchar *date_dob)
{
  g_strlcpy(date_dob,date,10);
  g_strlcat(date_dob,"/",10);
  g_strlcat(date_dob,month,10);
  g_strlcat(date_dob,"/",10);
  g_strlcat(date_dob,year,10);
}

/* Creates displayable search results*/
void prepare_results(GString *result,int cols,int radio)
{
  int retval,i;
  retval = sqlite3_step(stmt);
  //gchar col_name[25];
  //gchar col_name_db[25];
  GString *tmp;
  tmp =g_string_new("");
  if(retval == SQLITE_ROW)
    {
      //g_string_append_printf(result,"%s","*******************************************");
      //g_string_append_printf(result,"%s\n","*******************************************");

      /* i starts from 1 as uid is in first column of the table*/
      g_print("%d",cols);
      for(i=1;i<cols;i++)
	{
	  // g_strlcpy(col_name_db,sqlite3_column_name(stmt,i),25);
	  get_column_name(i,tmp,radio);  
	  g_string_append_printf(result,"%s",tmp->str);
	  g_string_append_printf(result,"%-30s",(gchar *)sqlite3_column_text(stmt,i));
	  g_string_printf(tmp,"%s","");
	  
	}
      //g_string_append_printf(result,"\n%s","*******************************************");
      //g_string_append_printf(result,"%s\n","*******************************************");

    }
  else
    {
      g_string_append_printf(result,"%s","End of search");
    }
  g_string_free(tmp,TRUE);
}


/* Creates printable column name for search results window*/
void get_column_name(int i,GString *col_name,int table)
{
  if(table==0)
    {
      switch(i)
	{	    
	case 1:  
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Kept At      ");
	  break;
	case 2:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Place        ");
	  break;
	case 3:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Date         ");
	  break;
	case 4: 
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Name         ");
	  break;
	case 5:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Date of birth");
	  break;
	case 6:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Sex          ");
	  break;
	case 7:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Mother's Name");
	  break;
	case 8:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Father's Name");
	  break;
	case 9:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Residence    ");
	  break;
	case 10:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Caste        ");
	  break;
	case 11:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Sponsor 1    ");
	  break;
	case 12:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Sponsor 2    ");
	  break;
	case 13:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Priest       ");
	  break;
	case 14:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t\t\t%s\t\t\t","Remarks      ");
	  break;
	}
    }
  else if(table==1)
    {
      switch(i)
	{
	case 1:
	   append_line(col_name);
	   g_string_append_printf(col_name,"\n\t%s\t","Date of Marriage   ");
	   break;
	case 2:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%-18s\t%-28s\t%s","Parties","Groom","Bride");
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Name               ");
	  break;
	case 3:
	  break;
	case 4:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Date of birth      ");
	  break;
	case 5:
	  break;
	case 6:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","condition          ");
	  break;
	case 7:
	  break;
	case 8:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Rank of profession ");
	  break;
	case 9:
	  break;
	case 10:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Father name's      ");
	  break;
	case 11:
	  break;
	case 12:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Door no and street");
	  break;
	case 13:
	  break;
	case 14:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Village           ");
	  break;
	case 15:
	  break;
	case 16:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","District          ");
	  break;
	case 17:
	  break;
	case 18:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","PIN               ");
	  break;
	case 19:
	  break;
	case 20:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Witness name      ");
	  break;
	case 21:
	  break;
	case 22:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Door no and street");
	  break;
	case 23:
	  break;
	case 24:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","village           ");
	  break;
	case 25:
	  break;
	case 26:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","District          ");
	  break;
	case 27:
	  break;
	case 28:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","PIN              ");
	  break;
	case 29:
	  break;
	case 30:
	  append_line(col_name);
	  g_string_append_printf(col_name,"\n\t%s\t","Minister's Name  ");
	  break;	  
	}
      
    }

}

void append_line(GString *result)
{

     g_string_append_printf(result,"\n%s","------------------------------------------");
     g_string_append_printf(result,"%s","-------------------------------------------------------------------------");


}