public data getData(int id, string objectType)
{
if (BaseData.Connection.State == System.Data.ConnectionState.Closed)
{
BaseData.Connection.Open();
}
SqlCeCommand command = new SqlCeCommand("SELECT * from " + objectType + " where id = " + id, BaseData.Connection);
data result = null;
try
{
var reader = command.ExecuteReader();
reader.Read();
if (objectType == "items")
{
result = new Model.data(Convert.ToInt16(reader["id"]), reader["name"].ToString(), reader["description"].ToString());
}
else
{
result = new Model.data(Convert.ToInt16(reader["id"]), reader["pelak"].ToString(), reader["description"].ToString());
result.ownerUserId = Convert.ToInt16(reader["owner_user_id"]);
}
}
catch
{
}
return(result);
}
public SearchByDateViewModel()
{
theDaysBetween = 0;
today = DateTime.Today;
mod = new Model.data();
items = new NamedayData();
onSearchByName = new Command(onSearchByNameClicked);
todaysNameday = new Command(onTodaysNamedayClicked);
onSearchByDate = new Command(onSearchByDateClicked);
}
public TodaysNameDayViewModel()
{
mod = new Model.data();
items = new NamedayData();
onSearchToday();
onSearchByDate = new Command(onSearchByDateClicked);
onSearchByName = new Command(onSearchByNameClicked);
searchToday = new Command(onSearchToday);
}
