public void Actualizar(SCE_CAMPO_BE BE) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CAMPO_UPD"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CAMPO", BE.ID_CAMPO); cmd.Parameters.AddWithValue("@NOM_CAMPO", BE.NOM_CAMPO); cmd.Parameters.AddWithValue("@ALIAS", BE.ALIAS); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void Insertar(SCE_CAMPO_BE BE) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CAMPO_INS"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NOM_CAMPO", BE.NOM_CAMPO); cmd.Parameters.AddWithValue("@ALIAS", BE.ALIAS); cmd.Parameters.AddWithValue("@RESTRINGIR", BE.RESTINGIR); cmd.Parameters.AddWithValue("@VALDIGITOS", BE.VALDIGITOS); cmd.Parameters.AddWithValue("@TIPO", BE.TIPO); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void Actualizar(int Id, string alias, string nombre) { try { BE = new SCE_CAMPO_BE(); BE.ID_CAMPO = Id; BE.ALIAS = alias; BE.NOM_CAMPO = nombre; DA.SCE_CAMPO_DA DA = new DA.SCE_CAMPO_DA(usrLogin); DA.Actualizar(BE); } catch (Exception ex) { throw ex; } }
public List <SCE_CAMPO_BE> Listar() { List <SCE_CAMPO_BE> lstBE = new List <SCE_CAMPO_BE>(); SCE_CAMPO_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CAMPO_SEL"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BE = new SCE_CAMPO_BE(); BE.ID_CAMPO = Convert.ToInt32(reader["ID_CAMPO"]); BE.ALIAS = Convert.ToString(reader["ALIAS"]); BE.NOM_CAMPO = Convert.ToString(reader["NOM_CAMPO"]); BE.FLAGPERTENECE = Convert.ToInt32(reader["FLAGPERTENECE"]); BE.TIPO = Convert.ToString(reader["TIPO"]); BE.RESTINGIR = Convert.ToString(reader["RESTINGIR"]); BE.VALDIGITOS = Convert.ToString(reader["VALIDAR"]); lstBE.Add(BE); } return(lstBE); } } } catch (Exception ex) { throw ex; } }
public void Insertar(string alias, string nombre, string restringir, string valDigitos, string tipo) { try { BE = new SCE_CAMPO_BE(); BE.ALIAS = alias; BE.NOM_CAMPO = nombre; BE.RESTINGIR = restringir; BE.VALDIGITOS = valDigitos; BE.TIPO = tipo; DA.SCE_CAMPO_DA DA = new DA.SCE_CAMPO_DA(usrLogin); DA.Insertar(BE); } catch (Exception ex) { throw ex; } }
public SCE_CAMPO_BE ObtenerPorID(int Id) { SCE_CAMPO_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CAMPO_GET"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CAMPO", Id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { BE = new SCE_CAMPO_BE(); BE.ID_CAMPO = Convert.ToInt32(reader["ID_CAMPO"]); BE.ALIAS = Convert.ToString(reader["ALIAS"]); BE.NOM_CAMPO = Convert.ToString(reader["NOM_CAMPO"]); } return(BE); } } } catch (Exception ex) { throw ex; } }