public short Minisite_add(eMinisite oMinisite) { short addNew = 0; IdException = cMinisite.Insert(oMinisite); if (IdException == 0) { addNew = Convert.ToInt16(cMinisite.getLastID); } return(addNew); }
private void FillDetalle(short MinisiteID) { ClearFormDetalle(); eMinisite _oMinisite = lCMS.Minisite_item(MinisiteID); if (_oMinisite != null) { txtDescripcion.Text = _oMinisite.Descripcion; txtAlias.Text = _oMinisite.Alias; chkActivo.Checked = _oMinisite.Activo; } }
public int Insert(eMinisite oMinisite) { SqlCommand cmd = new SqlCommand("pCMS_Minisite_insert"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Descripcion", SqlDbType.VarChar, 255).Value = oMinisite.Descripcion; cmd.Parameters.Add("@Alias", SqlDbType.VarChar, 255).Value = oMinisite.Alias; cmd.Parameters.Add("@Activo", SqlDbType.TinyInt).Value = oMinisite.Activo; return(InsertCommand(cmd, true)); }
public int Update(eMinisite oMinisite) { SqlCommand cmd = new SqlCommand("pCMS_Minisite_update"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdMinisite", SqlDbType.BigInt).Value = oMinisite.IdMinisite; cmd.Parameters.Add("@Descripcion", SqlDbType.VarChar, 255).Value = oMinisite.Descripcion; cmd.Parameters.Add("@Alias", SqlDbType.VarChar, 255).Value = oMinisite.Alias; cmd.Parameters.Add("@Activo", SqlDbType.TinyInt).Value = oMinisite.Activo; return(UpdateCommand(cmd)); }
public eMinisite GetItem(short IdMinisite) { SqlCommand cmd = new SqlCommand("pCMS_Minisite_select"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdMinisite", SqlDbType.SmallInt).Value = IdMinisite; SqlDataReader reader = ExecuteReader(cmd); eMinisite oMinisite = null; if (reader.Read()) { oMinisite = new eMinisite(); oMinisite.IdMinisite = reader.GetInt16(0); oMinisite.Descripcion = reader.GetString(1); oMinisite.Alias = reader.GetString(2); oMinisite.Activo = reader.GetBoolean(3); } reader.Close(); return(oMinisite); }
protected void btnSave_Click(object sender, EventArgs e) { if (!validateUserAction(ModuloID, CMD_Administrar)) { return; } eMinisite _oMinisite = new eMinisite(); bool success = false; _oMinisite.Descripcion = this.txtDescripcion.Text; _oMinisite.Alias = this.txtAlias.Text; _oMinisite.Activo = Convert.ToBoolean(this.chkActivo.Checked); if (grvListado.SelectedIndex >= 0) { _oMinisite.IdMinisite = Convert.ToInt16(grvListado.SelectedDataKey.Value); success = lCMS.Minisite_edit(_oMinisite); RegistrarLog(ModuloID, CMD_Administrar, "Se ha actualizado el Minisite: " + _oMinisite.IdMinisite.ToString()); } else { _oMinisite.IdMinisite = lCMS.Minisite_add(_oMinisite); success = (_oMinisite.IdMinisite > 0); RegistrarLog(ModuloID, CMD_Administrar, "Se ha insertado un Nuevo Minisite: " + _oMinisite.IdMinisite.ToString()); } if (success) { modDetalle.Hide(); BindListado(); } else { lblFormError.Text = lCMS.getErrorMessage(); } }
public List <eMinisite> GetList_Activo() { SqlCommand cmd = new SqlCommand("pCMS_MinisiteActivo_list"); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = ExecuteReader(cmd); List <eMinisite> lista = new List <eMinisite>(); while (reader.Read()) { eMinisite oMinisite = new eMinisite(); oMinisite.IdMinisite = reader.GetInt16(0); oMinisite.Descripcion = reader.GetString(1); oMinisite.Alias = reader.GetString(2); oMinisite.Activo = reader.GetBoolean(3); lista.Add(oMinisite); } reader.Close(); return(lista); }
public bool Minisite_edit(eMinisite oMinisite) { IdException = cMinisite.Update(oMinisite); return(IdException == 0); }