public string mantenercategoria(TecnologiaCE tec, string accion) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_mantenimientocategoria"; cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@codcat", SqlDbType.VarChar, 3).Value = tec.getCodcat(); cmd.Parameters.Add("@descat", SqlDbType.VarChar, 100).Value = tec.getDescat(); cmd.Parameters.Add("@detalle", SqlDbType.VarChar, 200).Value = tec.getDetalle(); cmd.Parameters.Add("@accion", SqlDbType.Char, 1).Value = accion; try { cn.Open(); cmd.ExecuteNonQuery(); return("exito"); } catch (Exception e) { return("Error" + e.ToString()); } finally { cmd.Dispose(); cn.Close(); } }
public string mantenercategoria(TecnologiaCE tec, string accion) { return(tecnologiadao.mantenercategoria(tec, accion)); }