public eFormulario GetItem(short IdFormulario)
{
SqlCommand cmd = new SqlCommand("pCMS_Formulario_select");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IdFormulario", SqlDbType.SmallInt).Value = IdFormulario;
SqlDataReader reader = ExecuteReader(cmd);
eFormulario oFormulario = null;
if (reader.Read())
{
oFormulario = new eFormulario();
oFormulario.IdFormulario = reader.GetInt16(0);
oFormulario.Descripcion = reader.GetString(1);
oFormulario.Activo = reader.GetBoolean(2);
oFormulario.FechaRegistro = ((!reader[3].Equals(DBNull.Value)) ? reader.GetDateTime(3) : DefaultDateTime);
}
reader.Close();
return(oFormulario);
}
public List <eFormulario> GetList()
{
SqlCommand cmd = new SqlCommand("pCMS_Formulario_list");
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = ExecuteReader(cmd);
List <eFormulario> lista = new List <eFormulario>();
while (reader.Read())
{
eFormulario oFormulario = new eFormulario();
oFormulario.IdFormulario = reader.GetInt16(0);
oFormulario.Descripcion = reader.GetString(1);
oFormulario.Activo = reader.GetBoolean(2);
oFormulario.FechaRegistro = ((!reader[3].Equals(DBNull.Value)) ? reader.GetDateTime(3) : DefaultDateTime);
lista.Add(oFormulario);
}
reader.Close();
return(lista);
}
protected void Page_Load(object sender, EventArgs e)
{
IdFormulario = (Request["fID"] != null) ? Convert.ToInt16(Request["fID"]) : Convert.ToByte(0);
if (!Page.IsCallback && !Page.IsPostBack)
{
if (!SetPage(ModuloID))
{
return;
}
if (!validateUserAction(ModuloID, CMD_Listar))
{
return;
}
pnlForm.Attributes.Add("style", "display:none");
drpAsunto.Items.Add(new ListItem("Seleccionar", "0"));
List <eParametro> lAsunto = lCMS.Parametro_ListarWeb(1);
foreach (eParametro oAsunto in lAsunto)
{
drpAsunto.Items.Add(new ListItem(oAsunto.Nombre, oAsunto.IdParametro.ToString()));
}
eFormulario oFormulario = lFormulario.Formulario_item(IdFormulario);
drpAsunto.Visible = oFormulario.FiltrarAsunto;
txtSearch.Attributes.Add("placeholder", "nombres / apellidos / email");
txtFInicio.Text = DateTime.Now.AddDays(-((int)DateTime.Now.Day - 1)).ToShortDateString();
txtFFin.Text = DateTime.Now.ToShortDateString();
BindListado();
//btnAddNew.Enabled = validateUserAction(ModuloID, CMD_Administrar);
}
}
