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