public static List <Tuple <string, HourModel> > GetAllHourInBoard(int boardid)
{
List <Tuple <string, HourModel> > entries = new List <Tuple <string, HourModel> >();
using SqliteConnection db = new SqliteConnection("Filename=ImaginaryNumberSpace.db");
db.Open();
SqliteCommand selectCommand = new SqliteCommand("SELECT * from HourTable WHERE BoardID = @BoardID", db);
selectCommand.Parameters.AddWithValue("@BoardID", boardid);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
HourModel hourfortag = new HourModel
{
Tag = query.GetString(3),
Hours = query.GetFloat(4),
};
entries.Add(new Tuple <string, HourModel>(query.GetString(2), hourfortag));
}
db.Close();
return(entries);
}
private void Valider_Click(object sender, RoutedEventArgs e)
{
if (ComboDays.SelectedItem == null || ComboHours.SelectedItem == null || ComboDuree.SelectedItem == null)
{
return;
}
string day = ComboDays.SelectedItem as string;
Days dayChoosed = GetDayByStr(day);
HourModel hour = ComboHours.SelectedItem as HourModel;
DureeModel duree = ComboDuree.SelectedItem as DureeModel;
string libelleAffiche = TxtBoxLibelle.Text;
Creneau creneauChoosed = new Creneau()
{
Activite = DataManager.Instance.ActiviteChoosed,
Classe = CurrentClasse,
Jour = dayChoosed,
Duree = duree,
Hour = hour,
Column = ColumnSpanType.Full,
LibelleAffiche = string.IsNullOrEmpty(libelleAffiche) ? CurrentClasse.Libelle : libelleAffiche,
ConflitCreneauId = 0
};
CreneauChoosed?.Invoke(this, creneauChoosed);
}
void CreateDetailsAsync()
{
HourModel hour = _place.GetHourOfDay(dpDate.Date.DayOfWeek);
_startHour = hour.HourStart.Hour;
_endHour = hour.HourEnd.Hour;
gridDetail.RowDefinitions.Clear();
gridDetail.ColumnDefinitions.Clear();
_hourToShow = DateTime.Now.Hour;
if (_binding.Pitches.Count <= 3)
{
_rowsToShow = 7;
}
AddDetail(true);
}
private void Valider_Click(object sender, RoutedEventArgs e)
{
if (ComboDays.SelectedItem == null ||
ComboHours.SelectedItem == null ||
ComboDuree.SelectedItem == null ||
string.IsNullOrEmpty(TxtBoxLibelle.Text) ||
LstClasses.SelectedItems.Count == 0)
{
return;
}
string day = ComboDays.SelectedItem as string;
Days dayChoosed = GetDayByStr(day);
HourModel hour = ComboHours.SelectedItem as HourModel;
DureeModel duree = ComboDuree.SelectedItem as DureeModel;
string libelleAffiche = TxtBoxLibelle.Text;
List <Classe> lstClasse = new List <Classe>();
lstClasse.AddRange(LstClasses.SelectedItems.Cast <Classe>());
Creneau creneauChoosed = new Creneau()
{
Activite = DataManager.Instance.ActiviteChoosed,
//Classe = CurrentClasse,
ListClass_Custom = lstClasse,
Jour = dayChoosed,
Duree = duree,
Hour = hour,
Column = ColumnSpanType.Full,
LibelleAffiche = libelleAffiche,
ConflitCreneauId = 0
};
LstClasses.SelectedItem = null;
CreneauChoosed?.Invoke(this, creneauChoosed);
}
public PlaceViewModel(Page page, PlaceModel place) : base(page)
{
Place = place;
_hourOfDay = place.GetHourOfDay();
FindCommand = new Command(async() => { await OpenPageAsync(new FindCourtView()); });
OpenMapCommand = new Command(async() => { await OpenPageAsync(new MapView(_place)); });
ShowTimesCommand = new Command(async() =>
{
string[] times = new string[place.Hours.Count];
int count = 0;
foreach (HourModel hour in place.Hours)
{
int numberDay = hour.NumberDay;
if (numberDay == 7)
{
numberDay = 0;
}
string day = null;
if (numberDay == 8)
{
day = T.GetValue("holydays");
}
else
{
day = place.GetDayName(numberDay, DependencyService.Get <ILocalize>().GetCurrentCultureInfo());
}
times[count] = string.Format("{0}: {1:hh:mm tt} - {2:hh:mm tt}", day, hour.HourStart, hour.HourEnd);
count++;
}
await _page.DisplayActionSheet("", T.GetValue("close"), null, times);
});
}
