public async Task <ActionResult> DeleteConfirmed(int id)
{
DisciplineSet disciplineSet = await db.DisciplineSet.FindAsync(id);
db.DisciplineSet.Remove(disciplineSet);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public static void deleteDisciplineSet(DisciplineSet disciplineSet)
{
executeSql(""
+ "DELETE FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + " = " + disciplineSet.DisciplineSetId + " "
+ "LIMIT 1"
);
}
public static void deleteDisciplineSet(DisciplineSet disciplineSet)
{
executeSql(""
+ "DELETE FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + " = " + disciplineSet.DisciplineSetId + " "
+ "LIMIT 1"
);
}
public async Task <ActionResult> Edit([Bind(Include = "DisciplineId,TitleDiscipline")] DisciplineSet disciplineSet)
{
if (ModelState.IsValid)
{
db.Entry(disciplineSet).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(disciplineSet));
}
public static void deleteCompetitionDisciplineSetRelation(Competition competition, DisciplineSet disciplineSet)
{
executeSql(""
+ "DELETE FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_competitionId + " = " + competition.CompetitionId + " "
+ "AND `" + field_disciplineSetId + " = " + disciplineSet.DisciplineSetId + " "
+ "LIMIT 1"
);
}
public async Task <ActionResult> Create([Bind(Include = "DisciplineId,TitleDiscipline")] DisciplineSet disciplineSet)
{
if (ModelState.IsValid)
{
db.DisciplineSet.Add(disciplineSet);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(disciplineSet));
}
private void SetPrepod_Click(object sender, RoutedEventArgs e)
{
StudentStatisticsEDMContainer studentStatisticsEDMContainer = new StudentStatisticsEDMContainer();
var descipline = new DisciplineSet
{
Name = name.Text,
Kafedra = kafedra.Text
};
studentStatisticsEDMContainer.DisciplineSetSet.Add(descipline);
studentStatisticsEDMContainer.SaveChanges();
}
public static void createCompetitionDisciplineSetRelation(Competition competition, DisciplineSet disciplineSet)
{
executeSql(""
+ "INSERT INTO "
+ "`" + tableName + "` "
+ "("
+ "`" + field_competitionId + "`,"
+ "`" + field_disciplineSetId + "`"
+ ") VALUES ("
+ competition.CompetitionId + ","
+ disciplineSet.DisciplineSetId
+ ")"
);
}
// GET: Disciplines/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DisciplineSet disciplineSet = await db.DisciplineSet.FindAsync(id);
if (disciplineSet == null)
{
return(HttpNotFound());
}
return(View(disciplineSet));
}
public static void updateDisciplineSet(DisciplineSet disciplineSet)
{
// Implement if there are any updateable fields available
/*this.executeSql(""
+ "UPDATE "
+ "`" + tableName + "` "
+ "SET "
+ "`" + field_name + "` = " + discipline.Name + ", "
+ "`" + field_measureId + "` = " + discipline.Measure.MeasureId + ", "
+ "`" + field_categoryId + "` = " + discipline.Category.CategoryId + " "
+ "WHERE "
+ "`" + field_disciplineId + " = " + discipline.DisciplineId
+ );*/
}
public static bool relationExists(DisciplineSet disciplineSet, Discipline discipline)
{
Dictionary <string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId + " "
+ "AND `" + field_disciplineId + "` = " + discipline.DisciplineId
);
if (result.Count == 1)
{
return(true);
}
return(false);
}
public static List<Discipline> getDisciplinesByDisciplineSet(DisciplineSet disciplineSet)
{
List<Dictionary<string, object>> results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId
);
List<Discipline> disciplines = new List<Discipline>();
foreach (var row in results)
{
disciplines.Add(DisciplineProvider.getDisciplineById(Convert.ToInt32(row[field_disciplineId])));
}
return disciplines;
}
public static List <Discipline> getDisciplinesByDisciplineSet(DisciplineSet disciplineSet)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId
);
List <Discipline> disciplines = new List <Discipline>();
foreach (var row in results)
{
disciplines.Add(DisciplineProvider.getDisciplineById(Convert.ToInt32(row[field_disciplineId])));
}
return(disciplines);
}
public static List<Competition> getCompetitionsByDisciplineSet(DisciplineSet disciplineSet)
{
List<Dictionary<string, object>> results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId
);
List<Competition> competitions = new List<Competition>();
foreach (var row in results)
{
competitions.Add(CompetitionProvider.getCompetitionById(Convert.ToInt32(row[field_competitionId])));
}
return competitions;
}
public static DisciplineSet getDisciplineSetById(int disciplineSetId)
{
Dictionary <string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSetId
);
if (result == null)
{
return(null);
}
DisciplineSet disciplineSet = new DisciplineSet(
Convert.ToInt32(result[field_disciplineSetId])
);
foreach (Discipline discipline in DisciplineSetDisciplineMappingProvider.getDisciplinesByDisciplineSet(disciplineSet))
{
disciplineSet.addDiscipline(discipline);
}
foreach (Competition competition in CompetitionProvider.getCompetitionsByDisciplineSet(disciplineSet))
{
disciplineSet.addCompetition(competition);
}
foreach (DisciplineSetDisciplineMapping disciplineSetDisciplineMapping in DisciplineSetDisciplineMappingProvider.getDisciplineSetDisciplineMappingsByDisciplineSet(disciplineSet))
{
disciplineSet.addDisciplineSetDisciplineMapping(disciplineSetDisciplineMapping);
}
return(disciplineSet);
}
public static void createCompetitionDisciplineSetRelation(Competition competition, DisciplineSet disciplineSet)
{
executeSql(""
+ "INSERT INTO "
+ "`" + tableName + "` "
+ "("
+ "`" + field_competitionId + "`,"
+ "`" + field_disciplineSetId + "`"
+ ") VALUES ("
+ competition.CompetitionId + ","
+ disciplineSet.DisciplineSetId
+ ")"
);
}
public void addDisciplineSet(DisciplineSet disciplineSet)
{
this.disciplineSets.Add(disciplineSet);
}
public static List <Discipline> getDisciplinesByDisciplineSetId(DisciplineSet disciplineSet)
{
return(DisciplineSetDisciplineMappingProvider.getDisciplinesByDisciplineSet(disciplineSet));
}
public void removeDisciplineSet(DisciplineSet disciplineSet)
{
this.disciplineSets.Remove(disciplineSet);
}
public static List <Competition> getCompetitionsByDisciplineSet(DisciplineSet disciplineSet)
{
return(CompetitionDisciplineSetProvider.getCompetitionsByDisciplineSet(disciplineSet));
}
public static bool relationExists(Competition competition, DisciplineSet disciplineSet)
{
Dictionary<string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_competitionId + "` = " + competition.CompetitionId + " "
+ "AND `" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId
);
if (result.Count == 1)
{
return true;
}
return false;
}
public static void deleteCompetitionDisciplineSetRelation(Competition competition, DisciplineSet disciplineSet)
{
executeSql(""
+ "DELETE FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_competitionId + " = " + competition.CompetitionId + " "
+ "AND `" + field_disciplineSetId + " = " + disciplineSet.DisciplineSetId + " "
+ "LIMIT 1"
);
}
public static List <DisciplineSetDisciplineMapping> getDisciplineSetDisciplineMappingsByDisciplineSet(DisciplineSet disciplineSet)
{
List <Dictionary <string, object> > results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId
);
List <DisciplineSetDisciplineMapping> disciplineSetDisciplineMappings = new List <DisciplineSetDisciplineMapping>();
foreach (var row in results)
{
disciplineSetDisciplineMappings.Add(getDisciplineSetDisciplineMappingByPrimaryKey(
Convert.ToInt32(row[field_disciplineSetId]),
Convert.ToInt32(row[field_ageFrom]),
Convert.ToInt32(row[field_ageUntil]),
Convert.ToInt32(row[field_disciplineId])
));
}
return(disciplineSetDisciplineMappings);
}
public static void updateDisciplineSet(DisciplineSet disciplineSet)
{
// Implement if there are any updateable fields available
/*this.executeSql(""
+ "UPDATE "
+ "`" + tableName + "` "
+ "SET "
+ "`" + field_name + "` = " + discipline.Name + ", "
+ "`" + field_measureId + "` = " + discipline.Measure.MeasureId + ", "
+ "`" + field_categoryId + "` = " + discipline.Category.CategoryId + " "
+ "WHERE "
+ "`" + field_disciplineId + " = " + discipline.DisciplineId
);*/
}
public static List<Competition> getCompetitionsByDisciplineSet(DisciplineSet disciplineSet)
{
return CompetitionDisciplineSetProvider.getCompetitionsByDisciplineSet(disciplineSet);
}
public static DisciplineSet getDisciplineSetById(int disciplineSetId)
{
Dictionary<string, object> result = querySingleSql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSetId
);
if (result == null)
{
return null;
}
DisciplineSet disciplineSet = new DisciplineSet(
Convert.ToInt32(result[field_disciplineSetId])
);
foreach (Discipline discipline in DisciplineSetDisciplineMappingProvider.getDisciplinesByDisciplineSet(disciplineSet))
{
disciplineSet.addDiscipline(discipline);
}
foreach (Competition competition in CompetitionProvider.getCompetitionsByDisciplineSet(disciplineSet))
{
disciplineSet.addCompetition(competition);
}
foreach (DisciplineSetDisciplineMapping disciplineSetDisciplineMapping in DisciplineSetDisciplineMappingProvider.getDisciplineSetDisciplineMappingsByDisciplineSet(disciplineSet))
{
disciplineSet.addDisciplineSetDisciplineMapping(disciplineSetDisciplineMapping);
}
return disciplineSet;
}
public static List<Discipline> getDisciplinesByDisciplineSetId(DisciplineSet disciplineSet)
{
return DisciplineSetDisciplineMappingProvider.getDisciplinesByDisciplineSet(disciplineSet);
}
public static List<DisciplineSetDisciplineMapping> getDisciplineSetDisciplineMappingsByDisciplineSetAndDiscipline(DisciplineSet disciplineSet, Discipline discipline)
{
List<Dictionary<string, object>> results = querySql(""
+ "SELECT "
+ "* "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_disciplineSetId + "` = " + disciplineSet.DisciplineSetId + " "
+ "AND `" + field_disciplineId + "` = " + discipline.DisciplineId
);
List<DisciplineSetDisciplineMapping> disciplineSetDisciplineMappings = new List<DisciplineSetDisciplineMapping>();
foreach (var row in results)
{
disciplineSetDisciplineMappings.Add(getDisciplineSetDisciplineMappingByPrimaryKey(
Convert.ToInt32(row[field_disciplineSetId]),
Convert.ToInt32(row[field_ageFrom]),
Convert.ToInt32(row[field_ageUntil]),
Convert.ToInt32(row[field_disciplineId])
));
}
return disciplineSetDisciplineMappings;
}
