// 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());
}
