public ClassCollection SelectClass(string procedureName)
{
OpenConnection();
List<ClassTableModal> result = DbConnection.Query<ClassTableModal>(procedureName,
commandType: System.Data.CommandType.StoredProcedure).ToList<ClassTableModal>();
ClassCollection collection = new ClassCollection();
foreach (ClassTableModal modal in result)
{
collection.Add(modal);
}
CloseConnection();
return collection;
}
public BlockTraineeOperationViewModel(TraineeManagementBussiness trainees, TraineeOperationBussiness traineeOperation,
BlockClassManagement blockClasses)
: base(trainees)
{
_traineeOperation = traineeOperation;
_traineeOperation.OperationEnableEvent += Enable;
_blockClasses = blockClasses;
_blockClasses.BlockClassCollection.ForEach(c => ClassCollection.Add(c.ClassName));
_blockClasses.BlockClassChangedEvent += (operation, regularClass, newIndex) =>
{
ClassCollection.Clear();
_blockClasses.BlockClassCollection.ForEach(c => ClassCollection.Add(c.ClassName));
};
ClassComboWidth = 200;
VisRemain = Visibility.Hidden;
}
void GetOuterClasses(ClassCollection classes, IClass curClass)
{
if (curClass != null)
{
foreach (IClass c in curClass.InnerClasses)
{
if (c != null && c.Region != null && c.Region.IsInside(caretLine, caretColumn))
{
if (c != GetInnermostClass())
{
GetOuterClasses(classes, c);
classes.Add(c);
}
break;
}
}
}
}
/// <remarks>
/// Returns all (nestet) classes in which the carret currently is exept
/// the innermost class, returns an empty collection if the carret is in
/// no class or only in the innermost class.
/// the most outer class is the last in the collection.
/// </remarks>
ClassCollection GetOuterClasses()
{
ClassCollection classes = new ClassCollection();
if (cu != null)
{
foreach (IClass c in cu.Classes)
{
if (c != null && c.Region != null && c.Region.IsInside(caretLine, caretColumn))
{
if (c != GetInnermostClass())
{
GetOuterClasses(classes, c);
classes.Add(c);
}
break;
}
}
}
return(classes);
}
public ClassCollection getClass(int line, int station, int department)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
ClassCollection Class = new ClassCollection();
String qry = String.Empty;
qry = @"SELECT id , description FROM class where line={0} and station = {1} and
department={2} ORDER by id";
qry = String.Format(qry, line,station , department);
SqlCommand cmd = new SqlCommand(qry, con);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dr.Close();
cmd.Dispose();
for (int i = 0; i < dt.Rows.Count; i++)
{
Class.Add(new Class(department, (int)dt.Rows[i]["id"], (string)dt.Rows[i]["description"]));
}
con.Close();
con.Dispose();
return Class;
}
void GetOuterClasses(ClassCollection classes, IClass curClass)
{
if (curClass != null) {
foreach (IClass c in curClass.InnerClasses) {
if (c != null && c.Region != null && c.Region.IsInside(caretLine, caretColumn)) {
if (c != GetInnermostClass()) {
GetOuterClasses(classes, c);
classes.Add(c);
}
break;
}
}
}
}
/// <remarks>
/// Returns all (nestet) classes in which the carret currently is exept
/// the innermost class, returns an empty collection if the carret is in
/// no class or only in the innermost class.
/// the most outer class is the last in the collection.
/// </remarks>
ClassCollection GetOuterClasses()
{
ClassCollection classes = new ClassCollection();
if (cu != null) {
foreach (IClass c in cu.Classes) {
if (c != null && c.Region != null && c.Region.IsInside(caretLine, caretColumn)) {
if (c != GetInnermostClass()) {
GetOuterClasses(classes, c);
classes.Add(c);
}
break;
}
}
}
return classes;
}