public List <TelefoneBE> SelectList(String IdContato) { { List <SqlParameter> lstPar = new List <SqlParameter>(); StringBuilder Query = new StringBuilder(); Query.AppendFormat("SELECT IdTelefone, IdContato, TipoTelefone, UsoTelefone, NumTelefone FROM Telefone WHERE IdContato = '{0}'", IdContato); DataTable tB = Conn.ExecSql_DataTable(Query.ToString()); List <TelefoneBE> objList = new List <TelefoneBE>(); foreach (DataRow rw in tB.Rows) { TelefoneBE obj = new TelefoneBE(); obj.IdTelefone = rw["IdTelefone"].ToString(); obj.IdContato = rw["IdContato"].ToString(); obj.TipoTelefone = rw["TipoTelefone"].ToString(); obj.UsoTelefone = rw["UsoTelefone"].ToString(); obj.NumTelefone = rw["NumTelefone"].ToString(); objList.Add(obj); } return(objList); } }
public TelefoneBE Insert_Update(TelefoneBE obj_list) { { List <SqlParameter> lstPar = new List <SqlParameter>(); obj_list.IdTelefone = (obj_list.IdTelefone == "0" ? Guid.NewGuid().ToString() : obj_list.IdTelefone); lstPar.Add(new SqlParameter("@IdTelefone", obj_list.IdTelefone)); lstPar.Add(new SqlParameter("@IdContato", obj_list.IdContato ?? "")); lstPar.Add(new SqlParameter("@TipoTelefone", obj_list.TipoTelefone ?? "")); lstPar.Add(new SqlParameter("@UsoTelefone", obj_list.UsoTelefone ?? "")); lstPar.Add(new SqlParameter("@NumTelefone", obj_list.NumTelefone ?? "")); Conn.ExecSp("Telefone_Insert_Update", lstPar); return(obj_list); } }