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;
}
}
}
