protected void btnGrabar_Click(object sender, EventArgs e)
{
try
{
GrupoEnt ItemGuardar = new GrupoEnt();
GruposBus oGruposBus = new GruposBus();
ItemGuardar.psIDGrupo = txtIDGrupo.Text;
ItemGuardar.psNombreGrupo = rcGrupo.SelectedValue.ToString();
ItemGuardar.psIDNivelAcademico = rcNivelAcademico.SelectedValue.ToString();
ItemGuardar.psIDCiclo = rcCiclo.SelectedValue.ToString();
ItemGuardar.psIDGrado = rcGrado.SelectedValue.ToString();
if (oGruposBus.ValidaGrupoBus(ItemGuardar) == "1")
{
RadWindowManager1.RadAlert("El Grupo ya existe, verifique !!", 270, 150, "Mensaje", "refreshGrid", "../IMAGES/warning.png");
}
else
{
if (oGruposBus.fnRegistroGrupoBus(ItemGuardar) != "")
{
Response.Redirect("GruposLista.aspx?Token=" + CreaTokenPost());
}
}
}
catch (Exception ex)
{
Label2.Text = ex.Message;
}
}
public string ValidaGrupoBus(GrupoEnt GrupoItem)
{
return(oGrupoDat.ValidaGrupo(GrupoItem));
}
public string fnRegistroGrupoBus(GrupoEnt GrupoItem)
{
return(oGrupoDat.fnRegistroGrupoDat(GrupoItem));
}
public GrupoEnt ObtieneGruposDat(string Grupo)
{
GrupoEnt item = new GrupoEnt();
OleDbConnection dbConnection = null;
OleDbCommand dbCommand = null;
OleDbDataReader dbDataReader = null;
try
{
dbCommand = new OleDbCommand();
//dbConnection = new OleDbConnection(ConexionString.connStringIEL);
dbConnection = new OleDbConnection(constring);
dbCommand.Connection = dbConnection;
dbCommand.CommandText = "select * from Grupo where idGrupo = '" + Grupo + "'";
dbCommand.CommandType = CommandType.Text;
dbConnection.Open();
dbDataReader = dbCommand.ExecuteReader();
if (dbDataReader.HasRows)
{
while (dbDataReader.Read())
{
item.psIDNivelAcademico = dbDataReader["IDNivel"].ToString();
item.psIDGrado = dbDataReader["IDGrado"].ToString();
item.psIDCiclo = dbDataReader["IDCiclo"].ToString();
item.psIDGrupo = dbDataReader["NombreGrupo"].ToString();
}
}
dbCommand.Dispose();
dbCommand = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
dbDataReader.Close();
dbDataReader.Dispose();
dbDataReader = null;
}
catch (Exception oException)
{
if (dbCommand != null)
{
dbCommand.Dispose();
dbCommand = null;
}
if (dbConnection.State == ConnectionState.Open)
{
dbDataReader = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
}
else
{
dbDataReader = null;
dbConnection.Dispose();
dbConnection = null;
}
throw new Exception("Mensaje: DAT>GruposDat>ObtieneInformacionGrupo");
}
return(item);
}
public string ValidaGrupo(GrupoEnt item)
{
string sRespuesta = "";
OleDbConnection dbConnection = null;
OleDbCommand dbCommand = null;
OleDbDataReader dbDataReader = null;
try
{
dbCommand = new OleDbCommand();
//dbConnection = new OleDbConnection(ConexionString.connStringIEL);
dbConnection = new OleDbConnection(constring);
dbCommand.Connection = dbConnection;
dbCommand.CommandText = "SELECT * FROM GRUPO WHERE IDNIVEL=" + item.psIDNivelAcademico.ToString() +
" AND IDGRADO=" + item.psIDGrado.ToString() +
" AND IDCICLO=" + item.psIDCiclo.ToString() +
" AND NOMBREGRUPO='" + item.psNombreGrupo.ToString() + "'";
dbCommand.CommandType = CommandType.Text;
dbConnection.Open();
dbDataReader = dbCommand.ExecuteReader();
if (dbDataReader.HasRows)
{
sRespuesta = "1";
}
else
{
sRespuesta = "0";
}
// dbCommand.Dispose();
// dbCommand = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
// dbDataReader.Close();
//dbDataReader.Dispose();
// dbDataReader = null;
}
catch (Exception oException)
{
sRespuesta = "0";
if (dbCommand != null)
{
dbCommand.Dispose();
dbCommand = null;
}
if (dbConnection.State == ConnectionState.Open)
{
dbDataReader = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
}
else
{
dbDataReader = null;
dbConnection.Dispose();
dbConnection = null;
}
throw new Exception("Mensaje: DAT>GrupoDat>RegistraGrupoDat");
}
return(sRespuesta);
}
public string fnRegistroGrupoDat(GrupoEnt item)
{
string sRespuesta = "";
OleDbConnection dbConnection = null;
OleDbCommand dbCommand = null;
OleDbDataReader dbDataReader = null;
try
{
dbCommand = new OleDbCommand();
dbCommand.Parameters.Add("ID", OleDbType.VarChar).Value = item.psIDGrupo.ToString();
dbCommand.Parameters.Add("IDNIVEL", OleDbType.VarChar).Value = item.psIDNivelAcademico.ToString();
dbCommand.Parameters.Add("IDGRADO", OleDbType.VarChar).Value = item.psIDGrado.ToString();
dbCommand.Parameters.Add("IDCICLO", OleDbType.VarChar).Value = item.psIDCiclo.ToString();
dbCommand.Parameters.Add("NOMBREGRUPO", OleDbType.VarChar).Value = item.psNombreGrupo.ToString();
dbConnection = new OleDbConnection(constring);
//dbConnection = new OleDbConnection(ConexionString.connStringIEL);
dbCommand.Connection = dbConnection;
dbCommand.CommandText = "proc_Grupos";
dbCommand.CommandType = CommandType.StoredProcedure;
dbConnection.Open();
dbDataReader = dbCommand.ExecuteReader();
sRespuesta = "1";
dbCommand.Dispose();
dbCommand = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
dbDataReader.Close();
dbDataReader.Dispose();
dbDataReader = null;
}
catch (Exception oException)
{
sRespuesta = "";
if (dbCommand != null)
{
dbCommand.Dispose();
dbCommand = null;
}
if (dbConnection.State == ConnectionState.Open)
{
dbDataReader = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
}
else
{
dbDataReader = null;
dbConnection.Dispose();
dbConnection = null;
}
throw new Exception("Mensaje: DAT>GrupoDat>RegistraGrupoDat");
}
return(sRespuesta);
}
public List <GrupoEnt> ListaGruposDat()
{
List <GrupoEnt> oGruposLista = new List <GrupoEnt>();
OleDbConnection dbConnection = null;
OleDbCommand dbCommand = null;
OleDbDataReader dbDataReader = null;
try
{
dbCommand = new OleDbCommand();
//dbConnection = new OleDbConnection(ConexionString.connStringIEL);
dbConnection = new OleDbConnection(constring);
dbCommand.Connection = dbConnection;
dbCommand.CommandText = "SELECT G.idGRUPO,G.NOMBREGRUPO, GR.IDGrado, CASE G.IDNIVEL WHEN 0 THEN 'KINDER' WHEN 1 THEN 'PRIMARIA' WHEN 2 THEN 'MATERNAL' END AS NIVEL, " +
" GR.DESCRIPCIONGRADO, C.NOMBRECICLO, C.id FROM GRUPO G, GRADO GR , CICLO C WHERE G.IDNIVEL = GR.IDNivel AND G.IDGrado = GR.IDGrado AND C.id = G.IDCiclo";
dbCommand.CommandType = CommandType.Text;
dbConnection.Open();
dbDataReader = dbCommand.ExecuteReader();
if (dbDataReader.HasRows)
{
while (dbDataReader.Read())
{
GrupoEnt item = new GrupoEnt();
item.psIDGrupo = dbDataReader["idGrupo"].ToString();
item.psNombreCiclo = dbDataReader["NOMBRECICLO"].ToString();
item.psNombreGrupo = dbDataReader["NOMBREGRUPO"].ToString();
item.psNivelAcademico = dbDataReader["NIVEL"].ToString();
item.psGrado = dbDataReader["DESCRIPCIONGRADO"].ToString();
item.psIDGrado = dbDataReader["IDGrado"].ToString();
item.psIDCiclo = dbDataReader["id"].ToString();
oGruposLista.Add(item);
}
}
dbCommand.Dispose();
dbCommand = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
dbDataReader.Close();
dbDataReader.Dispose();
dbDataReader = null;
}
catch (Exception oException)
{
if (dbCommand != null)
{
dbCommand.Dispose();
dbCommand = null;
}
if (dbConnection.State == ConnectionState.Open)
{
dbDataReader = null;
dbConnection.Close();
dbConnection.Dispose();
dbConnection = null;
}
else
{
dbDataReader = null;
dbConnection.Dispose();
dbConnection = null;
}
throw new Exception("Mensaje: DAT>GruposDat>ListaGruposDat");
}
return(oGruposLista);
}
