public void ResetAll() { IgnoredRow = -1; ExcelColumnPositionService ExServiceNew = new ExcelColumnPositionService(); ListExCol = ExServiceNew.getListCol(); ProgressbarValue = "0"; LblProgress = "0/0"; TxbFileName = string.Empty; }
private void StartUpInitializer() { this.SchoolClasses = new string[] { "V", "VI", "VII", "VIII", "IX", "X", "XI", "XII" }; this.Section = new string[] { "A", "B", "C", "D", "E" }; this.ClsIndex = -1; this.SectionIndex = -1; this.UnSelectedColumnIndex = -1; this.SelectedColumnIndex = -1; this.SYear = DateTime.Today.Year; this.EYear = DateTime.Today.Year; this.Slist = new List <Student>(); PreFilteredList = new List <Student>(); this.FilteredList = new List <Student>(); this.ProgressbarValue = "0/0"; ExcelColumnPositionService exService = new ExcelColumnPositionService(); this.UnSelectedColumns = new ObservableCollection <string>(exService.GetColListForExport()); this.SelectedColumns = new ObservableCollection <string>(); this.db = new ExcelExportDb(); this._flagCanExport = true; this.FilterCategory = "none"; HsArtsSubs = new string[] { "ARABIC", "ECONOMICS", "EDUCATION", "GEOGRAPHY", "PHILOSOPHY", "HISTORY", "POL. SC", "SOCIOLOGY" }; HsSciSubs = new string[] { "PHYSICS", "CHEMISTRY", "MATHEMATICS", "BIOLOGY" }; HsActiveSubs = new string[] { }; HsSubIndex = -1; StreamList = new string[] { "ARTS", "SCIENCE" }; StreamListIndex = -1; SubHsVisibility = System.Windows.Visibility.Hidden; this.MoveRightCommand = new RelayCommand(this.MoveRight, this.CanMoveRight); this.MoveRightAllCommand = new RelayCommand(this.MoveRightAll, this.CanMoveRightAll); this.MoveLeftCommand = new RelayCommand(this.MoveLeft, this.CanMoveLeft); this.MoveLeftAllCommand = new RelayCommand(this.MoveLeftAll, this.CanMoveLeftAll); this.BuildGridViewCommand = new RelayCommand(this.BuildGridView, this.CanBuildGridView); this.ExportCommand = new RelayCommand(this.Export, this.CanExport); }
public ExcelEntryViewModel() : base() { ExService = new ExcelColumnPositionService(); ExcelEntryHelper = new ExcelEntryHelper(); ListExCol = ExService.getListCol(); IgnoredRow = 0; LblProgress = "0/0"; ProgressbarValue = "0"; ClassesInSchool = new string[] { "V", "VI", "VII", "VIII", "IX", "X", "XI", "XII" }; // SectionsInClass = new string[] { "-not applicable-", "A", "B", "C", "D", "E" }; SectionsInClass = new string[] { "-not applicable-" }; SessionStartYear = DateTime.Today.ToString("yyyy"); SessionEndYear = DateTime.Today.ToString("yyyy"); ExDb = new ExcelEntryDb(); _flagCanInsert = true; FileOpenCommand = new RelayCommand(getExcelFile, CanFileBrowse); IncrementIgnoredRowCommand = new RelayCommand(IncrementIgnoredRow, CanIncrementIgnoredRow); DecrementIgnoredRowCommand = new RelayCommand(DecrementIgnoredRow, CanDecrementIgnoredRow); InsertDataCommand = new RelayCommand(InsertData, CanInsertData); ResetCommand = new RelayCommand(ResetAll, CanReset); AbortCommand = new RelayCommand(Abort, CanAbort); }