public Telefone(TipoTel tipoTelefone, string codTel, string pais, string area, string numero)
{
TipoTelefone = tipoTelefone;
CodTel = codTel;
Pais = pais;
Area = area;
Numero = numero;
}
public List<TipoTel> CargaTipoTel()
{
List<TipoTel> tipotel = new List<TipoTel>();
sqlDataAdapter.SelectCommand = new SqlCommand();
sqlDataAdapter.SelectCommand.Connection = sqlConnectionWeb;
sqlDataAdapter.SelectCommand.CommandText = "ConsultaTipoTel";
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.Fill(ds, "ConsultaTipoTel");
foreach (DataRow dr in ds.Tables["ConsultaTipoTel"].Rows)
{
TipoTel tmp = new TipoTel();
tmp.Id = Convert.ToString(dr["Id_Tipo_Tel"]);
tmp.Name = Convert.ToString(dr["Tipo_Tel"]);
tipotel.Add(tmp);
}
return tipotel;
}
