public void CreateOfficeDepartment(DepartmentToUser departmentToUser)
        {
            using (MySqlConnection db = new MySqlConnection(ConfigurationValues.GroveHillConnection))
            {
                departmentToUser.UniqueID = Guid.NewGuid().ToString();

                try
                {
                    const string query = "insert into officenames(UniqueID,Name,Department)"
                        + " values(@UniqueID,@Name,@Department)";
                    int rowsAffectd = db.Execute(query, new
                    {
                        @UniqueID = departmentToUser.UniqueID,
                        @Name = departmentToUser.Name,
                        @Department = departmentToUser.Department
                    });
                }
                catch (Exception er)
                {
                  EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
                  EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
                }
            }
        }
 // GET: api/AddDepartmentTo
 public IEnumerable<string> Get(DepartmentToUser departmentToUser)
 {
     return new string[] { "value1", "value2" };
 }