Query Regarding add the times in the database and also shows it on form also

Question

0.00/5 (No votes)

See more:

Hello guys I have a query regarding the storing the time in database with correct format.

In my app i create a 2 buttons START TIME & END TIME open the time picker and select the time and after show it on form with textview and as well as it store it in database also.In database i have a TIMES table which contain 3 fields id, starttime and closetime.

Now my problem is that the time which i select from time picker is different it shows on form is also different and in database it also shows the different entry.

Please help me to solve this problem.

Thanks in advance

Posted 4-Mar-13 18:32pm

Varsha Bhatia

Add a Solution

Comments

Devang Vaja 5-Mar-13 1:07am

hello varsha ji which db r u using?
mysql or sql server?

Varsha Bhatia 5-Mar-13 1:16am

sir sqlite database m using..sir minor problem which i solve but still i have a prob which is start time and end time both are same in database..

Devang Vaja 5-Mar-13 1:20am

r u using webservice to insert?

Varsha Bhatia 5-Mar-13 1:22am

no sir i paste a code here

public long updateTimeRecord(long id, Calendar calendar) {
ContentValues values = new ContentValues();

// Here is where we apply the Data DateFormat:
values.put(COL_START_TIME, TimeDataFormate.formatDateAsLong(calendar));
values.put(COL_CLOSE_TIME, TimeDataFormate.formatDateAsLong(calendar));

return mDb.update(TABLE_TIME, values, COL_ID1 + "=" + id, null);
}

Varsha Bhatia 5-Mar-13 1:24am

// This is only used for TIME table which define the start and close time
public Cursor fetchTimeList() {
Cursor cursor = mDb.query(TABLE_TIME, new String[] { COL_ID1,
COL_START_TIME, COL_CLOSE_TIME }, null, null, null, null, null);
if (cursor != null) {
cursor.moveToFirst();
}
return cursor;
}

Devang Vaja 5-Mar-13 1:28am

private final SimpleDateFormat parser = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String dateStr = tvData.getText().toString();
String timeStr = tvHora.getText().toString();

//only save if both fields are non empty
if (!TextUtils.isEmpty(dateStr) && !TextUtils.isEmpty(timeStr)) {
try {
Date d = parser.parse(dateStr + " " + timeStr);
ContentValues valor = new ContentValues();
valor.put("mensagenssalvas", d.getTime());
db.insert("mensagens", null, valor);
} catch(ParseException ex) {
Log.e("YOURTAG", "Error parsing date", ex);
}
} else {
Log.d("YOURTAG", "Both fields not present, can't save");
}
use this

Varsha Bhatia 5-Mar-13 1:32am

sir i can insert the record properly but my question is that when i insert it, it display the same time in both the fields STARTTIME & CLOSETIME.Both have same values which is closetime. In form it display properly but in database it display the same time.

Devang Vaja 5-Mar-13 1:36am

oh...have you debug the code?
befor inserting check which values are going in db...

Devang Vaja 5-Mar-13 1:32am

sollution ho jaye to batana..

Varsha Bhatia 5-Mar-13 1:33am

sir i am using this class for formating the time

public class TimeDataFormate
{

private TimeDataFormate(){}

public static final String TIME_FORMAT = "HHmmss";
private static final SimpleDateFormat timeFormat = new SimpleDateFormat(TIME_FORMAT);

public static long formatDateAsLong(Calendar cal){
return Long.parseLong(timeFormat.format(cal.getTime()));
}

public static Calendar getCalendarFromFormattedLong(long l){
try {
Calendar c = Calendar.getInstance();
c.setTime(timeFormat.parse(String.valueOf(l)));
return c;

} catch (ParseException e) {
return null;
}
}

public static long getNowFormattedLong(){
return TimeDataFormate.formatDateAsLong(Calendar.getInstance());
}

}

Varsha Bhatia 5-Mar-13 1:35am

In mainActivity i am using this code..
btnCloseTime.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
showEndTimePicker();
}
});

Varsha Bhatia 5-Mar-13 1:36am

it calls showEndTimePicker..like this.
private void showEndTimePicker() {
Log.i("endtimepicker","start");
TimePickerDialog tdialog2;
if (mTimeClose == null) {
final Calendar c = Calendar.getInstance();

tdialog2 = new TimePickerDialog(this, mTimeEndSetListener,
c.get(Calendar.HOUR_OF_DAY), c.get(Calendar.MINUTE), true);

} else {
tdialog2 = new TimePickerDialog(this, mTimeEndSetListener,
mTimeClose.get(Calendar.HOUR_OF_DAY),
mTimeClose.get(Calendar.MINUTE), true);
}
tdialog2.show();
Log.i("endtimepicker","end");
}

Varsha Bhatia 5-Mar-13 1:39am

calls the mTimeEndSetListener...

private TimePickerDialog.OnTimeSetListener mTimeEndSetListener = new TimePickerDialog.OnTimeSetListener() {
@Override
public void onTimeSet(TimePicker view, int hourOfDay, int minute) {

Log.i("EndListener","endlistenerstart");
Calendar c = Calendar.getInstance();
c.set(Calendar.HOUR_OF_DAY, hourOfDay);
c.set(Calendar.MINUTE, minute);
mDbHelper1.updateTimeRecord(timeId, c);
mListCursor1.requery();
mListCursor1.moveToFirst();
populateEndTime();
}
};

Varsha Bhatia 5-Mar-13 1:40am

it calls the populateEndTime.....

private void populateEndTime() {
Log.i("populate","start-time-end");
String time = null;
if (mListCursor1 != null && mListCursor1.getCount() > 0) {
timeId = mListCursor1.getLong(mListCursor1
.getColumnIndex(DbAdapter.COL_ID1));
long d = mListCursor1.getLong(mListCursor1
.getColumnIndex(DbAdapter.COL_CLOSE_TIME));
if (d > 0) {
mTimeClose = TimeDataFormate.getCalendarFromFormattedLong(d);
time = TimeDisplayFormat.getFormattedTime(mTimeClose);
}
}
if (time != null) {
close_time.setText(time);
}
Log.i("populate","end-time-end");
}

Varsha Bhatia 5-Mar-13 1:41am

sir here i write the complete code for the endtime likewise i used for start time..same but the name was different..

Devang Vaja 5-Mar-13 1:53am

ya your code is seems to be ok but somewhere instance of start_date is calling by you...i dont know where but problem is that..
actually i am .net developer but trying to help you

Varsha Bhatia 5-Mar-13 1:57am

ok sir..

Devang Vaja 5-Mar-13 2:00am

try out with debug you will definately success

Varsha Bhatia 5-Mar-13 2:04am

ok sir

Devang Vaja 5-Mar-13 2:06am

tell me when you success

Devang Vaja 5-Mar-13 4:12am

hello thai gayu k nai solve?

Varsha Bhatia 5-Mar-13 4:41am

sir slove that but the problem is when i click the starttime first and after close time, the database is store only closetime value in both the field and when i choose close button first and the choos the start button ,in database it stores the start button value in both the field...wwhat is the solution of this?

Devang Vaja 5-Mar-13 4:43am

Not sir yar friend

Varsha Bhatia 5-Mar-13 4:45am

ok but i want a solution only if you have then help

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)