/// <summary>
        /// Selects the by name and create.
        /// </summary>
        /// <param name="siteId">The site id.</param>
        /// <param name="name">The name.</param>
        /// <returns></returns>
        public tbl_ContactFunctionInCompany SelectByNameAndCreate(Guid siteId, string name)
        {
            var contactFunctionInCompany = SelectByName(siteId, name);

            if (contactFunctionInCompany == null)
            {
                contactFunctionInCompany = new tbl_ContactFunctionInCompany {
                    SiteID = siteId, Name = name
                };
                Add(contactFunctionInCompany);
            }
            return(contactFunctionInCompany);
        }
        /// <summary>
        /// Adds the specified contact function in company.
        /// </summary>
        /// <param name="contactFunctionInCompany">The contact function in company.</param>
        /// <returns></returns>
        public tbl_ContactFunctionInCompany Add(tbl_ContactFunctionInCompany contactFunctionInCompany)
        {
            if (contactFunctionInCompany.ID == Guid.Empty)
            {
                contactFunctionInCompany.ID = Guid.NewGuid();
            }

            _dataContext.tbl_ContactFunctionInCompany.AddObject(contactFunctionInCompany);

            _dataContext.SaveChanges();

            return(contactFunctionInCompany);
        }