static void Main(string[] args)
{
string dbPath = System.AppDomain.CurrentDomain.BaseDirectory + "/Files/EventDB.db";
//using (var conn = new SQLite.SQLiteConnection(dbPath))
//{
// conn.CreateTable<Event>();
//}
EventDbAccess eventDb = new EventDbAccess(dbPath);
string meridian;
int month;
int hour;
int day;
int minute;
string date;
string time;
Random rnd = new Random();
Event e = new Event();
for (int i = 0; i < 100; i++)
{
month = rnd.Next(6, 13);
day = rnd.Next(1, 31);
hour = rnd.Next(1, 13);
minute = rnd.Next(1, 60);
if (rnd.Next(1, 3) == 1)
{
meridian = "am";
}
else
{
meridian = "pm";
}
date = "2017/" + month.ToString("00") + "/" + day.ToString("00");
time = hour.ToString("00") + ":" + minute.ToString("00") + " " + meridian;
e.name = "Random Event " + i.ToString();
e.date = date;
e.time = time;
e.with = "Bob, Joe, Sue";
e.where = "Lane Community College";
e.extra = "This is a randomly generated event for demonstration purposes.";
e.state = 0;
eventDb.Create(e);
}
List <Event> d = eventDb.RetrieveId(1);
Console.WriteLine(d[0].with);
e = d[0];
e.with = "Joe, Fred, Bob";
eventDb.Update(e);
List <Event> d2 = eventDb.RetrieveId(1);
Console.WriteLine(d2[0].with);
Console.WriteLine();
Console.ReadLine();
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.Edit);
// Create your application here
var nameText = FindViewById <EditText>(Resource.Id.NameText);
var whereText = FindViewById <EditText>(Resource.Id.WhereText);
var withText = FindViewById <EditText>(Resource.Id.WithText);
var extraText = FindViewById <EditText>(Resource.Id.ExtraText);
var date = FindViewById <DatePicker>(Resource.Id.DatePicker);
var time = (TimePicker)FindViewById <TimePicker>(Resource.Id.TimePicker);
var addButton = FindViewById <Button>(Resource.Id.AddButton);
addButton.Text = "Add New Event";
string[] datepart;
string displaydate;
string displaytime;
string[] timepart;
string meridian = "am";
int timehr;
if (Intent.HasExtra("name"))
{
nameText.Text = Intent.GetStringExtra("name");
}
if (Intent.HasExtra("where"))
{
whereText.Text = Intent.GetStringExtra("where");
}
if (Intent.HasExtra("with"))
{
withText.Text = Intent.GetStringExtra("with");
}
if (Intent.HasExtra("extra"))
{
extraText.Text = Intent.GetStringExtra("extra");
}
if (Intent.HasExtra("date"))
{
displaydate = Intent.GetStringExtra("date");
datepart = displaydate.Split('/');
date.UpdateDate(int.Parse(datepart[0]), (int.Parse(datepart[1]) - 1), int.Parse(datepart[2]));
}
if (Intent.HasExtra("time"))
{
displaytime = Intent.GetStringExtra("time");
timepart = displaytime.Split(new char[2] {
':', ' '
});
if (timepart[2] == "pm")
{
timepart[0] += 12;
}
time.Hour = int.Parse(timepart[0]);
time.Minute = int.Parse(timepart[1]);
}
addButton.Click += delegate
{
Event e = new Event();
string dbPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "EventDB.db");
if (!File.Exists(dbPath))
{
using (Stream inStream = Assets.Open("EventDB.db"))
using (Stream outStream = File.Create(dbPath))
inStream.CopyTo(outStream);
}
EventDbAccess eventDb = new EventDbAccess(dbPath);
e.name = nameText.Text;
e.date = date.Year + "/" + (date.Month + 1).ToString("00") + "/" + date.DayOfMonth.ToString("00");
e.where = whereText.Text;
e.with = withText.Text;
e.extra = extraText.Text;
if (time.Hour > 12)
{
timehr = time.Hour - 12; meridian = "pm";
}
else
{
timehr = time.Hour;
}
e.time = timehr.ToString() + ":" + time.Minute + " " + meridian;
eventDb.Create(e);
base.OnBackPressed();
Android.Widget.Toast.MakeText(this, "Added!", Android.Widget.ToastLength.Short).Show();
};
}