public static zbs FindZBSByName(string zbsName)
{
zbs result = null;
try
{
if (zbsList == null || zbsList.Count() == 0)
{
if (LoadZBSList() == false)
{
ncLog.Error("FindZBSByName::Unable to load ZBS");
return(result);
}
}
result = zbsList.Where(x => x.nombre == zbsName).FirstOrDefault();
if (result == null)
{
result = new zbs();
result.nombre = zbsName;
}
}
catch (Exception exp)
{
ncLog.Exception("FindZBSByName::" + exp.Message);
}
return(result);
}
private void btLoadZBS_Click(object sender, EventArgs e)
{
try
{
using (OpenFileDialog openFileDialog = new OpenFileDialog())
{
openFileDialog.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
openFileDialog.FilterIndex = 2;
openFileDialog.RestoreDirectory = true;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
//Get the path of specified file
string filePath = openFileDialog.FileName;
txtZBSPath.Text = filePath;
ncLog.Message("ExcelPath:" + filePath);
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
Worksheet sheet = (Worksheet)wb.Sheets["ZBS"];
Range excelRange = sheet.UsedRange;
int nRows = excelRange.Rows.Count;
ncLog.Message("Nº Rows:" + nRows);
foreach (Microsoft.Office.Interop.Excel.Range row in excelRange.Rows)
{
int rowNumber = row.Row;
if (rowNumber != 1) //Headers
{
string[] arrayAG = Util.GetRange("A" + rowNumber + ":G" + rowNumber + "", sheet);
zbs newZBS = new zbs(arrayAG);
if (!newZBS.IsOk())
{
ncLog.Error("LoadZBS::Unable to create ZBS object row number:" + rowNumber);
continue;
}
if (IctusDBManager.NewZBS(newZBS))
{
ncLog.Message("LoadZBS::Inserted row number:" + rowNumber);
}
else
{
ncLog.Message("LoadZBS::Unable to insert row number:" + rowNumber);
}
}
}
}
}
}
catch (Exception exp)
{
ncLog.Exception("LoadZBS::" + exp.Message);
}
}
