private void AddLocalEmployeeToCorpDB(string employeeName)
{
using (SqlConnection conn = SQLAzureUtilities.GetActiveSqlConnection())
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "AddEmployee";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter tenant = cmd.Parameters.Add("@Tenant", SqlDbType.NVarChar);
tenant.Value = spContext.SPHostUrl.ToString();
SqlParameter name = cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 50);
name.Value = employeeName;
cmd.ExecuteNonQuery();
}
}