public ActionResult AddGrades(GradesModel rec)
{
//if (IsExisting(rec.CourseID))
//{
// ViewBag.Error = "<div class='alert alert-danger'> Subject Already added </div>";
// return View();
//}
//else
//{
using (SqlConnection con = new SqlConnection(Dekomori.GetConnection()))
{
con.Open();
string query = @"INSERT INTO Grades VALUES
(@SN,@CourseID,@Grade,@Total)";
using (SqlCommand com = new SqlCommand(query, con))
{
com.Parameters.AddWithValue("@SN", rec.StudentName);
com.Parameters.AddWithValue("@CourseID", rec.CourseID);
com.Parameters.AddWithValue("@Grade", rec.Grade);
com.Parameters.AddWithValue("@Total", DBNull.Value);
com.ExecuteNonQuery();
}
}
return(RedirectToAction("ViewGrades"));
//}
}
public ActionResult AddGrades()
{
GradesModel rec = new GradesModel();
rec.Courses = GetCourses();
return(View(rec));
}
public IActionResult Create(GradesModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
_context.Add(model);
_context.SaveChanges();
return(View("Details", model));
}
public IActionResult Grades(GradesModel model)
{
//this is further validation that if a rule is broken, the person will have to enter different numbers for their grades.
//if the inputs are valid, the grade will be shown and then the person will be redirected to the home page.
if (ModelState.IsValid)
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public async void Run(IBackgroundTaskInstance taskInstance)
{
// Get a deferral, to prevent the task from closing prematurely
// while asynchronous code is still running.
BackgroundTaskDeferral deferral = taskInstance.GetDeferral();
// check for new grades
try {
GradesModel gradesModel = GradesModel.GetInstance();
SettingsModel settingsModel = SettingsModel.GetInstance();
int countNewGrades = await gradesModel.GetNewGradesCount(settingsModel.SNummer, settingsModel.RZLogin);
if (countNewGrades > 0)
{
ToastContent content = new ToastContent()
{
Visual = new ToastVisual()
{
TitleText = new ToastText()
{
Text = countNewGrades + " neue Noten verfügbar!"
}
},
Audio = new ToastAudio()
{
Src = new Uri("ms-winsoundevent:Notification.IM")
}
};
XmlDocument xmlContent = content.GetXml();
var toast = new ToastNotification(xmlContent);
ToastNotificationManager.CreateToastNotifier().Show(toast);
}
}
catch {
Debug.WriteLine("Grades could not be retrieved.");
}
// Inform the system that the task is finished.
deferral.Complete();
}
public IActionResult Grades(GradesModel model)
{
return(View());
}
public IActionResult Create()
{
GradesModel model = new GradesModel();
return(View(model));
}
public IActionResult GradesAdd(GradesModel gradeModel)
{
_context.Set <GradesModel>().Add(gradeModel);
_context.SaveChanges();
return(RedirectToAction("GradesManage", new { id = gradeModel.Id }));
}
async Task LoadGrades()
{
SettingsModel settingsModel = SettingsModel.GetInstance();
GradesModel gradesModel = GradesModel.GetInstance();
GradeObjectsList gradeObjectsList;
// only show if correct user name/password
try {
gradeObjectsList = await gradesModel.GetGrades(settingsModel.SNummer, settingsModel.RZLogin);
}
catch (Exception e) {
Debug.WriteLine(e);
MessageDialog md = new MessageDialog("Ungültiger Benutzername und/oder Passwort in den Einstellungen hinterlegt!");
await md.ShowAsync();
return;
}
if (gradeObjectsList != null)
{
// get all semesters
List <string> semester = new List <string>();
foreach (GradeObject gradeObject in gradeObjectsList.gradeObjects)
{
if (!semester.Contains(gradeObject.Semester))
{
semester.Add(gradeObject.Semester);
}
}
// create as many listviews as there are semester
List <ListView> semesterList = new List <ListView>();
foreach (string s in semester)
{
ListView listView = new ListView();
listView.Name = s;
semesterList.Add(listView);
}
// fill listviews with entries
foreach (ListView listView in semesterList)
{
int i = 0;
foreach (GradeObject gradeObject in gradeObjectsList.gradeObjects)
{
if (gradeObject.Semester == listView.Name)
{
// custom page as ListViewItem template
double grade = double.Parse(gradeObject.PrNote) / 100;
GradesItem gradesItem = new GradesItem();
gradesItem.Tb_title.Text = gradeObject.PrTxt + " (" + gradeObject.PrForm + ")";
gradesItem.Tb_grade.Text = grade.ToString();
gradesItem.Tb_credits.Text = gradeObject.EctsCredits;
/*if (i % 2 == 1)
* gradesItem.Gg.Background = new SolidColorBrush(Colors.LightGray);
* gradesItem.Tb_title.Width = this.ActualWidth * .75;*/
listView.Items.Add(gradesItem);
i++;
}
}
}
// clear listview
ClearListView(mainView);
// add listviews to page
foreach (ListView listView in semesterList)
{
ListViewItem listViewHeader = new ListViewItem();
string year = listView.Name.Substring(0, 4);
string yearPart = listView.Name.Substring(4, 1);
if (yearPart.Equals("1"))
{
listViewHeader.Content = "Sommersemester " + year;
}
else if (yearPart.Equals("2"))
{
listViewHeader.Content = "Wintersemester " + year;
}
listViewHeader.Background = new SolidColorBrush(Colors.LightSteelBlue);
mainView.Items.Add(listViewHeader);
ListViewItem listViewContent = new ListViewItem();
listViewContent.Content = listView;
mainView.Items.Add(listViewContent);
}
mainView.IsItemClickEnabled = true;
mainView.ItemClick += new ItemClickEventHandler(ItemClick);
timestamp.Text = "Stand: " + gradeObjectsList.timestamp.ToLocalTime().ToString();
CollapseOldEntries();
}
}
