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