public void Insert(long dealerId)
        {
            DBAccess.ExecuteNonQuery("INSERT INTO Contact (Surname, Name, Patronymic, Position, DealerId) VALUES (@param1, @param2, @param3, @param4, @param5)", Surname, Name, Patronymic, Position, dealerId);
            long contactId = DBAccess.ExecuteScalar <long>("SELECT MAX(Id) FROM Contact");

            Phones.ForEach(x => x.Insert(contactId));
            Faxes.ForEach(x => x.Insert(contactId));
            Emails.ForEach(x => x.Insert(contactId));
        }
Exemple #2
0
        /// <summary>
        /// Metodo para listar os faxes ordenando do mais antigo ao mais recente
        /// </summary>
        /// <returns>IList</returns>
        private IList <Fax> listarFaxesAsc()
        {
            User user = userService.OrigemFaxBox;


            if (user != null)
            {
                Faxes faxes = user.Faxes;

                SortedList <DateTime, Fax> listaFax = new SortedList <DateTime, Fax>();

                foreach (Fax fax in faxes)
                {
                    if (fax.IsReceived == BoolType.True && fax.FaxStatus == FaxStatusType.fsDoneOK && fax.Folder.ID.ToUpper().Equals("MAIN"))
                    {
                        listaFax.Add(fax.FaxRecordDateTime, fax);
                    }
                }

                return(listaFax.Values);
            }
            return(null);
        }
Exemple #3
0
        public void FaxTest()
        {
            Faxes fax = new Faxes(9);

            Assert.AreEqual(9, fax.NumberOfFaxes);
        }