private Parametro GetByPK(Constants.Parametros id) { DbConnection connection = this.instance.CreateConnection(); Parametro objToLoad = new Parametro(); try { connection.Open(); DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_GET_PARAMETRO_BY_PK"); storedProcCommand.Connection = connection; this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)Convert.ToInt32((object)id)); DbDataAdapter dataAdapter = this.instance.GetDataAdapter(); DataTable dataTable = new DataTable(); dataAdapter.SelectCommand = storedProcCommand; dataAdapter.Fill(dataTable); if (dataTable.Rows.Count > 0) { this.LoadFromDataRow(ref objToLoad, dataTable.Rows[0]); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } finally { connection.Close(); } return(objToLoad); }
protected void rgData_UpdateCommand(object sender, GridCommandEventArgs e) { Parametro objEntity = new Parametro(); ParametroBll objBll = new ParametroBll(); Constants.Parametros idParametro = (Constants.Parametros)Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"]); objEntity = objBll.Load(idParametro); GridEditableItem editItem = (GridEditableItem)e.Item; Hashtable updatedValues = new Hashtable(); e.Item.OwnerTableView.ExtractValuesFromItem(updatedValues, editItem); objEntity.Valor = updatedValues["VALOR"].ToString(); objEntity.IdUltimaModificacion = this.IdUserCurrent; objEntity.FechaUltimaModificacion = DateTime.Now; if (!objBll.Update(objEntity)) { RadScriptManager.RegisterClientScriptBlock(this, this.GetType(), "errUpd", "alert('Se ha presentado el siguiente error al actualizar la variable:\\n\\n" + Utilidades.AjustarMensajeError(objBll.Error) + "');", true); } else { this.rgData.EditIndexes.Clear(); this.rgData.Rebind(); } }
public Parametro Load(Constants.Parametros id) { ParametroDao parametroDao = new ParametroDao(); Parametro parametro = parametroDao.Load(id); this.error = parametroDao.Error; return(parametro); }
public DataTable GetList(Constants.Parametros id, bool showAllId, string nombre) { ParametroDao parametroDao = new ParametroDao(); DataTable list = parametroDao.GetList(id, showAllId, nombre); this.error = parametroDao.Error; return(list); }
public List <Parametro> GetParametros( Constants.Parametros id, bool showAllId, string nombre) { ParametroDao parametroDao = new ParametroDao(); List <Parametro> parametros = parametroDao.GetParametros(id, showAllId, nombre); this.error = parametroDao.Error; return(parametros); }
public DataTable GetList(Constants.Parametros id, bool showAllId, string nombre) { DataTable dtEstructure = ParametroDao.DtEstructure; try { DbConnection connection = this.instance.CreateConnection(); try { connection.Open(); DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_PARAMETRO_GET_LIST"); storedProcCommand.Connection = connection; if (!showAllId) { this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)Convert.ToInt32((object)id)); } else { this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)DBNull.Value); } if (nombre != string.Empty) { this.instance.AddInParameter(storedProcCommand, "@NOMBRE", DbType.String, (object)nombre); } else { this.instance.AddInParameter(storedProcCommand, "@NOMBRE", DbType.String, (object)DBNull.Value); } DbDataAdapter dataAdapter = this.instance.GetDataAdapter(); dataAdapter.SelectCommand = storedProcCommand; dataAdapter.Fill(dtEstructure); } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } finally { connection.Close(); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } return(dtEstructure); }
public List <Parametro> GetParametros( Constants.Parametros id, bool showAllId, string nombre) { List <Parametro> parametroList = new List <Parametro>(); try { foreach (DataRow row in (InternalDataCollectionBase)this.GetList(id, showAllId, nombre).Rows) { Parametro objToLoad = new Parametro(); this.LoadFromDataRow(ref objToLoad, row); parametroList.Add(objToLoad); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } return(parametroList); }
public Parametro Load(Constants.Parametros id) => this.GetByPK(id);