dboperations

public class MainActivity extends Activity implements OnClickListener {
DataBase db;

SQLiteDatabase sDb;
Button btn,vi;
EditText e1,e2,e3;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

db=new DataBase(getApplicationContext());

e1=(EditText)findViewById(R.id.editText1);
e2=(EditText)findViewById(R.id.editText2);
e3=(EditText)findViewById(R.id.editText3);

btn=(Button)findViewById(R.id.button1);
vi=(Button)findViewById(R.id.button2);
btn.setOnClickListener(this);
vi.setOnClickListener(this);



}
@Override
public void onClick(View v) {

switch(v.getId()){
case R.id.button1:
String id=e1.getText().toString();
String nm=e2.getText().toString();
String ad=e3.getText().toString();

sDb = db.getWritableDatabase();
db.insertValues(id,nm,ad,sDb);
db.close();

break;
case R.id.button2:

sDb = db.getWritableDatabase();
ArrayList<dbModel> values = db.getValues(sDb);

for(int i=0;i<values.size();i++)
{
Log.e("ss",""+values.get(i).name);
}
db.close();


break;
}


......................................................................................................
public class DataBase extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "RajaDaTa";
public static final int DB_VER = 1;
public static final String Create_Table = "create table Rajasekhar(id text,name text,address text)";

SQLiteDatabase db;
Context context;

public DataBase(Context context) {

super(context, DATABASE_NAME, null, DB_VER);

}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(Create_Table);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub

}



public void insertValues(String id, String nm, String ad, SQLiteDatabase db) {
ContentValues cv = new ContentValues();
cv.put("id", id);
cv.put("name", nm);
cv.put("address", ad);

try {
long v = db.insert("Rajasekhar", null, cv);

if (v == 1)
Log.e("inserted", "inserted");
} catch (SQLiteException e) {
e.printStackTrace();
}
}

public ArrayList<dbModel> getValues(SQLiteDatabase db) {
// TODO Auto-generated method stub

ArrayList<dbModel> arr = new ArrayList<dbModel>();
try {
Cursor cr = db.rawQuery("select * from Rajasekhar", null);

if(cr !=null)
{
if(cr.getCount()>0)
{
Log.e("c", ""+cr.getCount());

while (cr.moveToNext()) {
dbModel d = new dbModel();
d.name = cr.getString(1);
Log.e("Name", ""+cr.getString(1));
}
}
}

} catch (SQLiteException e) {
e.printStackTrace();
}


return arr;
}



}

completereference

cardsupdateactivity
setContentView(R.layout.cards_update_screen);

SharedPreferences sp = getSharedPreferences("prefs", 0);
id = sp.getString("id", "name not found");
CardModel cardmodel = new CardModel();
DatabaseHelper db = new DatabaseHelper(getApplicationContext());
cardmodel = db.getselectedvalues(id);

mEtCardno = (EditText) findViewById(R.id.update_add_card_ET_card_no);
mEtBankName = (EditText) findViewById(R.id.update_add_card_ET_bankname);
mEtCvvno = (EditText) findViewById(R.id.update_add_card_ET_cvv_no);
mEtPin = (EditText) findViewById(R.id.update_add_card_ET_pin_no);

mEtValidFrom = (Button) findViewById(R.id.update_add_card_ET_validFrom);
mEtValidTo = (Button) findViewById(R.id.update_add_card_ET_validTo);

Btn_update = (Button) findViewById(R.id.Btn_update);
Btncancel = (Button) findViewById(R.id.Btncancel);
Btn_update.setOnClickListener(this);
Btncancel.setOnClickListener(this);


mEtCardno.setText(cardmodel.getCardNumber());
mEtBankName.setText(cardmodel.getBankName());
mEtCvvno.setText(cardmodel.getCvvNumber());
mEtPin.setText(cardmodel.getPinNumber());
mEtValidFrom.setText(cardmodel.getValidFrom());
mEtValidTo.setText(cardmodel.getValidTo());



}

@Override
public void onClick(View v) {
switch(v.getId()){
case R.id.Btn_update:
DatabaseHelper db=new DatabaseHelper(getApplicationContext());

mEtCardno = (EditText) findViewById(R.id.update_add_card_ET_card_no);
mEtBankName = (EditText) findViewById(R.id.update_add_card_ET_bankname);
mEtCvvno = (EditText) findViewById(R.id.update_add_card_ET_cvv_no);
mEtPin = (EditText) findViewById(R.id.update_add_card_ET_pin_no);
/*mEtValidFrom = (EditText) findViewById(R.id.update_add_card_ET_validFrom);
mEtValidTo = (EditText) findViewById(R.id.update_add_card_ET_validTo);*/

String CardNumber = mEtCardno.getText().toString();
String bankname = mEtBankName.getText().toString();
String cvvno = mEtCvvno.getText().toString();
String pinno = mEtPin.getText().toString();
String validfrm = mEtValidFrom.getText().toString();
String validto = mEtValidTo.getText().toString();

db.updaterecord(id, CardNumber,bankname,cvvno,pinno,validfrm,validto);
Intent intent = new Intent();
setResult(RESULT_OK, intent);
finish();
break;

case R.id.Btncancel:

finish();
break;

}
}

}




'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
cardmodel
public class CardModel implements Serializable{

private String CardNumber;
private String BankName;
private String PinNumber;
private String CvvNumber;
private String ValidFrom;
private String ValidTo;
private String Id;
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
addactivity
public class CardAddDetailsActivity extends Activity implements OnClickListener {

private EditText mETCardno, mETBankname, mETPin, mETCvv;
private Button mBtnSave, mBtnCancel;
private Button  mBtnVailedFrom, mBtnVailedTo;
private int calendarDay, calendarMonth, calendarYear;
private Calendar calendar = Calendar.getInstance();

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);

requestWindowFeature(Window.FEATURE_NO_TITLE);
setContentView(R.layout.card_add_details_screen);

initUI();


}


private void initUI() {

mETCardno = (EditText) findViewById(R.id.add_card_ET_card_no);
mETBankname = (EditText) findViewById(R.id.add_card_ET_bankname);
mETPin = (EditText) findViewById(R.id.add_card_ET_pin_no);
mETCvv = (EditText) findViewById(R.id.add_card_ET_cvv_no);
/*mETVailedFrom = (EditText) findViewById(R.id.add_card_Btn_validFrom);
mETVailedTo = (EditText) findViewById(R.id.add_card_Btn_validTo);*/

mBtnVailedFrom = (Button) findViewById(R.id.add_card_Btn_validFrom);
mBtnVailedTo = (Button) findViewById(R.id.add_card_Btn_validTo);

mBtnSave = (Button) findViewById(R.id.Btn_Save);
mBtnCancel = (Button) findViewById(R.id.add_card_Btn_cancel);

mBtnSave.setOnClickListener(this);
mBtnCancel.setOnClickListener(this);
mBtnVailedFrom.setOnClickListener(this);
mBtnVailedTo.setOnClickListener(this);


}



@Override
public void onClick(View v) {
switch (v.getId()) {

case R.id.Btn_Save:

String Cardno = mETCardno.getText().toString();
String Bankname = mETBankname.getText().toString();
String pinno = mETPin.getText().toString();
String Cvvno = mETCvv.getText().toString();
String validfrom = mBtnVailedFrom.getText().toString();
String validto = mBtnVailedTo.getText().toString();

if(Cardno.equals("")&&Bankname.equals("")&&pinno.equals("")&&validfrom.equals("")&&validto.equals

("")){
Toast.makeText(getApplicationContext(),
"Please Enter Card Details", Toast.LENGTH_SHORT).show();

}else
if(Cardno.equalsIgnoreCase("")){
Toast.makeText(getApplicationContext(),
"Please Enter Card Number", Toast.LENGTH_SHORT).show();

}

else if(Bankname.equalsIgnoreCase("")){
Toast.makeText(getApplicationContext(),
"Please Enter Bankname", Toast.LENGTH_SHORT).show();

}
else if(pinno.equalsIgnoreCase("")){
Toast.makeText(getApplicationContext(),
"Please Enter pin Number", Toast.LENGTH_SHORT).show();

}
else if(Cvvno.equalsIgnoreCase("")){
Toast.makeText(getApplicationContext(),
"Please EnterCvvno Number", Toast.LENGTH_SHORT).show();

}
else if(validfrom.equalsIgnoreCase("")){
Toast.makeText(getApplicationContext(),
"Please Enter validfromDate Number", Toast.LENGTH_SHORT).show();

}
else if(validto.equalsIgnoreCase("")){
Toast.makeText(getApplicationContext(),
"Please Enter validtoDate Number", Toast.LENGTH_SHORT).show();

}
else{


DatabaseHelper dbSample = new DatabaseHelper(getApplicationContext());

dbSample.addCardDetails(Cardno, Bankname, pinno, Cvvno, validfrom, validto);
Toast.makeText(getApplicationContext(), "Card details Added successfully",

Toast.LENGTH_SHORT).show();

Intent intent = new Intent();
setResult(RESULT_OK, intent);
finish();

}
break;

case R.id.add_card_Btn_cancel:


finish();

break;

case R.id.add_card_Btn_validFrom:

new DatePickerDialog(CardAddDetailsActivity.this, d, calendar.get(Calendar.YEAR), calendar.get

(Calendar.MONTH),
calendar.get(Calendar.DAY_OF_MONTH)).show();

break;

case R.id.add_card_Btn_validTo:

new DatePickerDialog(CardAddDetailsActivity.this, dd, calendar.get(Calendar.YEAR), calendar.get

(Calendar.MONTH),
calendar.get(Calendar.DAY_OF_MONTH)).show();

break;

}
}

final DatePickerDialog.OnDateSetListener d = new OnDateSetListener() {

@Override
public void onDateSet(DatePicker view, int year, int monthOfYear,
int dayOfMonth) {

calendarDay = dayOfMonth;
calendarMonth = monthOfYear + 1;
calendarYear = year;
mBtnVailedFrom.setText(" " + calendarDay + "/" + calendarMonth + "/" + calendarYear);
}
};


final DatePickerDialog.OnDateSetListener dd = new OnDateSetListener() {

@Override
public void onDateSet(DatePicker view, int year, int monthOfYear,int dayOfMonth) {

calendarDay = dayOfMonth;
calendarMonth = monthOfYear + 1;
calendarYear = year;
mBtnVailedTo.setText(" " + calendarDay + "/" + calendarMonth + "/"+ calendarYear);
}
};
}

.................................................................................................
viewActivyy

public class CardViewDetailActivity extends Activity {
private ImageView mBtnBack;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
requestWindowFeature(Window.FEATURE_NO_TITLE);
setContentView(R.layout.card_view_details_screen);

mBtnBack = (ImageView) findViewById(R.id.btn_AddCarddetails1_back);
backCard();

Intent intent = getIntent();
CardModel cardModel = (CardModel) intent.getSerializableExtra("data");

TextView tv = (TextView) findViewById(R.id.tv_cardno);
TextView tv1 = (TextView) findViewById(R.id.tv_bankname);
TextView tv2 = (TextView) findViewById(R.id.tv_pinno);
TextView tv3 = (TextView) findViewById(R.id.tv_cvvno);
TextView tv4 = (TextView) findViewById(R.id.tv_validfrm);
TextView tv5 = (TextView) findViewById(R.id.tv_validto);

tv.setText("CardNumber:"+cardModel.getCardNumber());
tv1.setText("BankName:"+cardModel.getBankName());
tv2.setText("CvvNumber:"+cardModel.getCvvNumber());
tv3.setText("PinNumber:"+cardModel.getPinNumber());
tv4.setText("ValidFrom:"+cardModel.getValidFrom());
tv5.setText("ValidTo:"+cardModel.getValidTo());

}

public void backCard(){

mBtnBack.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {

finish();

}
});
}
...............................................................................
CardlistActvity:
public class CardListActivity extends Activity {

private ImageView mBtnAdd,mBtnBack;
private DatabaseHelper db;
private final Context context = this;
private String PREFS = "prefs";
private SharedPreferences sharedPreferences;
private ListView listview;
private ArrayList<CardModel> carddata;
private LayoutInflater inflater;
private CustomAdapter customAdapter;

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
this.requestWindowFeature(Window.FEATURE_NO_TITLE);

setContentView(R.layout.card_list_screen);
initUI();

}

public void initUI() {

db = new DatabaseHelper(CardListActivity.this);

mBtnAdd = (ImageView) findViewById(R.id.btn_AddCarddetails);
mBtnBack = (ImageView) findViewById(R.id.btn_AddCarddetails1_back);
listview = (ListView) findViewById(R.id.list_AddCardDetails);

carddata = new ArrayList<CardModel>();
carddata = db.getValues();
customAdapter = new CustomAdapter(carddata);
inflater = getLayoutInflater();

listview.setAdapter(customAdapter);
listview.setLongClickable(true);

listview.setOnItemClickListener(new AdapterView.OnItemClickListener() {

@Override
public void onItemClick(AdapterView<?> parent, View view,int position, long id) {

Intent intent = new Intent(CardListActivity.this,CardViewDetailActivity.class);
intent.putExtra("data", carddata.get(position));
startActivity(intent);

}

});

listview.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {

public boolean onItemLongClick(AdapterView<?> parent,
final View view, int position, long id) {

doOnLongPress(view);
return false;
}

});

autocompletetxt();
addCard();
backCard();

}

public void addCard(){

mBtnAdd.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {

Intent intent=new Intent(CardListActivity.this,CardAddDetailsActivity.class);
           startActivityForResult(intent, 2);

}
});
}


public void backCard(){

mBtnBack.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {

finish();

}
});
}

public void autocompletetxt() {


db = new DatabaseHelper(getApplicationContext());
String[] auto = db.getarraycardnumbr();
final AutoCompleteTextView autotext = (AutoCompleteTextView) findViewById(R.id.autoCompleteTextView1);
ArrayAdapter<String> adapter = new ArrayAdapter<String>(getApplicationContext(), R.layout.text, auto);
autotext.setAdapter(adapter);
autotext.setOnItemClickListener(new OnItemClickListener() {

@Override
public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
long arg3) {
// Toast.makeText(getApplicationContext(), "hhh", Toast.LENGTH_LONG).show();
db = new DatabaseHelper(getApplicationContext());
carddata = db.getautocarddtails(autotext.getText().toString());
CustomAdapter ca = new CustomAdapter(carddata);
listview.setAdapter(ca);

}
});
}

private void doOnLongPress(final View view){

AlertDialog.Builder alertdialog = new AlertDialog.Builder(context);
alertdialog.setTitle("Grapple");
alertdialog.setMessage("Please Select Your Choice");
alertdialog.setPositiveButton("Update",
new DialogInterface.OnClickListener() {

@Override
public void onClick(DialogInterface dialog,int which) {

String ctn = ((TextView) view.findViewById(R.id.ctextView1)).getText

().toString();
sharedPreferences = getSharedPreferences(PREFS, 0);
SharedPreferences.Editor editor = sharedPreferences.edit();
editor.putString("id", ctn);
editor.commit();

Intent intent=new Intent(CardListActivity.this,CardsUpdate.class);
           startActivityForResult(intent, 1);
         
}
});

alertdialog.setNegativeButton("Delete", new DialogInterface.OnClickListener() {

@Override
public void onClick(DialogInterface dialog, int which) {

DatabaseHelper db = new DatabaseHelper(getApplicationContext());
String ctn = ((TextView) view.findViewById(R.id.ctextView1)).getText

().toString();
db.deletecard(ctn);
updatelist();

}
});
alertdialog.show();

}

class CustomAdapter extends BaseAdapter {

private ArrayList<CardModel> data;

public CustomAdapter(ArrayList<CardModel> data) {
this.data = data;
}

@Override
public int getCount() {

return data.size();
}

@Override
public ArrayList<CardModel> getItem(int arg0) {

return null;
}

@Override
public long getItemId(int arg0) {

return arg0;
}

@Override
public View getView(int position, View view, ViewGroup parent) {

View rowView = inflater.inflate(R.layout.customcard, null, true);
TextView txtTitle = (TextView) rowView.findViewById(R.id.customcard_tv);
TextView txtid = (TextView) rowView.findViewById(R.id.ctextView1);
txtTitle.setText(data.get(position).getCardNumber());
txtid.setText(data.get(position).getId());

return rowView;

}
}

@Override
protected void onActivityResult(int requestCode, int resultCode, Intent data) {

super.onActivityResult(requestCode, resultCode, data);

if ((requestCode == 1 || requestCode == 2) && resultCode == RESULT_OK) {

updatelist();

}
}

public void updatelist() {

db = new DatabaseHelper(getApplicationContext());
carddata = db.getValues();
CustomAdapter ca = new CustomAdapter(carddata);
listview.setAdapter(ca);

}

}




................................................................................
sp = getSharedPreferences(PREFS, 0);
String userid=sp.getString("Userid1","");



mETUsername = (EditText) findViewById(R.id.reg_ETUsername);
mETPassword = (EditText) findViewById(R.id.reg_ETPassword);
mBtnSubmit = (Button) findViewById(R.id.btn_Submit);
mBtnregister = (Button) findViewById(R.id.Register);

String tempString="Register Here ?";
SpannableString spanString = new SpannableString(tempString);
spanString.setSpan(new UnderlineSpan(), 0, spanString.length(), 0);
spanString.setSpan(new StyleSpan(Typeface.BOLD), 0, spanString.length(), 0);
spanString.setSpan(new StyleSpan(Typeface.ITALIC), 0, spanString.length(), 0);
mBtnregister.setText(spanString);

db=new DatabaseHelper(getApplicationContext());

mBtnSubmit.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {

String username = mETUsername.getText().toString();
String password = mETPassword.getText().toString();

if(username.equals("")&&password.equals("")){

Toast.makeText(getApplicationContext(), "Please Enter Login Details " ,

Toast.LENGTH_SHORT).show();

}

else if(username.equalsIgnoreCase("")){

Toast.makeText(getApplicationContext(), "Please enter Username" ,

Toast.LENGTH_SHORT).show();

}else if(password.equalsIgnoreCase("") || password.length()<6){

Toast.makeText(getApplicationContext(), "Please enter password" ,

Toast.LENGTH_SHORT).show();

}else{

if(db.getdetails(username).equalsIgnoreCase("none"))
{


Toast.makeText(getApplicationContext(), "Invalid Username and Password",

Toast.LENGTH_SHORT).show();

}else{


String userid=db.getdetails(username);
String userid1=db.getdetails(password);
sp = getSharedPreferences(PREFS, 0);
SharedPreferences.Editor editor=sp.edit();
editor.putString("Userid", userid);
editor.putString("Userid1", userid1);
editor.commit();
startActivity( new Intent(getApplicationContext(),Home.class) );

finish();

}
}
}
});


....................................................................................................

setContentView(R.layout.sample_register);

mETUsername        = (EditText) findViewById(R.id.reg_ETUsername);
mETPassword        = (EditText) findViewById(R.id.reg_ETPassword);
mETConfirmPassword = (EditText) findViewById(R.id.confirmpwd);

mBtnSubmit=(Button)findViewById(R.id.btn_Submit);

mBtnSubmit.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {

String username =mETUsername.getText().toString();
String password =mETPassword.getText().toString();
String confirmpasswd =mETConfirmPassword.getText().toString();


if(username.equalsIgnoreCase("")){

Toast.makeText(getApplicationContext(), "Please Enter username",

Toast.LENGTH_SHORT).show();

}else if(password.equalsIgnoreCase("") ){

Toast.makeText(getApplicationContext(), "Please Enter password",

Toast.LENGTH_SHORT).show();

}else if(password.length()<6 ){

Toast.makeText(getApplicationContext(), "Password should be Minimum 6 charaters",

Toast.LENGTH_SHORT).show();

}else if(confirmpasswd.equalsIgnoreCase("")){

Toast.makeText(getApplicationContext(), "Please Enter confirmpasswd",

Toast.LENGTH_SHORT).show();

}else if(confirmpasswd.length()<6){

Toast.makeText(getApplicationContext(), "Confirm password should be Minimum 6

charaters", Toast.LENGTH_SHORT).show();

}else if(!confirmpasswd.equalsIgnoreCase(password)){

Toast.makeText(getApplicationContext(), "Password and confirmpasswd are not

match", Toast.LENGTH_SHORT).show();

}else{

db=new DatabaseHelper(getApplicationContext());
int i= db.insertuserdetails(username, password);

if (i == -1) {

Toast.makeText(getApplicationContext(), "Registered Unsuccessfully",

Toast.LENGTH_SHORT).show();

}else{

Toast.makeText(getApplicationContext(), "Registered Successfully",

Toast.LENGTH_SHORT).show();
finish();

}
}
}
});


'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

public class DatabaseHelper extends SQLiteOpenHelper {

Context context;

public DatabaseHelper(Context context) {
super(context, "SampleDb", null, 1);
this.context = context;

}

@Override
public void onCreate(SQLiteDatabase db) {

Log.e("", "onCreate database");

db.execSQL("Create table passwordTable(id  INTEGER PRIMARY KEY AUTOINCREMENT,accountname text,username

text,password text);");
db.execSQL("Create table Cards(id  INTEGER PRIMARY KEY AUTOINCREMENT,CardNumber text ,BankName

text,PinNumber text,CvvNumber text,ValidFrom text,ValidTo text);");

db.execSQL("Create table Userdtails(id  INTEGER PRIMARY KEY AUTOINCREMENT,username varchar, password

varchar,status INTEGER);");

}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

public void exeQuery(SQLiteDatabase db, String query) {

db.execSQL(query);
}


ArrayList<CardModel> cardsData = new ArrayList<CardModel>();

public ArrayList<CardModel> getValues() {

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();

Cursor cr = sqliteDB.rawQuery("select * from Cards", null);

if (cr.getCount() > 0) {

while (cr.moveToNext()) {

CardModel cardModel = new CardModel();
cardModel.setId(cr.getString(cr.getColumnIndex("id")));
cardModel.setCardNumber(cr.getString(cr.getColumnIndex("CardNumber")));
cardModel.setBankName(cr.getString(cr.getColumnIndex("BankName")));
cardModel.setPinNumber(cr.getString(cr.getColumnIndex("PinNumber")));
cardModel.setCvvNumber(cr.getString(cr.getColumnIndex("CvvNumber")));
cardModel.setValidFrom(cr.getString(cr.getColumnIndex("ValidFrom")));
cardModel.setValidTo(cr.getString(cr.getColumnIndex("ValidTo")));
cardsData.add(cardModel);

}
}

Log.e("Value", "" + cardsData.size());
return cardsData;
}

public CardModel getselectedvalues(String id) {

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();

CardModel cardModel = new CardModel();
String query = "select * from Cards where id=" + id;
Cursor cr = sqliteDB.rawQuery(query, null);

if (cr.getCount() > 0) {
while (cr.moveToNext()) {

cardModel.setCardNumber(cr.getString(cr.getColumnIndex("CardNumber")));
cardModel.setBankName(cr.getString(cr.getColumnIndex("BankName")));
cardModel.setPinNumber(cr.getString(cr.getColumnIndex("PinNumber")));
cardModel.setCvvNumber(cr.getString(cr.getColumnIndex("CvvNumber")));
cardModel.setValidFrom(cr.getString(cr.getColumnIndex("ValidFrom")));
cardModel.setValidTo(cr.getString(cr.getColumnIndex("ValidTo")));

}
}
return cardModel;
}

public void updaterecord(String id, String CardNumber, String BankName,
String PinNumber, String CvvNumber, String ValidFrom, String ValidTo) {

ContentValues cv = new ContentValues();
cv.put("id", id);
cv.put("CardNumber", CardNumber);
cv.put("BankName", BankName);
cv.put("PinNumber", PinNumber);
cv.put("CvvNumber", CvvNumber);
cv.put("ValidFrom", ValidFrom);
cv.put("ValidTo", ValidTo);
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase db = dbSample.getWritableDatabase();
db.update("Cards", cv, id + "=" + "id", null);

}

public void deletecard(String id) {
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase db = dbSample.getWritableDatabase();
db.delete("cards", id + "=" + "id", null);

}

public String[] getarraycardnumbr() {

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
int i = 0;

Cursor cr = sqliteDB.rawQuery("select * from Cards", null);
String[] array = new String[cr.getCount()];
if (cr.getCount() > 0) {
while (cr.moveToNext()) {
array[i] = cr.getString(cr.getColumnIndex("CardNumber"));
i += 1;
}
}

return array;
}

public ArrayList<CardModel> getautocarddtails(String cardno) {
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
String query = "select * from cards where CardNumber like " + "'"
+ cardno + "%'" + "or CardNumber like" + "'% " + cardno + "%'";
Cursor cr = sqliteDB.rawQuery(query, null);

if (cr.getCount() > 0) {

while (cr.moveToNext()) {

CardModel cardModel = new CardModel();
cardModel.setId(cr.getString(cr.getColumnIndex("id")));
cardModel.setCardNumber(cr.getString(cr.getColumnIndex("CardNumber")));
cardModel.setBankName(cr.getString(cr.getColumnIndex("BankName")));
cardModel.setPinNumber(cr.getString(cr.getColumnIndex("PinNumber")));
cardModel.setCvvNumber(cr.getString(cr.getColumnIndex("CvvNumber")));
cardModel.setValidFrom(cr.getString(cr.getColumnIndex("ValidFrom")));
cardModel.setValidTo(cr.getString(cr.getColumnIndex("ValidTo")));
cardsData.add(cardModel);

}
}

return cardsData;
}




ArrayList<PasswordModel> passwdData = new ArrayList<PasswordModel>();

public ArrayList<PasswordModel> getPasswdValues() {

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();

Cursor cr = sqliteDB.rawQuery("select * from passwordTable", null);

if (cr.getCount() > 0) {

while (cr.moveToNext()) {

PasswordModel passwordModel = new PasswordModel();
passwordModel.setId(cr.getString(cr.getColumnIndex("id")));
passwordModel.setAccountname(cr.getString(cr.getColumnIndex("accountname")));
passwordModel.setUsername(cr.getString(cr.getColumnIndex("username")));
passwordModel.setPassword(cr.getString(cr.getColumnIndex("password")));

passwdData.add(passwordModel);

}
}

return passwdData;
}

public PasswordModel getselectedPasswords(String id) {
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
PasswordModel Passworddata = new PasswordModel();
String query = "select * from passwordTable where id=" + id;
Cursor cr = sqliteDB.rawQuery(query, null);
if (cr.getCount() > 0) {
while (cr.moveToNext()) {

Passworddata.setAccountname(cr.getString(cr.getColumnIndex("accountname")));
Passworddata.setUsername(cr.getString(cr.getColumnIndex("username")));
Passworddata.setPassword(cr.getString(cr.getColumnIndex("password")));

}
}
return Passworddata;
}

public void updatepasswordrecord(String id, String accountname, String username,
String password) {

ContentValues cv = new ContentValues();
cv.put("accountname", accountname);
cv.put("username", username);
cv.put("password", password);

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase db = dbSample.getWritableDatabase();
db.update("passwordTable", cv, id + "=" + "id", null);

}

public void deletepassword(String id) {
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase db = dbSample.getWritableDatabase();
db.delete("passwordTable", id + "=" + "id", null);

}

public String[] getarraypasswordnumbr() {

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();

int i = 0;
Cursor cr = sqliteDB.rawQuery("select * from passwordTable", null);
String[] array = new String[cr.getCount()];

if (cr.getCount() > 0) {
while (cr.moveToNext()) {
array[i] = cr.getString(cr.getColumnIndex("accountname"));
i += 1;
}
}

return array;
}

public ArrayList<PasswordModel> getautopassworddtails(String accountname) {

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
String query = "select * from passwordTable where accountname like " + "'"
+ accountname + "%'" + "or accountname like" + "'% " + accountname + "%'";

Cursor cr = sqliteDB.rawQuery(query, null);

if (cr.getCount() > 0) {

while (cr.moveToNext()) {

PasswordModel passwordModel = new PasswordModel();
passwordModel.setId(cr.getString(cr.getColumnIndex("id")));
passwordModel.setAccountname(cr.getString(cr.getColumnIndex("accountname")));
passwordModel.setUsername(cr.getString(cr.getColumnIndex("username")));
passwordModel.setPassword(cr.getString(cr.getColumnIndex("password")));

passwdData.add(passwordModel);

}
}

return passwdData;
}


// addcarddetails
public boolean addCardDetails(String Cardno, String Bankname, String pinno,
String Cvvno, String validfrom, String validto) {

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();

ContentValues cv = new ContentValues();
cv.put("CardNumber", Cardno);
cv.put("BankName", Bankname);
cv.put("PinNumber", pinno);
cv.put("CvvNumber", Cvvno);
cv.put("ValidFrom", validfrom);
cv.put("ValidTo", validto);

long staus = sqliteDB.insert("Cards", null, cv);

sqliteDB.close();

if (staus == -1)
return false;
else
return true;

}// addcarddetails


public Boolean chckusername()
{
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();

String query="select * from Userdtails";

Boolean chck;
Cursor cr=sqliteDB.rawQuery(query,null );
if(cr.getCount()>0)
{
chck=true;
}
else
{
chck=false;
}
return chck;
}

public int insertuserdetails(String username,String password)
{
int i;
i=0;
ContentValues cv = new ContentValues();
cv.put("username", username);
cv.put("password",password);
cv.put("status", i);

try{
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase db = dbSample.getWritableDatabase();
i = (int) db.insert("Userdtails", null, cv);
db.close();

}catch(Exception e) {
i = -1;
}

return i;
}
public Usermodel getdetails()
{
Usermodel user=new Usermodel();

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
//int i=0;
Cursor cr = sqliteDB.rawQuery("select * from Userdtails where id =1", null);


//String query = "select * from LoyalityCards where id=" + id;

if(cr.getCount()>0)
{
while(cr.moveToNext())
{
user.setUsername(cr.getString(cr.getColumnIndex("username")));
user.setPassword(cr.getString(cr.getColumnIndex("password")));
}
}
return user;
}


public String getdetails(String Username)
{
String mId = "none";

DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();

Cursor cr = sqliteDB.rawQuery("select * from Userdtails where username="+"'"+Username.toString()+"';", null);

if(cr.getCount()>0){

while(cr.moveToNext()){

mId = cr.getString(cr.getColumnIndex("id"));
}
}
return mId;
}
public String getstatus()
{
String userid="null";
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
Cursor cr = sqliteDB.rawQuery("select * from Userdtails where status=1", null);
try
{
if(cr.getCount()>0)
{

while(cr.moveToNext()){

userid = cr.getString(cr.getColumnIndex("id"));
}
}
}
catch(Exception ex)
{
userid="null";
}

return userid;
}






public boolean updateuser(String password)
{
try{

SQLiteDatabase db = this.getWritableDatabase();
ContentValues cv = new ContentValues();
//cv.put("username",username);
cv.put("password",password);
db.update("Userdtails", cv, "1=" + "id", null);
}catch(Exception e){
return false;
}
return true;

}


public void Updatestatus(String userid, int status) {


SQLiteDatabase db = this.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put("status",status);

String sql="update Userdtails set status="+String.valueOf(status)+" where id="+userid.toString();
db.execSQL(sql);
db.close();

}
public String getusername(String userid)
{
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
String username="";

Cursor cr = sqliteDB.rawQuery("select * from Userdtails where id="+userid.toString(), null);
if(cr.getCount()>0){

while(cr.moveToNext()){

username = cr.getString(cr.getColumnIndex("username"));
}
}
return username;
}

public String getpassword(String userid1)
{
DatabaseHelper dbSample = new DatabaseHelper(context);
SQLiteDatabase sqliteDB = dbSample.getReadableDatabase();
String password="";

Cursor cr = sqliteDB.rawQuery("select * from Userdtails where id="+userid1.toString(), null);
if(cr.getCount()>0){

while(cr.moveToNext()){

password = cr.getString(cr.getColumnIndex("password"));
}
}
return password;
}
}
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
confirmation:
setContentView(R.layout.confirmation_screen);



mETUsername = (TextView) findViewById(R.id.reg_ETUsername);
mETPassword = (EditText) findViewById(R.id.reg_ETPassword);

mBtnSubmit = (Button) findViewById(R.id.btn_Submit);


sp = getSharedPreferences(PREFS, 0);
String userid=sp.getString("Userid","");
final String userid1=sp.getString("Userid","");


if(userid==""){

}

else {
DatabaseHelper db=new DatabaseHelper(getApplicationContext());
String username=db.getusername(userid);

mETUsername.setText("Welcome To:"+username);

}




mBtnSubmit.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {

DatabaseHelper db=new DatabaseHelper(getApplicationContext());
String password1=db.getpassword(userid1);

String password=mETPassword.getText().toString();

if(password.equals("")){
Toast.makeText(getApplicationContext(), "Please Enter Confirm Password " ,

Toast.LENGTH_SHORT).show();
}

else if(password.equals(password1)){
Toast.makeText(getApplicationContext(), "Password matched" , Toast.LENGTH_SHORT).show();
finish();
startActivity(new Intent(getApplicationContext(),GrappleHome.class));

}else{
Toast.makeText(getApplicationContext(), "Passworddoes not matched" ,

Toast.LENGTH_SHORT).show();
}


}
});

...........................................................................................
setContentView(R.layout.splash_screen);


Thread splashThread = new Thread() {
public void run() {
try {
sleep(3000);
} catch (InterruptedException e) {

e.printStackTrace();
} finally {
finish();



   sp = getSharedPreferences(PREFS, 0);
String userid=sp.getString("Userid","");

//Log.d("th e valie ", userid);


if(userid=="")


{
startActivity(new Intent(getApplicationContext(),LoginScreen.class));
}
else
{


startActivity(new Intent(getApplicationContext(),ConfirmationScreen.class));


}
   



}
}
};splashThread.start();

}