private void deleteEvent(object sender, RoutedEventArgs e)
{
int Id = int.Parse(((Button)e.Source).Tag.ToString());
events.Remove(events.FirstOrDefault(o => o.Id == Id));
NotesDB.db_deleteEvent(Id);
}
public GroupsView()
{
InitializeComponent();
groups = new ObservableCollection <GroupModel>(NotesDB.db_queryGroups());
this.DataContext = groups;
}
//For Delete Data
public int DeleteDetails(NotesDB Dnotedb)
{
lock (locker)
{
return(con.Delete(Dnotedb));
}
}
public EventsView()
{
InitializeComponent();
events = new ObservableCollection <EventModel>(NotesDB.db_queryEvents());
this.DataContext = events;
}
//For Insert data
public int InsertDetails(NotesDB notesdb)
{
lock (locker)
{
return(con.Insert(notesdb));
}
}
//For Update data
public int UpdateDetails(NotesDB Unotesdb)
{
lock (locker)
{
return(con.Update(Unotesdb));
}
}
private void addGroup(object sender, RoutedEventArgs e)
{
GroupModel g = new GroupModel {
Title = "New Group"
};
NotesDB.db_insertGroup(g);
groups.Add(NotesDB.db_queryGroups().Last());
}
public NotesView()
{
InitializeComponent();
parentGroup = NotesDB.db_queryGroup(NotesDB.currentGroupId);
notes = new ObservableCollection <NoteModel>(NotesDB.db_queryNotes(parentGroup.Id));
this.DataContext = notes;
group_title.Content = parentGroup.Title;
}
private void editEventContent(object sender, KeyEventArgs e)
{
if (e.Key == Key.Return)
{
int Id = int.Parse(((TextBox)e.Source).Tag.ToString());
string newContent = ((TextBox)e.Source).Text;
events.Where(o => o.Id == Id).ToList().ForEach(o => o.Content = newContent);
NotesDB.db_updateEventContent(new EventModel {
Id = Id, Content = newContent
});
}
}
private void editGroupTitle(object sender, KeyEventArgs e)
{
if (e.Key == Key.Return)
{
int Id = int.Parse(((TextBox)e.Source).Tag.ToString());
string newTitle = ((TextBox)e.Source).Text;
groups.Where(o => o.Id == Id).ToList().ForEach(o => o.Title = newTitle);
NotesDB.db_updateGroup(new GroupModel {
Id = Id, Title = newTitle
});
}
}
private void addEvent(object sender, RoutedEventArgs e)
{
Random rn = new Random();
string red = rn.Next(0, 256).ToString("X");
string green = rn.Next(0, 256).ToString("X");
string blue = rn.Next(0, 256).ToString("X");
string color = $"#{red}{green}{blue}";
EventModel eve = new EventModel {
Content = "", Color = color, Date = "DD/MM/YYYY"
};
NotesDB.db_insertEvent(eve);
events.Add(NotesDB.db_queryEvents().Last());
}
private void addNote(object sender, RoutedEventArgs e)
{
Random rn = new Random();
string red = rn.Next(0, 256).ToString("X");
string green = rn.Next(0, 256).ToString("X");
string blue = rn.Next(0, 256).ToString("X");
string color = $"#{red}{green}{blue}";
NoteModel n = new NoteModel {
Content = "", Color = color, GroupID = parentGroup.Id
};
NotesDB.db_insertNote(n);
notes.Add(NotesDB.db_queryNotes(parentGroup.Id).Last());
}
public HomePage()
{
//Here i am passin dbConnectivity
_notesdb = new NotesDB();
_querytable = new QueryTable();
//create button for Add Note
var createButton = new Button {
Text = "Add Note"
};
_lstview = new ListView {
};
//calling item cells
_lstview.ItemTemplate = new DataTemplate(typeof(NoteItemCell));
//CREATIN EVENT
_lstview.ItemSelected += async(sender, e) =>
{
if (e.SelectedItem == null)
{
return;
}
var detail_item = (NotesDB)e.SelectedItem;
var detail_page = new EditPage();
detail_page.BindingContext = detail_item;
await Navigation.PushAsync(detail_page);
((ListView)sender).SelectedItem = null; //using for clear selected bg
};
//Add button event
createButton.Clicked += (object sender, EventArgs e) =>
{
Navigation.PushAsync(new CreatePage());
};
//LAYOUT
var mainLayout = new StackLayout {
};
mainLayout.Children.Add(createButton);
mainLayout.Children.Add(_lstview);
Content = mainLayout;
}
private void editEventDate(object sender, SelectionChangedEventArgs e)
{
int Id = int.Parse(((DatePicker)e.Source).Tag.ToString());
string newDate = ((DatePicker)e.Source).SelectedDate.Value.Date.ToShortDateString();
List <string> date = newDate.Split('/').ToList();
newDate = $"{date[1].PadLeft(2, '0')}/{date[0].PadLeft(2, '0')}/{date[2]}";
int idx = events.IndexOf(events.Where(o => o.Id == Id).FirstOrDefault());
EventModel newEvent = new EventModel
{
Id = events[idx].Id,
Content = events[idx].Content,
Color = events[idx].Color,
Date = newDate
};
events[idx] = newEvent;
NotesDB.db_updateEventDate(new EventModel {
Id = Id, Date = newDate
});
}
public CreatePage()
{
//Here pass DB connectivity
_notesdb = new NotesDB();
_querytable = new QueryTable();
//here i am creating Editor
var noteEditor = new Editor
{
BackgroundColor = Color.White,
VerticalOptions = LayoutOptions.FillAndExpand,
HorizontalOptions = LayoutOptions.FillAndExpand
};
//Here i am creating Button
var saveButton = new Button {
Text = "Save", HorizontalOptions = LayoutOptions.FillAndExpand
};
var cancelButton = new Button {
Text = "Cancel", HorizontalOptions = LayoutOptions.FillAndExpand
};
//Here i am creatin Event
saveButton.Clicked += (object sender, EventArgs e) =>
{
_datetime = DateTime.Now;
try
{
InsertData(noteEditor.Text.ToString(), _datetime.ToString());
//I Creata Display alert
DisplayAlert("Alert", "Save Succesfully...!", "ok");
//Navigate
Navigation.PushAsync(new HomePage());
}
catch (Exception ex)
{
string error = ex.ToString();
DisplayAlert("Opps...!", "Something went wrong.", "Ok");
}
};
//Layout fOR BUTTON
var btnStack = new StackLayout
{
Orientation = StackOrientation.Horizontal,
HorizontalOptions = LayoutOptions.FillAndExpand,
Children =
{
saveButton, cancelButton
}
};
//Button Event for Cancel Button
cancelButton.Clicked += (sender, e) =>
{
var NoteItem = (NotesDB)BindingContext;
this.Navigation.PopAsync();
};
//Stack Layout fOR Editor
Content = new StackLayout
{
VerticalOptions = LayoutOptions.FillAndExpand,
HorizontalOptions = LayoutOptions.FillAndExpand,
Children =
{
noteEditor, btnStack
}
};
}
private void clearEvents(object sender, RoutedEventArgs e)
{
NotesDB.db_deleteAllEvent();
this.DataContext = new GroupModel();
}
public EditPage()
{
//Here i am passin dbConnectivity
_NOTESDB = new NotesDB();
_QUERY = new QueryTable();
//Here i am binding data
var idEntry = new Entry {
};
idEntry.SetBinding(Entry.TextProperty, "id");
idEntry.IsVisible = false;
var noteEntry = new Entry {
};
noteEntry.SetBinding(Entry.TextProperty, "Note");
//Design Button
var updateButton = new Button {
Text = "UPDATE"
};
var DeleteButton = new Button {
Text = "Delete"
};
var CancelButton = new Button {
Text = "Cancel"
};
//creating event for updating data
updateButton.Clicked += (object sender, EventArgs e) =>
{
try
{
_DATETIME = DateTime.Now;
SetNotesDB(idEntry.Text.ToString(), noteEntry.Text.ToString(), _DATETIME.ToString());
_QUERY.UpdateDetails(_NOTESDB);
DisplayAlert("Yes..!!", "Update Successfully.", "Ok");
Navigation.PushAsync(new HomePage());
}
catch (Exception ex)
{
string error = ex.ToString();
DisplayAlert("Oops...!!", "Try After Sometime.", "Ok");
}
};
//Creating Event for Delete
DeleteButton.Clicked += (object sender, EventArgs e) =>
{
try
{
int Id = Convert.ToInt32(idEntry.Text.ToString());
//_QUERY.DeleteDetails(Id);
SetNotesDB(idEntry.Text.ToString(), noteEntry.Text.ToString(), _DATETIME.ToString());
int x = _QUERY.DeleteDetails(_NOTESDB);
DisplayAlert("Alert", "Deleted Succesfully.", "Ok");
Navigation.PushAsync(new HomePage());
}
catch (Exception ex)
{
string error = ex.ToString();
DisplayAlert("Opps...!!", "Something went Wrong", "Ok");
}
};
//Cancel Button Evenet
CancelButton.Clicked += (sender, e) =>
{
var NoteItem = (NotesDB)BindingContext;
this.Navigation.PopAsync();
};
//Layout
var btnStack = new StackLayout
{
HorizontalOptions = LayoutOptions.FillAndExpand,
Orientation = StackOrientation.Horizontal,
Children =
{
updateButton, DeleteButton, CancelButton
}
};
Content = new StackLayout
{
VerticalOptions = LayoutOptions.FillAndExpand,
HorizontalOptions = LayoutOptions.FillAndExpand,
Padding = new Thickness(20),
Children =
{
idEntry, noteEntry, btnStack
}
};
}
