public static Boolean ExecuteSelectDateDetailsTableTaskTime(string dbpath, DateDetailsViewModel dsv, string sql, DateTime dt)
{
// return value true: More button visibie
Boolean ret = false;
SQLiteConnection con = new SQLiteConnection("Data Source=" + dbpath + ";");
con.Open();
SQLiteCommand com = new SQLiteCommand(sql, con);
com.Parameters.Add(sqliteParam(com, "@date", dt.Date.ToString("yyyy-MM-dd HH:mm:ss")));
try
{
SQLiteDataReader sdr = com.ExecuteReader();
int resultCount = 0;
while (sdr.Read() == true)
{
resultCount++;
if (resultCount <= DateDetailsMoreSize)
{
ListDateDetails lds = new ListDateDetails();
lds.Name = (string)sdr["name"];
DateTime utc = DateCalc.SQLiteStringToDateTime((string)sdr["start_date"]);
lds.StartDate = utc.ToLocalTime().ToString("G", System.Globalization.CultureInfo.CurrentCulture);
DateTime utc2 = DateCalc.SQLiteStringToDateTime((string)sdr["end_date"]);
lds.EndDate = utc2.ToLocalTime().ToString("G", System.Globalization.CultureInfo.CurrentCulture);
TimeSpan ts = new TimeSpan((Int64)sdr["duration"]);
lds.Duration = ts.ToString(@"hh\:mm\:ss");
dsv.Entries.Add(lds);
SumTimeSpanDateDetails += ts;
}
else
{
DateDetailsMoreCount += DateDetailsMoreSize;
ret = true;
}
}
sdr.Close();
}
catch (Exception ex)
{
MessageBox.Show("database table select tasktime DateDetails error!\n" + ex.Message);
}
finally
{
con.Close();
}
return(ret);
}
public static Boolean ExecuteSelectTableTaskMemo(string dbpath, TaskMemoViewModel tmv, string sql, Int64 id)
{
// return value true: More button visibie
Boolean ret = false;
SQLiteConnection con = new SQLiteConnection("Data Source=" + dbpath + ";");
con.Open();
SQLiteCommand com = new SQLiteCommand(sql, con);
com.Parameters.Add(sqliteParamInt64(com, "@id", id));
try
{
SQLiteDataReader sdr = com.ExecuteReader();
int resultCount = 0;
while (sdr.Read() == true)
{
resultCount++;
if (resultCount <= TaskMemoMoreSize)
{
ListTaskMemo ltm = new ListTaskMemo();
ltm.Memo = (string)sdr["memo"];
DateTime utc = DateCalc.SQLiteStringToDateTime((string)sdr["date"]);
ltm.Date = utc.ToLocalTime().ToString("G", System.Globalization.CultureInfo.CurrentCulture);
tmv.Memos.Add(ltm);
}
else
{
TaskMemoMoreCount += TaskMemoMoreSize;
ret = true;
}
}
sdr.Close();
}
catch (Exception ex)
{
MessageBox.Show("database table select taskmemo error!\n" + ex.Message);
}
finally
{
con.Close();
}
return(ret);
}
