public List <eAreas> xClave(int pId) { List <eAreas> lst = new List <eAreas>(); using (IDbConnection connection = database.CreateOpenConnection()) { using (IDbCommand command = database.CreateStoredProcCommand("xClaveArea", connection)) { command.Parameters.Add(database.CreateParameter("@pId", pId)); using (IDataReader dr = command.ExecuteReader()) { while (dr.Read()) { eAreas a = new eAreas(); a.IdPadre = int.Parse(dr["ID_PADRE"].ToString()); a.Id = int.Parse(dr["ID"].ToString()); a.Clave = dr["CLAVE"].ToString(); a.Siglas = dr["SIGLAS"].ToString(); a.Descripcion = dr["DESCRIPCION"].ToString(); a.Nivel = int.Parse(dr["NIVEL"].ToString()); a.Ruta = dr["RUTA"].ToString(); a.Ruta_Texto = dr["RUTA_TEXTO"].ToString(); lst.Add(a); } } } } return(lst); }
public void Nueva(eAreas area) { using (IDbConnection connection = database.CreateOpenConnection()) { using (IDbCommand command = database.CreateStoredProcCommand("insArea", connection)) { command.Parameters.Add(database.CreateParameter("@pIdPadre", area.IdPadre)); command.Parameters.Add(database.CreateParameter("@pClave", area.Clave)); command.Parameters.Add(database.CreateParameter("@pSiglas", area.Siglas)); command.Parameters.Add(database.CreateParameter("@pDescripcion", area.Descripcion)); command.Parameters.Add(database.CreateParameter("@pNivel", area.Nivel)); command.Parameters.Add(database.CreateParameter("@pRuta", area.Ruta)); command.Parameters.Add(database.CreateParameter("@pRuta_Texto", area.Ruta_Texto)); command.ExecuteNonQuery(); } } }