// GET: Stundenplan public ActionResult Index() { //var stundenplan = Stundenplan.GetMockupDaten(); var stundenplan = Stundenplan.get(); return(View(stundenplan)); }
public EditStundenplan() { InitializeComponent(); btn_set.Clicked += Btn_set_Clicked; btn_back.Clicked += Btn_back_Clicked; if (ClassDataSafe.Stundenplan != "") { Stundenplan sp = JsonConvert.DeserializeObject <Stundenplan>(ClassDataSafe.Stundenplan); monday_1.Text = sp.stunden[0, 0]; monday_2.Text = sp.stunden[0, 1]; monday_3.Text = sp.stunden[0, 2]; monday_4.Text = sp.stunden[0, 3]; monday_5.Text = sp.stunden[0, 4]; monday_6.Text = sp.stunden[0, 5]; monday_7.Text = sp.stunden[0, 6]; monday_8.Text = sp.stunden[0, 7]; tuesday_1.Text = sp.stunden[1, 0]; tuesday_2.Text = sp.stunden[1, 1]; tuesday_3.Text = sp.stunden[1, 2]; tuesday_4.Text = sp.stunden[1, 3]; tuesday_5.Text = sp.stunden[1, 4]; tuesday_6.Text = sp.stunden[1, 5]; tuesday_7.Text = sp.stunden[1, 6]; tuesday_8.Text = sp.stunden[1, 7]; wednesday_1.Text = sp.stunden[2, 0]; wednesday_2.Text = sp.stunden[2, 1]; wednesday_3.Text = sp.stunden[2, 2]; wednesday_4.Text = sp.stunden[2, 3]; wednesday_5.Text = sp.stunden[2, 4]; wednesday_6.Text = sp.stunden[2, 5]; wednesday_7.Text = sp.stunden[2, 6]; wednesday_8.Text = sp.stunden[2, 7]; thursday_1.Text = sp.stunden[3, 0]; thursday_2.Text = sp.stunden[3, 1]; thursday_3.Text = sp.stunden[3, 2]; thursday_4.Text = sp.stunden[3, 3]; thursday_5.Text = sp.stunden[3, 4]; thursday_6.Text = sp.stunden[3, 5]; thursday_7.Text = sp.stunden[3, 6]; thursday_8.Text = sp.stunden[3, 7]; friday_1.Text = sp.stunden[4, 0]; friday_2.Text = sp.stunden[4, 1]; friday_3.Text = sp.stunden[4, 2]; friday_4.Text = sp.stunden[4, 3]; friday_5.Text = sp.stunden[4, 4]; friday_6.Text = sp.stunden[4, 5]; friday_7.Text = sp.stunden[4, 6]; friday_8.Text = sp.stunden[4, 7]; } }
public IActionResult Get(int sessionID, int filter) { try { var spSessionID = new SqlParameter("i_SessionID", sessionID); var spFilter = new SqlParameter("i_Filter", filter); SqlConnection conn = new SqlConnection(_configuration["ConnectionString"]); SqlCommand cmd = new SqlCommand("EXECUTE dbo.pda_Stundenplan @i_SessionID, @i_Filter", conn); cmd.Parameters.Add(spSessionID); cmd.Parameters.Add(spFilter); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds); conn.Close(); Stundenplan result; if (ds.Tables[0].Rows.Count > 0) { result = new Stundenplan() { StundenplanList = new System.Collections.Generic.List <Termine>() }; foreach (DataRow row in ds.Tables[0].Rows) { result.StundenplanList.Add( new Termine() { Fehler = (int)row["Fehler"], FehlerMeldung = (string)row["Fehlermeldung"], Id = (int)row["ID"], Datum = (string)row["Datum"], Zeit = (string)row["Zeit"], Titel = (string)row["Titel"], Code = (string)row["Code"], Bezeichnung = (string)row["Bezeichnung"], Zimmer = (string)row["Zimmer"], Lehrperson = (string)row["Lehrperson"] } ); } } else { result = new Stundenplan(); } return(Ok(result)); } catch (Exception ex) { return(BadRequest(ex.ToString())); } }
private void NavigationHelper_LoadState(object sender, Stundenplan.Common.LoadStateEventArgs e) { this.DataContext = new TimetableSettingsPageViewModel(App.Timetable); }
private void RefreshData() { ControllPanelData.DownloadUserData(); ControllPanelData.DownloadClassData(); uebersicht_txt_Klassenname.Text = ClassDataSafe.ClassName; uebersicht_txt_Beschreibung.Text = ClassDataSafe.Description; uebersicht_txt_Schule.Text = ClassDataSafe.School; profil_txt_email.Text = TCPCommandManager.getEMail(); profil_txt_geschlecht.Text = UserDataSafe.Gender; profil_txt_vorname.Text = UserDataSafe.Firstname; profil_txt_nachname.Text = UserDataSafe.Lastname; if (ClassDataSafe.Stundenplan != "") { Stundenplan sp = JsonConvert.DeserializeObject <Stundenplan>(ClassDataSafe.Stundenplan); monday_1.Text = sp.stunden[0, 0]; monday_2.Text = sp.stunden[0, 1]; monday_3.Text = sp.stunden[0, 2]; monday_4.Text = sp.stunden[0, 3]; monday_5.Text = sp.stunden[0, 4]; monday_6.Text = sp.stunden[0, 5]; monday_7.Text = sp.stunden[0, 6]; monday_8.Text = sp.stunden[0, 7]; tuesday_1.Text = sp.stunden[1, 0]; tuesday_2.Text = sp.stunden[1, 1]; tuesday_3.Text = sp.stunden[1, 2]; tuesday_4.Text = sp.stunden[1, 3]; tuesday_5.Text = sp.stunden[1, 4]; tuesday_6.Text = sp.stunden[1, 5]; tuesday_7.Text = sp.stunden[1, 6]; tuesday_8.Text = sp.stunden[1, 7]; wednesday_1.Text = sp.stunden[2, 0]; wednesday_2.Text = sp.stunden[2, 1]; wednesday_3.Text = sp.stunden[2, 2]; wednesday_4.Text = sp.stunden[2, 3]; wednesday_5.Text = sp.stunden[2, 4]; wednesday_6.Text = sp.stunden[2, 5]; wednesday_7.Text = sp.stunden[2, 6]; wednesday_8.Text = sp.stunden[2, 7]; thursday_1.Text = sp.stunden[3, 0]; thursday_2.Text = sp.stunden[3, 1]; thursday_3.Text = sp.stunden[3, 2]; thursday_4.Text = sp.stunden[3, 3]; thursday_5.Text = sp.stunden[3, 4]; thursday_6.Text = sp.stunden[3, 5]; thursday_7.Text = sp.stunden[3, 6]; thursday_8.Text = sp.stunden[3, 7]; friday_1.Text = sp.stunden[4, 0]; friday_2.Text = sp.stunden[4, 1]; friday_3.Text = sp.stunden[4, 2]; friday_4.Text = sp.stunden[4, 3]; friday_5.Text = sp.stunden[4, 4]; friday_6.Text = sp.stunden[4, 5]; friday_7.Text = sp.stunden[4, 6]; friday_8.Text = sp.stunden[4, 7]; } aufgabenview.ItemsSource = null; aufgabenview.ItemsSource = ControllPanelData.Tasks; terminview.ItemsSource = null; terminview.ItemsSource = ControllPanelData.Termine; // if (ClassDataSafe.Creator.Equals(TCPCommandManager.EMAIL, StringComparison.InvariantCultureIgnoreCase) == false) { profil_btn_einladen.IsVisible = false; uebersicht_btn_klassendatenbearbeiten.IsVisible = false; uebersicht_btn_rechtebearbeiten.IsVisible = false; if (ClassDataSafe.changeStundenplan == false) { stundenplan_btn_edit.IsVisible = false; } if (ClassDataSafe.createAufgabe == false) { btn_newTask.IsVisible = false; } if (ClassDataSafe.createTermin == false) { btn_newTermin.IsVisible = false; } } else { profil_btn_einladen.IsVisible = true; uebersicht_btn_klassendatenbearbeiten.IsVisible = true; uebersicht_btn_rechtebearbeiten.IsVisible = true; stundenplan_btn_edit.IsVisible = true; btn_newTask.IsVisible = true; btn_newTermin.IsVisible = true; } }
private void Btn_set_Clicked(object sender, EventArgs e) { Stundenplan sp = new Stundenplan(); sp.stunden[0, 0] = monday_1.Text; sp.stunden[0, 1] = monday_2.Text; sp.stunden[0, 2] = monday_3.Text; sp.stunden[0, 3] = monday_4.Text; sp.stunden[0, 4] = monday_5.Text; sp.stunden[0, 5] = monday_6.Text; sp.stunden[0, 6] = monday_7.Text; sp.stunden[0, 7] = monday_8.Text; sp.stunden[1, 0] = tuesday_1.Text; sp.stunden[1, 1] = tuesday_2.Text; sp.stunden[1, 2] = tuesday_3.Text; sp.stunden[1, 3] = tuesday_4.Text; sp.stunden[1, 4] = tuesday_5.Text; sp.stunden[1, 5] = tuesday_6.Text; sp.stunden[1, 6] = tuesday_7.Text; sp.stunden[1, 7] = tuesday_8.Text; sp.stunden[2, 0] = wednesday_1.Text; sp.stunden[2, 1] = wednesday_2.Text; sp.stunden[2, 2] = wednesday_3.Text; sp.stunden[2, 3] = wednesday_4.Text; sp.stunden[2, 4] = wednesday_5.Text; sp.stunden[2, 5] = wednesday_6.Text; sp.stunden[2, 6] = wednesday_7.Text; sp.stunden[2, 7] = wednesday_8.Text; sp.stunden[3, 0] = thursday_1.Text; sp.stunden[3, 1] = thursday_2.Text; sp.stunden[3, 2] = thursday_3.Text; sp.stunden[3, 3] = thursday_4.Text; sp.stunden[3, 4] = thursday_5.Text; sp.stunden[3, 5] = thursday_6.Text; sp.stunden[3, 6] = thursday_7.Text; sp.stunden[3, 7] = thursday_8.Text; sp.stunden[4, 0] = friday_1.Text; sp.stunden[4, 1] = friday_2.Text; sp.stunden[4, 2] = friday_3.Text; sp.stunden[4, 3] = friday_4.Text; sp.stunden[4, 4] = friday_5.Text; sp.stunden[4, 5] = friday_6.Text; sp.stunden[4, 6] = friday_7.Text; sp.stunden[4, 7] = friday_8.Text; switch (TCPCommandManager.SetStundenplan(JsonConvert.SerializeObject(sp))) { case 201: DisplayAlert("Erfolgreich", "Stundenplan konnte gespeichert", "OK"); Navigation.PushAsync(new ControllPanel()); Navigation.RemovePage(this); break; default: DisplayAlert("Fehler", "Stundenplan konnte nicht gesetzt werden", "OK"); break; } }
// GET: Stundenplan public ActionResult Index() { ViewBag.stundenplan = Stundenplan.getDaten(); return(View()); }