public void TestSubjectCodeFromFilename() { Assert.AreEqual("BMEVIAUM963_Gy", XlsLoader.SubjectCodeFromFilename("jegyimport_BMEVIAUM963_Gy_2017_18_1.xlsx")); Assert.AreEqual("BMEVIAUMT00_Gy", XlsLoader.SubjectCodeFromFilename("jegyimport_BMEVIAUMT00_Gy_2017_18_1.xlsx")); Assert.AreEqual("BMEVIAUAL00_AL", XlsLoader.SubjectCodeFromFilename("jegyimport_BMEVIAUAL00_AL_2017_18_1.xlsx")); Assert.AreEqual("BMEVIAUAT00_AGY", XlsLoader.SubjectCodeFromFilename("jegyimport_BMEVIAUAT00_AGY_2017_18_1.xlsx")); Assert.AreEqual("BMEVIAUAL00_L", XlsLoader.SubjectCodeFromFilename("jegyimport_BMEVIAUAL00_L_2017_18_1.xlsx")); }
private void LoadPUData(string fileName) { if (textBox1.Text != "") { XlsLoader xlsLoader = new XlsLoader(fileName); xlsLoader.LoadPUWorkBookFromFile(); List <DepartmentForLoader> departments = new List <DepartmentForLoader>(); foreach (Department dep in XlsLoader.departments) { departments.Add(new DepartmentForLoader { DepartmentName = dep.DepartmentName }); } var bindingList = new BindingList <DepartmentForLoader>(departments); var source = new BindingSource(bindingList, null); dataGridView1.DataSource = source; List <EmployeeForLoader> employees = new List <EmployeeForLoader>(); foreach (Employee emp in XlsLoader.employees) { employees.Add(new EmployeeForLoader { BirthDay = emp.BirthDay, DepartmentName = emp.Department.DepartmentName, DateDismissed = emp.DateDismissed, DateEmployed = emp.DateEmployed, EID = emp.EID, FirstName = emp.FirstName, LastName = emp.LastName, FullNameUk = emp.FullNameUk, IsManager = emp.IsManager, roles = String.Join(", ", XlsLoader.rolesDict[emp.EID]) }); } var bindingList2 = new BindingList <EmployeeForLoader>(employees); var source2 = new BindingSource(bindingList2, null); dataGridView2.DataSource = source2; List <PositionForLoader> positions = new List <PositionForLoader>(); foreach (Position pos in XlsLoader.positions) { positions.Add(new PositionForLoader { TitleUk = pos.TitleUk }); } var bindingList3 = new BindingList <PositionForLoader>(positions); var source3 = new BindingSource(bindingList3, null); dataGridView3.DataSource = source3; uploadStatus = uploadStatus | UploadStatus.FirstFileUploaded; if (uploadStatus == (UploadStatus.FirstFileUploaded | UploadStatus.SecondFileUploaded)) { button7.Enabled = true; } } }
private void button5_Click(object sender, EventArgs e) { XlsLoader xlsLoader = new XlsLoader(textBox3.Text); xlsLoader.LoadEIDWorkBookFromFile(); List <EIDsForLoader> eids = new List <EIDsForLoader>(); foreach (KeyValuePair <string, string> empNewOldEID in XlsLoader.employeeIDs) { eids.Add(new EIDsForLoader { oldEID = empNewOldEID.Key, newEID = empNewOldEID.Value }); } var bindingList8 = new BindingList <EIDsForLoader>(eids); var source8 = new BindingSource(bindingList8, null); dataGridView8.DataSource = source8; button9.Enabled = true; }
private void button3_Click(object sender, EventArgs e) { if (textBox2.Text != "") { XlsLoader xlsLoader = new XlsLoader(textBox2.Text); xlsLoader.LoadBTMWorkBookFromFile(); List <LocationForLoader> locations = new List <LocationForLoader>(); foreach (Location loc in XlsLoader.locations) { locations.Add(new LocationForLoader { Title = loc.Title }); } var bindingList4 = new BindingList <LocationForLoader>(locations); var source4 = new BindingSource(bindingList4, null); dataGridView4.DataSource = source4; List <VisaForLoader> visas = new List <VisaForLoader>(); foreach (Visa visa in XlsLoader.visas) { visas.Add(new VisaForLoader { Days = visa.Days, DueDate = visa.DueDate, EID = visa.VisaOf.EID, Entries = visa.Entries, StartDate = visa.StartDate, VisaType = visa.VisaType }); } var bindingList5 = new BindingList <VisaForLoader>(visas); var source5 = new BindingSource(bindingList5, null); dataGridView5.DataSource = source5; List <PermitForLoader> permits = new List <PermitForLoader>(); foreach (Permit permit in XlsLoader.permits) { permits.Add(new PermitForLoader { EID = permit.PermitOf.EID, EndDate = permit.EndDate, Number = permit.Number, StartDate = permit.StartDate }); } var bindingList6 = new BindingList <PermitForLoader>(permits); var source6 = new BindingSource(bindingList6, null); dataGridView6.DataSource = source6; List <BusinessTripForLoader> businessTrips = new List <BusinessTripForLoader>(); foreach (BusinessTrip businessTrip in XlsLoader.businessTrips) { businessTrips.Add(new BusinessTripForLoader { Comment = businessTrip.Comment, EID = businessTrip.BTof.EID, EndDate = businessTrip.EndDate, LastCRUDedBy = businessTrip.LastCRUDedBy, LocationTitle = businessTrip.Location.Title, Manager = businessTrip.Manager, Responsible = businessTrip.Responsible, StartDate = businessTrip.StartDate, status = businessTrip.Status }); } var bindingList7 = new BindingList <BusinessTripForLoader>(businessTrips); var source7 = new BindingSource(bindingList7, null); dataGridView7.DataSource = source7; uploadStatus = uploadStatus | UploadStatus.SecondFileUploaded; if (uploadStatus == (UploadStatus.FirstFileUploaded | UploadStatus.SecondFileUploaded)) { button7.Enabled = true; } } }