public string Delete(CategoryData Category) { string res = ""; SqlConnection SqlCon = new SqlConnection(); try { // Connection SqlCon.ConnectionString = Connection.Con; SqlCon.Open(); // Comand SqlCommand SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlCon; SqlCmd.CommandText = "peliminar_categoria"; SqlCmd.CommandType = CommandType.StoredProcedure; // Parameters SqlParameter ParId = new SqlParameter(); ParId.ParameterName = "@id_categoria"; ParId.SqlDbType = SqlDbType.Int; ParId.Value = Category.IdCategory; SqlCmd.Parameters.Add(ParId); // Execute res = SqlCmd.ExecuteNonQuery() == 1 ? "Correcto" : "No se ha podido eliminar el registro"; } catch (Exception e) { res = e.Message; } finally { // Close connection if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return(res); }
public DataTable FindByName(CategoryData Category) { DataTable DataTableRes = new DataTable("categoria"); SqlConnection SqlCon = new SqlConnection(); try { SqlCon.ConnectionString = Connection.Con; SqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlCon; SqlCmd.CommandText = "pbuscarnombre_categoria"; SqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter ParTextCat = new SqlParameter(); ParTextCat.ParameterName = "@nombre"; ParTextCat.SqlDbType = SqlDbType.VarChar; ParTextCat.Size = 50; ParTextCat.Value = Category.FindText; SqlCmd.Parameters.Add(ParTextCat); SqlDataAdapter SqlAdapter = new SqlDataAdapter(SqlCmd); SqlAdapter.Fill(DataTableRes); } catch (Exception e) { DataTableRes = null; Console.WriteLine(e); } finally { if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return(DataTableRes); }