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