public static DataTable naplata(termin t, string comboBox1)
{
connect.Open();
SqlDataAdapter sda = new SqlDataAdapter("Select * From termin where ImeiPrezime = '" + comboBox1 + "';", connect);
DataTable dt = new DataTable();
sda.Fill(dt);
connect.Close();
return(dt);
}
private async void Potvrdi_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(DanCombo.Text))
{
MessageBox.Show("Odaberite dan termina.");
return;
}
if (string.IsNullOrWhiteSpace(TimePickerOd.Value.ToString()) || string.IsNullOrWhiteSpace(TimePickerDo.Value.ToString()))
{
MessageBox.Show("Popunite termine.");
return;
}
Func <DateTime?, DateTime?, bool> compare = (a, b) => a?.TimeOfDay.CompareTo(b?.TimeOfDay) > 0;
if (compare(TimePickerOd.Value, TimePickerDo.Value))
{
MessageBox.Show("Termin početka mora biti prije termina završetka.");
return;
}
using (ErsteModel ersteModel = new ErsteModel())
{
termin termin = await ersteModel.termini.FindAsync(item.termin.Id);
if (termin != null)
{
termin.Dan = DanCombo.Text;
if (TimePickerOd.Value != null)
{
termin.Od = TimePickerOd.Value.Value.TimeOfDay;
}
if (TimePickerDo.Value != null)
{
termin.Do = TimePickerDo.Value.Value.TimeOfDay;
}
if (GrupaCombo.Text != "Nije dodijeljena grupa" && !string.IsNullOrWhiteSpace(GrupaCombo.Text))
{
termin.GrupaId = (await ersteModel.grupe.FirstAsync(g => g.Naziv == GrupaCombo.Text)).Id;
}
await ersteModel.SaveChangesAsync();
}
}
Close();
refresh();
}
private void DodavanjeTermina_OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
Func <string, (string, int, int, int, int)> parser = s =>
{
var splittedString = s.Split(' ');
string date = splittedString[1];
var niz = date.Substring(1, date.Length - 2).Split('-');
string[] ar1 = niz[0].Split(':');
string[] ar2 = niz[1].Split(':');
return(splittedString[0],
int.Parse(ar1[0]),
int.Parse(ar1[1]),
int.Parse(ar2[0]),
int.Parse(ar2[1]));
};
if (flag)
{
using (ErsteModel ersteModel = new ErsteModel())
{
if (e.AddedItems.Count > 0)
{
string text = e.AddedItems[0].ToString();
var p = parser(text);
string dan = p.Item1;
int sat1 = p.Item2;
int min1 = p.Item3;
int sat2 = p.Item4;
int min2 = p.Item5;
termin termin = ersteModel.termini.First(t => t.Dan == dan && t.Od.Hours == sat1 && t.Od.Minutes == min1 && t.Do.Hours == sat2 && t.Do.Minutes == min2);
grupa grupica = ersteModel.grupe.Where(gr => gr.Id == grupa.Id).ToList().First();
grupica.termini.Add(termin);
termin.grupa = grupica;
ersteModel.SaveChanges();
Init();
NazivGrupeCombo.Text = text;
}
}
}
}
private void Button1Click(object sender, RoutedEventArgs e)
{
ResetBorderColors();
if (string.IsNullOrWhiteSpace(textBox_NazivGrupe.Text))
{
MessageBox.Show("Odaberite naziv grupe.");
textBox_NazivGrupe.BorderBrush = Brushes.Red;
return;
}
if (string.IsNullOrWhiteSpace(DanCombo.Text))
{
MessageBox.Show("Odaberite dan termina.");
DanCombo.BorderBrush = Brushes.Red;
return;
}
if (string.IsNullOrWhiteSpace(TimePickerOd.Value.ToString()) || string.IsNullOrWhiteSpace(TimePickerDo.Value.ToString()))
{
MessageBox.Show("Popunite termine.");
if (string.IsNullOrWhiteSpace(TimePickerOd.Value.ToString()))
{
TimePickerOd.BorderBrush = Brushes.Red;
}
else
{
TimePickerDo.BorderBrush = Brushes.Red;
}
return;
}
Func <DateTime?, DateTime?, bool> compare = (a, b) => a?.TimeOfDay.CompareTo(b?.TimeOfDay) > 0;
if (compare(TimePickerOd.Value, TimePickerDo.Value))
{
MessageBox.Show("Termin početka mora biti prije termina završetka.");
TimePickerOd.BorderBrush = Brushes.Red;
TimePickerDo.BorderBrush = Brushes.Red;
return;
}
try
{
TimeSpan @od = new TimeSpan();
TimeSpan @do = new TimeSpan();
string dan = "";
if (TimePickerOd.Value == null || TimePickerDo.Value == null || DanCombo.SelectedValue == null)
{
return;
}
dan = DanCombo.Text;
@od = TimePickerOd.Value.Value.TimeOfDay;
@do = TimePickerDo.Value.Value.TimeOfDay;
termin t = new termin()
{
Dan = dan,
Od = @od,
Do = @do,
grupa = Grupa,
GrupaId = Grupa.Id
};
ErsteModel.termini.Add(t);
Grupa.termini.Add(t);
Grupa.Naziv = textBox_NazivGrupe.Text;
ErsteModel.SaveChanges();
MessageBox.Show("Uspješno ste dodali novi termin.");
}
catch (IOException ioException)
{
MessageBox.Show(ioException.StackTrace);
}
Close();
}
