package emp.management;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import android.util.Log;
public class EmployEdit extends Activity
{
EditText editEmpName,
editCompanyName,
editEmpPost;
Button btnSubmit;
DatePicker DOB;
TextView errorMsg;
int day,
month,
year;
String empName,
companyName,
empPost, DOBDate;
//DataBase Variable Declaration
private static String DBEmpName="empName",
DBCompanyName="companyName",
DBPost="post",
DBDate="DOB";
String EMP_TABLE_CREATE;
private static final String TAG = "EmployEdit";
DbHelper myDB = new DbHelper(EmployEdit.this);
public void setEmpName(String empName)
{
this.empName = empName;
}
public String getEmpName()
{
return empName;
}
public void setCompanyName(String companyName)
{
this.companyName = companyName;
}
public String getCompanyName()
{
return companyName;
}
public void setEmpPost(String empPost)
{
this.empPost = empPost;
}
public String getEmpPost()
{
return empPost;
}
public void setDOBDate(String DOBDate)
{
this.DOBDate=DOBDate;
}
public String getDOBDate()
{
return DOBDate;
}
public void onCreate(Bundle savedInstanceState)
{
try{
super.onCreate(savedInstanceState);
setContentView(R.layout.empinformation);
editEmpName = (EditText)findViewById(R.id.EditEmpName);
editCompanyName = (EditText)findViewById(R.id.EditComnpanyName);
editEmpPost = (EditText)findViewById(R.id.EditEmpPost);
DOB = (DatePicker)findViewById(R.id.EditEmpDOB);
btnSubmit = (Button)findViewById(R.id.btnSubmitEmp);
btnSubmit.setOnClickListener(new OnClickListener()
{
@Override
public void onClick(View arg0)
{
day = DOB.getDayOfMonth();
month = DOB.getMonth();
year = DOB.getYear();
DOBDate = year+"/"+month+"/"+day;
empName = editEmpName.getText().toString();
companyName = editCompanyName.getText().toString();
empPost = editEmpPost.getText().toString();
if(empName.equals(""))
{
InValid=true;
Toast.makeText(getApplicationContext(), "Employ Name Missing", Toast.LENGTH_LONG).show();
}
else if(companyName.equals(""))
{
InValid=true;
Toast.makeText(getApplicationContext(), "Comapny Name Missing",Toast.LENGTH_LONG).show();
}
else if(empPost.equals(""))
{
InValid=true;
Toast.makeText(getApplicationContext(), "Employ post Missing", Toast.LENGTH_LONG).show();
}
if(InValid==false)
{
addEntry(empName,companyName,empPost,DOBDate);
}
}
});
}
catch(Exception e)
{
e.printStackTrace();
Log.e(TAG, "Line 169", e);
}
}
private void addEntry(String empName2, String companyName2, String empPost2, String dOBDate2)
{
// TODO Auto-generated method stub
SQLiteDatabase db = myDB.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("EmployeeName",empName2);
values.put("EmpCompanyName",companyName2);
values.put("EmpPost", empPost2);
values.put("EmpDOB", dOBDate2);
/*values.put("EmployeeName",getEmpName());
values.put("EmpCompanyName",getCompanyName());
values.put("EmpPost", getEmpPost());
values.put("EmpDOB", getDOBDate());*/
try{
db.insertOrThrow(DbHelper.DATABASE_TABLE_NAME_EMP_INFO, null, values);
Toast.makeText(getApplicationContext(), "successfully Inserted", Toast.LENGTH_LONG).show();
}
catch(SQLiteException e)
{
e.printStackTrace();
Log.e(TAG, "Line Number:-229 ", e);
}
catch(Exception e1)
{
e1.printStackTrace();
Log.e(TAG,"Line number:-234",e1);
}
}
public void onDestroy(SQLiteDatabase db)
{
super.onDestroy();
db.close();
finish();
}
}
import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import android.util.Log;
public class EmployEdit extends Activity
{
EditText editEmpName,
editCompanyName,
editEmpPost;
Button btnSubmit;
DatePicker DOB;
TextView errorMsg;
int day,
month,
year;
String empName,
companyName,
empPost, DOBDate;
//DataBase Variable Declaration
private static String DBEmpName="empName",
DBCompanyName="companyName",
DBPost="post",
DBDate="DOB";
String EMP_TABLE_CREATE;
private static final String TAG = "EmployEdit";
DbHelper myDB = new DbHelper(EmployEdit.this);
public void setEmpName(String empName)
{
this.empName = empName;
}
public String getEmpName()
{
return empName;
}
public void setCompanyName(String companyName)
{
this.companyName = companyName;
}
public String getCompanyName()
{
return companyName;
}
public void setEmpPost(String empPost)
{
this.empPost = empPost;
}
public String getEmpPost()
{
return empPost;
}
public void setDOBDate(String DOBDate)
{
this.DOBDate=DOBDate;
}
public String getDOBDate()
{
return DOBDate;
}
public void onCreate(Bundle savedInstanceState)
{
try{
super.onCreate(savedInstanceState);
setContentView(R.layout.empinformation);
editEmpName = (EditText)findViewById(R.id.EditEmpName);
editCompanyName = (EditText)findViewById(R.id.EditComnpanyName);
editEmpPost = (EditText)findViewById(R.id.EditEmpPost);
DOB = (DatePicker)findViewById(R.id.EditEmpDOB);
btnSubmit = (Button)findViewById(R.id.btnSubmitEmp);
btnSubmit.setOnClickListener(new OnClickListener()
{
@Override
public void onClick(View arg0)
{
day = DOB.getDayOfMonth();
month = DOB.getMonth();
year = DOB.getYear();
DOBDate = year+"/"+month+"/"+day;
empName = editEmpName.getText().toString();
companyName = editCompanyName.getText().toString();
empPost = editEmpPost.getText().toString();
if(empName.equals(""))
{
InValid=true;
Toast.makeText(getApplicationContext(), "Employ Name Missing", Toast.LENGTH_LONG).show();
}
else if(companyName.equals(""))
{
InValid=true;
Toast.makeText(getApplicationContext(), "Comapny Name Missing",Toast.LENGTH_LONG).show();
}
else if(empPost.equals(""))
{
InValid=true;
Toast.makeText(getApplicationContext(), "Employ post Missing", Toast.LENGTH_LONG).show();
}
if(InValid==false)
{
addEntry(empName,companyName,empPost,DOBDate);
}
}
});
}
catch(Exception e)
{
e.printStackTrace();
Log.e(TAG, "Line 169", e);
}
}
private void addEntry(String empName2, String companyName2, String empPost2, String dOBDate2)
{
// TODO Auto-generated method stub
SQLiteDatabase db = myDB.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("EmployeeName",empName2);
values.put("EmpCompanyName",companyName2);
values.put("EmpPost", empPost2);
values.put("EmpDOB", dOBDate2);
/*values.put("EmployeeName",getEmpName());
values.put("EmpCompanyName",getCompanyName());
values.put("EmpPost", getEmpPost());
values.put("EmpDOB", getDOBDate());*/
try{
db.insertOrThrow(DbHelper.DATABASE_TABLE_NAME_EMP_INFO, null, values);
Toast.makeText(getApplicationContext(), "successfully Inserted", Toast.LENGTH_LONG).show();
}
catch(SQLiteException e)
{
e.printStackTrace();
Log.e(TAG, "Line Number:-229 ", e);
}
catch(Exception e1)
{
e1.printStackTrace();
Log.e(TAG,"Line number:-234",e1);
}
}
public void onDestroy(SQLiteDatabase db)
{
super.onDestroy();
db.close();
finish();
}
}