private void btnAdd_Click(object sender, RoutedEventArgs e)
{
DateTime start = DateTime.Now;
int rec;
Random rnd = new Random();
string strInsert = " Insert into Customer (Name,Place,Lat, Long, Date, Hour, Status, Priority,Desc) values (@Name,@Place,@Lat,@Long,@Date,@Hour,@Status,@Priority,@Desc)";
for (int i = 0; i < 5; i++)
{
Customer tst = new Customer
{
Name = "Name " + i,
Place = Name + "@" + "aaa.com",
Lat = Name + "@" + "aaa.com",
Long = Name + "@" + "aaa.com",
Date = Name + "@" + "aaa.com",
Hour = Name + "@" + "aaa.com",
Status = Name + "@" + "aaa.com",
Priority = Name + "@" + "aaa.com",
Desc = "Desc for " + i
};
rec = (Application.Current as App).db.Insert < Customer>(tst,strInsert);
}
System.Diagnostics.Debug.WriteLine("\nInserted 5 " + " rows\r\nGenerated in " + (DateTime.Now - start).TotalSeconds);
}
private void bAdd_Click(object sender, EventArgs e)
{
DateTime start = DateTime.Now;
int rec;
App thisApp = App.Current as App;
Random rnd = new Random();
string strInsert = " Insert into Customer (Name,Place,Lat, Long, Date, Hour, Status, Priority,Desc) values (@Name,@Place,@Lat,@Long,@Date,@Hour,@Status,@Priority,@Desc)";
thisApp.ok_set_coord = false;
string spriority = "", splace = "", sdesc = "", status = "off";
if (sPriority.Value.ToString() == "1") spriority = "low";
if (sPriority.Value.ToString() == "2") spriority = "medium";
if (sPriority.Value.ToString() == "3") spriority = "high";
if (tbPlace.Text == "") splace = "Place not set yet.";
else splace = tbPlace.Text;
if (tbDescriere.Text == "") sdesc = "Description not added yet.";
else sdesc = tbDescriere.Text;
if (switch1.IsChecked == true) status = "Yes";
else status = "No";
Customer tst = new Customer
{
Name = tbTaskName.Text + " ",
Place = splace + " ",
Lat = thisApp.Lat.ToString() + " ",
Long = thisApp.Long.ToString() + " ",
Date = datepicker1.Value.ToString() + " ",
Hour = timepicker.Value.ToString() + " ",
Status = status,
Priority = spriority + " ",
Desc = sdesc + " "
};
if (tbTaskName.Text == "") MessageBox.Show("Your task must have a name.");
else
{
rec = (Application.Current as App).db.Insert<Customer>(tst, strInsert);
System.Diagnostics.Debug.WriteLine("\nInserted 5 " + " rows\r\nGenerated in " + (DateTime.Now - start).TotalSeconds);
if (switch1.IsChecked == true) NavigationService.Navigate(new Uri("/AddNotification.xaml", UriKind.RelativeOrAbsolute));
NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.RelativeOrAbsolute));
}
}
private void Save(object sender, EventArgs e)
{
string place, name, lat, Long,date, hour, status,pri, desc;
place = tbWhere.Text;
name = textBlock0.Text;
if (thisApp.Lat != -1000 && thisApp.Long != -1000)
{
lat = thisApp.Lat.ToString();
Long = thisApp.Long.ToString();
}
else
{
lat=Long="-1000";
}
date = datepicker1.Value.ToString();
hour = timepicker.Value.ToString();
status = (switch1.IsChecked == true) ? "Yes" : "No";
pri = slider1.Value.ToString();
desc = tBDescription.Text;
DateTime start = DateTime.Now;
string strDel = " Delete from Customer where ID=" + thisApp.id.ToString();
(Application.Current as App).db.Delete<Customer>(strDel);
System.Diagnostics.Debug.WriteLine("\nDelete last " + " record\r\n in " + (DateTime.Now - start).TotalSeconds);
// rec = (Application.Current as App).db.Insert<Customer>(tst, strInsert);
string strInsert = " Insert into Customer (Name,Place,Lat, Long, Date, Hour, Status, Priority,Desc) values (@Name,@Place,@Lat,@Long,@Date,@Hour,@Status,@Priority,@Desc)";
int rec;
Customer tst = new Customer
{
Name = name,
Place = place,
Lat = lat,
Long = Long,
Date = date,
Hour = hour,
Status = status,
Priority = pri,
Desc = desc
};
rec = (Application.Current as App).db.Insert<Customer>(tst, strInsert);
System.Diagnostics.Debug.WriteLine("\nInserted 5 " + " rows\r\nGenerated in " + (DateTime.Now - start).TotalSeconds);
if (switch1.IsChecked == true) NavigationService.Navigate(new Uri("/AddNotification.xaml", UriKind.RelativeOrAbsolute));
else NavigationService.GoBack();
}