public static void InsertarSubsistemas <T>() where T : class
{
string _pageName = "";
switch (typeof(T).Name)
{
case "T_Subsistema_Area":
_pageName = "SubsistemaArea";
break;
case "T_Subsistema_Tipo":
_pageName = "SubsistemaTipo";
break;
}
var _subAreas = ImportarExcel.GetSubsistema <T>(_pageName);
using (var db = new DB_PLANTILLA())
{
foreach (var item in _subAreas)
{
IList <PropertyInfo> _properties = new List <PropertyInfo>(item.GetType().GetProperties());
dynamic _subsistema = Activator.CreateInstance <T>();
_subsistema.Value = _properties.FirstOrDefault(p => p.Name == "Value").GetValue(item).ToString();
DataBaseController.AddElemento(db, typeof(T), _subsistema);
}
}
}
public static void AdicionarAll <T>() where T : class
{
//ImportarExcel.Singleton();
string _pageName = "";
switch (typeof(T).Name)
{
case "T_Catalogo_Techo":
_pageName = "Techos";
break;
case "T_Catalogo_Pared":
_pageName = "Paredes";
break;
case "T_Catalogo_Rodapie":
_pageName = "Rodapie";
break;
case "T_Catalogo_Suelo":
_pageName = "Suelos";
break;
case "T_Catalogo_Impermeable":
_pageName = "Impermeable";
break;
}
var _workSheet = ImportarExcel.GetWorkSheetByName(_pageName);
var _acabadosName = ImportarExcel.GetAcabadosName(_workSheet);
using (var dbp = new DB_PLANTILLA())
{
foreach (var item in _acabadosName)
{
var _record = ImportarExcel.GetCatalogoRow(item);
IList <PropertyInfo> _properties = new List <PropertyInfo>(_record.GetType().GetProperties());
dynamic _acabado = Activator.CreateInstance(typeof(T));
_acabado.Cod = _properties.FirstOrDefault(p => p.Name == "Cod").GetValue(_record).ToString();
_acabado.CapituloID = _properties.FirstOrDefault(p => p.Name == "Capitulo_ID").GetValue(_record).ToString();
_acabado.Capitulo = _properties.FirstOrDefault(p => p.Name == "Capitulo").GetValue(_record).ToString();
_acabado.Grupo = _properties.FirstOrDefault(p => p.Name == "Grupo").GetValue(_record).ToString();
DataBaseController.AddElemento(dbp, typeof(T), _acabado);
}
}
}
public static void InsertarParametroFloat <T>(int column) where T : class
{
var _records = ImportarExcel.GetColumnValues(column);
var _uniqueRecords = _records.Distinct();
foreach (var item in _uniqueRecords)
{
dynamic _parameter = Activator.CreateInstance(typeof(T));
_parameter.Value = item == "-" ? 0.0f : float.Parse(item);
DataBaseController.AddElemento(new DB_PLANTILLA(), typeof(T), _parameter);
}
}
