private void btnImportGlobalPositions_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog opf = new OpenFileDialog();
if (opf.ShowDialog().Value == true)
{
Excel.Worksheet xlsheet;
Excel.Workbook xlwkbook;
xlwkbook = (Excel.Workbook)System.Runtime.InteropServices.Marshal.BindToMoniker(opf.FileName);
xlsheet = (Excel.Worksheet)xlwkbook.ActiveSheet;
Excel.Range oRng;
for (int i = 2; i < 48; i++)
{
HR_GlobalPositions pos = new HR_GlobalPositions();
//name
string gstr;
oRng = (Excel.Range)xlsheet.Cells[i, 1];
try
{
gstr = oRng.get_Value(Missing.Value).ToString();
}
catch (System.NullReferenceException)
{
continue;
}
if (gstr == "")
{
continue;
}
pos.Name = gstr;
oRng = (Excel.Range)xlsheet.Cells[i, 6];
try
{
gstr = oRng.get_Value(Missing.Value).ToString();
}
catch (System.NullReferenceException)
{
continue;
}
if (gstr == "")
{
continue;
}
pos.id_positionType = int.Parse(gstr);
pos.IsActive = true;
pos.ActiveFrom = DateTime.Now;
using (var logic = new NomenclaturesLogic())
{
logic.HR_GlobalPositions.Add(pos);
logic.Save();
}
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (var logic = new NomenclaturesLogic())
{
if (this.id_globalPosition == 0)
{
this.globalPosition = new HR_GlobalPositions();
this.globalPosition.IsActive = true;
this.globalPosition.ActiveFrom = DateTime.Now;
}
else
{
this.globalPosition = logic.HR_GlobalPositions.GetById(this.id_globalPosition);
}
using (var comboBoxLogic = new ComboBoxLogic())
{
this.cmbPositionTypes.ItemsSource = comboBoxLogic.ReadPositionTypes(this.globalPosition.id_globalPosition);
}
this.DataContext = this.globalPosition;
}
}