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