private void addNewPlan_Click(object sender, RoutedEventArgs e)
{
bool validationLocationClear = true;
bool validationDateClear = true;
//check location not blank
if (String.IsNullOrEmpty(planLocation.Text))
{
Flyout myFlyout = Resources["validationFlyout"] as Flyout;
myFlyout.ShowAt(planLocation);
if(validationLocationClear == true)
{
validationLocationClear = false;
}
}
else
{
validationLocationClear = true;
}
//Check End Date > Start Date
if(planStartDate.Date.DateTime.Date > planEndDate.Date.DateTime.Date)
{
Flyout dateValidationFlyout = Resources["endDateValidation"] as Flyout;
dateValidationFlyout.ShowAt(planStartDate);
if(validationDateClear == true)
{
validationDateClear = false;
}
}
else
{
validationDateClear = true;
}
if(validationLocationClear == true & validationDateClear ==true)
{
if (String.IsNullOrEmpty(planBudget.Text))
{
planBudget.Text = "0";
}
Plans plan = new Plans(planStartDate.Date.DateTime, planEndDate.Date.DateTime,
planLocation.Text, Convert.ToDouble(planBudget.Text));
Sqlite sqlData = new Sqlite();
sqlData.conn.Insert(plan);
//plan.SetPlanDetails(planStartDate.Date.DateTime, planEndDate.Date.DateTime, planLocation.Text, Convert.ToDouble(planBudget.Text));
Frame.Navigate(typeof(PlanDetails), plan);
}
}
//public static ObservableCollection<Days> getDayList(DateTime startDate, DateTime endDate)
//{
// var dayList = new ObservableCollection<Days>();
// //int maxDay = CalculateMaxDay(startDate, endDate);
// //for (int i = 1; i <= maxDay; i++)
// //{
// //dayList.Add(new Days("No Activities on this day!", "Day " +i.ToString()));
// //}
// return dayList;
//}
public static TableQuery<Days> getDayList(Plans p)
{
Sqlite sqlData = new Sqlite();
var queryDay = from d in sqlData.conn.Table<Days>()
where d.PlanID_FK.Equals(p.PlanID)
select d;
//int maxDay = CalculateMaxDay(startDate, endDate);
//for (int i = 1; i <= maxDay; i++)
//{
//dayList.Add(new Days("No Activities on this day!", "Day " +i.ToString()));
//}
return queryDay;
}