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