Exemple #1
0
        public BE_ResGenerico ExecInsUpdConstante(BE_ReqInsUpdConstante Request)
        {
            BE_ResGenerico Item      = new BE_ResGenerico();
            long           Resultado = 0;

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");

                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "[usp_InsUpd_Contante]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("flag", Request.flag);
                        cm.Parameters.AddWithValue("nConCodigo", Request.nConCodigo);
                        cm.Parameters.AddWithValue("cConDescripcion", Request.cConDescripcion);
                        cm.Parameters.AddWithValue("nConValor", Request.nConValor);
                        cm.Connection  = cn;
                        Resultado      = cm.ExecuteNonQuery();
                        Item.Resultado = Resultado;
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(Item);
        }
Exemple #2
0
        //Store Procedure para Constante (Insert y Update)
        public BE_ResGenerico ExecInsUpdConstante(BE_ReqInsUpdConstante Request)
        {
            DAConstante    Obj  = new DAConstante();
            BE_ResGenerico Item = new BE_ResGenerico();

            Item = Obj.ExecInsUpdConstante(Request);
            return(Item);
        }