public DataTable listProfessions(DTOProfession profession) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "prc_ListarProfesiones"; DataTable data = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(cmd); con.Open(); sda.Fill(data); con.Close(); return(data); }
public int deleteProfession(DTOProfession profession) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "prc_EliminarProfesion"; cmd.Parameters.AddWithValue("@cod_prof", profession.Profession_Code); try { con.Open(); cmd.ExecuteNonQuery(); return(1); } catch (Exception ex) { Console.WriteLine("Error" + ex.Message); con.Close(); return(0); } }