Source code:-

package [Link].attendance_manager;

import [Link];

import [Link].AndroidJUnit4;
import
[Link];

import [Link];
import [Link];

import static [Link];

/**
* Instrumented test, which will execute on an Android
device.
*
* @see <a
href="[Link]
documentation</a>
*/
@RunWith([Link])
public class ExampleInstrumentedTest {
@Test
public void useAppContext() {
// Context of the app under test.
Context appContext =
[Link]().getTargetC
ontext();
assertEquals("[Link].attendance_manager",
[Link]());
}
}
xml version="1.0" encoding="UTF-8"?>

<manifest package="[Link].attendance_manager"
xmlns:android="[Link]
android:name="[Link]"/><application
android:theme="@style/[Link]" android:supportsRtl="true"
android:roundIcon="@mipmap/ic_launcher_round" android:label="@string/app_name"
android:icon="@mipmap/ic_launcher" android:allowBackup="true"><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"/><activity
android:name=".[Link]"><intent-filter><action
android:name="[Link]"/><category
android:name="[Link]"/></intent-filter></activity></application></
manifest>

<?xml version="1.0" encoding="UTF-8"?>

<project version="4">
<component name="RemoteRepositoriesConfiguration">
<remote-repository>
<option name="id" value="central" />
<option name="name" value="Maven Central repository" />
<option name="url" value="[Link] />
</remote-repository>
<remote-repository>
<option name="id" value="[Link]" />
<option name="name" value="JBoss Community repository" />
<option name="url" value="[Link] />
</remote-repository>
<remote-repository>
<option name="id" value="MavenRepo" />
<option name="name" value="MavenRepo" />
<option name="url" value="[Link] />
</remote-repository>
<remote-repository>
<option name="id" value="BintrayJCenter" />
<option name="name" value="BintrayJCenter" />
<option name="url" value="[Link] />
</remote-repository>
<remote-repository>
<option name="id" value="Google" />
<option name="name" value="Google" />
<option name="url" value="[Link] />
</remote-repository>
</component>
</project>
package [Link].attendance_manager.context;

import [Link];

import [Link];

import [Link].attendance_manager.[Link];
import [Link].attendance_manager.[Link];
import [Link].attendance_manager.[Link];
import [Link].attendance_manager.[Link];

public class ApplicationContext extends Application {

private Faculty faculty;
private AttendanceSession attendanceSession;
private ArrayList<Student> studentList;
private ArrayList<Attendance> attendanceList;
 public Faculty getFaculty() {
return faculty;
}

public void setFaculty(Faculty faculty) {

[Link] = faculty;
}

public AttendanceSession getAttendanceSession() {

return attendanceSession;
}

public void setAttendanceSession(AttendanceSession attendanceSession) {

[Link] = attendanceSession;
}

public ArrayList<Student> getStudentList() {

return studentList;
}

public void setStudentList(ArrayList<Student> studentList) {

[Link] = studentList;
}

public ArrayList<Attendance> getAttendanceList() {

return attendanceList;
}

public void setAttendanceList(ArrayList<Attendance> attendanceList) {

[Link] = attendanceList;
}
}
package [Link].attendance_manager.controllers;

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

import [Link].attendance_manager.[Link];
import [Link].attendance_manager.[Link];
import [Link].attendance_manager.[Link];
import [Link].attendance_manager.[Link];

public class DBAdapter extends SQLiteOpenHelper {

private static final int DATABASE_VERSION = 1;

 private static final String DATABASE_NAME = "Attendance";

private static final String FACULTY_INFO_TABLE = "faculty_table";

private static final String STUDENT_INFO_TABLE = "student_table";
private static final String ATTENDANCE_SESSION_TABLE = "attendance_session_table";
private static final String ATTENDANCE_TABLE = "attendance_table";

private static final String KEY_FACULTY_ID = "faculty_id";

private static final String KEY_FACULTY_FIRSTNAME = "faculty_firstname";
private static final String KEY_FACULTY_LASTNAME = "faculty_Lastname";
private static final String KEY_FACULTY_MO_NO = "faculty_mobilenumber";
private static final String KEY_FACULTY_ADDRESS = "faculty_address";
private static final String KEY_FACULTY_USERNAME = "faculty_username";
private static final String KEY_FACULTY_PASSWORD = "faculty_password";

private static final String KEY_STUDENT_ID = "student_id";

private static final String KEY_STUDENT_FIRSTNAME = "student_firstname";
private static final String KEY_STUDENT_LASTNAME = "student_lastname";
private static final String KEY_STUDENT_MO_NO = "student_mobilenumber";
private static final String KEY_STUDENT_ADDRESS = "student_address";
private static final String KEY_STUDENT_DEPARTMENT = "student_department";
private static final String KEY_STUDENT_CLASS = "student_class";

private static final String KEY_ATTENDANCE_SESSION_ID = "attendance_session_id";

private static final String KEY_ATTENDANCE_SESSION_FACULTY_ID =
"attendance_session_faculty_id";
private static final String KEY_ATTENDANCE_SESSION_DEPARTMENT =
"attendance_session_department";
private static final String KEY_ATTENDANCE_SESSION_CLASS = "attendance_session_class";
private static final String KEY_ATTENDANCE_SESSION_DATE = "attendance_session_date";
private static final String KEY_ATTENDANCE_SESSION_SUBJECT = "attendance_session_subject";

private static final String KEY_SESSION_ID = "attendance_session_id";

private static final String KEY_ATTENDANCE_STUDENT_ID = "attendance_student_id";
private static final String KEY_ATTENDANCE_STATUS = "attendance_status";

public DBAdapter(Context context) {

super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
String queryFaculty = "CREATE TABLE " + FACULTY_INFO_TABLE + " (" +
KEY_FACULTY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_FACULTY_FIRSTNAME + " TEXT, " +
KEY_FACULTY_LASTNAME + " TEXT, " +
KEY_FACULTY_MO_NO + " TEXT, " +
KEY_FACULTY_ADDRESS + " TEXT," +
KEY_FACULTY_USERNAME + " TEXT," +
 KEY_FACULTY_PASSWORD + " TEXT " + ")";
Log.d("queryFaculty", queryFaculty);

String queryStudent = "CREATE TABLE " + STUDENT_INFO_TABLE + " (" +

KEY_STUDENT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_STUDENT_FIRSTNAME + " TEXT, " +
KEY_STUDENT_LASTNAME + " TEXT, " +
KEY_STUDENT_MO_NO + " TEXT, " +
KEY_STUDENT_ADDRESS + " TEXT," +
KEY_STUDENT_DEPARTMENT + " TEXT," +
KEY_STUDENT_CLASS + " TEXT " + ")";
Log.d("queryStudent", queryStudent);

String queryAttendanceSession = "CREATE TABLE " + ATTENDANCE_SESSION_TABLE + " (" +

KEY_ATTENDANCE_SESSION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_ATTENDANCE_SESSION_FACULTY_ID + " INTEGER, " +
KEY_ATTENDANCE_SESSION_DEPARTMENT + " TEXT, " +
KEY_ATTENDANCE_SESSION_CLASS + " TEXT, " +
KEY_ATTENDANCE_SESSION_DATE + " DATE," +
KEY_ATTENDANCE_SESSION_SUBJECT + " TEXT" + ")";
Log.d("queryAttendanceSession", queryAttendanceSession);

String queryAttendance = "CREATE TABLE " + ATTENDANCE_TABLE + " (" +

KEY_SESSION_ID + " INTEGER, " +
KEY_ATTENDANCE_STUDENT_ID + " INTEGER, " +
KEY_ATTENDANCE_STATUS + " TEXT " + ")";
Log.d("queryAttendance", queryAttendance);

try {
[Link](queryFaculty);
[Link](queryStudent);
[Link](queryAttendanceSession);
[Link](queryAttendance);
} catch (Exception e) {
[Link]();
Log.e("Exception", [Link]());
}

@Override
public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
String queryFaculty = "CREATE TABLE " + FACULTY_INFO_TABLE + " (" +
KEY_FACULTY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_FACULTY_FIRSTNAME + " TEXT, " +
KEY_FACULTY_LASTNAME + " TEXT, " +
 KEY_FACULTY_MO_NO + " TEXT, " +
KEY_FACULTY_ADDRESS + " TEXT," +
KEY_FACULTY_USERNAME + " TEXT," +
KEY_FACULTY_PASSWORD + " TEXT " + ")";
Log.d("queryFaculty", queryFaculty);

String queryStudent = "CREATE TABLE " + STUDENT_INFO_TABLE + " (" +

KEY_STUDENT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_STUDENT_FIRSTNAME + " TEXT, " +
KEY_STUDENT_LASTNAME + " TEXT, " +
KEY_STUDENT_MO_NO + " TEXT, " +
KEY_STUDENT_ADDRESS + " TEXT," +
KEY_STUDENT_DEPARTMENT + " TEXT," +
KEY_STUDENT_CLASS + " TEXT " + ")";
Log.d("queryStudent", queryStudent);

String queryAttendanceSession = "CREATE TABLE " + ATTENDANCE_SESSION_TABLE + " (" +

KEY_ATTENDANCE_SESSION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_ATTENDANCE_SESSION_FACULTY_ID + " INTEGER, " +
KEY_ATTENDANCE_SESSION_DEPARTMENT + " TEXT, " +
KEY_ATTENDANCE_SESSION_CLASS + " TEXT, " +
KEY_ATTENDANCE_SESSION_DATE + " TEXT," +
KEY_ATTENDANCE_SESSION_SUBJECT + " TEXT" + ")";
Log.d("queryAttendanceSession", queryAttendanceSession);

String queryAttendance = "CREATE TABLE " + ATTENDANCE_TABLE + " (" +

KEY_SESSION_ID + " INTEGER, " +
KEY_ATTENDANCE_STUDENT_ID + " INTEGER, " +
KEY_ATTENDANCE_STATUS + " TEXT " + ")";
Log.d("queryAttendance", queryAttendance);

try {
[Link](queryFaculty);
[Link](queryStudent);
[Link](queryAttendanceSession);
[Link](queryAttendance);
} catch (Exception e) {
[Link]();
Log.e("Exception", [Link]());
}
}

public void addFaculty(Faculty faculty) {

SQLiteDatabase db = [Link]();

String query = "INSERT INTO faculty_table

(faculty_firstname,faculty_Lastname,faculty_mobilenumber,faculty_address,faculty_username,facul
ty_password) values ('" +
 faculty.getFaculty_firstname() + "', '" +
faculty.getFaculty_lastname() + "', '" +
faculty.getFaculty_mobile_number() + "', '" +
faculty.getFaculty_address() + "', '" +
faculty.getFaculty_username() + "', '" +
faculty.getFaculty_password() + "')";
Log.d("query", query);
[Link](query);
[Link]();
}

public Faculty validateFaculty(String userName, String password) {

SQLiteDatabase db = [Link]();

String query = "SELECT * FROM faculty_table where faculty_username='" + userName + "' and
faculty_password='" + password + "'";
Cursor cursor = [Link](query, null);

if ([Link]()) {

Faculty faculty = new Faculty();

faculty.setFaculty_id([Link]([Link](0)));
faculty.setFaculty_firstname([Link](1));
faculty.setFaculty_lastname([Link](2));
faculty.setFaculty_mobile_number([Link](3));
faculty.setFaculty_address([Link](4));
faculty.setFaculty_username([Link](5));
faculty.setFaculty_password([Link](6));
return faculty;
}
[Link]();
[Link]();
return null;
}

public ArrayList<Faculty> getAllFaculty() {

ArrayList<Faculty> list = new ArrayList<>();

SQLiteDatabase db = [Link]();
String query = "SELECT * FROM faculty_table";
Cursor cursor = [Link](query, null);

if ([Link]()) {
do {
Faculty faculty = new Faculty();
faculty.setFaculty_id([Link]([Link](0)));
faculty.setFaculty_firstname([Link](1));
faculty.setFaculty_lastname([Link](2));
faculty.setFaculty_mobile_number([Link](3));
faculty.setFaculty_address([Link](4));
faculty.setFaculty_username([Link](5));
 faculty.setFaculty_password([Link](6));
[Link](faculty);

} while ([Link]());
}
[Link]();
[Link]();
return list;
}

public void deleteFaculty(int facultyId) {

SQLiteDatabase db = [Link]();

String query = "DELETE FROM faculty_table WHERE faculty_id=" + facultyId;

Log.d("query", query);
[Link](query);
[Link]();
}

//student crud
public void addStudent(Student student) {
SQLiteDatabase db = [Link]();

String query = "INSERT INTO student_table

(student_firstname,student_lastname,student_mobilenumber,student_address,student_departmen
t,student_class) values ('" +
student.getStudent_firstname() + "', '" +
student.getStudent_lastname() + "','" +
student.getStudent_mobile_number() + "', '" +
student.getStudent_address() + "', '" +
student.getStudent_department() + "', '" +
student.getStudent_class() + "')";
Log.d("query", query);
[Link](query);
[Link]();
}

public ArrayList<Student> getAllStudent() {

ArrayList<Student> list = new ArrayList<>();

SQLiteDatabase db = [Link]();
String query = "SELECT * FROM student_table";
Cursor cursor = [Link](query, null);

if ([Link]()) {
do {
Student student = new Student();
student.setStudent_id([Link]([Link](0)));
student.setStudent_firstname([Link](1));
student.setStudent_lastname([Link](2));
 student.setStudent_mobile_number([Link](3));
student.setStudent_address([Link](4));
student.setStudent_department([Link](5));
student.setStudent_class([Link](6));
[Link](student);
} while ([Link]());
}
[Link]();
[Link]();
return list;
}

public ArrayList<Student> getAllStudentByBranchSem(String branch, String semester) {

ArrayList<Student> list = new ArrayList<>();

SQLiteDatabase db = [Link]();
String query = "SELECT * FROM student_table where student_department='" + branch + "' and
student_class='" + semester + "'";
Cursor cursor = [Link](query, null);

if ([Link]()) {
do {
Student student = new Student();
student.setStudent_id([Link]([Link](0)));
student.setStudent_firstname([Link](1));
student.setStudent_lastname([Link](2));
student.setStudent_mobile_number([Link](3));
student.setStudent_address([Link](4));
student.setStudent_department([Link](5));
student.setStudent_class([Link](6));
[Link](student);
} while ([Link]());
}
[Link]();
[Link]();
return list;
}

public Student getStudentById(int studentId) {

Student student = new Student();
SQLiteDatabase db = [Link]();
String query = "SELECT * FROM student_table where student_id=" + studentId;
Cursor cursor = [Link](query, null);

if ([Link]()) {
do {

student.setStudent_id([Link]([Link](0)));
student.setStudent_firstname([Link](1));
student.setStudent_lastname([Link](2));
student.setStudent_mobile_number([Link](3));
 student.setStudent_address([Link](4));
student.setStudent_department([Link](5));
student.setStudent_class([Link](6));

} while ([Link]());
}
[Link]();
[Link]();
return student;
}

public void deleteStudent(int studentId) {

SQLiteDatabase db = [Link]();

String query = "DELETE FROM student_table WHERE student_id=" + studentId;

Log.d("query", query);
[Link](query);
[Link]();
}

public int addAttendanceSession(AttendanceSession attendanceSession) {

SQLiteDatabase db = [Link]();

String query = "INSERT INTO attendance_session_table

(attendance_session_faculty_id,attendance_session_department,attendance_session_class,attenda
nce_session_date,attendance_session_subject) values ('" +
attendanceSession.getAttendance_session_faculty_id() + "', '" +
attendanceSession.getAttendance_session_department() + "','" +
attendanceSession.getAttendance_session_class() + "', '" +
attendanceSession.getAttendance_session_date() + "', '" +
attendanceSession.getAttendance_session_subject() + "')";
Log.d("query", query);
[Link](query);

String query1 = "select max(attendance_session_id) from attendance_session_table";

Cursor cursor = [Link](query1, null);

if ([Link]()) {
return [Link]([Link](0));
}
[Link]();
[Link]();
return 0;
}

public ArrayList<AttendanceSession> getAllAttendanceSession() {

ArrayList<AttendanceSession> list = new ArrayList<>();

SQLiteDatabase db = [Link]();
String query = "SELECT * FROM attendance_session_table";
 Cursor cursor = [Link](query, null);

if ([Link]()) {
do {
AttendanceSession attendanceSession = new AttendanceSession();
attendanceSession.setAttendance_session_id([Link]([Link](0)));
attendanceSession.setAttendance_session_faculty_id([Link]([Link](1)));
attendanceSession.setAttendance_session_department([Link](2));
attendanceSession.setAttendance_session_class([Link](3));
attendanceSession.setAttendance_session_date([Link](4));
attendanceSession.setAttendance_session_subject([Link](5));
[Link](attendanceSession);
} while ([Link]());
}
[Link]();
[Link]();
return list;
}

public void deleteAttendanceSession(int attendanceSessionId) {

SQLiteDatabase db = [Link]();

String query = "DELETE FROM attendance_session_table WHERE attendance_session_id=" +

attendanceSessionId;

Log.d("query", query);
[Link](query);
[Link]();
}

//attendance crud
public void addNewAttendance(Attendance attendance) {
SQLiteDatabase db = [Link]();

String query = "INSERT INTO attendance_table values (" +

attendance.getAttendance_session_id() + ", " +
attendance.getAttendance_student_id() + ", '" +
attendance.getAttendance_status() + "')";
Log.d("query", query);
[Link](query);
[Link]();
}

public ArrayList<Attendance> getAttendanceBySessionID(AttendanceSession attendanceSession) {

int attendanceSessionId = 0;
ArrayList<Attendance> list = new ArrayList<>();

SQLiteDatabase db = [Link]();
String query = "SELECT * FROM attendance_session_table where
attendance_session_faculty_id=" + attendanceSession.getAttendance_session_faculty_id() + ""
 + " AND attendance_session_department='" +
attendanceSession.getAttendance_session_department() + "' AND attendance_session_class='" +
attendanceSession.getAttendance_session_class() + "'" +
" AND attendance_session_date='" + attendanceSession.getAttendance_session_date() + "'
AND attendance_session_subject='" + attendanceSession.getAttendance_session_subject() + "'";
Cursor cursor = [Link](query, null);

if ([Link]()) {
do {
attendanceSessionId = ([Link]([Link](0)));
} while ([Link]());
}

String query1 = "SELECT * FROM attendance_table where attendance_session_id=" +

attendanceSessionId + " order by attendance_student_id";
Cursor cursor1 = [Link](query1, null);
if ([Link]()) {
do {
Attendance attendanceBean = new Attendance();
attendanceBean.setAttendance_session_id([Link]([Link](0)));
attendanceBean.setAttendance_student_id([Link]([Link](1)));
attendanceBean.setAttendance_status([Link](2));
[Link](attendanceBean);

} while ([Link]());
}
[Link]();
[Link]();
[Link]();
return list;
}

public ArrayList<Attendance> getTotalAttendanceBySessionID(AttendanceSession

attendanceSession) {
int attendanceSessionId;
ArrayList<Attendance> list = new ArrayList<>();

SQLiteDatabase db = [Link]();
String query = "SELECT * FROM attendance_session_table where
attendance_session_faculty_id=" + attendanceSession.getAttendance_session_faculty_id() + ""
+ " AND attendance_session_department='" +
attendanceSession.getAttendance_session_department() + "' AND attendance_session_class='" +
attendanceSession.getAttendance_session_class() + "'" +
" AND attendance_session_subject='" +
attendanceSession.getAttendance_session_subject() + "'";
Cursor cursor = [Link](query, null);

if ([Link]()) {
do {
attendanceSessionId = ([Link]([Link](0)));
 String query1 = "SELECT * FROM attendance_table where attendance_session_id=" +
attendanceSessionId + " order by attendance_student_id";
Cursor cursor1 = [Link](query1, null);
if ([Link]()) {
do {
Attendance attendance = new Attendance();
attendance.setAttendance_session_id([Link]([Link](0)));
attendance.setAttendance_student_id([Link]([Link](1)));
attendance.setAttendance_status([Link](2));
[Link](attendance);

} while ([Link]());
}

Attendance attendance = new Attendance();

attendance.setAttendance_session_id(0);
attendance.setAttendance_status("Date : " + [Link](4));
[Link](attendance);
[Link]();
} while ([Link]());

[Link]();
[Link]();
return list;
}

public ArrayList<Attendance> getAllAttendanceByStudent() {

ArrayList<Attendance> list = new ArrayList<>();

SQLiteDatabase db = [Link]();
String query = "SELECT attendance_student_id,count(*) FROM attendance_table where
attendance_status='P' group by attendance_student_id";

Cursor cursor = [Link](query, null);

if ([Link]()) {
do {
Log.d("studentId", "studentId:" + [Link](0) + ", Count:" + [Link](1));
Attendance attendance = new Attendance();
attendance.setAttendance_student_id([Link]([Link](0)));
attendance.setAttendance_session_id([Link]([Link](1)));
[Link](attendance);

} while ([Link]());
}
[Link]();
[Link]();
return list;
}
 /*public ArrayList<AttendanceBean> getAllAttendanceBySessionID(int sessionId)
{
ArrayList<AttendanceBean> list = new ArrayList<AttendanceBean>();

SQLiteDatabase db = [Link]();
String query = "SELECT * FROM attendance_table where attendance_session_id=" +
sessionId;
Cursor cursor = [Link](query, null);

if(![Link]())
{
do{
AttendanceBean attendanceBean = new AttendanceBean();

attendanceBean.setAttendance_session_id([Link]([Link](0)));

attendanceBean.setAttendance_student_id([Link]([Link](1)));
attendanceBean.setAttendance_status([Link](2));
[Link](attendanceBean);

}while([Link]());
}
return list;
}*/

// Creating Tables
/*@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_User_Info_TABLE = "CREATE TABLE " + TABLE_INFO_USER + "("
+ KEY_ID + " INTEGER PRIMARY KEY, " + KEY_FIRSTNAME + " TEXT,
"+ KEY_LASTNAME + " TEXT, " +KEY_MO_NO +" TEXT, "
+KEY_EMAIL +" TEXT, " +KEY_USERNAME +" TEXT, " +
KEY_PASSWORD +" TEXT " + ")";

Log.d("rupali",CREATE_User_Info_TABLE );
[Link](CREATE_User_Info_TABLE);
}

// Upgrading database
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// Drop older table if existed
[Link]("DROP TABLE IF EXISTS " + TABLE_INFO_USER);

// Create tables again

onCreate(db);
}

void addUserInfo(UserInfo userinfo) {

SQLiteDatabase db = [Link]();
 ContentValues values = new ContentValues();
[Link](KEY_FIRSTNAME, userinfo.getUser_Firstname()); // Name
[Link](KEY_LASTNAME, userinfo.getUser_Lastname()); // Name
[Link](KEY_MO_NO, userinfo.getUser_MobileNo()); // Contact Phone
[Link](KEY_EMAIL, userinfo.getUser_EmailId());
[Link](KEY_USERNAME, userinfo.getUser_Username());
[Link](KEY_PASSWORD, userinfo.getUser_Password());

// Inserting Row
[Link](TABLE_INFO_USER, null, values);
//2nd argument is String containing nullColumnHack
[Link](); // Closing database connection
}

// Getting single contact

UserInfo getUserInfo(int id) {
SQLiteDatabase db = [Link]();

Cursor cursor = [Link](TABLE_INFO_USER, new String[] { KEY_ID,

KEY_FIRSTNAME, KEY_LASTNAME,KEY_MO_NO, KEY_EMAIL,
KEY_USERNAME, KEY_PASSWORD }, KEY_ID + "=?",
new String[] { [Link](id) }, null, null, null, null);
if (cursor != null)
[Link]();

UserInfo userinfo = new UserInfo([Link]([Link](0)),

[Link](1), [Link](2), [Link](3),
[Link](4),[Link](5),[Link](6));
// return contact
return userinfo;
}

public UserInfo validateUser(String username, String password)

{
SQLiteDatabase db = [Link]();
String query = "Select * from User_Info_Table WHERE User_Username='"+
username +"' AND User_Password='"+password+"'";
Log.d("Rupali", "Login QUERY:" + query);

Cursor cursor = [Link](query, null);

if(![Link]())
{
Log.d("Rupali", "cursor is null.. returing NULL");
return null;
}
Log.d("Rupali", "cursor is NOT null.. we got user data...");
 UserInfo userinfo = new UserInfo([Link]([Link](0)),
[Link](1), [Link](2), [Link](3),
[Link](4),[Link](5),[Link](6));

return userinfo;
}

// Updating single contact

public int updateUserPassword(UserInfo userinfo) {
SQLiteDatabase db = [Link]();

ContentValues values = new ContentValues();

[Link](KEY_PASSWORD, userinfo.getUser_Password());

// updating row
return [Link](TABLE_INFO_USER, values, KEY_ID + " = ?",
new String[] { [Link](userinfo.getUser_id()) });
}

public int updateUserContact(UserInfo userinfo) {

SQLiteDatabase db = [Link]();

ContentValues values = new ContentValues();

[Link](KEY_MO_NO, userinfo.getUser_MobileNo());
[Link](KEY_EMAIL, userinfo.getUser_EmailId());

// updating row
return [Link](TABLE_INFO_USER, values, KEY_ID + " = ?",
new String[] { [Link](userinfo.getUser_id()) });
}

//veiw details

public UserInfo viewUserInfo(String id) {

SQLiteDatabase db = [Link]();

String query = "Select * from User_Info_Table WHERE id='"+id+"'";

Cursor cursor = [Link](query, null);
if(![Link]())
{
Log.d("Rupali", "cursor is null.. returing NULL");
return null;
}
Log.d("Rupali", "cursor is NOT null.. we got user data...");

UserInfo userinfo = new UserInfo([Link]([Link](0)),

 [Link](1), [Link](2), [Link](3),
[Link](4),[Link](5),[Link](6));
// return contact
return userinfo;
}

// Getting All users

public List<UserInfo> getAllUserInfo() {
List<UserInfo> userinfolist = new ArrayList<UserInfo>();
// Select All Query
String selectQuery = "SELECT * FROM " + TABLE_INFO_USER;

SQLiteDatabase db = [Link]();
Cursor cursor = [Link](selectQuery, null);

// looping through all rows and adding to list

if ([Link]()) {
do {

UserInfo userinfo=new UserInfo();

userinfo.setUser_id([Link]([Link](0)));
userinfo.setUser_Lastname([Link](2));
userinfo.setUser_Username([Link](5));
userinfo.setUser_Firstname([Link](1));

// Adding contact to list

[Link](userinfo);
} while ([Link]());
}

// return contact list

return userinfolist;
}

// Deleting single contact

public void deleteUser(UserInfo userinfo) {
SQLiteDatabase db = [Link]();
[Link](TABLE_INFO_USER, KEY_ID + " = ?",
new String[] { [Link](userinfo.getUser_id()) });
[Link]();
}
*/