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